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

learn more… | top users | synonyms

1
vote
1answer
34 views

Geoserver GeoWebCache caches tiles of incomplete layers

I have data in a PostGIS database that is being pulled into Geoserver using a PostGIS (JNDI) store. The dataset I am using is a continuous polygon grid, but the dataset itself isn't all that large. ...
1
vote
0answers
23 views

PostGIS is not seeing any GDAL drivers

I've tried setting POSTGIS_GDAL_ENABLED_DRIVERS=ENABLE_ALL as an environment variable. As well as running SET postgis.gdal_enabled_drivers = 'ENABLE_ALL'; from psql. (With a pg_ctl restart after each) ...
4
votes
1answer
65 views

PostGIS: Strategy for fastest select by BBox with an ORDER BY polygon area clause. Cluster?

Update 2 (below) suggests 14% of the table geometries are stored out-of-line with the rest of the table records. This may be a useful clue. The Problem: We've got a table with appx 170,000 WGS84 ...
0
votes
1answer
42 views

find all circles intersecting another in a table [duplicate]

I am using postGreSQL (9.3) and postGIS (2.1). I have a table containing names and circles (point + radius). Given a name and a circle (point + radius), I would like to find all the database lines ...
0
votes
1answer
19 views

Preserving styles when going from KML to WMS

I'm currently losing styling information somewhere along my chain of applications: KML -> ArcGIS Layer (via ArcGIS Desktop) ArcGIS .gdb -> PostGIS via ogr2ogr PostGIS -> GeoServer GeoServer ...
0
votes
0answers
9 views

Extract table-embedded attributes in KML using ogr2ogr

I'm loading a number of diverse data files into a PostGIS database, using ogr2ogr. One of these data files is a KML with useful attributes embedded as an HTML table in a description column: ...
4
votes
2answers
149 views

PostGIS: ST_Equals false when ST_Intersection=100% of geometry?

