[postgis-users] US counties to Spatial_ref_sys?

[Matthew Perry]

Darryl,

On 2/26/06, Darryl Watson <dwatson at roof-express.com> wrote:
> >>I was afraid that we would have to manually pick SRIDs for each SPCS
> >>zone, but it sounds like that is what we must do.  Doh!
> >
> >Not necessarily; with enough restrictions a query might be able to
> >narrow down a list of possibile SRIDs to the one it needs.  I'm
> >still playing with this, but if you're interested I could send you
> >a few tables that you might be able to use.
> >
> >Have you searched to see if anybody has already done this?  I looked
> >around a little but not much; I was more interested in the doing
> >than in the end result :-)
> >
> Yes, Mr. Google has been a good friend to me, but not in this case.  I
> haven't been able to find a publicly available set of data which helps
> me get where I want, all the way.
>
> Sure, if you want to send me some tables, I would appreciate that.

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.

--
Matt Perry
perrygeo at gmail.com
http://www.perrygeo.net