SQL Server does creates spatial index automatically however the bounding box coordinates needs to be typed in manually. A FME workspace has been created for creating spatial index. First workspace loads the data into sql server database and the second workspace (which creates the spatial index) runs after the translation is complete.
runfmeworkspace.py is the python shutdown script in the workspace loading data into SQL Server. This script calls the FME workspace and creates spatial index.
Added more workspaces. These FME workbench uses ESRI REST API to download data. The data that can be downloaded are:
- Special Area of Conservation
- Special Protection Areas
- Sites of Special Scientific Interest.
- Nitrate Vulnerable Zones 2021.
- Felling Licence Application
Updated the FME workbenches added on 20 Feb 2021. The workbenches now contain private parameters populated by Python script. The parameters are SRID, xmin, xmax, ymin & ymax. These are used while in setting the coordinate system and X, Y extents while creating table in Oracle database.
- Added FME workbench to generate ArcGIS token using REST API. The workbench is based on sample workbench provided here. The token is generated using the user login credentials.
- Added FME workbench to generate ArcGIS token using OAuth2 REST endpoint. For more detailed information please refer the ArcGIS Developer documentation here.
Added FME workbench to use OS API. The workbench is a boiler plate and demonstrates way to generate access token or using the project key in HTTPCaller.