I have shape files for landcover downloaded from here:
http://www.webgis.com/terr_pages/lulcgeo_mo.html
I'd like to put them in the postgis database and run a query on them to add correct mp_types to them, and then export back out as shapefiles (same as the water and road data in the tutorial).
One, how do I find out what types to assign, and two how do I write the query?
Lalita
If you get any metadata with these files, check to see what the source data is. USGS had DLG files for the 250K scale (~1% 100K) LULC paper maps created in the 1970's. The 1992 and 2001 raster data use a different classification scheme than is in the reference gave. When the 2001 data was first released, USGS stated that the classification methods had changed enough that a comparison to the 1992 data would not be valid to determine land cover changes.
It would be great if someone has taken the 2001 raster data and made vector polygons.
I do not remember if you said what you wanted the data for, but you could use the free version of Globalmapper to overlay these vector files on recent photography to determine if they will meet you needs.
If you're not doing custom types I use the cgpsmapper manual to decide what to make the MP_TYPE, I cut out and posted just the types section here: http://www.gpsfiledepot.com/cgpsmapper_types.pdf
Thanks you guys. I'll check it all out and see what I can come up with.
Lalita