All Layers and Tables (vw_phl_open_data_program

Layers:

Tables:

phl_open_data_program_indicators (0)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

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:

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: