Questions tagged [postgis]

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

Filter by
Sorted by
Tagged with
4 votes
2 answers
881 views

ArcSDE 10 and PostgreSQL 8.3 vs 8.4

We have recently upgraded our ArcSDE 9.3 instance to ArcSDE 10. I was hoping to upgrade postgresql 8.3 to 8.4 at the same time. Although ArcSDE 10 supports 8.4, it turns out that the ArcSDE wizards ...
user avatar
  • 661
19 votes
4 answers
7k views

Creating one-sided buffers or parallel lines in PostGIS?

I'm looking for a way to create so-called one-sided buffers or parallel lines in PostGIS. Example: 1. buffer, 2. one-side, 3. both-sides I've found some discussion on the mailing list from 2009 and ...
user avatar
  • 82.4k
22 votes
7 answers
10k views

Options for displaying PostGIS vectors in OpenLayers

I am very new to web-mapping, so this question may be a little misguided. I want to have a very simple web interface using OpenLayers (or even Google Maps if that will be easier) which can display a ...
user avatar
  • 9,351
2 votes
6 answers
2k views

How can I connect to a PostGIS database from ArcCatalog 9.3 via ArcSDE?

I have a problem connecting to my postgis database via ArcSDE in Arc Catalog. When i want to establish connection to my database i get an error:
user avatar
  • 3,606
9 votes
5 answers
3k views

Queries returning very big datasets in PostGIS

I have a PostGIS query that will return several million rows: SELECT t1.id AS id1, t2.id AS id2, ABS(t1.mean_h - t2.mean_h) AS h_diff, ST_Distance(t1.the_geom, t2.the_geom) AS dist FROM ...
user avatar
  • 9,351
7 votes
3 answers
1k views

How to get a list of adjacent lots to a road in ArcMAP and PostGIS/QGIS?

In the following map, I have: A line / road layer A parcel / lot layer The Task: Find and count the list of lots adjacent to the road with their types (parcel_type is a field in the parcel layer) ...
user avatar
  • 8,442
16 votes
2 answers
4k views

What are the implications of invalid geometries

I've imported some data in a Postgis database and some of the geometries are reported invalid (ST_IsValidReason reports self-intersection or ring self-intersection). The queries I am performing don't ...
user avatar
  • 2,308
9 votes
3 answers
4k views

How to emulate Google Maps driving directions using pgRouting?

Would like to emulate google maps' driving directions functionality but use pgRouting instead. google's data over the project area & scale is quite a bit off so we want to use our own transport ...
user avatar
6 votes
4 answers
5k views

Live KML from PostGIS to Google Earth

Is there a way to bring data from a PostGIS database into Google Earth to view live? I know of the asKml function in PostGIS, but I'm interested to know if it's possible to dynamically load KML-...
user avatar
  • 34k
24 votes
2 answers
11k views

How can I find a point inside a polygon in PostGIS?

How can I find a point that is guaranteed to be within a given polygon in PostGIS? I am aware of the ST_Centroid function. However, the centroid is not always within a polygon, see below: ...
user avatar
  • 9,351
19 votes
2 answers
8k views

How can I calculate the bearing between two points in PostGIS?

How can I find the bearing between two points in PostGIS? Please specify in your answer whether or not the method producing a bearing on the spheroid, or a planar bearing.
user avatar
  • 9,351
2 votes
4 answers
6k views

struggling with GeoDjango install: ERROR: could not access file "$libdir/postgis-1.5": No such file

I'm installing GeoDjango on Mac OSX. I've followed the official Mac install instructions, which all went smoothly, and am now creating a spatial database template for PostGIS. However, when I try to ...
user avatar
8 votes
2 answers
3k views

Unions of polygons (Postgis ST_UNION for Geography type)

I am looking for a function that will return the intersection of 2 or more polygons (geography type). I am aware of ST_UNION, ST_COLLECT but it works only for geometry type.
user avatar
  • 181
2 votes
1 answer
1k views

psycopg2 error with QGIS 1.5

So I just installed QGIS 1.5 using the windows installer not the osgeo4w one and now any plugins that need access to PostgreSQL databases don't seem to work, they all throw a: "Couldn't import Python ...
user avatar
  • 34k
3 votes
1 answer
458 views

How to convert SHP/POSTGIS data into x, y, z, "cost" data?

Is there a way to convert a line layer (shp or PostGIS) data into (x, y , z, cost) i.e. (From_node, To_node, optional_Elevation, Cost/Weight) ?
user avatar
  • 8,442
4 votes
3 answers
3k views

Writing a plugin for QGIS using Python to access PostGIS and write geometries

Sorry about the strange title, I didn't really know how to word it. I currently use MapInfo to do most of my GIS work however I have recently installed PostGIS 1.5 and I really like it so far. A ...
user avatar
  • 34k
37 votes
7 answers
24k views

Nearest neighbor between point layer and line layer? [closed]

I've asked this question several times on stackoverflow and irc between #qgis and #postgis and I also tried to code it or implement it my self in postgis with no real answer. Using programming (most ...
user avatar
  • 8,442
3 votes
1 answer
686 views

Find polygon that contains all linestring records in PostGIS table

I'm still pretty new to this stuff, so bear with me. In PostGIS how could I find a polygon that would contain all the linestring records in a given table?
user avatar
26 votes
4 answers
7k views

Simplifying adjacent polygons using PostGIS?

I encountered a problem simplifying set of polygons that are adjacent. If I simplify each polygon separately with the Douglas–Peucker algorithm (which is used by many open source tools), the resulting ...
user avatar
  • 853
17 votes
5 answers
5k views

Simplifying polygons to linestring?

I would like to simplify some polygons that represent rivers into linestrings. I assume that holes in polygons can be omitted. Anybody has some good idea how to simply do it? It would be nice, if it ...
user avatar
  • 853
38 votes
21 answers
34k views

Connecting to PostGIS database from ArcMap for display and query without ArcSDE?

How can I connect to a PostGIS database from ArcMap using ArcGIS Desktop 9.3 and later? I would like to be able to perform spatially enabled queries and receive the results back (e.g. spatial and non-...
user avatar
  • 9,351
37 votes
4 answers
12k views

Separate polygons based on intersection using PostGIS

I have a PostGIS table of polygons where some intersect with one another. This is what I'm trying to do: For a given polygon selected by id, give me all of the polygons that intersect. Basically, ...
user avatar
  • 1,684

1
171 172 173 174
175