Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
I follow this great post:pgRouting 2.0 for Windows quick guide, and I have loaded the test data from GeoJSON, like this:
But I don't know how to load this layer into my database, and my DB manager doesn't look the same as in Anita's post:
How should I do to load and test this layer into my PostGIS database?
You are using QGIS 1.8, 2.0 adds the Import and Export buttons to the DB Manager plugin. Without upgrading QGIS you're going to need to use another import tool to get your data into PostGIS. You can either use ogr2ogr to directly import your GeoJSON file, or you can right click on the layer in QGIS, save it to a shapefile then use shp2PGSQL, shp2PGSQL-gui, SPIT, or any one of a number of different shapefile to PostGIS importers.
Personally I'd upgrade QGIS to 2.0, there are tons of improvements and the direct import to PostGIS from the DB Manager window is one of my favorites.
