Thank you Steve. I downloaded AZ files again and loaded fine but others are still the same problem. According to your explanation that should be ok.
I got the postgis database loaded for all states now. I have about 3 mil addresses, may not all be normalized, which I am trying to batch geocode them. I am using the example mentioned in this link. http://www.postgresonline.com/journal/archives/181-pgscript_intro.html I am even using 100 as a batch, my update query is too slow. Its updating at 1500 per hour. That's too slow, I will never be able to finish them. I have 16GB RAM, and 7200 rpm disk partitioned to hold the postgres table spaces. I am not sure what makes it run faster. Anybody has done so many addresses before? What makes the performance go faster? I am attaching the query and query plan here. www.pastie.org/3008194 Any help is appreciated. Thanks Ravi Ada -----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Stephen Woodbridge Sent: Monday, December 12, 2011 8:50 AM To: postgis-users@postgis.refractions.net Subject: Re: [postgis-users] Tigerdata for AZ, AS and VI On 12/12/2011 9:18 AM, Ravi ada wrote: > Hello All, > > Has anyone experienced loading tigerdata into postgis database for > Arizona, American Samoa and Virgin Islands. I getting "*addr.dbf" > cannot find errors. All the other states are loaded fine. I tried to > download the shape files again thinking that they might have been > corrupted during the transmission, but even after that I am getting the same error. > > Any ideas? My download of Tiger has all the *addr* files for Arizona and I believe I have accessed them all without a problem. In general, the *addr* files are optional, and there are none for Guam, American Samoa and Virgin Islands. Typically if the county or county equivalent does not have roads with address ranges in it, then it will not have any *addr* files. So it is possible that a county in Arizona in say the desert might not have any address ranges and therefore not have that file, but looking at the list of counties in Arizona it looks like they all have those files. -Steve W _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
