Skip to main content

Questions tagged [postgis-2.2]

Version 2.2 of PostGIS, a spatial database extender for PostgreSQL object-relational database, released on 7 October 2015.

Filter by
Sorted by
Tagged with
0 votes
1 answer
85 views

Simplify on provider side if possible

There is such item in QGIS layer render properties, how to use it? I have database in PostGIS. The problem is, that I have huge landcover polygon layer for which render is very slow. Would this help?
Irakli Ugulava's user avatar
-1 votes
1 answer
68 views

GIS Query improvement

Could someone suggest on the below query? One of the queries which was created on GIS data is taking a long time and even it is not taking the index as well. I have included all the required details ...
postgann2020 s's user avatar
1 vote
0 answers
370 views

Suggestion on table analyze [closed]

Environment: PostgreSQL: 9.5.15, PostGIS: 2.2.7 When analyzing a table containing GIS data, I get this output: ANALYZE SCHEMA.TABLE; NOTICE: no non-null/empty features, unable to compute statistics ...
postgann2020 s's user avatar
0 votes
1 answer
2k views

pyproj gives inf instead of values

I want to convert the coordinates (639117.49, 6865775.92) from EPSG:4326 to EPSG: 3949, by using the following code: from pyproj import Proj, transform P4326 = Proj(init='epsg:4326') P3949 = Proj(...
Wave1988's user avatar
0 votes
0 answers
162 views

PostGIS (or rpostgis) issue on Ubuntu 18.04

I've installed PostgreSQL 10 and PostGIS on Ubuntu following instructions here. Now I'm migrating an R interface from Windows to said Linux box and have an inconsistency I can't sort out. When I ...
Jeff's user avatar
  • 83
0 votes
0 answers
414 views

Optimal way to find points within polygon in PostGIS

I've developed a query to find points which completely fall inside a polygon by using PostgreSQL 10 and PostGIS 2.4 database. The query took a long time (aprx 90mins) to produce the result. The number ...
venkat's user avatar
  • 1,051
1 vote
1 answer
155 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 "...
Gautam Shahi's user avatar
1 vote
1 answer
2k views

Find and remove portions of polygons from one geometry column that overlap from another geometry column in PostGIS

Let's say I have 2 VIEWS. Each has a geometry column with polygons that overlap, approximately like so: I'd like to delete the portions of of the green polygons where there is any overlap with the ...
fslick's user avatar
  • 23
2 votes
1 answer
983 views

PostGIS creating an envelope around a buffer returns strange results

For a spatial search I need a 900km buffer around a given point(lon 18 degrees, lat 63 degrees) and search all geometries in a table that intersect with the envelope around the buffer( actually a ...
rimetnac's user avatar
3 votes
1 answer
441 views

create spatial view in postgis on an ArcGIS table with ST_Geometry type

I am working on PostgreSQL 9.4.5 with Postgis 2.2.3. I work on a spatial table created on ArcGIS, with geometry type "ST_POINT". I would like to create a spatial view of that table in postgreSQL ...
Thierry's user avatar
  • 41
1 vote
1 answer
2k views

Transformation of geometry on select Postgresql

I am trying to run a transformation of a geom via a select query, the layer has been digitised in WGS 4326 and when I run my select to filter the table by my criteria, I would like to transform the ...
Terry's user avatar
  • 51
1 vote
1 answer
881 views

How do I create a dissolved buffer using PostGIS with EPSG 4326?

I'm trying to buffer a polyline (WGS84/EPSG 4326) by 50km, and then dissolve all the overlaps in the buffer. So far I've tried a combination of: casting the EPSG 4326 geometry as geography (to get ...
srha's user avatar
  • 838
13 votes
1 answer
4k views

Why is st_intersects faster than &&

It's a table of points. ~1M records SELECT COUNT(*) as value FROM alasarr_social_mv s; Output: 976270 It looks like st_intersects forces to use the spatial indexes but && doesn't. Sample ...
alasarr's user avatar
  • 461
1 vote
2 answers
2k views

What do the error messages from renderd mean?

I'm pre-rendering a small section of a map for offline use, and I'm getting errors from the output of render_list. I've set up a postgreSQL database with postGIS, and I'm using Mod Tile/Renderd to ...
Onofog's user avatar
  • 111
1 vote
1 answer
1k views

Server searching for wrong PostGIS extension file version?

Our database is hosted on a shared server, spatial queries are now failing unexpectedly returning the following error: ERROR: could not access file "$libdir/postgis-2.0": No such file or directory **...
Don's user avatar
  • 815
7 votes
1 answer
965 views

Is there an inverse operation to ST_Shift_Longitude in PostGIS < 2.3?

ST_Shift_Longitude(geom) (renamed to ST_Shift_Longitude in PostGIS 2.2) adds 360 to longitudes below 0, thereby (for lon-lat coordinates like WGS84) moving the part of the world "left" (west) of the 0-...
das-g's user avatar
  • 1,465
5 votes
2 answers
5k views

Plotting a shapefile directly from PostGIS using Python

I'm trying to plot a shapefile directly from PostGIS using Python. My shapefile is already stored in PostgreSQL. I know how to connect Python with PostgreSQL, but I just can't find anything that helps ...
MAR's user avatar
  • 183
2 votes
0 answers
2k views

How to speed up slow performance on postgresql Postgis?

I'm using postgresql 9.6 as my database. It takes too much time than the query itself. The query take about 160ms which is not as good as the wanted performance. My query is like : SELECT DISTINCT ...
Zeus's user avatar
  • 141
1 vote
1 answer
273 views

Strange result with ST_Distance, geography type and equator

I am getting strange results with distance queries in PostGIS using geography types and ST_Distance. According to the docs, ST_Distance should return the distance in metres between two geography ...
alphabetasoup's user avatar
4 votes
2 answers
1k views

Finding new point, with proportion, between two points Postgis

I couldn't find a topic related to my problem, thus I am going to ask. I have the following problem: I need to create a new Point based on three variables: P1 (Geometry), P2 (Geometry) and length (...
Mateus Batista's user avatar
1 vote
0 answers
149 views

Postgis, Installing Tiger Geocoder :Using Extension

I am trying to install the tiger geocoder for postGIS. I am using the 2.2 version of postGIS on Windows 10. I am using this set of instruction to do so. I do not know the meaning of the fourth step. ...
Epulari's user avatar
  • 49
0 votes
1 answer
664 views

Creating Postgis Polygon using ST_ConcaveHull from Geometry Points

I have a postgis 2.2 table with 20 columns of type geometry(Point,4326) I'd like to generate a polygon which covers the outer boundary of the points - it seems like ST_ConcaveHull is a good option, ...
user1051849's user avatar
1 vote
2 answers
2k views

Split Lines by Polygons

We have a need to split a table of lines(> 100 MM) lines by a table of polygons (~ 5000). ST_Split only accepts two arguments (not sets). What would be the best way to do this? That is, split each ...
c00der's user avatar
  • 231
5 votes
0 answers
384 views

Making QGIS select correct feature id in PostGIS materialized view?

Can you tell me if there is a way to make QGIS automatically select the correct feature ID when I choose a materialized view in PostGIS? It's not a big deal, but it is nonetheless something I would ...
Nico Alberti's user avatar
1 vote
0 answers
478 views

Calculating the slope for parts of the dem

In my PostGIS / PostgreSQL DB I have a DEM cropped to the size of Germany. As a second (vector) layer I have 1300 catchment areas (<30km²) for which I want to calculate the slope. To reduce the ...
andschar's user avatar
  • 1,255
7 votes
0 answers
2k views

PostGIS: Storing large gridded time series

I'm trying to store a large raster timeseries on PostGIS-2.2 / PostgreSQL 9.5. The data comes as a collection of HDF-EOS (basically HDF4) files. Each file contains 24 bands, representing hourly ...
Tom's user avatar
  • 171
1 vote
1 answer
121 views

Postgres crashed when I run function

I would like to copy part of one geography table (hidrography) to another table. So I did one functions to help me it. However everytime I ran it the postgres (see figure above). Why my query didn't ...
Diogo Caribé's user avatar
7 votes
1 answer
2k views

PostGIS / OSM: Faster query to find nearest line of points

Following scenario: I have a table roads, which basically contains the road network of a whole country extracted from the OSM line table and a table points containing millions of GPS tracked points ...
Johannes H's user avatar
3 votes
0 answers
2k views

How can I do a soft upgrade from PostGIS 2.1.4 to 2.2.2?

I am running PostGIS on Linux Mint 17.2 using versions in ubuntugis-unstable PPA. I recently updated from 2.1.4+dfsg-3~trusty to 2.2.2+dfsg-2~trusty0. Using soft upgrade instructions http://postgis....
Lee Hachadoorian's user avatar
5 votes
4 answers
2k views

"libSFCGAL.so.1: undefined symbol" upgrading to Postgis 2.2.2 (and 2.2.1)

I recently got PostGIS upgraded to version 2.2.2. I would like to upgrade a legacy database to this new version, running this query: alter extension postgis update to "2.2.2" The result is this ...
Luís de Sousa's user avatar
1 vote
2 answers
750 views

Creating a table that stores Distances and other column

I am looking to run a query to calculate the distance from a polygon to other features (will use this query on point, polygon, and line features) within 2 miles and create a table that will display ...
GIS Pat's user avatar
  • 301
1 vote
1 answer
200 views

Building PostGIS address_standardizer extension formerly known as PAGC address normalizer on Mac?

I have come a long way towards completing the TIGER Geocoder. However, I cannot perform an installation of postgres and postgis that reveals the new PostGIS 2.2.1 address_standardizer extension or any ...
metro-mark's user avatar
-1 votes
1 answer
309 views

Cannot find PostGis address_standardizer extension

I installed postgres and postgis using the enterprise db standard installer for osx. everything feels normal and works great! But I cannot find any sign of the address_standardizer extension. I'm ...
metro-mark's user avatar
4 votes
1 answer
184 views

PostGIS Intersection weird behavior

I can observe a strange behavior with my PostGIS query. I am trying to accomplish the following: I have one polygon layer I have 2 different line layers layer with horizontal lines layer with 45° ...
andehhh's user avatar
  • 457
1 vote
1 answer
664 views

How to add more vertexes to a LineString

I created a map of LineStrings using QGis and then it was exported to a Postgis DB, then I used the query below in order to create the vertexes in the map so it could be used with the functions of ...
figuedmundo's user avatar
0 votes
1 answer
276 views

Confusion with Postgis Topology and Geometrytype

in the moment I try to understand the principles of postgis topology. While testing I discovered a behavior, which I don't understand. I have a table public.test with a standard geometrycolumn type ...
Michael's user avatar
  • 454
0 votes
1 answer
3k views

Error parsing GeoJson - parse error - invalid geometry

I'm trying to parse GeoJSON but getting a parse error. I've validated the GeoJSON using http://geojsonlint.com/ and http://geojson.io/. Using PostGIS 2.2.2 r14797, this is my SQL command: SELECT ...
Ender2050's user avatar
  • 103
8 votes
1 answer
874 views

How do I load 1 billion points into PostGIS?

I have a file geodatabase containing research data that I need to load into PostGIS. The GDB contains one feature class with one billion records with three columns (the FID, a FK, and the geometry (...
DenaliHardtail's user avatar
2 votes
1 answer
951 views

PostGIS: How can I improve the response time for getting the routed distance between addresses?

I need the ability to calculate the driving distance between two addresses for possibly hundreds of thousands of records. I have decided on PostGIS because it can geocode and perform routing all in ...
kttii's user avatar
  • 3,630
3 votes
1 answer
4k views

PostgreSQL 9.4.7: PostGIS 2.2.1 via Stackbuilder Checksum issue

When installing PostGIS via Stackbuilder (3.1.1) I get an error: "checksum verification failed for: postgis_2_2_pg94.exe! deleting file..." I've neither seen this in previous installations nor found ...
Jochen Schwarze's user avatar
0 votes
1 answer
38 views

Polygons from PostGIS table won't highligt in QGIS

QGIS 2.14.1 / PostGIS 2.2.1 I have a table with polygons and a view on this table in PostGIS. When I select the features from the view in QGIS with Identify Features, the objects highlight on the map....
nielsgerrits's user avatar
  • 3,946
7 votes
1 answer
2k views

How to use ST_ClusterWithin with geography data type and measurement units?

I want to clustering locations use ST_ClusterWithin function: geometry[] ST_ClusterWithin(geometry set g, float8 distance); My table has column location of geography(Point,4326) type and I don't ...
Maxim's user avatar
  • 171
2 votes
1 answer
3k views

postgis not valid win 32 application

I'm trying to setup Postgres 9.5 on my local machine x64 based win 8. I've downloaded postgresql-9.5.1-1-windows.exe and also downloaded postgis-bundle-pg95x64-setup-2.2.2-1.exe Postgres runs fine, ...
MetalGeorge's user avatar
1 vote
0 answers
113 views

Getting PNG map from PostGIS to Node and then jquery

Using Jquery, I am aiming to get png map from postGIS which has been created dynamically from node server in different port. I used jsonp to overcome cross domain issue in jquery. $.ajax( 'http://...
atemiz88's user avatar
  • 397
1 vote
1 answer
1k views

Distance measure of ST_ClusterWithin

I use SRID 4326(WGS 84). So what is the measure of distance in ST_ClusterWithin . m, km, degree ? I ask it because in documentation it only says: geometry[] ST_ClusterWithin(geometry set g, float8 ...
galakt's user avatar
  • 113
1 vote
1 answer
137 views

Importing information on bridges into postgis-table using OSM2PGROUTING

In OpenStreetMap (OSM) road data there is information about whether or not a road feature is a bridge or not (boolean). However, when importing into a postgreSQL data base for routing (pgrouting), ...
Latus's user avatar
  • 13
2 votes
2 answers
650 views

Postgis Functional Index on st_pointonsurface() Ignored

If I define the following table... CREATE TABLE tbl_vast_importance( id bigserial PRIMARY KEY, geom geometry(MultiPolygon,4326) ); CREATE INDEX ON tbl_vast_importance USING GIST (geom); CREATE ...
THX1138's user avatar
  • 1,621
1 vote
0 answers
93 views

Incorrect results returning from st_distance_spheroid query

Given a routable network table constructed by completing the guide at http://anitagraser.com/2011/02/07/a-beginners-guide-to-pgrouting/, how can I get an accurate list of all roads that are within a ...
Jason's user avatar
  • 289
1 vote
1 answer
337 views

Stretched QGIS Hexbin in Google maps

I am very new to GIS so please forgive me if the question is naive, but I haven't found a solution yet. I generated a mock hexbin in QGIS using MMQGIS plugin, with project set to EPSG:4326 and saved ...
Dave's user avatar
  • 113
3 votes
1 answer
5k views

How to install the latest PostGIS in Ubuntu

I am wondering how can I install the latest PostGIS 2.2 (testing) from the Debian GIS project here: https://launchpad.net/ubuntu/+source/postgis/2.2.0+dfsg-3 I tried apt-get install -s postgis after ...
tinlyx's user avatar
  • 11.1k