-
Creating unique ID based on count of three attributes
I am trying to create an unique ID for a dataset based on the count of three variables. The three variables are county (55 total), district (10 total), and type (9 total). The unique ID would preferred to be structured as so: county number + district number + "-" + count of asset with a unique county/district/type +…
-
Inspections Data Management - looking for suggestions
Hello all! I'm hoping to gather input and suggestions about best practices and data management when it comes to mapping inspections - such as outfall inspections and evaluations, stormwater inspections, etc. Here are two options in mind, with examples: 1. A feature layer for storm drains/outfalls/etc. AND an unrelated…
-
Personal geodatabases: How were annotation reference scales determined?
Note: I know that Personal Geodatabases are deprecated. Please do not inform me of that here, I am well aware. That being said, I'm working on a project involving them here and could use some help. ArcMap is not an option for me. How were annotation reference scales in personal geodatabases determined? For example, I have…
-
How to enable missing layer properties: supportsAttachmentsByUploadId and supportsApplyEditsWithGlobalIds
Hello everyone, I’m troubleshooting an issue with attachments in a branch versioned parcel fabric service, and I’d like to share what we have investigated so far and ask for guidance on how to proceed. Context: * ArcGIS Enterprise 11.4, Oracle Geodatabase, ArcGIS Pro 3.4.0. * Editing attachments works fine from Portal (web…
-
Database view drops all field alias values
Have a simple view that combines two layers using Union. SQL server is the SDE backend. Both layers match exactly and have friendly alias field names with spaces. My view completely dropped the alias values on the view. There is no way to edit them either. I see similar posts but nothing for exactly this. My guess is I am…
-
Field Alias for SHAPE not showing in json
I have a client with a hosted feature layer and when I use /FeatureServer/layers?f=json , it shows the geometryField property outside of the fields array for the SHAPE field but does not show the alias. "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName":…
-
Table that changes as different attributes are selected
Hi there, operating on ARC 10.8.2 i have an attribute table with a list of towns, each town as a “voter total” associated with it i would like to have a table, or graph, or even just a text box that updates real time the total # of voters for the selected town. so if I add a selection, it will automatically add that voter…
-
NetCDF not rendering and refusing to become a CRF
Hello, so I have a NetCDF file that I am able to add to Pro through the: Add data -> Multidimensional raster Layer In that window I can fine browse to my dataset and after selected it shows me the right variables that I can select and so forth. After pressing OK then my data does indeed get added to the map and gets…
-
arcmap attribute table problems
the data do not display correctly they are not comprehensive in symbols and stuff bit if i copy it and paste it elsewhere the original (correct ) data is pasted i am having this problem with arcmap 10.8
-
Timestamp Difference
Hello! I have a branch versioned database that is showing a timestamp that is 5 hours behind. The machine where the data resides is showing the correct time. Is there a setting somewhere in the enterprise deployment that I may have missed? Any insight is appreciated! *Updated to add these are local on-prem servers/db.*…
-
Creating Point from XY Fails if not saving into project folder (
Hi, I have a weird problem where Arc will not convert my csv into a shapefile unless I save it into my project folder. I import the csv, check the data types, and run Create Point from XY: Input Table ozone.csv Output Feature Class C:\Users\Arya\Documents\ozone.shp X Field Site Longitude Y Field Site Latitude Z Field…
-
Option to Export *.lyr file from ArcGIS Pro
It would be helpful to have the option of sharing Layer files as LYR files as well as the LYRX type in ArcGIS Pro. Companies using other non-GIS software utilize this file type frequently. While it is ultimately up to those companies to update their software to the new formats, it delays transition from ArcMap for ESRI…
-
Seeking Official Definition for Shape Length and Shape Area Fields
I am looking for an official definition of the shape length and shape area fields from an Esri documentation site. I have not been able to find this, though Esri's AI chatbot provided an answer (without a source). My database-centric colleagues need a definition for a data modeling project. The datasets are polygon. I…
-
Merge multiple .sid files together
Hello, I am trying to merge together multiple aerial photos together to run a classification and they are currently .sdi files. I tried running a Mosiac to New Raster but I get the below error when geoprocessing finishes. Is there anything else I can do to process Mosiac? ERROR 999999: Something unexpected caused the tool…
-
Loss of Precision in Latitude/Longitude Fields After Migrating to Azure SQL
We recently migrated/copied some feature dataset from an on-prem SQL database to Azure SQL managed instance. During the process, the FLOAT data type (on-prem) for latitude and longitude fields was automatically changed to NUMERIC(38,8) in Azure SQL. This change has led to a loss of precision in my geographic coordinates.…
-
Duplicate Data in Direct Connect - remove for hot spot
I am working in ArcGIS Pro, and our data is directly connected. The issue is that we are trying to run an analysis (80/20, kernel density, etc.), but certain areas are coming up as issues are only hot spots because the same case is listed multiple times. I don't want to permanently delete the duplicates, but I don't want…
-
best practice when connecting to SQL DB
I am able to connect to a SQL Server database (not a GDB) as either an OLE DB connection or as an SDE connection (using the New Database Connection option in Catalog) - is there an advantage to using one over the other? My use case is mainly extracting a table (approx 250K records) via a python script before applying…
-
Extract Table of Latitude, longitude and Elevation for all pixels WITHOUT point features, from a Topographic Raster layer
Hello, "I have a simple question but it's a complicated task 😅" I'm working with the PDS GTDR (Topographic) layer from the Magellan mission to the Venus. What I need: Aa global table with the Latitude, Longitude, and Altitude (Elevation, or Z level) for each coordinate (X,Y), within the Magellan topographic data. * I have…
-
Reclassify problem
Hi, I am facing a problem while doing reclassify of NDVI layer in ArcMap 10.3. The reclassify result is coming but it is showing a error sign and a error message as I have attached two pictures showing the results of two reclassify layers. It will be a great help if anyone can suggest me any method to solve this problem.…
-
Double vs String field for serial chart in Dashboard
I am creating a dashboard that shows funded grants over the past 20 years. I created a base map in ArcPro and uploaded it as a webmap to use in the dashboard. I want to portray a serial chart on the dashboard that shows how much funding was allocated per year (amount awarded), but I cannot get the serial chart to display…
-
How to make points count as multiple based on an attribute column network analyst
Hi all, I need to solve a location allocation problem on network analyst (ArcMap 10.8) and I have several demand points which should count as multiple but only count as one. I had a polygon file of all the blocks of a city with an attribute called "people" which shows the people living in each block. Since I can't use…
-
Dividing does not work
Hello, I have trouble to make basic mathematical operation in the REST API of ArcGIS. I just want to query a division of 2 fields. While this operation should work, see here. When I try to query it, it doesn't. See here. The addition work well, but not the divisions. Any thoughts on that? Thank you for your help!
-
Can I Edit a table (no spatial data) that is registered with the geodatabase using native SQL commands?
I have a table that contains no spatial data. It exists in an SDE enterprise geodatabase (SQL Server). The table contains log information generated by an FME process; data related to if a certain process ran successfully or not and why or why not. Again, this table contains no spatial data, but it is registered with the…
-
XML Import Failing : 160320: The subtype code does not exist.
Hi I am trying to import a FGDB Schema from XML, the XML export of the schema worked fine. However upon import I get the following error: 160320: The subtype code does not exist (Name) There is no subtype by the Name listed in the error in the FGDB, there is a FC by that name. How do I determine the root cause and resolve…
-
How to automatically create ID for existing feature classes?
Hello, Just wondering that could I automatically to create IDs for the existing feature classes? For example, I have pipes in the database already, the PIPEID fields are all Null, but I do not want to given them the IDs one by one. How could I do something to create the IDs automatically. Your help is appreciated. Thank…
