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

learn more… | top users | synonyms

0
votes
1answer
69 views

postgis finding lines that touch and update

I am not much of a postgis guy so please bear with me. I have a subset of lines representing exits and roads around those exists. Main roads and exists can be distinguished by their class attribute ...
1
vote
1answer
32 views

shp2pgsql data appent without gid

I have a shape file, I opened it in QGIS that has columns in attribute table named CITY_NAME, POPULATION and I have a database table in Posqgresql that has columns named gid (primary key), ...
0
votes
2answers
178 views

How to add polygon height in QGIS or PostGIS?

Is there an easy way to set the height of polygons in QGIS or PostGIS? I am trying to visualize polygons by turning them into volumes (same shape at the base and roof, but with walls). I would then ...
1
vote
0answers
14 views

QGIS DBmanager import file append not working [duplicate]

I am using QGIS and connecting to Postgresql database. I want to import shapefile data into database table via DBmanager tool. But Append data to table selection is inactive like following image. I ...
2
votes
2answers
85 views

Able to plot on map but having trouble with st_contains

I am new to working with GIS, and am building a rails app that uses the rgeo gem and PostGIS. I am trying to use geospatial data to determine the school district for a house. The house is represented ...
0
votes
1answer
74 views

Extract address data / Query point in administrative boundary

I try to create a DB in postgreSQL with all the postal adress data for a specific country. Actually I have this table full of data: id integer NOT NULL DEFAULT nextval('plz_id_seq'::regclass), ...
0
votes
1answer
94 views

Mapping application basic for ruby on rails

I am new to build map application using ruby on rails, with rails 4.1.1. I want to create map using map tiles. i have to use PostgreSQL database with postgis. Can you please explain how this flow ...
0
votes
2answers
108 views

Coordinate System Google Maps API

I am making an application in java using GMaps4JSF where the person will enter the address on the map I'll take this coordinate and consult on my postgis base regions in which region this point is ...
2
votes
1answer
202 views

CartoDB “Error loading rows, check your SQL query” & “There is a pb with your connection”

I have been trying to install my own CartoDB server for a few weeks. I succeeded to install each part with no error (after few corrections) with this tutorial. Make check with CartoDB-SQL-API and ...
1
vote
2answers
107 views

Find all points in a linestring that are contained by a polygon

I'm fairly new to PostGIS, so I apologize if this has been answered before. I have a linestring made up of 4D points and I need to determine which points in this linestring fall within a specific ...
0
votes
0answers
59 views

PGSQL2SHP Commnad switch column type

I work with Postgis. I have table CREATE TABLE centerline ( gid serial NOT NULL, l_from integer, l_to integer, r_add_pre character varying(15), r_to integer ... } Export this table with ...
0
votes
2answers
46 views

Which function is most appropriate to select postgis geometries that have any part inside another?

I ST_Dwithin the function returns TRUE if the geometry A is completely inside B. I happen to have many polygons (representing regions) and need to know which streets are within each of these polygons. ...
1
vote
1answer
71 views

PostGIS views vs WFS Filtering operations on PostGIS table

In what use cases should I prefer writing PostGIS views for filtering datasets versus filtering with WFS filter encoding operators and vice versa? In both cases I would be serving the data via ...
1
vote
2answers
73 views

How to style ways with CartoCSS depending on a relation property (OSM)

I'm using CartoCSS together with an OSM Postgres DB (hstore on). I want to set the line color depending on the operator tag of relations (routes). How can I do that? Update Thanks to Paul Norman for ...
2
votes
0answers
124 views

qgis-2.2.0 database tab missing

I have recently installed QGIS-2.2.0 but the Database tab in the top-menu bar is missing. It looks the main reason is missing libgdal1h library. But when I am installing it, it's removing ...
0
votes
1answer
51 views

Missing hstore column in TileMill!

I made a PostgreSQL with PosGIS Extension DB with the pgsnapshot_schema and loaded an .osm.pbf-file with OSMOSIS into it. Now i connected it to TileMill, but if i look up into the table i just see ...
-3
votes
1answer
82 views

Is it possible to access geoserver wfs layer from localhost:8080 in to web application? [closed]

