Last active
August 29, 2019 21:21
-
-
Save stiles/1c4b46ef1ca5a8e9350b622aa8bc9110 to your computer and use it in GitHub Desktop.
batch data conversion
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
| # reproject data | |
| ogr2ogr la_county_gis_childcare_3310.geojson -t_srs "EPSG:3310" la_county_gis_childcare_1566577142572.geojson | |
| ogr2ogr la_city_gis_bikeways_3310.geojson -t_srs "EPSG:3310" Bikeways_Existing.geojson | |
| ogr2ogr la_city_parks_3310.geojson -t_srs "EPSG:3310" la_city_parks_1566703413127.geojson | |
| ogr2ogr lausd_schools_boundaries_3310.geojson -t_srs "EPSG:3310" lausd_schools_boundaries_1566703408821.geojson | |
| ogr2ogr la_county_gis_homeless_shelters_3310.geojson -t_srs "EPSG:3310" la_county_gis_homeless_shelters_1566703407847.geojson | |
| ogr2ogr la_city_boundary_3310.geojson -t_srs "EPSG:3310" city_boundary_4326.geojson | |
| # ogr2ogr la_city_parcels_3310.geojson -t_srs "EPSG:3310" la_city_parcels_4326.geojson | |
| # copy reprojected data to postgis database | |
| ogr2ogr -append -f "PostgreSQL" PG:"dbname=mhustiles" la_city_parks_3310.geojson -nln la_city_parks | |
| ogr2ogr -append -f "PostgreSQL" PG:"dbname=mhustiles" la_county_gis_homeless_shelters_3310.geojson -nln la_county_homeless_shelters | |
| ogr2ogr -append -f "PostgreSQL" PG:"dbname=mhustiles" lausd_schools_boundaries_3310.geojson -nln lausd_schools | |
| ogr2ogr -append -f "PostgreSQL" PG:"dbname=mhustiles" la_county_gis_childcare_3310.geojson -nln la_county_childcare | |
| ogr2ogr -append -f "PostgreSQL" PG:"dbname=mhustiles" la_city_gis_bikeways_3310.geojson -nln la_city_bikeways | |
| ogr2ogr -append -f "PostgreSQL" PG:"dbname=mhustiles" la_city_boundary_3310.geojson -nln la_city_boundary | |
| # ogr2ogr -append -f "PostgreSQL" PG:"dbname=mhustiles" la_city_parcels_3310.geojson -nln buffer_city_parcels | |
| # reproject dissolved layer to mercator | |
| ogr2ogr la_city_parks_schools_childcare_homeless_buffer_dissolved_4326.geojson -t_srs "EPSG:4326" la_city_parks_schools_childcare_homeless_buffer_dissolved.geojson | |
| # copy reprojected layer to postgis database | |
| ogr2ogr -append -f "PostgreSQL" PG:"dbname=mhustiles" la_city_parks_schools_childcare_homeless_buffer_dissolved_4326.geojson -nln homeless_buffer_final |
Author
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
ogr2ogr -append -f "PostgreSQL" PG:"dbname=mhustiles" la_city_childcare.geojson -nln la_city_childcare