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

learn more… | top users | synonyms

1
vote
0answers
50 views

Can't edit osm_roads in udig

There is a PostGIS database that has a road network imported from Open Street Map, stored in osm_roads table. For the testing purposes I need to change some road geometry there. I tried to edit it ...
1
vote
0answers
62 views

database-backed WMS service runs as transaction

I'm trying to tame a geoserver 2.3.2 installation (backed by Postgres 9.1 and Postgis 1.5) by determining which of the many, many layers are actually being used. To this end, I've set up an audit ...
1
vote
0answers
56 views

Query OSM ids by name in PostGIS

I installed PostGIS on a server and now I want to query the OSM ids referring to a name, in order to get a list of all geometries according to this name. Is there an efficient way to query this ids ...
1
vote
0answers
46 views

windows function with points in a mixed (multipoint/point) table

I have a table comprising multipoints (tracks) and points (stops between tracks). there can be several consecutive multipoints. now, i want to merge any points lying very closely to each other ...
1
vote
0answers
130 views

How can I combine these two commands? (Get a clipped raster ASC-II file from PostGIS)?

My objective is to clip a polygon from PostGIS raster table, and then save this raster (draw polygon shape) as an ASC-II in a folder. What I did now are 2 steps. 1st Step: Insert the clipped raster ...
1
vote
0answers
82 views

An algorithm for locating candidate labelling boxes within a polygon

Has anyone implemented this algorithm In PostGIS? Quoting from the paper: Vector-based geographic information systems usually require annotation, such as a polygon number or attribute data, in a ...
1
vote
0answers
418 views

How to add legend in WFS openlayers

How can I publish WFS openlayer with legend, have tried different examples such as http://api.geoext.org/1.0/examples/vector-legend.js. But when I tried using this firebug shows an error=> ...
1
vote
0answers
301 views

QGIS SPIT errors loading shapefile into PostGIS

With QGIS 1.8 on Windows 7, I just installed PostgreSQL / PostGIS and tried to load my first data into it, a shapefile using SPIT, but failed: ERROR: Geometry type (Polygon) does not match column ...
1
vote
0answers
119 views

Creating polygons for a choropleth map using PostGIS

I have a grid of points, each with a value to it as shown in the image below. The data was retrieved from PostGIS and rendered in Quantum GIS. The final result should be a polygons of a choropleth map ...
1
vote
0answers
374 views

PostGIS Better ST_Intersects Query

I am currently using the following queries to return all features that intersect a large and complex polygon. I initially tried to use a single ST_Intersect query but because the number of features it ...
1
vote
0answers
158 views

How can I map data points to OpenStreetMap (OSM) line data?

my goal is to filter measuring points of vehicles by mapping them to streets. So I could filter out all the false data located in fields and rivers and so on. I imported my data into a PostGIS ...
1
vote
0answers
237 views

Can I use RGeo::Point data in PostGIS queries without multiple conversion?

How can I represent RGeo::Point ( CAPI implementation ) in some way where I don't have to convert it once more in Sql? Now I have something like this: class Poly scope :enclosing ->(geom) do ...
1
vote
0answers
62 views

New geographical point won't show on map

I did recently ask a question about how to add a new point to a PostGIS table. Now when I've got the new point in the table it should be visible on my map, but it isn't. I'm using Mapnik together ...
1
vote
0answers
93 views

calculating st_simplify tolerance for openlayers

I want to display a vector layer in openlayers. Users can scale the map before they load the vector layer and I'd like to simplify the geometry with st_simplify before sending it to the client. Does ...
1
vote
0answers
260 views

View PostGIS geometry in QGIS

I am a newbie to GIS systems so please be patient. I have a PostGIS database set up with a spatial data table. One of the columns is of Geometry type and contains Points with SRID 4326. I want to ...
1
vote
0answers
76 views

How to import multiple shapefiles each with different source projections to postgis

