Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- D:\DemoFolder\G-NAF\gnaf-loader>python load-gnaf.py --gnaf-tables-path="D:\DemoFolder\G-NAF\Downloads\MAY16_GNAF_PipeSeparatedValue_20160523140820\G-NAF\G-NAF MAY 2016" --admin-bdys-path="D:\DemoFolder\G-NAF\Downloads" --states VIC --pgdb="gnaf_May16" --pguser="postgres" --pgpassword="admin"
- Running on Postgres 9.5.3 and PostGIS 2.2.2 (with GEOS 3.5.0-CAPI-1.9.0)
- Part 1 of 4 : Start raw GNAF load : 2016-07-15 15:12:23.959000
- - Step 1 of 6 : tables dropped : 0:00:00.002000
- - Step 2 of 6 : database NOT vacuumed
- - Step 3 of 6 : tables created : 0:00:00.117000
- - Loading state VIC
- - Step 4 of 6 : tables populated : 0:01:59.229000
- - Step 5 of 6 : indexes created: 0:00:46.547000
- - Step 6 of 6 : primary & foreign keys NOT created
- Part 1 of 4 : Raw GNAF loaded! : 0:02:50.651000
- Part 2 of 4 : Start raw admin boundary load : 2016-07-15 15:15:14.610000
- - Step 1 of 3 : raw admin boundaries loaded : 0:00:36.511000
- - Step 2 of 3 : admin boundaries prepped : 0:00:14.593000
- - Step 3 of 3 : admin boundaries for analysis created : 0:00:10.940000
- Part 2 of 4 : Raw admin boundaries loaded! : 0:01:02.061000
- D:\DemoFolder\G-NAF\gnaf-loader>python load-gnaf.py --gnaf-tables-path="D:\DemoFolder\G-NAF\Downloads\MAY16_GNAF_PipeSeparatedValue_20160523140820\G-NAF\G-NAF MAY 2016" --admin-bdys-path="D:\DemoFolder\G-NAF\Downloads" --pgdb="gnaf_May16" --pguser="postgres" --pgpassword="somepassword"
- Running on Postgres 9.5.3 and PostGIS 2.2.2 (with GEOS 3.5.0-CAPI-1.9.0)
- Part 1 of 4 : Start raw GNAF load : 2016-07-15 15:38:56.139000
- - Step 1 of 6 : tables dropped : 0:00:00.002000
- - Step 2 of 6 : database NOT vacuumed
- - Step 3 of 6 : tables created : 0:00:00.131000
- - Loading state ACT
- - Loading state NSW
- - Loading state NT
- - Loading state OT
- - Loading state QLD
- - Loading state SA
- - Loading state TAS
- - Loading state VIC
- - Loading state WA
- - Step 4 of 6 : tables populated : 0:16:13.075000
- - Step 5 of 6 : indexes created: 0:06:03.473000
- - Step 6 of 6 : primary & foreign keys NOT created
- Part 1 of 4 : Raw GNAF loaded! : 0:22:16.699000
- Part 2 of 4 : Start raw admin boundary load : 2016-07-15 16:01:12.840000
- - Step 1 of 3 : raw admin boundaries loaded : 0:05:59.779000
- - Step 2 of 3 : admin boundaries prepped : 0:03:14.909000
- - Step 3 of 3 : admin boundaries for analysis created : 0:01:24.158000
- Part 2 of 4 : Raw admin boundaries loaded! : 0:10:38.852000
- Part 3 of 4 : Start create reference tables : 2016-07-15 16:11:51.693000
- - Step 1 of 14 : create reference tables : 0:00:00.468000
- - Step 2 of 14 : localities populated : 0:00:00.709000
- - Step 3 of 14 : locality aliases populated : 0:00:00.709000
- - Step 4 of 14 : locality neighbours populated : 0:00:00.213000
- - Step 5 of 14 : streets populated : 0:00:21.562000
- - Step 6 of 14 : street aliases populated : 0:00:00.903000
- - Step 7 of 14 : addresses populated : 0:37:11.565000
- - Step 8 of 14 : principal alias lookup populated : 0:03:32.527000
- - Step 9 of 14 : primary secondary lookup populated : 0:03:10.621000
- - Step 10 of 14 : Melbourne split : 0:01:22.884000
- - Step 11 of 14 : localities finalised : 0:07:00.425000
- - Step 12 of 14 : addresses finalised : 0:04:53.826000
- - Step 13 of 14 : postcode boundaries created : 0:02:58.123000
- - Step 14 of 14 : create primary & foreign keys and indexes : 0:16:00.171000
- Part 3 of 4 : Reference tables created! : 1:16:34.736000
- Part 4 of 4 : Start boundary tagging addresses : 2016-07-15 17:28:26.429000
- - Step 1 of 3 : gnaf addresses tagged with admin boundary IDs: 0:05:18.834000
- - Step 2 of 3 : invalid matches deleted & bdy tag indexes created : 0:04:28.107000
- - Step 3 of 3 : gnaf bdy tag table created : 0:34:59.715000
- Part 4 of 4 : Addresses boundary tagged: 0:44:46.675000
- Total time : : 2:34:18.399000
- D:\DemoFolder\G-NAF\gnaf-loader>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement