View In:   ArcGIS Online Map Viewer

Name: CIP Project Outlines

Display Field: PROJNAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 4a0e46113ffe4b7eb8cf8c54499c48cf

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
Supports Returning Geometry Centroid: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• PROJNAME ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJNAME )
• TOTCOST ( type: esriFieldTypeInteger, alias: Total Cost, editable: true, nullable: true, defaultValue: null, modelName: TOTCOST )
• TOTLEN ( type: esriFieldTypeDouble, alias: Total Length, editable: true, nullable: true, defaultValue: null, modelName: TOTLEN )
• TOTAREA ( type: esriFieldTypeDouble, alias: Total Area, editable: true, nullable: true, defaultValue: null, modelName: TOTAREA )
• TOTPNT ( type: esriFieldTypeDouble, alias: Point Count, editable: true, nullable: true, defaultValue: null, modelName: TOTPNT )
• DATESTART ( type: esriFieldTypeDate, alias: Expected Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESTART )
• DATECOMP ( type: esriFieldTypeDate, alias: Date Completed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECOMP )
• CIPSTATUS ( type: esriFieldTypeString, alias: CIP Status, editable: true, nullable: true, length: 50, defaultValue: Proposed, modelName: CIPSTAT , Coded Values: [Proposed: Proposed] , [Completed: Completed] , [Approved: Approved] , ...5 more... )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: NOTES )
• PRJMAN ( type: esriFieldTypeString, alias: Project Manager, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRJMAN , Coded Values: [A LeBlanc: A LeBlanc] , [C Jones: C Jones] , [Public Works: Public Works] , ...5 more... )
• CREATNAME ( type: esriFieldTypeString, alias: Created By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATNAM )
• CREATDATE ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATDAT )
• LINK ( type: esriFieldTypeString, alias: Link to Report, editable: true, nullable: true, length: 175, defaultValue: null, modelName: LINK )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• PROJTYPE ( type: esriFieldTypeString, alias: Project Type, editable: true, nullable: true, length: 80, defaultValue: null, modelName: PROJTYPE , Coded Values: [Streets: Streets] , [Other: Other] , [Water: Water] , ...2 more... )
• FUNDSOURCE ( type: esriFieldTypeString, alias: Funding Source, editable: true, nullable: true, length: 80, defaultValue: null, modelName: FUNDSOUR , Coded Values: [System Revenues: System Revenues] , [Other: Other] , [Water Enterprise Fund: Water Enterprise Fund] , ...5 more... )
• MANPHONE ( type: esriFieldTypeString, alias: Contact Phone, editable: true, nullable: true, length: 80, defaultValue: null, modelName: MANPHONE )
• MANEMAIL ( type: esriFieldTypeString, alias: Contact Email, editable: true, nullable: true, length: 80, defaultValue: null, modelName: MANEMAIL , Coded Values: [aleblanc@cityofnapa.org: aleblanc@cityofnapa.org] , [chrisjones@cityofnapa.org: chrisjones@cityofnapa.org] , [slemmon@cityofnapa.org: slemmon@cityofnapa.org] , ...4 more... )
• CIPID ( type: esriFieldTypeString, alias: CIP ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CIPID )
• CIPFISCALYEAR ( type: esriFieldTypeSmallInteger, alias: CIP FYEAR, editable: true, nullable: true, defaultValue: null, modelName: CIPFISCALYEAR )
• CIP_INTERAGENCYMAP ( type: esriFieldTypeString, alias: CIP INTERAGENCY MAP, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CIP_INTERAGENCYMAP , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• CIP_IMPROVEMENT_TYPE ( type: esriFieldTypeString, alias: CIP IMPROVE TYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CIP_IMPROVEMENT_TYPE , Coded Values: [Abandon: Abandon] , [New: New] , [Reduce: Reduce] , ...3 more... )
• Shape__Area ( type: esriFieldTypeDouble, alias: SHAPE.STArea(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STArea(), required: true )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )
• Plan_Year ( type: esriFieldTypeString, alias: Plan Year, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Plan_Year , 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONSTRUCTION_CREW , Coded Values: [City: City] , [Contractor: Contractor] )
• CIPComponent ( type: esriFieldTypeString, alias: CIPComponent, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CIPPRIORITY )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Description )
• BudgetFund ( type: esriFieldTypeString, alias: Budget Fund, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BudgetFund , Coded Values: [WD: Water Distribution] , [WT: Water Transmission] , [WQ: Water Quality] , ...2 more... )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Diameter )
• PipeMaterial ( type: esriFieldTypeString, alias: Pipe Material, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PipeMaterial )
• CIPMethod ( type: esriFieldTypeString, alias: CIP Method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CIPMethod , Coded Values: [OC: Open Cut] , [HDD: Horizontal Directional Drilling] , [PB: Pipe Burst] , ...5 more... )
• CostLinear ( type: esriFieldTypeInteger, alias: Cost Linear, editable: true, nullable: true, defaultValue: null, modelName: CostLinear )
• CostOther ( type: esriFieldTypeInteger, alias: Cost Other, editable: true, nullable: true, defaultValue: null, modelName: CostOther )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: CIP Project Outlines
  Description:
  Prototype:
  DATECOMP: null
  CostLinear: null
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  DATESTART: null
  CIPSTATUS: Proposed
  NOTES: null
  PRJMAN: null
  CREATNAME: null
  CREATDATE: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: null
  FUNDSOURCE: null
  MANPHONE: null
  MANEMAIL: null
  CIPID: null
  CIPFISCALYEAR: null
  CIP_INTERAGENCYMAP: null
  CIP_IMPROVEMENT_TYPE: null
  CostOther: null
  CIPMethod: null
  Plan_Year: null
  CONSTRUCTION_CREW: null
  CIPComponent: null
  Description: null
  BudgetFund: null
  Diameter: null
  PipeMaterial: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Relationships:

• CIPPoints (0) -- Related To: CIP Point Assets (0)
• CIPProjectsLocations (2) -- Related To: CIP Project Locations (1)
• WaterCIP_Table (5) -- Related To: Water CIP Table (15)
• CIPPolylines (3) -- Related To: CIP Polyline Assets (2)
• CIPPolygons (4) -- Related To: CIP Polygon Assets (9)
• CIPProjectsOverview (6) -- Related To: CIP Project Overviews (11)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata