Latest Contributions by LorindaGilbert

Hi, We have data on in our hub that was uploaded in FL State Plane East Ft projection.  I know that when you use the map on AGOL that it is Mercator in Lat Long.  When downloading the data as a csv, the polyline length is not matching up to the length in our data with any conversion of types.   I need to be able to tell someone that has downloaded this data what the length of the polyline represents, but it's difficult when the length of the line is 285.334 ft, translates to 0.0869 km and the length in the csv file is 0.0008124. If anyone can point me in the right direction for the projection that would be great. Thanks, Lorinda   ... View more

Hi, Have recently upgraded to 10.8.2 (and database is now 10.9.1) and as a result have needed to recreate all of our geocoders.  We have 6 that are part of a composite.  In the previous version, 10.3.1 rebuilt with often with 10.6.1, the composite would show all points that were geocoded. The newest version, shows that 98% of the rows were geocoded (263K of 264K) and they have have x,y coordinates in the rows.  However, only 78K show as points in the data that is written to the file geodatabase.  Where are the rest, what universe? The ones that show have point z as the shape/geometry.  We aren't using z values.  I've made sure that the projection is the one that we use, have disabled the z value and it still comes up with point z and only one of the parts of the composite is represented (the second one).  All rows say that they are point z. I have found that if I export the the attribute table and then import it to the mxd, show x,y event layer, that the points are there.  But this is not something that should be done. Any hints on what is going on?  I do not want to do these in ArcPro as the rest of our staff is not ready to make that leap as of yet, they need to still work in ArcMap for another year or two. Thanks, Lorinda ... View more

Hello, We have several views in a separate SQL Server enterprise database that we are using to map points in our enterprise geodatabase(s) for different types of data.  We are copying the data from the views into our EGDB as a static feature class with points created and selected columns (due to ESRI not playing nice and efficiently with using data across networks and servers). Our question is: should we bring the entire view (table) over and use definition queries in the mxd (project) to publish map layers or should we use sql to create individual tables to be brought in to the mxd (project) before publishing the map layers?  Is there a cost or benefit (space, time, messiness, etc) to either way?  This process will be run automatically on at least a nightly basis, possibly twice a day when decided. Thanks, Lorinda ... View more

Hi, I'm attempting to create a data expression from a published dataset on our site in ArcGIS Online using the FeatureSetByPortalItem function.  The data has not been shared as of yet due to just starting the build out of the dashboard.  I can't seem to find the proper syntax for accessing this data, the instructions say that the portal is "https:\\www.arcgis.com", our site on AGOL is prefaced as "org.maps.arcgis.com".  When I attempt to look at the rest services (which it is only a feature layer rather than a map service or feature service), I get that a token is required.  I did find the full URL for this one with the Token, so am able to see the listing of the layer IDs (only one).  Putting in the org.maps.arcgis.com, I get that it failed to fetch.  I was able to create an expression using data from the living atlas, however, it isn't the data that I want to use.   EDITED TO UPDATE:  just testing various combinations, I was able to use www.arcgis.com as the portal and the itemID and layer ID, it started working and gave me the list of the data in the feature set.  Not sure if there was a wait time or what.  Now to add the calculations that are required for some data coming out of this feature set. Thanks, Lorinda ... View more

Hi, Have a table with a related table that I'd like to sort the related table in descending order (as the latest data is the most important).  It is sorting in ascending order.  Has anyone been able to actually get the data to sort descending?  This is a character field for the year.  Hopefully by doing this in ArcPro it will follow thru to the web app that is also using the same data. Thanks, Lorinda ... View more

Hi All, We're looking to create a new grid for mapping use.  Wanted to know if anyone has used the grid index creation tools to create one that would radiate out from a central location, i.e. if you were to look at the x,y coordinates and see x running right, -x running left, y running up, -y running down.  Our addresses originate at a central intersection in the city and we'd like to recreate a new grid system for mapping using the central location as the origin for the map series. I have some ideas on how to accomplish this manually, but wanted to see if it could be done thru geoprocessing. Thanks, Lorinda ... View more