Latest Contributions by JoshSaad1

In my road centerline features I'm trying to calculate the neighborhood names in the left and right sides of each road segment based on the neighborhood.  To indicate which side to check, I'm including an Offset function to calculate the neighborhood name that intersects 1-foot on either side of the line.  I'm also performing this in a file geodatabase.  Here is my script: var fsNbrhd = FeatureSetByName($datastore, 'Neighborhood', ['Nbrhd_Comm'], true) var RoadLeft = Offset($feature, -1, 'us-feet', 'square') var fsNbrhdLeft = Intersects(fsNbrhd, RoadLeft) var NbrhdLeft = First(fsNbrhdLeft) if (IsEmpty(Geometry(NbrhdLeft))) return else if(NbrhdLeft == null) return null else return NbrhdLeft.Nbrhd_Comm I keep getting an error on line 4, "Search geometry cannot be null".  However, if I change the variable on line 3 to the line itself instead of the offset: var fsNbrhdLeft = Intersects(fsNbrhd, $feature) I don't get the error, and it just calculates whatever polygon my line intersects.  I think the problem might be with the Offset function. I also tried adding error messages in the script to help identify the problem: var fsNbrhd = FeatureSetByName($datastore, 'Neighborhood', ['Nbrhd_Comm'], true) if (IsEmpty(Geometry(fsNbrhd))) return "error0" var RoadLeft = Offset($feature, -1, 'us-feet', 'square') if (IsEmpty(Geometry(RoadLeft))) return "error1" var fsNbrhdLeft = Intersects(fsNbrhd, RoadLeft) if (IsEmpty(Geometry(fsNbrhdLeft))) return "error2" var NbrhdLeft = First(fsNbrhdLeft) if (IsEmpty(Geometry(NbrhdLeft))) return "error3" if(NbrhdLeft == null) return null return NbrhdLeft.Nbrhd_Comm When running this, all of the features returned "error0", indicating null geometry in my Neighborhood layer, but it seems to be drawing on the map with no problem, and it calculates fine if I ignore the offset and just calculate whatever intersects the line. Has anyone else experienced this, or can help identify the problem? Thanks, ... View more

I created a simple database view to summarize our site address data in a MSAG-like format.  Basically, it's a list of our road names with the high and low addresses for each, that's grouped by road.  Here's the code: SELECT fullname as "Full Road Name", count(fullname) as "# of Addresses", Min(Cast(addrnum as double precision)) as "Low Address", Max(Cast(addrnum as double precision)) as "High Address", Format(last_edited_date,'d', 'en-US') as "Date Edited" FROM [GIS].[dbo].[SiteAddressPoint_evw] Group By fullname, last_edited_date Order By fullname; I'd like to publish the table to our Open Data Hub so that people can query it or download it on their own. Since the data is summarized, I don't have an Object ID field or another type of unique identifier, so I can't add it to a map or register it with our Enterprise Geodatabase. Does anyone know if there's a workaround or a solution that would allow me to do this?  I tried including the ObjectID in the query, but that creates rows for each address and undoes the grouping. ... View more

Does anyone know how to manage feature templates in the new web map?  In Classic, when editing you could click the Manage button at the bottom of the edit pane to modify the feature template, but I don't see how to do that in the new web map. I found this documentation: Manage feature templates—ArcGIS Online Help | Documentation, but the new web map is specifically omitted. I've got a feature template where only a fraction of the features are available when editing and I'd like to add the rest but can't seem to find where to do that. ... View more