5
votes
2answers
60 views

How to select random adjacent census tract

I have set of census tracts spaced out across a city and I would like to randomly choose an adjacent census tract to explore nearby demographic data. I'm not sure if there is an easy process for ...
2
votes
2answers
66 views

How do I select Census Block Groups inside a Zip code?

Long time listener, first time caller. I already have my data imported, problem is my SELECT statements aren't yielding the results I'm looking for. I specifically need all the Block Group ...
0
votes
0answers
35 views

Consult the charts of a line

I have a table of bus lines and other bus stops in PostGIS. Are conformed to the image below, the lines and the stops on the sides. I want to relate the lines with parades through a spatial query. ...
1
vote
0answers
22 views

How to perform a join on simultaneous spatial and attribute criteria in PostGIS [duplicate]

Possible Duplicate: How to perform a join on simultaneous spatial and attribute criteria in ArcGIS? I have two point layers and want to perform a spatial join on nearest distance. I have a ...
5
votes
1answer
380 views

How can you join attributes from polygons to points which are within the polygon feature using PostgreSQL and PostGIS? [duplicate]

Possible Duplicate: How to perform a spatial join of point and polygon layers in PostGIS? I don't know how to solve my actual problem. I have polygons and points (some points are located ...
6
votes
2answers
211 views

Join multiple spatial tables by distance

I'm trying to join two tables, one which contains road names and the other just a point. After exhausting research I'm now stuck. The idea is to join up the two tables using only distance, ie, select ...