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

learn more… | top users | synonyms

3
votes
3answers
214 views

How can I draw squares in PostGIS layers at different angles?

I am trying to draw two squares on a 45-degree angle and then merge them using PostGIS to edit. QGIS can draw squares but only on a perpendicular plane (eg, 0, 90, 180), and I need to be able to draw ...
3
votes
0answers
544 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: ...
3
votes
2answers
3k views

Postgis installation error

I am using fedora machine. I want to install postgis on my system. So this is what I have done Installed Postgresql and supporting packages using YUM. Created directory /sources to put all the ...
2
votes
1answer
189 views

Using PostGIS functions in ArcGIS Desktop for Layer Definition Query?

I am connecting ArcGIS Desktop 10.2 to Postgis 2.0.3 with PostgreSQL 9.2.4. No SDE. I can load data with no problems and access the data in ArcMap. However I can't seem to use PostGIS functions within ...
2
votes
1answer
321 views

Unreachable vertex

I'm developing an application for academic purposes that mainly gives to the user a recommended itinerary for a previously introduced preferences (Gastronomy, Leisure,etc.). For this purpose, I use ...
2
votes
1answer
859 views

Why does my PostGIS query fail with “current transaction is aborted”

I'm trying to create a vector layer in a QGIS project using a PostGIS query. QGIS is returning the following error: Query failed 1 cursor states lost. SQL: CLOSE qgisf1 Result: 7 (ERROR: ...
2
votes
2answers
1k views

DatabaseError: Coordinate values are out of range [-180 -90, 180 90] for GEOGRAHY type

I am using Django 1.3, PostGIS 2.0 , Postgresql 9.0 and GeoDjango. I had a database with a table for places. This table had latitude and longitude for places in the US. I enabled this database with ...
2
votes
1answer
207 views

Automated correction of parcel geometry based on area measure?

i have a set of parcels in DWG file and i have the areas that should be in these parcels in an excel file, so i have to modify each parcel to match the area specified in the excel file with a moving ...
1
vote
0answers
230 views

Editing PostGIS data in ArcGIS Desktop?

Quick question regarding editing PostGIS data in ArcMap 10.0. Far as I can tell, this can only be accomplished through third-party plugins like GISSquirrel or ST-Links. Does anyone know of an ...
1
vote
3answers
158 views

How to complete the roads output of PostGIS?

I converted the file I exported from OSM to PostGIS using osm2pgsql. I have opened the table's outputs to QGIS and I saw data are not complete compare to OSM editor view. Most of the roads are broken ...
1
vote
2answers
466 views

Searching planet_osm_point by longitude and latitude

I used osm2pgsql to import data into my PostgreSQL database and it put gave me the following 4 tables, planet_osm_point, planet_osm_line, planet_osm_polygon and planet_osm_roads. I have looked at ...
1
vote
1answer
189 views

Routing in MS SQL 2012

I would like to perform routing in MS SQL 2012 similar to pgRouting. In pgRouting, I'd do the following steps to create a routable network: Create a database routing with template template_routing ...
1
vote
1answer
780 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 ...
0
votes
2answers
68 views

How to implement a radius search using PostGIS

I am very new to this topic and after a long time of research I didn't find a solution. I want a query that I can use on my PostGIS database performing a radiussearch.. I inserted the Open Street Map ...
0
votes
0answers
64 views

How to choose data type and SRID, for coordinates from different sources, in a medium size zone

I'm developing an application. In the database I need to store coordinates for many places, in the north-east of Italy, but the area could expand in the future. This coordinates will come from some ...
0
votes
1answer
132 views

PostGIS: ST_Clip() raster in SRID:32617 with a polygon

I'm trying to ST_Clip() raster in `SRID:32617' with a polygon. What I did ST_Transform(polygon, 32617): It fails, couldn't project point() exceeded limit (-14) ST_Transform(rast, 4326, ...
0
votes
1answer
411 views

Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type

