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

learn more… | top users | synonyms

2
votes
1answer
409 views

How to import ECW into my postgis database with raster2pgsql (windows)

I'm working on windows 7 64 bits, postgis 2.01. I have to import ECW files into my postgis database. Unfortunatly, my postgis seems to has been compiled without gdal ecw support.When i do a ...
1
vote
0answers
255 views

How to import 3D geometries from DXF, VRML or X3D into PostGIS 2

we plan to develop a webbased 3D GIS using PostGIS 2 and GeoServer with a W3DS. The architecture works fine, but i have problems to import 3D geometries into PostGIS. The geometries come from AutoCAD ...
3
votes
0answers
162 views

PostGIS 2.0 st_geomfromgml using LineString fails with invalid GML representation

I am attempting to insert a geometry into a table using the st_geomfromgml function. The GML is being sourced from a Geoserver WFS request. The function call looks like this ...
0
votes
0answers
156 views

Create Polygon Overlay Handling Holes

How can I create a polygon overlay that correctly handles holes? This answer provides a method of creating a polygon overlay that does not handle holes. Can it be modified to correctly handle holes? ...
1
vote
1answer
407 views

Dynamically load and display shapefiles from PostGIS 2.0 into Mapguide using .NET

I have a C# mechanism for Loading shapefiles into PostreSQL/PostGIS now I would like to dynamically load it on Mapguide fusion template.In either C# or VB.NET code behind. Use case is: 1.use uploads ...
2
votes
1answer
90 views

problems setting up postgis and importing data

Using Postgres 9.2.3.1 on a new Mac. I installed Postgres from the dmg file that I downloaded from the Postgres site. I then installed PostGIS using stackbuilder. This all worked flawlessly so far ...
1
vote
0answers
158 views

Renaming Columns in Geotools FeatureType

I am attempting to build a simple java program that loads shapefiles into a Postgis 2.0 database. Everything is working out great except that I would like to be able to modify the FeatureType in the ...
2
votes
1answer
278 views

How to Find the Nearest Node from a Given Coordinate

I have already developed a table manually. It contains the coordinates and the distance of all the nodes, there is no geom field or any field related to postgis. But I want to find out the nearest ...
3
votes
2answers
872 views

PostGIS - incorrect result distance between two points

I am quite confused the way PostGIS is returning the result for this basic query. So I am trying to find the distance between two points 45.2714,71.2087 and 42.3739,66.39 and the distance should be ...
2
votes
1answer
557 views

How to visuilze PostGIS data in GeoJSON format with PHP

I need to visualize PostGIS Geometry column as an overlay of a Leaflet tiled Map. I started a question here ,but didn't get any simple and satisfied answer. So I am starting this question. I got an ...
5
votes
1answer
461 views

How to snap line string start & end vertex to the nearest point?

I have a point layer and a line layer. The points are road junctions, collected using DGPS, while the lines are the connecting roads, collected through Handheld GPS in tracking mode. As a result, the ...
19
votes
1answer
1k 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 ...
1
vote
2answers
178 views

Is the PostGIS documentation correct for ST_Project?

In example of the page ST_Project the select is SELECT ST_AsText(ST_Project('POINT(0 0)'::geography, 100000, 45)); st_astext ------------------------------------------ ...
5
votes
1answer
517 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 ...
0
votes
0answers
64 views

how to group interconnected edges inside a table?

Given a table and a random set of edges with source and target columns, how can I find out which edges connect with each other and then group them together using PostgreSQL?
1
vote
0answers
48 views

given sets of vehicle passing on each edge, how to get most used vehicle to avoid transition?

I have two tables: one, the resulting table from converting osm.xml via osm2po so I can use pgRouting, and another one that contains information on what edges each public vehicle passes through ...
3
votes
1answer
440 views

Transit Routing using pgrouting as core routing engine?

i'm a student and i'm working on a project. the aim is given two sets of coordinates(origin & destination) route through the map to determine the optimum path using public transportation and of ...
0
votes
0answers
682 views

PostGIS data visualization

I have dump my data in PostGIS from shapefile successfully. I made a postgres connection through PHP and that also returning the data of other field. But the main problem is GEOM field visualization. ...
1
vote
1answer
346 views

error performing wfs-t insert in postgres 9.1.4

I am getting error performing insert exception while performing wfs-t insert operation when i use postgres 9.1.4 and postgis 2.0. but i get successful insert when using postgres 9.0.1 and postgis ...
7
votes
2answers
398 views

How to get distance between one point and all other points in a table?

I have a table in Postgres with lat and long columns. Can I use the ST_Distance_Sphere or ST_Distance_Spheroid methods to get the distance between one point and all other points in the table? Do I ...
16
votes
1answer
182 views

Can we create views over a raster table in Postgis2.0?

