A command used to retrieve information from a database

learn more… | top users | synonyms

0
votes
1answer
12 views

Fast way to check if postgis bounding box contains any points/linestrings

I have a bounding box given and want to know if this bounding box contains (or better intersects) any points or linestrings. So the query should return true if the first point/linestring was found and ...
11
votes
3answers
1k views

Are personal geodatabases better suited for quickly querying indexed attributes than file geodatabases?

I'm preparing data for an ArcGIS Engine application that queries the data to search for an address. Sometimes we search just on the street name field, just on the house number field, or both. When ...
1
vote
2answers
39 views

How to populate a table with geom line? [on hold]

I have the coordinates of a lot of points in a table. In pgadmin I want to make a line that passes on these points. I already have my Coordinate point im my table. I want to make line with those ...
0
votes
1answer
402 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 ...
1
vote
2answers
494 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 ...
3
votes
1answer
58 views

PostGIS - ST_Within or ST_Disjoint performance issues

I have a table of about 150,000 points in PostGIS with a spatial index and a SRID of 27700 (OS). I want to select the points that fall outside England and Wales. I have a multipolygon table with ...
0
votes
0answers
8 views

gxp WMS Filter View

I was trying to activate the WMSFilterView gxp plugin in opengeo SDK myviewer, but I couldn't make it work. I added the plugin to the dependencies and this is my code: { ptype: ...
0
votes
0answers
8 views

How do I insert a Query Result into an existing Table?

I am attempting to create a map that displays the Service Area for Firestations within Toronto, In order to do this I need to identify the Length of all pathways. I tried using the calculate geometry ...
1
vote
1answer
196 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 ...
0
votes
0answers
10 views

How to select data from the table using Query Widget

I have a question regarding Query Widget of the WebApp. I made a web application using WebApp, and put a Query widget in it. The Query seems like working, because if I select parcels using Query, the ...
0
votes
2answers
46 views

CMV Attributes Table issue

I've created a CMV query widget that I am trying to link up with the Attribute Table widget. The table tab is being created in the bottom pane but that's as far as I'm able to get. I'm unable to get ...
0
votes
2answers
28 views

Postgis: Query ST_DWithin in square instead of circle

The ST_DWithin query queries all geometries within a certain radius from another geometry (in my case a point). For performance optimization of my application I want to query in a square. So that the ...
3
votes
1answer
44 views

QGIS 2.8.1-wien: how to unselect multiple layers from imported dxf?

I'm using the following syntax within the query builder in order to unselect a layer from a dxf added as a vector to the project: 'Layer' NOT LIKE '15%' It works but now I want to deselect some ...
2
votes
1answer
349 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 ...
2
votes
2answers
251 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
0answers
53 views

ESRI JavaScript API Web Application and SQL Queries in ASP.NET?

My workflow (and security restrictions) for a new html/javascript based web application is making me think that I could program an ASP.NET application, inside which I load the 'map' and the 'legends' ...
0
votes
0answers
33 views

QGIS expression: select from <layer> possible?

I have a project file with many nested layers and would like to query certain layers without having to click on them first. The expression tool however requires me to select the layer I want to query. ...
0
votes
1answer
757 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 ...
1
vote
1answer
31 views

Coordinates from a SQL Server Inserts don't Show Results

I am trying to parse a JSON output file from an .Mxd file. All work fine and the following SQL Insert in SSMS using sample coordinates: delete from RoomData insert into RoomData ...
1
vote
1answer
36 views

How to get all the LineStrings of a street using PostGIS with OSM

I want to get all parts of a given street. I use a query like: Select * from planet_osm_lines where name = 'mystreet' As a result I get all the LineStrings that are part of a street with the ...
0
votes
0answers
33 views

ArcGIS Workflow Manager Query - Find Duplicate Job_ID

We have a query in ArcGIS Workflow Manager 10.2 shown below that shows "All Assigned Jobs". Due to the nature of our workflows (parallel workflows), some jobs are duplicated more than once in the ...
7
votes
2answers
255 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 ...
6
votes
2answers
399 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. ...
4
votes
1answer
144 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
0answers
28 views

Distribution of POI query result

There are a lot of POIS in the database with fileds id name address lon lat. When we tried to query some points for a given bounding box, it is simple to build the accordingly sql and get the ...
2
votes
1answer
35 views

How to apply a filter to multiple vector layers in QGIS?

I am trying to apply an attribute filter to multiple layers in QGIS at once. The filter is to be applied to .osm data brought in through PostGIS to QGIS. I have tried selecting multiple layers -> ...
0
votes
0answers
28 views

How to get a specific street using OSM with PostGis

I want to get the polygon form a specific street from the OSM data importtes with osm2pqsql using PostGis. Since the streetname isn't the only identifier I wanted to add the postal code as a second ...
0
votes
0answers
104 views

ArcGIS Android syncing geodatabase does not work after downloading it with LayerQueries

I need to download a geodatabase from ArcGIS server using layer IDs and LayerQueries in database parameter class and then be able to sync both ways. The ArcGIS Android API examples are only based on ...
0
votes
0answers
16 views

Is it possible to get Metadata from railway attributes using OSM at PostGIS

I am using a query that gets me all tram stations from my data using a POstGis Database. I have OSM Data from Geofabrik. Query: SELECT point.osm_id as id, st_X(point.geom) as lng, ...
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
63 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
30 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 ...
0
votes
1answer
13 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
48 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
55 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 ...
2
votes
4answers
100 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
46 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
45 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
47 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
37 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 ...
0
votes
2answers
237 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
36 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
220 views

How can I change SQL query through a layer of an action (python)? [closed]

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
1answer
57 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
461 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
53 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
55 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
1answer
571 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
33 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
92 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, ...