|
POST
|
Totally agree Joe. What I do now with the fallout is go through the list and check if address assignment has the address in their system. If address assignment has it in their system, I add it to the map.If they don't have it, I mark it on my spreadsheet. Once I have gone through the spreadsheet I will provide it to them and they can check/research if the marked addresses are valid.
... View more
02-24-2017
07:29 AM
|
1
|
0
|
503
|
|
POST
|
This week I have received an excel spreadsheet of all the phone numbers from our MSAG provider. We can request one of these once a year for free. Each phone number has an address attached to it. Here are the steps I came up with to compare it to our GIS address point layer. 1) Create a field in the phone number spreadsheet called FULL ADDRESS. 2) Use the excel concatenate function to populate the FULL ADDRESS field. Don't forget to include TRIM to remove extra spaces.The function will look similar to this: =TRIM(CONCATENATE(B2," ",C2," ",D2," ",E2," ",F2)) 3) Now you will have a field that shows the full address that looks like this: 4660 N HIGHWAY 1 PALM SHORES 4) Select the FULL ADDRESS column, go to DATA on the ribbon and click "Remove Duplicates". In the window click on Expand the selection and then only put a check mark in your FULL ADDRESS field. 5) This leaves us with all unique address values in the phone number list. 6) Export your Address Point GIS data in to an excel spreadsheet. 7) If you dont have a FULL ADDRESS field in your GIS data yet, create it in your Excel spreadsheet just like in step 2. IMPORTANT it needs to have the same name as in your MSAG spreadsheet. 8)Go to your MSAG spreadsheet and copy the FULL ADDRESS coulumn. 9) Go to your GIS spreadsheet and go to the last entry in your FULL ADDRESS column. Below this entry paste wha you have copied from your MSAG spreadsheet. 10) Now repeat step 4, which should eliminate all MSAG addresses that you have in GIS. 11) Anything below the last GIS entry will be addresses that you are missing in your GIS address point layer. Hope this helps! Tim
... View more
02-24-2017
05:19 AM
|
0
|
3
|
3214
|
|
POST
|
Once you have done your edits, I would export it as a shapefile and then upload it (zip the shapefile first) into ArcGIS Online. I don't think CSV files work for polygons?
... View more
02-15-2017
06:17 AM
|
1
|
1
|
1589
|
|
POST
|
Michael thanks for the help. What I will end up doing is create a DATE field and a TIME field and then write an expression for my DateUpdate field looking like this: [DATE] & "T" & [TIME] & "-05:00"
... View more
02-07-2017
11:43 AM
|
1
|
0
|
858
|
|
POST
|
Row Info Row Number 20 TableName: * FieldName: DateUpdate ValueInfo: DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") ValueMethod: EXPRESSION On Create: 1 On Change: 1 Checking for Subtype Restriction Field Name: DateUpdate was found at index: 68 Trying: EXPRESSION Checking to verify there is a field to store the expression Expression to be eval: DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") ERROR: evaluating the expression for feature in Brevard_Nena_Street with OID of 42394 Object required: 'DateTime' Finished: EXPRESSION
... View more
02-07-2017
10:42 AM
|
0
|
3
|
858
|
|
POST
|
Joe, I tried that earlier but it didn't work. Maybe I was using it wrong? I even tried that in the field calculator and it didn't work. Thanks for posting though!
... View more
02-07-2017
09:54 AM
|
0
|
5
|
2326
|
|
POST
|
Hey mmiller-esristaff thanks for the reply! So I would have to create the Field, in which I want the timestamp to go as a string field. Then I would use the Expression method for that field to fill in the timestamp? Could you post a basic example of the DateTime.Now.ToString I would have to use? From there I can probably figure it out myself. Thanks! Tim
... View more
02-07-2017
06:57 AM
|
0
|
7
|
2326
|
|
POST
|
I pulled the decimal from their Date Field description: D – Date and Time fields are as defined by the International Organization for Standardization (ISO) 8601 standard and are a NENA requirement. Date and time use ISO 8601 compliant formats which are in the format of YYYY-MM-DDThh:mm:ss.sTZD and conform to a TimeStamp as defined in NENA-STA-010 [1] , which in turn conforms to W3C dateTime format. Example: 2014-02-20T23:16:45.7-05:00 744 2014 = the Year 02 = the Month 20 = the Day NENA Standard for NG9-1-1 GIS Data Model NENA-STA-006.1-201X, Month Day, Year [MM/DD/YYYY] Page 29 of 86 23 = the Hour 16 = the Minute 45.7 = the Seconds and decimal fraction of seconds –05:00= the Offset from UTC Note: The Offset from Coordinated Universal Time (UTC) is the optional separator to indicate the time zone designation, which in this example is -5:00 to indicate the local Eastern Standard Time (EST) time difference from UTC. I'll have to check out editor tracker!
... View more
02-07-2017
05:04 AM
|
0
|
9
|
2326
|
|
POST
|
I know it is crazy, I am just looking through the upcoming NENA standards This is what I am talking about: 1403 5.37 Date Updated 1404 Description: The UTC date and time that the record was created or last modified. This 1405 value SHOULD be populated upon modifications to attributes, geometry, or both. 1406 Domain: Restricted to ISO 8601 compliant values in Coordinated Universal Time (UTC). 1407 Values are not allowed to be in the future. 1408 Example: 2010-12-19T20:01:29-05 (representing a record updated on December 19, 2010 1409 at 8:01 and 29 seconds PM US Eastern Standard Time)
... View more
02-06-2017
01:22 PM
|
0
|
11
|
2326
|
|
POST
|
Hey everybody, I am trying to get my timestamp in a certain format: YYYY-MM-DDThh:mm:ss.s but I am not able to do it. As an example it needs to look like this: 2017-02-20T23:16:45.7 Is this even possible? If so, what would be the expression I need? Thanks, Tim
... View more
02-06-2017
09:51 AM
|
0
|
13
|
3973
|
|
POST
|
This might help: Shapefiles—ArcGIS Online Help | ArcGIS
... View more
02-03-2017
09:45 AM
|
1
|
0
|
728
|
|
POST
|
Ana, when you go to your organization settings under security did you check the Allow anonymous access to your organization's website. settings? Tim
... View more
01-19-2017
06:25 AM
|
1
|
1
|
7663
|
|
POST
|
The size property does work, but I think SVG items have a set size that can't be changed within your SimpleMarkerSymobols.
... View more
01-12-2017
07:17 AM
|
0
|
2
|
2308
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 07-06-2015 06:58 AM | |
| 1 | 05-04-2016 07:27 AM | |
| 1 | 07-06-2017 08:12 AM | |
| 1 | 10-26-2015 11:51 AM | |
| 1 | 12-12-2014 12:05 PM |
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:23 AM
|