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

learn more… | top users | synonyms

1
vote
1answer
65 views

st_intersects on postgis

I'm trying to write a command to see whether a given point lies within a multipolygon boundary (in this case, a watershed). I have a table of watershed boundaries and another table with the point I'm ...
2
votes
0answers
55 views

What is the MS SQL Spatial syntax for counting points within polygons? [duplicate]

All, What I'm trying to do is this: Count points within polygons There are thousands of points and maybe 2 dozen polygons Get a list back of the 2 dozen polygons by name and the count of points ...
0
votes
1answer
516 views

OS Vectormap GML files into PostGIS

I am having difficulty in efficiently dealing with OS Vectormap data that comes in GML format. In the past I used the Plugin for QGIS (OS GML Tools) to batch convert folders of compressed GML (.GZ) ...
1
vote
0answers
193 views

MapServer Clustering GetFeatureInfo

I'm having a bit of a problem with clustering in map server the clustering itself works fine and the GetFeatureInfo works fine most of the time. However some times when I click on a cluster point it ...
1
vote
2answers
1k views

How to select all points within a circle in PostGIS?

I have set of points in a PostGIS Table (Type Geometry). Now, I need to filter points that lie in a circle with a center (C) and radius (R)! I expect C to be of type Point or Coordinates.. R to be ...
5
votes
3answers
395 views

Very poor performance of QGIS and PostGIS2. User error or feature?

I have a large table in Postgis2. It has >500 million polygon, line and point features all happily living in there and the table performs brilliantly in other GIS. I am now trying to just add that ...
0
votes
0answers
183 views

How does geoserver determine what SRID to pass to PostGIS [OPERATION ON MIXED SRID GEOMETRIES]

We are using Geoserver to render some data onto maps in a web application. The map shapes are read by Geoserver from a postgis database. The shapes are imported into postgis using the ogr2ogr utility. ...
2
votes
1answer
69 views

Intersecting Layers Returns Empty Collection Despite Visible Intersection

When I perform an intersection of a polygon I draw in OpenLayers and a postgis database layer, it seems that I am getting incorrect results. Intersection works correctly on some layers. For ...
1
vote
1answer
382 views

How to render GPX files in TileMill?

I want to show a number of GPX files in a TileMill map. Here's the process that I thought would work: gpsbabel -i gpx -f "$myfile" -o kml,lines=1 -F "$myfile.kml" Add as layer in Tilemill, style ...
0
votes
3answers
175 views

What is gid in OpenStreetMap data model?

I'm using an old code written by an ex-fellow and I wonder what is GID in OSM? The gid is basically used everywhere. The project uses PostGIS and PgRouting. Any pointers to that? I know this is a ...
2
votes
0answers
96 views

Large buffers in PostGIS (5000 km radius)

I have a number of points stored as geographies in PostGIS (version 2.0.1), and I'd like to create rather large buffers around them (with a radius of 5000+ km). However, ST_Buffer doesn't handle this ...
1
vote
1answer
391 views

PostGIS package problem on Ubuntu 12.04.2 LTS

I've started getting an error on Ubuntu when trying to upgrade packages: "Not all updates can be installed Run a partial upgrade, to install as many upgrades as possible" When I run a partial ...
1
vote
0answers
122 views

can Geocat Bridge enable me to connect to existing PostGIS database and make edits through ArcGIS?

We are planning to set up a Webgis to share our GIS data on the web. Currently, we are on a desktop GIS and using ESRI's File geodatabase format. We are considering ArcGIS Server or using Opengeo ...
2
votes
3answers
417 views

PostGIS: Inserting a null value into a geometry column - feasible?

I'm trying to insert a null value into a geometry column, which I cannot do: "ERROR: parse error - invalid geometry" So what I'm trying to accomplish is to erase a point from a map and save that ...
0
votes
1answer
174 views

Using pgr_drivingDistance with large ids

I have little experience with postgres and none with pgrouting. I'm trying to use the pgr_drivingDistance function with Open Street Map data (generated through osm2po), but whenever I run my query: ...
3
votes
1answer
699 views

Setting coordinate system in PostGIS

The geographical information data that INEGI (part of the Mexico's goverment) provides are in the following coordinate system (or is projection?) Lambert Conformal Conic, double standard parallel ...
1
vote
3answers
588 views

Why can't I open postgis layers in QGIS?

I've set up a table in PostGIS using OSM data (converted using osm2pgsql). I know this database is good, because I'm able to import it and work with it in TileMill, but whenever I try to interact with ...
2
votes
0answers
225 views

3D features (Polyline, Polygon) intersection library

For my research I am looking for a (python) library to get the intersection of some 3D features. The features can be Polygons or Polylines. Mostly I need to intersect a plane with my features and get ...
9
votes
2answers
488 views

Are there Desktop GIS alternatives to ArcGIS 10.X for topology and vector conflation?

Is there any options other than ArcGIS for Desktop for topological rules and automatic topology integrity enforcing in a Desktop GIS? I am looking for something that will automatically snap features ...
2
votes
1answer
56 views

Compare features in PostGIS with updating attributes

I have two polygonal layers: "existing" and "modified". Attribute table of "existing" and "modified" layers have same column "feature_id" - number of feature. Please help me create query which write ...
0
votes
0answers
51 views

QGIS Gazetteer Plugin connection to internal database

A few posts on here mention that the Astun QGIS-Gazetteer-Plugin could be adapted to reference a PostGIS database. Has anyone done this adaptation and could share it? I want to use a gazetteer stored ...
0
votes
1answer
260 views

PostGIS 2.0 ST_Split rounding errors when splitting line with point

My apologies for the bad title; I couldn't think of anything more descriptive. I have been testing ST_Split with a dataset, and found that even with points that are supposed to be exactly on a line ...
1
vote
0answers
79 views

Can I speed up very long connection times to a PostGIS DB caused by complex views?

When connecting to a PostGIS database to add a postgis layer, all table and views are scanned by Qgis in order to define the geometry type (if I understand well the query performed). My problem is ...
0
votes
0answers
19 views

Estimation of Net Primary production (NPP) [duplicate]

I want to study calculate NPP of my city. Can you teach me how to do it? And can you advise me any softwares and models to caluculate NPP? If it possible write full instruction!
3
votes
0answers
226 views

Find points that fall within a radius using Hibernate Spatial

I am using hibernate spatial and postgis and i want to find the points that fall within a certain radius. Using this SQL: SELECT name FROM institution WHERE ...
7
votes
2answers
827 views

Version editing for Postgresql 9.2.4 / postGIS 2

Background: I am "building" a GIS with PostgreSQL 9.2.4 / PostGIS 2 as the database and QGIS 1.8.0 as the geographic application. There will be multiple users accessing, editing and viewing the data ...
1
vote
0answers
57 views

Can't edit osm_roads in udig

There is a PostGIS database that has a road network imported from Open Street Map, stored in osm_roads table. For the testing purposes I need to change some road geometry there. I tried to edit it ...
3
votes
1answer
1k views

PostGIS 2.0 “No function matches the given name and argument types”

After a lot of research, I figured out how to build PostGIS 2.0 from source on a Turnkey Linux LAPP (Postgres 8.4) server. The main draw of PostGIS 2.0 for me is the ST_ConcaveHull function, aka ...
1
vote
1answer
243 views

PostgreSQL/GIS table relations in QGIS 1.8.0

I am building a database in PostgreSQL 9.2 with the PostGIS 2.0 extension. The database consists of a schema called Water which contains water related geographic features (as example, boreholes and ...
1
vote
1answer
474 views

What to do if PostGIS gives error that “geometry requires more points”?

I have a .TAB file. I convert it to ESRI(shp)-->sql and insert it into database. Using PostGIS when I want to convert the data into ESRI file, it shows an error: geometry requires more points ...
3
votes
0answers
110 views

PostGis functions vs. EWKT [duplicate]

While using PostGis, we can query using EWKT format like: SRID=4326;POINT(lon lat) or use the functions defined by PostGis itself. For example: ST_SetSRID( ST_MakePoint( lon , lat ) , 4326 ) I'm ...
1
vote
1answer
227 views

Buffer along a route

I'm using Googlemaps service to plot some marker on the map. All markers are stored in a postgresql table, named "locations" and that has a location column (data type to geometry). When the user ...
0
votes
1answer
125 views

Find closest NON interpolated point on a LINESTRING

I have a linestring and a point, I want to find the closest point on the linestring to that point. Below is a screenshot of a test I created to confirm that the various POSTGIS functions for finding ...
1
vote
1answer
156 views

Looking for all points in a square around a given point in PostGIS

For a given point (x,y), I would like to find all the points in the neighborhood (defined by myRadius, a number, in meters). For now, I'm using a circle around each point, but some reason, I'd like ...
0
votes
2answers
296 views

I have a database in PostGIS, is possible using CartoDB? or I need another map server?

I have a data base in PostgreSQL/PostGIS, and I want to offer to my users a way of visualize it, Is it CartoDB the best option? It is possible? Or which is the best option around? (Please provide ...
3
votes
2answers
1k views

How to make a raster layer transparent via MapServer

I loaded a PostGIS raster Data through OpenLayer and Mapserver. The code inside the OpenLayer is as following : localWMS = new OpenLayers.Layer.WMS( "Local WMS layers", ...
1
vote
1answer
313 views

Generate tiles with EPSG:4326 projection using Mapnik

I'm trying to generate tiles from a postgresql database that contain osm data in EPSG 4326. I used the scripts generate_xml.py and generate_tyles.py provided by mapnik-stylesheets. The final result is ...
1
vote
1answer
70 views

Display problems in some layers of Geoserver 2.3.1

I deleted Geoserver 2.2-SNAPSHOT and deleted tomcat6. Set tomcat7 (from ubuntu repository) and Geoserver 2.3.1. Rewrote his workspce (store, style ..), changing the owner to tomcat7. Some layers are ...
2
votes
2answers
2k views

I just want to make a simple loop in PostgreSQL

In the PostGIS SQL Editor, I just want to make a loop to make this function work This query is to give the UTM Zone number to one column of Global DTM raster table For Loopid = 0 to 1000, then ...
0
votes
1answer
175 views

How can I convert a set of coordinates from a linestring to wkb for storage in postgis?

I have a set of coordinates that come from a kml file and I would like to convert them to wkb for storage in my postgis database. When I use st_geomfromkml, though, I get an error that says I have ...
1
vote
1answer
153 views

Can I append to different tables using ogr2ogr?

I have been through many related questions and links but I am still confused as to how/if this is achievable. So, I have defined tables in my postgis database and I would like my ogr2ogr commnand to ...
1
vote
1answer
205 views

Why does Driving distance of pgRouting return disconnected results?

I am trying the driving distance function of pgRouting 2.0 beta, with an extract of OSM data. The problem i have is illustrated on the following image : On this picture i try to get all the ways ...
4
votes
3answers
550 views

Loading raster data to postgis

I'm a newbie in GIS technology and need some help in loading a rainfall radar raster data into PostGIS. The raster image is shown here: What I need is to store in the database the radar ...
2
votes
0answers
42 views

What resources are there for PostGIS maintenance? [duplicate]

I am recommending the usage of a Postgres+PostGIS database to a client for storage of their Geospatial Data. I need to recommend the processes for maintenance of the database. The Client is an Oracle ...
2
votes
0answers
139 views

get all the possible parameters of sql view

I have a Geoserver layer coming from a postGIS database. Among other attributes, I have one that is related to the date data we've collected, called departuretime. We use this attribute to display a ...
1
vote
3answers
1k views

Select empty Postgis (Postgresql) geometry column

I try to select rows in Postgis that have an empty geometry column. This works but gives me the opposite: SELECT * FROM foo where geom <> ''; And this fails: SELECT * FROM foo where geom = ...
3
votes
1answer
359 views

How do I find the intersection of two polylines in PostGIS?

I have a set of road conditions reported for small segments of road, and I am hoping to determine the specific subset of each segment which intersect with a route along the road so that I can draw the ...
3
votes
1answer
84 views

Can I use predefined list of values from Postgis when I draw lines in QGIS?

Lets say that we have 2 tables in Postgis: Table 1 (PIPE): -ID -pipe_type_id -geometry Table 2 (PIPE_TYPE): -ID -type foreign key PIPE.pipe_type_id - PIPE_TYPE.ID Table PIPE is empty. Table ...
1
vote
1answer
996 views

PostGIS - Geometry or Geography find points within distance in meters

I have a requirement where I need to store lat/long coordinates for locations all around the world. I then need to query for those locations that are within a specified distance (in meters) from ...
2
votes
1answer
92 views

Load PGDB with filename

this is my first question here and I have done extensive searches but still can't find the (full?) answer I'm looking for. Hopefully someone can help! I am loading a number of personal geodatabases ...