Version 2.0 of PostGIS brought a heavy set of new extensions for the PostgreSQL object-relational database, adding greater support for spatial objects.
0
votes
1answer
41 views
Can I use in a postgis db within the same table a combination of CRS?
I'm experimenting around with my postgis2.0 database. I want to create a basic table to store all my point data and in the process,I realized that the coordinates are in different CRSs. So naturally ...
1
vote
2answers
193 views
PostGis, export Svg in pixels
I'm new to GIS. It is very intersting.
I have installed Postgis, insert shapefile, get data in SVG without problem (ST_AsSVG).
Now, I'd like to export the same svg but in pixel to add it on top of ...
3
votes
1answer
124 views
How to Load RDF Data to PostGIS?
I want to load some sample RDF (Relational Data Format) to POSTGIS. Are there any tools or methods to do this.
1
vote
3answers
136 views
postgis under win 7 “on demand” not as a service
how do I install postgis2.0 under win 7 to run just on demand. I dont want to run it permanently as a service. Similary as the (nonspatial) mysql can be run on demand via the xampp-tools ...
2
votes
1answer
543 views
pgRouting: unable to execute routing_core.sql
I'm unable to execute the routing_core.sql, receiving following error.
I'm using pgAdmin III, Windows 7, PostgreSQL 9.1, PostGIS 2.0.
ERROR: could not load library "C:/Program ...
8
votes
2answers
171 views
Moving existing hard drive with PostGIS data directory to a new computer
I have a new computer that is replacing an old machine that has PostGIS installed.
The old computer has a 2nd hard drive where the PostGIS data directory is stored. I want to move this drive over to ...
0
votes
1answer
161 views
How to use ST_Length?
I want to calculate the lenght of the line inside the polygon.
If I do this:
SELECT ST_Length(ST_Intersection(ST_Transform('SRID=3035;LINESTRING(4000000 3000000,
...
1
vote
1answer
194 views
Adding table from Postgis
While trying to import a table containing raster data in QGIS , Raster column is not being imported ... I am getting following messages:
Database connection was successful , but the accessible ...
8
votes
1answer
203 views
How to get the length of a line inside a polygon
How can I get the length (brown marked part) of the "Road 7" inside the red polygon?
My start:
SELECT ST_Length(way) FROM lines WHERE road = "Road 7" AND ST_Intersects(line, polygon)?
With that, ...
1
vote
0answers
56 views
Make a thumbnail of a raster in PostGIS
I'm fiddling around trying to create a thumbnail of a fairly large (originally 27MB) raster, chunked into 64x64 blocks. I've got the following and it works, quite well, but I'm wondering if there is a ...
3
votes
1answer
192 views
gdalinfo gives no georeferencing information for a PostGIS raster
I have a PostGIS raster dataset which I am trying to access via GDAL. I've had various problems with making this work, so thought I'd try running the gdalinfo command to check that GDAL can actually ...
3
votes
1answer
338 views
PostGIS 2.0 ST_Transform with Rasters cannot find custom SRID
I'm trying to calculate an average value in a buffer around a point.
Given a raster in EPSG 4326 and a similar point, this is fine, except that the values will be skewed as they are not projected in ...
6
votes
1answer
1k views
PostGIS - 1.5 to 2.0 easy update
I have a PostGIS 1.5 database and want to update to 2.0. I read that because this is major release I have to follow the 'Hard update' procedure. However the spatial data I have is only test data so I ...
1
vote
1answer
109 views
How to select data inside a tile?
I have an OpenStreetMap PostGIS database and would like to select specific data (for example all shops) of each tile (on a defined zoomlevel) on the planet. Is this possible to achieve and if yes, ...
3
votes
1answer
378 views
remove duplicate points based on a specified distance
i have a table of points with each point acquired on a specified date, by a specified source, and having a measured value. i want to consider points as duplicates if they have the same date and if ...
19
votes
1answer
659 views
Nearest Neighbor problem in Postgis 2.0 using GIST Index (<-> function)
I'm trying to use Postgis 2.0 new function <-> (Geometry Distance Centroid) in order to calculate, for each row of my table (cosn1), the distance to the nearest polygon of the same class.
I was ...
4
votes
1answer
603 views
How to design model in Django using GeoDjango?
I am using Postgresql 9.0 and PostGIS 2.0. I am using Django 1.3 and GeoDjango.I have model with id,latitude,longitude and placename. All the places are in USA.
My requirement is following -
User ...
5
votes
1answer
445 views
Speed up pgRouting point_to_id using new <-> operator in PostGIS 2.0.0
The point_to_id function, which assigns a node id to a point based on existing nodes and tolerance, is using a query as follows:
SELECT
id, the_geom
FROM vertices_tmp WHERE
...
1
vote
1answer
312 views
PostGIS 2.0 and Postgres 9.1: ST_Transform => failed to load NAD27-83 correction file (Windowsx 64)
after making a clean install with the latest stable release of postgis (2.0) i can't perform any transformations:
SELECT ST_Transform(ST_SetSRID('BOX3D(2644033.2454124987 ...
16
votes
1answer
1k views
Comparison of geocoding solutions (such as Gisgraphy & PostGIS 2.0)
As I am sure many of you are aware, PostGIS has finally released Version 2.0 and included within this version they have also built a geocoder (see: http://postgis.refractions.net/docs/Extras.html).
...
7
votes
2answers
1k views
Postgis 2.0 upgrade problem with postgres data [SOLVED]
I have a serious problem:
on Wednesday, April 2 OpenSUSE 12.1 is updated, and the package was to update the PostGIS-a version 1.5.3 to 2.0.0.
After this operation, Postgres does not display records.
...
7
votes
2answers
859 views
Intersecting a raster with a polygon using PostGIS - artefact error
I'm using PostGIS2.0 to do some raster/polygon intersections. I'm having difficulty understanding which operation I should use, and what the quickest way of performing this is. My problem is as ...
9
votes
3answers
4k views
Loading a raster into a PostGIS 2.0 database on Windows
I'm trying to figure out how to load a raster into a PostGIS2.0 database (I have asked previous questions on this topic here and here). I am trying to use the raster2pgsql.exe program provided with ...
4
votes
1answer
1k views
Loading a raster using QGIS into a PostGIS2.0 enabled database
Following on from my attempt to install a postgresql 9.1 db with postgis 2.0 on windows 7, I am trying to figure out how to load a raster. I have successfully loaded a shapefile, and am trying to do ...
0
votes
1answer
302 views
Unable to Make PostGIS 2.0 - file not found
I am struggling to get the latest trunk of PostGIS to install on a fresh Mac running Lion. I did install PostGIS 1.5.3-2 for Postgres 9.1 from [KyngChaos Mac OSX Installers][1]. This setup worked ...
7
votes
2answers
982 views
How to run two PostGIS versions in parallel on Windows?
I'm trying to understand how to install PostGIS2.0 on Windows7. The PostGIS site has the following suggestions:
PostGIS Experimental Binaries PostGIS 2.0.0SVN Binaries with Raster,
Topology ...
