Latest Contributions by MarkChilcott

Hi All, I note the following in the ArcGIS Pro Roadmap: Schema Reporting - Tools to generate data model reports and data dictionaries, similar to the ArcMap X-Ray add-in. Due for release in ArcGIS Pro 3.2, scheduled for mid November. I look forward to seeing this. Cheers, Mark ... View more

I wonder if I can create a spatial view of the feature class, containing the shape.  Might have to look at that ...   ... View more

I was hoping it would be a simple solution.  Perhaps a definition query on the shape field with st_geometry?   ... View more

Great result ! ... View more

I am seeing the same thing in 10.9.1 (upgrade from 10.6.1). Was there a solution to this?   ... View more

Hi Peoples, One our analysts provided his take on it here.  Some interesting points, so have provided below.  I have seen almost the same issues in the distant past when dealing with Oracle and Oracle Spatial.  As always, it comes back to what the primary business objective is. There are three main issues we found when loading spatial data into PostgreSQL using the PostGIS geometry type (without ArcSDE).   Multiple Geometry Types vs Single Geometry Types PostGIS allows for a mixture of different shape types (point,line,polygon) to be stored against the one feature/row. ArcGIS expects only one shape type per table, so a mixture of geometry types will cause an error or display nothing. Invalid geometry PostGIS allows the storage of invalid geometry. It is up to the application, or developer, to ensure the data is valid before inserting it into the table. Alternatively, all applications reading the data must be able to accommodate invalid geometry. ArcSDE, on the other hand, does not allow for the insertion of invalid geometry. Curve Geometry Representation The storage of curves (curved lines or curved polygons) is varied and complicated in PostGIS. Probably better to explain face-to-face. We had to do a lot of work in FME to create a PostGIS Writer that will create data that is readable by ArcGIS applications. It was complicated, and I wouldn’t be surprised if more issues arise in the future. Note that if only point geometry is being stored, then using the PostGIS geometry should be fine. Consider ArcSDE installed on top of PostgreSQL and using PostGIS as the underlying geometry storage type. At face value this sounds like it should make everyone happy, ArcSDE ensures that only a single geometry type is used, validates the geometry, and converts the curves into a structure that ArcGIS can handle. This approach works for the “single geometry type” and “invalid geometry” issues, but it does something weird to curves – ArcGIS creates an additional binary column in the table and stores the curves in a way that other PostGIS clients can’t read, which actually defeats the whole purpose of using the PostGIS geometry type! We worked out that if we convert curves to straight line segments, and do a bit more data “massaging”, we can load the data in a way that can be read by ArcGIS and PostGIS clients (like QGIS). Assuming we are using PostgreSQL as the underlying database consider : If the applications accessing a spatial database are purely ArcGIS applications, use ArcSDE with ST_Geometry. If ArcGIS is the primary application accessing a database, but other types of clients need access too: Use ArcSDE with PostGIS Geometry Type, but be aware of the curve geometry issues. If non-ArcGIS clients are the predominant software accessing the data, go with straight PostgreSQL/PostGIS, but be real careful with how you handle geometry.   PS:  There is a side note here – you can install the ST_geometry into PostgreSQL and use that. ... View more

Hi Russell, Thanks for looking into this.  I can't seem to reproduce the steps you have used.  Could you break it down for me please. In MyContent New Item URL https://services.thelist.tas.gov.au/arcgis/rest/services/AerialPhotoViewer/AerialPhoto_Time/MapServer Type : ArcGIS Web Server Does not open in map viewers I tried again with reference to the one layer New Item URL https://services.thelist.tas.gov.au/arcgis/rest/services/AerialPhotoViewer/AerialPhoto_Time/MapServer/0 Type : ArcGIS Web Server This opens in Classic Map viewer.  Does not open in new map viewer. The one you created  works - what did you do?   I noted there was not identify in yours?       Cheers, Mark ... View more

Hi Russell, You should be able to see the following public map. https://arcg.is/imG1i Layers are coming from our ArcGIS Server:  https://services.thelist.tas.gov.au/arcgis/rest/services/AerialPhotoViewer/AerialPhoto_Time/MapServer Cheers, Mark   ... View more