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