Latest Contributions by Bud

Is there a way to use an Ontario property boundaries layer with PINs attributes in AGOL?  (for personal use) Assorted notes: The layer I'm looking for would be similar to the Private Land layer in iHunter (link) or the parcel owner layers in Ontario municipal web maps. PIN=Property Identification Number -- for looking up Parcel Registry documents at ONLand.ca or teranetexpress.ca to determine who the property owner is. Related info: Use iHunter Ontario to easily find property information If we're talking official terminology, the layer would be called the "owner parcel layer" (has PINS), not the "assessment parcel layer" (has tax assessment roll numbers). For what it's worth, there are a few Province of Ontario web maps that have the "assessment parcel" layer in them: Make a Topographic Map Make a Map: Natural Heritage Areas Agricultural Information Atlas (AgMaps). But that doesn't help me with what I'm doing. I want the PIN/owner information, not the tax number, since I don't think there's a publicly available way to look up the property owner via the tax roll number. I would be willing to pay a modest fee to access a property layer in AGOL. It's for personal/recreation use only: camping, hunting, finding waterbody access, etc. Also, in general, I want to learn more about land information/property rules in Ontario. Having access to a property layer would certainly help. Related: LIO - Ontario Parcel Anyone know how to get a Ontario property owner layer in AGOL? Thanks. ... View more

As far as I can tell, AGOL doesn't directly support serving up a WMS URL/service: Sharing WMS services via ArcGIS Online ArcGIS Online - Hosted Layers Setting up WMS in ArcGIS Online? Could Esri consider adding direct AGOL support, for use cases where we don't want to use Portal/ArcGIS Server, such as this? Serve up WMS/TMS/XYZ layer to iHunter app   ... View more

I use the map functionality in the iHunter app (Android, iOS, and web): https://ihunterapp.com/ https://web.ihunterapp.com/ In iHunter, we can add custom layers by entering a service URL. For example, I can successfully add this WMS URL to iHunter:  https://maps.geogratis.gc.ca/wms/CBMT?service=wms&version=1.3.0&request=GetCapabilities That GeoGratis WMS URL works as a quick test; the tiles show up in the map as expected. But what I really want is to do is add a custom raster map to iHunter. This is the map: Ontario Geological Survey Map 2499 Marble Lake (page 3). Question: How can I publicly serve up a georeferenced version of that map/image as a WMS, TMS, or XYZ service/URL — for personal use in iHunter?   As far as I can tell, AGOL doesn't directly support sharing a WMS URL: Sharing WMS services via ArcGIS Online ArcGIS Online - Hosted Layers Setting up WMS in ArcGIS Online? And while ArcGIS Server does seem to directly support WMS (ArcGIS Server - WMS services), ArcGIS Server isn't available for personal use or as a trial; it's only available for commercial use for tens of thousands of dollars. And would require a high level of expertise to set up. So I don't think that helps me.   If I've understood correctly that AGOL and ArcGIS Server aren't applicable here, can anyone recommend any alternative products or vendors that would be suitable? A contact suggested I could: ...tile it with a program like MapTiler, then host the tiled imagery on a webserver (not just a file sharing service) in XYZ format which can also be imported. You would need to have some web hosting with a webserver such as Apache or Nginx running and host the files there. But that's beyond my skill level. I'm hoping to find a solution that's a bit easier. Any ideas/insight? Thanks. ... View more

It sounds like Oracle 23c will likely be released shortly after February 2023: …Oracle Database 23c is the new Long Term Support release (succeeding 19c) that has a beta period starting in October 2022 and ending in February 2023. Very shortly we will be able to start playing with these features and before too long we can start using them for real. Note that Oracle Database 23c will be supported for a long time (well into 2028 and with extended support already projected into 2031). https://technology.amis.nl/database/oracle-database-23c-new-feature-highlights-release-february-2023/ If 23c will be released soon, I’m wondering, how long does it take Esri to support new Oracle versions?   ... View more

Could an "X" (close) button be added to the top bar of the Licensing window in ArcGIS Pro? Admittedly, I was distracted/in a rush, but I kept clicking the button in the top bar to close the window. But as the mouseover suggests, that button maximizes the window, it doesn't close it. While there is a Cancel button at the bottom, I believe the convention is to also have an "X" button in the top bar too, which would be more intuitive.    ArcGIS Pro 3.0.2 (upgraded today). ... View more

I have a raster map that has red areas in it. I want to extract the red areas as a polygon FC for spatial analysis purposes (find where the red polygons overlap a different polygon FC). Unfortunately, the source vector data isn't available from the government organization that produced the map (1980). So I'm hoping to extract the red areas using GIS tools instead. I've georeferenced the image in ArcGIS Pro. Next, I think I  need to: Remove pixels that aren't red. Convert the red pixels to polygons. What's a good way to do that?   ArcGIS Pro 2.6.8; Spatial Analyst Extension ... View more

Oracle18c EGDB I have a feature class called EVENTS (fields: EVENT_ID, EVENT_YEAR) and a related table called FUNDING (fields: EVENT_ID, FUNDING_YEAR). I want to filter (display in the attribute table) events where there are related funding rows from other years. For example: Show a 2022 event that has funding from years other than 2022: Funding in 2021, 2023, etc. (it doesn't matter if there is funding from 2022 or not) Don't show events that only have 2022 funding rows. And don't show rows that have no funding rows. I want the filter to be dynamic. And I want the event rows to be editable. I don't need to display any fields from the related table. What are my options?  Create a definition query that has an SQL subquery that points to the related table: event_id in ( select e.event_id from events e left join funding f on e.event_id = f.event_id where e.event_year <> f.fund_year and e.event_status in ('F','P','A','C') group by e.event_id ) I can edit the events in the attribute table.  No joins required. Or, create a database view that selects the applicable funding rows. In ArcGIS Pro, create an in-map join (only matches included) to the view via the common EVENT_ID. Edit the events in the event attribute table. Or, instead of an in-map join, create an in-map relate. Select all funding rows and use the Attribute Table tools to select the related event rows. Or, do #2 above, but use a Query Layer instead of a database view.   Are there any other options or anything I've overlooked? Thanks.     ... View more

Edited as suggested by @JohannesLindner  Regarding database views in geodatabases: It would be helpful if we could edit the SQL view definition in ArcGIS Pro/Catalog. We can create database views in ArcGIS Pro. Why not let us update the SQL in Pro too? Edit: It should also be possible to modify the SQL of a broken view. Related: Display database view SQL definition in Catalog properties, even when view is broken Edit: It turns out it's possible to replace a database view using the Create Database View geoprocessing tool. Just use the same name as the existing view. See my comment below for details. ... View more

Regarding Make Query Table event layers: If the first table in the list of tables/joins is 1:1 (i.e. only one row per record), then the columns from that table should be editable. For example, that's how it works with Oracle views (outside of ArcGIS): views are editable via SQL if the data is 1:1. Reason: We have use cases where we want to query data for the purpose of filtering certain records as well as utilizing supporting information from other tables. And we want to edit the data while doing it. Yes, that can be achieved with in-map joins for simple cases -- such as only joining on a single field. But for more complex cases like joining on multiple fields, a Make Query Table is the only option. So it would help if we could edit in the resulting Make Query Table event layer. Note: Other event layer types such as route event layers (linear referencing) are editable. Why not allow editing in Make Query Table event layers too?   ... View more