Name: CDPH_Complaints

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• id (type: esriFieldTypeInteger, alias: id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• complaint_number (type: esriFieldTypeString, alias: complaint_number, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• submit_date (type: esriFieldTypeDate, alias: submit_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• submit_time (type: esriFieldTypeString, alias: submit_time, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• complaint_type (type: esriFieldTypeString, alias: complaint_type, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• complaint_input (type: esriFieldTypeString, alias: complaint_input, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• complaint_inspector (type: esriFieldTypeString, alias: complaint_inspector, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• complaint_status (type: esriFieldTypeString, alias: complaint_status, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• complaint_outcome (type: esriFieldTypeString, alias: complaint_outcome, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• food_complaint (type: esriFieldTypeString, alias: food_complaint, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• farm_animal (type: esriFieldTypeString, alias: farm_animal, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• insect_vermin (type: esriFieldTypeString, alias: insect_vermin, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• odor_type (type: esriFieldTypeString, alias: odor_type, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• odor_strength (type: esriFieldTypeString, alias: odor_strength, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• problem_location_name (type: esriFieldTypeString, alias: problem_location_name, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• problem_address (type: esriFieldTypeString, alias: problem_address, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• problem_street_direction (type: esriFieldTypeString, alias: problem_street_direction, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• problem_street_name (type: esriFieldTypeString, alias: problem_street_name, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• problem_street_type (type: esriFieldTypeString, alias: problem_street_type, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• problem_unit_number (type: esriFieldTypeString, alias: problem_unit_number, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• problem_city (type: esriFieldTypeString, alias: problem_city, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• problem_zip_code (type: esriFieldTypeString, alias: problem_zip_code, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• problem_date_time (type: esriFieldTypeString, alias: problem_date_time, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• mac_complaint_id (type: esriFieldTypeString, alias: mac_complaint_id, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• permanent_parcel_number (type: esriFieldTypeString, alias: permanent_parcel_number, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• census_tract (type: esriFieldTypeString, alias: census_tract, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• ward_number (type: esriFieldTypeString, alias: ward_number, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• submit_datetime (type: esriFieldTypeDate, alias: submit_datetime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• dw_ward (type: esriFieldTypeDouble, alias: dw_ward, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dw_ward_2014 (type: esriFieldTypeDouble, alias: dw_ward_2014, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dw_ward_2026 (type: esriFieldTypeDouble, alias: dw_ward_2026, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dw_neighborhood (type: esriFieldTypeString, alias: dw_neighborhood, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• dw_census_tract (type: esriFieldTypeString, alias: dw_census_tract, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• dw_parcel (type: esriFieldTypeString, alias: dw_parcel, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/27/2025 10:39:45 AM

Schema Last Edit Date: 7/27/2025 10:39:45 AM

Data Last Edit Date: 7/27/2025 10:39:45 AM

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