[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] zcta census data, help with query
From:       "Matt Bartolome" <mattxbart () gmail ! com>
Date:       2007-02-28 19:49:24
Message-ID: 633d34560702281149h7e49b901vc7cc75397a07f5f4 () mail ! gmail ! com
[Download RAW message or body]

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
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]