A command used to retrieve information from a database

learn more… | top users | synonyms

2
votes
1answer
53 views

Looking to find (or build) a particular Python geoprocessing tool

So here is my situation: There is a large area (a wildlife refuge) of nearly 200,00 acres that we have loads of spatial data for, from habitat management projects from the past several years. My boss ...
0
votes
0answers
11 views

Insensitive case query in Geotools to WFS

I'm trying to make an insensitive case query from Geotools to WFS (Web feature service) datasource,I used FilterFactory2 with the method like(Expression expr, String pattern, String wildcard, String ...
0
votes
1answer
30 views

arcgis 10.2 how to order query results

is there a way to order the returned results of a query task? this: query.where = "COD > 0"; works fine, but this: query.where = "COD > 0 order by COD"; throws: dojo.io.script error ...
0
votes
0answers
16 views

Multi-level filtering with Web app builder query widget

I have options to use web app builder and web app builder developers edition to design a query task to find a street number. For example, I have got 4 villages and each villages have 10 streets. In ...
2
votes
1answer
26 views

Postgis spatial query st_disjoint

I have 2 layers that I want to compare. I wish to retrieve the features in the layer 1 that have no part in common with the features in the layer 2. I try queries like that but do not returns me the ...
0
votes
0answers
19 views

How to remove lines made with a PostGIS query automatically if origin is not in the map window?

I have a PostGIS point layer with labels. I moved these points because they were too close. To connect label and point, I created a line vector layer which was made with a query in the DB-Manager ...
0
votes
1answer
50 views

Clicking on points in ArcGIS Android

This seems like it should be very easy to do, but I am unable to click on a point and have the map recognize that I have clicked on the point. I first tried just creating a simple point, setting the ...
0
votes
0answers
21 views

Assign a dummy value for removed features in a Polygon-Grid

I want to calculate the entropy index for landuses classes for an area based on a 100m Polygon Grid. I did find an existing toolbox that does all the required calculation. Input features are the 100m ...
1
vote
1answer
33 views

Select ID by most recent date

I have a personal GDB table that has a non-unique SLID field and a date field. Basically there are multiple records with the same SLID numbers but different dates. I want to select only the most ...
0
votes
1answer
47 views

SQL and ArcGIS data querying: what's the difference?

I am wondering if the language used by ArcGIS for data querying (e.g., search by attribute) is part of the SQL language, or to what extent there is a connection between the two (and where does it come ...
1
vote
1answer
62 views

Reference Selection in SQL query (where clause)

I keep raising errors with my where_clause in the 9th line of this script. FID is an Object ID field and I want the cursor to select whatever row it is currently pointing at. I don't know how to do ...
1
vote
3answers
77 views

How to search within a string to extract data from OSM other_tags?

I am working with OSM data in QGIS and I often need to query items in the other tags field. When I download the data using the OSM download plugin the other tags come in one field so are not easy to ...
0
votes
2answers
36 views

Performing spatial join in Spatialite (QspatiaLite for QGIS)

I'm trying to spatially join and summarize the attributes of a set of buildings to a set of containing parcels. There are (potentially) many buildings to each one parcel. Here is the query as I'm ...
1
vote
2answers
49 views

SQL query new feature with loop

I'm trying to create an individual buffer feature class for each column of an input feature class, where there is a field that contains the buffer distance. I think there is a problem with my SQL ...
0
votes
0answers
41 views

Qgis-Web-Client Query: Search Panel

I open the sample project helloworld with QGIS I go in the file site / js / GlobalOptions.js and start very simply change the language or the layer order. I do tests to see how the various commands I ...
0
votes
1answer
32 views

How to connect SQL SSMS to ArcGIS file geodatabase

I've found this reference article talking about how to query a file geodatabase using SQL. ...
0
votes
0answers
35 views

Multiple LEFT JOIN in PostgreSQL

I got a "nice" problem with a query in PostgreSQL with a multiple join SELECT DISTINCT "Monitoraggio_L001_L008_2015_aprile"."ID", "Monitoraggio_L001_L008_2015_aprile"."Ordine", ...
0
votes
1answer
54 views

select by location point in polygon with sql query

I have 2 tables table a this one a polygon layer with 10000 records table b this one a point layer with 600000 records in postgresql geodatabase i select a polygon feature with the query by input ...
0
votes
0answers
6 views

Not able to use Find by Layer feature in ArcGIS Online, when data is url .csv?

In AGOL, when using Layers linked with a url to a .csv, the 'Find' by layer feature in the Details/Edits section is not active. Meaning that layers cannot be searched using the 'Find' feature. Is it ...
0
votes
0answers
23 views

Getting connected points in intersection from OpenStreetMap using PostGIS?

I'm trying to get the points that connected with the intersections. suppose that I know the point of the intersection (if we see in the pictures, I represent the intersections as black node). Now ...
0
votes
1answer
32 views

Query table names

I want to query a table in my postgis table named Seg_060_2009 using psycopg2 and cant seem to get my query to execute. The query will execute if I name the talbe layer. Are there restrictions on ...
0
votes
1answer
63 views

Database queries using GeoServer? [closed]

I am new to GeoServer. I have a PostGIS database and GeoServer setup. How can I query the database using the GeoServer/ Boundless SDK? I have OpenGeo Suite 4.6 and I am trying to query the database ...
1
vote
2answers
70 views

Extracting difference between two massive shapefiles using QGIS?

I have two massive shapefiles and I need to create a difference shapefile output between the two. I have a layer where I have satellite coverage (orange) and then a layer where I have high resolution ...
1
vote
1answer
55 views

Running spatial query on huge table [duplicate]

I've got two tables conatining geometry: 1 containing big polygon's (regions, srid=4326) and another containing smaller polygon's (pand, srid=28992, containg ~9.9milion rows) By using one of the big ...
0
votes
0answers
17 views

A New Query Option In GeoExplorer To Calculate All Of Features In A Layer

Is there a tool to do this? A query option to calculate the number of exist features in a layer! For example on this picture I have 220 point in my layer, but is there a query option to do this that ...
2
votes
1answer
75 views

Can't import certain tables from SQL Server to QGIS

This is a list of 193 zip codes and their geometries that do not import in QGIS. This is a list of 999 Census Block Groups and their geometries that do import in QGIS. This is the Add MSSQL Layer ...
1
vote
1answer
48 views

How to concatenate values from postgis table which have the same id into a new column? [closed]

I have the following table in postgres-9.3 postgis 2.1. (geom values is too long , I cut to make it short in below table): id | name | geom ------------------------- 12 | A | "01030000000" 12 | ...
0
votes
0answers
40 views

ArcMap ObjectID seems to be getting changed, any ideas what might be doing it?

I am working with ArcMap10.0 and MDB's, often creating Definition Queries based off my ObjectID with the understanding that this unique identifier should not change over time. ie. if I create ...
0
votes
0answers
19 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
84 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
21 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
61 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
13 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
58 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
77 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
22 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
112 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
44 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
39 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
118 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
55 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
81 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
139 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
49 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
52 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
61 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
50 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
41 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
106 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
49 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 ...