Versions Compared

Old Version 4

changes.mady.by.user Kim Stimpson

Saved on

compared with

New Version Current

changes.mady.by.user Kim Stimpson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Page Properties
hiddentrue
idKB


ThemeData Loading
Type

ESRI FeatureServer

Available from


...

The Department for Environment Food & Rural Affairs (DEFRA) provide a wealth of data, such as Sites of Special Scientific Interest (SSSI) in , Nature Reserves etc. via ESRI FeatureServer format, which may be downloaded to your Spatial Data Warehouse (SDW) and can downloaded as GeoJSON. This may then be transformed into ESRI Shape, MapInfo TAB etc. your Spatial Data Warehouse (SDW) files for displaying in iShare or stored in your SDW as a PostGISs table.

Step-by-step guide

Step 1 - Find URL for the FeatureServer Layer you are interested in

...

Code Block
-f GeoJSON E:\iShareData\{new_layer}.geojson {featureserver URL}

Where: is You need to change the entries to reflect the path to where you wish to save your GeoJSON fileto the GeoJSON file to create, the URL to the dataset you wish to download, together with geometry information e.g.



E:\iShareData\Is the path to where you wish to save your GeoJSON file
{new_layer}Is the name for your new GeoJSON file.
{featureserver URL}This is the URL you have noted in Step 1 together with the geometry information e.g. "http://environment.data.gov.uk/arcgis/rest/services/NE/SitesOfSpecialScientificInterestEngland/FeatureServer/0/query?geometry="xMin:"293890.40,"yMin":461082.70,"xMax:"389794.00,"yMax":588517.40,"spatialreference":{"wkid":27700}}&geometryType=esriGeometryEnvelope&outfields=*&f=json". You need to replace the values in red with the bounding box information you gathered in Step 2.

You should end up with an entry something like this. 

Paste code macro
f GeoJSON E:\iShareData\SSSI.geojson "http://environment.data.gov.uk/arcgis/rest/services/NE/SitesOfSpecialScientificInterestEngland/FeatureServer/0/query?geometry="xMin:"293890.40,"yMin":461082.70,"xMax:"389794.00,"yMax":588517.40,"spatialreference":{"wkid":27700}}&geometryType=esriGeometryEnvelope&outfields=*&f=json"
  • Save the Task and press the Run button if you wish to actually run it to download the data.

Step 4 - Create a Spatial Data Transformation Task

  • In Studio create a Spatial Data Transformation Task to load the GeoJSON into a SDW PostGIS table. You could also output as an ESRI Shape file or MapInfo tab file by selecting different Output.
  • Enter a Name for the Task and pick GeoJSON File as the Source Data.
Note

If GeoJSON File does not exist in the list of "Source Data" types then you will need to edit the ConTypes.xml file, which you will find in the ...Astun\iShare\n.n\Studio\config folder. If you open ConTypes.xml with a text editor you will see options for DBConTypes (servers, such as PostgreSQL and Oracle) and FileConTypes (file formats such as shapefile or mapinfo tab).  Create a new FileConType entry after the last closing </FileConType> tag (but before the closing </ConnectionTypes> tag as follows:

Code Block
 <FileConType>
  <Name>GeoJSON File</Name>
  <FormatName>GeoJSON</FormatName>
  <Direction>Both</Direction>
  <FileFilter>GeoJSON files (.geojson)|.geojson</FileFilter>
 </FileConType>


  • For the Filename enter the path to where you saved your GeoJSON file e.g. E:\iShareData\SSSI.geojson
  • Select your SDW in the type of Output (outlined in red above) you require, either your SDW as in our screen shot or any of the other types, and Save the Taskand enter a name for the Table that you wish to create. 
  • Save the Task and press the Run button if you wish to actually run it to transform the data.