A command used to retrieve information from a database

learn more… | top users | synonyms

2
votes
2answers
88 views

Determining closest representation of polygon as collection of points+radii

Have a bit of a tough question, which I realize there may not be an easy solution to. Figured what better place to ask. I'm attempting to transform a polygon into a series of arbitrary points with ...
1
vote
2answers
40 views

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

Good Day! 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 ...
3
votes
1answer
43 views

How to select an limited TOP n from a specific column in arcgis query builder

I'd like to know what is the best way to select a limited top 'n' of rows from a specific column of a geodatabase file. Currently I use a function in the query builder of the select tool (arcgis10) in ...
3
votes
1answer
220 views

TO_DATE ORACLE SDE failing

I'm trying to use TO_DATE to query an Oracle SDE dataset. It's not working in the javascript API application so I tried to query the rest end point directly and I get the error: "Unable to perform ...
1
vote
1answer
25 views

Rewrite query to match two points with a linestring in a different database table

OK, not sure if I've worded the title brilliantly, but here goes: Suppose I have: a table "gps_nodes" containing columns: "EASTING" (containing longitude data) "NORTHING" (containing latitude ...
1
vote
1answer
170 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
0
votes
1answer
56 views

Is it possible to do a query to multiple tables?

I have a point a line and a polygon layer. They have the same attribute table. Can I do one query that refers to all the attribute tables? So I wouldn't have to do every query three times. Thanks. ...
0
votes
1answer
24 views

Multiple field vbscript query

I'm fairly new to arc gis and I'm trying to string along several queries. individually they work in same query they don't. background I want to query all permit types rc, re, re/ap, and db; less than ...
0
votes
1answer
41 views

Isolate And Save Raster Features From Existing Multivalue Raster Map

I have Cyprus Corine map with 44 different types of land use. I want to run a raster calculator query or any other way to isolate the areas with codes 10 to 22 and 26 to 34, all other values 1 to 44 ...
0
votes
1answer
536 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 ...
3
votes
0answers
214 views

Select features within a country or bounding box effectively using PostGIS

I imported the planet OSM file into a PostgreSQL 9.2/PostGIS 1.5 server using osm2pgsql. I now want to select certain map features which lie within the bounding box formed by a countries borders, e.g. ...
3
votes
0answers
307 views

How do I determine appropriate Date query syntax for a layer?

I'm writing a web mapping query tool to query Esri mapservice layers by date using the REST API. It has been said that the syntax depends on what kind of database is behind the mapservice layer, as ...
3
votes
0answers
232 views

How to get distinct values from multiple columns in GeoTools?

Is there a way to get distinct values from multiple columns in geotools? I know I can get unique values from a column like this: SimpleFeatureSource featureSource = ...
2
votes
0answers
614 views

Proxy trouble with GeoExt Query Panel?

I got the GeoExt QueryPanel working so far, it recognizes the layers available on my Geoserver but it is not able to get the attribute columns for the dataset. I configured an osgeo proxy on my Apache ...
1
vote
0answers
19 views

How to Build Query Table from two OLE DB tables using ArcPy?

When I run the following code to create a subset of a table, the error says "An invalid SQL statement was used" [Query]. The error shows in line 39. Is there any idea you can figure this out? import ...
1
vote
0answers
9 views

Forcing Hash Join Query Plans using PostGIS

I'm currently testing PostGIS 2.0 in a Greenplum Appliance (Postgres 8.2 based) and have hit an incompatibility between PostGIS and the MPP Greenplum environment. The basic query below can't be ...
1
vote
0answers
40 views

Querying and summarizing/reporting a multiple tables database

I have to create a database with information on Scottish buildings from 17 and 18 centuries. In order for my data to be searchable I need to have a series of tables connected with 1 to many ...
1
vote
0answers
60 views

PostGis search query on hstore tags

I am writing a search client, to query postgis db. The search query will be, SELECT tags->'name' AS name,ST_Transform(way,4326) AS pt_lonlattext FROM planet_osm_point WHERE lower(tags->'name') ...
1
vote
0answers
125 views

ArcObjects: How to Speedup Spatial Query to Feature Layer?

I have ROAD (POLYLINE) Shape File with more than 400,000 Records. I am working on a code which goes like this: Loop through all Feature of the Shape File Take First Feature Find the LAST VERTEX of ...
1
vote
0answers
363 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 ...
1
vote
0answers
153 views

