Posts

Showing posts from May, 2014

Install pgRouting extension with postgresql 9.3

Installing cutting edge software is always fun.  So my journey was to install pgrouting 2.0.0.2 with postgresql 9.3 and postgis 2.1.2 on  a Ubuntu 12.04 machine for some testing. As it looks this was not so strait forward I had to use some debian packages which are thankfully easy to install.  Visit each of theses sites then scroll WAY down to the bottom, select your system architecture then click the link to download https://packages.debian.org/sid/postgresql-9.3-pgrouting plus: (update 20.08.2014 now using libboost-thread1.55.0 and libboost-system1.55.0)     https://packages.debian.org/sid/libcgal10     https://packages.debian.org/sid/libboost-thread1.55.0     https://packages.debian.org/sid/libboost-system1.55.0 / Now how to install pgrouting begins with viewing each page and scrolling down on each page then select a server to download then simply download and you should have the following .deb install files in your downloads folder. (if you are using AMD64 archit

ogr2ogr upload shapefile to postgis

Simple quick upload a shapefile to an existing postgis database into an existing schema called "geodata" upload shapefile to postgis with ogr2ogr: # upload shapefile into postgis schema and automatically create the table named "test C:\OSGeo4W\bin\ogr2ogr.exe -lco GEOMETRY_NAME=geom -append -lco SCHEMA=geodata -f "PostgreSQL" PG:"host=domainName port=5432 user=username dbname=dbName password=secretpasswrd" -a_srs "EPSG:3785" C:/somepath/myshapefile.shp -nln NewTableName )