Overview
The Department for Environment Food & Rural Affairs (DEFRA) provide a wealth of data such as Sites of Special Scientific Interest (SSSI) in ESRI FeatureServer format which may be downloaded to your Spatial Data Warehouse (SDW) as GeoJSON. This may then be transformed into ESRI Shape, MapInfo TAB etc. files for displaying in iShare.
Step-by-step guide
Step 1 - Find URL for the FeatureServer Layer you are interested in
Brose to https://environment.data.gov.uk/ and search for the dataset you want. For this example we've used Sites of Special Scientific Interest (England) which, when you select it from the search results, should take you to a page like this.
Look under the Dataset Links section for one called ESRI REST Feature Server Endpoint and click on the link. The link there should take you to this page:
The URL (highlighted in red in the above image) is https://environment.data.gov.uk/arcgis/rest/services/NE/SitesOfSpecialScientificInterestEngland/FeatureServer and this is what you need to import the data.
Step 2 - Determine the Bounding Box for your dataset
As the DEFRA dataset is for the whole of England you will probably only need the data for your area. Usually your iShare Maps / GIS will have Start up Boundary Settings (Min X, Min Y, Max X, Max Y). You can use these values to cookie cut the data.
Step 3 - Create a Workflow Program Task to Import the data
First you need to configure a Program Task in Studio to import the data from DEFRA.
Uses D:\Astun\Tools\OGR2.2.1\ogr2ogr.exe (or whichever version of ogr2ogr is installed)
-f GeoJSON E:\iShareData\{new_layer}.geojson {featureserver URL}
Where featureserver URL is something like this.
geometry="xMin:"293890.40,"yMin":461082.70,"xMax:"389794.00,"yMax":588517.40,"spatialreference":{"wkid":27700}}
&geometryType=esriGeometryEnvelope
&outfields=*
&f=json"
To get the featureserver layer name and firstly go to https://environment.data.gov.uk/
Search for a dataset. For this example I’ve used Sites of Special Scientific Interest (England). This should take you a page like this: