[postgis-users] What SRID is the USGS 24k Quad Grid?

[Michael Fuhr]

On Mon, Oct 30, 2006 at 03:34:40AM -0500, Paragon Corporation wrote:
> No that didn't work. The actual data is not in degrees.  I think
> its in meters of some sort, but not sure which one.  My fear is
> that its more than one SRID like it's a set of UTM ones and so I
> would have to change my SRID for each slice as the UTM zone changes.

Which data are you downloading?  I looked at "USGS 24K Quad Grid
(2 MB, SHP format)":

ftp://download1.geocomm.com/sd2/usgs_24kgrid.zip

That data is indeed in degrees:

% shp2pgsql -w 24kgrid.shp test
[...]
INSERT INTO "test" ("name","state","lat","long","mrc",the_geom) VALUES
('(ALL WATER)','WA','47.750','-124.625','47124-G6',
GeometryFromText('MULTIPOLYGON(((-124.75 47.75,-124.75 47.875,-124.625 47.875,-124.625 47.75,-124.75 47.75)))',-1) );

-- 
Michael Fuhr