View In:   ArcGIS Online Map Viewer

Name: CIP Five Year Projected Polygons

Display Field: CIPDepartment

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: 521029.08257322013
YMin: 193180.14506031573
XMax: 561926.8761055619
YMax: 243350.01880171895
Spatial Reference: PROJCS["Dakota - county coordinates - english",GEOGCS["Dakota - county coordinates - english",DATUM["",SPHEROID["",6378421.989,298.2572133677354]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",499999.999998],PARAMETER["False_Northing",99999.9999996],PARAMETER["Central_Meridian",-93.31666666666666],PARAMETER["Standard_Parallel_1",44.51666666666667],PARAMETER["Standard_Parallel_2",44.91666666666666],PARAMETER["Latitude_Of_Origin",44.47194444444445],UNIT["Foot_US",0.3048006096012192]]

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [200, 222, 250, 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: 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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CIP_Year ( type: esriFieldTypeString, alias: CIP_Year, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CIP_Year )
• DATESTART ( type: esriFieldTypeDate, alias: DATESTART, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESTART )
• DATECOMP ( type: esriFieldTypeDate, alias: DATECOMP, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECOMP )
• CIP_Maint ( type: esriFieldTypeString, alias: CIP_Maint, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CIP_Maint , Coded Values: [General Maintenance: General Maintenance] , [Sealcoat: Sealcoat] , [New: New] , ...15 more... )
• CIP_FClass ( type: esriFieldTypeString, alias: CIP_FClass, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CIP_FClass , Coded Values: [Collector: Collector] , [Local: Local] )
• CIP_YearGroup ( type: esriFieldTypeString, alias: CIP_YearGroup, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CIP_YearGroup , Coded Values: [Future: Future] , [2012-2016: 2012-2016] , [2013-2017: 2013-2017] , ...13 more... )
• ImprovementType ( type: esriFieldTypeString, alias: ImprovementType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ImprovementType , Coded Values: [Street: Street] , [Trail: Trail] , [Sanitary FO: Sanitary FO] , ...15 more... )
• CIPDepartment ( type: esriFieldTypeString, alias: CIPDepartment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CIPDepartment , Coded Values: [Streets: Streets] , [Water Quality: Water Quality] , [Parks: Parks] , ...2 more... )
• 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 )
• 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 )
• ContractNumber ( type: esriFieldTypeString, alias: ContractNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ContractNumber )
• CIPSTAT ( type: esriFieldTypeString, alias: CIPSTAT, editable: true, nullable: true, length: 50, defaultValue: Proposed, modelName: CIPSTAT , Coded Values: [Proposed: Proposed] , [Completed: Completed] , [Approved: Approved] , ...7 more... )
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNumber )
• PROJNAME ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: PROJNAME )
• TOTCOST ( type: esriFieldTypeDouble, 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 )
• PRJMAN ( type: esriFieldTypeString, alias: Project Manager, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRJMAN )
• CREATNAM ( type: esriFieldTypeString, alias: Created By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATNAM )
• CREATDAT ( 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 )
• FUNDSOUR ( type: esriFieldTypeString, alias: Funding Source, editable: true, nullable: true, length: 80, defaultValue: null, modelName: FUNDSOUR )
• 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 )
• Priority ( type: esriFieldTypeInteger, alias: Priority, editable: true, nullable: true, defaultValue: null, modelName: Priority )
• HyperlinkToContract ( type: esriFieldTypeString, alias: HyperlinkToContract, editable: true, nullable: true, length: 256, defaultValue: null, modelName: HyperlinkToContract )
• HyperlinkToProject ( type: esriFieldTypeString, alias: HyperlinkToProject, editable: true, nullable: true, length: 256, defaultValue: null, modelName: HyperlinkToProject )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATION )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: NOTES )
• PlanItID ( type: esriFieldTypeString, alias: PlanItID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PlanItID )
• VideoLink ( type: esriFieldTypeString, alias: VideoLink, editable: true, nullable: true, length: 200, defaultValue: null, modelName: VideoLink )
• WebsiteProjectSpecificLink ( type: esriFieldTypeString, alias: WebsiteProjectSpecificLink, editable: true, nullable: true, length: 200, defaultValue: null, modelName: WebsiteProjectSpecificLink )
• WebsiteProjectGenericLink ( type: esriFieldTypeString, alias: WebsiteProjectGenericLink, editable: true, nullable: true, length: 200, defaultValue: null, modelName: WebsiteProjectGenericLink )
• ProjectContact ( type: esriFieldTypeString, alias: ProjectContact, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectContact )
• ProjectDetails ( type: esriFieldTypeString, alias: ProjectDetails, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ProjectDetails )
• ProjectJustification ( type: esriFieldTypeString, alias: ProjectJustification, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ProjectJustification )

Templates:

• Name: 2014
  Description:
  Prototype:
  CIP_Maint:
  ProjectDetails: null
  DATECOMP: null
  CIP_Year: 2014
  DATESTART: null
  CIP_FClass:
  CIP_YearGroup: null
  ImprovementType: null
  CIPDepartment: null
  WebsiteProjectSpecificLink: null
  VideoLink: null
  PlanItID: null
  NOTES: null
  ProjectContact: null
  WebsiteProjectGenericLink: null
  ContractNumber: null
  CIPSTAT: Proposed
  ProjectNumber: null
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  PRJMAN: null
  CREATNAM: null
  CREATDAT: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: null
  FUNDSOUR: null
  MANPHONE: null
  MANEMAIL: null
  Priority: null
  HyperlinkToContract: null
  HyperlinkToProject: null
  LOCATION: null
  ProjectJustification: null
  
  Drawing Tool: esriFeatureEditToolPolygon
• Name: 2015
  Description:
  Prototype:
  CIP_Maint:
  ProjectDetails: null
  DATECOMP: null
  CIP_Year: 2015
  DATESTART: null
  CIP_FClass:
  CIP_YearGroup: null
  ImprovementType: null
  CIPDepartment: null
  WebsiteProjectSpecificLink: null
  VideoLink: null
  PlanItID: null
  NOTES: null
  ProjectContact: null
  WebsiteProjectGenericLink: null
  ContractNumber: null
  CIPSTAT: Proposed
  ProjectNumber: null
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  PRJMAN: null
  CREATNAM: null
  CREATDAT: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: null
  FUNDSOUR: null
  MANPHONE: null
  MANEMAIL: null
  Priority: null
  HyperlinkToContract: null
  HyperlinkToProject: null
  LOCATION: null
  ProjectJustification: null
  
  Drawing Tool: esriFeatureEditToolPolygon
• Name: 2016
  Description:
  Prototype:
  CIP_Maint:
  ProjectDetails: null
  DATECOMP: null
  CIP_Year: 2016
  DATESTART: null
  CIP_FClass:
  CIP_YearGroup: null
  ImprovementType: null
  CIPDepartment: null
  WebsiteProjectSpecificLink: null
  VideoLink: null
  PlanItID: null
  NOTES: null
  ProjectContact: null
  WebsiteProjectGenericLink: null
  ContractNumber: null
  CIPSTAT: Proposed
  ProjectNumber: null
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  PRJMAN: null
  CREATNAM: null
  CREATDAT: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: null
  FUNDSOUR: null
  MANPHONE: null
  MANEMAIL: null
  Priority: null
  HyperlinkToContract: null
  HyperlinkToProject: null
  LOCATION: null
  ProjectJustification: null
  
  Drawing Tool: esriFeatureEditToolPolygon
• Name: 2017
  Description:
  Prototype:
  CIP_Maint:
  ProjectDetails: null
  DATECOMP: null
  CIP_Year: 2017
  DATESTART: null
  CIP_FClass:
  CIP_YearGroup: null
  ImprovementType: null
  CIPDepartment: null
  WebsiteProjectSpecificLink: null
  VideoLink: null
  PlanItID: null
  NOTES: null
  ProjectContact: null
  WebsiteProjectGenericLink: null
  ContractNumber: null
  CIPSTAT: Proposed
  ProjectNumber: null
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  PRJMAN: null
  CREATNAM: null
  CREATDAT: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: null
  FUNDSOUR: null
  MANPHONE: null
  MANEMAIL: null
  Priority: null
  HyperlinkToContract: null
  HyperlinkToProject: null
  LOCATION: null
  ProjectJustification: null
  
  Drawing Tool: esriFeatureEditToolPolygon
• Name: 2018
  Description:
  Prototype:
  CIP_Maint:
  ProjectDetails: null
  DATECOMP: null
  CIP_Year: 2018
  DATESTART: null
  CIP_FClass:
  CIP_YearGroup: null
  ImprovementType: null
  CIPDepartment: null
  WebsiteProjectSpecificLink: null
  VideoLink: null
  PlanItID: null
  NOTES: null
  ProjectContact: null
  WebsiteProjectGenericLink: null
  ContractNumber: null
  CIPSTAT: Proposed
  ProjectNumber: null
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  PRJMAN: null
  CREATNAM: null
  CREATDAT: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: null
  FUNDSOUR: null
  MANPHONE: null
  MANEMAIL: null
  Priority: null
  HyperlinkToContract: null
  HyperlinkToProject: null
  LOCATION: null
  ProjectJustification: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Relationships:

• CIPFiveYearPlanITData (5) -- Related To: Funds (23)
• CIPFiveYearPlanITTotalCost (6) -- Related To: CIPFiveYearPlanITTotalCost (24)

Capabilities: Query

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   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata