1
vote
2answers
37 views

What is best way to reorganize osm into PostGIS database entity?

I'm just wondering how to reorganize the OSM given entity to more flexible and schematic purpose. The OSM gave 4 entities the planet_osm_line, planet_osm_point, planet_osm_polygon and ...
1
vote
1answer
53 views

Possible to store 3D features such as dome into geospatial database?

Is it possible to store 3D features such as dome into geospatial database such as PostGIS? I know that it can store x,y,z data, can such complex features be stored into database?
1
vote
2answers
99 views

Most optimal way to create a (spatial) database for big amounts of data?

I am using QGIS, and on my way to set up a huge spatial database (geographical), where most of the data is points without geometry), along with other types of data (like lines in DXF and areas in ...
4
votes
3answers
339 views

QGIS, Postgis: Geometry type does not match column type

I'm trying to import some polygon shapefiles to Postgis in QGIS via SPIT. One of them can't be imported and returns this error: ERROR: Geometry type (Polygon) does not match column type ...
0
votes
2answers
69 views

QGIS Connection PostGIS and shapefile

I'm working on QGIS with a database created in PostGIS and a shapefile. Inside the database, I have geometry type data about location of some points, instead on the shapefile there some selected ...
0
votes
0answers
104 views

PyQGIS + PostGis: FATAL: sorry, too many clients already

I searched for questions regarding this problem and hadn't find one. I'm developing a custom application with a map canvas to show some geographic information from a PostGis database. After some ...
1
vote
3answers
1k views

How to create a new 'gis' database in PostGIS?

I'd like to create a new database in PostGIS, so I can load stuff into it while the current database is being used. According to the docs Some packaged distributions of PostGIS (in particular the ...
2
votes
1answer
80 views

How do you get a schema report from SHP, PostGIS, or other file type?

All, We're loading City and County data into our database, but looking to remove several fields we don't use. Those fields we do use I'd like our users to simply highlight on a printout I give them ...
1
vote
1answer
77 views

How to import a postgis database in ubuntu (osgeo live 7)

How does one import a postgis database in the ubuntu/osgeo live environment? In windows I would copy the backed up database file into the postgres bin folder and then use cmd to restore the databse. ...
1
vote
3answers
401 views

Load information about a feature

I must mention first of all that I am very new to this area... I am developing a GIS application. I created a simple map using geoserver with openlayers, it is all working through apache tomcat - and ...
3
votes
2answers
266 views

Adding a GIS feature to existing database entry with QGIS

I've built a database with postgreSQL with tables, which include geometry columns. When I add some data to my non-geometry columns, I can see them in QGIS when I connect to my database using postgis. ...
0
votes
1answer
187 views

Column exists in DatabaseMetaData, but does not exist in relation?

I am using JDBC to query a PostgreSQL database. And I want to populate a column called wiki_url based on the value of another column, level which will determine which value of 5 columns to concatenate ...
1
vote
0answers
66 views

Database has duplicate values after running pgrouting

I am a newbie with postgresql and sql statements so maybe it is a trivial question, I'm sorry for that. I am working on a postgis database and try to use the pgrouting function. My goal is to store ...
1
vote
1answer
120 views

Creating admin roles with limited access to PostGIS

I'm trying to cram three different organisations into one server. Today they each have their own geoserver instance connected to separate PostGIS databases, which works fine. But now they also need to ...
0
votes
1answer
196 views

Why is the database connection lost on every query?

Every time I started a query the connection with the database is lost. Anyone familiar with this problem? This problem occurs with various query, for instance: CREATE TABLE table SELECT a.*, ...
9
votes
2answers
289 views

How do you protect your PostGIS credentials when using QGIS 1.7?

I'm fairly certain this should be a community wiki, but I don't know how to make it one. So if an admin sees this please change if appropriate. So.....How do you protect your PostGIS database data ...
5
votes
1answer
372 views

GIS-based reporting and maintenance tool

Background Conceptually, I am looking for a tool, or suite of software tools that can be readily integrated to help browse data using a GIS-based map (such as Google Maps). The proposed architecture ...
4
votes
2answers
312 views

Fastest way to remove matched points

Hoping someone can see a faster way of doing this, because at the moment I'm averaging 9 hours per run for what I'm trying to do and well basically getting my behind chewed off by the boss :-) The ...
6
votes
1answer
565 views

Data visualization and maintenance tool

Background Looking to leverage an existing GIS system for exploring organizational data. Architecture The following figure represents a high-level overview of the system's desired features: The ...
4
votes
1answer
235 views

Spatial index vs two coordinates indexes

I have a table with two columns: latitude and longitude. I want to get all objects inside a "rectangular" (well, rectangular in a lat/lon coordinate metric) bounding box: min-max latitude and min-max ...
10
votes
5answers
562 views

Database versus Files for Solo Developer

I'm just getting started in GIS and am interested in using it to create maps of mountain biking trails in my area and nearby. I've been learning QGIS and have made enough progress to generate a decent ...
13
votes
4answers
971 views

Database design: road topology in GIS

Is there a standard or a best practice way to store certain features about roads: Road directionality: One way streets: Roads going in one direction only Center Turning lanes: roads that exist ...
3
votes
1answer
1k views

Casting a Geography type in PostGIS

I have the following table defined, which uses PostGIS geography. CREATE TABLE test_geog ( id SERIAL PRIMARY KEY, boundary GEOGRAPHY(Polygon) ); I added the following test polygon to the ...
18
votes
7answers
1k views

Spatial databases learning resources for newbies

Would be taking up a course on spatial databases next semester. Would anybody know a newbie friendly introductory resource? A vendor neutral one would be preferable. Thanks.
1
vote
0answers
93 views

Getting started with storing LoST and GML searching

I am working on a logging and search database application. The application will receive event records containing XML LoST values (RFC5222 Location-To-Service-Translation). These records will be ...
8
votes
2answers
638 views

What are the Pros and Cons of hstore data type in postgis?

PostgreSQL has a module named hstore that implement the use of key/value pairs (it's something like the OpenStreetMap model, but in a single table). What are the Pros and Cons of hstore regarding GIS ...
52
votes
8answers
3k views

How do I get started with PostGis

I have been reading a lot about it, but I am struggling to find a good beginner's guide. Which tutorials/books do you recommend? My past experience involves python and arcgis. But I have never worked ...