I have 2 datasets consisting of cadastral parcel data - roughly 125,000 rows each. The geometry column is WKB polygons representing parcel boundaries; all data are geometrically valid (the polygons ...
0
votes
1answer
37 views

Exporting layers from ArcGIS into PostGIS while preserving attributes such as color

I have managed to import/convert a KML into ArcGIS 10.0 (ArcMap) using the built-in conversion tools and now have a series of layers. Next, I export these layers to a PostGIS database using the ...
2
votes
2answers
62 views

Find the area of points in PostGIS?

I have points that form a line. I would like to assign a radius to each point to give them volume, e.g. 50m and then find the area of the combined points. Does anyone know of a way to do this in ...
0
votes
1answer
33 views

Calculate area of a raster for an irregular polygon in PostGIS

I have a number of polygons with irregular shapes (i.e. non-rectangular) and want to calculate their areas after I have converted them to rasters. Here are my steps: Convert my geometry to a ...
0
votes
0answers
48 views

Implement Leaflet search box for 370,000 points stored in PostGIS served as raster tiles

I have built http://opentrees.org. It's a TileMill/PostGIS/Leaflet stack with raster tiles and UTFGrid interactivity. I'd like to add a search box, so users can search for a feature – trees in this ...
0
votes
1answer
37 views

Creating point using ST_GeomFromText with SQL parameters?

I'm trying to insert points using C# into a PostGIS / PostgreSQL database. I'm using the Npgsql driver. I suspect this is less a driver issue and more a syntax issue due to me being unfamiliar with ...
0
votes
0answers
33 views

ST_MakePoint returns an error when using Python

I am trying to use ST_Point or ST_MakePoint to create points from a table of latitude and longitudes coordinates. However I am consistently getting an error even when trying the examples. For example ...
0
votes
2answers
44 views

How to make interactive OpenStreetMap layers in TileMill?

If I'm reading the UTFGrid spec right, you can only have 65,501 different interactive features. Or more precisely, every feature needs a unique ID in the range 0-65501. TileMill uses UTFGrid for its ...
0
votes
0answers
36 views

GeoDjango: Find all points within radius?

I am working in GeoDjango (with a Django 1.7 and PostGIS 2.1.4 backend). I have a model with a PointField in my database and I am trying to find all items within 10km radius of a point. Here is my ...
0
votes
0answers
50 views

Create a route by using points (pgRouting)

I'm currently working on a routing model for 17th and 18th century voyages. These routes are based on data from old shipping logbooks. I made a separate layer in QGIS which contains point. I exported ...
1
vote
1answer
35 views

Create a raster with fixed 10meter pixel scale in PostGIS

I have a series of points that I would like to convert to a raster, and then calculate the area of the raster as a proxy for "amount of area covered". I'm trying to do this using PostGIS rather than ...
0
votes
2answers
25 views

how to configuring geomajas wih oracle spatial db?

I have just done intial setup of the geomajas project and trying to config its data source with oracle database. I am following the given example for sqlserver and POSTGIS. My oracle layerroad xml ...
1
vote
0answers
43 views

Is geotools transformation of EPSG:3785 (Web mercator) to EPSG:4326 wrong?

Using postgres (9.3.6) and postgis: select st_astext(st_transform(ST_GeomFromEWKT('SRID=3785;POINT( 7550310.77 4139679.02 )'), 4326)); This returns POINT(67.8255956454323 34.8217133646348) Using ...
0
votes
1answer
23 views

Problem with ST_Intersection in postgis

I have got a problem with ST_Intersection as bellow query. I do not know why I can not get element z of this intersection? ----query: SELECT ST_AsText(ST_Intersection('LINESTRING Z (0 0 0, 2 2 2)', ...
3
votes
1answer
102 views

How to edit a PostGIS database using ArcGIS for Desktop Add-In/Extension? (no ArcSDE)

I need to improve an existing solution to be able to do multiuser editing within a PostGIS database from ArcMap. Available for the solution is ArcGIS for Desktop 10.3 [Basic]. (No non-free Extensions ...
1
vote
0answers
37 views

Calculate surface map from PostGIS

We need to create surface maps from the website. The data is stored on PostGIS (2.1) as a table of Point geometries with a field indicating a thematic value. The optimal solution would be to produce ...
1
vote
1answer
27 views

Extracting specific geometry point from MultiPoint geometry using PostGIS?

I am working with multipoint geometries in postgis and would like to extract the geometry point associated with the greatest y value of the multipoint geometry. How may I accomplish such a task? For ...
1
vote
0answers
56 views

Is there PostGIS equivalent to arcpy.sa.Slice() function?

I have an existing system built on an 8.3 PostgreSQL database which uses a ArcGIS - Spatial Analyst for a couple of raster operations. The system is moving to PostgreSQL 9.2 and I'm evaluating if the ...
1
vote
0answers
70 views

PostGIS: Ordering by the sum of two distances

I have an SQL statement that selects possible bus routes between two points, ordered by the walking distance required from the start point to the departure bus stop (distance1) and the arrival bus ...
0
votes
0answers
16 views

problem with to addlister event google maps in same html file

I try to make two actionlistener one when the mouse over a marker show a infowindows and the other is for get when click on a market the lat and long and make an AJAX request the two lister code is ...
0
votes
0answers
38 views

Make PostGIS points from Ajax data in a php file

I have an AJAX a string which has lat-long parameters in a request. I try to make point in an SQL query but I get this error 37.15452626 ERROR; parse error- invalid geometry HINT: ...
0
votes
0answers
35 views

Import KML file into GeoDjango

I'm trying to import a KML file into an existing GeoDjango app (using a Postgres 9.3 database). This is my Django model: class PCT(models.Model): code = models.CharField(max_length=3, ...
0
votes
1answer
33 views

Fast way to check if postgis bounding box contains any points/linestrings

I have a bounding box given and want to know if this bounding box contains (or better intersects) any points or linestrings. So the query should return true if the first point/linestring was found and ...
0
votes
0answers
15 views

Load a shape file in postgresql DB with php

I am trying to load a shapefile in a postgis database using the exec() command. I have read the format I have to follow from here and I checked several similar questions from the forum. Based on the ...
0
votes
1answer
32 views

How to use WGS84 in postgis?

I am getting NMEA output (WGS84) from my GPS and would like to put that into Postgis table. Format of the coordinate is 3267.56N 02575.92W. Is there way to insert that coord in db ?
2
votes
1answer
27 views

Postgis 2.1: ERROR: Shell is not a line - SQL state: XX000

My current setup is PostgreSQL 9.3.6 & PostGIS 2.1.5 I have a table with contour lines (multilinestrings) that I wish to group by the attribute 'elevation', and make polygons out of them. The ...
0
votes
0answers
29 views

PostGis without shp2pgsql

I recently reinstalled postgis on my pc, following these instructions link. The installation is successful, and for several days work using PostgreSQL and PostGIS without problems. Now, I need to ...
1
vote
0answers
26 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
19 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 ...
0
votes
0answers
11 views

Changing color of multispectral Raster Image using PostgreSQL/PostGIS query

Would like to change the color of a multispectral Raster Image. looking for changing band rendering values for Red, green and Blue bands using PostgreSQL/PostGIS query. I have loaded the raster ...
1
vote
0answers
22 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.
0
votes
1answer
52 views

Convert string column back to geometry column?

I had a table with a column set to 'point' in doctrine2, but this was changed to 'string' and updated. I can't change it back to 'point' in doctrine2, I get an error: ...
0
votes
0answers
19 views

Update Statement in PostGIS ERROR

I am trying to update a column in PostGIS using information from a column in another table where they spatially intersect. I looked up how to do this on the PostgreSQL tutorial and I think that I ...
0
votes
0answers
28 views

Clipping vector data (Point) with one class in symbolised raster

I have some .asc raster data I symbolised with ranges in two classes. Say 2.145 to 10.000 and 10.001 to 30.1254. Now I want to clip vector data with the area covered by 2.145 to 10.000. How can I ...
0
votes
0answers
28 views

Displaying measurements on a grid of the Earth

I'm developing an application where I need to draw the averaged results of some measurements on a map. Right now, I'm using Leaflet to draw the map with MapQuest/OpenStreetMap tiles, and have the ...
1
vote
2answers
54 views

How to populate a table with geom line? [closed]

I have the coordinates of a lot of points in a table. In pgadmin I want to make a line that passes on these points. I already have my Coordinate point im my table. I want to make line with those ...
1
vote
1answer
41 views

Mixing POINT and MULTIPOINT in PostGIS table

I'm trying to load a bunch of GeoJSON files into one PostGIS table. I get this kind of error: Warning 1: Geometry to be inserted is of type Point, whereas the layer geometry type is Multi Point. ...
0
votes
0answers
52 views

Problem to visualize raster data from PostGIS in QGIS

I have two multiband raster files and i'm trying to load these data into PostGIS using raster2pgsql. Here is the syntax that i used: raster2pgsql -c -s 4326 -I -t 100x100 *.tif ...
1
vote
0answers
31 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 ...
0
votes
0answers
28 views

ClassNotFound Exception: org.postgresql.Driver Using Geotool: gt-imagemosiac-jdbc-x.x.jar

I am a newbie to GIS, coming from a strict MIS background. Anyway, I have been having a little challenge for the past couple of days trying to import tiles and pyramids into my database. Using a ...
2
votes
2answers
48 views

Is a multi-database select possible with DB Manager?

I have data in two locations: geometry data (with attributes) on a PostGIS server (read only) a geometryless table on a local SpatiaLite DB (read+write) I need to select features based on data ...
1
vote
0answers
13 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 ...
0
votes
0answers
16 views

How do I begin creating my open layers Web Map? [duplicate]

I'm completely new in the world of web mapping. I am however determined to learn and create a web map within a month or less. I have some geographical areas that have sites (Solar PV Sites) I want to ...
0
votes
1answer
30 views

Adding M coordinate with different measurings in PostGIS

I have a line table made of several linestring features in succession, so that all linestrings together would form one continuous line, such as: id | geom ----+----------------------- 1 | ...