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

learn more… | top users | synonyms

0
votes
0answers
45 views

How to Make WMS (ArcGIS Server) automatic query top raster from PostGIS Database

I've a question about using ArcGIS Server in this scenario: PostGIS table with fields (ID, time, ras:raster, linkpath to file .tif in folder:char) eachday, we put some images in this table ...
0
votes
0answers
42 views

line features show up as polygons in GeoServer

the layers are located in a postgreSQL Enterprise Geodatabase. I created a new line feature class and added it to the database and then added it to geoserver. But in geoserver it comes in as a polygon ...
0
votes
0answers
47 views

Syntax error drivingdistance

I am new in sql and i am trying to get that works a subquery with pgr_drivingdistance and pgr_pointsaspolygon but i get the next error: subqueries in FROM must to have an alias,for example, FROM ...
0
votes
0answers
33 views

How to create unique plane with PostGIS?

How to create a unique plane, with (x , y ,z) as center and a vector as normal, in PostGIS? I already saw "Make3DBox" function, but it does not make a unique one.
0
votes
0answers
52 views

Convert Postgis tables to DWG

Is there a simple way of converting a postgis table to DWG for a given table name? Regards,
0
votes
0answers
152 views

How to choose data type and SRID, for coordinates from different sources, in a medium size zone

I'm developing an application. In the database I need to store coordinates for many places, in the north-east of Italy, but the area could expand in the future. This coordinates will come from some ...
0
votes
0answers
49 views

GIS Data from osm visual in google maps

I have download from openstreetmap data for my project in a workshop i use den coordinates from a roads network ,but i have problem with visualization the cord in google maps same roads is not drawn ...
0
votes
0answers
120 views

All queries on wkb_geometry column return null regardless of input ( ST_Point, ST_Intersects )

I am new to Postgis and I don't know if I am doing something wrong with my query, or if there is a problem with the data. I have been running queries on tiger shape files from the US Census site, I ...
0
votes
0answers
20 views

Updating committee name based on a spatial join within a trigger in postgis

Updating committee name based on a spatial join within a trigger in Postgis. It appears right to me and it runs and executes successfully but still comes up with an error when I try to create a new ...
0
votes
0answers
45 views

Dissolving points based on easting and northing with statistic type first as aggregate function using PostGIS?

I have two points features having point_ID, Easting and Northing fields and want to dissolve based on Easting and Northing with statistic type aggregate as "first" for point_ID, as you do in ArcMap. ...
0
votes
0answers
44 views

QGIS Crash: Enter Credentials

just wondering if anyone has come up against this issue...in the office QGIS will come up with an 'Enter Credentials' box with 'Error: Too many clients already'. When you enter your username and ...
0
votes
0answers
50 views

PostGIS ST_Contains query return empty

Hopefully I explain this properly. I am trying to check if a route falls into another route I have created. The route is saved as a linestring. My search query is: SELECT id FROM routes WHERE ...
0
votes
0answers
55 views

NameError: global name 'QgsDataSourceURI' is not defined

Following on from my previous question I cannot seem to get my function to run using script runner in QGIS. However, if i type then out in the Python Console then they work and load the layer in ...
0
votes
0answers
99 views

ERROR IN sudo PGUSER=postgres make installcheck step

I am trying to setup cartodb on Ubuntu 14.04. I installed all the dependencies & requirements. Postgres 9.3 and postgis 2.0 are also installed. Whenever I try to execute following Steps : ...
0
votes
0answers
57 views

Routes through centroids and array functions

I have a table stopcentroids4 like in figure with the following fields: gid, routes, geom and i want to draw a line for each route that runs through centroids. In my code there is a mistake. ...
0
votes
0answers
99 views

How to select main cities in a country from planet OSM data

I am trying to create a map with my own style with the help of geoserver and planet OSM data,but trying to give style to the polygon at different zoom level ,need to highlight main in cities in ...
0
votes
0answers
98 views

box2d spatial type

I'm storing data that defines a box. I created a column by adding it to my table as follows: SELECT addgeometrycolumn('grid', 'grid_geometry', 32650, 'GEOMETRY', 2); I then insert my data in using ...
0
votes
0answers
39 views

Ways of editing Postgis tables from remote desktops (WFS?)

I've got like 500 postgis tables and i would like to serve then as WMS and especially as WFS to be able to edit that info. To do so i read that the easiest way is Mapserver + TinyOWS. Mapserver works ...
0
votes
0answers
50 views

How can I prevent ogr2ogr from trying to get the SRID from PostGIS?

I'm running ogr2ogr for a PostGIS to GeoJSON export like this: ogr2ogr -s_srs EPSG:4326 -f GeoJSON unique_geoms.json "PG:host=localhost dbname=local_data user=local_user password=local_pass" -sql ...
0
votes
0answers
143 views

PGeo: MDB Tools driver not found

I'm trying to load a Access .gdb(.mdb) database into postgis using ogr2ogr. I'm running Ubuntu 14.04 with gdal 1.10. I've install both unixODBC and mdbtools as per the instructions at ...
0
votes
0answers
194 views

MapServer/WFS with filter doesn't return result

I'm using MapServer version 6.4.1 with PostGIS for my GIS app. When querying a property through 'REQUEST=GetFeature' MapServer returns all the expected data correctly, but if it's set a simple filter, ...
0
votes
0answers
132 views

IntraMaps Roam does not update PostGIS database?

The QGIS project I created for use with IntraMaps Roam has a PostGIS database sync'd to offline mode (i.e. stored in sqlite on my hard drive). I do my edits in Roam and it goes great, the local file ...
0
votes
0answers
73 views

Any way to speed up my postgis topology creation?

I need to do topology aware simplification, and I'm investigating PostGIS's new topology extension. However it's taking a very long time to create the topology, and I'd like to know if there's ...
0
votes
0answers
41 views

