[postgis-users] US counties to Spatial_ref_sys?

[Michael Fuhr]

On Sun, Feb 26, 2006 at 12:24:31PM -0800, Matthew Perry wrote:
> There's an online EPSG database at http://ocean.csl.co.uk/ that might
> help. You can browse the database by state name to narrow down the
> SRIDs to state plane coordinate systems/datums in that state.

Unless I'm missing something, a PostGIS query like the following
does much the same thing:

SELECT * FROM spatial_ref_sys WHERE srtext ~* 'california';

-- 
Michael Fuhr