Re: [GENERAL] GIS/GPS Experiences with pgsql? - Mailing list pgsql-general

From Maarten Boekhold
Subject Re: [GENERAL] GIS/GPS Experiences with pgsql?
Date
Msg-id 36CD2633.7E37E11D@tibco.com
Whole thread Raw
In response to [GENERAL] GIS/GPS Experiences with pgsql?  (Bryan Mattern <bm@cc.gatech.edu>)
List pgsql-general
> > Vector not raster. Right?
>
> Actually, it's just text.  Here's a sample record:
>
> 10003 43140280 B Smallwood Road A31 13131891899301893018 9501 9501 227
> 222  -82521645+33638976 -82528956+33639940

I assume this describes a vector....

> may remember me for having brought the TIGER map database to free
> software. If you want copies of that, you can get them through Dale
> Scheetz..."
>
> Anybody know WTF he is talking about?

IIRC he bought the copyrights to the TIGER map and released it under GPL
or something like that.

Maarten

ps. How much 'pgsql-space (ie. megabytes)' would 600M of a textual
description like the above take? I assume pgsql can store this more
efficiently in its tables using these geometric types.

--

Maarten Boekhold, boekhold@tibco.com
TIBCO Finance Technology Inc.
The Atrium
Strawinskylaan 3051
1077 ZX Amsterdam, The Netherlands
tel: +31 20 3012158, fax: +31 20 3012358
http://www.tibco.com

pgsql-general by date:

Previous
From: Bryan Mattern
Date:
Subject: [GENERAL] GIS/GPS Experiences with pgsql?
Next
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] slow inserts and updates on large tables