PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.

learn more… | top users | synonyms

3
votes
1answer
199 views

How to typecast from MULTIPOLYGON to MULTIPOLYGONM (force XY multipolygon into XYM)

I need to merge several databases, where the destination table has a constraint checking for MULTIPOLYGONM in the geometry column. At some source tables, the geometry column is in the XY form ...
0
votes
1answer
43 views

Requires Datatype for inserting features

I have imported postgis data in geoserver. In geoserver the spatial data column is displayed as MultiLineString, Does it affect when inserting features into geoserver or does it have to be explicitly ...
0
votes
1answer
1k views

socket connect failed for: /tmp/osm-renderd

I have installed Mapnik and have a functioning PostGIS database (I can access data through QGIS with no problems). When I try to run render_list to generate tiles it fails with socket connect failed ...
1
vote
2answers
385 views

What are some good examples of geospatial UI's [closed]

I am interested in understanding and applying practical geo-spatial examples for some of the transportation data that I have. I have several geocodes that I will pull from the database, and display in ...
1
vote
1answer
2k views

Hibernate Spatial Maven Issue

I'm following the tutorial at http://www.hibernatespatial.org/tutorial-hs4.html. I've created a maven project, and imported it into Eclipse. However, when I run mvn dependency:list, I get the error ...
4
votes
2answers
478 views

Symbolizing Layers in PostGIS

I have a number of vectors (points, lines and polygons) loaded into PostGIS (not QGIS Server). I would like to provide a colour schema based on attribute values which is saved as a default. What I ...
7
votes
3answers
256 views

What would be 'normal' processing time for a large postgis query

I have two datasets which I want to spatially join (with an intersect). The first dataset consists of 9 million addresses. The second dataset consists of 12.000 neighbourhoods. I want the add the ...
14
votes
5answers
2k views

Find pseudo nodes in free GIS software

Software gvSIG OA Digital Edition 2010 have tools topology for finding pseudo nodes in linear geometry. I set cluster tolerance 0.00002 and maximum number of errors -10000 for 20000 link count linear ...
3
votes
1answer
244 views

How can I solve “Shortest and Fastest With time” routing issue?

Please see the image below. (If you can't see the image please search "Bangalore to Palakkad" in Google Maps.) I am searching for a route from Bangalore to Palakkad. Google shows two routes. I ...
45
votes
2answers
7k views

Acquiring ArcGIS-like speed in Postgis

I have been using Postgis 2.0 for 3/4 of a year now and while I really enjoy using it, excessive query processing time has rendered it basically unusable for my use case. I tend to do heavy ...
1
vote
0answers
461 views

Openlayers WFS Overlay Problem

a) I am running a PostGIS database, and I want to display a Table with a about 500 Points of Interest. The POIs have the projection EPSG 4326. b) Geoserver is installed, running and connected to my ...
3
votes
0answers
344 views

Shortest distance from pgrouting with cost not being length: optimal solution

I'm using pgrouting shortest_path_astar with a complicated cost function. It gives back the edges, vertices and costs. I would like to get the total distance of this shortest path (i.e., the sum of ...
3
votes
2answers
430 views

Reinventing the wheel: Public Transit System

I'm building a public transit service in South Africa, and I initially started the project on PHP and MySQL. I've managed to get far with the simple stack, with: Routing algorithm in PHP Data ...
2
votes
2answers
2k views

PostGIS/QGIS and granting permissions

I've got a PostGIS databases, with lots of schemas. I can easily create a new user that will allow them to update and delete features. However when I get the user to create a new feature I get the ...
-5
votes
1answer
441 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..
4
votes
1answer
2k 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 ...
2
votes
0answers
97 views

MultiPolygon from database

I would like to know how to create an instance of a Multipoint from a PostGIS database.. I do the query , then got the ResultSet named "area" , the column with MultiPolygon attributes is named "geom" ...
4
votes
0answers
669 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 ...
1
vote
1answer
200 views

How can I Transfer mysql wkt directly into a postgis table?

I have wkt geometry data in mysql stored in blob format. I need to get this data into a postgis db and am looking for the quickest-easiest way to do it. I have managed to select the data "ASTEXT" but ...
4
votes
2answers
440 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
3k 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
1k 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 ...
1
vote
0answers
749 views

How to add ECW support to GDAL bundled with PostGIS Windows

I'm currently trying the new raster functionalities of PostGIS 2.0 and I successfully imported some GeoTIFF file into PostGIS (although it only find one band so it's all black and white for some ...
1
vote
1answer
202 views

Looking for a template project for OSM data

I have a PostGIS 2 database filled with OSM data for my country via Osmosis. Is there perhaps a template/project (!styling) for QGIS i could download, where i would simply change the provider of data ...
4
votes
1answer
3k 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 ...
2
votes
1answer
919 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) --> ...
9
votes
0answers
293 views

Solutions for fast operations on large GIS datasets [duplicate]

Possible Duplicate: Acquiring ArcGIS-like speed in Postgis I have been using PostGIS 2.0 for all of my GIS operations. PostGIS is an excellent GIS database, but no matter how I format my ...
1
vote
1answer
520 views

ST_Line_Locate_Point between two spatial relations with PostGIS

I am trying to calculate the closest edge and its offset for a relation of points. If using only one point that approach works fine, but if I have several points in the relation I do not know how to ...
6
votes
1answer
783 views

calculate slope for a road network

I am working on a road network for routing operations using postgis and QGIS. I am new to both of these tools and need to calculate the slope for each edge (by retrieving the Z value for the start ...
5
votes
2answers
2k views

Rasterize a vector layer in PostGIS

Related to this question asked here on gis.se and this thread on postgis-user, has anyone worked out a good solution for in-database rasterization of a vector layer using PostGIS? It sounds like the ...
3
votes
3answers
1k views

How to connect all lines within in Multilinestring to one?

I am trying below query to convert Multilinestring to Linestring. It’s output is a multi string because it can’t merge because of different values which is marked as bold in below code. Is there ...
2
votes
2answers
212 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
796 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 ...
2
votes
1answer
213 views

Delete rows that share the same geometry value in postgis

Hello I have the following problem: I created a grid in QGIS. For some unknown reason QGIS doesn't tesselate the plane correctly. Sometimes there are polygons with different "id" that represents the ...
1
vote
1answer
478 views

Obtain address from PostGIS OSM data like Nominatim does?

We currently use the Nominatim service to do address lookups. We want to store the OSM data in our own servers as our usage gets higher. How do I calculate the address of a given coordinate, like ...
4
votes
1answer
1k views

How to relate Non-Spatial table to Spatial table in two different Postgis DBs?

I need to relate a Non-spatial table to Spatial table, but both are in different database. Spatial_table(dbname:dist) gid district_name district_code geom Non_Spatial(dbname:census) ID ...
4
votes
0answers
725 views

How can I properly add PostGIS data into MapGuide Maestro?

I am having trouble connecting a PostGIS database to MapGuide Maestro. Actually, I have added the PostGIS data into Maestro, but when I click to validate the layer it shows an error message: ...
9
votes
1answer
3k views

Using PostgreSQL with QGIS and ArcGIS?

Is it possible to use PostgreSQL with QGIS and ArcGIS? i.e. one database for different clients. Is it anything that I have worry or any problems to use the DBMS from two different software? I know ...
4
votes
3answers
604 views

How to store raster data outside postgis database

I am able to import raster data easily into the database and view it through QGIS. However, I am unable to view the raster layer in Arcgis. Now I want to know how to create a table with a reference to ...
2
votes
0answers
1k views

How to fire a query from OpenLayers to GeoServer to fetch 'the_geom' column in PostGIS table?

I am coloring the polygon shapes of world_country. I have OpenLayers in my UI, GeoServer as server and PostGIS as db. All I want is fire this query: select the_geom from world_country where ...
2
votes
1answer
633 views

Accessing PostGIS raster data using Query Layer in ArcGIS Desktop?

I tried to load raster file (jpg) into post gis using the syntax provided here "C:\Program Files (x86)\PostgreSQL\9.1\bin>raster2pgsql -I -C -e -Y -F -s 102003 -t 300x300 ras_test.tif ras_test1 | psql ...
3
votes
2answers
1k views

How to create a valid global polygon grid in PostGIS?

I want to create a grid spawning the whole globe. The grid is used to measure a density value by counting the number of certain spatial objects in each grid cell. To create the grid, I have created ...
3
votes
2answers
222 views

Points in polygon by months

I have two tables: points(gid,id,datum,x,y,geom) and hexa_grid(gid,geom). I must create new table hexa_grid_pip (gid,2008_01,2008_02 ... 2011_12, geom) In column 2008_01 ... 2011_12 must be number ...
1
vote
3answers
508 views

Java shared hosting with PostGIS

I've been developing a disaster risk management application that makes use of Java/Smart GWT, PostgreSQL/PostGIS, and Tomcat 7. I'm looking for a shared hosting environment for the beta testing period ...
3
votes
1answer
704 views

PostGIS: ST_Transform function conversion problem

I'm inserting map data from a GML file with srid EPSG:27700 into a PostGIS database table with srid EPSG:4326. I'm using the ST_Transform function as in this snippet: ...
5
votes
1answer
1k views

Why do TIF loaded into PostGIS lose their colormap?

I have successfully loaded a TIF image (using raster2pgsql) into my PostGIS 2.0.1 database. I can load the raster image into QGIS and it displays in the correct space. However, it has lost all colour ...
0
votes
1answer
515 views

To get attribute data of polygon layer by giving Lat/Lon

Is anyone having an idea about how to get attribute data of a polygon layer by giving Coordinates with in that polygon. Here i have tried with these codes.. SELECT * FROM kar_bbmp_198 WHERE ...
2
votes
2answers
453 views

Ordnance Survey osgb:BNG spatial reference system not recognized by PostGIS

I'm trying to load an Ordnance Survey GML file into PostGIS using the ST_GeomFromGML function. The problem is that the spatial reference system that is used in the file, osgb:BNG, is not recognized by ...
4
votes
2answers
971 views

PostGIS: incorrect interpretation of a polygon that intersects the 180th meridian

I try to find out all geopoints which intersect the polygon set as a parameter. The problem is when I pass polygon that roughly covers an area of Bering Strait (nearby 180 longitude): So I use the ...
1
vote
2answers
64 views

Can I use in a postgis db within the same table a combination of CRS?

I'm experimenting around with my postgis2.0 database. I want to create a basic table to store all my point data and in the process,I realized that the coordinates are in different CRSs. So naturally ...