|
POST
|
First add a spatial type: https://pro.arcgis.com/en/pro-app/help/data/databases/overview-database-spatial-types.htm#ESRI_SECTION1_A53013704BF74AFA… Add the ST_Geometry type to a PostgreSQL database—Help | Documentation
... View more
03-18-2020
12:08 PM
|
1
|
2
|
7805
|
|
BLOG
|
A powerful feature of ArcGIS Data Interoperability and 'cousin' FME is the ability to save and share connections to web apps. Once configured, you can use a web connection to read and write data in any number of workspaces while maintaining secure credentials in only one place. Portal for ArcGIS is a component of ArcGIS Enterprise I think of as a content management system. You can start reading about it here. A portal is a highly capable, single-tenant, secure geospatial infrastructure component where you can create, maintain and share data, maps, scenes and apps. This blog is about creating and using a portal app to access hosted feature services to be read and written with the ARCGISPORTALFEATURES reader/writer or the ArcGISOnlineConnector transformer. The starting point is your portal, here is my portal's home page (fake, but you'll get the idea): https://nonexistent.esri.com/portal/home/index.html The first thing to do is create an app to hang the web connection off. Go to your Content view and click to Add Item: Choose 'An application' and click Application and fill in the descriptive stuff: The app will be created and you'll be taken to its home URL, which will look something like this: https://nonexistent.esri.com/portal/home/item.html?id=50bfc12ef28840d48eac324c8ec67dd0 In the top right is the Settings view, click on it. Scroll down (or click on Application beside General top left) and you'll see App Registration: Click on Registered Info to see details you'll need to create your web connection: Click on Show Secret to expose the 32-character hex authentication key. Now you have everything you need to create your portal web app connection for Workbench. From the Pro Analysis ribbon (or by editing any ETL tool) open the Workbench application and go to Tools>FME Options>Web Connections. Mine look like this (login obscured): Click on Manage Services bottom right and in the Manage Web Services dialog use the pulldown bottom left to Create From and pull right and choose Esri ArcGIS Portal (Template). Now fill in the dialog: Test and Authenticate, then close the dialog, and you can add a web connection: ...and you are in business! Restart Workbench and use the new web connection to add a portal feature service reader (login obscured): Now enjoy your portal features ETL!
... View more
03-13-2020
01:07 PM
|
4
|
17
|
19876
|
|
POST
|
Hear hear. Or in metric here here. Or is that entendre entendre.
... View more
03-05-2020
02:30 PM
|
5
|
0
|
2629
|
|
POST
|
Here you are, you will want to refine the schema but the datetime data is correctly handled.
... View more
03-05-2020
07:25 AM
|
1
|
0
|
5246
|
|
POST
|
If I'm reading the logic of this correctly then you should be able to find the rows having shared values between two tables in one pass with this tool: https://pm.maps.arcgis.com/home/item.html?id=e638afe0695a4ad38388cb8d9b350446
... View more
03-04-2020
02:33 PM
|
0
|
0
|
3018
|
|
POST
|
Andreas, Data Interoperability extension will be able to do this for you, if you can share a sample file I can provide an ETL tool source for Pro 2.5/FME 2019.
... View more
03-04-2020
07:53 AM
|
0
|
2
|
5246
|
|
POST
|
Hello. Data Interoperability extension has a transformer - FeatureMerger - that will join the shapefile and your other table using multiple columns. You can obtain an evaluation of the extension if you do not already have it.
... View more
03-03-2020
01:13 PM
|
0
|
0
|
1172
|
|
BLOG
|
Hi Brett, sorry about the delay responding, I totally missed your comment. The check throwing the error is coded as a string comparison comparing the two spatial references. In your Pro session's Python window key in code like below, replacing the inputs with your layer names. If the spatial references differ you may see where by inspecting the strings. A good way to force agreement in spatial references is to put both data sets into a feature dataset. old = "OldAddress" new = "NewAddress" newSR = arcpy.Describe(new).spatialReference.exportToString() oldSR = arcpy.Describe(old).spatialReference.exportToString() newSR != oldSR # False
... View more
03-03-2020
12:25 PM
|
0
|
0
|
5857
|
|
POST
|
OK! Regularize Building Footprint—Help | Documentation Requires 3D Analyst extension.
... View more
02-24-2020
02:56 PM
|
1
|
1
|
5509
|
|
POST
|
I can't quite picture what you're looking to do but making squared off boundaries and rotating features is in this sample: https://pm.maps.arcgis.com/home/item.html?id=9398bd2232cb4c8490b0b05015364d28
... View more
02-24-2020
02:34 PM
|
1
|
3
|
5509
|
|
POST
|
Oh my word, a doc bug! Thanks for reporting it, I'll send it on. Data Interoperability is an extension like Network Analyst, Spatial Analyst etc., you can evaluate it at no cost.
... View more
02-14-2020
10:53 AM
|
0
|
0
|
852
|
|
POST
|
OK full disclosure I'm the Product Manager for Data Interoperability 😉
... View more
02-14-2020
09:07 AM
|
1
|
1
|
5919
|
|
POST
|
All, this pain is totally avoidable, just obtain the Data Interoperability extension and go directly from MySQL to File GDB. In Data Interop the reader is called MariaDB, in fact there are two, one spatial, one not. Bouncing data through CSV will throw the schema overboard as even writing a schema.ini file can't handle all data types.
... View more
02-14-2020
09:00 AM
|
1
|
3
|
5919
|
|
POST
|
The ETL approach requires Data Interoperability extension and the ability to author the processing, but we have big sites taking this no-code approach to maintaining hosted feature services from arbitrary source data on a regular schedule, so it works.
... View more
02-06-2020
02:05 PM
|
0
|
0
|
1627
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | a week ago | |
| 1 | a week ago | |
| 1 | a week ago | |
| 4 | 05-28-2026 05:58 AM | |
| 1 | 05-15-2026 06:54 AM |
| Online Status |
Offline
|
| Date Last Visited |
Tuesday
|