Skip to content

Instantly share code, notes, and snippets.

@mtravis
Last active December 13, 2015 17:38
Show Gist options
  • Save mtravis/4948859 to your computer and use it in GitHub Desktop.
Save mtravis/4948859 to your computer and use it in GitHub Desktop.
<OGRVRTDataSource>
<OGRVRTLayer name="50kgaz2012_new">
<SrcDataSource>C:\OSOpenData\Data\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=C:\OSOpenData\Data\
# The .csv file containing parameters for each dataset
csv_table=Table.csv
# Database the datasets will be loaded into
database=dbname='OSOpenData' user='postgres' host='localhost' password='postgres'
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
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