Layer: Sidewalk_Reporter (ID:0)

View In: Map Viewer

Name: Sidewalk_Reporter

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:

{"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)
Tree_Gaurantee (type: esriFieldTypeString, alias: Tree Gaurantee, SQL Type: sqlTypeOther, length: 256, 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 3:43:34 PM

Schema Last Edit Date: 7/18/2025 3:43:34 PM

Data Last Edit Date: 7/18/2025 3:43:34 PM

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