Questions tagged [postgis-2.0]

Version 2.0 of PostGIS brought a heavy set of new extensions for the PostgreSQL object-relational database, adding greater support for spatial objects.

Filter by
Sorted by
Tagged with
4
votes
1answer
57 views

Storing Central European data, which SRS/which data type?

I am creating a PostGIS 2.X data base to store some 500 or so sites as points in it, which are distributed in the northeastern part of Germany, northern Poland and parts of the southern Baltic coast. ...
1
vote
0answers
17 views

Get the measure M along a CircularStringM in PostGIS without first converting to a LineStringM

I've been struggling to get PostGIS 2.5 to run any linear referencing functions on geometry containing curves (CircularStringM, CompoundCurveM for example). Is it possible to get the measure M along ...
3
votes
2answers
106 views

Change of geometry type and buffer

I have a layer. I want to transform the type of geometry from point to polygon while creating a buffer around points proportional to the population of cities. I'm testing : ALTER TABLE city ALTER ...
2
votes
0answers
38 views

Storing distance between two points in KM

I am very new to PostgreSQL and PostGIS. I am filtering a collection of messages based on their distance from a point which works great, but I would like to be able to store the distance between the ...
2
votes
1answer
53 views

ST_3DIntersection PostGIS incorrect result

I have tried multiple times to obtain the 3D Intersection between a 3D linestring and a solid cube in both PostGIS 2.5.2 and 2.5.3 with the SFCGAL backend. Below is a query that works as expected and ...
1
vote
2answers
52 views

Calculate the maximum minimum distance from a geo object to multipoint?

I am working with postgis 2.0 and I would like to calculate the maximum minimum distance from a point set (multipoint) to a polygon. It seems that neither st_distance nor st_maxdistance can meet my ...
0
votes
0answers
14 views

Getting start and end points of intersection of 2 polylines using PostGIS?

