sdot_signs.py

import sys
import requests
import csv

layer = 5
field_names = ('CATEGORY', 'SIGNTYPE', 'STANDARDTEXT')
max_records = 1000
url = 'http://gisrevprxy.seattle.gov/ArcGIS/rest/services/SDOT_EXT/sdot_parking/MapServer/{0}/query'.format(layer)
count_params = {
    'f': 'json',
    'where': '1=1',
    'returnCountOnly': 'true'
}
page_clause = 'OBJECTID > {0}'
params = {
    'f': 'json',
    'outFields': ','.join(field_names),
    'returnGeometry': 'false',
}
response = requests.get(url, count_params)
json = response.json()
record_count = json['count']
writer = csv.DictWriter(sys.stdout, field_names)
writer.writeheader()
for record_index in range(0, record_count, max_records):
    params['where'] = page_clause.format(record_index)
    response = requests.get(url, params)
    json = response.json()
    for feature in json['features']:
        writer.writerow(feature['attributes'])