Name: CASE_INVESTIGATIONS

Display Field: ADDRESSOBJECTID

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/5543ca785c4ae4cd66d3ff80/representationdetails/5e986970b2c39b001522fb9d/

Copyright Text:

Min. Scale: 2500

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8379896.73381958
YMin: 4846986.27635049
XMax: -8344155.20104701
YMax: 4886753.49919889
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[249,147,0,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)
• parcel_id_num (type: esriFieldTypeString, alias: PARCEL_ID_NUM, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• casenumber (type: esriFieldTypeString, alias: CASENUMBER, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• casetype (type: esriFieldTypeString, alias: CASETYPE, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• caseresponsibility (type: esriFieldTypeString, alias: CASERESPONSIBILITY, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• casepriority (type: esriFieldTypeString, alias: CASEPRIORITY, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• investigationprocessid (type: esriFieldTypeInteger, alias: INVESTIGATIONPROCESSID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• investigationtype (type: esriFieldTypeString, alias: INVESTIGATIONTYPE, SQL Type: sqlTypeOther, length: 1999, nullable: true, editable: true)
• investigationcompleted (type: esriFieldTypeDate, alias: INVESTIGATIONCOMPLETED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• investigationstatus (type: esriFieldTypeString, alias: INVESTIGATIONSTATUS, 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)
• address (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 120, 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: 6, nullable: true, editable: true)
• opa_owner (type: esriFieldTypeString, alias: OPA_OWNER, SQL Type: sqlTypeOther, length: 254, 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: CASE_INVESTIGATIONS
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/23/2025 4:21:46 AM

Schema Last Edit Date: 7/23/2025 4:21:46 AM

Data Last Edit Date: 7/23/2025 4:20:04 AM

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