A command used to retrieve information from a database

learn more… | top users | synonyms

0
votes
0answers
16 views

How to reset query format in QGIS?

I have a raster layer (wms) that I can query for some info (1). The query window offers different formats for this (2). However when I select "Object", the query result vanishes (3). I looked ...
0
votes
1answer
30 views

Querying GeoJSON polygons from Django models in Leaflet?

Am developing an application in GeoDjango and using Leaflet to show my data.I have loaded my data successfully into the map and added a sidebar where I have my textboxes to input values and a search ...
0
votes
0answers
14 views

pgsql2shp query error select

I need to export from postgis some data obtaining the center of my polygons, now I'm working on Ubuntu. My command looks like this: ./pgsql2shp -f /home/me/ESTADOS_POINT -h localhost -p 5432 -P ...
0
votes
1answer
46 views

Using Python parser of ArcGIS Field Calculator to populate values in one field based on those in another?

I am trying to populate a field with a sorting code that represents the value of another field. Example: EXPCODE|SORT| S4DNN2 |3.5 H2BNN2 5.0 EXPCODE is a field with a value like "S4DNN2." SORT ...
0
votes
0answers
9 views

Query search using variables to search for variables?

I am trying to see if part of any attributes in field 1 (PID) does not match part of field 2 (parcelnum). The PIDs are 16 digit, but the last 4 digits are used to create the parcelnums. So if my ...
0
votes
0answers
8 views

Can't get edit or query widget to display in published GeoServer WFS

I have successfully enabled transaction support in my WFS. When I view my app in preview layers, the query and edit buttons work fine. However, when I go to publish, there is no option to include edit ...
0
votes
1answer
33 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 ...
1
vote
2answers
54 views

How to populate a table with geom line? [closed]

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
0answers
11 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: ...
3
votes
1answer
69 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
16 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 ...
0
votes
0answers
17 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
61 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
35 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
55 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 ...
1
vote
0answers
76 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
37 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. ...
1
vote
1answer
34 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
42 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
39 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 ...
0
votes
0answers
33 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
47 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
34 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
114 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
20 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
68 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 ...
7
votes
2answers
259 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
16 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
404 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
54 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
60 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
48 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
109 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
51 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
54 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
40 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
39 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
66 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
56 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
38 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
60 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
109 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
155 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
23 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
34 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
30 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
34 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
101 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, ...