[postgis-users] zcta census data, help with query

[Matt Bartolome]

Hello List,

I have loaded zt06_d00.shp (california zcta) data from
http://www.census.gov/geo/www/cob/z52000.html

Using the shp2pgsql utility:
shp2pgsql -s 2230 -d zt06_d00.shp public.ziptest > zip.sql

I am able to load the data into my postgres database with no problem.
Dumping shapefiles and some other things I've tried work great.

My problem right now is doing the query:
SELECT zcta, WITHIN (Transform(SetSRID(MakePoint(-117.119403,
32.771608),4269),2230), the_geom) as within from ziptest;

This should fall within zipcode 92116 but it is showing false. Can
anybody "point" me in the right direction?

Thanks,
Matt