2018-04-07 02:57:28,796    DEBUG: Downloading http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0 to ca--nb--city_of_st_john-aa9a5817.csv
2018-04-07 02:57:28,797    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0 with args {'f': 'json'}
2018-04-07 02:57:28,911    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': '1=1', 'f': 'json', 'returnCountOnly': 'true'}
2018-04-07 02:57:29,398     INFO: Source has 24722 rows
2018-04-07 02:57:29,398    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0 with args {'f': 'json'}
2018-04-07 02:57:29,470    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': '1=1', 'f': 'json', 'returnCountOnly': 'true'}
2018-04-07 02:57:29,869    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'f': 'json', 'outStatistics': '[{"outStatisticFieldName":"THE_MIN","statisticType":"min","onStatisticField":"OBJECTID"},{"outStatisticFieldName":"THE_MAX","statisticType":"max","onStatisticField":"OBJECTID"}]', 'outFields': ''}
2018-04-07 02:57:32,080     INFO: Built 36 requests using OID where clause method
2018-04-07 02:57:32,080    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 1 AND OBJECTID <= 1001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:34,286    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 1001 AND OBJECTID <= 2001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:35,831    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 2001 AND OBJECTID <= 3001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:36,808    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 3001 AND OBJECTID <= 4001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:37,556    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 4001 AND OBJECTID <= 5001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:38,193    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 5001 AND OBJECTID <= 6001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:38,906    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 6001 AND OBJECTID <= 7001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:39,730    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 7001 AND OBJECTID <= 8001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:40,336    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 8001 AND OBJECTID <= 9001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:40,918    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 9001 AND OBJECTID <= 10001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:42,010    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 10001 AND OBJECTID <= 11001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:43,537    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 11001 AND OBJECTID <= 12001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:44,824    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 12001 AND OBJECTID <= 13001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:45,618    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 13001 AND OBJECTID <= 14001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:46,528    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 14001 AND OBJECTID <= 15001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:47,391    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 15001 AND OBJECTID <= 16001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:47,879    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 16001 AND OBJECTID <= 17001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:48,488    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 17001 AND OBJECTID <= 18001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:49,310    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 18001 AND OBJECTID <= 19001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:50,096    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 19001 AND OBJECTID <= 20001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:51,376    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 20001 AND OBJECTID <= 21001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:52,426    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 21001 AND OBJECTID <= 22001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:53,251    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 22001 AND OBJECTID <= 23001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:54,596    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 23001 AND OBJECTID <= 24001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:55,651    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 24001 AND OBJECTID <= 25001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:57,690    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 25001 AND OBJECTID <= 26001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:58,485    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 26001 AND OBJECTID <= 27001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:57:58,801     INFO: Resource usage: { user: 21%, system: 0%, memory: 462MB, read: 0KB, written: 1300KB, sent: 150KB, received: 4194KB, period: 30sec, procs: 1 }
2018-04-07 02:57:59,920    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 27001 AND OBJECTID <= 28001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:58:01,203    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 28001 AND OBJECTID <= 29001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:58:02,354    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 29001 AND OBJECTID <= 30001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:58:03,362    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 30001 AND OBJECTID <= 31001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:58:04,365    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 31001 AND OBJECTID <= 32001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:58:05,638    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 32001 AND OBJECTID <= 33001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:58:06,960    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 33001 AND OBJECTID <= 34001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:58:08,247    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 34001 AND OBJECTID <= 35001', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:58:08,952    DEBUG: Requesting http://maps.saintjohn.ca/arcgis/rest/services/Operational_Layers/Civic_Addressing_Public/MapServer/0/query with args {'where': 'OBJECTID > 35001 AND OBJECTID <= 35511', 'returnGeometry': True, 'outFields': '*', 'geometryPrecision': 7, 'f': 'json', 'outSR': '4326'}
2018-04-07 02:58:09,675     INFO: Downloaded 24722 ESRI features for file /tmp/worker-enegrheg/work-9axwxbqx/out/process_one-v8t91vtc/cache-wf3dmgq3/esri/ca--nb--city_of_st_john-aa9a5817.csv
2018-04-07 02:58:09,700     INFO: Cached data in file:///tmp/worker-enegrheg/work-9axwxbqx/out/process_one-v8t91vtc/cached/ca--nb--city_of_st_john-aa9a5817.csv
2018-04-07 02:58:09,737    DEBUG: URL says ".csv" for file:///tmp/worker-enegrheg/work-9axwxbqx/out/process_one-v8t91vtc/cached/ca--nb--city_of_st_john-aa9a5817.csv
2018-04-07 02:58:09,737    DEBUG: Guessed ca--nb--city_of_st_john-803cc8b1.csv for file:///tmp/worker-enegrheg/work-9axwxbqx/out/process_one-v8t91vtc/cached/ca--nb--city_of_st_john-aa9a5817.csv
2018-04-07 02:58:09,753    DEBUG: File exists /tmp/worker-enegrheg/work-9axwxbqx/out/process_one-v8t91vtc/conform-wcck59d2/http/ca--nb--city_of_st_john-803cc8b1.csv
2018-04-07 02:58:09,753     INFO: Downloaded to ['/tmp/worker-enegrheg/work-9axwxbqx/out/process_one-v8t91vtc/conform-wcck59d2/http/ca--nb--city_of_st_john-803cc8b1.csv']
2018-04-07 02:58:09,753  WARNING: Could not guess a single compression from file names
2018-04-07 02:58:09,754     INFO: Decompressed to 1 files
2018-04-07 02:58:09,755     INFO: Sampled 6 records
2018-04-07 02:58:09,755    DEBUG: Converting to /tmp/worker-enegrheg/work-9axwxbqx/out/process_one-v8t91vtc/conform-wcck59d2
2018-04-07 02:58:09,755    DEBUG: extract temp file /tmp/openaddr-extracted-n7c63njr.csv
2018-04-07 02:58:09,756     INFO: ESRI GeoJSON source found; treating it as CSV
2018-04-07 02:58:09,756     INFO: Converting source CSV /tmp/worker-enegrheg/work-9axwxbqx/out/process_one-v8t91vtc/conform-wcck59d2/http/ca--nb--city_of_st_john-803cc8b1.csv
2018-04-07 02:58:23,087     INFO: Converted to /tmp/worker-enegrheg/work-9axwxbqx/out/process_one-v8t91vtc/conform-wcck59d2/converted/ca--nb--city_of_st_john-803cc8b1.csv with 24722 addresses
2018-04-07 02:58:23,088     INFO: Processed data in /tmp/worker-enegrheg/work-9axwxbqx/out/process_one-v8t91vtc/out.csv
2018-04-07 02:58:23,089  WARNING: Nothing previewed