A command used to retrieve information from a database

learn more… | top users | synonyms

0
votes
0answers
4 views

Headwater polygons

This is a follow up question to this question. I have a river network (multiline) and some drainage polygons (see picture below). My goal is to select only the headwater polygons (green). With ...
5
votes
2answers
331 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
7 views

ST_AsLatLonText () rounded

I know this is a POSTGIS question… I set a field with UPDATE members SET latlong_degree = ST_AsLatLonText (the_geom) But the result is (for example) 48°37’41.742”N 9°17’55.716”E The seconds part ...
2
votes
2answers
34 views

QGIS keyboard shortcut to launch a 'Select by expression' query

I can't find if it is possible to launch a 'Select by expression' query (not to open the dialog) with a keyboard shortcut. I can't find this option in the Settings > Configure shortcuts list... If ...
2
votes
1answer
278 views

query / filter on attribute tables with external tables joined

i tried to do some queries on joiend table fields ... i've got/found some answers concerning version 1.8 - which result in "use select + export to create a combined dataset" so i just did some tests ...
3
votes
1answer
45 views

Cemetery Grave/Person Locator

I'm a mediocre to intermediate ArcGIS user. I have created several point shapefiles, one for each section of a national cemetery, roughly 200-600 points in each section in a grid. Attached to these ...
0
votes
1answer
717 views

How to make Stored Queries for WFS 2.0.0 in Geoserver

I am a new user of Geoserver. I have created a WFS and also could connect it with the QGIS WFS 2.0.0 Client plugin available now. But as like the default WFS link in that plugin I am not able to make ...
0
votes
1answer
319 views

SQL Geometry Query similar to Select by Centroid

Does anyone know if it's possible to query SQL geometry by something like 'centroid of polygon'...similar to ArcMap's select by location? I'm using SQL Server 2008 R2 as the DBMS. I have two polygon ...
2
votes
4answers
73 views

Postgis don't use spacial-index with st_intersects

I imported the data from openstreetmap using osm2pgsql and copied it another table structure. If I made a query for containing rows using st_intersects, st_contain or someone else, postgis don't use ...
0
votes
1answer
35 views

Write a query to find all geometries within a distance using ST_DWithin

I have written a query in PostGIS in which I use the ST_DWithin function to get the geometries which are located in a certain distance: SELECT images.path, focnetworkpart.__gid FROM images INNER ...
0
votes
0answers
35 views

Query does not work on joined file

Using QGIS 2.6.1 Brighton on an IMac (10.8.5). QGIS 1.8 Lisboa with exactly the same two vector shapefiles and the same CSV file works. I joined the file containing the polygons showing the features ...
0
votes
1answer
30 views

Connecting to ArcSDE with arcpy is slow (ArcSDESQLExecute)

I'm creating an API which will allow queries to be performed on my GeoDatabase. I'm using ArcSDESQLExecute to connect to ArcSDE (backed with an Oracle database). Creating the connection object is very ...
0
votes
0answers
29 views

PostGIS ST_Contains query return empty

Hopefully I explain this properly. I am trying to check if a route falls into another route I have greated. The route is saved as a linestring. My search query is: SELECT id FROM routes WHERE ...
4
votes
1answer
104 views

SQL-query in arcpy - SELECT WHERE feature between two values

I need to select features between two values in python with arcpy. However, whenever I try to run the code below, it returns with error message "An invalid SQL statement was used". whereclause = ...
0
votes
2answers
222 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 ...
1
vote
0answers
22 views

How to query a bunch of tables/feature classes which linked together by relationships

I have one feature class and 3 tables which linked together by relationship classes. The feature class, called "buildings", has the fellowing feilds: (1) FID: Feature ID and (2) ID: My own ID This ...
1
vote
1answer
188 views

Using database tables with bigint columns in ArcMap query layer

I am very new to GIS and am using the ArcMap 10 program. Currently, I am trying to set up a query layer from a remote database. I am able to connect to the database, but I am having trouble making ...
1
vote
1answer
215 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
1
vote
2answers
203 views

Using Qt Designer to Create a Form in QGIS that can search for a specific point in a layer

I would like to ask if you can create a form in Qt Designer to create a form that can search for a point on the map using data that the user will provide such as the Name. I am currently creating a ...
1
vote
1answer
36 views

SQL-Like Inner Join on IDs in Two Layers in QGIS

Using QGIS v2.6.0-Brighton. This question is not about editing layers geographically in anyway. It is merely trying to find data from two layers as you would in an SQL Query and append an extra ID to ...
9
votes
2answers
408 views

What is the precision of SELECT DISTINCT on PostGIS geometry column?

I wonder what the precision of the SELECT DISTINCT operator is on a PostGIS geometry. On my system, the following query gives me a count of 5, which means that the inserted points are considered equal ...
0
votes
0answers
34 views

single quote escape for arcgis server rest query

This might possibly belong in stack overflow so let me know if I I should go there instead. I'm trying to create a simple query using the arcgis rest api and javascript. I think my problem is with ...
0
votes
0answers
35 views

How to create a query dialog with MapBox JS?

I like to have a query dialog in the map in order to filter data according to specified fields and attributes selected by the user. Example: user may want to select a state via a dropdown menu and ...
1
vote
0answers
537 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
15 views

arcgis flex api queryTask only zoom to the target feature BUT without select the feature

I am using ArcGIS flex api queryTask to perform "select and zoom" feature(s), now I can zoom to the target feature, but it never select the feature. No idea what is missing in my code. The code is ...
1
vote
2answers
54 views

How can I calculate how many of a certain feature lie within my various buffer rings?

I am using ArcMap and I have a series of real estate parcels mapped along with a series of wind turbines. I have created multiple buffer rings around each real estate parcel with distances (0.5, 1, ...
0
votes
0answers
46 views

SQL Server : find Intersecting geometries with a geometry using sql query

I asked this question on parallel site (h++p://stackoverflow.com)and think this is a better place to ask such questions I want to find all geometries in a table that intersects with spacial geometry ...
1
vote
0answers
13 views

Using statisticdefintion in a querytask

I have a question about using QueryTask to accomplish to jobs: Identify unique value for a county in a graphics layer via mouseover. This unique county value (from a specified field) is used to ...
0
votes
0answers
28 views

How to save SQL-like WHERE as .qqf in QGIS 2.6?

I used to use QGIS 1.7.4. And there was "advanced search". I can save SQL where clause as .qqf. But I installed QGIS 2.6 and I cannot find this kind of things. Could you please teach me how to save ...
0
votes
0answers
27 views

Simple query not returning values

I have a super simple select by attribute query "Coefficient" = #, the #'s are 0, .2, .3, etc... to 1. The query will select some of the #s but not others. Example) when I query 0,1,.5 the attributes ...
1
vote
1answer
28 views

Why does my query not run since SRID are the same?

I am running this query: SELECT source,ST_AsText(ST_ClosestPoint(roads.geom,ST_GeomFromText('POINT(22.256 39.569)'))) FROM roads ORDER BY ST_Distance(roads.geom,ST_GeomFromText('POINT(22.256 ...
1
vote
2answers
81 views

How to visualize pgrouting result?

So I use this query SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_dijkstra(' SELECT gid AS id, source::integer, ...
0
votes
0answers
35 views

How to send parameter to mapfile from javascript with query to show map in browser?

I try to send parameter to mapfile but it's seem it didn't work very well. Can anyone help me find solution please? Here's my mapfile webgis.map MAP NAME "Banda_Aceh" SIZE 2000 900 UNITS dd ...
2
votes
1answer
81 views

Filter query error in QGIS2.4 or 2.6

I get this error when undertaking in query in QGIS2.4 or QGIS2.6: An error occurred when executing the query. The data provider said: OGR[3] error 1: Unrecognised field name ...
3
votes
1answer
596 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 ...
0
votes
1answer
43 views

SpatiaLite - WITH, view or sub-query?

I am running on Windows 8.1 SpatiaLite_gui 1.8.0, SpatiaLite version 4.2.0 and SQLite 3.8.5. I need to interrogate one single spatial table whith those attributes: ID | val | val_1 | val_2 | Geom ...
3
votes
1answer
100 views

How to snap a GPX-track to a road network?

I want to snap the GPX-track to the road network as the image below shows. I found out, that "Hausdorff Distance" is exactly what I need and that it is usable with PostGIS. But unfortunately I have no ...
0
votes
1answer
37 views

Spatial query to make view

I've got two tables which I want to combine and enrich with each others data. I'm getting stuck on the join part, as this needs to be done via a spatial query. First the table structure: a table with ...
0
votes
1answer
58 views

How to execute query based on previous query result and a field filter in arcgis flex api?

I'm trying to execute recursive queries and each one depend on the previous result. I'm looking for a method to use a filter field in the query execution based on the previous query result. Is this ...
0
votes
1answer
98 views

How to query all layers in ArcMap and get access to them by name or index?

I have next issue: I have ArcMap with tons of layers. Some of these layers may contain another layers with data (aka Composite layers) or they don't. The depth of composite layers in unknown. I need ...
2
votes
0answers
110 views

ArcGIS API for Silverlight : query that displays layer attributes in a dataGrid

I'm working with ArcGIS API for Silverlight to build a webmapping application and I'm trying to display my attributes in a datagrid. I made a try by using this code : void ...
1
vote
1answer
46 views

Using query in a while loop causing android application to freeze

I am having some troubles with the while loop + query. What I'm trying to do is track the user location (using onlocationChanged) and keep querying a FeatureLayer until the query returns a result and ...
3
votes
0answers
61 views

Postgis database query optimisation

I have a set of rasters in DTED format which I load into postgis database using raster2pgsql command line tool. Each of rasters is simply stored in a row and described by rid and a value of raster ...
1
vote
0answers
21 views

Geoexplorer - How to open query panel in a bigger window?

The query panel in Geoexplorer (displayed in lower left corner) is so narrow, that entering data in it may be cumbersome. How can i configure Geoexplorer to open this panel in a bigger window and ...
0
votes
2answers
56 views

OSM, Query for POIs in a building

How can I construct a query (for example for Overpass) for getting all buildings where inside the building is a node (for example a shop)? L.
0
votes
0answers
21 views

2.4.0-Chugiak PostgreSQL layer subset causes DB error

I have succesfully connected to pgsql layer. I got an error after trying to define feature subset in query builder. Can anybody help with this error? An error occurred when executing the query. ...
1
vote
1answer
512 views

Administrative level and coordinates from Yahoo GeoPlanet WOEID

The Yahoo GeoPlanet data can be freely downloaded from: http://developer.yahoo.com/geo/geoplanet/data/. If I understand it correctly, each WOEID corresponds to a unique location on earth, with ...
2
votes
0answers
19 views

Querying a shapefile and returning values?

I have a lot of experience making maps in ArcMap. I don't have much experience programming or working with APIs. Here's the (simple) problem: I create a shapefile of a region and then load the ...
8
votes
3answers
2k 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 ...
0
votes
1answer
63 views

GeoTools exception: failed to connect to EPSG database

I downloaded the GeoTools 11.2 binary and am attempting to get it to run in my Netbeans java application. I tried to run this part of code: ... SimpleFeatureSource source = ...