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? http://www2.census.gov/geo/pdfs/maps-dat

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 the

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: http://testmaps.camavisio

Re: [postgis-users] Expand odd shapes

2015-06-10 Thread Andy Colson
Because I actually need to see the shape. One step is to see the shape, the second will be to find the parcels that touch it, which will use ST_DWithin for speed plus ST_Buffer for accuracy. -Andy On 6/10/2015 1:43 AM, RĂ©mi Cura wrote: Why not use ST_DWithin with the original triangle, it i