Guest User

Untitled

a guest
Feb 27th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. <OGRVRTDataSource>
  2. <OGRVRTLayer name="combine">
  3. <SrcDataSource>D:combine.csv</SrcDataSource>
  4. <GeometryType>wkbPoint</GeometryType>
  5. <LayerSRS>WGS84</LayerSRS>
  6. <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/>
  7. </OGRVRTLayer>
  8. </OGRVRTDataSource>
  9.  
  10. 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
  11.  
  12. 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