PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

4
votes
2answers
3k views

How to select segment of linestring using PostGIS?

i have PostgreSQL+PostGIS. I have a linestring: "LINESTRING(60.7014631515719 56.8441322356241,60.7023117507097 56.8445673405349,60.702948200063 56.8447993944193,60.703902874093 ...
0
votes
1answer
300 views

What is the fastest way to identify the two nearest linestrings using PostGIS?

I want to be able to identify the closest roads to two points that are generated through geocoding (a start and end address). The points will likely be near a linestring. Two approaches that I have ...
1
vote
0answers
228 views

How to view error feedback in qgis when testing connection to postgres database?

Using qgis 1.8 on Ubuntu 10.04 with Postgres 8.4.13 I am creating a new (and my first) Postgresql connection in qgis. I can connect to the user and the db using the pgsql client. ...
1
vote
0answers
2k views

How to populate data from postgresql using dynamic php\html listing

In the form I created, I need two fields to be dynamically populated from the database while the other fields will be manually entered and push to the database. I have written a script that is able ...
2
votes
1answer
168 views

How to create a network with all the track points

I have created a sample network through the use of gps visualizer. Than I used the ogr2ogr function to import this data in my database. Now I have a table which holds all the track points of these ...
6
votes
1answer
5k views

Postgis 2.0 - public.geometry_columns view does not contain correct info for views

We have recently updated our database to Postgis 2.0. In our system we used to create views for tables containing a geometry column. After creating the view we also manually updated the ...
9
votes
1answer
662 views

How to view a 155 MB raster stored in PostGIS?

I am using the following command to load a raster into a postgres database: raster2pgsql -I -C -e -Y -F -s 3086 -I -C -M myraster.tif myraster -F -t 30x30 | psql -U postgres -d database -h localhost ...
2
votes
1answer
174 views

Finding the Geometry within which a Point falls

I have the following query, which takes on average about 4 seconds. How might one improve the query such that the same response comes back faster? SELECT * FROM geometries g ORDER BY ...
7
votes
5answers
2k views

How to split OSM roads into individual segments at intersections?

I want to create a road-network for use with pgRouting using OpenStreetMap data. I loaded a shapefile from GeoFabrik into a Postgres table (with PostGIS enabled). However, one problem I had was that ...
3
votes
2answers
757 views

How to specify gdal_contour output format as postgresql table?

I want to generate contours with gdal_contour command. It generates an output as shapefile by default. I want this utility to output a postgresql (postgis) table. The documentation says there is a -f ...
27
votes
2answers
14k views

How to change the SRID of exisisting data in PostGIS?

While importing my shapefile data to PostGIS, I did not select the proper Projection. How do I now change the SRID of the data, without transforming the Coordinates?
2
votes
0answers
465 views

Qgis Plugin development with postgres data

can someone help me with initial developing on qgis plugin that displays postgres data table on a QTTableView or QTTableWidget? So far: I can connect to database using psycopg2 or using ...
6
votes
3answers
4k views

How can I transfer data from one PostGIS database to another?

