Skip to content

Instantly share code, notes, and snippets.

@walkermatt
Created February 6, 2013 08:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save walkermatt/4721118 to your computer and use it in GitHub Desktop.
Save walkermatt/4721118 to your computer and use it in GitHub Desktop.
Example AstunTechnology / OpenDataLoader (https://github.com/AstunTechnology/OpenDataLoader) config for OS 50k Gazetteer. OSOpenLoader.config and Table.csv should live in the root of the OpenDataLoader directory. Gazetteer.vrt should go in the source Gazetteer directory.
<OGRVRTDataSource>
<OGRVRTLayer name="50kgaz2012_new">
<SrcDataSource>/home/matt/Downloads/gaz50k_gb/Gazetteer/50kgaz2012_new.csv</SrcDataSource>
<GeometryType>wkbPoint</GeometryType>
<LayerSRS>EPSG:27700</LayerSRS>
<GeometryField encoding="PointFromColumns" x="EAST" y="NORTH"/>
</OGRVRTLayer>
</OGRVRTDataSource>
# The directory containing your source OS Open Data
# files. All files in the specified directory and it's decendents will be loaded.
src_dir=/home/matt/Downloads/gaz50k_gb
# The .csv file containing parameters for each dataset
csv_table=Table.csv
# Database the datasets will be loaded into
database=dbname='OSOPEN' user='postgres' host='localhost' password='postgres'
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 2. in line 1.
Dataset;Location_folder;Schema;Source_Projection;VRT_filename;CSV_filename;Header;Delimiter
ONSPD;ONSPD;other;EPSG:27700;ONSPD.vrt;ONSPD_FEB_2011_UK_O.csv;PCD PCD2 PCDS DOINTR DOTERM OSCTY OSLAUA OSWARD USERTYPE OSEAST1M OSNRTH1M OSGRDIND OSHLTHAU HRO CTRY GOR STREG PCON EER TECLEC TTWA PCT NUTS PSED CENED EDIND OSHAPREV LEA OLDHA WARDC91 WARD091 WARD98 STATSWARD OACODE OAIND CASWARD PARK SOA1 DZONE1 SOA2 URINDEW URINDSC URINDNI DZONE2 SOA1NI OAC OLDPCT;,
OSLocator;OSLocator;other;EPSG:27700;OS_Locator2011.vrt;OS_Locator2011_1_Open.csv;Name Classification Centx Centy Minx Maxx Miny Maxy Settlement Locality Coun_unit Local_Auth Tile_10K Tile_25K Source;:
Gazetteer;Gazetteer;gaz;EPSG:27700;Gazetteer.vrt;50kgaz2012.txt;SEQ KM_REF DEF_NAM TILE_REF LAT_DEG LAT_MIN LONG_DEG LONG_MIN NORTH EAST GMT CO_CODE COUNTY FULL_COUNTY F_CODE E_DATE UPDATE_CO SHEET_1 SHEET_2 SHEET_3;:
BoundaryLine;BoundaryLine;bdryline;EPSG:27700;;;;
Strategi;Strategi;strategi;EPSG:27700;Strategi_Gazetteer.vrt;STRATEGI_2011_GAZETTEER.TXT;Settlement Admin_area Easting Northing;*
Meridian2;Meridian2;meridian2;EPSG:27700;;;;
VMDvector;VMDvector;vmd;EPSG:27700;;;;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment