|
POST
|
ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB I'm trying to import a CSV into an enterprise geodatabase: Catalog > right-click a .SDE connection > Import > Table > Table to Table GP tool Unfortunately, Table to Table is doing a poor job of interpreting the values when setting the field data types in the new table. For example, in a number field in the CSV, the first value is 0, and subsequent values have decimal places like 1.234. The new table's data type is automatically set to an integer due to the 0, so when loading the data, the decimal places in the other numbers are getting truncated (or rounded?) to integers, which is incorrect. Is there a different tool that does a better job?
... View more
10-24-2024
05:37 PM
|
0
|
2
|
1442
|
|
IDEA
|
@AlfredBaldenweck might like this workaround: Use the SQL expression WHERE 1=2 to exclude all rows from the import, importing the schema only.
... View more
10-24-2024
02:44 PM
|
0
|
0
|
1605
|
|
IDEA
|
ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB: I'm trying to import a .CSV into an enterprise geodatabase as a standalone table: Catalog > right-click a .SDE connection > Import > Table > Table to Table GP tool I've gone to great lengths to set the Type parameter for each field to the appropriate type. However, I've gotten an error when running the Table to Table tool. As far as I can tell, I've just wasted an hour of my time because I will lose the field types that I set up. Ideally, I'd be able to export the Field Map configuration as a file (readable with a text editor) and then import it during a different attempt at using the Table to Table tool.
... View more
10-24-2024
02:19 PM
|
0
|
2
|
1393
|
|
IDEA
|
Yes, the field data types can be defined when importing. https://community.esri.com/t5/arcgis-pro-ideas/define-field-data-types-as-part-of-import-process/idc-p/1552053#M32535 But I still want the option of importing an empty table and then fiddling with the fields before importing the data.
... View more
10-24-2024
01:38 PM
|
0
|
0
|
1622
|
|
IDEA
|
ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB: Catalog > right-click a .SDE connection > Import > Table > Table to Table GP tool When importing a .CSV into an enterprise geodatabase as a standalone table: In the Field Map > Properties tab, when changing the data type for multiple fields, I would like to paste the text "Double" into the Type parameter picklist rather than choose an option by clicking the drop-down. Reason: Pasting and keyboard shortcuts are faster than clicking in a pick list. I imagine this would be helpful for accessibility reasons in some cases, too.
... View more
10-24-2024
01:22 PM
|
0
|
0
|
387
|
|
IDEA
|
ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB: When importing a .CSV into an enterprise geodatabase as a standalone table: Idea: An option in the GP tool to analyze ALL values in the field when determining the field type. For example, an ADDRESS_NUMBER field. The first value is an integer, so Pro has set the field to an integer data type. But there are a few values that have a letter in them. Another example is: The first value in a field is 0 (zero), but there are doubles further down, yet the field has been set to an integer. Catalog > right-click a .SDE connection > Import > Table > Table to Table GP tool
... View more
10-24-2024
01:03 PM
|
0
|
0
|
372
|
|
IDEA
|
This idea can be closed. I missed the Properties tab:
... View more
10-24-2024
12:45 PM
|
0
|
0
|
1795
|
|
IDEA
|
ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB: When importing a .CSV to an enterprise geodatabase as a standalone table: It would be great if we could define the field data types as part of the import process. For example, change a text column to a date. Catalog > right-click a .SDE connection > Import > Table > Table to Table GP tool
... View more
10-24-2024
12:38 PM
|
1
|
4
|
1802
|
|
IDEA
|
ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB: When importing a .CSV into an enterprise geodatabase as a standalone table: It would be great if we could import the schema only, not the data. Use case: Modify the field data types in the new table via the Fields View before importing the data, since field types can only be changed when the table is empty. I'm aware that I can import the rows and then delete them. But that seems unnecessarily cumbersome. Catalog > right-click a .SDE connection > Import > Table > Table to Table GP tool
... View more
10-24-2024
12:35 PM
|
1
|
5
|
1646
|
|
IDEA
|
When I add a standalone table from the Catalog pane to the map: I would like an optional setting to always open the attribute table when the table is initially added to the map.
... View more
10-24-2024
12:23 PM
|
1
|
0
|
539
|
|
IDEA
|
Dynamic Range Adjustment (DRA) is a useful tool for seeing lots of detail when zoomed into a large raster, such as a LiDAR DTM or DSM. It would be great if the shaded relief symbology type could do DRA too. Otherwise, I need to export a subset of the raster data in order to make use of the full range of symbology colors when using shaded relief.
... View more
10-24-2024
12:13 PM
|
0
|
0
|
793
|
|
IDEA
|
In the Edit Vertices pane: A field calculation-like mechanism to batch calculate Z and M values. For example, select a subset of a feature's vertices and set the M value to the cumulative length of the line, null, 0, or something else. There might be use cases for adjusting X and Y coordinates too, such as batch-moving specific X coordinates to the left or right.
... View more
10-22-2024
12:11 PM
|
1
|
2
|
990
|
|
POST
|
@AlfredBaldenweck might find this post interesting. I found it via Has Anyone found a workaround for Getting shapefiles out of an MDB without Arcmap?
... View more
10-22-2024
07:36 AM
|
1
|
0
|
1360
|
|
IDEA
|
Esri Casee 03748798 ArcGIS Pro 3.3.2 - Export Raster - JPG compression quality above 100% BUG-000171586: Compression Quality when using Export Raster does not honor the range from 0 to 100
... View more
10-21-2024
06:57 AM
|
0
|
0
|
1222
|
|
IDEA
|
ArcGIS Pro 3.3.2
I'm able to drag an item from the Catalog Pane > Project tab to geoprocessing parameters. Such as drag a file geodatabase from Catalog down to the desired tab name (Geoprocessing tab), and then up to an output parameter in the GP tool. Use Catalog Pane to enter GP Input parameter
However, I can't do the equivalent when working with a wizard. I can't drag a file geodatabase to the Export Raster wizard's Output Raster Dataset parameter.
That's unintuitive. The Geoprocessing pane and the Export Raster pane look similar in Pro. Users would expect them to have the same functionality. Could dragging functionality be added to wizard panes in Pro?
I'm aware that I can copy/paste the FGDB path. But I think dragging would be worthwhile since it is more efficient/intuitive, and would be more consistent with GP tools.
... View more
10-18-2024
04:12 AM
|
1
|
0
|
408
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-20-2026 02:12 PM | |
| 1 | 03-19-2026 11:42 AM | |
| 1 | 06-03-2026 04:02 AM | |
| 1 | 03-18-2026 07:08 PM | |
| 2 | 4 weeks ago |