Layer: Eyes_on_the_Street

View In: Map Viewer

Name: Eyes_on_the_Street_V3

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Eyes on the Street V3","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field: globalid

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
Location_Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Issue (type: esriFieldTypeString, alias: Issue Observed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [DDOT - Bus Stop Issue: DDOT - Bus Stop Issue], [DWSD - Flooded Street: DWSD - Flooded Street], [DWSD - Cave-In (Street, Alley, Sidewalk): DWSD - Cave-In (Street, Alley, Sidewalk)], ... 17 more ...)
mot_type_of_device (type: esriFieldTypeString, alias: MOT Type of Device, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mot_type_of_device_other (type: esriFieldTypeString, alias: If Other, please write-in, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
total_number_of_devices_removed (type: esriFieldTypeDouble, alias: Total Number of Devices Removed, SQL Type: sqlTypeOther, nullable: true, editable: true)
ownership_of_the_mot_device (type: esriFieldTypeString, alias: Ownership of the MOT Device, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ownership_of_the_mot_device_oth (type: esriFieldTypeString, alias: If Other, please write-in, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
status_of_mot_device (type: esriFieldTypeString, alias: Status of MOT Device, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Damaged/ disposable: Damaged/ disposable], [Good/ salvageable: Good/ salvageable])
Freeway (type: esriFieldTypeString, alias: Freeway, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
BusStop_Broken_Shelter_Glass (type: esriFieldTypeString, alias: BusStop_Broken_Shelter_Glass, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
BusStop_TrashDebrisIssue (type: esriFieldTypeString, alias: BusStop_TrashDebrisIssue, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
BusStop_Graffiti (type: esriFieldTypeString, alias: BusStop_Graffiti, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
BusStop_BrokenDamagedShelter (type: esriFieldTypeString, alias: BusStop_BrokenDamagedShelter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
BusStop_AdShelter (type: esriFieldTypeString, alias: Is this an advertising shelter?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
BusStop_brkglassground (type: esriFieldTypeString, alias: Is there broken glass on the ground?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
BusStopID (type: esriFieldTypeString, alias: What is the bus stop ID?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BusStopComments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
FloodStr_ImmSafetyIssue (type: esriFieldTypeString, alias: Is this an immediate safety issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
FloodStr_water_catchbasin (type: esriFieldTypeString, alias: Is the water-flow reaching the catch-basin?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unsure: Unsure])
FloodStr_catchbasin_blocked (type: esriFieldTypeString, alias: Is the catch-basin visibly blocked (debris on top)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
FloodStr_catchbasin_StreetAlley (type: esriFieldTypeString, alias: Is the catch-basin in the street or the alley?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Street: Street], [Alley: Alley], [Yes: Yes], ... 1 more ...)
FloodStr_RoadName (type: esriFieldTypeString, alias: What is name of the road the flooding is taking place on?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
FloodStr_TypeFlood (type: esriFieldTypeString, alias: What is the type of flooding?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Blocked Bus Stop: Blocked Bus Stop], [Entire Street Flooded: Entire Street Flooded], [Street Partially Flooded: Street Partially Flooded])
FloodStr_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CaveIn_Location (type: esriFieldTypeString, alias: Is this a street, alley, or a sidewalk?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Street: Street], [Alley: Alley], [Sidewalk: Sidewalk])
CaveIn_ImmSafetyIssue (type: esriFieldTypeString, alias: Is this an immediate safety issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CaveIn_ApproxSizeVoid (type: esriFieldTypeString, alias: Approximate size of the void (in Inches)? (Example 3x3), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CaveIn_Nearby_structures (type: esriFieldTypeString, alias: Nearby structures?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Manholes: Manholes], [Catch-Basins: Catch-Basins])
CaveIn_SteelPlate (type: esriFieldTypeString, alias: Is a steel plate needed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CaveIn_DWSDBarricade (type: esriFieldTypeString, alias: Is there a DWSD barricade present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CaveIn_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
WaterMBreak_location (type: esriFieldTypeString, alias: Where is the water coming up at?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Street: Street], [Curb: Curb], ... 3 more ...)
WaterMBreak_standwater (type: esriFieldTypeString, alias: Is there water standing in the street?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
WaterMBreak_nearStructures (type: esriFieldTypeString, alias: Are there any Cones, Barricades, Signs, or other indication that DWSD is aware of the issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
WaterMBreak_ImmSafetyIssue (type: esriFieldTypeString, alias: Is this an immediate safety issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
WaterMBreak_Streets (type: esriFieldTypeString, alias: What two streets is the water main break between?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
WaterMBreak_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TrafficSignal_Intersection (type: esriFieldTypeString, alias: Please provide name of the intersection., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TrafficSignal_Issue (type: esriFieldTypeString, alias: What is the type of issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TrafficSignal_IssueOther (type: esriFieldTypeString, alias: If Other, Explain:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TrafficSignal_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
StreetLight_Out (type: esriFieldTypeString, alias: How many streetlights are out?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
StreetLight_PoleID (type: esriFieldTypeString, alias: What is the pole ID along the side of the pole?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
StreetLight_Functioning (type: esriFieldTypeString, alias: Are there nearby streetlights functioning?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
StreetLight_Location (type: esriFieldTypeString, alias: Location of the streetlight?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Park: Park], [Major Road: Major Road], [Alley: Alley], ... 1 more ...)
StreetLight_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TrafficSign_Type (type: esriFieldTypeString, alias: What Type of sign is this?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Stop Sign: Stop Sign], [Yield Sign: Yield Sign], [One Way Sign: One Way Sign], ... 3 more ...)
TrafficSign_TypeOther (type: esriFieldTypeString, alias: If other, please explain:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TrafficSign_Problem (type: esriFieldTypeString, alias: What is the nature of the problem?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Sign down: Sign down], [Sign damaged: Sign damaged], [Sign defaced: Sign defaced], ... 2 more ...)
TrafficSign_ProblemOther (type: esriFieldTypeString, alias: If other, please explain:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TrafficSign_CementDirt (type: esriFieldTypeString, alias: Is the sign pole in Cement or Dirt?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Cement: Cement], [Dirt: Dirt])
TrafficSign_Graffiti (type: esriFieldTypeString, alias: Is there graffiti on the sign?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
TrafficSign_Condition (type: esriFieldTypeString, alias: What is the condition of the traffic sign?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Salvageable: Salvageable], [Not Salvageable: Not Salvageable])
TrafficSign_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DownedPole_Ownership (type: esriFieldTypeString, alias: Who does the pole belong to?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [DTE: DTE], [PLA: PLA], [PLD: PLD], ... 3 more ...)
DownedPole_OwnerOther (type: esriFieldTypeString, alias: If other, please write-in who the pole belongs to:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DownedPole_Safety (type: esriFieldTypeString, alias: Is this an immediate safety issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
DownedPole_StreetBlocking (type: esriFieldTypeString, alias: Is the pole blocking the major road/ sidewalk?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
DownedPole_attachments (type: esriFieldTypeString, alias: Does the pole have any attachments?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
DownedPole_attachmentsType (type: esriFieldTypeString, alias: If yes, what is attached to the pole?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DownedPole_LeanDown (type: esriFieldTypeString, alias: Is the pole leaning against something or is on the ground?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Leaning: Leaning], [Down: Down], [Missing: Missing])
DownedPole_PoleNumber (type: esriFieldTypeString, alias: What is the pole number found along the side of the pole?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DownedPole_metal_wood (type: esriFieldTypeString, alias: Is the street light pole made of metal or wood?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Metal: Metal], [Wood: Wood])
DownedPole_Condition (type: esriFieldTypeString, alias: Condition of the pole?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Damaged: Damaged], [Burned: Burned], [Good Condition: Good Condition])
DownedPole_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
UtilityStruct_ImmSafety (type: esriFieldTypeString, alias: Is this an immediate safety issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
UtilityStruct_StrType (type: esriFieldTypeString, alias: What is the type of structure?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Manhole: Manhole], [Catch-Basin: Catch-Basin], [Hand-Hold: Hand-Hold], ... 9 more ...)
UtilityStruct_sunkendepth (type: esriFieldTypeString, alias: If this is a sunken structure, how deep is it (in inches)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
UtilityStruct_SrtTypeOther (type: esriFieldTypeString, alias: If your choice was "Other" - please write-in the ownership of the structure, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
UtilityStruct_Loc (type: esriFieldTypeString, alias: What is the location of the structure?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Street: Street], [Sidewalk: Sidewalk], [Berm: Berm], ... 1 more ...)
UtilityStruct_NearbyOwner (type: esriFieldTypeString, alias: What nearby structures exist and what is the ownership of the nearby structures?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
UtilityStruct_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
FreewayIssue_IssueType (type: esriFieldTypeString, alias: Select issue from the following?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [BrokenSignPosts: Broken Sign Posts], [DamagedFreewayMOT: Damaged Freeway MOT], [DamagedFreewaySign: Damaged Freeway Sign], ... 8 more ...)
FreewayIssue_location (type: esriFieldTypeString, alias: On which freeway is this issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [I-75: I-75], [I-96: I-96], [I-94: I-94], ... 9 more ...)
Freeway_Direction (type: esriFieldTypeString, alias: Freeway direction of travel (NB, SB, EB, WB)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NB: NB], [SB: SB], [EB: EB], ... 1 more ...)
FreewayIssue_MileMarker (type: esriFieldTypeString, alias: What is the approximate mile marker of this issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
FreewayIssue_freewSign (type: esriFieldTypeString, alias: What is on the Freeway sign (Ex: "8 Mile Rd 1/4 mile" or "Exit 54")?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
FreewayIssue_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pothole_damagevehicle (type: esriFieldTypeString, alias: Is this in an area of the road that can cause severe damage to vehicles?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
pothole_ImmSafety (type: esriFieldTypeString, alias: Is this an immediate safety issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
pothole_number (type: esriFieldTypeString, alias: What is the approximate number of potholes?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pothole_size (type: esriFieldTypeString, alias: What is the size of the pothole (in inches)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pothole_comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GraffitiRoW_location (type: esriFieldTypeString, alias: If graffiti is on a bus stop shelter, please change your issue to "DDOT-Bus Stop Issue" and continue from there. If not, select from the following where the graffiti issue is located:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Traffic Control Sign: Traffic Control Sign], [Pole: Pole], [City Property: City Property], ... 4 more ...)
GraffitiRoW_citypropertyloc (type: esriFieldTypeString, alias: If your choice was City Property, please describe where the graffiti is located?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GraffitiRoW_locOther (type: esriFieldTypeString, alias: If your choice was Other, please describe where the graffiti is located:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GraffitionRoW_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BikelaneDel_NoDamged (type: esriFieldTypeString, alias: How many delineators are damaged?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BikelaneDel_Comment (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator Inspector , SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
Name_Inspector (type: esriFieldTypeString, alias: Name of Inspector, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Andre Harris: Andre Harris], [Jimmy Heike-Woody: Jimmy Heike-Woody], [Jason Peterson: Jason Peterson], ... 9 more ...)
StreetLight_lightsout (type: esriFieldTypeString, alias: Are a string of multiple lights out in a row, or are light outages spread out?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [String of Multiple Lights Out in a Row: String of Multiple Lights Out in a Row], [Lights Outages Spread Out: Lights Outages Spread Out])
Streetlight_power (type: esriFieldTypeString, alias: Does this look like a power outage, or just a single pole out?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Power Outage: Power Outage], [Single Pole Out: Single Pole Out])
Streetlight_positioning (type: esriFieldTypeString, alias: Does the positioning of the pole need to be corrected?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [District 1: District 1], [District 2: District 2], [District 3: District 3], ... 4 more ...)
IssueStatus (type: esriFieldTypeString, alias: Issue Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Resolved: Resolved], [Unresolved: Unresolved], [No Action Required: No Action Required], ... 3 more ...)
MOTStreet1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MOTStreet2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MOT_jurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
BusStopStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BusStopStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BusStopJurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
FloodStrStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
FloodStrStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
FloodStr_jurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
CaveIn_Owner (type: esriFieldTypeString, alias: Who is the suspected owner of this issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [DWSD: DWSD], [DTE: DTE], [PLD: PLD], ... 2 more ...)
CaveInStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CaveInStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CaveIn_jurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
WaterMBreak_IntStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
WaterMBreak_IntStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
WaterMBreak_jurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
TrafficSignalStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TrafficSignalStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
trafficSignal_jurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
StreetLightStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
StreetLightStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TrafficSignStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TrafficSignStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TrafficSign_jurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
DownedPoleStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DownedPoleStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DownedPole_jurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
UtilityStruct_Owner (type: esriFieldTypeString, alias: Who does the structure belong to?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AT&T: AT&T], [Comcast: Comcast], [Detroit Thermal: Detroit Thermal], ... 10 more ...)
UtilityStructOwner_other (type: esriFieldTypeString, alias: If your choice was "Other" - please write-in the ownership of the structure, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
UtilityStruct_missdig (type: esriFieldTypeString, alias: Are there MissDIG markings nearby?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
UtilityStructStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
UtilityStrucStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
UtilityStruct_jurisdiction (type: esriFieldTypeString, alias: UtilityStruct_jurisdiction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
FreewayIssueStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
FreewayIssueStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
FreewayIssue_jurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
potholeStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
potholeStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pothole_jurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
GraffitiRoW_locBusStop (type: esriFieldTypeString, alias: If your choice was bus stop, is the bus stop an advertising shelter?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
GraffitiRoWStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GraffitiRoWStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GraffitionRoW_Jurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
BikelaneStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BikelaneStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BikelaneDel_jurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
TreeDamage_property (type: esriFieldTypeString, alias: Is this one private property or City-owned property?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Private Property: Private Property], [City-Owned Property: City-Owned Property])
TreeDamage_damage (type: esriFieldTypeString, alias: Did the tree cause damage to utilities or other nearby objects?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
TreeDamageStatus (type: esriFieldTypeString, alias: Is the tree completely down, limbs damaged, or a branch damaged?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Tree Completely Down: Tree Completely Down], [Limbs Damaged: Limbs Damaged], [Branch Damaged: Branch Damaged])
TreeDamageHeight (type: esriFieldTypeString, alias: Estimate the height of the tree in feet?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TreeDamageStr1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TreeDamageStr2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TreeDamage_jurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
TreeDamage_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Restoration_TempPerma (type: esriFieldTypeString, alias: What is the type of restoration issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Temporary Restoration: Temporary Restoration], [Permanent Restoration: Permanent Restoration], [ADA Ramp: ADA Ramp], ... 3 more ...)
Restoration_location (type: esriFieldTypeString, alias: Location of the restoration?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Street: Street], [Sidewalk: Sidewalk], [Alley: Alley], ... 1 more ...)
Restoration_condition (type: esriFieldTypeString, alias: Condition of the Restoration?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Failing: Failing], [Missing: Missing], [Sunken (Dip): Sunken (Dip)])
Restoration_material (type: esriFieldTypeString, alias: Material used for temporary restoration?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Cold Patch: Cold Patch], [Stone/Gravel: Stone/Gravel], [Missing Restoration Completely: Missing Restoration Completely])
Restoration_relateStructure (type: esriFieldTypeString, alias: Is the restoration related to a structure?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Restoration_steelplate (type: esriFieldTypeString, alias: Is a steel plate needed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Restoration_type (type: esriFieldTypeString, alias: What type of restoration is it?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Utility Cut: Utility Cut], [Trench: Trench], [Structural: Structural])
Restoration_Str1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Restoration_Str2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Restoration_jurisdiction (type: esriFieldTypeString, alias: What is the jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City: City], [Wayne County: Wayne County], [MDOT: MDOT])
Restoration_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Freeway_Str1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Freeway_Str2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
RestorationADAIssue (type: esriFieldTypeString, alias: What is the issue with the ADA Ramp?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Missing: Missing], [Cracked: Cracked], [Sinking: Sinking])
RestorationADAPad (type: esriFieldTypeString, alias: Is the pad still in place?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
RestorationADAflood (type: esriFieldTypeString, alias: Is Water Flooding into this ADA Ramp?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Water Flooding: Water Flooding], [No Flooding: No Flooding])
ReInspectionComment (type: esriFieldTypeString, alias: Re-Inspection Comment, SQL Type: sqlTypeOther, length: 550, nullable: true, editable: true)
Reinspection_date (type: esriFieldTypeDate, alias: ReInspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
TrafficSign_location (type: esriFieldTypeString, alias: Is this sign Mid-Block or at an Intersection?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Mid-Block: Mid-Block], [Intersection: Intersection])
Issue_Priority (type: esriFieldTypeString, alias: Issue Priority, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Emergency: Emergency], [High: High], [Medium: Medium], ... 2 more ...)
FloodStr_gradingissue (type: esriFieldTypeString, alias: Does this appear to be a grading issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Restoration_materialleft (type: esriFieldTypeString, alias: Materials left behind?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Restoration_materiallefttype (type: esriFieldTypeString, alias: If materials are left behind, what are they?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SidewalkDamageLoc (type: esriFieldTypeString, alias: Is this an Intersection or Mid-block?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Intersection: Intersection], [Mid-block: Mid-block])
Sidewalk_Intersection1 (type: esriFieldTypeString, alias: Sidewalk Intersection 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Sidewalk_Intersection2 (type: esriFieldTypeString, alias: Sidewalk Intersection 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Sidewalk_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Streetlight_trreovergrowth (type: esriFieldTypeString, alias: Is there tree overgrowth blocking the streetlight from being seen?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
GraffitiRoW_graffiti_sticker (type: esriFieldTypeString, alias: Is this graffiti or a sticker/sign?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Graffiti: Graffiti], [Sticker/Sign: Sticker/Sign])
BusStop_DamagedLeaningBusStopS (type: esriFieldTypeString, alias: BusStop_DamagedLeaningBusStopS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
RestorationResParty (type: esriFieldTypeString, alias: Suspected Responsible Party?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [DWSD: DWSD], [DTE: DTE], [Telecom: Telecom], ... 6 more ...)
Guardrail_location (type: esriFieldTypeString, alias: On which freeway is this issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [I-75: I-75], [I-96: I-96], [I-94: I-94], ... 4 more ...)
Guardrail_direction (type: esriFieldTypeString, alias: What is the direction of travel?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NB: NB], [SB: SB], [EB: EB], ... 1 more ...)
Guardrail_MileMarker (type: esriFieldTypeString, alias: What is the approximate mile marker of this issue?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Guardrail_freewSign (type: esriFieldTypeString, alias: Nearest Exit on Freeway (name or exit#)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Guardrail_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Guardrail_Str1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Guardrail_Str2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DownedPole_direction (type: esriFieldTypeString, alias: Is this pole East or West of Livernois?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [West: West], [East: East])
AlleyLightsNote (type: esriFieldTypeString, alias: Note: Select and submit this only if this is a High Pressure Sodium Light (HPS), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AlleyLightStreetName (type: esriFieldTypeString, alias: On what street is this alley?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AlleyLightResidential (type: esriFieldTypeString, alias: Is this alley light in a residential area?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
AlleyLightLocation (type: esriFieldTypeString, alias: Is this behind a home, commercial property, or vacant property?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Home: Home], [CommercialProperty: Commercial Property], [VacantProperty: Vacant Property])
AlleyLightFunctioning (type: esriFieldTypeString, alias: How many lights are functioning?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AlleyLightBorderStreet1 (type: esriFieldTypeString, alias: Border Street 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AlleyLightBorderStreet2 (type: esriFieldTypeString, alias: Border Street 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AlleyLightComments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GraffitiPLAPole (type: esriFieldTypeString, alias: Is this on a PLA-owned pole?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
GraffitiPLAPole_type (type: esriFieldTypeString, alias: Is this graffiti or a sticker/sign?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Graffiti: Graffiti], [Sticker/Sign: Sticker/Sign])
GraffitPLAPole_Inter1 (type: esriFieldTypeString, alias: Intersection 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GraffitPLAPole_Inter2 (type: esriFieldTypeString, alias: Intersection 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GraffitPLAPole_Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BikelaneDel_Str1 (type: esriFieldTypeString, alias: Intersection 1 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BikelaneDel_Str2 (type: esriFieldTypeString, alias: Intersection 2 Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/18/2025 4:19:50 PM

Schema Last Edit Date: 7/18/2025 2:53:32 PM

Data Last Edit Date: 7/18/2025 4:19:50 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Attachments Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: Eyes_on_the_Street_V3 (ID:0)