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

learn more… | top users | synonyms

2
votes
3answers
2k views

Unable to connect PostgreSQL to ArcMap 10.1

I'm trying to connect my local PostgreSQL database to ArcMap 10.1 but for some reason I'm unable to connect to the server. Any ideas of what might be causing the issue. For the instance option in ...
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
23 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 ...
1
vote
1answer
40 views

How to create regular point grid inside a polygon in Postgis without knowing cell size but cell number?

I need to create a grid within a polygon like it is done in How to create regular point grid inside a polygon in Postgis? There a function is created to draw the grid points. But necessary to know ...
0
votes
0answers
24 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 ...
3
votes
2answers
2k views

PostGIS: Convert meters to arbitrary spatial reference units?

I'm writing a query that needs to be able to work with data of any SRID. The basic problem is very simple - I get two pieces of information: A point (SRID = 900913) A distance (unit = meters) I ...
14
votes
3answers
3k views

Identifying road intersections using PostGIS

I'm trying to identify where roads intersect each other, and to make a point at this intersection, with the number of roads that form the intersection listed. I was wondering if there was some way ...
1
vote
1answer
254 views

How can I map data points to OpenStreetMap (OSM) line data?

my goal is to filter measuring points of vehicles by mapping them to streets. So I could filter out all the false data located in fields and rivers and so on. I imported my data into a PostGIS ...
0
votes
2answers
44 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 ...
2
votes
3answers
258 views

postgis linestring segmentation in 4326

How can I divide a single postgis linestring with SRID 4326 into segments (preferably an array of linestrings) with no segment longer than a given distance? I've tried st_segmentize(), but it spits ...
7
votes
1answer
118 views

How fast should I expect PostGIS to geocode well-formatted addresses?

How fast should I expect PostGIS to geocode well-formatted addresses? I've installed PostgreSQL 9.3.7 and PostGIS 2.1.7, loaded the nation data and all states data but have found geocoding to be much ...
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
1answer
32 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 ...
1
vote
1answer
36 views

PostGIS 3D bounding box query that envolves all 3 axes (xyz)

I have some experience with PostgreSQL, but not with PostGIS, and for the life of me I can't make my bounding box take the Z axis into account. I have a points table with XYZ columns. I add another ...
0
votes
1answer
31 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
180 views

Shp2pgsql - exec() not allowed on external server

Me and my collegue are using the shp2pgsql and psql commands in php code (a Drupal module to be precise). We put these commands in a php variable and use the exec() command to execute them. This ...
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 ...
4
votes
1answer
435 views

raster tile - find the correct tile for a given coordinate

I have a large raster map which I loaded into postgis with 1000x1000 meter tiles... the corresponding table has about 200 rows, each row representing a tile. I want to get the raster value for a ...
2
votes
1answer
397 views

How to obtain closest point of point over polylines layer in PostGIS 1.4 (without st_ClosestPoint)?

I´ve got a polylines layer (pipes) and a points layer (valves) and In Postgis 1.4 I would like to obtain the closest points but exactly on the closest polyline. In other words, i need to locate each ...
2
votes
1answer
285 views

Geoserver configuration for large layers

I'm having problem with geoserver configuration. Currently I'm running geoserver 2.4 on CentOS and Tomcat 6 with 24 cores CPU and 48 GB RAM. I have uploaded 4 layers to PostGIS (PostgreSQL 9.3/PostGIS ...
2
votes
2answers
133 views

Map-matching GPS points to the road network!

I am quite a newbie in Postgres and Postgis so please be simple and clear :) I am trying to do a simple map-matching (or path-inference if you wish) of some GPS points. I am using postgres(postgis). ...
3
votes
1answer
71 views

How to create an exact tracking route from GPS data with animated icon?

Probably this is not purely GIS related question, its related to developing issues. I am just asking if there is any kind of suggestions from Gurus. I am building an tracking application where GPS ...
1
vote
0answers
18 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 ...
1
vote
0answers
59 views

Help serializing a postGIS query to geojson

I have a query which I would like to serialize to geoJSON: select article_title, pub_date, city, geom from article, location where article.id = location.id; I can serialize the geom field easily ...
1
vote
2answers
1k views

How to add Geoserver WFS to Leaflet JS Application

I have a PostGIS database and have successfully consumed a table into GeoServer and published a WFS. Are there REST endpoints available for these WFS' akin to ESRI's feature services? How are ...
3
votes
2answers
53 views

Remove specific points from linestring postgis

I am working with a data set that has been using the (0 0) point to pad any points that were missing when the linestring was created. So now the query SELECT id, route as line FROM trips ...
7
votes
1answer
2k views

Generating Interactive Tiles using Nodejs, Mapnik, and PostGIS for Leaflet

I am looking to do something like this but where I have all the data on the same server. I've been following through the set of tutorials @ sparkgeo.com/labs/big/ and I'm having some difficulty. ...
0
votes
1answer
49 views

Check if point is inside unclosed linestring using POSTGIS ST Functions [closed]

I have a table with spatial data. This table contains a single record which is a unclosed linestring. I calculated the Centroid of this geometry using query SELECT ST_AsText(ST_Centroid("geom")) ...
1
vote
1answer
44 views

Creating geodjango model with geometry field that can accept different projections