Is it possible to create PostgreSQL views over a table that contains raster data? I have succeeded in creating the view but the entry in raster_columns is not correct (all the raster info is ...
2
votes
1answer
202 views

How to filter or query data in GRASS?

I have a PostGIS dataset with just over 2 million rows. Each row has a PostGIS geometry point value and several attributes. I'd like to do some analysis on certain subsets of the data, but I can't ...
2
votes
1answer
184 views

Problems with QGIS (v 1.8.0) layer labels [closed]

I have a PostGIS (v 2.0) layer representing lakes. The attributes "chinchar" and "chintrans" contain Chinese characters and Pinyin (Roman) characters in UTF8 format. When I use Layer -> Labeling in ...
3
votes
1answer
706 views

How to render PostGIS raster with Mapnik XML?

I'm trying to manage raster files from PostGIS, which to be rendered using Mapnik. I used raster2pgsql to load those GeoTIFF images to PostGIS, and I think the loading process turned out OK. The ...
2
votes
1answer
119 views

Join Zip Codes Table to Nearest City from Second Table

I have two tables, siteareas and ziplookup. The former contains large cities in the US; the latter all US zips with lat/lngs. I have a foreign key into the former table in the latter: sitearea_id. I ...
0
votes
0answers
82 views

Can't drop table with geography column

I imported shp to postgis 2.0.1 with shp2pgsql and chose to use geography instead of geometry. However, now when I try to drop the table, the pgadmin/sql console/phpPgAdmin freezes. I can't neither ...
7
votes
1answer
505 views

How to set up GeoDjango with PostGIS 2.0?

I would like to run GeoDjango (Django 1.4) with Postgis 2.0. Whenever I try to run syncdb I get the following error for geographic fields: Failed to install index for stores.Store model: operator ...
3
votes
1answer
290 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.
2
votes
1answer
821 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 ...
0
votes
1answer
139 views

Open Source GIS Problem [closed]

I am new at open source GIS platform. I am using Ubuntu 12.10. I have tried to install the followings but without 2-3 tools I could not install anyone. Can any body help me how can I install the ...
2
votes
1answer
358 views

Querying PostGIS Raster with MultiPoint

For one of my projects using PostGIS 2 I have a table with GPS tracks (igc_files). It holds records including a MULTIPOINT() column that has about 1,000 points for each record and a column that has an ...
3
votes
1answer
939 views

Postgres/Postgis doesn't work after update

I work on OpenSUSE 12.1 and after today's upgrade (2012 NOV 14) Postgres and Postgis doesn't work. If I login to Postgres server by PgAdmin, get the message: translated from polish "ERROR: can't acces ...
2
votes
1answer
542 views

How to fix 'GEOSDifference: TopologyException'?

Why does Postgis throws an error in this SQL? Error: ERROR: GEOSDifference: TopologyException: found non-noded intersection between LINESTRING (-5.67027 43.5374, -5.67085 43.5376) and LINESTRING ...
3
votes
1answer
397 views

nearest neighbor within table using PostGIS

using PostGIS 2.0 and PostgreSQL 9.1 I have a table of photographic observations, sco_photos. The location column contains a PostGIS geometry point specifying where the observation was made. The table ...
-1
votes
1answer
185 views

PostGIS raster support

I have the following requirements to manage raster data 1) Convert raster-maps from BSB format to PNG or GeoTIFF 2) Cut the borders of the map 3) Merge individual maps to form a contiguous coverage ...
2
votes
2answers
513 views

What's the fastest way to search for polygons that intersect with others?

I'm querying the database for searching polygons that intersect with others, but is very slow research, wanted to increase the speed. I thought of using sphinx, solr, elastic search googled but did ...
1
vote
2answers
131 views

st_intersection; What Im doing wrong?

Im trying to run this query : create TABLE data.agri_grc as select id, code_00, ST_Intersection(data.agri.geom,data.grc_bor.geom) as geom from data.agri; But im getting this error: ERROR: missing ...
2
votes
1answer
51 views

How do I append PostGIS commands to the system path?

I'd like to be able to call psql instead of having to put in the full path everytime. I went into Environment Variables through My Computer and added the path to the semi-colon separated list, but ...
0
votes
1answer
216 views

What is the fastest way to identify the two nearest linestrings using PostGIS?

I want to be able to identify the closest roads to two points that are generated through geocoding (a start and end address). The points will likely be near a linestring. Two approaches that I have ...
5
votes
1answer
3k views

Postgis 2.0 - public.geometry_columns view does not contain correct info for views

We have recently updated our database to Postgis 2.0. In our system we used to create views for tables containing a geometry column. After creating the view we also manually updated the ...
8
votes
1answer
439 views

Are Zonal Statistics possible in PostGIS2?

Now with postgis2 which supports rasters by default is it possible to do a zonal statistics analysis? I've google it but I haven't found anything solid? Is there a tutorial outthere to get me ...
2
votes
1answer
803 views

How to find polygons inside polygon with PostGIS 2.0

I have a relation representing all the counties in my country and the other one containing all the districts - e. g. each and every county is composed of several districts. How do I select them with ...
2
votes
1answer
688 views

Access PostGIS Raster layer through mapserver

I am trying to use a cgi script calling mapserver to display a raster layer that is stored in a PostGIS database. However, only a blank white image is returned and I don't know where the problem is. ...
2
votes
3answers
1k views

How to import data with SRID 4269 to GEOGRAPHY type?

In PostGIS, we are importing various US census bureau shapefiles (with SRID = 4269) using shp2pgsql loader. I have medium-sized database with several tables containing fields of type geography ...
0
votes
1answer
1k views

How to export data from QGIS to display in Google Maps?

I'm exporting layers of a project for a quantum gis postgis table and visualizing the data in gmaps, but the coordinates are very wrong. is there any special way to export the quantum gis? postgres ...
2
votes
0answers
3k views

Create a stacked bar chart with matplotlib [closed]

I'm trying to create a stacked bar chart in python with matplotlib and I can draw my bar one up the other # -*- coding: utf-8 -*- import psycopg2 import matplotlib.pyplot as plt import numpy as np # ...
-2
votes
1answer
459 views

Postgis error on select all intersetcs of a polygon [closed]

i can get all polygon on intersects this:-7.9245860488441 -37.122384500713,-7.9245860488441 -37.11904223938,-7.9233955716106 -37.1187601948 SELECT * FROM propriedades WHERE ST_Intersects( ...
3
votes
1answer
268 views

How can I find the nearest points (plural) on a line segment using PostGIS

I'm locating the nearest point on a line segment with PostGIS and ST_ClosestPoint, I can select the point on each of these line segments which is closest to the starting point. Which looks something ...
4
votes
1answer
2k 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 ...
1
vote
2answers
311 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 ...