After import some data from OSM file into Postgre, the coordinates numbers are too big and having trouble to cast to Geography: Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY ...
0
votes
0answers
91 views

not able to view imported .tif file in geoserver

I am using geoserver. I have imported a .tif file using postgis, which has been saved in vector type layer in geoserver. Now, whenever, I preview it, the layer gets automatically downloaded as wms ...
18
votes
7answers
2k 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.
10
votes
1answer
6k views

Geocode quality: Nominatim vs. PostGIS Geocoder vs. Geocoder::US 2.0

I occasionally need to geocode >> 500,000 US street addresses (no features or intersections). I'd like to set up a geocoding service locally to handle these bulk geocodes. I've used the Tiger-based ...
17
votes
2answers
5k views

How can I find a point inside a polygon in PostGIS?

How can I find a point that is guaranteed to be within a given polygon in PostGIS? I am aware of the ST_Centroid function. However, the centroid is not always within a polygon, see below: ...
24
votes
5answers
9k views

Optimizing osm2pgsql imports for OSM data

I'm currently building an instance on EC2 on which to import the entire Planet.osm snapshot of the whole Earth's worth of data for some projects we're working on. I've spun up a large Ubuntu x64 ...
18
votes
1answer
3k views

Comparison of geocoding solutions (such as Gisgraphy & PostGIS 2.0)

As I am sure many of you are aware, PostGIS has finally released Version 2.0 and included within this version they have also built a geocoder (see: http://postgis.net/docs/Extras.html). Although I ...
17
votes
6answers
3k views

How do I get started with GIS Servers on Amazon EC2?

Are there any tutorials, talks or presentations that discuss the use of EC2 or other cloud computing services to host GIS Servers? Has anyone had any experience in doing it with Amazon's EC2? How hard ...
14
votes
2answers
2k views

How can I merge/collapse nearby and parallel road lines (eg. a dual-carriageway) into one single line?

I have a shapefile from OSM which contains all the roads within a city. Larger roads (like dual-carriageways) seem to have 2 parallel lines. I'd like to collapse / combine those into 1 line so I can ...
13
votes
1answer
1k views

Identifying topological relationships using PostGIS

I'm trying to perform a basic typology analysis using PostGIS. My objective is to find any polygons that touch other polygons. To do this, I thought the ST_GetFaceEdges would work (reference). I want ...
8
votes
1answer
304 views

How can I transform polylines into points every n metres in PostGIS?

Question in pretty much the same as this, but I need to use PostGIS. I have a number of polylines, and want to trasform them into points every n metres along these lines. edit: Thanks a lot to ...
8
votes
2answers
2k views

What is the most common way of displaying geodata from Postgis on Leaflet?

For example, in my database I've some points with geographic coordinates. I want to display them on Leaflet JS layer. Which instruments should I use? Maybe there is some API...
8
votes
4answers
1k views

What is the best web editor and server for postgis?

I'm looking for a web editor (similar to openstreetmap) that works with an map Server (postGIS). This should permit edit and create new structures on map. What is the best option? Can you help me? ...
17
votes
2answers
1k views

Moving a PostGIS Installation

I have a simple question: I have a postGIS installation running on an old computer that I'd like to move. I spent a bunch of time playing with pg_dump and pg_dumpall without success. It seems the ...
12
votes
5answers
11k views

How to create PostGIS template?

I am following a tutorial to install pgrouting. However, I didn't get the part when it says Start pgAdmin and create a new database based on your PostGIS template Where can I get this postgis ...
12
votes
3answers
721 views

PgRouting - How to clip links when reaching max costs?

I have a polyline shapefile representing a road network and a second shapefile containing points. I would like to use PostGIS (presumably PgRouting) to identify sub-networks or service areas radiating ...
11
votes
1answer
592 views

Nearest Neighbor Grouped Selection in QGIS

OK - so I have an interesting problem I am trying to solve. I have a list containing over 100,000 points in lat/long format which I have imported into qgis. Now, what I am trying to do here is group ...
10
votes
2answers
5k 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, ...
8
votes
2answers
1k views

Version editing for Postgresql 9.2.4 / postGIS 2

Background: I am "building" a GIS with PostgreSQL 9.2.4 / PostGIS 2 as the database and QGIS 1.8.0 as the geographic application. There will be multiple users accessing, editing and viewing the data ...
8
votes
3answers
3k views

Editing PostGIS/GeoServer data via web?

I've got PostGIS installed and would like to create a web application to do some simple edits: Draw manually (over a Basemap) points, lines and polylines, using snapping points (points, end of ...
15
votes
3answers
1k views

Is there a CASE Tool for modelling spatial databases?

Does anyone knows if there is a CASE Tool that would be possible for modelling spatial tables? I need to create a model and export it to SQL or a database directly. I´m using PostGIS. Thanks in ...
13
votes
3answers
1k views

Visualization of 3D shapefiles with Mapserver and Postgis

I'm wondering is there a way to visualize 3d data with mapserver? 3D .shp files are in postgis database, and I already connected mapserver to database, but with simple layer in mapfile.
10
votes
2answers
474 views

How to identify and simplify point clusters with regard to time in PostGIS?

I just started to work with spatial databases and I want to write a SQL(PostGIS) query for automatic generalizing of raw GPS-tracks (with fixed tracking frequency). The first thing I am wokring on is ...
10
votes
6answers
2k views

Should I use a CMS for my web mapping application?

For my web mapping app, I am using GeoServer as server, PostGIS as spatial DB and OpenLayers on client side (as well as other JS libraries). The map is composed of base maps and vector layers. One of ...
9
votes
2answers
4k views

What is the best way to do reverse geocoding with PostGIS?

Is there a way to do reverse geocoding with PostGIS? There's a lot of information on the Web but I found it very confusing... I have imported osm data into my own Postgres with PostGIS database. Now ...
8
votes
2answers
563 views

PostGIS Intermittent INDEX Performance

I have a table containing approximately 55 million data points ( point is a geometry with SRID 4326 ) and for my query I need to join this to an area table ( currently have ~1800 areas ) which ...
5
votes
4answers
823 views

How to merge close points into polygon?

I have a set of coordinates (points & no overlaps) in a single table,each containing attribute number fields,like in the following image. I want to merge these points into smallest polygons by ...
5
votes
2answers
2k views

How to implement Spatial Autocorrelation using QGIS or PostgreSQL (or any free application)?

I am a total newbie on the GIS scene so I hope this is not a stupid question. I have two layers in a PostgreSQL database. The first layer contains points where events happened in Europe. The second ...
3
votes
1answer
2k views

How to find the nearest point projected on the road network?

I would like to know if there is a function at pgRouting that given a point (lon/lat) can give you the projection of that point to the road network . Thanks in advance john
14
votes
2answers
4k views

What are hardware requirements for a cloud hosted PostGIS & GeoServer?

I have been playing with a local installation of PostGIS & GeoServer. I would like to move my work online now to share it with several collaborators. The proof of the concept map will consist of ...
12
votes
2answers
643 views

PostGIS interpolation / triangulation options

I'm looking for an open source workflow to automate DEM construction. We have a series of sites that fall within a LIDAR dataset. We want to create site specific DEM's for each site, and we're ...
9
votes
2answers
568 views

Are there Desktop GIS alternatives to ArcGIS 10.X for topology and vector conflation?

Is there any options other than ArcGIS for Desktop for topological rules and automatic topology integrity enforcing in a Desktop GIS? I am looking for something that will automatically snap features ...
9
votes
3answers
1k views

How to populate an undirected graph from PostGIS?

This question is more related to resources that I might not have identified yet, although I've been searching the web for a while. In the project I'm working at the moment I need to run a ...
8
votes
1answer
812 views

Is it possible to geocode street intersections using Nominatim?

Is it possible to geocode the location of a street intersection using Nominatim? Example geocode query Commonwealth Ave at Washington Street, Boston, MA Successful Geocode by Google ...