Latest Contributions by JoshSaad1

‎08-29-2024

I thought I had a solution, but I couldn't get it to register with the geodatabase. I used: Row_Number() Over(Order By fullname) as "ObjectID" But I didn't think to cast it as an integer. So after I saw your post I updated it to Cast(Row_Number() Over(Order By fullname) as Int) as "ObjectID" and that totally word. Thanks!

‎08-28-2024

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.

‎06-10-2024

There are some online courses that Esri offers that can help you get started using ArcGIS Pro: ArcGIS Pro Fundamentals | Learning Plan (esri.com). Here are some tutorials on how to use Model Builder to automate your work: Work with Iterate Feature Classes—ArcGIS Pro | Documentation.

‎06-10-2024

I recommend managing your local data in a geodatabase, and that it uses the OneSoltuion CAD data schema. You can automate importing and transforming the shapefiles from your other agencies into the geodatabase using a geoprocessing model. And, if it's already in the OneSoltuion schema, you can just export to shapefiles to convert to CAD without additional transformation. Geodatabases offer functionality that makes managing the data much easier, like versioning and archiving. You can use either an Enterprise geodatabase in SQL, or store one (or more) locally as a file geodatabase, depending on whether you'll have multiple people editing the data simultaneously. It still sounds tricky determining which features to use for CAD if you'll be editing the data outside of the authoritative sources. You could add a 'source' field to the data that identifies which is which, and use some logic in the data export to determine which features to use.

‎06-10-2024

How do you manage your GIS data? You mentioned converting DBF files. Do you keep your data in shapefiles or a geodatabase?

‎05-30-2024

We have a few weather stations that output real-time data to JSON hosted in a CDN. I'd like to add this to ArcGIS Online, but it's not GeoJSON. I'm not quite sure why you can add GeoJSON, but not JSON. I've only found two ways to get my data into AGOL. The first is to purchase ArcGIS Velocity, which has no problem processing the feed but is exorbitantly expensive. The other is to use Data Pipelines, but that only updates at most once an hour and costs service credits to update. Is there any other way that I can use my real-time data in ArcGIS Online? I'd love to be able to add it to a dashboard to view real-time weather conditions.

‎03-01-2024

I just figured this out the other day. You can use the Offset function in Arcade. Here's the code that I use to calculate the neighborhood on the left-side of a road segment. //Set the neighborhood dataset, selecting only the neighborhood name field. var fsNbrhd = FeatureSetByName($datastore, "GIS.DBO.Neighborhood", ["nbrhdname"]) //Specifies the left-side of the road. If the offset is greater than 0, it will be the right-side. var RoadLeft = offset($feature, -1, 'feet', 'square') //Selects the neighborhood polygon on the left-side of the road. var fsNbrhdLeft = Intersects(fsNbrhd, RoadLeft) //Returns only the first intersecting polygon, in case there are overlaps. var NbrhdLeft = First(fsNbrhdLeft) if(NbrhdLeft == null) return null //Returns the name of the first intersecting neighborhood polygon on the left-side of the road segment. return NbrhdLeft.nbrhdname

‎03-01-2024

I just tested using the Export Features tool, and it exported without the attribute rules. Thanks! 👍

‎02-05-2024

I think I might have had the wrong idea of what you could do with ArcGIS for SharePoint. I was hoping you could create a SharePoint list item using an interactive map, using SharePoint as a way of editing the item's attributes in the list view. Each list item would be a map feature. Like, create a new list item, then have an interactive map in the input form where you could draw a polygon or drop a point while entering the attributes in the form fields, and view and edit the list of features in the SharePoint list. Is that possible? The documentation makes it seem like you really just geo-tag existing items with existing features on a map.

‎01-23-2024

I'll try that. Thank you

‎01-23-2024

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.

‎01-11-2024

Yeah, I've had cases with them that have been open for years before finding a resolution. It's bad enough their mapping platform came from the late 90's. You might have to escalate the case to get any progress.

‎01-08-2024

If this is a new area you'll have to check the layer display settings in MapSet to include it. To do so, in MapSet, add the layer to your map. Then, click Options > Layer Display Settings. In the Layer Display Settings Window, click the Polygon tab, then click the Select button under Color Classify. You can verify the colors here. I usually click Apply Random Colors. If that doesn't work, you might have to call Central Square support. MapSet is so awful I usually have to anyway.

‎06-21-2023

I'm setting up a gauge to track the wind speed of a storm. I set custom color-coded guides based on wind speed that correspond to whether the storm is a Tropical Storm, Strong Tropical Storm, Category 1, Category 2, Category 3, Category 4, and Category 5. However, there doesn't seem to be a way to label the guides; so the viewer would have to count the rings to determine what the value represents. It would be great if there was an option to create custom guide label text instead of numeric values. Also, the increment level options are either Automatic or to specify a custom increment, but it would be great if your increment values could match your guides. Thanks.

‎05-31-2023

Thanks, but I haven't found any documentation that says where the toolbox would be located if it's not loading in the default suite of toolboxes. I might just have to call Esri support on this.

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by JoshSaad1

Re: Register with Geodatabase but No Object ID

Register with Geodatabase but No Object ID

Re: Need help with One Solution CAD to ARC GIS PRO conversion and back.

Re: Need help with One Solution CAD to ARC GIS PRO conversion and back.

Re: Need help with One Solution CAD to ARC GIS PRO conversion and back.

Is it possible to use real-time JSON data in ArcGIS Online?

Re: Identify a polygon to the right or left of a line

Re: Add option to delete attribute rules when exporting feature classes

Create SharePoint list item with geometry?

Re: Unable to Modify Feature Templates in Web Map

Unable to Modify Feature Templates in Web Map

Re: One Solution CAD not recognizing polygon after converting shapefile. (Turns Black)

Re: One Solution CAD not recognizing polygon after converting shapefile. (Turns Black)

Allow for Custom Gauge Labels and Increments Based On Guides

Re: Not seeing toolbox after install

Re: Register with Geodatabase but No Object ID

Register with Geodatabase but No Object ID

Create SharePoint list item with geometry?

Layers Only Visible In Web Map If User Is Administ...

Re: Identify a polygon to the right or left of a l...