I have 2 polylines and want to get first and last intersection points of these. I have tried: (SELECT ST_AsText(st_startpoint(st_makeline(f.geom))) FROM (select ((ST_CollectionExtract (...
1
vote
1answer
36 views

Creating Image Mosaic database table in GeoServer?

When I create an image mosaic store in geoserver, the table is automatically created in the PostGIS database. If it is possible to alter the table name, how will GeoServer know what table to look to?...
0
votes
0answers
69 views

Optimal way to find points within polygon in PostGIS

I've developed an query to find points which are completely falls inside polygon by using PostgreSQL 10 and PostGIS 2.4 database. The query took long time (aprx 90mins) to produce the result. The ...
1
vote
1answer
53 views

Updating geometry as Multipolygon from Polygon table using PostGIS? [closed]

There are two tables in PostGIS. In which, one has polygon geometries with layer name wise and another one table has master layer name list. The requirement is to collect the polygon geometries as ...
1
vote
2answers
88 views

How to get number of Lane from OSM?

I am using OSM for my project, I have downloaded data from http://download.geofabrik.de/ in the OSM file and imported the data in POSTGIS, In the planet_osm_roads, I am not able to see any key related ...
1
vote
0answers
36 views

How to speed up PostGIS intersects query?

I have a table which contains 5,00,000 records. I want to fetch all the rows which intersects with the given bounding box. My query is: select * from data_master b where b.geom && '...
1
vote
0answers
40 views

PostGIS ST_Within processing speed

I've created an SQL script that selects a given set of polygons ("v_rag_RenouvellementClaim") that are completeley within a specified buffer ("v_rag_RenouvellementClaimGrtr25000_Buffer") using PostGIS ...
1
vote
0answers
89 views

Map Matching between two geometry (line string)

I have two tables in PostGIS, both having line string as the geometry type. I wanted to extract a similar or exact matching street. Can you please suggest query or algorithm for it? Table 1 column ...
0
votes
1answer
392 views

Installing PostGIS after PostgreSQL Ubuntu 18.04

sudo apt-get install postgresql-9.5-postgis-2.5 returns a series of errors: The following packages have unmet dependencies: postgresql-9.5-postgis-2.5 : Depends: libgdal1i (>= 1.9.0) but it is ...
1
vote
1answer
50 views

ST_Centroid in view produces geometry without further definition from geometry(polygon, ssid)

I'm a Postgresql novice. In a postgresql 9.2 + PostGIS instance I have one table with a geometry(polygon, ssid) column. From this table I am trying to create a view using ST_Centroid like so: ...
0
votes
1answer
32 views

How to get the rectangular coordinates from list of line string

I have a linestring geometry in my PostgreSQL database. I want to get the corner coordinates of the rectangular bounding box. Example "...
1
vote
1answer
364 views

Getting Latitude and Longitude from a Linestring

I have a linestring geometry in my Postgres database. I wanted to extract the latitude-longitude coordinates of each point inside the linestring. Example "...
2
votes
0answers
234 views

In QGIS, How to add the database connection in DB Manager via Python [closed]

I am using QGIS 3.0.2 I want to add connection settings in DB Manager via Python script. is it possible ? (I am interested in PostGIS and Oracle Spatial for now) This script will save the ...
5
votes
5answers
4k views

“libintl-9.dll is missing” when trying to run PostGIS 2.0 Shapefile and DBF Loader Exporter

When I try to run PostGIS 2.0 Shapefile and DBF Loader Exporter I get the following error: The program can't start because libintl-9.dll is missing from your computer. Try reinstalling the ...
2
votes
1answer
110 views

Intersection of touching geometries returns a polygon

I'm using Postgis 2.3. I have two touching geometries that I got from an overlay (ST_Difference) operation: id | st_astext 3 | MULTIPOLYGON(((0 -2,0 ...
1
vote
0answers
104 views

Publishing web service using QGIS? [closed]

I want to show different types of surveyed land parcels which are available in shapefile format, in our country map. That map will be published in a web site and it will be available for surveyors. ...
0
votes
1answer
372 views

Postgis 2 - ST_area : huge difference between 3857 and 4326

I've been doing tests between projections with Postgis 2.3 and I was surprised by the result of the ST_area function with the Web Mercator projection (3857). Here is a sample query and result on a ...
0
votes
2answers
73 views

Problem While Selecting from table using ST_Transform

This following query is not returning any values SELECT * FROM leads WHERE leads.latlong && ST_Transform( ST_MakeEnvelope(78.2137, 12.5186, 78.2460, 12.5419, 4326),3587); Results like: ...
1
vote
1answer
68 views

How to migrate PostGIS databases between Postgres versions?

Mac OS I am trying to upgrade my Postgres version 9.2 to 9.6 and failing. My strategy was to follow the standard advice for Postgres databases and use pg_dumpall. This does not appear to work if ...
2
votes
2answers
317 views

PostgreSQL is loading wrong PostGIS library

I am attempting to upgrade my version of PostgreSQL (from 9.2 to 9.6) on a Mac running 10.13.5. I used pg_dumpall to backup the 9.2 database as per the instructions in the postgres documentation ...
1
vote
2answers
351 views

MySQL 8 MBRIntersects 10 times slower than PostGIS equivalent

I'm trying to migrate a PostGIS database to MySQL 8 and am having a big performance hit when it comes to MBRIntersects. Using Mapbox to render vector tiles, I need to extract geometry intersecting ...
3
votes
0answers
67 views

pgsql2shp issue when using WITH clause

I'm using pgsql2shp.exe from a Windows batch file and I get an error when using a WITH clause: "C:\Program Files\PostgreSQL\9.4\bin\pgsql2shp.exe" [ ... ] "WITH test AS (SELECT gid, the_geom FROM ...
0
votes
0answers
128 views

Issue editing nodes on a PostGIS table via QGIS

I launch a PostGIS table via QGIS DB Manager tool [PostgreSQL 9.4.17 - PostGIS 2.1.8 - QGIS 2.18.19]. The table geometry is MultiPolygon. I can toggle both Toggle editing and Node tool buttons. When I ...
4
votes
1answer
161 views

OSM2PGSQL - Openstreetmap Tiles showing no detail at certain levels

I recently built myself a Map server using this guide: https://www.linuxbabe.com/linux-server/openstreetmap-tile-server-ubuntu-16-04 This has worked really well to an extent. I have however noticed ...
1
vote
0answers
86 views

Using postgis to rasterize a set of points grouping by time

I have used postgis for vector operations for years, but have recently begun a project mixing vector and raster data and I am bit confused as to what is the best way to do what I want to do. I have ...
4
votes
1answer
580 views

Get ST_SummaryStats from Raster Table using geoJSON polygon

I have a raster dataset imported into POSTGIS with SRS 3857. This table is named as prcp0000_normal3857. The dataset represents statewide precipitation in Montana and can be downloaded below. ftp://...
0
votes
0answers
292 views

POSTGIS to dissolve all features

I have a multi polygon with spatial field layer with and 3000 records and I want to use dissolve all in 1 record. On DISSOLVE algorithm in QGIS you have a choose to dissolve all features from layer ...
1
vote
2answers
359 views

PostgreSQL query using GROUP BY question [closed]

I have a polygon layer table in PostgreSQL and I want to create a simple query using GROUP BY . Here my fields : fid field1 -- ---- 1 text1 1 text2 1 text3 2 text1 3 text4 ...
0
votes
0answers
79 views

Two geometries not at same place

In the picture1 shown there is a linestring which is Area2 and a buffer of linestring which is Area1. I want to include Area2(linestring in picture) in the buffer but I cannot increase the size of the ...
1
vote
0answers
157 views

how to split polyline where start/endpoints of the linestring touches or intersects with the nearby lines in qgis using python or postgis [closed]

I have a line layer and i want to find if the start/endpoints of the linestring touches or intersects with the nearby lines in qgis using python. I have tried the following code but it is not ...
1
vote
0answers
283 views

PostGis stopped working: Invalid access to memory location

I have a PostgreSQL v9.3 database with PostGIS 2.1.8 running locally on Win10 Creative Update 64-Bit. This database is running for months without any problem. I've used it yesterday afternoon. This ...
4
votes
2answers
75 views

How to get list of empty parcels (without building)

I have 2 table: 1. parcel 2. building How to get list of empty parcels (without building)? I can get parcel with building by use: ST_DWithin(parcel.geom, building.geom, 0) ...so i made my own ...
0
votes
0answers
460 views

How To Use ST_Union in PostgreSql?

I have a spatial table (polygons,polylines) in a database. These are digitized by multiple people. For example, a state is divided into multiple Grids and given to multiple people to digitize using ...
4
votes
0answers
133 views

Updating PostGIS layer from another vector layer in QGIS?

I have a vector layer that contains way points that I load using "load vector layer" from a gpx file. I am attempting to add these new points to an existing postgis layer by simply copying and ...
1
vote
1answer
411 views

Loading Tiger Data, and populating missing table data (such as tabblock)

I'm working with postgis and followed many tutorials out there to try to use tiger data. this one seems to be the best: https://bluehatrecord.wordpress.com/2015/07/06/installing-the-tiger-geocoder-...
2
votes
2answers
138 views

Setting up pgRouting

I'm following anita Graser's process (https://anitagraser.com/2011/05/13/catchment-areas-with-pgrouting-driving_distance/) and I don't know how to add LANGUAGE C. When I try to execute routing_dd.sql ...
0
votes
1answer
197 views

Error while importing geotiff file into postgresql database in linux platform

I am trying to import GeoTIFF file into spatially enabled PostgreSQL database. Using command: raster2pgsql -s 4326 -C -F -a path/to/geotiff/file public.table_name | psql -d database_name -U ...
2
votes
1answer
1k views

Updating the Entry in geometry_columns for Spatial Table Created from a Query

I created a spatial table from a query. Now, I notice in geometry_columns, the following entry for the table: f_table_catalog | f_table_schema | f_table_name | f_geometry_column | ...
0
votes
1answer
172 views

I would like to extract 'landuse' information from OSM data using postgis

I am trying to extract OSM land use information for a given bounding box in PostGIS. Using this example I wrote my code: SELECT * FROM planet_osm_polygon WHERE planet_osm_polygon.landuse &&...
2
votes
0answers
49 views

ST_Transform Displaced Locations

Ive updated my spatial_ref_sys table in postgres with spatial reference statement from http://spatialreference.org/ref/esri/102737/. I can perform the tranformation from srid 4326 to srid 102737 and ...
2
votes
1answer
448 views

Strange slow behavior of a very simple query utilizing single PointField field

Infrastructure on AWS RDS: PostgreSQL= 9.6.1 POSTGIS="2.3.0 r15146" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.1.1, released 2 016/07/07" LIBXML="2.9.1" LIBJSON="...
7
votes
1answer
6k views

How to find points within a polygon in PostGIS

I have a series of lat and long coordinates I've loaded into a spacial table (Nov01) in PostGIS, and I've created a geometry column in the table. I also have a shapefile (greatermanchester) I've ...
1
vote
0answers
606 views

java.lang.IllegalArgumentException: Can't convert object of type org.postgresql.util.PGobject

I am trying to fetch GIS data using nativeSQLQuery, but I am facng below issue. Stack Trace: java.lang.IllegalArgumentException: Can't convert object of type org.postgresql.util.PGobject ...
1
vote
1answer
594 views

PostGIS: how to split a polyline into straight segments? [duplicate]

I'm working with PostGIS 2.1.8. I need to split a polyline into as many straight segments this polyline contains. Here is an illustration to make it clear enough: The initial feature is only one row ...