Toolbox and scripts for importing tables into an existing feature class within a web layer or file geodatabase.
Geometry can be assigned to features using provided coordinate values in a known spatial reference system, or by geocoding an address associated with each incident.
These scripts can be scheduled using Task Scheduler to automatically update the feature class and service.
ArcGIS Pro
ArcGIS Online organizational account or ArcGIS Portal
Source table and feature class must have fields with a unique identifier for each record.
To filter for duplicates, both the source table and the feature class must have fields with the date, and optionally time, of the record. This format can be modified by changing the Timestamp Format Parameter.
All date, time, and timestamp fields in the source table should contain the following, in order of requirement:
For example, a field containing only the time 16:45 will cause the tool to fail because it is missing the year, month and day information associated with that time.
These tools are set up to use the World Geocode service, which requires, and consumes credits from, an ArcGIS Online organizational account.
Learn more about setting up a connection to the World Geocode Service
Optionally, use your own locator or geocode service. This requires some additional configuration of the scripts. Open import_records.py in IDLE or a text editor and modify the values of the following parameters located near the top of the script:
Additional information available for these tools.
Learn more about Esri's ArcGIS for Local Government solutions.
Show me a list of other Local Government GitHub repositories.
New to Github? Get started here.
Find a bug or want to request a new feature? Please let us know by submitting an issue.
Esri welcomes contributions from anyone and everyone. Please see our guidelines for contributing.
Copyright 2013 Esri
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
A copy of the license is available in the repository's LICENSE.txt file.