Name: phl_open_data_program_indicators

Display Field: name

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

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:

• status (type: esriFieldTypeString, alias: status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• name (type: esriFieldTypeString, alias: name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• topic (type: esriFieldTypeString, alias: topic, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• equity_focus (type: esriFieldTypeString, alias: equity_focus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• timestamp (type: esriFieldTypeDate, alias: timestamp, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• release_year (type: esriFieldTypeString, alias: release_year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• department (type: esriFieldTypeString, alias: department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dept_acronym (type: esriFieldTypeString, alias: dept_acronym, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• type (type: esriFieldTypeString, alias: type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• subtype (type: esriFieldTypeString, alias: subtype, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• deprecated (type: esriFieldTypeString, alias: deprecated, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• automated (type: esriFieldTypeString, alias: automated, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• possible_to_automate (type: esriFieldTypeString, alias: possible_to_automate, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• year_automated (type: esriFieldTypeInteger, alias: year_automated, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sunlight_open_data_census (type: esriFieldTypeString, alias: sunlight_open_data_census, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sunlight_countable (type: esriFieldTypeString, alias: sunlight_countable, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sunlight_url (type: esriFieldTypeString, alias: sunlight_url, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• blogpost_url (type: esriFieldTypeString, alias: blogpost_url, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• press_release_url (type: esriFieldTypeString, alias: press_release_url, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• has_viz (type: esriFieldTypeString, alias: has_viz, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• data_viz_url (type: esriFieldTypeString, alias: data_viz_url, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• viz_display (type: esriFieldTypeString, alias: viz_display, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• exclude_from_stats (type: esriFieldTypeString, alias: exclude_from_stats, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• metadata_url (type: esriFieldTypeString, alias: metadata_url, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• finder_app (type: esriFieldTypeString, alias: finder_app, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• eodp_url (type: esriFieldTypeString, alias: eodp_url, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• division (type: esriFieldTypeString, alias: division, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• name_year (type: esriFieldTypeString, alias: name_year, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• original_release_date (type: esriFieldTypeDate, alias: original_release_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• finder_display (type: esriFieldTypeString, alias: finder_display, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• data_last_updated (type: esriFieldTypeDate, alias: data_last_updated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• objectid (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• fiscal_year (type: esriFieldTypeInteger, alias: fiscal_year, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: phl_open_data_program_indicators
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/31/2026 12:03:26 AM

Schema Last Edit Date: 1/31/2026 12:03:26 AM

Data Last Edit Date: 1/31/2026 12:03:26 AM

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