ESRI Asset Federation and Data Connections are managed by site Administrators and Publishers using the Catalog Connector.
With the ESRI ArcGIS server Connector, you can choose either to federate the layers to your Socrata catalog as external datasets or to create a data connection that downloads the layers from the ArcGIS server and creates datasets hosted on Socrata.
Federated layers will then become external datasets and will be searchable and discoverable within your Socrata catalog. Federating public ESRI layers to your Socrata Catalog allows your users to discover and explore the rich data that you’re publishing through ArcGIS, alongside your other data assets.
Data connections download the data from your ArcGIS endpoint on a regular schedule and create public, published datasets hosted on Socrata. These datasets will also be searchable and discoverable within your Socrata catalog, but also provide your users the ability to download this geospatial data as well as API access via SODA.
- Your ArcGIS server must be a Map Server or a Feature Server. Other ArcGIS server types are not supported.
- The ArcGIS server needs to be publicly available
- The ArcGIS server needs to run on an https SSL cert (for more on this, see: http://resources.arcgis.com/en/help/install-guides/arcgis-server-web-adaptor-iis/10.2/index.html#//01nz00000027000000).
- The version of ArcGIS must be 10.0 or higher
- You'll need to have your ArcGIS Server Address to setup the connection. It will look something like this - https://<your domain>/arcgis/rest
- Feature layers must have REST query capabilities for the data connection to work properly
Selecting Layers to Federate or Connect
When the connection is first established, none of your ArcGIS Map Server assets will be connected to your Socrata catalog by default. You’ll see this indicated in the “Connected assets” column of the connectors list as “0 assets connected”.
Administrators have the ability to curate the selection of connected assets and choose specific assets or groups of assets that you would like to make available to your users. Select “Edit” to curate the map layers that you want to federate to your Socrata catalog.
On the “Edit Connector” page, you’ll see three options for connection selection near the top. You’ll have the option to a) connect all assets in your ArcGIS Map Server as maps, b) federate all assets as external datasets, or c) to select a subset of assets and groups of assets to connect.
If you choose “Connect all assets as Maps” in the image below, then all the layers in your ArcGIS Map Server will be downloaded and a dataset will be created for each one in your public Socrata catalog. If you choose this option then any new layers that are added to your ArcGIS server will automatically create new datasets and show up in your Socrata catalog upon the next sync.
If you choose “Connect all assets as External Datasets” in the image below, then all the layers in your ArcGIS Map Server will federate to your public Socrata catalog. If you choose this option then any new layers that are added to your ArcGIS server will automatically show up in your Socrata catalog upon the next sync.
If you choose “Connect a subset of assets,” then you’ll need to select the assets or groups of assets that you want to show in your public Socrata catalog as well as whether you would like to connect them as external datasets or as maps. With this method of connecting individual assets, anytime new layers are added to your ArcGIS server they will be discovered during the next sync but not added to the catalog automatically.
Once you’ve made your selection, press “save” to start the connection sync process for those assets.
Each time you edit the configuration and select more or different layers to connect, you’ll find the status of that sync process indicated as the “current status” on the "Manage Connectors" page. Once the sync status is marked “success” you’ll find those new layers in your Socrata catalog.
Map Layers in the Catalog
When the Catalog Connector is established, map layers appear in your Socrata catalog as External Datasets or as Maps depending on your selection.
Please note that ArcGIS servers are scheduled to sync data changes and update the map layers in your catalog as necessary, including selected metadata, once a day, but updates for very large servers may take longer than 24 hours. Additionally, dependent on available resources, updates to a connector may not happen every day. Each time it refreshes, changes that have taken place within your ArcGIS Map Server will show for each catalog listing.
Expected functionality when a map layer is federated to your Socrata catalog includes:
- If the layer is renamed in ArcGIS, the dataset name is changed in Socrata.
- If the layer is deleted in ArcGIS or moved to another ArcGIS server, the corresponding dataset is also deleted in your Socrata catalog.
- If the layer is moved or redeployed to another service or folder in the same ArcGIS server, it appears as deleted in Socrata and a new dataset of the same name but with a different Unique ID (4x4) is added.
Q: What happens if the data on my ESRI server hits Socrata platform limits?
A: The overall sync will be successful, but failures on certain datasets will appear on the Activity Log page.
Q: What happens if I have metadata on my ESRI asset? Does it transfer over to Socrata?
A: The ESRI Connector will transfer the asset's title and make an attempt to bring the description if available - other fields will not be transferred. You can overwrite the title and description on the Socrata dataset that come from the ESRI asset. However, if the title and description change on the ESRI side, those changes will be migrated to the Socrata dataset on the next sync and overwrite the existing values. Metadata fields other than title and description on an ESRI Connected Socrata dataset can be updated just like any other field and will not be changed by the ESRI Connector.