Latest Contributions by Bud

Merged from a separate idea: “Select By Location” Feature Layer — Spatial query that is fast, modifiable, and refreshable The idea was previously named: "Convert selected features from Select By Location into a fully-functional feature layer"   We need spatial queries that are: Fast Easy to set up Dynamic Modifiable Refreshable One option would be Spatial SQL Definition Queries. But as mentioned in that idea, spatial database operations are notoriously slow and are difficult to set up correctly (as @JoshuaBixby mentions in a comment here). So I'm wondering if “Select By Location” functionality could be used as an alternative mechanism, since that tool is surprisingly fast, even for large datasets. Idea: Could functionality be added to ArcGIS Pro that lets us convert the selected features from Select By Location into a fully functional feature layer?  Refresh the layer dynamically. When the map refreshes, the spatial operation automatically re-queries. Or, the user could choose to manually refresh the layer as needed. We would need the ability to modify the Select By Location parameters after the feature layer was created. For example, put modifiable Select By Location parameters right in the layer properties. Or a button that brings up the Select By Location window with the existing layer's settings preloaded, ready to be adjusted and rerun.  ---------------------------------------------- I’m aware that it’s possible to create a layer from a selection using the Create Layer from Selected Features tool. But I don’t think those layers are dynamic/modifiable/refreshable, so they have limited use. It might be possible to create a model or Python script to produce FCs that are similar to what we want — output a FC using spatial operations and re-run the script on-demand to replace the data. But that would require time, effort, and skill to develop. And couldn’t be refreshed automatically. Further, even manual refreshing would be slow because ArcPy is slow to initialize compared to Select By Location. One of the benefits of this idea is that it would use ArcObjects, which means it would support all datatypes, such as file geodatabases. Whereas the Spatial SQL Definition Query idea would only work for datatypes that have spatial functions in the database, such as enterprise and mobile geodatabases, not file geodatabases. I suppose, behind the scenes, the layer would be a list of objectids, which is somewhat similar to "Create Layer from Selected Features". But the difference would be: the layer is modifiable and refreshable.  ... View more

I think the problem is the underlying Oracle field type is NCLOB. That's unusual for Oracle enterprise geodatabase tables. The underlying text datatype is usually NVARCHAR2. With that said, I think I found a fix: In ArcGIS Pro > Fields View, change the field data type in the empty table from TEXT to SHORT INT. Save. Then change it back to TEXT. Save. The underlying datatype is now NVARCHAR2(255 CHAR).    ... View more

Unfortunately, changing the field lengths in the empty table using the Fields View didn't work: "ERROR 001624: Failed to alter field length."   ... View more

Get maximum text value length of multiple text fields Idea: Import Table — Set text field length to input field's max text value length ... View more

Get maximum text value length of multiple text fields Idea: Import Table — Set text field length to input field's max text value length   ... View more

One option is to use SQL in a SQL client like SQL Developer: select max(length(WONUM)), max(length(RECTYPE)), max(length(DESCRIPTION)), max(length(STATUS)), max(length(WO_CLASSIFICATION)), max(length(OWNERGROUP)), max(length(ASSET_DESCRIPTION)), max(length(ASSET_CLASSIFICATION)), max(length(LOCATION)), max(length(LOCATION_DESCRIPTION)), max(length(REPORTDATE)), max(length(STATUSDATE)), max(length(ACTSTART)), max(length(ACTFINISH)), max(length(DIVISION)), max(length(ASSETNUM)), max(length(RECUNIQUEID)), max(length(SA_ADDRESSLINE2)), max(length(SA_STADDRSTREET)), max(length(SA_STADDRNUMBER)), max(length(SA_DESCRIPTION)), max(length(SA_STREETADDRESS)), max(length(SA_FORMATTEDADDRESS)), max(length(SA_CODE)), max(length(XYSOURCE)), max(length(SUBZONE)) from infrastr.a_test_tbl It would be ideal if I could pivot using Oracle SQL and then ORDER BY to find the max. I'm aware of the PIVOT clause in Oracle SQL, but I'm not sure how to use it for this. ... View more

For my notes, Table to Table (ArcGIS Pro 2.9.5) has been replaced with the Export Table geoprocessing tool in newer versions of Pro.  https://pro.arcgis.com/en/pro-app/latest/tool-reference/conversion/table-to-table.htm   ... View more

Importing CSV — Is there a GP tool that correctly interprets values when setting field data types? ... View more

It looks like Table to Geodatabase might be doing a better job at interpreting the values when setting field types. The numbers are interpreted as doubles; a double field is created, not an integer, which is correct. The numbers with decimal places are loaded into the new table without issue. ... View more