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

learn more… | top users | synonyms

0
votes
0answers
15 views

PostGIS Best Practices with thousands of entries [on hold]

I'm creating a PostGIS database which will hold thousands of different shapes (imported from Shapefile, GeoJSON, etc), and they'll stay there and be queried over time. How should I organize such a ...
0
votes
0answers
12 views

MultiPatch Shapefile import into PostGIS Database

I have geometry of buildings in Shapefile MultiPatch format. I want to import it into PostGIS database in the same format. Is that even possible? If yes, then how?
0
votes
0answers
24 views

GeoDjango and bug with bounding box query

Just some context first, I have a postgres database with PostGIS extension, running under a GeoDjango wrapper. I have a weird bug that hopefully someone can shed some light on. I'm running a query ...
0
votes
1answer
16 views

How to check if a node is in route computed with pgRouting?

I'm new to the GIS system and I'm following the pgRouting workshop. I've imported the locations of nodes (points, highway=street_lamp) using osm2pgsql. now I'm calculating a few paths between two ...
1
vote
1answer
36 views

Why can't I import my shp file into a postgis database with SRID 102631 using shp2pgsql?

Hi I have been trying to figure out the reason shp2pgsql isn't working when I try to import a shapefile with SRID=102631. I've had no problems with other SRIDs. For all shapefiles in 102631, I get ...
1
vote
1answer
44 views

Where to store lat/lon data with additional informations?

I have huge database of lat/lon GPS coordinate points. For every point, I have several other variables (height, surface type, temperature, pressure...). Also, data will be changed every day and old ...
2
votes
1answer
19 views

PostGIS - interfacing with CADCORP 7.1 and QGIS - user 'postgres' can import, but no other roles can

I'm new to PostGIS (reasonably) - but I'm plagued with one on-going problem: I'm able to access PostGIS from various GIS systems using the main 'postgres' user. Using a newly created user ...
0
votes
1answer
12 views

Importing map information with osm2pgrouting

I'm importing the cartography of Spain with osm2pgrouting. I want to import address information, that is, the tag addr = *. I modified the file mapconfig.xml follows: <type name="junction" ...
0
votes
0answers
7 views

OpenGeo Suite 4.0.1 Activating SSL for remote connection

I have installed OpenGeo Suite 4.0.1 on my Windows 7 OS and created a spatially database. Now i want to connect to my database remotely but then it seems like i have to generate a self-signed key. i ...
0
votes
0answers
6 views

How to specify the new layer type in writeOGR{rgdal}?

There is a task that we copy some polygons into postgis using rgdal package. I noticed postgis is strict with geometry type so that the new multi-feature layer type must be specified. I tested the ...
0
votes
0answers
17 views

Integrate Qgis project to web based google api [on hold]

I was planning to convert the shape file into KML which google map supports. However, my project also includes TimeManager and PostGIS database. How do I handle them?
2
votes
0answers
26 views

Field Collection App for Geoserver or Any OS GIS Server

I am looking for a mobile app/interface for field data collection and mobile editing of GIS data that relies/syncs back to some type of GIS server or database. I am aware of Fulcrum and AmigoCloud, ...
0
votes
1answer
14 views

PostGIS Topology Requires Admin

I am running PostGIS on an Ubuntu server. I am able to add the Topology extension via CREATE EXTENSION, but when I try to use it as anything other than an admin I am denied permission. I ran GRANT ...
2
votes
0answers
32 views

QGIS: Edits in attribute table are not updated in Postgis database. Why?

As the title say. I edit values in the attribute tables of my QGIS project but there is no update to the database. I refreshed in QGIS as well as the database. What else do I need to do?
0
votes
1answer
19 views

Displaying raster tiles from OSM data stored in a postgis server

I have been recently tasked with setting up a raster tile server that serves tiles from data pulled from a postgis store. I have managed to get a vector tile server up and running but I'm stuck on ...
0
votes
0answers
35 views

H2GIS and POSTGIS

