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

learn more… | top users | synonyms

0
votes
0answers
27 views

Capturing points slightly out at sea

I have two tables one containing points (points) and the other polygons (polygons). I want to generate a two-columns table identifying for each point of the first table the polygon containing it. So ...
1
vote
1answer
43 views

Conversion of EPSG:3857 coordinate to UTM

I'm trying to convert coordinates from Google Maps using the PostGIS. I'm using this query: SELECT ST_AsText(ST_Transform(ST_GeomFromText('POINT(-29.16297 -51.1795034)', 900913), 29182)); The ...
0
votes
1answer
19 views

Merge Point Data and Raster using ST_SetValues in PostGIS

I'm trying to merge a point dataset with a raster dataset using Column X / Row Y. I have written a tool which generates a raster and, from that raster, I have created grid points with ...
0
votes
0answers
26 views

Geohash36 for PostGIS

i was wondering if anyone created a ST_GeoHash36 function inside postGIS, i know the ST_GeoHash + ST_GeomFromGeoHash functions exists, But i need the geohash36 function inside postGIS, i need a ...
1
vote
1answer
25 views

How to save selected features from a postgis database into a new mini database

I have a postgis(v2.1.3)/postgresql(v9.3) database with geometry (geom1, geom2, etc.) and attribute (attr1, attr2, attr3, etc.) tables. The attribute tables are linked to the geometry tables using ...
2
votes
0answers
51 views

Building a ol3 webapplication with dynamic content and user registration

My setup: currently i'm using a postgis database, get it with a geoserver and display it with openlayers 3. I use the wfs data to display the features in clusters and i'm able to edit them with wfs-t. ...
0
votes
0answers
14 views

Do you have some reference to create WebGIS? [duplicate]

I need to create a webgis for my thesis. My thesis is create webgis with ms4w and mapfish as framework. I have trouble to show my map. I load map from postgis. So, I need some reference to continue my ...
-2
votes
0answers
57 views

How to compute “how many points present in each square mile area”

I am using postgressql. I am searching psql command - to find out number of points that lie in every square mile of an area. the SRID is 2263.and I have some information: Extent West -74.257159 East ...
1
vote
0answers
47 views

QGIS shapefile layers to database geometry type [closed]

I have opened Arcgis shapefile with QGIS. And I used QGIS database manager tool to create table and import data to postgresql database. Database manager is creating and importing success. But there is ...
1
vote
1answer
23 views

Is there a way to configure QGIS to prevent the st_extent call when adding a PostGIS table?

I'm trying to add an extremely large table with a points geometry field to QGIS and QGIS appears to hang. After some investigating in the postgresql database, I tracked it down to a st_extent on ...
0
votes
0answers
37 views

pgRouting with my bus network and select the best of the available routes?

so here's the case: I have been using postgresql/postgis, openlayers and pgrouting to create an online application that selects and visualizes the best of the availabble routes. My problem is though: ...
2
votes
1answer
83 views

How can i use Kriging inside a Postgis database?

i use a postgis database with temperature data. I want to use a spatial interpolation method but not the supported IDW Method. I need to use the kriging Method. Problem is that its no a part of the ...
0
votes
0answers
26 views

pgRouting 2.0 shortest path with pgr_dijkstra returns an empty result

I've been trying to automate shortest path finding for a list of points (on pair at a time) using the OSM road layer for Sri Lanka. I'm using pgrRouting 2.0 and have followed the instructions here. ...
3
votes
1answer
62 views

Postgis is Broken after installing Nominatim

I followed Nominatim Tutorial to install PostGIS and after that I can't access PostGIS at all I already trying reinstalling and installing everything over and over again with no success. Everytime I ...
0
votes
1answer
74 views

How to calculate the optimum bus route using pgrouting?

My setup for my web page is OpenLayers, Postgresql/postgis and pgrouting. What I do not understand is how I am going to do the routing.I have read many tutorials but I don't understand what my next ...
2
votes
0answers
54 views

Inserting coordinates from Google Maps into a Database

My question is pretty basic. I am using Android Google Maps to take the coordinates off a location on the map and I want to insert it into a PostgreSQL database. I know I have to use PostGIS but how ...
1
vote
1answer
27 views

Search Points within Buffered Polygon with PostGIS

