Name: Data View JCOS Property

Display Field: PARK_NAME

Type: Table

Geometry Type: N/A

Description: Description: This is a stand alone table used to join and relate to the Land Boundary Detailed and Land Boundaries Data Flow Process Deliverables. The purpose of this table is to reduce redundency of data within the Land Boundaries feature classes (both detailed and data deliverables). This table is used to generate the Property_Association Domain with the Jeffco Parks and Open Space Production SDE. Data Type: TableSensitive: NoUpdate Frequency: As needed basis. This is based on updates to the Land Boundary data, the Land Use Classification data, and asset data.Source of Origination: Jefferson County Parks and Open SpaceCreation Process: This table was generated by the Jeffco Parks and Open Space GIS team by evaluating the link between Land Boundary Parcels and larger Jeffco Parks and Open Space parks and propertiesOriginal Projection: n/aUpdate Frequency: This data is sync with the AGOL data. When edits are to this the data in this location, an update occurs the following night to the AGOL data.Root Data: NoAdditional Notes: This domain update/overwrite process is handled by the Python Script, "PropertyAssociationDomainUpdate.py", which is run by the scripting machine through the task scheduler. In order to run this Python Script an exclusive lock on the SDE is needed.Business Rules:1) 3 letter codes of parks are added as records to this table. If a new park is added to the system, this table is where the Property Association Code/Description is added.2) Property Codes are added to maintain unique names of the land boundaries outside of the Jeffco Parks and Open Space parks.3)Records are added to this table on an as needed basis based on the connection between Land Boundaries data and Land Use Classification data.4)Records are added to this table on an as needed basis based on the connection between Land Boundaries data and Asset data.

Service Item Id: ed2e5b16ebfa4270b79b7b239fc9fd4d

Copyright Text: Jefferson County Parks and Open Space

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• PROPERTY_ASSOCIATION_PK ( type: esriFieldTypeInteger, alias: PROPERTY_ASSOCIATION_PK, editable: true, nullable: true, defaultValue: null, modelName: PROPERTY_ASSOCIATION_PK )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DESCRIPTION )
• PARK_NAME ( type: esriFieldTypeString, alias: PARK_NAME, editable: true, nullable: true, length: 150, defaultValue: null, modelName: PARK_NAME )
• WEBSITE_URL ( type: esriFieldTypeString, alias: WEBSITE_URL, editable: true, nullable: true, length: 500, defaultValue: null, modelName: WEBSITE_URL )
• WEBSITE_PHOTO_URL ( type: esriFieldTypeString, alias: WEBSITE_PHOTO_URL, editable: true, nullable: true, length: 500, defaultValue: null, modelName: WEBSITE_PHOTO_URL )
• PDF_MAP_URL ( type: esriFieldTypeString, alias: PDF_MAP_URL, editable: true, nullable: true, length: 500, defaultValue: null, modelName: PDF_MAP_URL )
• ACTIVITIES ( type: esriFieldTypeString, alias: ACTIVITIES, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ACTIVITIES )
• PARK_SPECTRUM ( type: esriFieldTypeString, alias: PARK_SPECTRUM, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PARK_SPECTRUM )
• SHAREPOINT_URL ( type: esriFieldTypeString, alias: SHAREPOINT_URL, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: SHAREPOINT_URL )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Data View JCOS Property
  Description:
  Prototype:
  SHAREPOINT_URL: null
  PROPERTY_ASSOCIATION_PK: null
  DESCRIPTION: null
  PARK_NAME: null
  WEBSITE_URL: null
  WEBSITE_PHOTO_URL: null
  PDF_MAP_URL: null
  ACTIVITIES: null
  PARK_SPECTRUM: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata