edmonton-ca/311-requests-2014-vvnz-h46c
Icon for Socrata external plugin
 
Readme
Updated 3 years ago
Indexed 6 hours ago

311 Requests (2014)

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

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Ward Longitudeward_longitudeward_longitudeNumberThe longitude value for the centroid of the Ward
Nbhd Longitudenbhd_longitudenbhd_longitudeNumberThe longitude value for the centroid of the Neighbourhood
Nbhd Latitudenbhd_latitudenbhd_latitudeNumberThe latitude value for the centroid of the Neighbourbhood
Neighbourhood IDneighbourhood_idneighbourhood_idNumberUnique number identifier given to Neighourhoods throughout Edmonton
Service Areaservice_areaservice_areaTextThe business area that is responsible for the service.
Service Descriptionservice_descriptionservice_descriptionTextProvides a general description of the service request.
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.
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
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.
Row IDrow_idrow_idTextSystem generated value for each 311 request created in the system
Nbhd Locationnbhd_locationnbhd_locationPointThe combination of latitude/longitude for the centroid of the Neighbourhood used for mapping purposes.
Service Category (Service Area)service_category_service_areaservice_category_service_areaTextA combination of Service Category and Service Area so visualizations can be created
WardwardwardTextA unique number give to a geographical area representing a electoral area
NeighbourhoodneighbourhoodneighbourhoodTextThe name given to a Neighbourhood
Ward Location (city)ward_location_cityward_location_cityText
Nbhd Location (state)nbhd_location_statenbhd_location_stateText
Nbhd Location (address)nbhd_location_addressnbhd_location_addressText
Nbhd Location (city)nbhd_location_citynbhd_location_cityText
CountcountcountNumberA field created to do a sum function for charting purposes (Note: having this would be equivalent to doing a row count).
Ward Locationward_locationward_locationPointThe combination of latitude/longitude for the centroid of the Ward used for mapping purposes.
Ward Latitudeward_latitudeward_latitudeNumberThe latitude value for the centroid of the Ward
Ward Location (zip)ward_location_zipward_location_zipText
Ward Location (state)ward_location_stateward_location_stateText
Ward Location (address)ward_location_addressward_location_addressText
Nbhd Location (zip)nbhd_location_zipnbhd_location_zipText
YearyearyearNumberThe Year in which the 311 ticket was created.
(Service Area) Service Descriptionservice_area_service_descriptionservice_area_service_descriptionTextA combination of Service Area and Service Description 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
Referral Typereferral_typereferral_typeTextThe action associated with how the request was handled either information provided or transferred to a business area.
Service Categoryservice_categoryservice_categoryTextThe type of action or service request.
Interaction Channelinteraction_channelinteraction_channelTextThe channel or method in which the request was initiated
MonthmonthmonthTextThe Month in which the 311 ticket was created.
Request Statusrequest_statusrequest_statusTextThe stage at which your request is at, Open or Closed.
 
Preview
  • 311_requests_2014
     
Upstream Metadata