I have a table of boundaries as polygons and another table of peaks as points. I want to find the points that are within the polygons and the polygons are extended with a buffer. What would be the ...
0
votes
1answer
33 views

Spatial query to make view

I've got two tables which I want to combine and enrich with each others data. I'm getting stuck on the join part, as this needs to be done via a spatial query. First the table structure: a table with ...
0
votes
1answer
72 views

Google Maps Api , PHP, Javascript and Postgresq-Postgis

I'm trying to make a web application, where I take the start/end city from a text box, geocode the city, use the coordinates to query my database in PHP, and return the features to be drawn in the ...
0
votes
1answer
31 views

Can't add a postgis layer in tilemill (symbol shown grayed)

I want to add a postgis layer to a tilemill project but the symbol is shown grayed and I can't select it (shown on the picture below). I followed this instructions.
0
votes
1answer
47 views

st_startpoint(the_geom) returning empty values

When I upload a shapefile to PostgreSQL using the QGIS tool I can create the routing topology following this tutorial without any problem. But when I use the PostGis Shapefile Import/Export Manager ...
1
vote
0answers
34 views

Postgis geocoder size and performance

I have installed Postgresql 9.3.5 and Postgis 2.1.2 on a 16Gb Ubuntu 14.04 system. (1) If I load all the states TIGER data, using the scripts provided in Postgis, how big will the database be for the ...
2
votes
1answer
29 views

How to transform this PostGIS type of projection to EPSG:900913 in OpenLayers?

