| Page Properties | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
...
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 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
...
- 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:
|
...