edmonton-ca/311-requests-2015-3tzn-47wh

 
External

311 Requests (2015)

  • 311
  • 311 edmonton
  • calls
  • dead animal removal
  • drainage maintenance
  • And 12 more...

311 Requests (2015)

Listing of all requests raised to 311 in 2015, details of each call/transaction and update on the status.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Month Numbermonth_numbermonth_numberNumberThe numeric Month in which the 311 ticket was created.
Date Createddate_createddate_createdCalendar dateThe date the service request ticket was created
Service Categoryservice_categoryservice_categoryTextThe type of action or service request.
Request Statusrequest_statusrequest_statusTextThe stage at which your request is at, Open or Closed.
CountcountcountNumberA field created to do a sum function for charting purposes (Note: having this would be equivalent to doing a row count).
MonthmonthmonthTextThe Month in which the 311 ticket was created.
NeighbourhoodneighbourhoodneighbourhoodTextThe name given to a Neighbourhood
Nbhd Latitudenbhd_latitudenbhd_latitudeNumberThe latitude value for the centroid of the Neighbourbhood
Neighbourhood IDneighbourhood_idneighbourhood_idNumberUnique number identifier given to Neighourhoods throughout Edmonton
Nbhd Locationnbhd_locationnbhd_locationPointThe combination of latitude/longitude for the centroid of the Neighbourhood used for mapping purposes.
Referral Typereferral_typereferral_typeTextThe action associated with how the request was handled either information provided or transferred to a business area.
Nbhd Longitudenbhd_longitudenbhd_longitudeNumberThe longitude value for the centroid of the Neighbourhood
Interaction Channelinteraction_channelinteraction_channelTextThe channel or method in which the request was initiated
WardwardwardTextA unique number give to a geographical area representing a electoral area
Service Areaservice_areaservice_areaTextThe business area that is responsible for the service.
Service Descriptionservice_descriptionservice_descriptionTextProvides a general description of the service request.
YearyearyearNumberThe Year in which the 311 ticket was created.
Row IDrow_idrow_idTextSystem generated value for each 311 request created in the system
Service Category (Service Area)service_category_service_areaservice_category_service_areaTextA combination of Service Category and Service Area so visualizations can be created
(Service Area) Service Categoryservice_area_service_categoryservice_area_service_categoryTextA combination of Service Area and Service Category so visualizations can be created
(Service Area) Service Descriptionservice_area_service_descriptionservice_area_service_descriptionTextA combination of Service Area and Service Description so visualizations can be created
Status Detailstatus_detailstatus_detailTextCertain request types may include additional detals describing the progress or action associated with the request. The state of progress the request is at.
Date Closeddate_closeddate_closedCalendar dateThe date the appropriate City department has investigated the concern and identified steps to resolve your request. Action for resolving the issue may be dependent on priority and weather conditions or your issue has been closed due to lack of information including contact details.
Ward Locationward_locationward_locationPointThe combination of latitude/longitude for the centroid of the Ward used for mapping purposes.
Ward Longitudeward_longitudeward_longitudeNumberThe longitude value for the centroid of the Ward
Ward Latitudeward_latitudeward_latitudeNumberThe latitude value for the centroid of the Ward

Upstream Metadata