This guide provides a step-by-step process for importing projects from an ESRI Feature Layer into PublicInput using a predefined project template. This functionality is particularly useful for state and local governments looking to streamline their data integration processes.
Locate ArcGIS Rest Endpoint:
Begin by identifying the Feature Server endpoint in ArcGIS.
Select the layer from which you wish to import projects.
Understand and Utilize Fields from the feature layer:
Upon selecting a layer (e.g., point or line), review the fields displayed on the initial page.
These fields will be imported using the project import service.
Familiarize yourself with the template project to understand how these fields merge.
Note: Fields should be enclosed in double brackets for merging:
Scroll to the bottom of the feature layer page and click "query".
Get the query URL from the ESRI Query service
1=1(to pull all records).
*(to include all fields).
Optionally, set a
Result Record Countto limit initial imports for testing.
Choose the output format as GeoJSON.
Click the 'Query Get' button to generate the URL for import.
Configure the Import on the PublicInput Project Import tool:
Go to the settings page in PublicInput and select the 'Project Import' tab.
Paste the generated URL into the import service.
Click 'Generate Preview' to view the fields to be imported.
Choose the destination department and the name field (e.g., project name or identifier).
Select the tags field, adding a separator if multiple tags exist.
Running the Import:
Ensure you have chosen the correct template that matches your fields.
Run the import process. This may take a few minutes.
Once completed, review the imported projects for accuracy.
If not all variables have come through, double-check the field names and layer for null values.
Iterate and re-import as necessary after making changes to your template - the service will overwrite the name and description of projects that have already been imported using the project id field to identify matching projects that were previously imported.
Conclusion: By following these steps, you can efficiently import projects from an ESRI Feature Layer into PublicInput using a project template.