I am working on web application with GeoDjango and within the model (db table) RoadAxis I have geometry field or more precisely LineStringField where I need to store different polylines (road axis) ...
0
votes
0answers
34 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 ...
0
votes
0answers
22 views

pg_dump Database that was populated with osm2pgsql

Is it possible to dump a postgres database that was created with osm2pgsql and a .osm.pbf file with pg_dump and import this into a remote postgres database? After running osm2pgsql the database is ...
1
vote
1answer
1k views

Having trouble connecting QGIS with postgres database with postgis extension [closed]

I am working on Ubuntu Precise with postgresql version 9.3 and postgis 2.0. After initially starting my postgres database and eventually getting permission errors that would prevent postgres from ...
0
votes
1answer
222 views

ST-Links convert Feature Class to DB Table error

I'm using ArcMap with the ST-Links SpatialKit Conversion tool to convert a Feature Class to a DB Table. But I'm getting an error: ERROR: 42601: type modifier is not allowed for type "geometry". I ...
2
votes
1answer
693 views

Installed PostGIS extension not listed for database

I have a PostgreSQL database with the PostGIS extension enabled. I know that this extension is enabled, since I am using PostGIS functions, and I can actually see the PostGIS functions. However, ...
0
votes
1answer
31 views

Converting spatial data to table of vertices using PostGIS?

I have a spatial data table in PostGIS 2.1 that looks like this: Geom | type | cost POLYGON(0 0,1 1,2 2)| A | 123 POLYGON(3 3,4 4,5 5)| b | 123 I am trying to create a ...
0
votes
1answer
29 views

Utilizing OSM Data in a Postgres/PostGIS database in ArcMap

I've been trying for over a week now, and I'm not sure what i'm doing wrong and I haven't found the answer yet. I am trying to display and symbolize the OSM dataset over Jordan in ArcGIS for Desktop ...
1
vote
1answer
240 views

Convert native box to geometry

I have an old table that contains bounding boxes of lat long coordinates in a "box" type. How do I convert them to PostGIS geometry ? I tried using ...
3
votes
1answer
56 views

How to change the “application_name” of a PostGIS-connection in QGIS?

PostGIS offers a view called pg_stat_activity, where you can see all the active connections to the database. This view includes the interesting column application_name. When a connection comes from a ...
0
votes
1answer
20 views

Parameterizing Postgis function in GeoServer's SQL Views

I have a problem when parameterizing a postgis function in sqlviews If i create this sql, all works like a charm attaching this &viewparams=idvia:6753 to the url SELECT ...
0
votes
1answer
153 views

OpenGeo Explorer for QGIS 2.6.1 - No module named ogr2ogrtopostgis

I'm trying to use the OpenGeo Explorer plugin for QGIS (v2.6.1) to import shapefiles to my PostGIS database. I can connect to the server, but when I try to import, I get the following error: No module ...
2
votes
3answers
2k views

How to insert data into postgis database with phpPgAdmin?

I have 50 line objects in .shp format in folder on my computer. I need to insert it to postgis database on the distant server.. When I log in in phpPgAdmin, it says it runs on localhost:5433. What is ...
0
votes
1answer
88 views

How do I explode a MultiLineString using ST_Dump() in PostGIS?

I want to do what this blog post does: explode a MultiLineString into individual LineStrings. I'm using CartoDB but don't get individual LineStrings as the result of my query. I still get a ...
1
vote
0answers
2k views

How to write a point-in-polygon query for Postgis?

I'm trying to write a query in Postgis which will return all rows where a dynamically changing longitude/latitude point resides within the geometric polygon of that row (in the geom column). This is ...
1
vote
1answer
139 views

Admin Sample GXP Viewer

I have Geospatial application which is using GXP, GeoServer, GeoExt and PostgisSQL. We would like to enhance the application by adding a user friendly Admin system, similar to what GeoNode has. This ...
2
votes
2answers
118 views

How to write a (memory) layer from QGIS to PostGIS?

I am looking for an "elegant" solution to write, from a python script, a layer from qgis and into a new table of a PostGIS database. I thougth that this might be solved by QgsWriteVectorLayer, but I ...
4
votes
2answers
633 views

clustering points in postgresql to create contour map

UPDATE: To try to make this a little more simple, is it possible to create a query which selects a group of points such that each point in the group is at most X units away from at least one other ...
60
votes
8answers
6k views

How do I get started with PostGis

I have been reading a lot about it, but I am struggling to find a good beginner's guide. Which tutorials/books do you recommend? My past experience involves python and arcgis. But I have never worked ...
5
votes
2answers
2k views

Automating batch load of multiple GPX files into PostGIS

I've got 50+ GPX files that I would like to "batch load" into a PostGIS database. All of the track_points data would be loaded into a "track_points" table (with typical GPS fields like lat, long, ...
0
votes
1answer
34 views

QGIS DB Manager - load as new layer not loading

After successfully running an SQL query on two tables and some results in 3 columns, I would really like to be able to display it in the canvas. Apparently, that function is not doing anything, not ...
1
vote
1answer
72 views

Number of Neighbors Around a Point

I need to get a count of neighbors within 100m for each point in a set of 250 million points. The result would have the id of each point accompanied by the number of neighbors around them. Can this be ...