[GENERAL] GIS/GPS Experiences with pgsql?
On Wed, 17 Feb 1999, Peter T Mount wrote:
[snip]
If the TIGER/Line data is raster, and each feature (polygon, line,
circle, etc) doesn't exceed the block size, then postgresql should be able
to handle it.[snip]
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
...the CD-ROM "database" is about 600MB.
It should present no problem to extract the important data w/perl.
In related news, I read on slashdot.org today, in the "Bruce Perens
Resigns From OSI" article:
"...I'm Bruce Perens. You may know me as the primary author of the
Debian Free Software Guidelines and the Open Source Definition. I wrote
the Electric Fence malloc() debugger, and some pieces of Debian. And you
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?
--bryan
-- Failure is not an option. It comes
bundled with your Microsoft product.
---
Bryan R. Mattern
bm@datapace.com http://www.datapace.com
--------
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
In article <36CD2060.452BE176@cc.gatech.edu>,
Bryan Mattern <bm@cc.gatech.edu> wrote:
In related news, I read on slashdot.org today, in the "Bruce Perens
Resigns From OSI" article:"...I'm Bruce Perens. You may know me as the primary author of the
Debian Free Software Guidelines and the Open Source Definition. I wrote
the Electric Fence malloc() debugger, and some pieces of Debian. And you
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?
http://www.slashdot.org/articles/99/01/06/1630245.shtml
It's debatable whether this means anything, since the TIGER data is in
the public domain.
--
Shields.
Import Notes
Reply to msg id not found: BryanMattern'smessageofFri19Feb1999032712-0500