[Live-demo] What data should be included on the LiveDVD & Postgres installer

[Hamish]

Alex Mandel wrote:
> Just need someone with the sample data to import it into Postgres and
> then do some SQL dumps. These .sql files can then be run on the command
> line with psql and would build and populate the tables.
> 
> That's the safe way to do it since importing from shp and other formats
> may be more likely to an error that needs human intervention.


for those of us who don't know PostgreSQL very well but are pretty good at
monkey-see monkey-do, a command by command example of how to do this on
the wiki would be incredibly helpful. it doesn't have to be anything fancy.

e.g., starting with shp2pgsql, then export to the .sql, and finally reimporting back into the destination PostGIS db.


thanks,
Hamish