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

learn more… | top users | synonyms

1
vote
0answers
113 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
132 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
153 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
108 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
76 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
135 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
109 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
369 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
34 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
132 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
164 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
43 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
155 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
160 views

Error recognising password; importing OSM to PostGIS in QGIS

When selecting OSM Tools (Import into PostGIS) , attching my .osm file in the Input option, selecting my OSM Database, and then clicking run, I am prompted to enter a password for connection. "Enter ...
1
vote
0answers
88 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
188 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
119 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
168 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
668 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
277 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
64 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
97 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
94 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
359 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
718 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
66 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 ...
1
vote
0answers
161 views

PostGIS reports invalid Curve GML

PostGIS version POSTGIS="1.5.3" GEOS="3.3.1-CAPI-1.7.1" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.3" USE_STATS Postgresql version PostgreSQL 9.1.2 I'm having issues inserting Curves into a ...
1
vote
0answers
439 views

How to display indoor map using OpenLayers?

I created my osm file in JOSM, and i imported it to my database by osm2pgsql tool. I created new layer in my osm.xml file, which selecting data with query: select way from planet_osm_line, (select ...
1
vote
0answers
980 views

how can we save vector files in openlayers

i'm using Postgis + tomcat + geoserver + openlayers for my application. with the help of some tutorial i have reached upto gettting feature information of layers. Next i want to edit and save ...
1
vote
0answers
599 views

Geometry contains non-closed polygon: GeoServer output from PostGIS

I have imported a shp file using PostGIS shapefile loader plugin for pgAdmin3. The geometry type of the table created is MultiPolygon. I have cross checked the same using the following query. SELECT ...
1
vote
0answers
251 views

Add building height from xyz points in PostGIS

I have been trying to get this query right and just can' seem to. I have a building polygon table with over 7 million polygons, indexed I then have a grided height XYZ table with attribute 'height' ...
1
vote
0answers
91 views

How to maintain schema when copying feature from layer 1 to layer 2, where both layers have same schema?

If I load two unique layers, wherein each layer contains unique data, but both layers share the exact same schema, why is it when I copy a feature from layer 1, and paste it into layer 2, the ...
1
vote
0answers
219 views

Manifold 'Link drawing to query' - can I do this in QGIS?

Manifold GIS allows the creation of dynamic drawings linked to queries. Unfortunately I do not have access to Manifold as my employer refuses to pay for it, so am currently investigating ...
1
vote
0answers
239 views

Live KML Feeds - From the Ground Up, How Would You Build It and Why?

I found the "Live KML from PostGIS to Google Earth" post very informative but a bit daunting for someone new to the open source world of products like PostGIS and GeoServer. If I am building the ...
1
vote
0answers
604 views

Cannot Display Data From POSTGIS

I try to display the data that I have converted shp into PostGIS database with MapServer and OpenLayers. When I try to show directly shp file is successfully displayed in OpenLayers, but when I try to ...
1
vote
0answers
158 views

How to add column “EDGE” in pgRouting?

I am a newbie in PostGis and pgRouting. I have installed and configured both on my windows PC, following FOSS4G tutorial. I am able to see the result in browser, using GeoServer and OpenLayers. ...
1
vote
0answers
93 views

Getting started with storing LoST and GML searching

I am working on a logging and search database application. The application will receive event records containing XML LoST values (RFC5222 Location-To-Service-Translation). These records will be ...
0
votes
0answers
13 views

How to ensure that Tilemill interprets my postgis query as intended?

One of my layers (a postgis query from my local osm2pgsql database) is being translated incorrectly in Tilemill. The query is attempting to select the way, the area of the polygon, and the sport=* ...
0
votes
0answers
20 views

Consult the charts of a line

I have a table of bus lines and other bus stops in PostGIS. Are conformed to the image below, the lines and the stops on the sides. I want to relate the lines with parades through a spatial query. ...
0
votes
0answers
22 views

OpenStreetMap Road and Polygon Data as 1x1 Degree Shapefiles

I am working on a global project for which I want to use OSM data as a model input. I am looking for advice on the best way to produce 1x1 degree WGS84 shapefiles from either regional extracts or the ...
0
votes
0answers
7 views

Credential Dialog, disabling default Realm information messages disclosing password

I'm using the QgsCredentialDialog for determining user access to the database. When a user is failing to log in correctly the log in credentials are shown in the dialog (Fig. 1). Despite the ...
0
votes
0answers
4 views

Query from plugin that shows result on Map and in Attribute Table

I'd like to create a plugin that performs a static (no user input required) query that, based on a condition, selects all the features on the map and displays these in the attribute table. I have the ...
0
votes
0answers
29 views

How to get create new object right in postgresql

I created a .shp in QGIS successfully and now i want to move on this to postgis db, following this command shp2pgsql -s 2964 roads.shp lakes_new | psql qgis_db but i got this error how to solve ...
0
votes
0answers
25 views

PostGIS: calculate width/length of rectangular surface

I have rectangular shaped surfaces (multipolylines) and I need to calculate the width and/or length.. they have a rectangular shape but they're not real rectangles. Is there a way to do this ?
0
votes
0answers
30 views

PyQGIS loading layer style with PostGIS

I'm loading layer styles from .qml files in a Python plugin. I'm about to switch to loading them from a non-local postgreSQL db. I've been looking at the (from QgsVectorLayer (v2.2)) ...
0
votes
0answers
20 views

Double version of PostGIS installed on my server

For some reason I messed up an installation of Postgis on my PostgreSQL 9.2.8 server. I had version 2.0.3 installed and when I tried to upgrade to 2.1 it did so. The problem comes when I dump the ...
0
votes
0answers
25 views

PostGIS 2.1 error install with shared object (rtpostgis-2.1.so") Linux Mint

I've Installed Linux Mint 16 mate and install PostGIS with PostGreSQL (I've tried many ways in the Internet from original source to some suggestion) but all is too error: " ERROR: could not load ...
0
votes
0answers
61 views

How to add a Geoserver WFS layer with data imported from PostGIS to OpenLayers?

I know that there are very similar answers to my question but I just can't find how to solve this problem, so I am wondering if my case is different or if I am doing something wrong here. I am trying ...
0
votes
0answers
30 views

PostGIS : check if 2 lines are at contrary sides of third line

I am looking for a workflow to select a line on the condition that it is located on the contrary side of a middle line. So there are 3 lines (2 are given, 1 I want to select). I don't need you guys ...
0
votes
0answers
23 views

Multiple Centroids within a dataset based on distance

Is there a way that we can find out the centroids of clusters within a dataset while differentiating one cluster from other based on distance not on any attribute value. The dataset is present in ...