Layers:

Layer: CIP (0)

Name: CIP

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: b6b0fc4c786949bfb2f06893a25cc1de

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 2980671.3180658817
YMin: 709804.3196243048
XMax: 3070966.907159388
YMax: 790916.1035946459
Spatial Reference: 102736  (2274)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: GeoType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSFSSolid
Color: [130, 130, 130, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: No
  Label: No
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [130, 130, 130, 0]
  Outline:
  Style: esriSLSSolid
  Color: [91, 102, 112, 255]
  Width: 1
• Value: Yes
  Label: Yes
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [252, 219, 0, 63]
  Outline:
  Style: esriSLSSolid
  Color: [253, 223, 0, 255]
  Width: 1
Transparency: 0
Labeling Info:
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• ProjectID ( type: esriFieldTypeString, alias: Project ID, length: 255 )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, length: 255 )
• Description ( type: esriFieldTypeString, alias: Description, length: 2500 )
• Rationale ( type: esriFieldTypeString, alias: Rationale, length: 2500 )
• ProjectType ( type: esriFieldTypeString, alias: ProjectType, length: 255 )
• Categories ( type: esriFieldTypeString, alias: Categories, length: 1000 )
• FundingSource ( type: esriFieldTypeString, alias: FundingSource, length: 1000 )
• PlannedStartDate ( type: esriFieldTypeDate, alias: Planned Start Date, length: 8 )
• PlannedEndDate ( type: esriFieldTypeDate, alias: Planned End Date, length: 8 )
• ContactName ( type: esriFieldTypeString, alias: ContactName, length: 255 )
• ContactPhone ( type: esriFieldTypeString, alias: ContactPhone, length: 255 )
• ContactEmail ( type: esriFieldTypeString, alias: ContactEmail, length: 255 )
• EstimatedCost ( type: esriFieldTypeDouble, alias: EstimatedCost )
• ProjectStatus ( type: esriFieldTypeString, alias: ProjectStatus, length: 255 , Coded Values: [Project Initiation Project Initiation: Project Initiation] , [Analysis and Review: Analysis and Review] , [Executive Approval: Executive Approval] , ...3 more... )
• ActualStartDate ( type: esriFieldTypeDate, alias: ActualStartDate, length: 8 )
• ActualEndDate ( type: esriFieldTypeDate, alias: ActualEndDate, length: 8 )
• ActualCost ( type: esriFieldTypeDate, alias: ActualCost, length: 8 )
• URL ( type: esriFieldTypeString, alias: URL, length: 1000 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• FundingSourceDetails ( type: esriFieldTypeString, alias: FundingSourceDetails, length: 255 )
• GeoType ( type: esriFieldTypeString, alias: GeoType, length: 255 )
• StrategicPlanFocusArea ( type: esriFieldTypeString, alias: Strategic Plan Focus Area, length: 1000 )
• CapitalOrOperating ( type: esriFieldTypeString, alias: Capital or Operating, length: 255 )
• DeleteProject ( type: esriFieldTypeString, alias: Delete Project, length: 255 )
• Department ( type: esriFieldTypeString, alias: Department, length: 255 )
• CIPVersion ( type: esriFieldTypeString, alias: CIP Version, length: 255 )
• OldGlobalID ( type: esriFieldTypeGUID, alias: OldGlobalID, length: 38 )

Relationships:

• JC.CapitalImprovementsProgram_CostsByYear (3) -- Related To: Costs (2)
• JC.CapitalImprovementsProgram_Updates (2) -- Related To: Updates (3)
• JC.CapitalImprovementsProgram_Locations (1) -- Related To: Locations (1)

Layer: Locations (1)

Name: Locations

Display Field: LocationName

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: b6b0fc4c786949bfb2f06893a25cc1de

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 2980671.3180658817
YMin: 709804.3196243048
XMax: 3070966.907159388
YMax: 790916.1035946459
Spatial Reference: 102736  (2274)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [252, 181, 191, 0]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• ParentGUID ( type: esriFieldTypeGUID, alias: ParentGUID, length: 38 )
• LocationName ( type: esriFieldTypeString, alias: Location Name, length: 255 )
• FiscalYears ( type: esriFieldTypeString, alias: FiscalYears, length: 255 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 2500 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• CIPVersion ( type: esriFieldTypeString, alias: CIPVersion, length: 255 )
• OldParentGUID ( type: esriFieldTypeGUID, alias: OldParentGUID, length: 38 )

Relationships:

• JC.CapitalImprovementsProgram_Locations (1) -- Related To: CIP (0)

Tables:

Table: Costs (2)

Name: Costs

Display Field: FiscalYear

Type: Table

Geometry Type: N/A

Description: The costs table is related to the CapitalImprovementProgram feature class. This table contains a separate data entry for each year/item/project combination.This data should be edited from the Capital Improvement Program Editor.It can be viewed from the Capital Improvement Program dashboard.

Service Item Id: b6b0fc4c786949bfb2f06893a25cc1de

Copyright Text: City of Johnson City, TN Solution created by Ellen Lester (IT GIS) in coordination with Dustin Thompson and Samantha Rivera (Budget)

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: false
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: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ParentGUID ( type: esriFieldTypeGUID, alias: ParentGUID, length: 38 )
• FiscalYear ( type: esriFieldTypeString, alias: FiscalYear, length: 255 )
• PlannedCost ( type: esriFieldTypeDouble, alias: PlannedCost )
• ActualCost ( type: esriFieldTypeDouble, alias: ActualCost )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 2500 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• FundingSource ( type: esriFieldTypeString, alias: FundingSource, length: 255 )
• FundingSourceDetails ( type: esriFieldTypeString, alias: FundingSourceDetails, length: 255 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• CIPVersion ( type: esriFieldTypeString, alias: CIPVersion, length: 255 )
• OldParentGUID ( type: esriFieldTypeGUID, alias: OldParentGUID, length: 38 )

Relationships:

• JC.CapitalImprovementsProgram_CostsByYear (3) -- Related To: CIP (0)

Table: Updates (3)

Name: Updates

Display Field: FiscalYear

Type: Table

Geometry Type: N/A

Description: This table is used to track updates to the CIP projects after they have been approved and are in progress.This data should be edited from the Capital Improvement Program Editor.It can be viewed from the Capital Improvement Program dashboard.

Service Item Id: b6b0fc4c786949bfb2f06893a25cc1de

Copyright Text: City of Johnson City, TN Solution created by Ellen Lester (IT GIS) in coordination with Dustin Thompson and Samantha Rivera (Budget)

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ParentGUID ( type: esriFieldTypeGUID, alias: ParentGUID, length: 38 )
• FiscalYear ( type: esriFieldTypeString, alias: FiscalYear, length: 255 )
• PlannedCost ( type: esriFieldTypeDouble, alias: PlannedCost )
• ActualCost ( type: esriFieldTypeDouble, alias: ActualCost )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 2500 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• CIPVersion ( type: esriFieldTypeString, alias: CIPVersion, length: 255 )
• OldParentGUID ( type: esriFieldTypeGUID, alias: OldParentGUID, length: 38 )

Relationships:

• JC.CapitalImprovementsProgram_Updates (2) -- Related To: CIP (0)

Table: CapitalImprovementsProgram__ATTACH (4)

Name: CapitalImprovementsProgram__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: b6b0fc4c786949bfb2f06893a25cc1de

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: false
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: true
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: null

Fields:
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )

Table: CapitalImprovementsProgram_Updates__ATTACH (5)

Name: CapitalImprovementsProgram_Updates__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: b6b0fc4c786949bfb2f06893a25cc1de

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: false
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: true
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: null

Fields:
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )