A command used to retrieve information from a database
1
vote
2answers
53 views
Merge lines with the same 'name' attribute on QGIS?
I have a shapefile with a few thousand lines, each is a street segment. I'd like to merge all features with the same 'streetName' attribute into a single attribute. I only really care about the name ...
1
vote
1answer
30 views
Why does ArcGIS Server not return data when querying joined fields?
I've been trying to help troubleshoot an issue that is very strange, and I think we've boiled it down to an issue with ArcGIS Server.
We have a map service that shows up in the services directory as:
...
1
vote
1answer
14 views
Why do I suddenly get 'ERROR' as elements in my attribute table after doing a query in QGIS?
I was looking at an .osm file in QGIS using the OSM plugin; I was specifically looking at a country's lines layer. When I checked the attribute table just after opening the .osm, everything looked ...
2
votes
1answer
68 views
How can you tell if a RDBMS is an ArcSDE Geodatabase?
I want to know if there is any way I can query the RDBMS to determine whether it is an ArcSDE Geodatabase, or if I have to do it through ArcObjects. I am wondering if it would be enough to check if ...
0
votes
0answers
9 views
Spatial query without spatial database module
I have the following scenario:
Oracle database without the space module.
Application in JEE2 with the following architecture:
-- Entity
-- Persistence (DAO / JPA + JDBC)
-- Business (BC)
-- Vision ...
1
vote
1answer
34 views
How to speed up spatialite-query using spatialindex?
I have got 2 tables, one of type LineLayer called strlayer, the other one is a PolygonLayer called blayer. The LineLayer contains two rows called fromBland and toBland that should be filled with an ...
1
vote
0answers
27 views
ArcObjects: How to Speedup Spatial Query to Feature Layer?
I have ROAD (POLYLINE) Shape File with more than 400,000 Records. I am working on a code which goes like this:
Loop through all Feature of the Shape File
Take First Feature
Find the LAST VERTEX of ...
0
votes
2answers
34 views
oracle search against intersect of a region that covers the whole world doesnt find any records
I am new to Oracle Spatial, I am trying to implement a service that will take coordinates from a map, and search our database to find any geometries that intersect with that map view. I works fine for ...
0
votes
0answers
16 views
SQL Query Remove Multiple Attributes
I'd like to query a street layer by the ownership of the street (State County etc). I know I can do
"Road_Auth" <> 'IL' or "Road_Auth" <> 'Kane' and so on. This question Select by ...
0
votes
1answer
48 views
A couple GeoExplorer questions
I just started working with the OpenGeo Suite. I'd really like to use it for a County web map, but have a couple questions...
1) Is there a way to add a lat/lon or other X/Y location to the URL and ...
2
votes
2answers
77 views
Select by Attributes - If string has a letter
I'm running ArcMap 10.1.
I'm using a File Geodatabase.
I have a string coordinate field that I want to clean and some records have letters in it (mostly 'N' or 'E' or 'n' or 'e' e.g. '6213210N' or ...
1
vote
1answer
38 views
IQueryFilter where Clause quering two feature class at a time
I need to query two feature class at the same time using IQueryFIlter.
For eg -
FeatureClass -- A has field OBJECTID
FeatureClass -- B has field OBJECTID
what i am tring to do is --
IQueryFilter ...
1
vote
2answers
48 views
Find the majority area within another area
I have a survey grid overlaid unto several administrative areas. Both are polygon features and I have performed a union on both features in order to determine the areal contribution of the segments ...
0
votes
1answer
49 views
Circles created by points inside bounding box query - PostGIS
The table that i want to perform this query has 3 columns: id, the_geom and seen_count.
The query i've been using to get points inside a bounding box is as follows:
SELECT id, ST_AsGeoJSON(the_geom) ...
0
votes
2answers
44 views
ST_DWithin uses Geometry or Geography type
assuming I use the following query to match the locations to a poi within 10km distance:
SELECT
poi.poi_id,
h.loc_id,
(ST_Distance(poi.geom,h.geom)*111.111) as distanceinkm
FROM iut_poi_transl AS ...
0
votes
1answer
53 views
How to select all cities in Germany from city and country layer?
I have 2 layers: layer_1: countries of europe, layer_2: cities of europe
I want to create (and then save) a layer_3 which would be all the cities of Germany.
Is there any good tutorial of how can i ...
1
vote
1answer
57 views
Why isn't my select by attributes query working?
I'm running ArcMap 10.1.
I have a point feature class joined to a table and am trying to query a field.
If I do [field] = 'TEST', it selects all the fields.
But if I do [field] LIKE 'TES%', it ...
0
votes
0answers
28 views
ArcGIS server 10 web adf query attributes task results sorting
I'm fairly new to web mapping and my company uses ArcGIS server 10 web ADF.
I've used 'query attribute' task and given the list of data to select from. Now I was asked if I could sort those results ...
2
votes
1answer
70 views
Help building SQL query to get a list of streets of a city
From two layers in PostGIS (osm_places and osm_roads), I would need to have the roads belonging to a certain city.
It would be fair enough to get the street names of all streets in a radius of X ...
2
votes
3answers
73 views
How can I export or query all hospitals from Open Street Map?
I'd like to extract all the hospital locations in the US from Open Street Map as a reference for my geocoding project. I know how to get all the OSM data for a small area with the QGIS plugin but not ...
2
votes
0answers
93 views
Select features within a country or bounding box effectively using PostGIS
I imported the planet OSM file into a PostgreSQL 9.2/PostGIS 1.5 server using osm2pgsql. I now want to select certain map features which lie within the bounding box formed by a countries borders, e.g. ...
1
vote
1answer
42 views
For each polygon, return yes/no value if it intersects another layer
I have a polygon grid overlaying several other polygon vectors. I wish to visit each polygon in the grid and ask yes/no if each of these layers fall within the grid cell or not. I can do this easily ...
0
votes
2answers
57 views
PostGIS, distance between two users
I have a simple table (location_test) with three column (name, geom , jid). geom is a geometry column with SRID 27700. I set the user's geometry position with:
UPDATE location_test SET geom = ...
2
votes
2answers
115 views
Built a query for polygon Shapefile in R
I use the package maptools to read in Shapefiles in R. I would like to know if there is a function that can built up a query/subset to select only some Polygons based on a specific attribute in the ...
3
votes
2answers
57 views
How to query for a specific point, within a specific polygon?
I have a shapefile points layer, with each point representing either Marginal, suboptimal, or optimal conditions. I want to find only the marginal points within a specific polygon from my catchments ...
2
votes
1answer
69 views
Merge attribute data using spatial query in QGIS
I have 2 vector layers that I wish to correlate attributes - a shape file containing boundary polygons and a shape file containing point locations.
I'm using the vector>spatial query tool to generate ...
3
votes
1answer
87 views
Filter contour lines in QGIS
I have a shapefile of contour lines, with an ALTITUDE attribute with the height ASL in metres. The source data is in 0.5m intervals, but I'd like to filter it down so I get contour lines at (for eg.) ...
1
vote
2answers
87 views
What are the options for working around the max number of records returned for a query task on ArcGIS Server 9.3.1?
I'm trying to return polygon features that intersect a larger polygon which defines my area of interest. It is working in some cases, but when the area of interest gets large (7000 intersecting ...
1
vote
1answer
114 views
Querytask/query - executed select
Is there a way to get to the query condition, which is executed under the querytask ?
I have an example, which is actually a copy of this ArcGIS example ...
1
vote
1answer
92 views
How can I change SQL query through a layer of an action (python)?
I have three layers from three diferent database tables.
When I click in other layer I want to change (with an action) the query of that three layers.
How can I do that?
Thank you
2
votes
3answers
136 views
Creating a where clause from user input/Python list
I am trying to perform a query based on values in a Python list. The where clause will then be used in an Update Cursor, so that the rows NOT equal to the values in the list will be deleted.
This is ...
2
votes
1answer
155 views
Reading OGC geometry data from SQL server using R
I would like to write a script in R that creates a map using OGC geometry data that is stored on a Microsoft SQL server. Is there a way to read OGC geometry data using a query passed from R?
Maybe ...
0
votes
1answer
77 views
In QGIS can I show just the lines in a Postgis query? How can I do that?
I have three tables in Postgresql, each table with one layer of lines.
I want to show the path of an initial line to another final. Is it possible executing a SQL query?
Thanks
My three tables are ...
3
votes
1answer
131 views
How to Find points in a Kilometre radius
I am new to PostGIS and GeoData.
I need to find where the lightning has stroke by a period of time and kilometre radius based on a given location.
I have given lon/lat and my table is:
latitude ...
1
vote
1answer
74 views
How to get the nearest line to a feature?
I have features on map, and i want to get the nearest poly-line to each one.
How to write spatial query to get the nearest one.
I tried to use ISpatialFilter but i couldn't reach anything.
4
votes
1answer
198 views
How to speed up an st_intersects() query?
I have a "huge" spatial database: 72GB, 200 millions documents with geometries (points)
I have a GIST index on the geometries
the database:
CREATE TABLE resources
(
id bigint NOT NULL,
accuracy ...
1
vote
2answers
138 views
Selecting lines occupying identical positions in MapInfo or QGIS
I have two shapefiles from a client, one is their entire network (complete with unique IDs) and another a selection I need. However the selection file does not have unique IDs but the entire one does. ...
1
vote
0answers
230 views
ArcGIS API Javascript - FeatureLayer from json: problem with queries and popup
Hello everybody
I've tried this code proposed by Derek Swingley in JSFIDDLE:
JSFIDDLE-FeatureLayer from JSON
Everything "seems" to work fine, but not always. If you go down to the closer scale (level ...
0
votes
0answers
28 views
Isolate And Save Raster Features From Existing Multivalue Raster Map
I have Cyprus Corine map with 44 different types of land use.
I want to run a raster calculator query or any other way to isolate the areas with codes 10 to 22 and 26 to 34, all other values 1 to 44 ...
1
vote
1answer
60 views
How to get routes in the database that intersects circle?
I have routes (linestrings) recorded in the database. I want to create a query which returns the routes that have some commonality with a circle whose center and radius are passed as parameter.
I ...
3
votes
1answer
344 views
How can I more efficiently select related records?
Below is the code I'm using to replicate the "related tables" button in ArcMap. In ArcMap that button selects features in one feature class or table based on the selection of features in another ...
1
vote
0answers
110 views
Query to find lat/lon of a house by street.name & house.number
How can I get house coordinates (latitude, longitude) by street.name and house.number? If it is possible, how I can get it?
Many thanks!
4
votes
3answers
425 views
How to join two tables using date, time, lat and lon as common field?
I am sorry if the question is elementary but I did not find any clear discussion or guide to understand how to run a query in postgresql. So that a pointer to another website would be also useful. ...
7
votes
3answers
434 views
How to query all records (>1000) and export to csv?
I posted in arcgis forum but never got any answer.
Can anyone tell me how to solve this?
Assume you have a vehicle tracking records from Oct.1 to Dec. 31 with wind speed information.
All data is ...
2
votes
1answer
99 views
How to best execute the same query on many different vector layers?
I have some vector layers in my project and I need to separate the polygones by area (I need a copy of all shapes > 2ha). I know how to do this for each separate layer (query) but is the a tool to do ...
5
votes
2answers
441 views
How do I use QGIS python console to iterate through simple layer queries and png outputs?
I'm really new to QGIS coding and I'm having a hard time finding (especially) the api classes/functions to carry out actions of the Query Builder window.
I'm basically trying to do this:
Iterate ...
3
votes
1answer
124 views
How to filter layer of osm data?
I have a table osm_roads that has a column named geometry geometry geometry(LineString,900913).
If I want to filter a city to draw districts, I cannot do it by geographic coordinates?
What if in ...
1
vote
1answer
245 views
How to save WMS getFeatureInfo points to a layer?
This may be a poorly worded question, because I am not sure of the exact terminology, but I'll give it a shot.
I have imported a vector layer from a WMS server into QGIS. I am able to query the ...
5
votes
2answers
217 views
PostgreSql query problem with aggregate functions
I need help with a PostgreSql query. I need to find all parcels which have bigger area then average. I'm using this query:
SELECT OBJECTID
FROM parcela
WHERE ST_Area(geom)<(SELECT ...
4
votes
1answer
326 views
Querying Data with a 1-Many Relationship Class
I have created a relationship class similar to the one I posted about in this question.
Essentially, there is a point feature class representing a location of vegetation clearing with attributes ...
