A command used to retrieve information from a database

learn more… | top users | synonyms

0
votes
1answer
2k views

Query Feature using OpenLayers + MapServer

I'm trying to query a feature in OpenLayers, but it's returning just an image highlighted that is not possible to make zoom, pan and drag. My intention is to query a feature on the map like street ...
2
votes
1answer
829 views

troubles with osm2pgrouting

I'm trying desperately to write my first query in pgRouting using maps in osm format (as shown in http://www.carsonfarmer.com/?p=799). Im using Ubuntu 10.10 with Postgresql 8.4 ang postgis 1.5. After ...
8
votes
1answer
661 views

ST_ClosestPoint(line, point) does not intersect line

In my PostGIS database (PostGIS 1.5 on Postgres 8.4.1), I have two tables: roads (composed of linestrings) and crashes (composed of points). I've been trying to correlate each crash to a road, but I'm ...
0
votes
2answers
982 views

QGis import partial PostGIS layer using query builder

I'm sorry, but I'm terribly new to the GIS scene (and PostGIS & QGis). I have loaded a whole bunch of OpenStreetMap data into a PostGIS database and successfully drawn a map using Mapnik. Now I ...
0
votes
3answers
4k views

Defining a Query with Multiple Values

I have been trying by best to create a definition query which would select a group of municipalities from among the many in my state. I have tried commands of all sorts of variations from ...
5
votes
2answers
396 views

Query a georss feed

I'm trying to consume a georss feed from a C# project. Can I have queries against a #georss feed? For example 'nearest item to Lon/Lat' or 'items contained in bounding box X' .? Thanks
1
vote
1answer
626 views

ArcGIS Server 10 - Query numeric field with string

In ArcGIS Server 10, I am running queries against several fields in a feature class. All of them are sent with the format FIELDNAME ='value' (all queries contain the single quotes). This is ...