[postgis-users] More than 4 dimensions

2007-06-28 Thread Robin Chauhan
I am interested in multidim indexes in higher than 4 dimensions, in postgres, using postgis or otherwise. Can anyone suggest a strategy? Thanks =Robin ___ postgis-users mailing list postgis-users@postgis.refractions.net

[postgis-users] TIGER geocoder question

2007-06-28 Thread Shuo Liu
Hi, All, I'm working on a GIS project and trying to use TIGER Geocoder from the refractions website on TIGER data. The two sql files in the Geocoder generated some errors when being loaded, complaining that some tables (gazetteer_places, tiger_geocode_roads, place_lookup, roads_local, and

Re: [postgis-users] TIGER geocoder question

2007-06-28 Thread Stephen Frost
* Shuo Liu ([EMAIL PROTECTED]) wrote: I'm working on a GIS project and trying to use TIGER Geocoder from the refractions website on TIGER data. The two sql files in the Geocoder generated some errors when being loaded, complaining that some tables (gazetteer_places, tiger_geocode_roads,

Re: [postgis-users] TIGER geocoder question

2007-06-28 Thread Marvin
Thanks, Stephen. Your explanation helps me a lot. So you think that it is possible just to change roads_local in the script to completechain? One more question, there is another table missing (tiger_geocode_join). One message says that tiger_geocode_join links roads_local and tiger_geocode_roads

Re: [postgis-users] TIGER geocoder question

2007-06-28 Thread Stephen Frost
* Marvin ([EMAIL PROTECTED]) wrote: Thanks, Stephen. Your explanation helps me a lot. So you think that it is possible just to change roads_local in the script to completechain? Well, looking back I actually recreate road_local from completechain by doing some simple type conversions and

Re: [postgis-users] TIGER geocoder question

2007-06-28 Thread Marvin
Thank you so much, Stephen.. I'll check it out. On 6/28/07, Stephen Frost [EMAIL PROTECTED] wrote: * Marvin ([EMAIL PROTECTED]) wrote: Thanks, Stephen. Your explanation helps me a lot. So you think that it is possible just to change roads_local in the script to completechain? Well, looking

[postgis-users] Performance Updates

2007-06-28 Thread Paul Ramsey
FYI, this commit: mleslie * r2634 /trunk/lwgeom/ (6 files): Added a 1D rtree for polygon segment indexing, and tied the index into the point in polygon short-circuit of the contains, within, intersects and disjoint methods. Added an index cache to the comparitor methods to save index build

Re: [postgis-users] TIGER geocoder question

2007-06-28 Thread Stephen Frost
* Marvin ([EMAIL PROTECTED]) wrote: Thank you so much, Stephen.. I'll check it out. Sure. I'd really like to see some of this stuff end up back in the tiger geocoder on the website... I don't think anyone is actively maintaining it, which, in my view, is a real shame. :( Does anyone know of

[postgis-users] Newbie question on assigning a SRID

2007-06-28 Thread Will Tuladhar-Douglas
Folks, I am trying to use data from Nepalese government maps. These give good projection information, but there appears to be no SRID that corresponds to their projection. The information given is as follows: Spheroid: Everest 1830. (No reference to corrections or adjustments) Projection:

[postgis-users] Re: TIGER geocoder question

2007-06-28 Thread Marvin
Stephen, I think it would be great if you can post a complete set of scripts/files that you used to create TIGER Geocoder. It is a very handy tool but lacks some maintenance, IMHO. BTW, it seems that there are some inconsistency in your script to create tiger_geocode_roads. Tables state_lookup,

[postgis-users] Re: TIGER geocoder question

2007-06-28 Thread Marvin
Hi, Stephen, I seem to be able to geocode an address after running your script. A new question I have now is the schema of the result returned from geocode. It seems that a geocoded result may come from one of functions in your script ( e.g., geocode_address_state or geocode_address_zip). Do

Re: [postgis-users] Re: TIGER geocoder question

2007-06-28 Thread Stephen Frost
* Marvin ([EMAIL PROTECTED]) wrote: I seem to be able to geocode an address after running your script. A new question I have now is the schema of the result returned from geocode. It seems that a geocoded result may come from one of functions in your script ( e.g., geocode_address_state or