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:

• objectid (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• status (type: esriFieldTypeString, alias: status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Research feasibility: Research feasibility], [Completed: Completed], [Backlogged: Backlogged], ... 1 more ...)
• 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, Coded Values: [Transportation and Infrastructure: Transportation and Infrastructure], [Public Health and Human Services: Public Health and Human Services], [Public Safety: Public Safety], ... 9 more ...)
• equity_focus (type: esriFieldTypeString, alias: equity_focus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Y: Y], [N: N])
• timestamp (type: esriFieldTypeDate, alias: timestamp, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• release_date (type: esriFieldTypeString, alias: release_date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• release_month (type: esriFieldTypeString, alias: release_month, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [3: March], [4: April], [5: May], ... 9 more ...)
• release_year (type: esriFieldTypeString, alias: release_year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• in_odp (type: esriFieldTypeString, alias: in_odp, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Y], [N: N])
• department (type: esriFieldTypeString, alias: department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Board of Ethics: Board of Ethics], [Board of Pensions and Retirement: Board of Pensions and Retirement], [Budget Director: Budget Director], ... 44 more ...)
• dept_acronym (type: esriFieldTypeString, alias: dept_acronym, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [BOE: BOE], [Pension: Pension], [Budget: Budget], ... 45 more ...)
• type (type: esriFieldTypeString, alias: type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Future refresh: Future refresh], [Future new release: Future new release], [Refresh: Refresh], ... 2 more ...)
• subtype (type: esriFieldTypeString, alias: subtype, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Application: Application], [Enhanced Version: Enhanced Version], [New Dataset: New Dataset], ... 3 more ...)
• difficulty_level (type: esriFieldTypeString, alias: difficulty_level, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [1: Heavy lift], [2: Medium lift], [3: Easy lift (i.e. simple refresh)], ... 1 more ...)
• refresh_priority_level (type: esriFieldTypeString, alias: refresh_priority_level, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [1: high priority for refresh], [2: medium priority for refresh], [3: low priority for refresh], ... 1 more ...)
• deprecated (type: esriFieldTypeString, alias: deprecated, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Y: Y], [N: N])
• reason_deprecated (type: esriFieldTypeString, alias: reason_deprecated, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• description (type: esriFieldTypeString, alias: description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• automated (type: esriFieldTypeString, alias: automated, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Automated: Automated], [Not automated: Not automated], [Not able to automate: Not able to automate], ... 1 more ...)
• possible_to_automate (type: esriFieldTypeString, alias: possible_to_automate, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Investigate: Investigate], [N: N], [N - Annual updates: N - Annual updates], ... 2 more ...)
• year_automated (type: esriFieldTypeInteger, alias: year_automated, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1990 - 2050])
• source_update_frequency (type: esriFieldTypeString, alias: source_update_frequency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Manual: As Needed], [Hourly: Hourly], [Daily: Daily], ... 4 more ...)
• update_frequency_notes (type: esriFieldTypeString, alias: update_frequency_notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sunlight_open_data_census (type: esriFieldTypeString, alias: sunlight_open_data_census, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Y: Y], [N: N])
• sunlight_countable (type: esriFieldTypeString, alias: sunlight_countable, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Y: Yes, is a Sunlight high value dataset we've released], [N: No, we haven't released])
• 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, Coded Values: [Y: Y], [N: N])
• 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, Coded Values: [Visualization: Visualization])
• odp_url (type: esriFieldTypeString, alias: odp_url, 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, Coded Values: [Y: Y], [N: N])

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: 4/17/2025 11:33:34 AM

Schema Last Edit Date: 4/17/2025 11:33:34 AM

Data Last Edit Date: 4/17/2025 11:33:34 AM

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