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

learn more… | top users | synonyms

2
votes
1answer
163 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
418 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 ...
3
votes
1answer
777 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 ...
3
votes
0answers
554 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: ...
8
votes
1answer
2k 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
466 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 ...
1
vote
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
521 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
718 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
214 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
461 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 ...
2
votes
1answer
520 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
432 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
366 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 ...
3
votes
2answers
697 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 ...
0
votes
1answer
48 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 ...
0
votes
0answers
589 views

Implementing custom (Vincenty/Haversine formula) functions for MySQL vs Using PostGIS?

I currently am using MySQL for all of my relational data. I have hit a crossroads with geo calculations. Since, MySQL does not have good support for spatial functions, I am contemplating on using ...
3
votes
2answers
9k views

Click a marker icon to open a pop-up, using OpenLayers

Background Looking to create a pop-up that performs an Ajax request when the user clicks a marker on an OpenLayers map. The markers, however, have different icons. The following is working code that ...
8
votes
2answers
1k views

Growing a PostGIS geometry by a percentage

I'm looking for a way to add a buffer around a PostGIS geometry, but the size of the buffer should depend on size of the geometry. That is, I want each geometry to be enlargened by, say, 5%. The idea ...
10
votes
2answers
6k views

Spatially enabled Postgres database

I am trying to create a spatially enabled PostGIS database. I am following the PostGIS documentation, http://postgis.net/docs/manual-1.5/ch02.html#id2648455. In the short version, i executed, ...
1
vote
1answer
288 views

Cordenadas 2d transformacion a postgis desde QGIS

This is a three-dimensional shape file, I checked in ARCGIS, where the shape attribute indicates POINT ZM, This is the table fid 0 shape* point ZM atribut1 A atribut2 B ESTE ...
3
votes
0answers
335 views

Can we do operations like Geo-referencing and Geo-coding in NoSQL Databses

I want to generate a map, using some spatial data provider like OSM. I am trying to put in some dynamic data-set on top of the base map. The data size is considerably large enough to be called as ...
2
votes
1answer
892 views

MySQL GeoSpatial function for ST_Distance_Spheroid? Metric used in return Type of GLength?

Is there a ST_Distance_Sphere, ST_Distance_Spheroid equivalent function in MySQL's GeoSpatial Support? If not, any way to emulate this? What is the metric used in return type of ...
3
votes
1answer
319 views

Impossible to open the .qgs file I've just saved with QGIS 1.8

I'm using QGIS 1.8.0 on Mac OS X 10.6.8 (last stable version of QGIS I downloaded yesterday). After working yesterday and this morning on it, I'm trying to open it again, and QGIS asks me the ...
0
votes
2answers
148 views

dijkstra_sp runs without error in postgres query terminal, but triggers an error in Java

I am running this simple query select id,gid from dijkstra_sp('roads',22,33) This works perfectly fine and returns results in postgres query terminal. However running exactly the same query in java ...
1
vote
2answers
157 views

postgis st_geomfromgml error on point

In PostGIS 2.0 I try: select ST_GeomFromGML( '<gml:Point srsName="urn:ogc:def:crs:EPSG::28992"> <gml:pos>275466.0 565559.0 0.0</gml:pos> </gml:Point>'); This ...
7
votes
1answer
123 views

Finding similar trips in a database

I have a trips table and a bus_stops table. The trips table has a from_stop_id and a to_stop_id. The bus_stops table has lat and lng information for each bus stop. How can I order the trips in ...
1
vote
1answer
439 views

postgis st_linemerge based on attribute

I have a postgis table full of very small line segments. I would like to merge them according to an attribute in another field. update line_table set the_geom = ST_LineMerge(the_geom); but how do I ...
2
votes
1answer
190 views

Postgis nested query trouble

I am having difficulty writing a nested postgis query. I have a single table from which I need to create a view in PostgreSQL. I have created the view with the following command create view ...
1
vote
2answers
365 views

How does one control the rendering order of geometries from a postgis geometrycollection?

I have been using PostGIS for a while now but have only been using simple geometries (points,polylines and polygons). For a particular project of mine I am considering using the geometrycollection ...
1
vote
1answer
257 views

ERROR: type “geoms” does not exist. What version of pgRouting should I use for postgres 8.4 & postgis 1.5?

I am running this on windows 7: Postgres 8.4 postgis 1.5 I installed pgrouting, but I am getting the error: ERROR: type "geoms" does not exist. so my question is: which version of pgRouting should ...
10
votes
2answers
2k views

How can I convert geomagnetic coordinates to geographic coordinates without doing the math myself?

I have some data which are in geomagnetic coordinates; that is, they are latitude and longitude, but in reference to the magnetic north pole in Canada rather than the geographic north pole. As you ...
1
vote
0answers
2k views

Error when importing shapefile to Postgis database

I was trying to import shp to postgis database and i get the following error: Importing with configuration: adresy92, public, geom, C:\Users\tomek\Desktop\adresy92, mode=c, dump=1, simple=0, ...
4
votes
1answer
1k views

How to save a newly created shapefile in PostGIS?

I am creating shapefile using shapefile.py and my database has records more that 65k which is the limit of the shapefile. How can I create shapefiles then? Is it possible that somehow I am able to ...
6
votes
1answer
110 views

Understanding null shape type

I have some shapefiles that I am reading and then loading into tables in the database. The shapefiles with no zoom (eg. "au_postcode") have no shapes with type null. When I tried to load a shapefile ...
10
votes
1answer
1k views

Conflate (merge) private shapefile data with OSM data

Background Downloaded Alberta OSM data from Geofabrik and have it running on a private Linux server using PostgreSQL 9.1, PostGIS 2.0, Mapnik 2.1.0, osm2pgsql, Apache 2, mod_tile, renderd, and ...
8
votes
1answer
1k views

PostGIS - Calculate progressive distance between points on a GPX path

I am attempting to build an elevation profile using PostGIS-PostgreSQL only. I have imported GPX data in my PostGis database, so now I have a table full of the GPS coordinates of the track and the ...
5
votes
1answer
1k views

Raster data on PostGIS

I need to publish raster and vector data through GeoServer WMS service and I have already chosen PostGIS as datasource to keep vector data. Now I would like to know what is the best practice to work ...
3
votes
2answers
1k views

Select Duplicate Points PostGIS

I have a table made of merged point datasets in PostGIS. I want to select all of the features where two or more points have identical geom values. At present I just want to select so I can review ...
15
votes
2answers
8k views

How to change the geometry type from Point to Multipoint within an existing table in PostGIS?

Is there a PostGIS function that can change geometry type for an existing table? We need to change from POINT to MULTIPOINT. The table will be empty when we change the geometry type and we cannot ...
0
votes
1answer
371 views

one row is discarded while importing shapefile into postgres

Please help me in following issue. I need to import a polyline shapefile into Postgres9.1 through shp2pgsql command.When i did like this, i got an error as "NOTICE: CREATE TABLE will create ...
4
votes
1answer
364 views

Self-intersecting polygon using extreme values

I have this polygon POLYGON((1.2E-15 1.1E-15,1.31E-15 1.21E-15,-180 -90,180 90,1.2E-15 1.1E-15)) It uses an extreme coordinates like (1.2E-15 1.1E-15) and (180 90) When I call ST_isValidReason, ...
3
votes
1answer
376 views

How to Load RDF Data to PostGIS?

I want to load some sample RDF (Relational Data Format) to POSTGIS. Are there any tools or methods to do this.
2
votes
1answer
1k views

How to insert google maps lat/lng into postgis in geometry datatype

I came across: https://developers.google.com/maps/articles/phpsqlinfo_v3 I've changed the code a bit and all process is well done for postgis database. I get the data from infobox when user clicked. ...
0
votes
1answer
140 views

Retrieve data from table for spatial queries in PostGIS

We just want to write some spatial queries for our PostGIS tables, but we can only write queries with geometry columni like (POINT(36 43). Assume that we have two columns like geom and name, we want ...
4
votes
1answer
607 views

How to load a postgres view using pyQgis?

Under Qgis 1.8 on Windows 7 I have this problem with my pyArchInit plugin: I need to load on the map canvas my geometries from a postgis layer. Till the 1.7.4 version I use the method explained on the ...
1
vote
1answer
786 views

GeoServer WPS Aggregation Functions Example

The scenario: I want to present a user with names of polygons from a layer in GeoServer. I then display the polygon(s) whose name(s) the user selected. What I've done: I have a search box, which ...
11
votes
5answers
4k views

Free map service for private web applications

Background Looking to display a map (for internal use only) on a web page. The application must be able to add custom layers (without sending the data to the map service host): Municipal zones ...
5
votes
1answer
689 views

Can PostGIS constrain a column to multipolygons and polygons?

I'm currently using PostGIS 1.5.3, but I will be upgrading to 2.0 soon. So please note any differences between the two versions that are relevant to the following questions. Is it possible to create ...