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

learn more… | top users | synonyms

2
votes
0answers
565 views

Clustering table on geohash index and geohash ordered table

I wonder if there could be a performance gain to re organize the rows in a table by Geohash and then CLUSTER this table on the Geohash index of the geometries. CREATE TEMPORARY TABLE tmptbl AS SELECT ...
2
votes
0answers
122 views

Installing knn on PostgreSQL for windows

I am trying to install the extension KNN for clustering as an extension on my PostgreSQL database. I have downloaded the file http://www.pgxn.org/tag/analysis I found instructions on how to ...
2
votes
0answers
28 views

Spatial overlay data from many lines into a single line

Hello I have joined lines in my data set into longer lines (based on similar attributes) to reduce the number of rows in my data set. Now I want to take the information from the original smaller lines ...
2
votes
0answers
382 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 ...
2
votes
0answers
110 views

Storing features in PostGIS and then creating layers using queries

I have a whole set of line segments or tracks that represent real tracks or, in some case, boundaries between areas. These segments form a network of lines on the map. I have a number of GIS layers, ...
2
votes
0answers
139 views

How to Create database using OGC compliant geometries and Custom type Geometries?

I am interested in storing geometry attributes in a PostGis database, so that it would be OGC compliant, along with OGC compliant geometry types like point,line, linestring, etc. I also wanted to ...
2
votes
0answers
97 views

Table for feature layer in PostGIS database cannot be published and enabled on GeoServer

I have tried to publish a table for feature layer in a PostGIS database to GeoServer 2.2.5. The layer was added and published. However, the layer has got a yellow exclamation mark in the "Enabled?" ...
2
votes
0answers
33 views

Automatic insert of project name into database

For every layer I've a field in my postGIS database that should be filled with the name of the current project and today I do this manually. Is there a way to do this with the Commands that can be ...
2
votes
0answers
279 views

Different results given by PostGIS and MySQL?

I'm developing a spatial database of administrative areas. I started out with PostGIS, but as MySQL is being used in our other projects, I thought I would at least try to create a spatial-enabled ...
2
votes
0answers
188 views

Projecting PostGIS in Openlayers

I have a layer(base layer) with MultiLineString Geometries and now I need to project the layers(overlays) in the base layer from PostGIS using OpenLayers. However, I got an idea how to project table ...
2
votes
0answers
46 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?
2
votes
0answers
615 views

why preview image is blank for ImageMosaicJDBC (postgis raster) layer?

I follow http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html to publish a ImageMosaicJDBC layer in geoserver. the layer seems published ok and saved, but the preview of this layer ...
2
votes
0answers
269 views

From pgRouting shortest_path back to osm node id

I'm successfully performing path finding queries like shortest_path on data imported with osm2pgrouting. The tables I have inside my pgrouting DB are the following: List of relations ...
2
votes
0answers
204 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 ...
2
votes
0answers
276 views

Postgresql Query Plugins Not Returning Results in QGIS

I'm using the Fishnet function as described here to create a grid. If I use the following SQL to call the function to position a grid where I want it (I'm using NZGD2000 SRID = 2193) the query ...
2
votes
0answers
219 views

Displaying text from dxf in Openlayers

I managed to import .dxf into Postgis table, and now have, among others, rows with Point geometries and values in text column (which corespodent with Label values from ACAD .dxf). What is the best ...
2
votes
0answers
90 views

MultiPolygon from database

I would like to know how to create an instance of a Multipoint from a PostGIS database.. I do the query , then got the ResultSet named "area" , the column with MultiPolygon attributes is named "geom" ...
2
votes
0answers
320 views

Parcel ID Mapping (brainstorming)

In my project I have a table full of residential properties by Parcel_ID. Table 2 is a TIGER streets shapefile. I would like to build a query in MS Access displaying all properties within a mile ...
2
votes
0answers
97 views

network related issues arising when running an arcpy script

Essentially I wrote an arcpy script that is within a toolbox that I ported over to a different machine to test out after the script worked locally. The script essentially utilizes the psycopg module ...
2
votes
0answers
103 views

Symbolizing Layers from a PostGIS Database to many Client Computers

I was hoping someone could help with a symbolizing issue. I have a PostGIS database on a server with a number of layers. The layers of a series of polygons, lines and points that all share the same ...
2
votes
0answers
396 views

line segments using points

Is there a way to get line segments from a linestring using points with lat/lng coordinates? ST_Line_Substring is taking float8 start/end points. Is there a way to replace the float8 with lat/lng? I ...
2
votes
0answers
499 views

Arc by center point in PostGIS does not fit the circle

I'd like to store a GML ArcByCenterPoint in PostGIS. I can work out the start, middle and end points required by the CIRCULARSTRING type and all seems to be OK, except that when I visualise the arc it ...
1
vote
0answers
6 views

ST_Split and looping problems PostGIS

I am a total PostGIS noob, and am having trouble understanding the finer points of SQL syntax. I am trying to take a large set of line data and clip it with a polygon. I then want to create a new ...
1
vote
0answers
13 views

Tool, API of or code samples for calculating spatial similarity between Lines

I migrating a database with a road network to an other external data provider. We have joined our own data about roadworks, temporary speed-limits etc. using ID en Linear referencing on this data. So ...
1
vote
0answers
10 views

pgRouting. pgr_ksp() returns -1 as id3