I have quite a bit of GIS data in a old PostGIS Database (version "1.1.6") and I need to transfer it to another PostGIS Database ("POSTGIS="1.5.3"). I tried creating a backup and restoring that on ...
1
vote
1answer
1k views

How to install shp2pgsql-gui on Mac OSX Snow Leopard?

I am getting started with PostGIS. I am trying to understand how to install the plugin shp2pgsql-gui under Mac. Right now my 'Plugins' tab in pgAdminIII is blank... Thanks!
2
votes
1answer
2k views

Formatting SQL queries for use in Arcpy?

I have to make an SQL query on a column having not adequat name "type_borne_id", I couldn't make SQL queries using arcpy.Select_analysis neither selectbyattribute, but when I use select_analysis ...
1
vote
1answer
260 views

Problem with Pgrouting 1.5

Hi all and thanks in advance. I have Postgis 2.0.1 and PgRouting latest version. I'm using osm2pgrouting to import OpenStreetMap data everything goes ok the trouble is that I always get source and ...
1
vote
0answers
114 views

I've converted a kml to shp and want to import it to pgsql database, but no geometry column [closed]

As the title explains, I have a shapefile whose attribute table has no geometry column specifying the location of points. Rendered in QGIS, it looks fine, so the geometry data is obviously there. ...
1
vote
0answers
72 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 ...
3
votes
3answers
219 views

For the non-IT savvy GIS person (not great w/ Linux & Apache) could someone suggest how to set up PostgreSQL, Geoserver, and ISS/Apache?

I've heard of GeoCommon as being an easy GIS solution, but I'd like to host the data locally for internal users. I know of a group called Open Geosuite - but the ongoing maintenance is something I'd ...
1
vote
1answer
411 views

osm2pgsql import crashed!

I am currently importing a bz2 country file into PostgreSQL 9.1 database for Nominatim 2 using its setup.php that runs osm2pgsql. After processing the nodes. it seems to be stuck at a certain spot ...
12
votes
5answers
3k views

How can I update ogr2ogr to include the PostgreSQL driver?

I'm trying to use ogr2ogr to upload a shapefile to a remote PostGres installation. When I ran this command: celenius:~ celenius$ ogr2ogr -f PostgreSQL PG:"host=255.34.00.00 user=postgres dbname=mydb ...
4
votes
2answers
2k views

Publish SQL Views from Postgres/Postgis to Geoserver

I've trying and reading how to publish a Postgres/Postgis View in Geoserver. I know that I can create an SQL View in Geoserver, but I'd like to define the View in Postgres, not in Geoserver. Does ...
2
votes
2answers
943 views

Importing planet files into Nominatim

After a gruesome night installing PostgreSQL 9.1, PostGIS 2 and Nominatim 2 on CentOS 6.3 using the instructions here, I am finally at the stage of importing a US planet file. Problem: In ...
4
votes
1answer
519 views

Problem processing OSM file with osm2pgsql

I have an OSM file and when I want to import it in my PostGIS base using osm2pgsql, I get the following error: Processing: Node(130k 8.7k/s) Way(0k 0.00k/s) Relation(0 0.00/s)Assertion failed: ...
0
votes
0answers
280 views

assign_vertex_id error

I am trying to test if pgrouting works fine or not. To do so I have created a table containing the following attributes. Columns: gid | length | the_geom | source | target Now my ...
0
votes
1answer
345 views

Do postgres 9.1, postgis 2.0 from stackbuilder and pgrouting 1.0.3. work together?

I am new to pgrouting and I would like to check if the version I have installed works fine with postgres and postgis. I have installed postgres 9.1, postgis 2.0 from stackbuilder and pgrouting 1.03. ...
2
votes
1answer
601 views

How to upgrade PostGIS in OSGEO-Live Xubuntu virtual machine?

I have downlaoded the OSGEO-Live 6.0 virtual machine running Linux Xubuntu. I have it running through VirtualBox on a Windows machine. It currently comes preinstalled with a lot of GIS software, ...
1
vote
0answers
102 views

Is this pgRouting perfomance acceptable for my tiny server?

I'm testing pgrouting functions in a tiny server with 2GB of RAM and a dual core processor. I wrote a program that create client process and they connect to the server in a specific hour to perform a ...
2
votes
2answers
3k views

PostGIS convert geography(Point,4326) to GPS

I got a database with a column of type geography(Point,4326), the data contained looks like 0101000020E610000092E057F66EF73140930035B56CBD4840. How can I convert it to GPS coordinates?
1
vote
2answers
3k views

How to display a image from Postgres database

I have Images in bytea form in PostgreSQL/PostGIS database, i want to display them in a webpage using PHP - PostgreSQL. I got lot of examples and I worked out but not getting output from them... Few ...
5
votes
1answer
224 views

Given 2 LINESTRINGs with common point, how to extract common point?

I have 2 LINESTRING geometries. I know both share a common point. Using PostGIS for Postgres, what is the cleanest way to extract the common point? Example with illustration: How do I extract the ...
0
votes
1answer
372 views

How to get City, State, Numeration, etc from OSM roads by Geofabrik?

I'm really new in this GIS world. I downloaded a shp file from Geofabrik (http://download.geofabrik.de/osm/south-america/chile.shp.zip) and imported it to Postgresql using Postgis. If I see the road ...
4
votes
0answers
93 views

Pros and Cons of virtualisation technology for database-server and datastorage [closed]

Yesterday we had a chat about performance and restorability and I realized how many good things a virtualisation environment can bring to me - but as I'm a little sceptic concerning performance I'm ...
1
vote
1answer
451 views

error performing wfs-t insert in postgres 9.1.4

I am getting error performing insert exception while performing wfs-t insert operation when i use postgres 9.1.4 and postgis 2.0. but i get successful insert when using postgres 9.0.1 and postgis ...
6
votes
1answer
898 views

Are there limitations using a PostGIS out-db raster?

I have been trying to import a large raster into a PostGIS 2.0 database and hit a few stumbling blocks. Initially when I tried to import the raster using raster2pgsql, I would receive the following ...
0
votes
2answers
283 views

Why doesn't QGIS accept my manually altered geospatial column?

I have a table with a geospatial column with srid 28992 but noticed that if i try to show it in QGIS (v1.9) on any openlayer map (through the OpenLayers plugin) it is off by a few hundred meters. ...
3
votes
1answer
664 views

Duplicate ObjectID in ArcSDE Table

After making a check in from an arcpad AXF file, i remark that there's duplicate object ID records , this Arcsde pgsql table is versioned and edited by Axf checkins and a .net engine application. the ...
-5
votes
1answer
365 views

How to create,store and retrieve the spatial data in postgresql [closed]

i am new to postgresql/postgis can anyone explain in steps about how to store the spatial data and retrieve the spatial data and visualise in map in a proper steps.. pls . its very urgent..
1
vote
1answer
132 views

Thematic maps on Non Spatial Data in MapGuide

I need to create the thematic map on a polygon layer. But the data is not available in the layer; I am using Postgres database for that. It means I need to create the themes on layer using non spatial ...
4
votes
1answer
1k views

Error creating a spatial database. ERROR : could not load library “/usr/pgsql-9.1/lib/rtpostgis-2.0.so”

I am running PostgreSQL 9.1 with Postgis 2.0 on Fedora 15. When trying to install the raster support, psql -d mydb -f rtpostgis.sql -v ON_ERROR_STOP=1 I get the following error ...
3
votes
0answers
542 views

How to save table from PostgreSQL to MapInfo File?

I have two tables: 1 with geometry in WGS 2 with geometry in Local System I tried this: ogr2ogr -f "MapInfo File" output2.tab PG:"host=localhost user=postgres password=123456 dbname=postgis" -sql ...
4
votes
2answers
313 views

Saving rasters to postgresQL using raster2pgsql, saving forecast time

I would like to save a forecast which is saved as geoTiffs into a postgresQL database. I've been able to import the rasters using: raster2pgsql -s 0 -I -d tiff/field*.tiff -F public.latest | psql -d ...
6
votes
1answer
2k views

How to find the nearest point by using PostGIS function?

table A: lat | long | the_geom | code | sign 13.8433095 | 100.6360357 | 0101000020E61.... | ABC | start_point 13.7544738 | 100.5459646 | 0101000020E6..... | ABC | end_point 13.4124215 | 100.6232332 ...
8
votes
3answers
764 views

How to select only Spatial tables from the postgres database?

My database contains both Spatial and Non-Spatial tables, but I want to retrieve only Spatial table from the query. Any suggestions to select only Spatial tables. 'the_geom' is the geometry column in ...
4
votes
1answer
2k views

How to compare geometry in PostGiS?

I have a two tables. 1 table have srid=4326 2 table have srid=70066 I want to compare geometry columns of this tables. I find function ST_Equals(geometry, geometry) but its not what i want. I need ...
1
vote
1answer
829 views

Write spatial operations to PostGIS from QGIS or ArcGIS

I need to write my spatial operations to a (new) postgis layer (as the data is to large for a shp file). Can this be done in the QGIS browser or from ArcGIS without SDE? When you go (for example) --> ...
0
votes
1answer
460 views

GeoServer and local PostgreSQL database without Internet

simple question: can I work on GeoServer and local PostgreSQL database on my PC without need for Internet connection ? would I be able to connect GeoServer to the database and create layers ? also ...
1
vote
0answers
113 views

How to connect the Postgres database table to MapGuide? [duplicate]

Possible Duplicate: How can I properly add PostGIS data into MapGuide Maestro? I have added a .shp file into MapGuide Maestro, now I want to connect/link a Postgres database ...
2
votes
2answers
204 views

Opensource Tools for Optimizing Server Performance

I use a server with a basic Microsoft OS primarily for data storage and as a central repository for edited vector data. These data are not intended to be used as mapping or GIS products available ...
8
votes
2answers
657 views

How to catch PostgreSQL/PostGIS errors in GDAL/OGR Python bindings?

Is it possible to catch PostgreSQL output error messages in OGR after a query has failed? For example conn.ExecuteSQL('SELECT * FROM non_existing_table;') In Postgres this returns an error ...