Upload SHP to PostgreSQL via QGIS

There was the error when I try to upload the SHP to the PostGRESQL. The feature is the line type. The error was: ERROR: Geometry type (LineString) does not match column type (MultiLineString) Do ...
0
votes
0answers
95 views

Cannot see line made with PostGIS ST_MakeLine() in QGIS

I am probably missing something obvious while trying to do this basic job. thetable contains gps track points. The following aims join the track points by a line: CREATE VIEW line01 AS ( SELECT ...
0
votes
0answers
88 views

Generate random points in geometry near heatspots

I have an algorithm, that generates random points with in a given polygon (Generate random points in polygon. Algorithm question). The Polygons the points are generated in are communities or districts ...
0
votes
0answers
594 views

Intersection postgis TopologyException

I'm trying to make a quite simple analysis in Postgis, but I'm finding some problems. I want to in the first place create buffers for then, intersects themselves but one, this will be differenced. ...
0
votes
0answers
99 views

How to split linestrings where start/end points don't touch nearby lines

I am trying to figure out some basic routing with PostgreSQL/pgRouting and I'm struggling a bit. Our network of linestrings are not topologically correct, tracks that should be connected don't touch, ...
0
votes
0answers
67 views

strange result of spatial functions postgis

I have a problem with different result of spatial functions for same geometry. For some reason result I get when I use geometry from database is different then result when I load same geometry from ...
0
votes
0answers
41 views

Create polygon with predefined size

I need to create a polygon (square) with a predefined size to place it anywhere in a map. The size is given in centimeter (size in cm * scale = size in real). Is that possible with postgis/qgis?
0
votes
0answers
51 views

Overlapping gpx imported to PostGIS with ogr2ogr

I can successfully import track points from gpx file into my PostGIS database the usual way: ogr2ogr -f "PostgreSQL" PG:"dbname=ABC user=usrname password=123" firsttracklog.gpx However, I have a ...
0
votes
0answers
46 views

postgis & mapnik “column ”CLASS“ does not exist”

I've piped an osm map of greece into postgis with osm2pgsql and was playing around with C++ mapnik sample code giving "planet_osm_polygon" as the source table: parameters p0; p0["type"] = ...
0
votes
0answers
53 views

postgis st_makeline, points with rounded time

I have seen a number of example SQL statements that take gps points, order them by time, them use ST_MakeLine to make a Linestring. I think my trouble comes from that fact that my times are rounded to ...
0
votes
0answers
42 views

cartodb/postgis : how to display a polygon with longitude outside the -180;180 range

I am trying to display the following geojson polygon: { "type": "FeatureCollection", "features": [ { "type": "Feature", "properties": {}, "geometry": { "type": ...
0
votes
0answers
142 views

Converting GPS coordinates points to polylines

I happen to have some GPS coordinates points based on timestamp in a table. My table consists of and id , time_stamp and GPS points as the geometrical data. I want to create a line by joining all ...
0
votes
0answers
35 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 ...
0
votes
0answers
227 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 ...
0
votes
0answers
70 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
57 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 ...
0
votes
0answers
74 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 ...
0
votes
0answers
113 views

Insert several gtfs feeds into the same postgis/pgrouting database

I want to import sevaral gtfs feeds into my postgis/pgrouting database so that I can route over all my gtfs feeds. The problem is that the sources / destinations ids of my gtfs are likely to ...
0
votes
0answers
60 views

Apply raster contraints on single table with multiple files

I have a raster table (pre-created using CREATE TABLE) containing multiple individual raster files that I append piece by piece to a final table. The table itself is in its own tablespace 'gisdir' and ...
0
votes
0answers
23 views

pgsql2shp converting nulls to spaces

Why does PGSQL2SHP convert null values to spaces when exporting a table? I would have expected empty strings in the shapefile (dbf).
0
votes
0answers
138 views

How to work with gdb from c#?

I have installed PostgreSql 9.3, PostGIS(last version) and Npgsql. I have geodatabase(tmp.gdb) how to make conection for this DB from c#? And how to connect this DB to PostgreSql? It possible to ...
0
votes
0answers
48 views

OpenLayers gx_geocodercombo returns syntax error

I try to implement a gx_geocoder combobox... { xtype: "gx_geocodercombo", hideTrigger: true, emptyText: 'Enter address (streetname housenumber municipality)', width: 350, layer: ...
0
votes
0answers
243 views

numeric issue while loading floating point-valued GeoTIFF into PostGIS

I am trying to import a floating point GeoTIFF image into PostGIS (2.1), using the following command: raster2pgsql -s 4326 -I -M -F -C tif_dir/*.tif public.map | psql -U postgres -h localhost -d ...
0
votes
0answers
166 views

Importing a Raster into PostGIS 2.1 (Windows 7)

I am trying to learn how to import rasters into PostGIS (2.1). I have read through all the material I can find on doing this and know that the recommended tool for this is the raster2pgsql tool. I ...
0
votes
0answers
130 views

Geoserver ( Java.exe ) cause server to run 100%

Our server runs at 100% CPU when using map services build on geoserver + postgresql I can not find anything in geoserver logs. It is Java.exe takes 100% CPU and because of that server can not do ...
0
votes
0answers
23 views

Get a geometry point along a line from another point with distance using OGC SFSQL

I am wondering is that any quick OGC SFSQL function (or any other spatial query) which return a geometry point that: The point is x distance along a line from its A-End ? ps: I am using postgis 2.x
0
votes
0answers
136 views

Find correct SRID

I'm learning PostGIS raster, and importing GeoTiff with raster2pgsql. This command line tool states: -s <srid> Set the raster's SRID. Defaults to 0. If SRID not provided or is 0, ...