The documentation (http://docs.pgrouting.org/dev/src/ksp/doc/index.html) says that the result should be 0 for the last row. Is the same 0 than -1? I'm new on this. Thaks for the help.
1
vote
0answers
23 views

How to display table with more than one image from postgis in mapserver?

I have 3 tif files in one postgis(2.1.5 ver.) raster table. ( load with raster2pgsql) And i have mapserver MapServer 6.1-dev. I need to display table from postgis in qgis via mapserver. P.S I trying ...
1
vote
0answers
10 views

Replicate results from JSI using PostGIS

I am using OSM and facing an issue with finding the nearest road-segments to a given lat/lon point. I have a code that uses Java Spatial Index JSI which traverses the RTree index while computing the ...
1
vote
0answers
24 views

Mapserver display empty map when i add more then 1 raster file in 1 table postgis

Here is a part of mapfile with layer and WMS: WEB METADATA wms_title "Diplom" wms_abstract "no matter" wms_onlinesource ...
1
vote
0answers
23 views

GeoServer: Get styles from PostgreSQL/PostGIS table

We're running GeoServer with all layers coming from a PostGIS data source. Most people work directly on the PostGIS database, but we have one person sitting 10.000km away, and for him, connecting to ...
1
vote
0answers
21 views

Postgis - Creating Ellipse in WGS84 with metric parameters

I have points in WGS84 (x,y), radiuses in meters (rx, ry), rotation angle in degrees. I would like to create a new WGS84 geometry. I've tried this but the major/minor distances seem to be off by a ...
1
vote
0answers
25 views

How to generate arcs from attribute data?

What I am trying to achieve is an ellipse-like shape from a digitised point location and cardinal measurements. For example, point location at 531500,181500 with the attributes North - 4m, South - ...
1
vote
0answers
32 views

Batch load multiple shapefiles to Postgis

According to the shp2pgsql help, the options drop, append, create and prepare are mutually exclusive. So, if I want to create a table from a shape and then append multiple other shapefiles, I do ...
1
vote
0answers
37 views

pgsql2shp: create shapefile from empty table, but with known attributes (dbf)

I was trying to generate shapefile from postgis tables using pgsql2shp. Everything is fine except for table with no rows. When trying to create shapefile from an empty table, an error occurs: Could ...
1
vote
0answers
21 views

How to highlight joined features?

I have a task in QGIS (2.6), where I need to join two tables through an action (I think). I have some projects (points) that I need to connect to a list of partners (also points). I have data in both ...
1
vote
0answers
35 views

Dividing a geographical area (bbox) into smaller equal sized square miles

I'm working on an automated system for processing geographical information by bbox using PostGIS with an Openlayers 3 UI. The user will use dragbox to 'draw' the bbox they want processed. The catch ...
1
vote
0answers
36 views

Is there any VRP solver in Pgrouting 2.0?

after looking at older posts and googling for a while i guess there is not vrp solver (multiple trucks). there was DARP in pgr1.x but i can't see it in 2.x. i found a lot of information on ...
1
vote
0answers
50 views

Export DGN to shape or postgis with multiple mslinks

I need a command line tool to export DGN files to shapefile or PostGIS, I tried ogr2ogr but it only exports type, level, graphicgroup, colorindex, weight, style, entitynum, mslink and text. I need the ...
1
vote
0answers
60 views

Create polygons enclosing same number of points on PostGIS

I have a geodatabase on Postgis with points representing customers, what i need is give a number of customers, lets say 100 and it need to generate polygons enclosing 100 clients each one. I only ...
1
vote
0answers
242 views

Using ArcMap 10.3 with PostgreSQL 9.3.x database and PostGIS 2.1.1?

I have a PostGIS database that we use for data storage. I would like to open this data in ArcMap instead of storing it in another format. In previous versions of ArcMap it has been possible to open ...
1
vote
0answers
27 views

Searching a table within PostGIS using PyQGIS script

Morning all, I am looking for some guidance in trying to set up a script that will search a PostGIS database using a wildcard and then open a certain file directory that will be in one of the fields. ...
1
vote
0answers
29 views

How to correctly upload Shapefile into PostGIS on ubuntu?

I want to know how to use upload shape file via Postgis. Can u please help me? .com/nsVuQ.png
1
vote
0answers
26 views

From Openlayers 2 report generation

Can u suggest how a JasperReport can be geneated by an user accessing an point (say a wireless tower in map) on a active layer done in openlayers 3. Here the architecture uses openlayers 3 and is ...
1
vote
0answers
22 views

How do I step into the C++ functions from an external Python app I'm debugging?

I just wanted to see how to step into the C++ class QgsVectorLayer()'s methods from the python call to QgsVectorLayer(self.uri.uri(),'foo','postgres'). I'm trying to debug and it trying to step into ...
1
vote
0answers
95 views

How to create projects in Tilemill Ubuntu Web service?

I have set up Tilemill on a Ubuntu server and successfully accessed it from browser using TILEMILL_HOST:20009 I have already uploaded planet_osm data to postgresql/PostGIS DB in the same server ...
1
vote
0answers
142 views

PostGIS: snap latitude/longitude input to nearest OSM road point

I need a function to return the nearest OSM road point for any latitude/longitude. i.e. users input a latitude/longitude and postgis finds and uses the point on a road that is the nearest to it. ...
1
vote
0answers
32 views

Postgis routes diagram point-to-point

I have a set of centroids to which are related a set of points characterized by linename. The table with the points contains these fields: id ¦ linename ¦ lat ¦ lon¦ I would like to make a diagram ...
1
vote
0answers
68 views

Create GeoServer SQL View with variable number of arguments ( double precison [ ] )

I was trying to create a PostGIS procedural function which will perform a particular operation depending upon the user's provided coordinates. But since the user can provide any number of coordinates, ...
1
vote
0answers
30 views

How to Increase the length of column type geometry in postgres(pgAdminIII)

I am just wondering is there any way to increase the default length of column type geometry in postgres. Since we are trying to save large number of vertices polygon in to the geometry column geom in ...
1
vote
0answers
45 views

Import .gfs file into PostGIS?

Is it possible to import a .gfs file into PostGIS? I can open the .gfs file in QGis, so I assume it is a geographic file of some kind: but I'm not sure how to get it into PostGIS. I have Googled but ...
1
vote
0answers
90 views

Simplifying geometries and calculating non-spatial averages

I'm quite new to using proper spatial tools, and have a simple question that doesn't immediately show up on google. I have a table that contains multiple rows of empiric data (say, speed of a ...