View In:   ArcGIS Online Map Viewer

Name: Capital Improvement Districts

Display Field: Contractor

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: This is a polygon feature class for tracking capital im[rovement projects for the City of Fargo, North Dakota. This file is maintained by the Engineering Department. The file will show current and retired projects.

Copyright Text: City of Fargo, ND

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 750000.0

Max Scale: 0.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: -1.0789194338596396E7
YMin: 5888864.911844337
XMax: -1.0770126428700043E7
YMax: 5938722.580565652
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [255, 235, 175, 255]
Outline:
Style: esriSLSSolid
Color: [168, 112, 0, 255]
Width: 2
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: OBJECTID )
• BidDate ( type: esriFieldTypeDate, alias: BidDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BidDate )
• Contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Contractor )
• CompletionDate ( type: esriFieldTypeDate, alias: CompletionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CompletionDate )
• ProjectManager ( type: esriFieldTypeString, alias: ProjectManager, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectManager )
• ConstructionCost ( type: esriFieldTypeDouble, alias: ConstructionCost, editable: true, nullable: true, defaultValue: null, modelName: ConstructionCost )
• WorkType ( type: esriFieldTypeString, alias: WorkType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkType )
• ContractorContactInformation ( type: esriFieldTypeString, alias: ContractorContactInformation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ContractorContactInformation )
• ProjectStatus ( type: esriFieldTypeString, alias: ProjectStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectStatus )
• ImprovementDistrictNum ( type: esriFieldTypeString, alias: ImprovementDistrictNum, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ImprovementDistrictNum )
• CIPYEAR ( type: esriFieldTypeString, alias: CIPYEAR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CIPYEAR )
• 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 )
• CitywideProject ( type: esriFieldTypeString, alias: Citywide Project, editable: true, nullable: true, length: 10, defaultValue: No, modelName: CitywideProject , Coded Values: [Yes: Yes] , [No: No] )
• CIPMapWorkType ( type: esriFieldTypeString, alias: CIP Map Work Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CIPMapWorkType )
• CIPMapYear ( type: esriFieldTypeString, alias: CIP Map Year, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CIPMapYear )
• CIPMapPMIntials ( type: esriFieldTypeString, alias: CIP Map PM Intials, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CIPMapPMIntials )
• ProjNum ( type: esriFieldTypeString, alias: ProjNum, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjNum )
• ProFormaNumber ( type: esriFieldTypeString, alias: ProFormaNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProFormaNumber )
• SAProjectStatus ( type: esriFieldTypeString, alias: SAProjectStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SAProjectStatus , Coded Values: [Engineers Estimate: Engineers Estimate] , [Bid Tab: Bid Tab] , [Final Pay Estimate: Final Pay Estimate] , ...1 more... )
• SAUpdateAfterBidTab ( type: esriFieldTypeString, alias: SAUpdateAfterBidTab, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SAUpdateAfterBidTab , Coded Values: [Yes: Yes] , [No: No] )
• ChangeOrder ( type: esriFieldTypeString, alias: ChangeOrder, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ChangeOrder , Coded Values: [Yes: Yes] , [No: No] )
• Defferrals ( type: esriFieldTypeString, alias: Defferrals, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Defferrals , Coded Values: [Yes: Yes] , [No: No] )
• SubstantiallyComplete ( type: esriFieldTypeDate, alias: SubstantiallyComplete, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SubstantiallyComplete )
• FinalPayEstimateDate ( type: esriFieldTypeDate, alias: FinalPayEstimateDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FinalPayEstimateDate )
• CertifiedDate ( type: esriFieldTypeDate, alias: CertifiedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CertifiedDate )
• AssessedDate ( type: esriFieldTypeDate, alias: AssessedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AssessedDate )
• SARun ( type: esriFieldTypeString, alias: SARun, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SARun )
• SAComments ( type: esriFieldTypeString, alias: SAComments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SAComments )
• SpecialAssessed ( type: esriFieldTypeString, alias: SpecialAssessed, editable: true, nullable: true, length: 10, defaultValue: Yes, modelName: SpecialAssessed , Coded Values: [Yes: Yes] , [No: No] )
• ProjectCategory ( type: esriFieldTypeString, alias: ProjectCategory, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectCategory )
• SpecialAssessedAmount ( type: esriFieldTypeDouble, alias: SpecialAssessedAmount, editable: true, nullable: true, defaultValue: null, modelName: SpecialAssessedAmount )
• Link1 ( type: esriFieldTypeString, alias: Link1, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Link1 )
• Link2 ( type: esriFieldTypeString, alias: Link2, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Link2 )
• 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 )
• ProjectPurpose ( type: esriFieldTypeString, alias: ProjectPurpose, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: ProjectPurpose )
• EstimateStart ( type: esriFieldTypeDate, alias: EstimateStart, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EstimateStart )
• EstimateEnd ( type: esriFieldTypeDate, alias: EstimateEnd, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EstimateEnd )
• PACETotalProjectCost ( type: esriFieldTypeDouble, alias: PACE Total Project Cost, editable: true, nullable: true, defaultValue: null, modelName: PACETotalProjectCost )
• PACESpecialAssessedCost ( type: esriFieldTypeDouble, alias: PACE Special Assessed Cost, editable: true, nullable: true, defaultValue: null, modelName: PACESpecialAssessedCost )
• PercentCompleted ( type: esriFieldTypeDouble, alias: Percent Completed, editable: true, nullable: true, defaultValue: null, modelName: PercentCompleted )
• CallforBidDate ( type: esriFieldTypeDate, alias: Call for Bid Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CallforBidDate )
• AdvertisingDate1 ( type: esriFieldTypeDate, alias: Advertising Date 1, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AdvertisingDate1 )
• AdvertisingDate2 ( type: esriFieldTypeDate, alias: Advertising Date 2, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AdvertisingDate2 )
• AdvertisingDate3 ( type: esriFieldTypeDate, alias: Advertising Date 3, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AdvertisingDate3 )
• ProtestNumProperties ( type: esriFieldTypeDouble, alias: Protest Number Properties, editable: true, nullable: true, defaultValue: null, modelName: ProtestNumProperties )
• ProtestPercent ( type: esriFieldTypeDouble, alias: Protest Percent , editable: true, nullable: true, defaultValue: null, modelName: ProtestPercent )
• Contractor1 ( type: esriFieldTypeString, alias: Contractor , editable: true, nullable: true, length: 255, defaultValue: null, modelName: Contractor1 )
• Bid1 ( type: esriFieldTypeDouble, alias: Bid, editable: true, nullable: true, defaultValue: null, modelName: Bid1 )
• Status1 ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status1 )
• Contractor2 ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Contractor2 )
• Bid2 ( type: esriFieldTypeDouble, alias: Bid, editable: true, nullable: true, defaultValue: null, modelName: Bid2 )
• Status2 ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status2 )
• Contractor3 ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Contractor3 )
• Bid3 ( type: esriFieldTypeDouble, alias: Bid, editable: true, nullable: true, defaultValue: null, modelName: Bid3 )
• Status3 ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status3 )
• Contractor4 ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Contractor4 )
• Bid4 ( type: esriFieldTypeDouble, alias: Bid, editable: true, nullable: true, defaultValue: null, modelName: Bid4 )
• Status4 ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status4 )
• Contractor5 ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Contractor5 )
• Bid5 ( type: esriFieldTypeDouble, alias: Bid, editable: true, nullable: true, defaultValue: null, modelName: Bid5 )
• Status5 ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status5 )
• Contractor6 ( type: esriFieldTypeString, alias: Contractor , editable: true, nullable: true, length: 255, defaultValue: null, modelName: Contractor6 )
• Bid6 ( type: esriFieldTypeDouble, alias: Bid, editable: true, nullable: true, defaultValue: null, modelName: Bid6 )
• Status6 ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status6 )
• Contractor7 ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Contractor7 )
• Bid7 ( type: esriFieldTypeDouble, alias: Bid, editable: true, nullable: true, defaultValue: null, modelName: Bid7 )
• Status7 ( type: esriFieldTypeString, alias: Status , editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status7 )
• Contractor8 ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Contractor8 )
• Bid8 ( type: esriFieldTypeDouble, alias: Bid, editable: true, nullable: true, defaultValue: null, modelName: Bid8 )
• Status8 ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Status8 )
• ProjectInfoPage ( type: esriFieldTypeString, alias: ProjectInfoPage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectInfoPage )
• SATerm ( type: esriFieldTypeDouble, alias: SATerm, editable: true, nullable: true, defaultValue: null, modelName: SATerm )
• WarrantyEndDate ( type: esriFieldTypeDate, alias: WarrantyEndDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyEndDate )
• EstimatedProjectCost ( type: esriFieldTypeDouble, alias: EstimatedProjectCost, editable: true, nullable: true, defaultValue: null, modelName: EstimatedProjectCost )
• TotalFeeAmount ( type: esriFieldTypeDouble, alias: TotalFeeAmount, editable: true, nullable: true, defaultValue: null, modelName: TotalFeeAmount )
• TotalCostWithFee ( type: esriFieldTypeDouble, alias: TotalCostWithFee, editable: true, nullable: true, defaultValue: null, modelName: TotalCostWithFee )
• WarrantyStartDate ( type: esriFieldTypeDate, alias: WarrantyStartDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyStartDate )
• ProjectName ( type: esriFieldTypeString, alias: ProjectName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectName )

