A command used to retrieve information from a database

learn more… | top users | synonyms

0
votes
0answers
41 views

How to work with SRID using PostGIS [duplicate]

I am using PostGIS with OSM Data from Geofabrik that covers the complete area of Austria. I am used to work with calissical longitude and latitude. If you enter Vienna, Austria in ...
0
votes
2answers
78 views

How to implement a radius search using PostGIS

I am very new to this topic and after a long time of research I didn't find a solution. I want a query that I can use on my PostGIS database performing a radiussearch.. I inserted the Open Street Map ...
0
votes
0answers
41 views

Syntax error drivingdistance

I am new in sql and i am trying to get that works a subquery with pgr_drivingdistance and pgr_pointsaspolygon but i get the next error: subqueries in FROM must to have an alias,for example, FROM ...
7
votes
2answers
264 views

Find 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 ...
0
votes
1answer
19 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 ...
6
votes
2answers
420 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. ...
2
votes
2answers
65 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 ...
3
votes
1answer
66 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
0answers
51 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 ...
2
votes
4answers
156 views

PostGIS doesn't use spatial 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
64 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
1answer
65 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
43 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 ...
1
vote
0answers
59 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
99 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 ...
0
votes
0answers
75 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
56 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 ...
0
votes
0answers
81 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
2answers
161 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
258 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
31 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
37 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
31 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
38 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
118 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
135 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
134 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 ...
0
votes
1answer
68 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 ...
0
votes
1answer
45 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
133 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 ...
4
votes
1answer
211 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
1answer
303 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
207 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 ...
3
votes
0answers
84 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
1answer
105 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 ...
1
vote
0answers
38 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 ...
3
votes
1answer
267 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
0answers
25 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. ...
2
votes
0answers
23 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 ...
0
votes
1answer
207 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 = ...
4
votes
2answers
452 views

How can I extract all distinct values from a PostGIS Raster?

I am working with an integer raster in PostGIS 2.1 and I would like to extract all distinct values in that raster. I was hoping to be able to do something along the lines of the following query, but I ...
1
vote
0answers
84 views

How to count the number of coordinates within x meters grouping by distinct ids?

I have a table "items" of about 1 million rows and 40.000 distinct ids like the following: idx | id | point | lat | lon | the_geom 1 | 1 | 76 | 51.463388 | -0.16869856 | 0101000020E... 2 | 1 | 53 | ...
0
votes
0answers
213 views

Layer Definition Query - Subqueries

Background: I want to track the movement of icebergs in ArcGIS. In my FileGeodatabase I have a single Iceberg layer. What I have thought of is to create an ID field for each object; each ArcGIS ...
0
votes
0answers
54 views

Removing highlighting when selecting feature in Arcmap

Whenever I select a feature in an attribute table it gets highlighted which prevents me from seeing the symbology of that feature. I tried choosing No Color in the appearance option, but that results ...
0
votes
1answer
83 views

Summarizing at Modelbuilder

I like to summarize of the ID-Field with the ModelBulider because in the end I have to build a tool. The problem I have is that the field “GRIDCODE” should get in the new table comma separate. So that ...
0
votes
1answer
154 views

Create spatial view that references multiple databases

Based on this link, it sounds like I can create a view from separate spatial databases. Cross-database queries are permitted and ArcSDE views can reference data from multiple databases provided ...
2
votes
2answers
91 views

Parse Field to Select Records

I wish to select records based on the NRN attribute in my dataset : "NRN" IN ('1','2','23','31') Some records have multiple values in the NRN field separated by the underscore character. For ...
0
votes
0answers
43 views

MySQL Select rows where line strings are within a bounding box

I have a MySQL DB with some spatial data stored in a table after being input via ogr2ogr from a shapefile. The structure is similar to the following: OGR_FID int SHAPE geometry (all line ...
5
votes
2answers
435 views

Selecting maximum Value based on other field using ArcMap?

I have problems with a SQL query. The table looks like this, it is a point feature class both in postgres and file geodatabase, I am working in ArcMap. name: elev_p HEIGHT AREAid 100 1 200 1 ...
3
votes
4answers
1k views

Label using VBscript in ArcMap - multiple IF statements?

I have 4 fields that hold number values. I only want a label returned if the field <>0. For instance, if col1<>0, then label = col1 AND if col2 <>0 then label = col2, etc. So, I want all ...