The 2011 data imported correctly and results look pretty good.
On Wed, May 23, 2012 at 3:53 PM, Jeff Rossi [via PostGIS] <
ml-node+s17n4997746...@n6.nabble.com> wrote:
> The geocoder seems to only report one point per city if that helps with
> your diagnosis.
>
> --
>
The geocoder seems to only report one point per city if that helps with your
diagnosis.
--
View this message in context:
http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997746.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
My house
1506 Tuscaloosa Ave, Holly Hill FL 32117
returned
lat: 29.2442380014026
lng: -81.0463110761681
Google Results
Latitude: 29.249946
Longitude: -81.052326
Navteq Results
Latitude: 29.250059000651042
Longitude: -81.0520100911458
--
View this message in context:
http://postgis.17.
:postgis-users-boun...@postgis.refractions.net] On
> Behalf Of Jeff Rossi
> Sent: Wednesday, May 23, 2012 3:26 PM
> To: postgis-users@postgis.refractions.net
> Subject: Re: [postgis-users] tiger_geocoder import error
>
> For some reason the table is called fl_zcta5, and it has
For some reason the table is called fl_zcta5, and it has 983 rows.
I am running the script to import tiger 2011 into a separate database.
--
View this message in context:
http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997738.html
Sent from the PostGIS - User mailing list
Of Jeff Rossi
Sent: Wednesday, May 23, 2012 8:38 AM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] tiger_geocoder import error
psql --version
psql (PostgreSQL) 9.1.3
postgis-1.5 from ubuntu repo
I have the 2010 tiger data, and added the tiger geocoder from the 2.0 download
psql --version
psql (PostgreSQL) 9.1.3
postgis-1.5 from ubuntu repo
I have the 2010 tiger data, and added the tiger geocoder from the 2.0
download.
Perhaps my issue is due to the errors with the import.
Thanks,
Jeff
On Tue, May 22, 2012 at 10:20 PM, Paragon Corporation-2 [via PostGIS] <
ml-no
tions.net] On
> Behalf Of Jeff Rossi
> Sent: Tuesday, May 22, 2012 4:53 PM
> To: postgis-users@postgis.refractions.net
> Subject: Re: [postgis-users] tiger_geocoder import error
>
> I submitted a ticket, thank you
>
> I modified the query and got the data inserted.
>
I submitted a ticket, thank you
I modified the query and got the data inserted.
Is working ok for geocoding, but reverse geocoding does not report street
number, street or type
--
View this message in context:
http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997681.html
Se
27;PostGIS Users Discussion'
Subject: RE: [postgis-users] tiger_geocoder import error
Can you put in a ticket for this. I suspect its a bug. The census blocks
piece was the last piece to go in and when I was testing I was loading
mostly separately.
http://trac.osgeo.org/postgis/
Set to
s.net
Subject: Re: [postgis-users] tiger_geocoder import error
I can make a query to finish the import, but how would I fix the import
script so I don't have issues with the 49 other states.
On Tue, May 22, 2012 at 1:51 PM, Stephen Woodbridge [via PostGIS] <[hidden
email]> wrote:
D
I can make a query to finish the import, but how would I fix the import
script so I don't have issues with the 49 other states.
On Tue, May 22, 2012 at 1:51 PM, Stephen Woodbridge [via PostGIS] <
ml-node+s17n4997671...@n6.nabble.com> wrote:
> Depends on if you just want to rename them or copy the
Depends on if you just want to rename them or copy them!
Rename like:
create schema tiger_data;
begin;
-- first rename the table
alter table tiger_staging.fl_tabblock10 rename fl_tabblock;
-- then move it to the new schema
alter table tiger_staging.fl_tabblock set schema tiger_data;
commit;
If
Any idea how I can get the 480K records from tiger_staging.fl_tabblock10
to tiger_data.fl_tabblock
On Tue, May 22, 2012 at 8:47 AM, Mario Sileone [via PostGIS] <
ml-node+s17n4997640...@n6.nabble.com> wrote:
> Dear Jeff:
> according to the error detailed
> ERROR: INSERT has more expressi
Dear Jeff:
according to the error detailed
ERROR: INSERT has more expressions than target columns
You Have:
the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp
Which count 15 expressions and
the_geom,intptlon10,intptla
15 matches
Mail list logo
