2
votes
4answers
86 views

How to assign geometry to records in a table that contain an ID of a geometry point?

We are looking to map out 'incidents' at schools, but the incident table, which contains a few thousand records, only has a school number (plus the incident data). The table format is an Excel ...
0
votes
0answers
26 views

Search an attribute and highlight corresponding polygon from a “joined-in” layer [QGIS/PostGIS]

Using QGIS 1.8.0, Postgis 2.1.0, and still new to all that. As the headline points out, I have a list of samples, which are found within areas (no point (GPS) coordinates). With a search query I ...
4
votes
1answer
511 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 ...
6
votes
1answer
1k views

How to perform a spatial join of point and polygon layers in PostGIS?

I have a point dataset representing households that I want to associate with a parcel layer (i.e. assign its parcel_id). With ArcMap, I could spatially join the polygons to the points and specify that ...
1
vote
1answer
442 views

Enhance performance of a join query for mapnik using postgis

I use mapnik to render map with datasources from a postgis database. One query is a join on two table, one with a geometry (a polygon) and the other one with some fields I want to use for rendering. ...
5
votes
1answer
618 views

How to merge linestrings that don't touch based on common name?

I had a table of road line strings that contained duplicate road names with different geoms for different line segments. I extracted the duplicates to another table. I now want to join these segments ...
6
votes
2answers
859 views

Difference between two layers in PostGIS

What is the right way to calculate the difference between two layers? I tried to use the following approach: SELECT ST_Difference(river.geom, lakes.geom) FROM river LEFT JOIN lakes ON ...