Acronym for Structured Query Language. A syntax for retrieving and manipulating data from a relational database.
0
votes
2answers
570 views
Correct SQL statement in FME?
I am trying to write SQL statement in WHERE Clause FME in Navigator but it does not work.
WHERE Clause:
NAME IN SELECT CONCAT(''$(',SELECT REPLACE ('Roman Ann Jack',' ',','),')'')
This sql code ...
0
votes
1answer
47 views
ST_Box2D in PostGIS 2.0
I am getting an error trying to create a bounding box of a geometry using ST_Box2D(). Is the function deprecated? If so, what is the equivalent function?
SELECT ST_Box2D(ST_GeomFromText('LINESTRING(1 ...
0
votes
1answer
182 views
How to select multiple features using advanced search SQL in QGIS
I have a layer of planning units covering a large area (there are over 16000 PU's). Three of the columns in the attribute table hold information about which planning units were included in the ...
0
votes
1answer
95 views
Postgis reorder mixed up linestring chunks / max_segment_length(linestring)?
I imported ~1000 paths from somewhere into my postgis database to a linestring field.
I had the problem that the paths were divided into chunks, and those chunks were mixed up in some cases.
Suppose ...
0
votes
1answer
180 views
Running database operations against a stored GIS geometry
I'm using Quantum GIS and Postgres with the GIS extensions to store shapefiles that I'd like to run point in geometry and point in union geometries against. While it's easy to save and load the vector ...
0
votes
1answer
85 views
How to query distict row with the same label from different linestring with multiple segment?
I have a multilinestring street table in postgis with two columns: label and prefix.
This table has 2 different roads with the same name and each road contains multiple segments.
Roads were splitted ...
0
votes
1answer
90 views
help to code a spatial query that returns the results from a database
I have asked this question on stack overflow, what i need help with is to retrieve the database entries that fit within a polygon, drawn with the Google maps api. The map is showing the correct ...
0
votes
1answer
56 views
How to Export to PDF after zooming to extent of each feature that meets SQL where clause?
I realize that I've asked two similar questions recently, but following suggestions in the comment chain, I'll make this a separate question (separate as it is not the no output problem in ArcPy: ...
0
votes
1answer
84 views
Where Clause problems when all parts are user input variables
I have written some generic user ipnut code for a toolbox script (ArcGIS 10.0) but because everything is a variable I don't know how to write the SQL whereclause.
Please can someone help and suggest ...
0
votes
0answers
20 views
query for adjacent polygons in GRASS?
i need to create a table of each district in india's adjacent districts.
i found this query but couldnt get it to work for me: SELECT p1.PK_UID, p1.Name FROM Polys p1, Polys p2 WHERE p2.PK_UID=1 AND ...
0
votes
0answers
17 views
How to get sublinestring limited by two points?
Hi i have MS SQL_server R2 2008.
I have a linestring and two points on this line.
i want to get part o linestring limited by this points.
Its possible?
0
votes
1answer
72 views
Defining SQL 2008 store within GeoServer 2.3
I want to define a SQL server 2008 store within Geoserver 2.3.
I installed the sql Extension.
After defining the different attributes, I get the following error message :
Error creating data store, ...
0
votes
0answers
35 views
SQL statement in MakeTableView_management
EDIT: Finally found a way around this..
expression = "[Route] = '" + route + "' AND [Trip] = " + str(trip)
arcpy.MakeTableView_management(solutionTable, "solutionView", expression )
I tried str() ...
0
votes
0answers
58 views
Can osm way records in SQL spatial be merged to one geographic record if they have same Id?
I've imported England shp file of roads to mssql using OSM2MSSQL and I've noticed that the same road has couple of records with same Id but different geographic (probably it was segmented).
Is there ...
0
votes
0answers
38 views
Possible to manipulate data in a postgres database with psql using JDBC or Python's psycopg2 with something else?
I ultimately want to manipulate data in a postgres database programmatically, and I am much more comfortable programming in Python than Java, but I'm not sure whether arcpy can ultimately use psql, ...
0
votes
0answers
67 views
How to write model in ModelBuilder which connects to SQL Server database and merges subparcels by unique parcel Id?
How to draw a model in model builder; conecting to the database through SQL Server and merging the subparcels of a parcel who has unique Id?
Any help is much appreciated.
0
votes
0answers
613 views
How to populate data from postgresql using dynamic php\html listing
In the form I created, I need two fields to be dynamically populated from the database while the other fields will be manually entered and push to the database. I have written a script that is able ...
0
votes
0answers
62 views
Coordinates move in sql server insert
When I insert a row in TableA in sql server I use this for the geometry column:
geometry::STPolyFromText('POLYGON((x1,y1,x2,y2,x3,y3,x4,y4,x1,y1))', 3007)
You can find the definition for ...
0
votes
0answers
33 views
How to select from an ODC Table?
I want to run the following query, using Esri's Select by Attributes tool, on a table found in an ODC. After selecting these rows, I want to append the records to a table found on an SDE connection. ...
0
votes
0answers
107 views
How to find points, sort them based on closeness, and get 1-20, 21-40, etc. Efficiently using Myisam and mysql
Note: In this question I want actual mysql command that I should send. Not concept, and stuff.
This question is similar with how to find 20 closest points efficiently
However in that question I ...
0
votes
0answers
51 views
postgis minimum distance among many points [duplicate]
Possible Duplicate:
Nearest Neighbor calculation in PostGIS
Is there a way to achieve the following:
SELECT ST_AsText(a.geometry),
min(ST_Distance(ST_GeomFromText('POINT(10 20)'), ...
0
votes
0answers
183 views
VB Script for selecting multiple records [duplicate]
Possible Duplicate:
“If then” VB Script code (or Python) equivalent to SQL's IN ('x','y',z') expression in ArcGIS Field Calculator question?
going to ask ...
-1
votes
2answers
66 views
Date/Time Question [closed]
I am new to SQL and am having some difficulty manipulating date/time fields using sql. I have two columns: One is date/time formatted (2010-02-16 06:56:00.000) and the other is a text ID. I would ...
