PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.

learn more… | top users | synonyms

3
votes
3answers
214 views

For the non-IT savvy GIS person (not great w/ Linux & Apache) could someone suggest how to set up PostgreSQL, Geoserver, and ISS/Apache?

I've heard of GeoCommon as being an easy GIS solution, but I'd like to host the data locally for internal users. I know of a group called Open Geosuite - but the ongoing maintenance is something I'd ...
2
votes
1answer
2k views

Why does ST_Transform fail?

I got a postGIS error like this, ERROR: transform: couldn't project point (100.496 13.7118 0): latitude or longitude exceeded limits (-14) SELECT ...
1
vote
1answer
54 views

How to update constraints if the table name was changed?

I modified the name of a Table in postGIS. But the constraints contains old table name. How can I change the constraints? Please help me.
1
vote
2answers
2k views

How to offset point perpendicular to line direction in PostGIS

I have a postgis table of points, that are sitting on road centerlines (I've linear referenced them). And the second table with road centerlines themselves. The point table also has a field roadid and ...
1
vote
1answer
243 views

Why are Postgis sequences not automatically updating in QGIS?

I'm adding new features to a polygon datasets in QGIS. The data is held in PostGIS but when i have a look at the attribute table for the polygon the gid field is not automatically updating, the entry ...
1
vote
1answer
382 views

osm2pgsql import crashed!

I am currently importing a bz2 country file into PostgreSQL 9.1 database for Nominatim 2 using its setup.php that runs osm2pgsql. After processing the nodes. it seems to be stuck at a certain spot ...
11
votes
5answers
3k views

How can I update ogr2ogr to include the PostgreSQL driver?

I'm trying to use ogr2ogr to upload a shapefile to a remote PostGres installation. When I ran this command: celenius:~ celenius$ ogr2ogr -f PostgreSQL PG:"host=255.34.00.00 user=postgres dbname=mydb ...
1
vote
1answer
333 views

PgRouting Driving Distance crashing postgis server

I haven't used PgRouting much so I'm a little in the dark here. However, I am attempting a driving distance calculation like the one described by Underdark here. My SQL is identical, I have a ...
1
vote
0answers
139 views

How to export dxf of window view from postGis MasterMap layer

I have managed to get qgis to show my Mastermap data which is stored in a postGis database. It's national coverage so seems to take ages to load but that's another question. I basically want to ...
4
votes
2answers
2k views

Publish SQL Views from Postgres/Postgis to Geoserver

I've trying and reading how to publish a Postgres/Postgis View in Geoserver. I know that I can create an SQL View in Geoserver, but I'd like to define the View in Postgres, not in Geoserver. Does ...
2
votes
1answer
105 views

cannot reproject postgis in mapserver

I am trying to set up a wms server using point data in a postgis (v 1.5.1, pgsql v 8.4) database and mapserver (v 1.5.1) (I know these are not the most current versions of anything, but my server is ...
2
votes
2answers
832 views

Importing planet files into Nominatim

After a gruesome night installing PostgreSQL 9.1, PostGIS 2 and Nominatim 2 on CentOS 6.3 using the instructions here, I am finally at the stage of importing a US planet file. Problem: In ...
3
votes
0answers
191 views

How to estimate the average width of a sidewalk? [duplicate]

I have a table with two polygons representing urban block with and without the sidewalk: geomBlock and geomBlockWithSidewalk. On my city we can approximate the polygons of geomBlockWithSidewalk to a ...
8
votes
1answer
5k views

How to import KML file, with custom data, to Postgres/PostGIS database?

By custom, I don't mean a different structure of KML file, but in <description></description> section, I have data with HTML tags of this kind: <?xml version="1.0" ...
4
votes
1answer
493 views

Problem processing OSM file with osm2pgsql

I have an OSM file and when I want to import it in my PostGIS base using osm2pgsql, I get the following error: Processing: Node(130k 8.7k/s) Way(0k 0.00k/s) Relation(0 0.00/s)Assertion failed: ...
2
votes
2answers
1k views

Export from PostGIS to SpatiaLite?

My PostGIS database contains OSM data from my country. For transportation reasons I want to export a spatial view I created from that data to a SpatiaLite database. Is there any way to directly ...
8
votes
2answers
473 views

postgis, extrapolate a line

I'm trying to extrapolate from a line segment to find a point on the line but a 3rd of the way 'back', i.e. trying to find point new, given points A and B below: Given a line, I can interpolate it ...
5
votes
1answer
303 views

Calculating path sinuosity in postgis

Sinuosity is a fairly straightforward concept. How can this be calculated in postgis given a series of linestrings that represent the path?
0
votes
0answers
271 views

assign_vertex_id error

I am trying to test if pgrouting works fine or not. To do so I have created a table containing the following attributes. Columns: gid | length | the_geom | source | target Now my ...
0
votes
1answer
341 views

Do postgres 9.1, postgis 2.0 from stackbuilder and pgrouting 1.0.3. work together?

I am new to pgrouting and I would like to check if the version I have installed works fine with postgres and postgis. I have installed postgres 9.1, postgis 2.0 from stackbuilder and pgrouting 1.03. ...
2
votes
1answer
579 views

How to upgrade PostGIS in OSGEO-Live Xubuntu virtual machine?

I have downlaoded the OSGEO-Live 6.0 virtual machine running Linux Xubuntu. I have it running through VirtualBox on a Windows machine. It currently comes preinstalled with a lot of GIS software, ...
1
vote
1answer
189 views

Qgis mapserver - Can it use plugins you use in qgis desktop?

Im thinking about developing a small python plugin for qgis which would access postgis raster database and return data via ST_AsPNG() for example. But since i need this in my wms, would it be possible ...
3
votes
3answers
1k views

How to Calculate length of polyline geometry for several tables in PostGIS?

PostGIS database contains several geometry (polyline) tables (with names "D1_r", "D2_r", "D3_r"). I calculate length for one "postgis layer" use request: SELECT ...
1
vote
0answers
99 views

Is this pgRouting perfomance acceptable for my tiny server?

I'm testing pgrouting functions in a tiny server with 2GB of RAM and a dual core processor. I wrote a program that create client process and they connect to the server in a specific hour to perform a ...
3
votes
2answers
3k views

How do I use st_dwithin with meters?

I am trying to follow PostGIS ST_Buffer Radius Help to use a 50 meter distance but postgis is returning an error. I am trying the following SQL, SELECT id FROM table WHERE ...
2
votes
2answers
3k views

PostGIS convert geography(Point,4326) to GPS

I got a database with a column of type geography(Point,4326), the data contained looks like 0101000020E610000092E057F66EF73140930035B56CBD4840. How can I convert it to GPS coordinates?
4
votes
1answer
225 views

ST_Intersects returns “incomplete” results

I've created a PostGIS database of bus stops and train stations (from the gtfs file of two transit authority -- CITLA is the bus and AMT_Trains is... well, the train). I've created a 200 meters ...
1
vote
2answers
2k views

How to display a image from Postgres database

I have Images in bytea form in PostgreSQL/PostGIS database, i want to display them in a webpage using PHP - PostgreSQL. I got lot of examples and I worked out but not getting output from them... Few ...
6
votes
6answers
2k views

How to calculate the maximum distance within a polygon in x-direction (east-west direction) in PostGIS?

I am interested in the maximum width of a polygon, e.g. a lake, in the east-west direction. Bounding boxes will help only in simple polygons but not in complex concave polygons.
4
votes
3answers
1k views

How to speed up Postgis raster layer display in QGIS?

i've been importing some digital orthophoto geotif files into postgis 2.0.1 via raster2pgsql tool (i also made 3 levels of an overview table - pyramid). Then i tried to import the layer into qgis via ...
5
votes
1answer
213 views

Given 2 LINESTRINGs with common point, how to extract common point?

I have 2 LINESTRING geometries. I know both share a common point. Using PostGIS for Postgres, what is the cleanest way to extract the common point? Example with illustration: How do I extract the ...
0
votes
1answer
352 views

How to get City, State, Numeration, etc from OSM roads by Geofabrik?

I'm really new in this GIS world. I downloaded a shp file from Geofabrik (http://download.geofabrik.de/osm/south-america/chile.shp.zip) and imported it to Postgresql using Postgis. If I see the road ...
1
vote
1answer
182 views

Creating admin roles with limited access to PostGIS

I'm trying to cram three different organisations into one server. Today they each have their own geoserver instance connected to separate PostGIS databases, which works fine. But now they also need to ...
3
votes
2answers
2k views

Is there a way to automatically populate attribute values in Qgis?

We are using a Qgis/PostGis combo, where Qgis is used for adding features with attributes into a PostGis database. Is there a way to automatically fill the attribute data values with some ...
2
votes
1answer
443 views

How to create a point table from a remote csv file?

The current approach that I am using to load a csv file into a PostGIS enabled database on a server is the following: -- create table CREATE TABLE points( id int, lat double precision, lng double ...
10
votes
2answers
411 views

What are the advantages/disadvantages of populating a PostGIS database with Raster information?

...as opposed to keeping the rasters as locally stored GEOTIFFs? I have a large project that will require making available approximetely 50,000, 10mb GEOTIFFs as WMS to an OpenLayers based web map. ...
3
votes
1answer
269 views

Splitting large PostGIS/GeoServer geometry for WMS optmization

I have a large geometry (MultiPolygon) for a (fictional) world map. It basically spans a large portion of the entire world: it's the difference between a buffered extension of the union of the entire ...
2
votes
3answers
973 views

adding non spatial attributes using geoserver

I am using Openlayers + geoext to perform transaction operations in postgis database using geoserver . i can insert spatial data into postgis but cannot insert other data like road name, road type in ...
1
vote
1answer
493 views

How to create a table with one polygon and one point?

using postgresql and postgis, i would like to create a table with one polygon and one point. then use st_contains to check if the point is inside the polygon or not. so first, I should create a table ...
0
votes
0answers
439 views

PostGIS geometry aggregation problem

i have a problem with aggregation of geometry either with ST_Collect, ST_Union, Array_Agg after doing intersection with transformed geometry. Faulty PSQL code goes like this: SELECT ...
2
votes
2answers
157 views

Select the lines that form a ring in postgis

I need to select all the ids of the linestrings that forms a ring, grouped by ring. For example, the 6 linestrings below CREATE TABLE lines(id INTEGER); SELECT AddGeometryColumn('lines', 'geom', 0, ...
3
votes
2answers
387 views

small difference in projection between tilemill and postgis

I would like to create a world map with interaction on continents created directly from a postgis database. For the moment, I have a POSTgis database with the data. I created a background with ...
4
votes
1answer
198 views

Using “Time” in PostgreSQL/PostGIS

I'm loading gtfs into a PostGIS database but I have a problem when loading my stop times. The data is in time format "00:00:00" and for 1:30 AM, my data is "25:30:00". I'd like to keep it that way ...
4
votes
0answers
93 views

Pros and Cons of virtualisation technology for database-server and datastorage [closed]

Yesterday we had a chat about performance and restorability and I realized how many good things a virtualisation environment can bring to me - but as I'm a little sceptic concerning performance I'm ...
2
votes
1answer
572 views

How can I get the corners of a polygon in latitude and longitude?

How can I get the corners of a polygon -a square/rectangle, to be precise- in latitude-longitude format by using its geom value -or some other way, perhaps-? Thanks.
2
votes
1answer
309 views

Shouldn't QGIS read the proj definitions from the spatial_ref_sys table?

I have serveral layers in PostGis that use a custom projection. I added the projection SRID and it's deffinition to the spatial_ref_sys table but, when I load the layer in QGis, I get the "Coordinate ...
15
votes
4answers
1k views

What are some high-profile websites that use OpenLayers and PostGIS?

I think there are many convincing arguments for using PostGIS but I am interested in showing people examples of websites that use PostGIS and OpenLayers. Some examples that I have seen are: ...
0
votes
1answer
287 views

Why is the database connection lost on every query?

Every time I started a query the connection with the database is lost. Anyone familiar with this problem? This problem occurs with various query, for instance: CREATE TABLE table SELECT a.*, ...
0
votes
1answer
480 views

How to insert non-spatial data through WFS-T insert?

When i perform wfs-t insert operation using postgis database only spatial data and primary key gets inserted. Can anyone point me to some examples in which attribute data are also inserted along ...
20
votes
4answers
8k views

What is the best way to join lots of small polygons to form a larger polygon?

I have the following layer using SRID 27700 in postgis: It's every administrative region in the UK, and (as you can see from the colour grouping) each of them has a text field specifying the county ...