cityofnewyork-us/daily-tasks-park-cleaning-records-kwte-dppd

 
External

Daily Tasks Park Cleaning Records

  • cleaning
  • daily tasks
  • maintenance
  • park

Daily Tasks Park Cleaning Records

This data contains cleaning records for City property under the jurisdiction of or maintained by NYC Parks. It includes records of tasks such as opening parks, cleaning and restocking comfort stations, and removing graffiti, litter and natural debris.

For the User Guide, please follow <a href="https://docs.google.com/document/d/1BfsbNwMa33ff9aIqlVos2MU22Etei3QG55Ob4f9zeYE/edit?usp=sharing">this link</a>

For the Data Dictionary, please follow <a href="https://docs.google.com/spreadsheets/d/1aG8IotfTH1v6XlKUzKBgd2yRX5sgPK4OfWioRfmXEkM/edit?usp=sharing">this link</a>

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
animal_wasteanimal_wasteanimal_wasteTextAn indicator as to whether or not animal waste was cleaned during a visit.
gisobjidobj_gisobjidobj_gisobjidNumberUnique identifier that links the property being serviced to an asset in AMPS.
dumpingdumpingdumpingTextAn indicator as to whether or not dumping was cleaned during a visit.
graffitigraffitigraffitiTextAn indicator as to whether or not graffiti was cleaned during a visit.
broken_glassbroken_glassbroken_glassTextAn indicator as to whether or not broken glass was cleaned during a visit.
napswnapswnapswTextA count of the number of staff in the Associate Park Service Worker title on the cleaning crew during the indicated activity.
fixed_postfixed_postfixed_postTextAn indicator as to whether or not an entry was made using the "Fixed Post" module of the application.
activityactivityactivityTextThe type of activity captured for a record. Cleaning is indicated by the "Work" activity, while other activity codes are used for other actions.
nhoursnhoursnhoursTextA count of the adjusted number of hours a given task was performed.
districtdistrictdistrictTextThe name of the Park Maintenance District in which the property is located.
date_workeddate_workeddate_workedCalendar dateThe date on which the indicated activity was performed.
gispropnumgispropnumgispropnumTextUnique identification number for each park property, identified by borough/county (B = Brooklyn; M = Manhattan; Q = Queens; R = Richmond (Staten Island); X = Bronx) and followed by a number.
descriptionsignnamesignnameTextThe name of the entire site as it appears on the signs located on the exterior of the park.
vehicle_numbervehicle_numbervehicle_numberNumberThe vehicle number used for the given date and route.
daily_task_activity_iddaily_task_activity_iddaily_task_activity_idTextA unique ID assigned to each Daily Task activity entry.
overlap_flagoverlap_flagoverlap_flagTextAn indicator as to whether or not the number of hours (nhours) were adjusted for overlapping times and tasks.
fiscal_qtrfiscal_qtrfiscal_qtrTextThe fiscal year followed by the fiscal quarter for a given record.
ncpwncpwncpwTextA count of the number of staff in the City Park Worker title on the cleaning crew during the indicated activity.
ncsancsancsaTextA count of the number of staff in the City Seasonal Aide title on the cleaning crew during the indicated activity.
off_routeoff_routeoff_routeTextAn indicator as to whether or not a property is included on the selected route.
medical_wastemedical_wastemedical_wasteTextAn indicator as to whether or not medical waste was cleaned during a visit.
end_timeend_timeend_timeCalendar dateThe date and time at indicated which the activity ended.
fiscal_dayfiscal_dayfiscal_dayTextThe relative day of the fiscal year.
row_idrow_idrow_idNumber
npopnjtpnjtpTextA count of the number of staff in the Job Training Participant title on the cleaning crew during the indicated activity.
ncrewncrewncrewTextA count of the total number of workers on the cleaning crew during the indicated activity.
daily_task_iddaily_task_iddaily_task_idTextA unique ID assigned to each Daily Task entry.
fiscal_weekfiscal_weekfiscal_weekTextThe relative week of the fiscal year.
omppropidpropidpropidTextUnique identification number for a property or portion of a property. In some cases – a standalone, smaller park for example – this number will be equivalent to the GIS Property Number. In other cases – a zone, playground or other site within a larger park – an additional designation of letters and/or numbers will be added.
route_idroute_idroute_idNumberUnique identification number for the route as part of which the indicated activity was performed
sectorsectorsectorTextUnique identification string of the Park Maintenance Sector in which the property is located.
sector_namesector_namesector_nameTextThe name of the sector in which the property is located.
sector_descsector_descsector_descTextThe numbers of the Park Maintenance Districts that comprise the associated Sector
start_timestart_timestart_timeCalendar dateThe date and time at which the indicated activity started.
nnpwnnpwnnpwTextA count of the number of non-Parks employees on the cleaning crew during the indicated activity.

Upstream Metadata