Layers:

Layer: COMPLAINTS (0)


Name: COMPLAINTS

Display Field: COMPLAINTCODENAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The City of Philadelphia has migrated metadata for this data set to the City-wide Metadata Catalog. For any questions about the migration and administration of the Metadata Catalog, please contact maps@phila.gov. To view the metadata for this layer, please visit: https://metadata.phila.gov/#home/datasetdetails/5543ca6d5c4ae4cd66d3ff52/representationdetails/5e5d50e0fbc9650019b56025/ Below is information copied automatically from metadata.phila.gov: Complaints that were entered via 311 or by an individual in the department. Complaints were formerly known as 'Service Requests' in L&I's old enterprise database called 'Hansen', which was decommissioned in March 2020. *Each row in the table represents a single 'call'. Calls are sometimes bunched into one 'Complaint' all sharing the same unique number For all L&I data related inquiries contact ligisteam@phila.gov For all other L&I related services (including eCLIPSE troubleshooting) please contact Philly311: -Inside City Limits: 311 -Outside City Limits: 215-686-8686 Development Process: None

Copyright Text:

Responsible Department: Department of Licenses and Inspections

Contacts: ligisteam@phila.gov



Min. Scale: 2483.06917330329

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8379910.55251889
YMin: 4846984.74004585
XMax: -8344119.64715286
YMax: 4886797.0148771
Spatial Reference: 102100 (3857)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[243,198,19,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True


Global ID Field:

Type ID Field:

Fields:
• addressobjectid (type: esriFieldTypeString, alias: ADDRESSOBJECTID, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• unit_type (type: esriFieldTypeString, alias: UNIT_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• unit_num (type: esriFieldTypeString, alias: UNIT_NUM, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• zip (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• censustract (type: esriFieldTypeString, alias: CENSUSTRACT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• parcel_id_num (type: esriFieldTypeString, alias: PARCEL_ID_NUM, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• opa_account_num (type: esriFieldTypeString, alias: OPA_ACCOUNT_NUM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• opa_owner (type: esriFieldTypeString, alias: OPA_OWNER, SQL Type: sqlTypeOther, length: 1999, nullable: true, editable: true)
• complaintnumber (type: esriFieldTypeString, alias: COMPLAINTNUMBER, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• casenumber (type: esriFieldTypeString, alias: CASENUMBER, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• complaintcode (type: esriFieldTypeString, alias: COMPLAINTCODE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• complaintcodename (type: esriFieldTypeString, alias: COMPLAINTCODENAME, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• unitresponsible (type: esriFieldTypeString, alias: UNITRESPONSIBLE, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ticket_num_311 (type: esriFieldTypeString, alias: TICKET_NUM_311, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• complaintdate (type: esriFieldTypeDate, alias: COMPLAINTDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• complaintstatus (type: esriFieldTypeString, alias: COMPLAINTSTATUS, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• casestatus (type: esriFieldTypeString, alias: CASESTATUS, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• initialinvestigation_date (type: esriFieldTypeDate, alias: INITIALINVESTIGATION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• complaintresolution_date (type: esriFieldTypeDate, alias: COMPLAINTRESOLUTION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• systemofrecord (type: esriFieldTypeString, alias: SYSTEMOFRECORD, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• geocode_x (type: esriFieldTypeDouble, alias: GEOCODE_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• geocode_y (type: esriFieldTypeDouble, alias: GEOCODE_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• council_district (type: esriFieldTypeString, alias: COUNCIL_DISTRICT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• posse_jobid (type: esriFieldTypeString, alias: POSSE_JOBID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• objectid (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)

Templates:

Name: COMPLAINTS
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/21/2025 5:02:14 AM

Schema Last Edit Date: 8/21/2025 5:02:14 AM

Data Last Edit Date: 8/21/2025 5:01:35 AM