Templates:

• Name: Capital Improvement Districts
  Description:
  Prototype:
  WarrantyStartDate: null
  BidDate: null
  Contractor: null
  CompletionDate: null
  ProjectManager: null
  ConstructionCost: null
  WorkType: null
  ContractorContactInformation: null
  ProjectStatus: null
  ImprovementDistrictNum: null
  CIPYEAR: null
  TotalFeeAmount: null
  EstimatedProjectCost: null
  WarrantyEndDate: null
  SATerm: null
  CitywideProject: No
  CIPMapWorkType: null
  CIPMapYear: null
  CIPMapPMIntials: null
  ProjNum: null
  ProFormaNumber: null
  SAProjectStatus: null
  SAUpdateAfterBidTab: null
  ChangeOrder: null
  Defferrals: null
  SubstantiallyComplete: null
  FinalPayEstimateDate: null
  CertifiedDate: null
  AssessedDate: null
  SARun: null
  SAComments: null
  SpecialAssessed: Yes
  ProjectCategory: null
  SpecialAssessedAmount: null
  Link1: null
  Link2: null
  ProjectName: null
  TotalCostWithFee: null
  ProjectPurpose: null
  EstimateStart: null
  EstimateEnd: null
  PACETotalProjectCost: null
  PACESpecialAssessedCost: null
  PercentCompleted: null
  CallforBidDate: null
  AdvertisingDate1: null
  AdvertisingDate2: null
  AdvertisingDate3: null
  ProtestNumProperties: null
  ProtestPercent: null
  Contractor1: null
  Bid1: null
  Status1: null
  Contractor2: null
  Bid2: null
  Status2: null
  Contractor3: null
  Bid3: null
  Status3: null
  Contractor4: null
  Bid4: null
  Status4: null
  Contractor5: null
  Bid5: null
  Status5: null
  Contractor6: null
  Bid6: null
  Status6: null
  Contractor7: null
  Bid7: null
  Status7: null
  Contractor8: null
  Bid8: null
  Status8: null
  ProjectInfoPage: null
  
  Drawing Tool: esriFeatureEditToolPolygon

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

Sync Can Return Changes: false

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   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata