All Questions
Tagged with postgresql query
77
questions
2
votes
1
answer
110
views
ST_Contains Removes Invalid Geometry & ST_MakeValid PostGIS Query Gives Error
I'm trying to query a list of polygons (geo_parcels) and get all of them, and also spatially add any points or polygons (geo_buildings) that are in or on that polygon. Normally I'd use a query like ...
2
votes
1
answer
91
views
intersect with ST_Buffer in PostGIS
I have a table called "gebaeude" with all types of buildings in the city.
In the following I want to use a Buffer around the central train station that has the id="2" and a radius ...
4
votes
1
answer
169
views
PostgreSQL query not working in QGIS Graphical Modeler
Edit: For further context, my table does have a unique id in the form of an integer. Through the database manager, the query executes successfully and I am able to load the query layer into QGIS. This ...
2
votes
0
answers
65
views
MapServer / PostgreSQL don't display an ITEMQUERY
I try to search a string in MapServer with the method ITEMQUERY from a PostgreSQL table,. It look very simple but I receive the folow error:
msPostGISLayerWhichShapes(): Query error. Error executing ...
0
votes
1
answer
40
views
Max of count does not give me the result I need
I need to display the max of count for this query.
I tried a nested way but I could not get it to return the centroid of that cell.
Here flickr_edin table data consists of points
and grid100m table ...
2
votes
1
answer
112
views
Query executed but returns blank screen
I have two tables, flickr_edin and routea
flickr_edin contains columns id, date_taken, user and geom.
routea consists of a single entry of a line string under the geom column.
Use flickr table to show ...
2
votes
2
answers
2k
views
Operation on mixed SRID geometries error
I have two tables flickr_edin and temmpat.
temppat was created using:
CREATE TABLE temppat (id serial, geom geometry);
INSERT INTO temppat (geom) VALUES (ST_GeomFromText('POINT (326253.33 674110.63)'))...
1
vote
0
answers
53
views
Missing some data from query in PostgreSQL
I am using this query to get elevation data from PostgreSQL:
WITH points(geom) AS (
values (ST_SetSRID(ST_Point(980279.44, 6431129.89), 2154)),
(ST_SetSRID(ST_Point(982573.24, 6429308....
1
vote
0
answers
272
views
How to solve parse error in pgAdmin4? [closed]
I am currently trying to add Point geometries into a table. My query is the following
UPDATE postal_code.postal_codes
SET geom = ST_GeomFromText('POINT(' || lon || ' ' || lat || ')',4269); ...
4
votes
1
answer
696
views
Calling PostgreSQL procedures or functions from QGIS' Query Builder
I am trying to call either a stored procedure or function defined in the PostgreSQL/PostGIS database and use it from the QGIS Query Builder.
Neither work:
the function returns a table that cannot be ...
0
votes
0
answers
261
views
Query geodatabase with PostgreSQL to show - schema, table, column, domain name
How to query geodatabase system tables using PostgreSQL to result this:
schema, table, column, domain name
I found this, but nothing for PostgreSQL
https://desktop.arcgis.com/en/arcmap/10.3/manage-...
0
votes
1
answer
1k
views
Execute loop in PostgreSQL query
How to execute for each table in the list one fixed query replacing just %table% in PostgreSQL (like variables and loops)
sql = 'select * from $table$ where...some_filter'
$table = {tb1, tb2, tb3...}...
3
votes
1
answer
783
views
Group geometry points and create a linestring for each group
I have a table of points at a Postgres database that have two main columns (geom geometry, time timestamp).
I need a query to retrieve as linestrings or as array of the geometries the points that are ...
1
vote
1
answer
1k
views
Get all rows that have geometries which intersect with a geometry in any row of a different table in an effective way
I have two PostGIS tables containing thousands of geographic polygons each (each row has one polygon and numerous other attributes). Both tables represent different data sets but cover the same area ...
0
votes
1
answer
335
views
Alternative of intersects ?# operator in postgres
Is there any way to find if a path is intersecting with a box in postgres without using ?# or using an alternative?
I have this query below and hibernate's EntityManager is throwing an exception ...