Closed baolingz closed 4 years ago
@baolingz the changes outlined above are right this issue relates to the notes in other issue (i.e. removing the geosupport return code field) Yes, for 'nysdot_traffic_counts' I'd remove records outside NYC, rename county_code to borocode, and map county_code values to borocode values
Standard data schema: https://docs.google.com/spreadsheets/d/1Z41fgiU_mi1KltlS783kUZpPcC8Sn7hUxTqhaNxQFg8/edit?pli=1#gid=0
dep_cats_permits
: updateborough
values to proper case, addgeo_
to all fields return by geosupport, geometry-->geom, expirationdate::date, issuedate::date, addgeo_address
, (geo_latitude,geo_longitude)::double precisionnysdec_facility_permits
: addgeo_
to all fields return by geosupport, geometry-->geom, , issue_date::date, expire_date::datedot_traffic_cameras
: geometry-->geomatypical_roadways
: l_zip-->left_zipcode, r_zip-->right_zipcodefacilities_garages
: addgeo_
to all fields return by geosupport, geometry-->geomnysdec_air_monitoring_stations
: geometry-->geom, (Addgeo_
in front of longitude, latitude if they are from geosupport), map county-->borough (remove outsiteNYC by setting region='2'), borocode::integer, (geo_latitude,geo_longitude, geo_x_coord, geo_y_coord)::double precisionnysdot_functional_class
: geometry-->geomnysdot_aadt
: geometry-->geomnysdot_traffic_counts
: should we rename county_code to borocode and remove records outside NYC?