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

learn more… | top users | synonyms

3
votes
1answer
3k views

How to filter features in a layer?

I am trying to display certain features in a shapefile-based layer using QGIS. I have found the subset function in the properties panel, which does exactly what i want, but is too tedious given that I ...
3
votes
1answer
503 views

Making calls the PostGIS functions with Java

We have Java stored procedure in Oracle that make calls to functions offered by Oracle Spatial to perform spatial analysis and return results. I am looking to the same in PostGIS, is this possible?
4
votes
1answer
614 views

Spatial Join in PostGIS according to Line Attribute

I am in the process of building a data warehouse in PostGIS, that will store the length of the road network of a country (Lines) per Administrative Area (i.e. Province or State, referred to as AA ...
8
votes
2answers
591 views

How to speed up space partitioning in postgis?

I've a bunch of overlapping polygons and I'm trying to partition the space to avoid having overlapping ones. I think my problem is fairly simple. Using some ESRI product and ...
15
votes
4answers
11k views

Select bounding box using postgis

I want to create a query to select all ways and their nodes that exist within a bounding box using postGIS. The bounding box shall includes all details as osmosis "--bounding-box" command will ...
3
votes
2answers
658 views

How to determine Parcel Neighbors?

i like to get the neighbors of the Parcels "P1" like following : From B1 to B2 => P5 B2 => P4 From B2 to B3 => P3 From B3 to B4 => P2 From B4 to B1 => P6 i like to make this process automatic ...
1
vote
1answer
664 views

Generating nodes where edges meet, PostGIS, pgRouting

Recently I was doing some research on how to assign nodes (as POINT type geometry) to existing edges of a topology network and store them in a different table. Call it nodes table. I have all the ...
5
votes
1answer
1k views

Count points inside polygons using PostGIS

I have 2 vector data in my Postgis DB: one is a point layer (punti) with about 200000 elements and the other is a polygon (province) with 4 elements. They cover the same area and I need to find the ...
26
votes
3answers
9k views

How to make a spatial view in PostGIS and add it as a layer in QGIS?

In PostGIS 2.0, what is the most efficient way to create a spatially enabled view that is viewable in QGIS? I followed the context of Part 2 of @Mike Toews answer to this question, and the view ...
5
votes
1answer
1k views

grib2 to raster? (grib2 -> raster2pgsql -> PostGIS 2.0 -> GeoServer)

I'm looking to implement import of US National Weather Service data for doing various sorts of models (www.soils.wisc.edu/uwex_agwx if you're curious about what we're doing with the data). The ...
14
votes
4answers
2k views

The best language to program with GDAL

I'm going to start to create programs to handle geographical data from a PostGIS server, and going to use GDAL. According to your experience, with the best language to program with it? I can program ...
2
votes
0answers
97 views

network related issues arising when running an arcpy script

Essentially I wrote an arcpy script that is within a toolbox that I ported over to a different machine to test out after the script worked locally. The script essentially utilizes the psycopg module ...
8
votes
1answer
4k views

How to create a table from existing tables (applying new schemas) in postgis DB?

I have a table that is geospatially enabled; that contain world borders. I want to break it down to different schemas (global, europe etc..) . My thought is to use use something that looks like this: ...
1
vote
1answer
84 views

Filegeodatabase fanout and Python problem

I have fme wb which does fanout with gdb. It means that in the end as output sets of data I get few new created gdb. But If I start this fme wb within python script It does not do fanout. Just write ...
3
votes
3answers
985 views

Adding shapefile directly to geoserver

I have py script which is creating shapefiles using shapefile.py. Once the shapefile is created I have to add them manually to the geoserver. Is there a way to add it dynamically to the geoserver? ...
0
votes
3answers
2k views

Unable to Import Data

I am following this tutorial, but i am not able to get the right username and password to import data. How do I know what the username password is? By default I see tomcat6 as database and username ...
2
votes
4answers
505 views

Any pgrouting enabled hosting providers?

I am really interested if any of you know about a hosting provider that offers postgis & pgrouting pre-installed? If not, can I just go ahead and purchase a linode hosting account and do all the ...
6
votes
2answers
1k views

Options for PostGIS and Mapserver outputing SVG, and client with OpenLayers

This question is related to "Options for displaying PostGIS vectors in OpenLayers?", but I need SVG output on server. OpenLayers must render SVG directly. We are using Mapserver6, and thinking on WFS ...
3
votes
3answers
555 views

Which open source software to create desktop interface for Geo-processing tools?

I want to create an desktop interface to create geo-processing tool and that to using Open source GIS software. I will be using Postgresql and postgis too to save and retrieve data for operations. I ...
4
votes
2answers
1k views

Beginner needs suggestions on map clicks and geojson

I'm a beginner with programming, and javascript. I went to the FOSS4G-NA conference and was very inspired to learn more. I'm trying to learn PostGIS, and have come across a very useful tutorial for ...
5
votes
1answer
454 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 ...
0
votes
1answer
514 views

Changes made using wfs-t and GeoExt don't get saved to PostGIS

I'm using GeoExt to display and edit a vector layer from GeoServer (running with Apache Tomcat) but if I modify the shape of an existing polygon (or create a new one but I'm trying not to leap ahead ...
2
votes
2answers
616 views

LonLat Points to Grid of Polygons in PostGIS

I'm going to preface this with it's my first time using PostGIS. I'm starting out with a 5 km x 5 km grid cell in which I know the center point lon/lat (SRID=4326). I'm trying to create a polygon for ...
13
votes
2answers
2k views

How to calculate the angle at which two lines intersect in PostGIS?

I want to calculate the angle between two lines where they intersect in PostGIS. The starting point for angle calculations in PostGIS seems to be ST_Azimuth - but that takes points as input. My first ...
5
votes
1answer
713 views

How to find the two furthest points between a group of points?

I have a table with 20000 records and with those columns Shop, longitude, latitude, geom I would like to find a way to find the pair of ths farthest shops between a selection of shops For example we ...
6
votes
1answer
142 views

Interactive geographic region definitions

Background An organization has regions within a province, but has no list of coordinates that define region boundaries. I would like to draw custom polygon areas on a map using a web-based and ...
1
vote
1answer
156 views

Is it possible to use assign_vertex_id() POLYGONs?

I'm trying to use pgrouting in order to create a graphe and I have two questions : Is it possible to use the function assign_vertex_id() with a POLYGON geometry type? I always have the following ...
2
votes
1answer
837 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: ...
4
votes
1answer
560 views

Using group by to set a PostGIS datasource using QGIS Python API

I am writing a QGIS Plugin and wish to obtain data from a PostGIS table using the Group By clause using something like the following code: uri = QgsDataSourceURI() uri.setConnection('localhost', ...
1
vote
0answers
311 views

Add building height from xyz points in PostGIS

I have been trying to get this query right and just can' seem to. I have a building polygon table with over 7 million polygons, indexed I then have a grided height XYZ table with attribute 'height' ...
4
votes
1answer
732 views

remove duplicate points based on a specified distance

i have a table of points with each point acquired on a specified date, by a specified source, and having a measured value. i want to consider points as duplicates if they have the same date and if ...
0
votes
1answer
260 views

How to remove polygon under other one?

Hi, lets say that green polygon is under red and part of blue with yellow stripes is also under red polygon. how can i make one polygon from every polygons that intersects my main ( red ) polygon ...
0
votes
1answer
1k views

Adding MySQL to Geoserver for Non-Spatial Data

I need to connect to a MySql table, which has all the attribute values and the lat & long. I am using a GeoServer Suite to host my raster and so felt the best way to go about it would be to add ...
-1
votes
0answers
46 views

Determine the Closest road to a GPS point [duplicate]

Possible Duplicate: Calculate distance of point from an arc/polyline I have been trying to find the road to which a GPS point is closest to. I have a postGIS database which i loaded with ...
8
votes
1answer
2k views

Postgis - Converting 'geometry_dump' data type to a 'geometry' type

I am working with a dataset of property boundaries that has had ST_Union() run on it, thus all the polygons appear as a multi polygon in one row of a table. I would like to separate these out so I get ...
3
votes
2answers
756 views

Merging polygons that intersect by more than a specified amount

I am working with a dataset that contains a subset of property boundaries in a local government area, thus my dataset is made up of several thousand properties but not all are touching. Since it is a ...
6
votes
1answer
170 views

PostGIS ERROR: BOOM! Could not generate outside point!

This may be a continuation of a closed thread. I want to sum the areas of polygons over categories in a large data set (avian species ranges), like this: select sciname, ...
4
votes
4answers
3k views

Calculate distance of point from an arc/polyline

Using Postgres/PostGIS, I am trying to query the database for the closest arc to a particular GPS point. Each Arc is made up of two nodes that are GPS points on a map. Is there a way I could query ...
3
votes
1answer
205 views

How to query latitudinal bounds on 95% of a polygon in PostGIS?

I'm going to say thanks in advance. I'm very new to GIS and this forum is a tremendous help. My simple questions have been solved; here's one that might be a little trickier. Given a polygon in a ...
21
votes
2answers
6k views

Looking for fastest solution for Point in Polygon analysis of 200 million points

Apologies for asking a question that has been asked before -- I've read through answers, and I'm left wondering how to implement the recommendations. I've never used SQL, Python, C, and have only ...
0
votes
2answers
2k views

How to insert a point into postgis from php?

For the following line, I received an error in my php page, but the query is OK when I run it from pgmyadmin. I am trying to insert a point into my postgis from php which contains name, address and ...
3
votes
2answers
2k views

How to query aggregate max, min, median latitude of polygons in PostGIS?

I am just starting to learn how to use PostGIS (1.5.4) and my SQL skills are essentially those of a competent beginner. Having perused the PostGIS documentation and searched these forums, I'm not ...
5
votes
4answers
2k views

OSM To Postgis & WGS84 problems

I’m trying to import OpenStreetMap (OSM) data into postGIS it doesn’t appear to be working in that features do not appear to be in the correct place.. Using the QGIS OSM add in and a coastal shape ...
1
vote
1answer
4k views

Google Maps MarkerClusterer - Remove all clusters

So, I have a PostGreSQL DB with 317 datapoints - all spatially enabled through PostGIS. I have queried this using PHP as GeoJSON and overlaid it on Google Maps (using a converting routine). I have ...
13
votes
2answers
30k views

How to insert a point into postgis?

I have created one table in my Postgis. But I can not insert point. I do not know what's wrong with my query? CREATE TABLE app ( p_id INTEGER PRIMARY KEY ); SELECT ...
4
votes
2answers
348 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 ...
2
votes
2answers
642 views

How to create hibernate layers at runtime?

We need to dynamically create hibernate layers from shapefiles. As far as we understand, the workflow is following: Import shapefile to database(creating new table for each shapefile?) Is it good ...
4
votes
2answers
5k views

Struggling with enabling a PostGIS database on Mac

I have installed PostGIS on the mac using the binaries available on http://www.kyngchaos.com/software:postgres Postgres v 9.1.3 PostGIS v 2.0 After that I want to enable postgis for my database. I ...
6
votes
3answers
1k views

Large Open Street Map OSM file to Shapefile. Is there any hope for 32-bit FME?

I have a large OSM XML file (around 8 GB) that I was hoping to process in FME. I have a workbench that I previously used to process smaller files (500 MB) into feature type-specific Shapefiles (e.g. ...
2
votes
1answer
3k views

KML PHP parser to INSERT into database

So I have a KML file which has attribute data(Inside the tag with about 12 data points). This file was generated on ArcGIS. I'm trying to write a PHP script to parse this KML file and insert the ...