I have transferred this kind of projection from this type(which I don't what type it is): 010100000054E077E6F8F33640FD87F4DBD7AD4340 to EPSG:900913. I have the points which are in the above format ...
0
votes
1answer
24 views

Selecting PostGIS objects out of given distance

I need to select by SQL querry objects that are further than 100m from specific type of road. For selecting object that are in given distance there is ST_DWithin but what to do in this case?
0
votes
0answers
55 views

From a point find the closest line [duplicate]

I tried to find a LineString from my table road the nearest line to a point I give, but it is return me all the table SELECT gid, ST_Distance(ST_Transform(ST_GeomFromText('POINT(39.240443 ...
2
votes
0answers
25 views

Diminishing performance of gdal_polygonize in a python subprocess for GRASS to PostgreSQL

I have written a python script to polygonize GRASS rasters into a PostgreSQL database using the gdal utility gdal_polygonize: sub.call('gdal_polygonize.py -8 gdb/quercus/{0}/cellhd/{1} -f ...
0
votes
0answers
36 views

How to import NetCDF to PostGIS (or GeoTIFF)

I was wondering if there are some online examples/instructions for importing NetCDF files into PostGIS raster images? I looked around, and found this related GIS SE question. However, the answer only ...
1
vote
0answers
29 views

Read and Write data with Open Layers3

I'am currently using postGIS/geoDjango/OL3 I need the capability for a user to drop a point on the map, and store that in my database. When any user returns, that point will be shown on the map. ...
1
vote
2answers
44 views

How can I measure(length) line of segment in postgis?

This is my first question. I wonder that, how can I get length of line's segment? Yellow line is my road. blue Points are my start and end points. So I want to measure point1 and point2 between ...
0
votes
0answers
29 views

Replace for Tilecache?

I tried to use Tilecache with my mapserver/openlayers/postgis/cygwin configuration, but no success so far, I just got tired of keeping digging in the whole system to get that thing working. So, could ...
0
votes
0answers
34 views

How to fix scaling mismatch of shape file layer & PostGIS table Lat/Lon data layer for India Map in Geoserver?

I have generated India map in Geoserver using the shape files downloaded from "www.diva-gis.org/gdata" site. Now, when I expose my PostGIS table layer having Lat/Lon data for Indian cities, on top the ...
5
votes
1answer
101 views

What controls the direction of TopoGeometry Linestrings?

In PostGIS, what if anything controls the direction that topogeometry LINESTRINGs will have when converted to geometry? It doesn't appear to be the order in which the edges are listed in the call to ...
1
vote
0answers
43 views

What does it mean when I get rows executed, but with no resulted table?

While applying the following tutorial: http://anitagraser.com/2011/02/09/creating-catchment-areas-with-pgrouting-and-qgis/ utilizing vector network which has been tested (and demonstrated ...
2
votes
0answers
29 views

Why pgRouting GUI panel may not work in QGIS?

What could be the reason behind the mal-functionality of the pgRouting Layer GUI panel? In order to route shortest path via dijkstra function code I'm able to conduct the task using the following ...
0
votes
2answers
92 views

Using AJAX to run PostGIS SQL statements and display results via GeoServer

I am learning Web GIS, and I can't find a good example that gives a big picture of a web interface of running spatial analysis using PostGIS. What I am looking for is a graphical/GIS version of ...
0
votes
1answer
13 views

return state of point from postgis / mapnik pgsql db

I realize that I can confirm whether or not a point lies within a state like this: SELECT ST_Contains(poly,pt) As testr FROM ( SELECT ...
1
vote
1answer
27 views

PostGIS Unknown colormap keyword

I'm working with thematic maps with ST_ColorMap function smoothly until I try to create my own thematic map(colormap). WITH canvas AS ( SELECT ST_Raster( ...
2
votes
1answer
51 views

Export PostGIS line to AutoCAD with graphical direction information

Some time ago I managed to export from PostgreSQL to AutoCAD DXF format a line (LINESTRING) using ogr2ogr program with a PostgreSQL Query, and it works (I can visualise it by the QuantumGIS). Now I ...
1
vote
1answer
40 views

How to export a postgis table to a pbf file?

I need a tool like osm2po or osm2pgsql but that does the opposite thing, convert a postgis table to a pbf file. I think qgis can do this but I can't find that option.
1
vote
1answer
29 views

Adding PostGIS query layer says Query class name is invalid?

I am having issues with adding postgis query layers in ArcMAP 10.2.2.3552, not doing anything special just adding a layer, this works in 10.2.1 so I don't know if its a bug or something Also this ...
5
votes
2answers
74 views

How to draw radius of a circular point buffer using PostGIS

I have generated circular buffers of points in a shapefile. The generated circles and points share a common ID/key, say pt_id. My question is Is it possible to use PostGIS to generate a third layer ...
1
vote
0answers
34 views

Issues with QGIS WFS editing/PostGIS rendering

I want to be able to view and edit spatial data within a postgis database. I have tried using a WFS with Geoserver - but constantly get 'Empty Response' error and the Network log says the request ...
0
votes
2answers
75 views

Converting coordinates to 4326 for Google Maps.

I have a MultiLinestring, example coordinates, (698745.50201423 4210011.04002000) and I would like to convert them to something like (24.362 42.458) to use in Google Maps. When I try to get the SRID ...
0
votes
1answer
24 views

No results for PostGIS TIGER geocoder extension

Similar to this question, my TIGER geocoder extension in PostGIS isn't returning any results. It seemed to all install correctly, so I imported DC, and: psql -d geocoder -c "SELECT g.rating, ...
2
votes
1answer
65 views

QGIS select reversed geometries

I have a road network and a geometry for each road direction. One Geometry from A->B and another Geometry from B->A. This geometries are covering each other. Is there a tool available in QGIS to ...
1
vote
0answers
32 views

Error creating a spatial database. ERROR

I have been trying to get Postgis set up for a while now, I am stuck on one error and have not found a solutions yet. This is on Ubuntu 14.04.1. I am trying to run: CREATE EXTENSION postgis But am ...
1
vote
0answers
29 views

Invalid join selectivity error in postgis 2.1.3

I have 2 tables, one for points and one for polygons. I want to find points falling within theese polygons, so I quered: select p.id, l.id from points p inner join polys l on st_contains(l.geom, ...
1
vote
1answer
34 views

How to modify a PostGIS function?

I wish to modify a PostGIS function ST_PixelAsCentroids. What is the best way to go under-the-hood of PostgreSQL/PostGIS functions and modify and customize them as you wish? I'm not hitting the right ...
-1
votes
1answer
47 views

Geocode as soon as PostGIS table is updated

I am trying to create a map such that as soon as I enter an address into PostGIS table, it'll automatically be geocoded (and published in geoserver). The only way I could think of doing this was using ...
0
votes
1answer
40 views

PostGIS point st_within() polygon = false

so geoserver shows me a red dot within a blue polygon, i thought postgis can tell me that fact by query. i tried the following statements without success, can anyone tell me what i did wrong? select ...