A query for geometric features based on their spatial relationship.

learn more… | top users | synonyms

0
votes
0answers
6 views

send attribute from 75,000 object polygon to 20Mil point database

I have sql server 2008 r2. I have two tables: PropertyParameters and REF_GEOID. Property Parameters has four columns: PropertyID, ParcelID, Lat, Long. REF_GEOID has two: GEOID and GEOM. GEOM is a ...
1
vote
0answers
13 views

Help with sub-queries postgres

I wish to ask for some advice when it comes to build nested spatial expressions in postgres. I end up with the same kind of problem many times when it comes to select more than one type of geometry. ...
0
votes
0answers
29 views

Find hotspot with highest density for two objects

I'm using PostgreSQL/PostGIS and I have an advanced type of query. My database contains two types of objects - let's say homes and crime. Is there a way that I can find the area with the densest ...
4
votes
1answer
65 views

PostGIS: Strategy for fastest select by BBox with an ORDER BY polygon area clause. Cluster?

Update 2 (below) suggests 14% of the table geometries are stored out-of-line with the rest of the table records. This may be a useful clue. The Problem: We've got a table with appx 170,000 WGS84 ...
0
votes
1answer
42 views

ArcGIS Javascript Spatial Query with Lat Lng or X Y?

I am using Google Maps on the front end as all I need on this view is to show the points. When user clicks on the map in the view, it selects a point hence giving out lat and lng. I am trying to use ...
0
votes
2answers
172 views

Extracting data from four intersecting polygon layers in PostGIS

I've been using the following code in Postgres/PostGIS for the last year, as needed, which is about once a quarter. It works ok, it's just that it takes days to run. With over 25,000 parcels making up ...
4
votes
0answers
87 views

MapInfo “Boundary Select”, “Sum Attributes”, and “Update Column by Spatial Query” in QGIS?

I´m a MapInfo user, I´ve gone over to QGIS and it´s got a lot going for it, except for some "missing" simple features from MapInfo I just can´t do without.... MapInfo Boundary Select - spatial query ...
1
vote
1answer
150 views

PostGIS ST within does not exist

I'm quite new to postgresql and postgis so this error will probably due to some rookie mistake. I want to run the spatial query ST_within. When I describe the query like this SELECT nw.entity_id AS ...
1
vote
0answers
26 views

Select a polygon which is just partly member of another polygon with its area of the other polygon

I need to generate random points within geometries, which works quite good, but there are some small errors. Take the picture below. There are some greenish and redish Polygons(?!) which do not have ...
6
votes
2answers
404 views

Find start of river

Edit: Follow-up question here (= Find headwater polygons). How can I determine the start of a river in PostGIS? I have a river network (Multiline) and want to find the startpoints of the rivers. ...
0
votes
1answer
48 views

How to show a map with queries from a map file connected to postgres in browser using javascript?

So, the problem is how to show a map in browser using javascript? I have a map file with 2 layers in it: "peta" is a shp data from postgis and "korban" is a numeric data from postgresql. And then I ...
0
votes
0answers
67 views

Query tool option missing in publishing maps with geoexplorer

I want visitors to a website with a published map created by Opengeo Geoexplorer to query the layer (layers, if possible) it contained. I am able to use the query tool while composing my map within ...
1
vote
0answers
81 views

I have WIKI VGI Java based query doubts?

I have a code snippet in Java to query wiki volunteered GIS. This is first time I am using java and finding it difficult to answer some queries. package org.wikibrain.cookbook.MOOC; import ...
11
votes
2answers
153 views

Identify points in a shapefile that have no other point within x km with QGIS

This is probably a naive question but I am struggling as a new user to QGIS. I have a very large shapefile (275,000 points, but can break this into about 10 subregions if necessary for faster ...
2
votes
1answer
90 views

Get feature data from lat long input QGIS

In QGIS, I have a polygon dataset with feature data. I would like to extract data from this dataset using a latitude and longitude. To be more clear, I have a list of 1000 coordinates. I would like ...
0
votes
1answer
74 views

How to run spatial query get fields value of 2 layers?

Last month I ask a question "vb.net arcobjects spatial query get fields value of desired layer only", url vb.net arcobjects spatial query get fields value of desired layer only. Now there is some ...
2
votes
2answers
361 views

drawing concentric circles in arcmap 10.1

I am using ArcMap 10.1 and I would like to know if there is a way to draw circles at a specific distance from a georeferenced coordinate. I have a property and I would like to know how far you can ...
1
vote
1answer
47 views

Spatial queries to find co-occurrences of POIs

Given a POI database containing different types of points, e.g. hospital and pharmacy, how can I select the locations where a hospital and a pharmacy are closer than a certain threshold (e.g. 1000m)? ...
5
votes
2answers
79 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
249 views

vb.net arcobjects spatial query get fields value of desired layer only

Currently I am using ArcObjects (10.2.1) in vb.net (vs 2012). What I intent to develop is a spatial query tool. There are 2 steps in the function: (1) Use "Select Features" tool in ArcMap to select ...
0
votes
1answer
158 views

How to count number of points/lines/polygons contained within a polygon, when the feature to count is from a server

I'm currently running a study where I need to query the number of points/lines/polygons that are contained within a project boundary - intersecting lines and polygons need to be counted as well. The ...
2
votes
1answer
49 views

How do you create a query that will result with the adjacent parcels?

I have a shapefile with parcel data, and I am trying to create a query that will render a list or something similar that will list adjacent parcels to a specific parcel. I want to be able to select ...
2
votes
1answer
145 views

How to get the width and height of a rectangular polygon in PostGIS

I have a table with point features saved in the my PostgreSQL database, and I can run the following query to get the extent of the point features and I turned the extent back into a geometry: SELECT ...
2
votes
1answer
237 views

QGIS/PostGIS: Select Counties within Region via Spatial Query

I'm using GQIS 2.2 and PostGIS on Postgresql 9.3. I have 5 regions in the contiguous United States. Each region has states, and each state has counties. I would like to think that the data I'm given ...
1
vote
2answers
103 views

how to do simple self join and touches function in postgis?

I am having trouble with this query and neighbor calculation in PostGis. I want to find out which are the neighbors of Sweden in the table COUNTRIES which has column 'the_geom' for geometry and ...
0
votes
1answer
150 views

How can I find the segment of a line that lies within a polygon using Postgis?

Given a "road", represented by a line, that crosses a "state", represented by a polygon: What is the SQL query I can use to find the segment of the road that is within the state? A concrete example. ...
0
votes
1answer
109 views

ST_Within from centroid of geometry

I am looking at doing a spatial query where I can find when the center of one feature falls within another. For example, when the center (centroid) of a building falls within a grid tile. I know I can ...
3
votes
1answer
833 views

Problem PostGIS Spatial Query ST_Contains ST_Disjoint ST_Intersects

I'm working on a project with two different tables inside a database. One contains points in a column geometry(Point,4326) type and the second one has a column geometry(MultiPolygon,4326). Now I would ...
1
vote
0answers
20 views

Count gaps between polygon in spatialite

I have a database (.db) with a table that contains thousands of polygons containing id and geometry. I like a query that can get me the 'number of errors where there are gaps between polygons". How ...
2
votes
2answers
118 views

Is it possible to run a spatial query in QGIS 2.0 across multiple layers using a user-specified radius from a point?

I would like to be able to click on a point on a map to select all vector features (from multiple layers) within a specified radius of the point. Can anyone point me in the direction of how to do this ...
1
vote
1answer
80 views

Problem with runing a loop in a query in PostGIS

I am new to PostGIS and I have a question which can't solve. I have a table of buildings each having a value for number of people living in it. I would like to calculate the total value (sum of number ...
0
votes
0answers
58 views

PoI Range query

I have a dataset of 100,000 PoIs represented by (id, name, longitude, latitude).. I would like to perform a large number (around 10,000) search operations on this dataset. each search operation ...
0
votes
1answer
118 views

How to run Spatial Query using ArcGIS for Desktop?

I have a shapefile of a forest inventory of the uk. I want to find out the total area of woodland within a 60km radius of a specific point. I have added a layer for the point and added a 60 km buffer. ...
1
vote
0answers
141 views

Find area with highest relative density of one type of object

I'm using PostgreSQL/PostGIS and I have an advanced type of query. My database contains two types of object - let's say pubs and churches :) Is there a way that I can find the area with the densest ...
7
votes
1answer
869 views

What is difference between ST_DWithin and ST_Distance for proximity search in PostGIS?

I have records stored in a table with latitude/longitude coordinates stored in a geometry field. I want to find all records nearby a user supplied reference point. Note "nearby" probably means less ...
1
vote
0answers
214 views

How to add a MSSQL spatial layer using Python?

I'm having difficulty adding a MSSQL spatial data layer using Python. The database is password protected, and I can add the layer without any problems using the built in feature, but I can't make it ...
3
votes
2answers
1k views

Postgis, get the points that are x meters near another point, in meters

I'm trying to find the points within a certain distance, in meters, from another point. I'm using the function ST_Buffer, but I don't get how to express the distance in meters. I'm trying with ...
3
votes
3answers
532 views

QGIS spatial join, calculating distance from polygon to point layer

I am trying to perform a kind of 'spatial join' in Arcgis, joining to a polygon layer atributes of the closest feature of a point layer, as well as distance. But 'spatial query' doesn't offer an ...
1
vote
2answers
145 views

geoprocessing across multiple vector layers QGIS2

I have 6 layers of point data (each layer is one year), where data in each layer are distributed throughout a grid, and the grid is identical in each layer. I'd like to extract data from each layer, ...
1
vote
2answers
211 views

Best way to figure out which regions a point is in a shape file?

I'm trying to figure out the best way on Android to figure out if a point in region as defined in a shapefile. For instance, I might want to know what country I'm in using the Geo Common's Shapefile ...
0
votes
1answer
404 views

PHP/MySQL, PostgreSQL spatial queries. Find a polygon that contains a coordinate? [closed]

I am building a non mapping javascript app and I am wanting to take a lat/long coordinate and query a MySQL table of polygons for the one that contains the point. I have looked into MySQL spatial ...
2
votes
1answer
1k views

spatial query st_contains postgis

This seems too simple to be asking this but I am really new to postgis/postgres have been going around in circles with this. I am performing a really simple spatial query where I would like to make a ...
0
votes
1answer
176 views

Spatial query without spatial database module?

I have the following scenario: Oracle database without the spatial module. Application in J2EE with the following architecture: -- Entity -- Persistence (DAO / JPA + JDBC) -- Business (BC) -- Vision ...