Click here to get back home

Database Schema Advice
 Home | NewsGroups | Search | About
Login Password
Register Now!
 comp.infosystems.gis    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Database Schema Advice Peter 05-17-2005
Get Chitika Premium
Posted by Peter on May 17, 2005, 11:05 am
Please log in for more thread options
 I'm looking for a reference source to help design a database schema to store
*simple* geospatial data. The dataset basically consists of points, lines
and polygons. Are there established database schemas that are considered
'Best Practice' to use? If so, where can I find them?

Any good books on the subject?

TIA

Peter




Posted by spam on May 17, 2005, 12:52 pm
Please log in for more thread options

On Tue, 17 May 2005, Peter wrote:

> I'm looking for a reference source to help design a database schema to store
> *simple* geospatial data. The dataset basically consists of points, lines
> and polygons. Are there established database schemas that are considered
> 'Best Practice' to use? If so, where can I find them?
>
> Any good books on the subject?
>
> TIA
>
> Peter

Peter,

If I'm not mistaken, you might want to have a look at PostGreSQL. There
is an extension which allows geospatial records to be indexed, and looked
up efficiently as part of that distribution ...

        http://www.postgresql.org
        http://postgis.refractions.net/

Version 8.x now supports Windows (NT/2K) in native fashion ...
I hope this helps ...

Cheers,
Rob.


Posted by Philippe on May 21, 2005, 8:58 am
Please log in for more thread options
Something like :
http://eu.wiley.com/WileyCDA/WileyTitle/productCd-0471204889.html ?
Cheers



d6cj5m$bee$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com...
> I'm looking for a reference source to help design a database schema to
> store
> *simple* geospatial data. The dataset basically consists of points, lines
> and polygons. Are there established database schemas that are considered
> 'Best Practice' to use? If so, where can I find them?
>
> Any good books on the subject?
>
> TIA
>
> Peter
>
>




Posted by Philippe on May 21, 2005, 9:02 am
Please log in for more thread options

or DIGEST :
http://www.uswaternews.com/books/bksbycategory/8aRemoteSens/da1566702410.html

d6cj5m$bee$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com...
> I'm looking for a reference source to help design a database schema to
> store
> *simple* geospatial data. The dataset basically consists of points, lines
> and polygons. Are there established database schemas that are considered
> 'Best Practice' to use? If so, where can I find them?
>
> Any good books on the subject?
>
> TIA
>
> Peter
>
>




Posted by jrbtech on June 3, 2005, 2:42 pm
Please log in for more thread options
Try a geospatial database such as PostGIS. Google search it..

-Jim
http://www.gisforums.com/



Similar ThreadsPosted
Need your advice! March 16, 2005, 6:54 am
Open Source GIS - Need Advice Please November 8, 2007, 3:11 pm
Open Source GIS - Need Advice Please November 8, 2007, 3:11 pm
Seeking advice in comparing GIS software February 16, 2005, 2:07 pm
GIS software advice and importing from FreeHand January 26, 2007, 3:30 pm
advice needed: efficient approach to find streets that are close to a given point July 12, 2007, 7:57 am
advice needed: efficient approach to find streets that are close to a given point July 12, 2007, 7:58 am
Geocoding database May 19, 2004, 4:01 pm
Database merging June 13, 2006, 6:03 am
GIS Work in Montreal/ Canada- Advice Needed- Role Needed April 3, 2007, 2:19 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap