View In:   ArcGIS Online Map Viewer

Name: CIP POINTS

Display Field: projectname

Type: Feature Layer

Geometry Type: esriGeometryMultipoint

Description:

Service Item Id: 64b64d1eed2d4d58942e6ee286637198

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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

Extent:

XMin: 446954.600845661
YMin: 1205023.5407794043
XMax: 638246.8672104962
YMax: 1395656.8376616538
Spatial Reference: 102659  (2237)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [245, 202, 122, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
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: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• cip_number ( modelName: CIP_Number, nullable: true, editable: true, defaultValue: null, length: 20, alias: CIP Number, type: esriFieldTypeString )
• cip_num ( modelName: PLACENUMSL, nullable: true, editable: true, defaultValue: null, alias: CIP Number, type: esriFieldTypeDouble )
• projectname ( modelName: Current_Phase_CompleteDate, nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Name, type: esriFieldTypeString )
• project_type ( modelName: SHORT_DESC, nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Type, type: esriFieldTypeString , Coded Values: [Potable Water: Potable Water] , [Reclaimed Water: Reclaimed Water] , [Culvert Repair and Replacement: Culvert Repair and Replacement] , ...12 more... )
• major_category ( modelName: Major_Category, nullable: true, editable: true, defaultValue: null, length: 50, alias: Major Category, type: esriFieldTypeString , Coded Values: [Transportation: Transportation] , [Stormwater: Stormwater] , [Public Utilities: Public Utilities] , ...1 more... )
• current_phase ( modelName: Current_Phase, nullable: true, editable: true, defaultValue: null, length: 255, alias: Current Project Phase, type: esriFieldTypeString , Coded Values: [Planning: Planning] , [Design: Design] , [Procurement: Procurement] , ...4 more... )
• project_manager ( modelName: Project_Manager, nullable: true, editable: true, defaultValue: null, length: 50, alias: Project Manager, type: esriFieldTypeString )
• phone_number ( modelName: Phone_Number, nullable: true, editable: true, defaultValue: null, length: 25, alias: Phone Number, type: esriFieldTypeString )
• desc1 ( modelName: DESC1, nullable: true, editable: true, defaultValue: null, length: 700, alias: Project Description, type: esriFieldTypeString )
• desc2 ( modelName: DESC2, nullable: true, editable: true, defaultValue: null, length: 700, alias: Description 2, type: esriFieldTypeString )
• desc3 ( modelName: DESC3, nullable: true, editable: true, defaultValue: null, length: 700, alias: Description 3, type: esriFieldTypeString )
• desc4 ( modelName: DESC4, nullable: true, editable: true, defaultValue: null, length: 700, alias: Description 4, type: esriFieldTypeString )
• obj1 ( modelName: Obj1, nullable: true, editable: true, defaultValue: null, length: 750, alias: Objective1, type: esriFieldTypeString )
• obj2 ( modelName: Obj2, nullable: true, editable: true, defaultValue: null, length: 750, alias: Objective2, type: esriFieldTypeString )
• obj3 ( modelName: Obj3, nullable: true, editable: true, defaultValue: null, length: 750, alias: Objective3, type: esriFieldTypeString )
• obj4 ( modelName: Obj4, nullable: true, editable: true, defaultValue: null, length: 500, alias: Objective4, type: esriFieldTypeString )
• planningdate ( modelName: PlanningDate, nullable: true, editable: true, defaultValue: null, length: 15, alias: Planning Date, type: esriFieldTypeString )
• designdate ( modelName: DesignDate, nullable: true, editable: true, defaultValue: null, length: 15, alias: Design and Land Date, type: esriFieldTypeString )
• procuredate ( modelName: ProcureDate, nullable: true, editable: true, defaultValue: null, length: 15, alias: Procurement for Construction Date, type: esriFieldTypeString )
• constr_start ( modelName: Constr_Start, nullable: true, editable: true, defaultValue: null, length: 15, alias: Construction Start Date, type: esriFieldTypeString )
• constr_end ( modelName: Constr_End, nullable: true, editable: true, defaultValue: null, length: 15, alias: Construction Finish Date, type: esriFieldTypeString )
• closeoutdate ( modelName: CloseoutDate, nullable: true, editable: true, defaultValue: null, length: 15, alias: Post Construction and Closeout Date, type: esriFieldTypeString )
• project_budget ( modelName: Project_Budget, nullable: true, editable: true, defaultValue: null, alias: Estimate at Completion, type: esriFieldTypeDouble )
• planningbudget ( modelName: PlanningBudget, nullable: true, editable: true, defaultValue: null, alias: Planning Budget, type: esriFieldTypeDouble )
• designbudget ( modelName: DesignBudget, nullable: true, editable: true, defaultValue: null, alias: Design and Land Budget, type: esriFieldTypeDouble )
• constr_budget ( modelName: Constr_Budget, nullable: true, editable: true, defaultValue: null, alias: Construction Budget, type: esriFieldTypeDouble )
• fundnotes ( modelName: FundNotes, nullable: true, editable: true, defaultValue: null, length: 255, alias: FundNotes, type: esriFieldTypeString )
• on_schedule ( modelName: On_Schedule, nullable: true, editable: true, defaultValue: null, length: 10, alias: On Schedule, type: esriFieldTypeString )
• on_budget ( modelName: On_Budget, nullable: true, editable: true, defaultValue: null, length: 10, alias: On Budget, type: esriFieldTypeString )
• commisioner_district ( modelName: Commisioner_District, nullable: true, editable: true, defaultValue: null, length: 20, alias: Commisioner District, type: esriFieldTypeString , Coded Values: [District 4: District 4] , [District 1: District 1] , [District 3: District 3] , ...2 more... )
• community ( modelName: Community, nullable: true, editable: true, defaultValue: null, length: 75, alias: Community Area, type: esriFieldTypeString )
• planningarea ( modelName: PlanningArea, nullable: true, editable: true, defaultValue: null, length: 100, alias: Planning Area, type: esriFieldTypeString )
• length_ft ( modelName: Length_Ft, nullable: true, editable: true, defaultValue: null, alias: Project Length (Feet), type: esriFieldTypeDouble )
• region ( modelName: Region, nullable: true, editable: true, defaultValue: null, length: 50, alias: Region, type: esriFieldTypeString , Coded Values: [Northwest: Northwest] , [Northeast: Northeast] , [South: South] )
• datadate ( modelName: DataDate, nullable: true, editable: true, defaultValue: null, length: 12, alias: Data Date, type: esriFieldTypeString )
• gis_verify_date ( modelName: GIS_Verify_Date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: GIS_Verify_Date, type: esriFieldTypeDate )
• data_source ( modelName: Data_Source, nullable: true, editable: true, defaultValue: null, length: 25, alias: Data Source, type: esriFieldTypeString , Coded Values: [PWD: PWD] , [PUD: PUD] , [REFS: REFS] )
• display ( modelName: Display, nullable: true, editable: true, defaultValue: null, alias: Display, type: esriFieldTypeSmallInteger )
• phasegraphic ( modelName: PhaseGraphic, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Phase Graphic, type: esriFieldTypeString )
• budgetgraphic ( modelName: BudgetGraphic, nullable: true, editable: true, defaultValue: null, length: 256, alias: BudgetGraphic, type: esriFieldTypeString )
• schedulegraphic ( modelName: ScheduleGraphic, nullable: true, editable: true, defaultValue: null, length: 256, alias: ScheduleGraphic, type: esriFieldTypeString )
• website_url ( modelName: website, nullable: true, editable: true, defaultValue: https://www.hillsboroughcounty.org/en/government/county-projects, length: 300, alias: Website, type: esriFieldTypeString )
• pic_url ( modelName: pic_url, nullable: true, editable: true, defaultValue: null, length: 300, alias: Project Photo:, type: esriFieldTypeString )
• thumb_url ( modelName: thumb_url, nullable: true, editable: true, defaultValue: null, length: 300, alias: Thumbnail URL, type: esriFieldTypeString )
• factsheet_url ( modelName: factsheet_url, nullable: true, editable: true, defaultValue: null, length: 1000, alias: Factsheet_url, type: esriFieldTypeString )
• creationdate ( modelName: CreationDate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: CreationDate, type: esriFieldTypeDate )
• creator ( modelName: Creator, nullable: true, editable: true, defaultValue: null, length: 128, alias: Creator, type: esriFieldTypeString )
• editdate ( modelName: EditDate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: Editor, nullable: true, editable: true, defaultValue: null, length: 128, alias: Editor, type: esriFieldTypeString )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• has_line ( modelName: has_line, nullable: true, editable: true, defaultValue: null, length: 10, alias: Has_Line, type: esriFieldTypeString )
• budgetstatus ( modelName: BudgetStatus, nullable: true, editable: true, defaultValue: null, length: 70, alias: Budget Status, type: esriFieldTypeString )
• budgetreason ( modelName: BudgetReason, nullable: true, editable: true, defaultValue: null, length: 70, alias: Budget Reason, type: esriFieldTypeString , Coded Values: [1: Scope Change] , [2: Inaccurate Estimates] , [3: Estimates Prior to PD&E] , ...8 more... )
• schedulestatus ( modelName: ScheduleStatus, nullable: true, editable: true, defaultValue: null, length: 70, alias: Schedule Status, type: esriFieldTypeString )
• schedulereason ( modelName: ScheduleReason, nullable: true, editable: true, defaultValue: null, length: 70, alias: Schedule Reason, type: esriFieldTypeString , Coded Values: [1: Scope Change] , [2: Inaccurate Estimates] , [3: Estimates Prior to PD&E] , ...8 more... )
• mbe_yn ( modelName: MBE_YN, nullable: true, editable: true, defaultValue: null, length: 10, alias: MBE Story Map_YesNo, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• mbe_url ( modelName: MBE_url, nullable: true, editable: true, defaultValue: null, length: 50, alias: MBE Story Map_URL, type: esriFieldTypeString )
• mapscale ( modelName: MapScale, nullable: true, editable: true, defaultValue: 6000, alias: Map Scale, type: esriFieldTypeDouble )
• addmaterials_label ( modelName: AddMaterials_Label, nullable: true, editable: true, defaultValue: null, length: 100, alias: Additional Materials_Label, type: esriFieldTypeString )
• addmaterials_url ( modelName: AddMaterials_URL, nullable: true, editable: true, defaultValue: null, length: 255, alias: Additional Materials_URL, type: esriFieldTypeString )
• highlight_yn ( modelName: Highlight_YN, nullable: true, editable: true, defaultValue: null, length: 7, alias: Highlight Project, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• locationconf ( modelName: LocationConf, nullable: true, editable: true, defaultValue: null, length: 7, alias: Location Confidence, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• projnotes ( modelName: ProjNotes, nullable: true, editable: true, defaultValue: null, length: 700, alias: Project Notes, type: esriFieldTypeString )

Templates:

• Name: CIP POINTS
  Description:
  Prototype:
  procuredate: null
  creationdate: null
  schedulestatus: null
  schedulegraphic: null
  designbudget: null
  factsheet_url: null
  constr_budget: null
  has_line: null
  cip_number: null
  project_manager: null
  cip_num: null
  on_budget: null
  fundnotes: null
  project_type: null
  projectname: null
  closeoutdate: null
  planningbudget: null
  planningdate: null
  gis_verify_date: null
  obj2: null
  obj1: null
  designdate: null
  projnotes: null
  major_category: null
  community: null
  constr_end: null
  obj4: null
  data_source: null
  obj3: null
  phasegraphic: null
  phone_number: null
  region: null
  pic_url: null
  editdate: null
  length_ft: null
  budgetstatus: null
  thumb_url: null
  current_phase: null
  planningarea: null
  constr_start: null
  mapscale: 6000
  mbe_yn: null
  locationconf: null
  schedulereason: null
  mbe_url: null
  editor: null
  creator: null
  display: null
  budgetreason: null
  desc1: null
  desc2: null
  datadate: null
  highlight_yn: null
  desc3: null
  desc4: null
  addmaterials_label: null
  on_schedule: null
  website_url: https://www.hillsboroughcounty.org/en/government/county-projects
  addmaterials_url: null
  project_budget: null
  budgetgraphic: null
  commisioner_district: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• CIP_Lines_Cartographic (0) -- Related To: CIP LINES (1)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

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 Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata