Layer: Sidewalk_Reporter (ID:0)

View In: Map Viewer

Name: Sidewalk_Reporter

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

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:

{"renderer":{"type":"simple","label":"Sidewalk Reporter","description":"Survey Data Locations","symbol":{"color":[255,0,0,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,0,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"}}},"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)
Report_ID (type: esriFieldTypeString, alias: Report_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
parcel_id (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Owner (type: esriFieldTypeString, alias: Property Owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
District (type: esriFieldTypeString, alias: Council District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CoD_employee (type: esriFieldTypeString, alias: Are you reporting as a citizen or City of Detroit Employee?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Citizen: Citizen], [CoD_employee: CoD Employee])
CoD_email (type: esriFieldTypeString, alias: City of Detroit email address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CoD_dept (type: esriFieldTypeString, alias: Which department do you work for?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [DoN: Department of Neighborhoods], [Mayor: Mayor's Office], [Council: Council Member Staff], ... 5 more ...)
dept_other (type: esriFieldTypeString, alias: If Other, what is the name of the department?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
coll_dept (type: esriFieldTypeString, alias: coll_dept, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ombds_num (type: esriFieldTypeString, alias: If Ombudsman, what is the name of the Complaint #?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
f_name (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
l_name (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
email (type: esriFieldTypeString, alias: Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
phone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
senior_direct (type: esriFieldTypeString, alias: Are you a senior citizen?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
senior_citizen (type: esriFieldTypeString, alias: senior_citizen, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Referal (type: esriFieldTypeString, alias: Are your reporting on behalf of a citizen?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
ref_full_name (type: esriFieldTypeString, alias: Name of Citizen, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ref_email (type: esriFieldTypeString, alias: Email Address of Citizen, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ref_phone (type: esriFieldTypeString, alias: Phone Number of Citizen, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
senior_ref (type: esriFieldTypeString, alias: senior citizen?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
report_class (type: esriFieldTypeString, alias: What issue are you reporting?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [new_dmg: New report of damaged sidewalk], [prev_dmg: Previously reported damaged sidewalk], [restore: Report sidewalk construction related complaint (damaged sprinkler heads, lawn, etc.)])
dmgd_flgs (type: esriFieldTypeString, alias: Estimated Number of Sidewalk Flags Damaged/Missing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: 1], [2-3: 2-3], [4-6: 4-6], ... 2 more ...)
flg_Condition (type: esriFieldTypeString, alias: Describe Condition of Sidewalk, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_condition_other_text (type: esriFieldTypeString, alias: If other, please describe the damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_condition_Missing (type: esriFieldTypeString, alias: Report_condition_Missing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_condition_Asphalt (type: esriFieldTypeString, alias: Report_condition_Asphalt, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_condition_Cracked (type: esriFieldTypeString, alias: Report_condition_Cracked, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_ondition_overgrowth (type: esriFieldTypeString, alias: Report_ondition_overgrowth, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_condition_Raised (type: esriFieldTypeString, alias: Report_condition_Raised, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_condition_Sunken (type: esriFieldTypeString, alias: Report_condition_Sunken, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_condition_Other (type: esriFieldTypeString, alias: Report_condition_Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_dmg_src (type: esriFieldTypeString, alias: Describe source of Sidewalk damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_Source_other_text (type: esriFieldTypeString, alias: If other, please describe the damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_Source_Tree (type: esriFieldTypeString, alias: Report_Source_Tree, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_Source_Demo (type: esriFieldTypeString, alias: Report_Source_Demo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_Source_Utility (type: esriFieldTypeString, alias: Report_Source_Utility, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_Source_Unknown (type: esriFieldTypeString, alias: Report_Source_Unknown, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Report_Source_Other (type: esriFieldTypeString, alias: Report_Source_Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Comment (type: esriFieldTypeString, alias: Additional Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
inspect_date (type: esriFieldTypeDate, alias: Assigned Inspection Date, 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, 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)
user_det (type: esriFieldTypeString, alias: user_det, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
class (type: esriFieldTypeString, alias: user_class, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
CoD_inspector (type: esriFieldTypeString, alias: Sidewalk inspector, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
inspection (type: esriFieldTypeString, alias: inspection, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Street_Limit_1 (type: esriFieldTypeString, alias: Street Limit 1, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Street_Limit_2 (type: esriFieldTypeString, alias: Street Limit 2, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Vertical_Displacment_ (type: esriFieldTypeString, alias: Vertical Displacment (Inches), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Horizontal_Gap_at_Joint_ (type: esriFieldTypeString, alias: Horizontal Gap at Joint (Inches), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Horizontal_Gap_of_Crack_ (type: esriFieldTypeString, alias: Horizontal Gap of Crack(s) (Inches), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Broken_Cracked_ (type: esriFieldTypeString, alias: Broken/Cracked (%), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Quantity_City_Responsibility_ (type: esriFieldTypeString, alias: Quantity - City Responsibility (SqFt), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Quantity_Property_Owner_Responsibility_ (type: esriFieldTypeString, alias: Quantity - Property Owner Responsibility (SqFt), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Does_block_appear_to_be_at_least_60_occupied (type: esriFieldTypeString, alias: Does block appear to be at least 60% occupied?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Condition_Rating (type: esriFieldTypeString, alias: Condition Rating, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Recently_Replaced (type: esriFieldTypeString, alias: Sidewalk Recently Replaced?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Replacement_Year (type: esriFieldTypeString, alias: Sidewalk Replacement Year, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Drainage_Issues (type: esriFieldTypeString, alias: Sidewalk Drainage Issues?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Date_Placed (type: esriFieldTypeDate, alias: Date Placed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Date_Recorded (type: esriFieldTypeDate, alias: Date Recorded, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Contractor (type: esriFieldTypeString, alias: Contractor, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Foreman (type: esriFieldTypeString, alias: Foreman, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Map_No (type: esriFieldTypeString, alias: Map No., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Curb_and_Gutter (type: esriFieldTypeString, alias: Curb and Gutter, Conc, Det C5 (Ft) - 8020024, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Curb_Ramp_Opening (type: esriFieldTypeString, alias: Curb Ramp Opening, Conc (Ft) - 8030030, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Curb_Conc_Detail_CD (type: esriFieldTypeString, alias: Curb, Conc, Detail CD, Modified (Ft) - 6037001, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Curb_Rem_Modified (type: esriFieldTypeString, alias: Curb, Rem, Modified (Ft) - 2047001, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Detectable_Warning_Surface_Tile (type: esriFieldTypeString, alias: Detectable Warning Surface Tile, Modified (Ft) - 8027001, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Driveway_Nonreinf_Conc_Length (type: esriFieldTypeString, alias: Driveway, Nonreinf Conc, 8 inch (Length) - 8037010, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Driveway_Nonreinf_Conc_Width (type: esriFieldTypeString, alias: Driveway, Nonreinf Conc, 8 inch (Width) - 8037010, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Driveway_Nonreinf_Conc_sqft (type: esriFieldTypeString, alias: Driveway, Nonreinf Conc, 8 inch (SqFt) - 8037010, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Grinding_Sidewalk (type: esriFieldTypeString, alias: Grinding Sidewalk (SqFt) - 8037010, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Manhole_Structure_Cover_Adj (type: esriFieldTypeString, alias: Manhole Structure Cover Adj, Case II (Ea) - 4037050, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Monument_Box_Adjust_Modified (type: esriFieldTypeString, alias: Monument Box Adjust Modified (Ea) - 8210005, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Monument_Box_Modified (type: esriFieldTypeString, alias: Monument Box Modified (Ea) - 8210001, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Monument_Preservation_Vertical_Modified (type: esriFieldTypeString, alias: Monument Preservation, Vertical Modified (Ea) - 8210015, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Saw_Cut_Intermediate (type: esriFieldTypeString, alias: Saw Cut, Intermediate (Ft) - 6030090, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Seeding_Mixture_THM (type: esriFieldTypeString, alias: Seeding, Mixture THM (SqYd) - 8167011, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Ramp_ADA_6_inch_Length (type: esriFieldTypeString, alias: Sidewalk Ramp, ADA, 6 inch, COD Modified (Length) - 8027010, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Ramp_ADA_6_inch_Width (type: esriFieldTypeString, alias: Sidewalk Ramp, ADA, 6 inch, COD Modified (Width) - 8027010, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Ramp_ADA_6_inch_sqft_ (type: esriFieldTypeString, alias: Sidewalk Ramp, ADA, 6 inch, COD Modified (SqFt) - 8027010, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Conc_4_inch_Length (type: esriFieldTypeString, alias: Sidewalk, Conc, 4 inch (Length) - 8030044, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Conc_4_inch_Width (type: esriFieldTypeString, alias: Sidewalk, Conc, 4 inch (Width) - 8030044, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Conc_4_inch_SqFt (type: esriFieldTypeString, alias: Sidewalk, Conc, 4 inch (SqFt) - 8030044, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Conc_4_inch_With_Tree_RootsModified_Length (type: esriFieldTypeString, alias: Sidewalk, Conc, 4 inch, With Tree Roots, Modified (Length) - 8037010, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Conc_4_inch_With_Tree_RootsModified_Width (type: esriFieldTypeString, alias: Sidewalk, Conc, 4 inch, With Tree Roots, Modified (Width) - 8037010, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Conc_4_inch_With_Tree_RootsModified_SqFt (type: esriFieldTypeString, alias: Sidewalk, Conc, 4 inch, With Tree Roots, Modified (SqFt) - 8037010, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Conc_6_inch_Length (type: esriFieldTypeString, alias: Sidewalk, Conc, 6 inch (Length) - 8030046, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Conc_6_inch_Width (type: esriFieldTypeString, alias: Sidewalk, Conc, 6 inch (Width) - 8030046, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Conc_6_inch_SqFt (type: esriFieldTypeString, alias: Sidewalk, Conc, 6 inch (SqFt) - 8030046, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Conc_6_inch_With_Tree_RootsModified_Length (type: esriFieldTypeString, alias: Sidewalk, Conc, 6 inch, With Tree Roots, Modified (Length) - 8037010, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Conc_6_inch_With_Tree_RootsModified_Width (type: esriFieldTypeString, alias: Sidewalk, Conc, 6 inch, With Tree Roots, Modified (Width) - 8037010, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Conc_6_inch_With_Tree_RootsModified_SqFt (type: esriFieldTypeString, alias: Sidewalk, Conc, 6 inch, With Tree Roots, Modified (SqFt) - 8037010, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Rem_Length (type: esriFieldTypeString, alias: Sidewalk, Rem (Length) - 2040055, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Rem_Width (type: esriFieldTypeString, alias: Sidewalk, Rem (Width) - 2040055, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Sidewalk_Rem_SqYd (type: esriFieldTypeString, alias: Sidewalk, Rem (SqYd) - 2040055, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Stump_Rem_19_inch_to_36_inch_Ea (type: esriFieldTypeString, alias: Stump, Rem, 19 inch to 36 inch (Ea) - 2020006, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Stump_Rem_37_inch_or_Larger_Ea (type: esriFieldTypeString, alias: Stump, Rem, 37 inch or Larger (Ea) - 2020007, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Stump_Rem_6_inch_to_18_inch_Ea (type: esriFieldTypeString, alias: Stump, Rem, 6 inch to 18 inch (Ea) - 2020008, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Topsoil_Surface_Furn_4_inch_SqYd (type: esriFieldTypeString, alias: Topsoil Surface, Furn, 4 inch (SqYd) - 8160062, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Water_Shutoff_Adj_Case_1_Modified_Ea (type: esriFieldTypeString, alias: Water Shutoff, Adj, Case 1 Modified (Ea) - 8230421, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Water_Shutoff_Adj_Case_2_Modified_Ea (type: esriFieldTypeString, alias: Water Shutoff, Adj, Case 2 Modified (Ea) - 8230422, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Tree_Gaurantee (type: esriFieldTypeString, alias: Tree Gaurantee, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
age (type: esriFieldTypeString, alias: age, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
disability (type: esriFieldTypeString, alias: disability, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
assistive (type: esriFieldTypeString, alias: assistive, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
assistive_device (type: esriFieldTypeString, alias: assistive_device, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
cane (type: esriFieldTypeString, alias: cane, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
crutches (type: esriFieldTypeString, alias: crutches, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
wheelchair (type: esriFieldTypeString, alias: wheelchair, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
walker (type: esriFieldTypeString, alias: walker, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Condo (type: esriFieldTypeString, alias: Is this a Condo?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Condo_Address (type: esriFieldTypeString, alias: Condo Address, 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/17/2025 6:56:26 PM

Schema Last Edit Date: 7/17/2025 6:56:26 PM

Data Last Edit Date: 7/17/2025 6:56:26 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Attachments Add Features Update Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat