Louisville Metro KY -  Metro 311 Service Requests 2011

<div>For over 30 years Metro311 has been the Louisville Metro customer service center. Metro311 is contacted with a question or concern. Questions are answered and denoted into the reporting system as a Non-Service Request (NSR). For concerns, a Service Request (SR) is entered into the system and based on the information provided, routed to the appropriate agency. The responsible agency handling the request will receive the report and inspect or investigate per their protocols. A SR number is generated and can be utilized to track the concern.</div><div><br /></div><div><p style='margin:0in 0in 15pt; background-image:initial; background-position:initial; background-size:initial; background-repeat:initial; background-attachment:initial; background-origin:initial; background-clip:initial; box-sizing:border-box; max-width:100%;'>The city of Louisville adheres to the Open311.org  <a href='https://wiki.open311.org/GeoReport/bulk' target='_blank' rel='nofollow ugc noopener noreferrer'>Data Standards</a> </p><p style='margin:0in 0in 15pt; background-image:initial; background-position:initial; background-size:initial; background-repeat:initial; background-attachment:initial; background-origin:initial; background-clip:initial; box-sizing:border-box; max-width:100%;'><b>Data Dictionary</b></p><table style='color:rgb(0, 0, 0); font-size:medium; border-collapse:collapse; width:530pt;' width='707'><tbody><tr height='20' style='height:15pt;'><td height='20' style='padding-top:1px; padding-right:1px; padding-left:1px; font-weight:700; font-family:&quot;Aptos Narrow&quot;, sans-serif; border:0.5pt solid black; text-align:center; background:rgb(255, 192, 0); width:121pt; height:15pt;' width='161'>Field name</td><td style='padding-top:1px; padding-right:1px; padding-left:1px; font-weight:700; font-family:&quot;Aptos Narrow&quot;, sans-serif; border:0.5pt solid black; text-align:center; background:rgb(255, 192, 0); width:410pt;' width='546'>Field description</td></tr><tr height='20' style='height:15pt;'><td height='20' style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border-top:none; border-right:0.5pt solid black; border-bottom:0.5pt solid black; border-left:0.5pt solid black; border-image:initial; width:121pt; height:15pt;' width='161'>service_request_id</td><td style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border-top:none; border-right:0.5pt solid black; border-bottom:0.5pt solid black; border-left:0.5pt solid black; border-image:initial; width:410pt;' width='546'>The unique ID of the concern created by the system.</td></tr><tr height='20' style='height:15pt;'><td height='20' style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:121pt; height:15pt;' width='161'>requested_datetime</td><td style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:410pt;' width='546'>The date and time the SR was made.</td></tr><tr height='20' style='height:15pt;'><td height='20' style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:121pt; height:15pt;' width='161'>updated_datetime</td><td style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:410pt;' width='546'>The date and time the SR was last modified</td></tr><tr height='58' style='height:43.5pt;'><td height='58' style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:121pt; height:43.5pt;' width='161'>closed_datetime</td><td style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:410pt;' width='546'>The date the SR was closed. This information only applies to the SR, not the associated cases or work orders. Responding agencies utilize cases or work orders for their investigations.</td></tr><tr height='20' style='height:15pt;'><td height='20' style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:121pt; height:15pt;' width='161'>status</td><td style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:410pt;' width='546'>An indicator of the current state of the SR.</td></tr><tr height='20' style='height:15pt;'><td height='20' style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:121pt; height:15pt;' width='161'>source</td><td style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:410pt;' width='546'>How the SR was received.</td></tr><tr height='20' style='height:15pt;'><td height='20' style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:121pt; height:15pt;' width='161'>service_name</td><td style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:410pt;' width='546'>The name of the SR type</td></tr><tr height='20' style='height:15pt;'><td height='20' style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:121pt; height:15pt;' width='161'>description</td><td style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:410pt;' width='546'>A description of the SR submitted.</td></tr><tr height='20' style='height:15pt;'><td height='20' style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:121pt; height:15pt;' width='161'>agency_responsible</td><td style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:410pt;' width='546'>The agency responsible for addressing the SR.</td></tr><tr height='20' style='height:15pt;'><td height='20' style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:121pt; height:15pt;' width='161'>address</td><td style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:410pt;' width='546'>The location of the concern.</td></tr><tr height='20' style='height:15pt;'><td height='20' style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:121pt; height:15pt;' width='161'>council_district</td><td style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:410pt;' width='546'>council district of the location</td></tr><tr height='20' style='height:15pt;'><td height='20' style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:121pt; height:15pt;' width='161'>longitude</td><td style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:410pt;' width='546'>Longitude of the location, using the WGS84 projection.</td></tr><tr height='20' style='height:15pt;'><td height='20' style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:121pt; height:15pt;' width='161'>latitude</td><td style='text-align:center; padding-top:1px; padding-right:1px; padding-left:1px; border:0.5pt solid black; width:410pt;' width='546'>Latitude of the location, using the WGS84 projection.</td></tr></tbody></table></div>

Tags: 311-calls, 311-services, city-management-and-performance, community, historical, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, metro-311
Organization: Louisville Metro Government