Questions tagged [sql]
Acronym for Structured Query Language. A syntax for retrieving and manipulating data from a relational database.
1,875 questions
1
vote
1
answer
75
views
SQL query to extract relations within a bounding box from PostgreSQL OSM database
I used osm2pgsql to create an OSM PostgreSQL database for my region.
Now I want to extract data of different types within smaller areas. I can extract the nodes and ways within my bounding box using ...
- 1,013
0
votes
0
answers
48
views
QGIS Model Designer SQL-Query unreliable/not working
I was wondering if anybodey else has been encountering problems when using "Execute SQL" inside the model designer? Everytime I try to use this tool and do a query on 2 layers, the query ...
- 1
1
vote
1
answer
160
views
PostgreSQL/PostGIS : Error No space left on device SQL state: 53100
I want to compare a geoprocessing done in QGIS and PostGIS. It involves a union of two large polygonal vector layers.The processing in QGIS tooks 1.5 hours on a well-equipped workstation (32 GB of RAM)...
- 1,096
0
votes
0
answers
37
views
Populating tags with Python in ArcMap - Map automation through LRM
I am trying to fix a broken map in map templates that is generated through Land Resource Manager (LRM) where we manage all our data. When we generate maps we select the features we want to map, and ...
3
votes
2
answers
83
views
Selecting certain feature by ID from shapefile via ogr2ogr
I try to use the feature ID in a SQL query using the SQLite dialect with the tool ogr2ogr version 2.2.3. What is the attribute name for the feature ID. I tried the attributes FID and ID. Both attempts ...
- 3,735
2
votes
0
answers
52
views
Like query and adding multiple entries in one like query
I am looking for a query to use in the field calculator on QGIS that will put a number (1 for example) in a new field(ProtestantC) if the DESCRIPTIO field contains any of the below words.
"...
- 41
4
votes
0
answers
79
views
Usage of Map Algebra expressions to build Erosin and Dilation operations
PostGIS's ST_MapAlgebra function (focal operations) seems a good candidate for implementing Erosion and Dilation operations, which are like the vectorial counterpart ST_Buffer (positive and negative).
...
- 2,562
0
votes
0
answers
44
views
Convert WKT(type: text) to shape(type: geometry) in QGIS
I need import file CSV to mySQL (phpMyAdmin) have geometry type for shape's field but QGIS don't have it.
Is it possible to set geometry type in QGIS? I need to convert WKT(text) to shape(geometry) OR ...
- 1
2
votes
1
answer
85
views
Why ST_Resample() can't be used with geom in PostgreSQL/PostGIS
I am working with PostgreSQL and PostGIS and handling a very large geom dataset. My goal is to subsample the data similarly to PCD (point cloud) subsampling, selecting representative points every 10 ...
1
vote
0
answers
59
views
Convert a PostGIS dump file directly to GeoPackage file
I have a bunch of PostGIS dump files that I would like to convert directly into GeoPackages. What I am looking for is a file to file solution, so no database middlemen. This needs to be done in batch ...
- 313
0
votes
0
answers
59
views
ArcGIS Pro "Default" Field Calculation
I have this problem in a map project where when I open the field calculate window, it is populated with the same expression.
When I open the field calculate window, the default expression I am getting ...
- 43
1
vote
2
answers
146
views
Does ogr LIKE have undocumented differences depending on FROM?
This LIKE works as expected:
$ ogrinfo :memory: -q -al -dialect SQLite -sql \
"SELECT \"8145\" AS name WHERE name LIKE \"%8%\""
Layer name: SELECT
OGRFeature(SELECT):0
...
- 756
0
votes
1
answer
77
views
System.FormatException: 24141: A number is expected at position 28 of the input
I'm trying to update the WKT of a record in SSMS version 20. Below is the wkt of the linestring geometry.
Use GisFoxMain;
DECLARE @mainGeom geometry;
DECLARE @
centerPoint geometry;
SET @mainGeom = ...
- 1
0
votes
0
answers
24
views
How to determine when a feature class was last used
I am in the midst of doing an audit on feature classes and tables within an Enterprise (sde) database, it's called GIS_PUB. It's quite old and so I would like to determine the date each feature class ...
- 1
1
vote
1
answer
88
views
Using spatial filtering in PostGIS with dplyr in R
Problem statement
My goal is to filter the observations table and find all points that intersect with the grid cells of my area of interest. I'm using the dbplyr-package in R so that I can write and ...
- 207