[postgis-users] TIGER geocoder

2014-04-16 Thread Andre Mano
Hi users, I am a bit lost on the necessary steps in order to use the TIGER geocoding tool. This is what I have done so far: # Enable geocoding capabilities CREATE EXTENSION fuzzystrmatch; CREATE EXTENSION postgis_tiger_geocoder; # Test Geocoding capabilities SELECT na.address, na.streetname,

Re: [postgis-users] TIGER geocoder

2014-04-17 Thread Andre Mano
manual-2.1/postgis_installation.html#tiger_geocoder_loading_data > > > Hope that helps, > Regina > http://www.postgis.us > http://postgis.net > > > > -- > *From:* postgis-users-boun...@lists.osgeo.org [mailto: > postgis-users-boun...@lists.osgeo

Re: [postgis-users] TIGER geocoder

2014-04-17 Thread Andre Mano
ally more efficient to just run from the machine you have > PostgreSQL installed because of network / bandwidth. > > Hope that helps, > Regina > http://www.postgis.us > http://postgis.net > > > -- > *From:* postgis-users-boun...@lists.osgeo.

[postgis-users] Invalid Geometries

2014-07-14 Thread Andre Mano
Hi list, I have a table with all sort of geometry errors - self-intersections, holes outside polygon, etc. I have some recipes to tackle these problems, but I have a doubt - is there an order or precedence by which I should tackle them? I ask these because I have more than one kind of error in a s

Re: [postgis-users] ST_Intersection very slow.

2015-02-19 Thread Andre Mano
*"I will write up a tutorial explaining the benefits of vector tiling in PostGIS, with examples and parallelisation code patterns. If not today, hopefully over the next week. "* Would be nice if you have the time! Best, Andre On Fri, Feb 20, 2015 at 2:52 AM, Mark Wynter wrote: > > So I've w

Re: [postgis-users] QGIS plugin to track in PostGIS database (& triggerusage)

2015-02-27 Thread Andre Mano
Cool! Thanks! On Fri, Feb 27, 2015 at 4:49 PM, Hugues François wrote: > Hi remi, > > Very nice and useful for us ! > > Thanks for the job. > > Regards, > > Hug > > Original Message > From: Rémi Cura > Sent: Friday, February 27, 2015 04:33 PM > To: PostGIS Users Discussion >

Re: [postgis-users] Quadgrid Recursive SQL Function - Now Available on Github

2015-03-10 Thread Andre Mano
Thanks for the sharing Mark - very helpful stuff! On Tue, Mar 10, 2015 at 6:28 AM, Mark Wynter wrote: > Hi everyone > > I’ve been talking about sharing this code for some time - well here it > is. You can find the code on GitHub. > > Here’s the write up > > > http://dimensionaledge.com/quadgr