Tagged Questions
2
votes
3answers
86 views
Creating a where clause from user input/Python list
I am trying to perform a query based on values in a Python list. The where clause will then be used in an Update Cursor, so that the rows NOT equal to the values in the list will be deleted.
This is ...
1
vote
1answer
52 views
How to get routes in the database that intersects circle?
I have routes (linestrings) recorded in the database. I want to create a query which returns the routes that have some commonality with a circle whose center and radius are passed as parameter.
I ...
4
votes
3answers
243 views
How to join two tables using date, time, lat and lon as common field?
I am sorry if the question is elementary but I did not find any clear discussion or guide to understand how to run a query in postgresql. So that a pointer to another website would be also useful. ...
5
votes
1answer
165 views
How to run custom queries on vector layers and display results?
Is there a way to display the result of a query in QGIS?
For instance :
To get the total number of inhabitants :
SELECT SUM( inhabitants ) FROM countries
To get the total density :
SELECT ...
3
votes
1answer
72 views
Editing and Deleting Query Tables in ArcMap
How do I edit the query for a Query Table after it has been created?
How do I permanently delete a Query Table? Even after I do right-click -> remove, it still appears in dropdown lists.
3
votes
1answer
87 views
How to query against time
I have a date-time field in a feature class which I want to query. The field has values like "2011-01-01 00:00:29".
I want to query the data between the time 00:06:00 and 00:12:00. The date does not ...
3
votes
2answers
465 views
What is the best approach to using IQueryFilter.WhereClause in ArcObjects?
What is your preferred / best approach to using IQueryFilter.WhereClause statements in ArcObjects (e.g. when selecting features by attributes)?
You need to check the source type (shapefile / personal ...
11
votes
1answer
410 views
Nearest Neighbor Grouped Selection in QGIS
OK - so I have an interesting problem I am trying to solve. I have a list containing over 100,000 points in lat/long format which I have imported into qgis.
Now, what I am trying to do here is group ...
0
votes
2answers
496 views
Mysterious MapInfo query syntax errors
I'm struggling to get what seems like a perfectly normal query to execute in MapInfo v10.
In SQLite Manager (an excellent firefox plugin), this works as expected:
SELECT area_name, street_name, ...
0
votes
3answers
2k views
Defining a Query with Multiple Values
I have been trying by best to create a definition query which would select a group of municipalities from among the many in my state. I have tried commands of all sorts of variations from ...
