Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <OGRVRTDataSource>
- <OGRVRTLayer name="combine">
- <SrcDataSource>D:combine.csv</SrcDataSource>
- <GeometryType>wkbPoint</GeometryType>
- <LayerSRS>WGS84</LayerSRS>
- <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/>
- </OGRVRTLayer>
- </OGRVRTDataSource>
- ogr2ogr -overwrite -progress -gt 999999999 -skipfailures -f "PostgreSQL" PG:"host=000.000.000.000 port=0000 dbname=myDB user=me password=youtellme" -lco GEOMETRY_NAME=shape -t_srs EPSG:3857 D:input.vrt -nln output
- ogr2ogr -f "PostgreSQL" PG:"host=000.000.000.000 port=0000 dbname=myDB user=me password=youtellme" -s_srs EPSG:4326 -t_srs EPSG:3857 -progress -nln output -lco OVERWRITE=YES -lco GEOMETRY_NAME=shape -oo X_POSSIBLE_NAMES=longitude -oo Y_POSSIBLE_NAMES=latitude combine.csv
Add Comment
Please, Sign In to add comment