I have a couple thousand .zip files each with a .shp, .dbf, .shx, and .prj inside them that I want to load into postgis. The problem is, they have many different source projections (each defined in ...
1
vote
0answers
114 views

Problems combining (union) Multipolygons in geodjango

I'm using geodjango and postgis (1.x), What is the best way to combine (union) a list of multipolygons. in what i assume is rather inefficient i'm looping trough like this combined = multipolygon ...
1
vote
0answers
248 views

working with multiple wfs-t layers

I am using multiple wfs layers and using editing tools in that like edit,draw,save etc. The code is shown here...... var district = new OpenLayers.Layer.Vector("district(wfs)", { ...
1
vote
0answers
76 views

postgis union geometries in consecutive order

Database is postgres 9.2, POSTGIS="2.0.2 r10789" GEOS="3.3.6-CAPI-1.7.6" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.8" i have geometries in consecutive order. Here is query: SELECT ...
1
vote
0answers
89 views

Postgis walk through multilinestring

Maybe question title not correct, i have no idea how to formulate my question. Database is postgres 9.2, POSTGIS="2.0.2 r10789" GEOS="3.3.6-CAPI-1.7.6" PROJ="Rel. 4.7.1, 23 September 2009" ...
1
vote
0answers
115 views

Are there limitations with gdal virtual raster option?

I am new at Postgis and I'm groping... I pretend to rasterize some weighty vector layers in Postgis, do some map algebra and reclassification with them and visualize intermediate as well as final ...
1
vote
0answers
360 views

How to merge linestrings which are connected with each other?

I would like to join linestrings which are connected to each other. The preferred output is a longer linestring based on all joined single linestings! The table that holds my single linestrings is ...
1
vote
0answers
168 views

Break LINESTRING values in postgis into mutiple LINESTRINGs

Figure A below is the visual representation of what i have in my road data set. Line 1, Line 2, Line 3 in illustration are each represented as 1 row postgis DB inside a geometry column, some of these ...
1
vote
0answers
88 views

How can I snap 2 lines in QGIS so the st_distance between them is 0?

Sometimes when I snap the ends of 2 LineStrings together and I check the st_distance between those endpoints I get a value in the order of 1.1E-10 while at the same time when I check for equality of ...
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 ...
1
vote
0answers
122 views

django + apache mod_tile

I'm not sure if I'm doing this right and I need your opinion on this current situation. I'm creating a Web Interface using django and postgres as the database. With regards to the slippy map, I went ...
1
vote
0answers
155 views

Why is not ST_GeomFromEWKB() working?

The following SQL is working fine from the terminal: SELECT MIN(ST_Distance( ST_Transform(ST_GeomFromText('POINT(-3.163916 55.926528)',4326),32630), ...
1
vote
0answers
162 views

Query to find lat/lon of a house by street.name & house.number

How can I get house coordinates (latitude, longitude) by street.name and house.number? If it is possible, how I can get it? Many thanks!
1
vote
0answers
116 views

Geoserver WMS and filtering tables with cyrillic column names

I try to serve PostGIS tables with Geoserver WMS (both 2.1 and 2.2). Some column names are in cyrillic. Problem is - service fails, when I try to filter by those cyrillic columns (both with CQL and ...
1
vote
0answers
87 views

How can I assign road names from OSM to gis linestrings using open source tools?

Starting with a shapefile of linestrings I want to assign street names to these lines if there is a match with a road/street in OpenStreetMap. There are no exact matches as the linestrings have a ...
1
vote
0answers
152 views

Convert native box to geometry

I have an old table that contains bounding boxes of lat long coordinates in a "box" type. How do I convert them to PostGIS geometry ? I tried using ...
1
vote
0answers
110 views

GeoServer and PostGIS connection technology

Does anybody know how GeoServer connects to PostGIS. Which technology is used? Is it JDBC? Thanks
1
vote
0answers
529 views

How to handle postgresql/postgis geometry type errors in a function?

I have created the following function in PL/SQL to make a polygon from a set of linestrings: CREATE OR REPLACE FUNCTION _myfunction( _fid integer, _rid integer ) RETURNS VOID AS $$ ...
1
vote
0answers
35 views

Is it possible to permanently save the Edit Widget for a Postgis layer?

Is there a way of configure the editing type for a POSTGIS layer through Edit Plugin and do not lose the changes after remove the layer or exit the program?
1
vote
0answers
143 views

How to config geoserver to read style of vector layer from postgis/SQL store?

I've imported vector layers from map info pro to both SQL server and post gis using easy loader. In both cases I've included style column in the exported table. When I create new store in geoserver ...
1
vote
0answers
191 views

How can I use Convex Hull to select an area with a space from the points?

This refer to this post : Read Here My goal is to select an area covering some points, but maintaining some space from points of border, like in the follow picture : I think ST_Convexhull will do ...
1
vote
0answers
47 views

Converting geometry_dump to Point geometry vertex

If this was a Point geometry 010100000001DE02098A1B52C090A0F831E62E4640, is it possible to represent the above geometry_dump Point Vertex. I am trying with St_collection...,
1
vote
0answers
160 views

Imposm full database schema import template

I noticed that the default imposm template for importing OSM data into postgis lacks some types of features (powerlines for example). I was searching the web to find a complete schema import template ...
1
vote
0answers
92 views

Calculating spaces between roads from PostGIS database

Is it possible to calculate the spaces between the roads using a select statement in a PostGIS/PostGre Database? I tried using some combinations of the predefined functions as ST_Intersects & ...
1
vote
0answers
206 views

Postgres function with BOX3D error “doesnt start with BOX3D”

everybody. I created function search nearest point (pois) by using pg_routing as folowing CREATE OR REPLACE function find_pois(inn_point text, distance int) RETURNS float[] AS --point(x y) $$ ...
1
vote
0answers
127 views

post gis command prompt problem

While I'm working in post gis sql command prompt its mode changing automatically. I mean that the general form of command prompt as follows template_postgis=#(we type query's here) While working ...
1
vote
0answers
178 views

How to view error feedback in qgis when testing connection to postgres database?

Using qgis 1.8 on Ubuntu 10.04 with Postgres 8.4.13 I am creating a new (and my first) Postgresql connection in qgis. I can connect to the user and the db using the pgsql client. ...
1
vote
0answers
744 views

searching GeoJSON features

After googling for many days and reading the OL documentation, I don't understand well how the filterToParams in OpenLayers.HTTP protocol should work, what I'm trying to do is to find and display the ...
1
vote
0answers
297 views

Why won't this PostGIS query display in QGIS

I am having trouble rendering the following PostGIS query in qgis1.803. SELECT s.musym, st_intersection(s.the_geom,f.the_geom) as geo, nextval('"soilsplittersequence"'::regclass) as k From ...
1
vote
0answers
66 views

Database has duplicate values after running pgrouting

I am a newbie with postgresql and sql statements so maybe it is a trivial question, I'm sorry for that. I am working on a postgis database and try to use the pgrouting function. My goal is to store ...
1
vote
0answers
114 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 ...
1
vote
0answers
95 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 ...
1
vote
0answers
382 views

Openlayers WFS Overlay Problem

a) I am running a PostGIS database, and I want to display a Table with a about 500 Points of Interest. The POIs have the projection EPSG 4326. b) Geoserver is installed, running and connected to my ...
1
vote
0answers
834 views

How to fire a query from OpenLayers to GeoServer to fetch 'the_geom' column in PostGIS table?

I am coloring the polygon shapes of world_country. I have OpenLayers in my UI, GeoServer as server and PostGIS as db. All I want is fire this query: select the_geom from world_country where ...
1
vote
0answers
2k views

Error when importing shapefile to Postgis database

I was trying to import shp to postgis database and i get the following error: Importing with configuration: adresy92, public, geom, C:\Users\tomek\Desktop\adresy92, mode=c, dump=1, simple=0, ...