Re: [postgis-users] California Shapefile

2015-06-10 Thread 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?

Re: [postgis-users] Expand odd shapes

2015-06-10 Thread Andy Colson
Like this: http://testmaps.camavision.com/map/cassmo?pin=08083430332000 The blue part is the selected parcel. The gray is the ST_Buffer. -Andy On 6/10/2015 8:27 AM, Andy Colson wrote: Because I actually need to see the shape. One step is to see the shape, the second will be to find

Re: [postgis-users] Expand odd shapes

2015-06-10 Thread Andy Colson
Huh. My email from last night didnt make it though. Sorry to spam the list. This is my last one, I swear. ST_Buffer was exactly what I was looking for. Thanks Bob for pointing me back the right direction. -Andy On 6/10/2015 8:31 AM, Andy Colson wrote: Like this:

Re: [postgis-users] Expand odd shapes

2015-06-10 Thread Rémi Cura
Why not use ST_DWithin with the original triangle, it is the best option regarding speed and precision. Cheers Remi-C Le 10 juin 2015 01:30, Andy Colson a...@squeakycode.net a écrit : At first I thought no, because it creates a circle around a point: Returns a geometry that represents all

Re: [postgis-users] California Shapefile

2015-06-10 Thread Walter Nordmann
have a try at https://osm.wno-edv-service.de/boundaries select California in the left tree, SHP in the lower left corner and than EXPORT. Have fun walter, Germany yes, that's my baby :) On 10.06.2015 08:16, Kevin Zhao wrote: Hi everyone, I am new to PostGis and just finished the