Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
0answers
29 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 ...
2
votes
1answer
170 views

How to solve “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
40 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 ...
0
votes
0answers
23 views

Does pg_createTopology not create all topologies?

I created my paths from QGIS v2.18.18 and imported the shp file to pgadmin using GDAL with this command: ogr2ogr -f "PostgreSQL" "PG:host=localhost user=postgres dbname=routing password=password" "F:...
1
vote
0answers
59 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
0answers
28 views

Nested ST Function Calls not working through DEVART.Data.postgreSQL driver

From a VB.NET application, we make SQL calls through our devart PostgreSQL driver (Version 7.10.1031.0) It appears that nested SELECT "ST" function calls do not work on the PostgreSQL DB backend when ...
0
votes
1answer
56 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
42 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
36 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
58 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
1answer
144 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
42 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
57 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 ...
3
votes
1answer
112 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 ...
0
votes
0answers
21 views

How to search postGIS db for web client search box

I am using SQL command: SELECT column1 AS displaytext, Box2D(columngeometry) AS bbox FROM chosenlayer WHERE column2 ILIKE '%?%'; The search box works for most features, and returns nothing for other ...
1
vote
0answers
62 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
422 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
190 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
215 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
77 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
113 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
208 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
68 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
339 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 ...
3
votes
0answers
97 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
197 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-...
0
votes
0answers
217 views

Problem with pgr_createTopology in Qgis

I'm following anita Graser's pgRouting 2.0 for Windows quick guide, even I created the schema 'Network'and I added the geoJson from the data. After I executed the same command that appear in the page ...
2
votes
2answers
132 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
119 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 ...
0
votes
0answers
87 views

Twitter API (GeoJson RFC7946) coordinates to WGS84 coordinates

I'm trying to use WGS84 Coordinates but Twitter API uses geoJson and RFC7946 (https://dev.twitter.com/overview/api/tweets). I want to use the info on PostGIS.
1
vote
1answer
522 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
122 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
42 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
361 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="...
3
votes
1answer
1k 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
451 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
298 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 ...
0
votes
1answer
148 views

Limit ST_DWithin() to first candidate found

Im trying to create a table with distances calculated from points to lines. For that im using the following SQL adapted from BOSTON gis website. I understood the function seems to search for all ...
1
vote
1answer
150 views

Upgrading PostGIS and PostgreSQL but running upgrade to PostgreSQL it errors?

I want to upgrade PostGIS(2.0.4 ---> 2.2.3) and PostgreSQL (9.2.4 ----> 9.6) so First I upgrade PostGIS 1、install PostGIS 2.2.3 on postgresql 9.2.4 2、alter EXTENSION postgis 2.0.4 ---&...
1
vote
0answers
201 views

Querying for All OSM Street Intersections in PostGIS

I created a GIS database using an OSM datafile for a single city (from Geofabrik) and imported it into PostGIS using osm2pgsql. I have around 180K rows in osm_planet_line database, a manageable sie. ...
1
vote
0answers
50 views

GRASS plugin to QGIS [closed]

I want to work on QGIS using GRASS HRU. it needs QGIS software to boot first, but it is not booting. I tried reinstalling the software also. I can open GRASS but its not giving any result. I ...
2
votes
1answer
92 views

Exporting All Streets in a City - Multiple Lines, With Latitude and Longitude

I installed Postgresql, Gis, SELECT postgis_full_version() reports, POSTGIS="2.2.2 r14797" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 1.11.3, released 2015/09/16" ...
1
vote
2answers
235 views

Routing network from database created by osm2pgsql

I created my PostGIS database by osm2pgsql tool and now I want create network suitable for routing. (I could not use directly osm2pgrouting because I need street names e.g. and so on). For this ...
1
vote
0answers
315 views

QGIS & PostGIS: Layer not valid - not loaded

I've been having some issues with PostGIS and QGIS. I'm trying to connect to a PostGIS database, and retreive a layer called MargamParkMap (in Schema MargamPark) No warning triangle (like the views - ...
2
votes
0answers
119 views

Importing multiple raster images in PostGIS

I have several raster images for one area and I am trying to import these multiple raster images in PostGIS. Is there a efficient way to import these raster images at once?
0
votes
1answer
487 views

Seeking solution to using PostgreSQL/PostGIS views in ArcGIS for Desktop?

We are currently trying to 'clean up' our geodatabase. For example: we have 30 datasets of districts, each of a different year (1986-2016). To make it more visible, we want to combine them all into 1 ...
0
votes
1answer
404 views

ST_MakeSolid() creating an invalid solid from closed polyhedralsurfaceZ

I am trying to turn a polyhedralsurface object into solid using ST_MakeSolid() SFCGAL function in PostGIS. SELECT ST_Volume(ST_MakeSolid(ST_GeomFromEWKT('SRID=4326;PolyhedralSurface( ((-1....
1
vote
0answers
505 views

How to initialize a PostGIS database in PostgreSQL single-user mode? [closed]

Update: Reposted this question on StackExchange / Database Administrators: https://dba.stackexchange.com/q/152496/57043 I'm using PostgreSQL 9.2.15 with PostGIS 2.0.7 through the standard packages ...
5
votes
1answer
300 views

How to work on downloaded copies of database tables in QGIS

I want to provide the online editing facility from postgres database. but it seems if I use Live database it slows down all the function of qgis as its pulls data from online server for every ...
0
votes
0answers
76 views

QGIS and PostGIS connection and query

I work on shortest distance between set of origins and other set of destinations, I want to run shortest path algorithm on multiple source - target pairs at once and get a result as a table and ...