Stack Exchange Network

Stack Exchange network consists of 175 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.2]

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

0
votes
0answers
26 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 ...
0
votes
1answer
27 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 "...
0
votes
1answer
282 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 ...
1
vote
1answer
107 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 ...
3
votes
1answer
118 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 ...
1
vote
1answer
165 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 ...
1
vote
0answers
293 views

Why when hibernate.hbm2ddl.auto is update my hibernate spatial doesn't recognize reading from PosgGIS?

I'm using Wildfly-10.1.0.Final with hibernate-spatial-5.0.10.Final,postgresql-42.1.4 with PostGis with the following version select PostGIS_version(); postgis_version --------...
1
vote
1answer
326 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 ...
9
votes
1answer
2k 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 ...
1
vote
2answers
473 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 ...
1
vote
1answer
639 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 **...
5
votes
1answer
242 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-...
4
votes
2answers
1k 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 ...
1
vote
0answers
565 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 ...
1
vote
1answer
139 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 ...
3
votes
2answers
314 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 (...
1
vote
0answers
105 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. ...
0
votes
1answer
310 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, ...
1
vote
2answers
780 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 ...
4
votes
0answers
268 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 ...
1
vote
0answers
253 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 ...
6
votes
0answers
570 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 ...
1
vote
1answer
86 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 ...
7
votes
1answer
1k 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 ...
3
votes
0answers
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....
3
votes
3answers
1k 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 ...
1
vote
2answers
321 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 ...
0
votes
1answer
48 views

I need to locate and build on my mac the Postgis address_standardizer extension formerly known as PAGC address normalizer

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 ...
-1
votes
1answer
129 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 ...
4
votes
1answer
142 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° ...
1
vote
1answer
289 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 ...
0
votes
1answer
209 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 ...
0
votes
1answer
784 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 ...
7
votes
1answer
431 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 (...
2
votes
1answer
547 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 ...
2
votes
1answer
540 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 ...
0
votes
1answer
28 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....
4
votes
1answer
1k 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 ...
2
votes
1answer
2k 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, ...
1
vote
0answers
100 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://...
1
vote
1answer
714 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 ...
0
votes
1answer
106 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), ...
2
votes
1answer
557 views

How can I convert PostGIS geography to geometry and split polygons that cross the antimeridian

I have a PostGIS 2.2 table that stores polygons as geography type. The table contains several polygons that cross the antimeridian. I would like to split these polygons at the antimeridian and ...
2
votes
2answers
326 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 ...
1
vote
0answers
67 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 ...
1
vote
1answer
206 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 ...
3
votes
1answer
4k 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 ...
3
votes
1answer
432 views

What's the benefit of heterogeneous geometry column in PostGIS? [closed]

I read that in PostGIS, one can have different types of geometry, say, POINT and LINESTRING?? in the same column/field of a table. I have used ESRI products a lot where each table can only contain ...
5
votes
1answer
2k views

Can a PostGIS table or view have two geometry columns?

I am just wondering if it is possible for PostGIS to have two geometry columns. I use shapefile a lot, which has only one "Shape" column for geometry and all geometries in that column has the same ...
1
vote
0answers
108 views

QGIS as Spatial Database RAD or Hierarchical Attribute Viewer/Editor?

I have designed a geological observational spatial database in PostgreSQL/PostGIS to manage geochemical samples, QAQC and geological map objects. Now is the not so fun/easy part of designing a front ...