Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About BruceHarold
BruceHarold
Esri Frequent Contributor
since
07-04-2014
Friday
1337
Posts created
89
Kudos given
71
Solutions
665
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by BruceHarold
|
POST
|
Michael the single quotes around PARCELID make it a literal and not an identifier. Just remove them.
... View more
06-03-2024
02:05 PM
|
0
|
4
|
1858
|
|
DOC
|
In an earlier post I enumerated common data source types that you will encounter when bringing data into ArcGIS. This document discusses one of these data patterns - common file types available on your computer or by simple manual download. The particular scenario discussed in the attached document is a CSV file with commonly found ETL requirements: Controlling the output geodatabase feature class schema and creating geometry from a column. ModelBuilder in ArcGIS Pro 3.3 is the automation environment - it has everything you need, and preserves work for on-demand re-use. The post attachment includes the discussion document and Model, but not the subject data, which you can download yourself. Please use this post to ask questions or comment.
... View more
05-24-2024
07:32 AM
|
0
|
0
|
320
|
|
DOC
|
In an earlier post I enumerated common data source types that you will encounter when bringing data into ArcGIS. This document discusses one of these data patterns - calling an API that requires pagination to retrieve a complete dataset. Pagination is a technique used by data publishers to manage load on their servers. Response payloads are typically JSON or CSV. Please read the attached document and use this space to ask questions. The post attachment also includes the ArcGIS Pro 3.3 toolbox discussed, but not the subject data.
... View more
05-24-2024
07:23 AM
|
0
|
0
|
505
|
|
BLOG
|
Kyle, I have asked a colleague in the geocoding team to respond, I'm not aware of any new functionality - thanks.
... View more
05-23-2024
08:24 AM
|
1
|
0
|
1371
|
|
DOC
|
One-page "cheat sheet" documents are always popular, for example in the context of ArcGIS a perennial favorite has always been the functionality matrix for ArcGIS Enterprise. When considering your inbound ETL options there are high level decision criteria, this document (available as PDF in the post download) is a brief summary of two of them, namely where your source data comes from and how often you need to bring it in. This is only light guidance, in many cases you will have multiple implementation options, so treat this as an invitation to have a discussion, including in this community space. ETL Patterns
... View more
05-20-2024
08:14 AM
|
0
|
0
|
563
|
|
POST
|
My guess is Quick Import's input data type is not supported in the geoprocessing framework so you can try making an embedded Spatial ETL tool that accepts a file input. However a workspace (geodatabase) output is not supported by server side geoprocessing, so you will need to write to a zipped file geodatabase and make its path an output.
... View more
05-06-2024
07:56 AM
|
1
|
0
|
1202
|
|
POST
|
Quick Import will always try to create a new file geodatabase and the scratch GDB already exists, try using another name and make sure it doesn't exist before running Quick Import.
... View more
05-06-2024
06:35 AM
|
1
|
2
|
1215
|
|
POST
|
Tom, if you have remaining errors please open a support call. My guess is the geometry type suffix is an artifact of the reader not knowing the input geometry type, workspace generation will automatically create one (geometry named) feature type per input in those cases.
... View more
04-24-2024
06:24 AM
|
1
|
0
|
1966
|
|
POST
|
Hi, please log a support call, apologies for the delay.
... View more
04-02-2024
07:04 AM
|
0
|
0
|
737
|
|
IDEA
|
Related, an old sample: https://pm.maps.arcgis.com/home/item.html?id=9398bd2232cb4c8490b0b05015364d28
... View more
04-01-2024
09:20 AM
|
0
|
0
|
1073
|
|
POST
|
For followers: Product team for Data Interop have recommended a test embedding the service account owner credentials into the SQL Server reader.
... View more
02-23-2024
01:07 PM
|
0
|
1
|
8528
|
|
BLOG
|
Hello Annarita, since you mention a "workbench" I'll not wait for Jill to talk about replication and collaboration scenarios. You can do bi-directional synchronization between ArcGIS Online and enterprise geodatabase with Data Interoperability, but you will need to decide which system is parent and child when the same feature is edited in both systems. Maybe one system is where features are created and deleted but features can be edited in either, you make the rules. If you want to prefer one system's edits then run a workspace that commits its' edits to the child first, then a second workspace to fetch edits from the child. If you do not have a shared key field then you can only generate inserts and deletes, not updates. I'm thinking here of using the ChangeDetector transformer to generate the deltas.
... View more
02-20-2024
07:33 AM
|
1
|
0
|
3702
|
|
POST
|
Hello Jeremy, apologies for the delay. Quick Export doesn't know about definition queries. In the attached is a Pro 3.2 toolbox with a spatial ETL tool in it that exports your query features to mbtiles, zoom levels 4-8.
... View more
02-16-2024
10:53 AM
|
0
|
0
|
2813
|
|
BLOG
|
@ShareUser I suppose simple datasets in object stores could be used that way, but on the vector data front I'm personally interested in how AI could be used to generate SQL that gives you the view of GeoParquet that you want to consume, in a smart enough client.
... View more
02-14-2024
06:29 AM
|
1
|
0
|
2799
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 10-06-2025 05:36 AM | |
| 1 | 11-03-2025 05:14 AM | |
| 3 | 11-04-2025 08:41 AM | |
| 1 | 10-23-2025 01:24 PM | |
| 2 | 10-22-2025 09:17 AM |
Activity Feed
- Posted Re: Data Pipeline for sending data on Data Pipelines Questions. Friday
- Posted Re: WorkspaceRunner not working for ArcPro 3.1.2 on ArcGIS Data Interoperability Ques.. 3 weeks ago
- Kudoed Re: WorkspaceRunner not working for ArcPro 3.1.2 for KiwiGISmapster. 3 weeks ago
- Got a Kudo for Re: Change Detect or View Source Swap? The Winner Is..... 3 weeks ago
- Posted Re: Embed connection parameters of an enterprise geodatabase writer bug in DI FME 2025. on ArcGIS Data Interoperability Ques.. 3 weeks ago
- Kudoed Layer's Coordinate System Visibility for AlexZhuk. 3 weeks ago
- Kudoed Add the FME Form AI assistant to DIE Desktop for JuanJoséPérez. 4 weeks ago
- Got a Kudo for Data Generation At Scale. 11-05-2025 01:38 PM
- Got a Kudo for Data Generation At Scale. 11-05-2025 06:05 AM
- Kudoed Re: More From The Duck Pond - Using DuckDB In ArcGIS Pro for MatejVrtich. 11-04-2025 12:38 PM
- Got a Kudo for Re: More From The Duck Pond - Using DuckDB In ArcGIS Pro. 11-04-2025 10:30 AM
- Got a Kudo for Data Generation At Scale. 11-04-2025 10:13 AM
- Posted Data Generation At Scale on ETL Patterns Blog. 11-04-2025 08:41 AM
- Got a Kudo for More From The Duck Pond - Using DuckDB In ArcGIS Pro. 11-03-2025 06:46 AM
- Posted Re: More From The Duck Pond - Using DuckDB In ArcGIS Pro on ETL Patterns Blog. 11-03-2025 05:14 AM
- Got a Kudo for Subscribing To Overture Data With One Click Refresh. 10-29-2025 12:05 PM
- Posted Re: Subscribing To Overture Data With One Click Refresh on ETL Patterns Blog. 10-23-2025 01:38 PM
- Got a Kudo for Re: Subscribing To Overture Data With One Click Refresh. 10-23-2025 01:25 PM
- Posted Re: Subscribing To Overture Data With One Click Refresh on ETL Patterns Blog. 10-23-2025 01:24 PM
- Posted Re: Subscribing To Overture Data With One Click Refresh on ETL Patterns Blog. 10-23-2025 06:56 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
Friday
|