Query to find lat/lon of a house by street.name & house.number

How can I get house coordinates (latitude, longitude) by street.name and house.number? If it is possible, how I can get it? Many thanks!
1
vote
0answers
141 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
0answers
718 views

How to fire a query from OpenLayers to GeoServer to fetch 'the_geom' column in PostGIS table?

I am coloring the polygon shapes of world_country. I have OpenLayers in my UI, GeoServer as server and PostGIS as db. All I want is fire this query: select the_geom from world_country where ...
1
vote
0answers
273 views

Cannot join feature layer with SQL Server table with query built in it in ArcMap

I need to join a feature layer with a SQL Server View with a common field in ArcMap. The View was successfully added to ArcMap as data table with some query built on it from Query Builder. When I ...
0
votes
0answers
21 views

How do I use Arcpy to label based on two different expressions, then convert to annotation?

I am trying to open an mxd and turn on labels before converting them to annotation. I would like to turn on labels with 2 different classes, based on 2 different expressions, then convert them to 1 ...
0
votes
0answers
13 views

Automatically update the result of a QueryTask

I have developed a application using the ESRI JS API to allow users to create and edit features in a web map. I have used the QueryTask to create summary statistics to report back to the user on ...
0
votes
0answers
14 views

Problem using test search for tags in ArcGIS JavaScript API

I have the next problem with a query using the ArcGIS Javascript API, when I execute this code: portal.queryItems({ q: queryGroup+' AND tags:"' + tagsInserted+ '" ', num: 100 ...
0
votes
0answers
25 views

View for SDE Permissions for SQLServer

Does anyone know the correct tables and joins to write a view to see the permissions on objects in SDE? Here is what I had in 9.3 and it doesn't seem to work (ie., all Permissions are Edit b/c the ...
0
votes
0answers
24 views

Invalid spatial reference Error

I am getting the error: Invalid spatial reference. Spatial reference must match map's spatial reference. Clear the map layers collection prior to changing the spatial reference when I try to ...
0
votes
0answers
30 views

display route from database(postgresql) on

For first part: Link i have postgresql9.1,postgis2,pgrouting2 and qgis2.2 this is the second part of what i need to do: Search in a database (postgresql with pgrouting) for a line from public ...
0
votes
0answers
39 views

Why is Freehand Spatial Query in ArcGIS for Server not working?

I have been using the Spacial Query tool from ESRI to implement more functionality into my GIS application. The query works for a square, circle, and oval; but it does not return anything if the user ...
0
votes
0answers
23 views

QGIS spatial query cryptic error message

I tried running a spatial query plugin to return features in SpatialLite layer that fall within selected feature on MapInfo .TAB layer, which worked fine, selecting 3 items. But when I tried creating ...
0
votes
0answers
29 views

How to build a query tool for spatialite data in QGIS?

I am trying to build some tool for a collegue of mine to query data from a spatialite database while clicking on vector features. My first guess is, that I could do this with an "action" I define for ...
0
votes
0answers
49 views

Find area with highest relative density of one type of object

I'm using PostgreSQL/PostGIS and I have an advanced type of query. My database contains two types of object - let's say pubs and churches :) Is there a way that I can find the area with the densest ...
0
votes
0answers
39 views

Newbie, I want to make a map that shows something along the lines of the following:

What is the average income for housing units (middle, mixed, family, etc.) within a 2 mile radius of parks for the City of Anaheim? or What is the average number of parks within the 1/2 mile radius ...
0
votes
0answers
25 views

Exclude any geometry contained within another in geodjango queryset

I am trying to get a set of non-intersecting model objects my a GeoDjango project. I have a model with a polygon geometry field, and it represents a collection of buffers. The model definition is as ...
0
votes
0answers
78 views

Query area without “AREA” field

In ArcGis 10.2 I'd like to show only polygons over 1m2, using something like a query. Can I do this without adding an AREA field and calculating/populating it in my table ?
0
votes
0answers
34 views

SQL Query Remove Multiple Attributes

I'd like to query a street layer by the ownership of the street (State County etc). I know I can do "Road_Auth" <> 'IL' or "Road_Auth" <> 'Kane' and so on. This question Select by ...
0
votes
0answers
62 views

ArcGIS server 10 web adf query attributes task results sorting

I'm fairly new to web mapping and my company uses ArcGIS server 10 web ADF. I've used 'query attribute' task and given the list of data to select from. Now I was asked if I could sort those results ...