[postgis-users] California Shapefile

[James Keener]

With TIGER there are a few things you need.  The ADDR and EDGES records
can be used find the zipcode for an address, and geocoding. I'm not sure
why you need an altitude, you'll have to use other sources, DEM maybe?,
or if lon and alt will be unique enough?

http://www2.census.gov/geo/pdfs/maps-data/data/tiger/tgrshp2014/TGRSHP2014_TechDoc_Ch3.pdf

PostGIS has a geocoder that can work on the TIGER data:
http://postgis.net/docs/Geocode.html

Jim


On 06/10/2015 02:16 AM, Kevin Zhao wrote:
> Hi everyone,
> 
> I am new to PostGis and just finished the tutorial, loaded nyc data into
> my Postgresql database.  I am trying to build a database where I can
> give it street address or longitude and altitude, then it gives me a zip
> code back.  All for California only.  I know that I need shapefiles, but
> I looked online, found a few sites(including
> http://www.census.gov/geo/maps-data/data/tiger-line.html), and nothing
> really stood out to me as the shapefile that I am looking for.  Could
> someone give an idea on where I can find the shapefile that will fit my
> needs?
> 
> Thank you so much!
> 
> Kevin
> 
> -- 
> Kevin Zhao | LinkedIn <http://www.linkedin.com/in/kevinzhaouva>
> (434) 282-5369
> Business Analytics and Information Technology | University of Virginia 2016
> President | Project M <http://www.projectmuva.org/>
> Alpha Kappa Psi Professional Business Fraternity
> <http://www.akpsiatuva.org/>
> External Vice President | Mainland Student Network
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150610/433094b6/attachment.pgp>