Questions tagged [postgis]

PostGIS is a database extension for PostgreSQL providing additional spatial types, indexes, functions, and aggregates.

280 questions
1
vote
1 answer

Howto do a hard upgrade from postgis-1.5 to postgis-2.0

I need to upgrade from postgis 1.5 to postgis 2.0 but i cant backup my data and restore it can someone give me a link where it is clear enough for doing this?
USER123
0
votes
1 answer

Store lat lon in addition to the geography data type?

It's my first time using Postgis, I have been doing some reading on using it. I have added a geography data type to my table, but the values are stored in a binary format. Is it good practice to also store the lat and lon in separate columns as text…
Arya
  • 213
  • 1
  • 4
  • 16
0
votes
1 answer

How to make ST_DWithin to use meters for distance in Postgis?

I have already asked a similar question here: Find the nearest geo points across two tables with Postgis (or without)? but now I am stuck around the correct geo-reference to calculate the distance in ST_DWithin. What I have did with my tables is…
Randomize
  • 1,183
  • 1
  • 20
  • 33
0
votes
1 answer

Postgis building with `make docs`, "cannot parse /html/docbook.xsl"

When I try to build the docs, I'm getting, make -C doc html make[1]: Entering directory '/home/ecarroll/code/postgis/doc' make -C html/image_src images make[2]: Entering directory '/home/ecarroll/code/postgis/doc/html/image_src' make[2]: Nothing to…
Evan Carroll
  • 63,051
  • 46
  • 242
  • 479