Created
February 6, 2013 08:11
-
-
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.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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