Latest Contributions by TomGeo

‎08-16-2022

I initially created a new database on our MS SQL server and enabled the database through AGP 3.0 as an enterprise database. Thereafter, I populated the database with data tables. Each table contains a primary key, where 'Not Null', and 'Identity' are set to true. Since a primary key implies a unique index I think the solution from this posting does not work for me. The 'solution' for the issue at hand on this page is also very 'precise' and I do not know why my tables cannot be shown in a table view. What I can see in the monitor is <Event time="ti aug 16 15:02:00.034" type="Error" thread="5938: Main CIM worker thread" elapsed="0" function="" code=""> Cannot convert OID 4711880873618702336 to 32-bit integer. </Event> My database table does not contain a column named 'OID' and within the entire table a value of 4711880873618702336 cannot be found. The primary key of the table is called idq_id and has a max value of 11,321,131, while the table contains a total of 2,480,912 rows One more thing, using the 'XY Table To Point' tool I was able to create a point FC of more than 5 million points without any problem, and I can visualize the attribute values of the FC. However, opening the database table fails to retrieve the page of rows. I would really appreciate suggestions on how to solve this issue.

‎08-09-2022

Thanks Wolf, that was exactly what was needed. 🙂

‎08-09-2022

I migrated a project from AGP 2.9 to AGP 3.0 and it builds fine, though it comes back with a single warning MSB3277: Found conflict between different versions of "System.Drawing.Common" that could not be resolved. The more detailed description is: There was a conflict between "System.Drawing.Common, Version=4.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51" and "System.Drawing.Common, Version=6.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51". "System.Drawing.Common, Version=4.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51" was chosen because it was primary and "System.Drawing.Common, Version=6.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51" was not. I ran a build with a diagnostic log, but I cannot find out what part is still using version 4. I believe the pieces using version 6 are relatively clear: ArcGIS.Desktop.Framework.dll ArcGIS.Desktop.Core.dll ArcGIS.Desktop.Mapping.dll ArcGIS.Desktop.Editing.dll ArcGIS.Desktop.Layouts.dll Any suggestions on how I can get rid of this warning?

‎07-05-2022

Hi, why don’t you parse the lyrx and then you can address the “rangeDimensionValue” directly?

‎07-04-2022

I have the challenge of showing nautical data on top of some basemap in an Enterprise Portal. My main issue is that I cannot use the S-57 data we have in house since the data are encrypted and a UPN has to be provided to read them. Not having the possibility to read these data in ArcGIS Pro I went for OpenSeaMap data, available as *.osm files. These data I can read into a geo-database, but now I am struggling to get the proper symbology applied. Hence, I was looking for style files and found that earlier it was possible to download a "Nautical Style Set for ArcGIS and Instructions" as a zip file, containing .pdf and .style files. The link to the zip file is broken and I did not find any other source. Can somebody here help me out with style files to get ECDIS conform symbolization applied to my data? Best regards, Thomas

‎07-04-2022

Hi @Robert_LeClair I was just testing an sqlite database I created by using the Quick Export tool from the Interoperability Toolbox. The created database and table have been correctly read into AGP 3.0, and when adding to the mapview I was promptly getting a list of columns to choose the unique identifiers from. There seems to be an issue though with the coordinate systems. As I left the default coordinate system setting ("Same as Source"), when adding the table to the mapview the dialog shows the coordinate system as unknown. When setting the coordinate system manually to SRID = 25832, the layer is generated, and add to the content pane, but on visualizing the features nothing is shown. On 'Zoom to Layer' nothing is shown either. On the attempt to open the layers attribute table AGP return the following error message: If I leave the SRID as unknown, then the layer is correctly visualized. The other approach, of writing the OSM data in FME via a FeatureReader into an File Geodatabase works without problems.

‎07-01-2022

Wasn’t a climbing injury so to speak… climbing partner never showed but I couldn’t give it a pass once I was standing at its foot. No rope, but it took anyway a while and during a heatwave I burned my neck to a crisp. The second was closed at the time due to vultures nesting, or something like that.

‎07-01-2022

Well, Copenhagen here, and after a full working day, plus Tour de France… Colorado sounds good, but my neck hurts immediately again when I think at my last time at the 1st flat iron, and it seems to get pretty hot during the next couple of days. I will test the sqlite with some feature classes and see about the results for educational purposes. If it works writing to FGDB than that’s fine for me as well. If everything goes well with the data I will write them anyway into an Enterprise DB.

‎07-01-2022

Will try tomorrow… it’s almost 11pm here now. 😉 Can AGP actually handle an OSM file by itself? Also, as Said in the initial posting, QGIS reads and visualize the data from the sqlite db without breaking into sweat.

‎07-01-2022

@Robert_LeClair - yes, I do connect to the sqlite via ‘Add Database’ in the catalog pane, and AGP has no issue in listing all the tables within the database. I did not try the ‘Add Data’ button, but used drag and drop instead - from the catalog pane onto an existing map. I did try a right click as well, adding the table to a new map. Then the map view ic created, and the dialog from my initial post shows up. Whatever way I tried, the result is the same and I’m stuck at the dialog ‘New Query Layer’. Also, the only way to close the dialog is the close button, the cancel button does not work in this case. The way I create the sqlite db and it’s data source might be of interest. Who knows. I build the db in the FME Interoperability workbench by reading an OSM file in. I read every layer of the OSM file as single feature types and write them into the db file via the Spatialite writer, set to allow dynamic schemas.

‎06-30-2022

AGP 3.0 has no problem reading the content of an sqlite file in, however, adding data from an sqlite file to map hangs at a 'New Query Layer' dialog, where it seems AGP is trying to read the column properties, and fails. QGIS does not have any problem reading and visualizing the data. Hence, I don not think there is anything wrong with the sqlite file.

‎06-30-2022

I second this question! I just downloaded the addin and installed it in AGP 3.0 and I do have the same issue. The location of the txt file does not matter, the error is always the same.

‎06-29-2022

I recently installed AGP 3.0 and was going to set things up as I had them in my 2.9 environment. When getting to jupyterlab, and installing extensions and widgets I realized that I am still in version 2.2.10 of jupyterlab. I hoped for an upgrade of jupyterlab from AGP 2.9 to 3.0 but it seems that did not happen. Just to be absolutely sure, is 2.2.10 still the version delivered with AGP 3.0 or did something go wrong on my side?

‎06-23-2022

@DanPatterson yes, in the res directory of the base environment, there is a pinned file. There is also one in the conda-meta environment. Looks to me like conda create --clone arcgispro-py3 --name NAME does not create a clone including the pinned file. To a certain degree that is also what the user wants. I create the clone to be able to install what I need and want. At the same time, the absence of a pinned file, containing at least the packages that can't be updated is rather creating problems, than providing solutions. I didn't check the order of channels, and would assume the esri channel comes before the conda-forge, but setting -c pointing at conda-forge gave me the same message about the inconsistency. @DanPatterson wrote: I usually install packages in the base environment (for example Spyder and other packages) since I have full admin rights to my machine and a conda install --revisions (desired revision # here) How do you install something in your base environment? Do you simply use the command line and --no-pin? The pinned files for the base environment are up to the neck full with all the base packages...

‎06-23-2022

Hi @DanPatterson, I am aware that the arcpy package cannot be updated, and did not try. I also did not continue to update the arcgis package when receiving the message. However, I had a look for the pinned file, at much to my surprise, there is non in the conda-meta directory. If there is no pinned file, then where does the system takes the information from that a) something is pinned, and b) --no-pin will have an effect?

Online Status	Offline
Date Last Visited	‎05-08-2026 05:14 AM

My Ideas

Latest Contributions by TomGeo

Failed to retrieve a page of rows when trying to load enterprise table

Re: Conflicts between different versions of "System.Drawing.Common"

Conflicts between different versions of "System.Drawing.Common"

Re: Replace words\characters in text file

Availability of style files for nautical data.

Re: Adding data from sqlite fails (ArcGIS Pro 3.0)

Re: Adding data from sqlite fails (ArcGIS Pro 3.0)

Re: Adding data from sqlite fails (ArcGIS Pro 3.0)

Re: Adding data from sqlite fails (ArcGIS Pro 3.0)

Re: Adding data from sqlite fails (ArcGIS Pro 3.0)

Adding data from sqlite fails (ArcGIS Pro 3.0)

Re: Oriented Imagery, import Imagelist error: access denied

ArcGIS Pro 3.0 and jupyterlab

Re: ArcGIS Python environment clone inconsistent

Re: ArcGIS Python environment clone inconsistent

How to use 'Truncate Existing' using the Esri ArcG...

Re: WMTS works in Classic Viewer but not in New/Be...

Re: Docking option

Adding xyz layer to content

Re: Writing to Enterprise database fails with erro...