Layers:

Layer: CIP Project Locations (1)

Name: CIP Project Locations

Display Field: PROJNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This is a point feature that represents the location of CIP projects and is used in multi-scale maps.

Service Item Id: 7bfe6ff4978a409bafcbc7c5a2e65962

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 150000

Max Scale: 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: -214588.95977716148
YMin: -214715.70504674315
XMax: 6496793.750304587
YMax: 1938909.2022617608
Spatial Reference: 102642  (2226)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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 )
• PROJNAME ( type: esriFieldTypeString, alias: Project Name, length: 50 )
• TOTCOST ( type: esriFieldTypeDouble, alias: Total Cost )
• TOTLEN ( type: esriFieldTypeDouble, alias: Total Length )
• TOTAREA ( type: esriFieldTypeDouble, alias: Total Area )
• TOTPNT ( type: esriFieldTypeDouble, alias: Point Count )
• DATESTART ( type: esriFieldTypeDate, alias: Expected Start Date, length: 8 )
• DATECOMP ( type: esriFieldTypeDate, alias: Date Completed, length: 8 )
• CIPSTAT ( type: esriFieldTypeString, alias: CIP Status, length: 50 , Coded Values: [Proposed: Proposed] , [Completed: Completed] , [Approved: Approved] , ...5 more... )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 200 )
• PRJMAN ( type: esriFieldTypeString, alias: Project Manager, length: 50 , Coded Values: [A LeBlanc: A LeBlanc] , [C Jones: C Jones] , [Public Works: Public Works] , ...5 more... )
• CREATNAME ( type: esriFieldTypeString, alias: Created By, length: 50 )
• CREATDATE ( type: esriFieldTypeDate, alias: Date Created, length: 8 )
• LINK ( type: esriFieldTypeString, alias: Link to Report, length: 175 )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update, length: 8 )
• PROJTYPE ( type: esriFieldTypeString, alias: Project Type, length: 80 , Coded Values: [Streets: Streets] , [Other: Other] , [Water: Water] , ...2 more... )
• MANPHONE ( type: esriFieldTypeString, alias: Contact Phone, length: 80 )
• MANEMAIL ( type: esriFieldTypeString, alias: Contact Email, length: 80 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• CIPID ( type: esriFieldTypeString, alias: CIP ID, length: 20 )
• CIP_INTERAGENCYMAP ( type: esriFieldTypeString, alias: CIP INTERAGENCY MAP, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• CIPFISCALYEAR ( type: esriFieldTypeInteger, alias: CIPFISCALYEAR )
• FUNDSOURCE ( type: esriFieldTypeString, alias: Funding Source, length: 80 , Coded Values: [System Revenues: System Revenues] , [Other: Other] , [Water Enterprise Fund: Water Enterprise Fund] , ...5 more... )
• CIP_IMPROVEMENTTYPE ( type: esriFieldTypeString, alias: CIP Improvement Type, length: 30 )
• CONSTRUCTION_CREW ( type: esriFieldTypeString, alias: CONSTRUCTION CREW, length: 50 , Coded Values: [City: City] , [Contractor: Contractor] )
• CIPComponent ( type: esriFieldTypeString, alias: CIP COMPONENT, length: 20 )
• 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 )

Relationships:

• CIPProjects (0) -- Related To: CIP Project Outlines (10)

Layer: CIP Project Outlines (10)

Name: CIP Project Outlines

Display Field: PROJNAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 7bfe6ff4978a409bafcbc7c5a2e65962

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 150000

Max Scale: 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: -214758.36495016143
YMin: -214758.3647383228
XMax: 6732138.306517422
YMax: 1941265.3855415136
Spatial Reference: 102642  (2226)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [255, 190, 190, 255]
Outline:
Style: esriSLSSolid
Color: [255, 0, 0, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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 )
• PROJNAME ( type: esriFieldTypeString, alias: Project Name, length: 50 )
• TOTCOST ( type: esriFieldTypeInteger, alias: Total Cost )
• TOTLEN ( type: esriFieldTypeDouble, alias: Total Length )
• TOTAREA ( type: esriFieldTypeDouble, alias: Total Area )
• TOTPNT ( type: esriFieldTypeDouble, alias: Point Count )
• DATESTART ( type: esriFieldTypeDate, alias: Expected Start Date, length: 8 )
• DATECOMP ( type: esriFieldTypeDate, alias: Date Completed, length: 8 )
• CIPSTATUS ( type: esriFieldTypeString, alias: CIP Status, length: 50 , Coded Values: [Proposed: Proposed] , [Completed: Completed] , [Approved: Approved] , ...5 more... )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 200 )
• PRJMAN ( type: esriFieldTypeString, alias: Project Manager, length: 50 , Coded Values: [A LeBlanc: A LeBlanc] , [C Jones: C Jones] , [Public Works: Public Works] , ...5 more... )
• CREATNAME ( type: esriFieldTypeString, alias: Created By, length: 50 )
• CREATDATE ( type: esriFieldTypeDate, alias: Date Created, length: 8 )
• LINK ( type: esriFieldTypeString, alias: Link to Report, length: 175 )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update, length: 8 )
• PROJTYPE ( type: esriFieldTypeString, alias: Project Type, length: 80 , Coded Values: [Streets: Streets] , [Other: Other] , [Water: Water] , ...2 more... )
• FUNDSOURCE ( type: esriFieldTypeString, alias: Funding Source, length: 80 , Coded Values: [System Revenues: System Revenues] , [Other: Other] , [Water Enterprise Fund: Water Enterprise Fund] , ...5 more... )
• MANPHONE ( type: esriFieldTypeString, alias: Contact Phone, length: 80 )
• MANEMAIL ( type: esriFieldTypeString, alias: Contact Email, length: 80 , Coded Values: [aleblanc@cityofnapa.org: aleblanc@cityofnapa.org] , [chrisjones@cityofnapa.org: chrisjones@cityofnapa.org] , [slemmon@cityofnapa.org: slemmon@cityofnapa.org] , ...4 more... )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• CIPID ( type: esriFieldTypeString, alias: CIP ID, length: 20 )
• CIPFISCALYEAR ( type: esriFieldTypeSmallInteger, alias: CIP FYEAR )
• CIP_INTERAGENCYMAP ( type: esriFieldTypeString, alias: CIP INTERAGENCY MAP, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• CIP_IMPROVEMENT_TYPE ( type: esriFieldTypeString, alias: CIP IMPROVE TYPE, length: 30 , Coded Values: [Abandon: Abandon] , [New: New] , [Reduce: Reduce] , ...3 more... )
• SHAPE.STArea() ( type: esriFieldTypeDouble, alias: SHAPE.STArea() )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• Plan_Year ( type: esriFieldTypeString, alias: Plan Year, length: 50 , Coded Values: [FY 12-13: FY 12-13] , [FY 13-14: FY 13-14] , [FY 14-15: FY 14-15] , ...25 more... )
• CONSTRUCTION_CREW ( type: esriFieldTypeString, alias: CONSTRUCTION_CREW, length: 50 , Coded Values: [City: City] , [Contractor: Contractor] )
• CIPComponent ( type: esriFieldTypeString, alias: CIPComponent, length: 20 )
• Description ( type: esriFieldTypeString, alias: Description, length: 1000 )
• BudgetFund ( type: esriFieldTypeString, alias: Budget Fund, length: 50 , Coded Values: [WD: Water Distribution] , [WT: Water Transmission] , [WQ: Water Quality] , ...2 more... )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter )
• PipeMaterial ( type: esriFieldTypeString, alias: Pipe Material, length: 32 )
• CIPMethod ( type: esriFieldTypeString, alias: CIP Method, length: 50 , Coded Values: [OC: Open Cut] , [HDD: Horizontal Directional Drilling] , [PB: Pipe Burst] , ...5 more... )
• CostLinear ( type: esriFieldTypeInteger, alias: Cost Linear )
• CostOther ( type: esriFieldTypeInteger, alias: Cost Other )
• 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 )

Relationships:

• CIPProjectsLocations (0) -- Related To: CIP Project Locations (1)
• CIPProjectsOverview (1) -- Related To: CIP Project Overviews (11)

Layer: CIP Project Overviews (11)

Name: CIP Project Overviews

Display Field: PROJNAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: A polygon that represents an overview of the CIP project.

Service Item Id: 7bfe6ff4978a409bafcbc7c5a2e65962

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 150000

Max Scale: 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: -214818.36483016238
YMin: -214818.36461832374
XMax: 6732198.306069337
YMax: 1903287.6675338447
Spatial Reference: 102642  (2226)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [215, 192, 252, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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 )
• PROJNAME ( type: esriFieldTypeString, alias: Project Name, length: 50 )
• TOTCOST ( type: esriFieldTypeDouble, alias: Total Cost )
• TOTLEN ( type: esriFieldTypeDouble, alias: Total Length )
• TOTAREA ( type: esriFieldTypeDouble, alias: Total Area )
• TOTPNT ( type: esriFieldTypeDouble, alias: Point Count )
• DATESTART ( type: esriFieldTypeDate, alias: Expected Start Date, length: 8 )
• DATECOMP ( type: esriFieldTypeDate, alias: Date Completed, length: 8 )
• CIPSTATUS ( type: esriFieldTypeString, alias: CIP Status, length: 50 , Coded Values: [Proposed: Proposed] , [Completed: Completed] , [Approved: Approved] , ...5 more... )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 200 )
• PRJMAN ( type: esriFieldTypeString, alias: Project Manager, length: 50 , Coded Values: [A LeBlanc: A LeBlanc] , [C Jones: C Jones] , [Public Works: Public Works] , ...5 more... )
• CREATNAME ( type: esriFieldTypeString, alias: Created By, length: 50 )
• CREATDATE ( type: esriFieldTypeDate, alias: Date Created, length: 8 )
• LINK ( type: esriFieldTypeString, alias: Link to Report, length: 175 )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update, length: 8 )
• PROJTYPE ( type: esriFieldTypeString, alias: Project Type, length: 80 , Coded Values: [Streets: Streets] , [Other: Other] , [Water: Water] , ...2 more... )
• FUNDSOUR ( type: esriFieldTypeString, alias: Funding Source, length: 80 , Coded Values: [System Revenues: System Revenues] , [Other: Other] , [Water Enterprise Fund: Water Enterprise Fund] , ...5 more... )
• MANPHONE ( type: esriFieldTypeString, alias: Contact Phone, length: 80 )
• MANEMAIL ( type: esriFieldTypeString, alias: Contact Email, length: 80 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• CIPID ( type: esriFieldTypeString, alias: CIP ID, length: 20 )
• CIPPRIORITY ( type: esriFieldTypeString, alias: CIPPRIORITY, length: 20 )
• CIP_INTERAGENCYMAP ( type: esriFieldTypeString, alias: CICIP INTERAGENCY MAP, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• CIPFISCALYEAR ( type: esriFieldTypeInteger, alias: CIPFISCALYEAR )
• SHAPE.STArea() ( type: esriFieldTypeDouble, alias: SHAPE.STArea() )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• PLAN_YEAR ( type: esriFieldTypeString, alias: PLAN_YEAR, length: 50 )
• CONSTRUCTION_CREW ( type: esriFieldTypeString, alias: CONSTRUCTION CREW, length: 50 , Coded Values: [City: City] , [Contractor: Contractor] )
• 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 )

Relationships:

• CIPProjects (1) -- Related To: CIP Project Outlines (10)