All Questions
Tagged with postgresql postgis
3,091
questions
0
votes
0
answers
11
views
Get info about rendered entities (mapnik) for each zoom
I'm using mapnik (mod_tile + renderd) to generate tiles based on data from PostGIS. The data is very simple, several countries with roads, names, etc. There is a style description file (xml), where ...
- 1
0
votes
0
answers
21
views
Postgis - What is the most recommended way to store LineString?
I have recently been working on storing route data in PostgreSQL/PostGIS. I am wondering which way is better to store and manage lines:
Store the entire route as a single line.
Split the route into ...
- 13
0
votes
0
answers
16
views
How to Convert JSON Result to JSONB in a TypeORM Query Using PostGIS
I am currently working with a PostgreSQL database using PostGIS and TypeORM for a project. My entity includes a column defined as follows:
@Column("geometry", {
transformer: new ...
- 622
0
votes
0
answers
67
views
Cannot translate EF Core linq query (change SRID of point)
In the code below, I was trying to get geographic points from the database and filter them based on the distance to the user.
var pointQueryable = DbContext.Points.OrderBy(x => x.Title)....
- 3
1
vote
1
answer
46
views
Postgresql Left Join via intersecting geometry columns leads to wrong Sum and correction has bad performance
I have two tables with the following structure and a lot of data:
CREATE TABLE lines
(
"Id" text COLLATE pg_catalog."default" NOT NULL,
"ProjectId" text COLLATE ...
- 2,363
1
vote
1
answer
88
views
Invalid input syntax for type bytea
I have a function which looks like this:
DECLARE
cityjson_text bytea;
BEGIN
SELECT INTO cityjson_text json_agg(cityjson) FROM (
SELECT
json_build_object(
'tileboundary', ...
- 539
0
votes
0
answers
14
views
Insert GRIB2 File into PSQL Postgis database
so I'm trying to insert a GRIB2 file into a postgreSQL database with postgis installed. I know that I can get the raster with raster2pgsql into the database but I'm looking for a way to get the whole ...
1
vote
1
answer
19
views
How to add the result of st_centroid to postgresql json response
WITH center AS (
SELECT
ST_X(st_centroid(centroid)) AS longitude,
ST_Y(st_centroid(centroid)) AS latitude
FROM (
SELECT st_centroid(
st_transform(
st_collect(
...
- 11
2
votes
0
answers
50
views
How to Migrate DB with pg_transport while still having the PostGIS extension
I want to use pg_transport to migrate my PostgreSQL database from one RDS Instance to another RDS instance. My database is around 100 GB which contains spatial data (geom column) and uses the PostGIS ...
- 541
2
votes
1
answer
24
views
Is it possible to have an exclusion constraint using `st_intersects` in PostGIS?
I'm using PostGIS to store geographical polygons:
create table Polygons(id primary key, position geography);
I would like to have the DBMS throw an error if someone attempts to create a situation ...
- 122
0
votes
0
answers
31
views
Using PostGIS to find the Intersection of Linear Features on only the Buffer of Polygon Features
I am using PostGIS and I need to find where linear features (mylines) intersect only the buffer of polygon features (mypoly). I used the following code, which works, but it is taking 13.369 seconds to ...
- 25
0
votes
0
answers
27
views
psycopg2.errors.NullValueNotAllowed: FOREACH expression must not be null
I am using a Python script in QGIS. This script does the job with another database, but in my database (the same MCD), the script sends this error
psycopg2.errors.NullValueNotAllowed: FOREACH ...
0
votes
0
answers
32
views
Can I edit the EWKB format to use only 4 bytes for coordinate values instead of 8 bytes in PostGIS?
I am using PostgreSQL with PostGIS to store a large amount of polygons. I want to minimize the space my polygons are taking up in my database and since all the coordinate values of the polygons I am ...
- 1
0
votes
0
answers
31
views
syntax error at or near "n" when uploading to a postgis db. how to escape correclty?
I am getting a lot of error messages when uploading data to a postgis / PostgreSQL server. The issue seem to be unescaped characters in jsonb objects. this is an exemplary log from the db:
2024-06-...
- 539
0
votes
0
answers
30
views
PostGIS function that can extract duplicate lines
The line objects (two objects) in that part are duplicated. Is there a 'PostGIS function' that can extract that part?
I am inquiring because the results cannot be extracted using the st_overlap or ...
- 1