[postgis-users] California Shapefile

[Kevin Zhao]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150609/48c8f53f/attachment.html>