Acronym for Structured Query Language. A syntax for retrieving and manipulating data from a relational database.
8
votes
3answers
965 views
Beginner PostGIS question: getting geometry from multiple tables
I am very new to PostGIS, PostgreSQL, and SQL in general.
I have 44 tables in my PostGIS database, and each one represents a different layer of vector data. Each was loaded from a separate shapefile, ...
8
votes
4answers
1k views
To what extent is SQL's language accessible via ArcGIS tools?
That question just sounds so redundant...
At any rate, I have been asked to explore the uses of SQL in ArcGIS. We use an SDE DB for all server-side storage and DB managing/large-scale editing. ...
8
votes
5answers
2k views
A SQL console in QGIS
I know QGIS comes with its field calculator, which is not bad. It also comes with ftools which permits several operations on geometry and attributes. But we often need more control and I haven't seen ...
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 ...
4
votes
1answer
488 views
Spatialite SpatialSQL Query
I've been flummoxed by this query. I have a table of points, and a table of lines, and I am trying to return the point id and line id whenever the point is contained within a buffer of the line (i.e. ...
6
votes
2answers
2k views
SELECT TOP query in ArcGIS
Is there a way to use a SELECT TOP (n) within ArcGIS desktop? Is appears that since the ArcGIS query builder is effectively building the SQL statement after the WHERE clause, that this may not be ...
5
votes
2answers
675 views
Using an integer variable in where-clause in arcgis python script
I've seen some questions on this, but there seem to be many different answers... and none have seemed to work. I'm trying to include an integer variable in the SQL where-clause of a tool like this ...
3
votes
3answers
630 views
How to label features in QGIS using SQL statement?
In QGIS, I can't seem to find a way to define the features that I want to label using a SQL query? Is this possible?
For example, I downloaded the OSM Natural shapefiles, and a lot of those features ...
1
vote
1answer
624 views
Labeling classes for small roads on large extent maps in arcmap with sql statement
I have many small sub divisions that won't label nice, (lot of overlapping) unreadable. While using the bullet leader symbol. What would be the best statement that would place the labels in a clear ...
3
votes
4answers
3k views
Select by attributes - records with the largest attribute value
Using 'Select By Attributes' how can I select records from a shapefile database table where a numeric field contains the largest value.
Need to use MAX function or something like that but can't get ...
5
votes
1answer
5k views
Select by Attributes query question
Greetings, Nice looking alternative to esri forums here at gis.stackexchange.
I am trying to select multiple (50 or more) unique numeric records using ArcGIS 10's "Select by Attributes" using ...
2
votes
1answer
755 views
calculate value using maximum value from different feature class
I'm trying to get the maximum numeric value from one feature class and use that value in an expression to calculate values of a different feature class.
fc2.bldg_id = max(fc1.bldg_id)+1
Can this ...
11
votes
4answers
1k views
PostGIS: Select features that do NOT intersect
This seems to me like such a simple question (and it probably is) yet I cannot seem to find an example that gives me the answer. Using PostGIS, I just want to select points that fall outside of ...
4
votes
3answers
798 views
How to automatically create 2D-point features from addresses in an SQL database
I currently have an SQL-Table which contains our buildings. I already added the table and now want to create features ( 2D-Points ) from that information. The biggest problem I have is that the ...
5
votes
1answer
267 views
Postgres/postgis cursors
I have a road network with StreetName and min/max address ranges for each segment (ie- StreetName = 'Main St', Min = 100, Max = 199). I also have individual address points with similar information ...
3
votes
2answers
514 views
Is there a way to update the attribute table of a feature class with a query?
I have a layer with multi-polygon feature classes for states and provinces. The shape area for some features classes is < 0 causing the label to be position in odd locations. It seems that the ...
4
votes
2answers
5k views
'Select by attribute' using python in ArcMap 10
I need to select a feature using SQL before zooming to it in python. What I'm looking for are replacements for the commented lines in this code:
import arcpy
parcel_num = "123456"
mxd = ...
4
votes
1answer
317 views
Geodjango insert statement: psycopg2.IntegrityError: violates check constraint
Why is the following INSERT statement throwing this error?
INSERT INTO domes_place (placeid, structidx, oscode) VALUES ('10', '1', 'POINT(51.121282945772 1.3138398501222)');
psycopg2.IntegrityError: ...
1
vote
2answers
406 views
Error adding data to Geodjango database: parse error… within geometry
I'm trying to insert some values into a Geodjango database, but getting errors. This is the table:
class Place(models.Model):
placeid = models.IntegerField(primary_key=True)
structidx = ...
8
votes
2answers
552 views
Splitting polylines using regions with PostGIS
I was wondering if it is possible to split a polyline on polygon boundaries (regions) in PostGIS, the picture below is of what we have at the moment and showing where I need the polylines split:
...
8
votes
4answers
924 views
Queries returning very big datasets in PostGIS
I have a PostGIS query that will return several million rows:
SELECT
t1.id AS id1,
t2.id AS id2,
ABS(t1.mean_h - t2.mean_h) AS h_diff,
ST_Distance(t1.the_geom, t2.the_geom) AS dist
FROM ...
7
votes
1answer
320 views
Is it possible to define a No SQL model for spatial data? [duplicate]
Possible Duplicate:
Is there any way I can use a Key-Value store for geospatial data?
I read somewhere about No SQL being a solution for large databases management, the kind that google ...
8
votes
3answers
649 views
Are there any training resources in SQL and Python as applied to GIS database management?
I've taken ESRI database courses, which have been helpful to my work. But I also need training in SQL and Python as applied to GIS database management. Any suggestions?
1
vote
2answers
485 views
ArcObjects table views or sqlite3 in Python?
Given a larger csv (1000+ points) with attributes, I need to do both attrbute and spatial queries on the data. Would it be faster to read the points into an xy feature class, and do the spatial and ...
22
votes
9answers
9k views
How can I connect to a PostGIS database from ArcMap 9.3 and 10.0?
How can I connect to a PostGIS database from ArcMap 9.3 or 10.0?
Ideally, I would like to be able to perform spatially enabled queries and receive the results back (e.g. spatial and non-spatial ...