i use PostGIS and H2GIS and i have tested ST_Transform function on both systems: SELECT ST_AsText( ST_Transform( ST_GeomFromText('POINT('||to_char(5873455.6,'9999999.99')||' ...
1
vote
1answer
29 views

Rectangle Appears Distorted on Map

When displaying two features, a polygon a (see geoJSON) and its minimum bounding rectangle b (see geoJSON), I get the following result when viewing on geojson.io: The minimum bounding rectangle ...
1
vote
1answer
46 views

Split a table of Multi/Linestrings into Unique Linestrings

Is there an efficient way to split a table of Multi/Linestrings that overlap() and touch() into unique Linestrings (note: creating edges using topology is going very...very...very slow). Here is ...
0
votes
0answers
20 views

Converting NAD 83 to WGS 84 in PostGIS

My question is about the best way to convert from NAD 83 to WGS 84 in PostGIS. I have a PostGIS DB containing National Elevation Data rasters. The rasters are in NAD 83 and I would like to convert ...
0
votes
1answer
27 views

PostGIS: Perform a Spatial Join only joining the intersecting polygon with the maximum value

I'd like to perform a spatial join using PostGIS. I've got table_A containing 80.000 entries and table_B containing roughly 1.500.000 entries. The entries in table_B have a column "number". My goal ...
0
votes
0answers
12 views

How to render visualizations for geospatial objects (the way QGIS does it) on web interface for end users, from PostGIS database? [duplicate]

I have existing geospatial objects in PostGIS. I can visualize it using QGIS. But I want to render these visualization on a web-interface for my users as a result of some queries in the database. I ...
2
votes
1answer
40 views

Draw line with lon, lat, distance and azimuth

I have table in PostGIS with lon, lat, distance and azimuth columns. I want to make Geoserver draw a line through first point with given length and direction. I can turn lon and lat to geometry in ...
2
votes
2answers
43 views

geometry from relations - osm

Can someone show me the relevant documentation for relationships between tables? I'm trying to get the geometry for an entry from the relations table but I'm unable to pick out the right information ...
0
votes
1answer
22 views

Moving file flat-nodes.bin from an osm2pgsql import

I'm running PostgreSQL 9.4 and osm2pgsql 0.82.0 on Ubunt 14.04 (64bit). I'm new-ish to postgres and less new to OSM. My goal was to import the planet file. Unfortunately, when I started the import, ...
0
votes
0answers
44 views

How to relate a Spatial and Non Spatial table in PostGIS to be visualized in QGIS

first of all I'm quiet new in PostGIS. I'm working in pgadminIII with postGIS. I have in one database two tables. See the two tables SQL Pane. CREATE TABLE gw_body_characterisation2 ( ...
0
votes
1answer
31 views

Add columns with information OSM by osm2po?

I imported the europa.osm network within my spatial database thanks to the osm2po tool. I use this with pgrouting. My problem is that I need to know the information provided by the tag address (city, ...
-1
votes
1answer
20 views

Rotate Polygon to be Parallel with the X Axis

By default, PostGIS calculates the Envelope or Extent of a polygon based on the bounding box of the polygon ((MINX, MINY), (MINX, MAXY), (MAXX, MAXY), (MAXX, MINY), (MINX, MINY)). This gives a result ...
3
votes
1answer
37 views

Poor performance with storing large rasters in PostGIS and visualising in QGIS

my question concerns the use and performance of several software tools in conjunction, namely PostgreSQL, PostGIS, QGIS, and GDAL. I'm a long-time ArcGIS, Python, and R user who is interested in ...
0
votes
0answers
16 views

Any experience or tips for using qgis with postgis layers? [duplicate]

we want to replace our shapefiles with postgis layers for editing in QGIS. We plan to edit 1 Layer with 5 people at the same time is this possible? Is this a good idea or is there a better practice ...
2
votes
1answer
24 views

Postgis spatial query st_disjoint

I have 2 layers that I want to compare. I wish to retrieve the features in the layer 1 that have no part in common with the features in the layer 2. I try queries like that but do not returns me the ...
0
votes
0answers
22 views

How to convert a geojson from Postgresql to geojson format readable in rCharts in R?

I am creating a Rshiny interface on that can take in user input and SELECT the respectively map layer from Postgresql database based on the input. The package I am using to plot the map is rCharts. ...
-3
votes
0answers
29 views

How to open a file generated using Postgresql 9.3 and PostGIS 2.1

For more background to this question see Building customized data set from American Community Survey data? I downloaded a file from http://www.justicemap.org/data.php under the section PostgreSQL ...
0
votes
0answers
9 views

Finding Census Tracts Within a Circle in PostGIS [duplicate]

I suspect this is a basic question but, for a newb like me, it's proving to be quite a challenge. I have imported (using ogr2ogr) a collection of census tracts from the U.S. Census-provided .shp files ...
0
votes
0answers
10 views

In PostGIS, is it possible to use `ST_SnapToGrid` align to a coordinate system?

I am wondering if it is possible to align a raster or geometry by specifying the coordinate system using the spatial reference identifier, i.e. 4326 for WGS 84. I did not see anything in the ...
0
votes
1answer
19 views

PGR_Djikstra function error

I'm trying to find a shortest path between 2 nodes using djikstra method but it keeps saying ERROR: Error, query must return columns 'id', 'source', 'target' and 'cost' this is my query: ...
0
votes
1answer
26 views

Align pixels from two rasters with different cell sizes

I have two rasters in a PostGIS database that I want to be able to compare. The first raster is at 5m pixel resolution and the second raster is at 30m pixel resolution and is on a different grid. How ...
0
votes
0answers
18 views

How to remove lines made with a PostGIS query automatically if origin is not in the map window?

I have a PostGIS point layer with labels. I moved these points because they were too close. To connect label and point, I created a line vector layer which was made with a query in the DB-Manager ...
0
votes
0answers
5 views

Install PostGIS without Internet Connection [migrated]

Hi I have binaries but am working on a machine that is on a network not connected to the internet, and I need to install and run PostGIS without Stack Builder or an internet connection. I've tried ...
1
vote
0answers
22 views

Creating quadtree index on latitude, longitude data in PostGIS

I have a table of locations in which one of the columns represents the lat-long for the location. These coordinates have been extracted from the OpenStreetMap file. How can I create a quadtree index ...
0
votes
0answers
24 views

Windshaft + Postgres to read geojson

I have a Postgres database with a field bounds that contains an RGEO Multipolygon datatype and bounds_geojson which is simply the geojson equivalent of the bounds field. I downloaded Windshaft and ...
0
votes
0answers
22 views

Up-dating postgis spatial table from CSV files

I have a PostGIS Table I produced from importing a layer file itself created from a CSV. I am getting updates to the main file through other CSV files and need a method of importing the new CSV's into ...
0
votes
2answers
43 views

Hardware Requirements ? Overpowered?

I'm running a i3 3,1 GHz Machine, 4 GB of RAM with an onboard Graphic Chip. I build a small GIS with Mapbender3, Geoserver based on PostGIS data. It's running pretty fluid from what i can see. Now i ...
0
votes
0answers
23 views

Web Application for display raster data on basis of time slider

It May act as a duplicate question to many, but i have tried refering too all the questions related to my questions, but i am still confiused. Below in attached my code. which i use for Web Mapping ...
1
vote
1answer
30 views

What can I use to generate an interconnected graph from a series of coordinates?

I have a table containing latitude and longitude coordinates, and I'd like to be able to build an interconnected graph from it to use with pgRouting. Is there an existing feature of postGIS or ...
0
votes
1answer
42 views

Import point cloud into PostgreSQL/ pdal pipeline fails

I have a point cloud dataset that I would like to upload to my postgres/postgis database. I followed this tutorial and I could install everything without problems (on ubuntu 14.04. On ubuntu 12.04 ...
0
votes
0answers
10 views

Unable to Display Postgis Database Table Geometry Column Points in Geomoose

I'm a beginner in this field.I want to plot the postgis database table geometry column in geomoose but it is showing a pink tile.Through an android device we are pushing latitude and longitude to ...
0
votes
1answer
30 views

postGIS st_equals function not working as expected

I have a situation where I need to find out if a geometry being imported into a postGIS 2.1 database matches one drawn previously (i.e we want to know if the imported geometry is less up-to-date than ...
0
votes
1answer
21 views

How does ST_SnapToGrid work using nearest neighbor interpolation?

I have rasters in a PostGIS database that are not necessarily aligned (some rasters offset from the grid). I want to use ST_SnapToGrid to align all rasters to the same grid but have some questions ...
1
vote
0answers
17 views

How does `ST_Union` treat NULL values in a raster?

My question is about how ST_Union of rasters containing NULL values are handled. For example suppose I have two rasters that intersect but the values of the intersection are NULL in one of the ...
0
votes
0answers
33 views

Densifying OpenStreetMap (OSM) network nodes?

I am working with osmconverter to convert osm files(*.osm) to *.pbf, then i use osm2po to get sql file that run into PostGis to get a network table. The last step is to run a createTopology ...