I want to add a WFS layer. I am trying to get WFS layer from localhost:8080 geoserver. but I am getting eoserver DateLineWrap in Openlayers.js file...
0
votes
1answer
34 views

I need to test a condition within the sql in postgis.

I need to test a condition within the sql in postgis. My sql: SELECT (zoneamento3_32722.zt3), logradouros32722."NMIDEABR", logradouros32722."OBJECTID", ...
0
votes
2answers
51 views

PostgreSQL/PostGIS - group by series of values

I need to sum up linear objects' length and to group them by intervals of several years. I have one table storing my objects like this : - gid serial NOT NULL, - year INTEGER, - the_geom ...
2
votes
1answer
91 views

Centroid of Points using postgis

In my postgres database i have a set of points(lat, long) and i created the_geom index for that. Now i have to find the centroid of these points. I Google a lot and i find that for closed ...
0
votes
0answers
24 views

PHP Query Tables of Active Layers

I currently have an "Identify Features" function on my site that works by passing a the Lon and Lat of the click, along with a list of active layers to a PHP script that will then query my PostGIS ...
0
votes
2answers
49 views

How to join data in postgis tables to form layer with subset of attributes

In QGIS I am trying to join data from two postgis tables. I can not figure out how to do this at sql because add layer tools seem to allow one to select just one table to filter on. Instead I ...
1
vote
1answer
120 views

QGIS/PostGIS: Select Counties within Region via Spatial Query

I'm using GQIS 2.2 and PostGIS on Postgresql 9.3. I have 5 regions in the contiguous United States. Each region has states, and each state has counties. I would like to think that the data I'm given ...
0
votes
1answer
74 views

osm2po is missing edges while importing to pgrouting

I am using osm2po for importing pbf file to postgresql but when i find route using built-in algorithms i found that some of the edges are missing so route does not match with road. Did anybody know ...
0
votes
1answer
62 views

Searching closest region from Google Maps coordinates

Here is my problem. I'm mapping a region in google maps after that I'm saving the coordinates in PostGIS databse as geographic Polygon type. ST_GeographyFromText('SRID=4326;POLYGON((..))') The goal ...
0
votes
1answer
99 views

Drawing curved lines in CartoDB?

I am experimenting drawing curved line from Origin to Destination in Cartodb. I was able to do so once, however, failed the second and third time. Could anyone offer me some insights into the ...
0
votes
0answers
38 views

Installing PostGis / GeoServer in Mac OSX

On a Mac Server I am working to setup the ports. My understanding is that there is a system instance of PostgreSQL running and then a geoserver instance. Version is 10.7.5. I need help approaching ...
1
vote
0answers
107 views

Can't see Postgis layers added to QGIS

I'm trying to transition from an old Postgres/Postgis database to a new one. I'm working in a fresh install of Win 7 64 bit. I installed Postgresql 9.3 32 bit, then installed PostGIS 2.1.3. I created ...
0
votes
1answer
57 views

Calculating a vector raster intersection in postgis

I am using CartoDB and trying to calculate the total population (in raster format in popcount) within a specified distance to a line (vector data in mytable). The population data is at about 5km ...
1
vote
0answers
71 views

Collapse dual carriageway lines in PostGIS

I have OpenStreetMap data, which represents larger roads (e.g. dual carriageways, aka divided highways) as parallel lines. The question is answered for ArcGIS or Skeletron here, for example using ...
0
votes
1answer
135 views

How do I avoid this osm2pgsql duplicate key error in Windows?

I am attempting to load an OSM .bz2 file into a PostGIS database using osm2pgsql but am stuck at a duplicate key value in the nodes which violates a unique constraint - any suggestions? output is ...
1
vote
1answer
139 views

Development guide for beginner? [duplicate]

Im new to GIS and mapping, and I need to learn how to create web map application for my project. I'm really confused on what to use. I have read PostGIS, OpenStreetMap, and Openlayer. I'm wondering ...
2
votes
1answer
210 views

POSTGIS - calculating percent area of intersection in where clause

I have a table of polygons (census block groups) in postgres. I want to tag each block group with the town (another polygon table) it mainly resides within. Is this possible? I'm thinking I'd need to ...
0
votes
1answer
143 views

Import DEM into PostGIS for QGIS

I'm a complete GIS newbie so sorry if I'm using the wrong terminology in searching for a solution to this... I'm trying to import a DEM into PostGIS and display it in QGIS. The data is from the EU-DEM ...
0
votes
1answer
393 views

How to use Google Maps projection with GeoDjango/PostGIS

I am building a web service with GeoDjango which involves user submitted events including a location. I created a model field for my location using django.contrib.gis.db: location = ...
2
votes
1answer
56 views

When I publish a layer(shapefile or postgis) with TileMill, 200 meters moves

I hope someone can help me. Not if you know the TileMill application I'm working with her to publish layers look more beautiful. Well, first I have posted directly loading the shp file., But when ...
1
vote
2answers
63 views

how to do simple self join and touches function in postgis?

I am having trouble with this query and neighbor calculation in PostGis. I want to find out which are the neighbors of Sweden in the table COUNTRIES which has column 'the_geom' for geometry and ...
0
votes
0answers
34 views

Serial Int Primary Key not recognized by QGIS 2.2.0

I have a table "lines" stored as MULTILINESTRING features in PostGIS 1.5 ---------- -- Begin Table Definition: CREATE TABLE lines( gid serial NOT NULL, geom geometry, CONSTRAINT roadgeo_can_pk ...
1
vote
1answer
40 views

Break line into 100m segments

I have a line geometry in PostGIS and I am wondering how I would break the line into 100m segments. Is there a function for this?
1
vote
2answers
102 views

invalid KML representation on ST_GeomFromKML

I exported a table with a geography(MultiPolygon,4326) column using ogr2ogr to a KML file. When trying to re-import any of the shapes using the ST_GeomFromKML function I get the following error: ...
2
votes
0answers
139 views

TileMill Exports Failing

I'm having trouble exporting my map in TileMill (v0.10.1). I'm using OSM Bright with a PostGIS database connection to import OpenStreetMap data. When exporting an SVG or PDF through the user interface ...
1
vote
3answers
215 views

geography, geometry, distance, and wkt - PostGIS

I'm trying to understand the data conversions that happen in PostGIS when calculating distances in SRID 4326. Why is it that when I run on my marin_jobs points table: select cast (the_geom as ...
2
votes
0answers
64 views

QGIS is not working with Postgres Plus Advanced Server

We have a problem to integrate GIS software with our GIS database which is populated on Postgres Plus Advanced Server 9.2 from EnterpriseDB. We are using QGIS to maintain and analyze our GIS ...
0
votes
1answer
117 views

pgShapeLoader: how to load a shapefile in a different schema than 'public'

I'm trying to load a shapefile in POSTGIS using pgShapeLoader. It works but I can load table only in the "public" schema and i don't know how to configure, the tool to upload my shapefile in another ...
4
votes
2answers
645 views

Postgis 2.1 error after update

After a usual update progress - "apt-get upgrade" - I can not connect with qGIS to my PostGIS DB anymore. Error in the qGIS logfile: Your database has no working PostGIS support. Erroneous query: ...
1
vote
1answer
135 views

Geoserver OSM data Imported via osm2pgsql - most efficient tables to use to style roads

The Osm2pgsql importer for OSM data to Postgres results in two tables for ways, one called planet_osm_roads and a second one called planet_osm_lines The Osm2pgsql documentation states that the ...
0
votes
0answers
59 views

Displaying 3D city model from PostGIS 3D backend

I know that openlayers doesnt support 3D yet. I heard about Kartograph has 3D features but Does Kartograph support reading data from backend database especially PostGIS? I would like to create a 3D ...
1
vote
1answer
57 views

Possible to store 3D features such as dome into geospatial database?

Is it possible to store 3D features such as dome into geospatial database such as PostGIS? I know that it can store x,y,z data, can such complex features be stored into database?
1
vote
3answers
171 views

Dismiss invalid Polygons in PostGIS

I Have a massive Dataset from OpenStreetMap and imported it into a Postgres-Database using ogr2ogr. I got several warnings during this process because of multipolygons with too little vertices. Now I ...
1
vote
0answers
60 views

Add polygons to PostGres to be queried by Nominatim

I'm trying to build out a geocoder that also returns the correct legislative district information from this data: http://www.census.gov/geo/maps-data/data/tiger.html I've got OSM data imported into a ...