<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
have a try at <a class="moz-txt-link-freetext" href="https://osm.wno-edv-service.de/boundaries">https://osm.wno-edv-service.de/boundaries</a><br>
<br>
select California in the left tree, SHP in the lower left corner and
than EXPORT.<br>
<br>
Have fun<br>
<br>
walter, Germany<br>
<br>
yes, that's my baby :)<br>
<br>
<div class="moz-cite-prefix">On 10.06.2015 08:16, Kevin Zhao wrote:<br>
</div>
<blockquote
cite="mid:CAL8UOgYnTs70qGoM7Ob3FhD5YhiCKfTV+HF4GBGnnchmDHokCg@mail.gmail.com"
type="cite">
<div dir="ltr">Hi everyone,
<div><br>
</div>
<div>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 <a moz-do-not-send="true"
href="http://www.census.gov/geo/maps-data/data/tiger-line.html">http://www.census.gov/geo/maps-data/data/tiger-line.html</a>),
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?</div>
<div><br>
</div>
<div>Thank you so much!</div>
<div><br>
</div>
<div>Kevin<br clear="all">
<div><br>
</div>
-- <br>
<div class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr"><font face="times new roman, serif"
size="1" color="#999999">Kevin Zhao | <a
moz-do-not-send="true"
href="http://www.linkedin.com/in/kevinzhaouva"
target="_blank">LinkedIn</a></font>
<div><font face="times new roman, serif" size="1"
color="#999999">(434) 282-5369</font></div>
<div><font face="times new roman, serif" size="1"
color="#999999">Business Analytics and
Information Technology | </font><span
style="color:rgb(153,153,153);font-family:'times
new roman',serif;font-size:x-small">University
of Virginia</span><span
style="color:rgb(153,153,153);font-family:'times
new roman',serif;font-size:x-small"> </span><span
style="color:rgb(153,153,153);font-family:'times
new roman',serif;font-size:x-small">2016</span><br>
</div>
<div><span
style="color:rgb(153,153,153);font-family:'times
new roman',serif;font-size:x-small">President
| </span><a moz-do-not-send="true"
href="http://www.projectmuva.org/"
style="font-family:'times new
roman',serif;font-size:x-small"
target="_blank">Project M</a><font face="times
new roman, serif" size="1" color="#999999"><br>
</font></div>
<div><font face="times new roman, serif" size="1"
color="#999999"><a moz-do-not-send="true"
href="http://www.akpsiatuva.org/"
target="_blank">Alpha Kappa Psi Professional
Business Fraternity</a></font></div>
<div><font face="times new roman, serif" size="1"
color="#999999">External Vice President |
Mainland Student Network</font></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>