View In:   ArcGIS Online Map Viewer

Name: OCSurvey.DBO.InfrastructureProjectsPoly

Display Field: projname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

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

Supports Datum Transformation: true

Extent:

XMin: 5995611.245203465
YMin: 2102986.834692225
XMax: 6168288.4812131375
YMax: 2296943.0324089825
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: projphase
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [255, 0, 0, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Default Label:
UniqueValueInfos:
• Value: Pre-Design
  Label: Pre-Design
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [85, 255, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [85, 255, 0, 255] Width: 0
• Value: Design
  Label: Design
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 170, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
• Value: Bid/Award
  Label: Bid/Award
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 92, 230, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
• Value: Construction
  Label: Construction
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [197, 0, 255, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
• Value: Post-Construction
  Label: Post-Construction
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [104, 104, 104, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
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: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: projphase

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• projid ( type: esriFieldTypeString, alias: Project Identifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: projid )
• ORIG_FID ( type: esriFieldTypeInteger, alias: ORIG_FID, editable: false, nullable: true, defaultValue: null, modelName: ORIG_FID )
• projname ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: projname )
• projdesc ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: projdesc )
• projlimits ( type: esriFieldTypeString, alias: Project Limits, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: projlimits )
• mcas ( type: esriFieldTypeString, alias: Major Construction Activities Summary, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: status )
• projtype ( type: esriFieldTypeString, alias: Project Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: projtype , Coded Values: [Bikeway/Trail: Bikeway/Trail] , [External: External] , [Facilities: Facilities] , ...7 more... )
• supdistrict ( type: esriFieldTypeSmallInteger, alias: Supervisorial District, editable: true, nullable: true, defaultValue: null, modelName: supdistrict , Coded Values: [1: 1st] , [2: 2nd] , [3: 3rd] , ...4 more... )
• jobnum ( type: esriFieldTypeString, alias: Job Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: jobnum )
• projphase ( type: esriFieldTypeString, alias: Project Phase, editable: true, nullable: true, length: 255, defaultValue: null, modelName: projphase , Coded Values: [Design: Design] , [Construction: Construction] , [Complete: Complete] , ...3 more... )
• CM_PUP_Project ( type: esriFieldTypeString, alias: CM PUP Project, editable: true, nullable: true, length: 50, defaultValue: 0, modelName: CM_PUP_Project , Coded Values: [0: No] , [1: Yes] )
• fiscalyr ( type: esriFieldTypeString, alias: Fiscal Year, editable: true, nullable: true, length: 10, defaultValue: null, modelName: fiscalyr )
• deliverymethod ( type: esriFieldTypeString, alias: Project Delivery Method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: deliverymethod )
• fundsource ( type: esriFieldTypeString, alias: Funding Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fundsource )
• planstart ( type: esriFieldTypeDate, alias: Planned Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: planstart )
• planend ( type: esriFieldTypeDate, alias: Planned End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: planend )
• estcost ( type: esriFieldTypeDouble, alias: Estimated Cost, editable: true, nullable: true, defaultValue: null, modelName: estcost )
• pocname ( type: esriFieldTypeString, alias: Contact Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pocname )
• pocphone ( type: esriFieldTypeString, alias: Contact Phone, editable: true, nullable: true, length: 20, defaultValue: null, modelName: pocphone )
• pocemail ( type: esriFieldTypeString, alias: Contact Email, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pocemail )
• actstart ( type: esriFieldTypeDate, alias: Actual Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: actstart )
• actend ( type: esriFieldTypeDate, alias: Actual End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: actend )
• actcost ( type: esriFieldTypeDouble, alias: Actual Cost, editable: true, nullable: true, defaultValue: null, modelName: actcost )
• client ( type: esriFieldTypeString, alias: Client, editable: true, nullable: true, length: 50, defaultValue: null, modelName: client )
• duedate ( type: esriFieldTypeDate, alias: Due Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: duedate )
• inistart ( type: esriFieldTypeDate, alias: Pre-Design Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inistart )
• inicost ( type: esriFieldTypeDouble, alias: Pre-Design Cost, editable: true, nullable: true, defaultValue: null, modelName: inicost )
• inidays ( type: esriFieldTypeInteger, alias: Pre-Design Days, editable: true, nullable: true, defaultValue: null, modelName: inidays )
• inifinish ( type: esriFieldTypeDate, alias: Pre-Design Finish Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inifinish )
• inicomp ( type: esriFieldTypeInteger, alias: Pre-Design Percent Complete, editable: true, nullable: true, defaultValue: null, modelName: inicomp )
• desstart ( type: esriFieldTypeDate, alias: Design Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: desstart )
• descost ( type: esriFieldTypeDouble, alias: Design Cost, editable: true, nullable: true, defaultValue: null, modelName: descost )
• desdays ( type: esriFieldTypeInteger, alias: Design Days, editable: true, nullable: true, defaultValue: null, modelName: desdays )
• desfinish ( type: esriFieldTypeDate, alias: Design Finish Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: desfinish )
• descomp ( type: esriFieldTypeInteger, alias: Design Percent Complete, editable: true, nullable: true, defaultValue: null, modelName: descomp )
• bidstart ( type: esriFieldTypeDate, alias: Bid Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: bidstart )
• bidcost ( type: esriFieldTypeDouble, alias: Bid Cost, editable: true, nullable: true, defaultValue: null, modelName: bidcost )
• biddays ( type: esriFieldTypeInteger, alias: Bid Days, editable: true, nullable: true, defaultValue: null, modelName: biddays )
• bidfinish ( type: esriFieldTypeDate, alias: Bid Finish Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: bidfinish )
• bidcomp ( type: esriFieldTypeInteger, alias: Bid Percent Complete, editable: true, nullable: true, defaultValue: null, modelName: bidcomp )
• constart ( type: esriFieldTypeDate, alias: Construction Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: constart )
• concost ( type: esriFieldTypeDouble, alias: Construction Cost, editable: true, nullable: true, defaultValue: null, modelName: concost )
• condays ( type: esriFieldTypeInteger, alias: Construction Days, editable: true, nullable: true, defaultValue: null, modelName: condays )
• confinish ( type: esriFieldTypeDate, alias: Construction Finish Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: confinish )
• concomp ( type: esriFieldTypeInteger, alias: Construction Percent Complete, editable: true, nullable: true, defaultValue: null, modelName: concomp )
• closestart ( type: esriFieldTypeDate, alias: Post-Construction Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: closestart )
• closecost ( type: esriFieldTypeDouble, alias: Post-Construction Cost, editable: true, nullable: true, defaultValue: null, modelName: closecost )
• closedays ( type: esriFieldTypeInteger, alias: Post-Construction Days, editable: true, nullable: true, defaultValue: null, modelName: closedays )
• closefinish ( type: esriFieldTypeDate, alias: Post-Construction Finish Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: closefinish )
• closecomp ( type: esriFieldTypeInteger, alias: Post-Construction Percent Complete, editable: true, nullable: true, defaultValue: null, modelName: closecomp )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Attachment_ID ( type: esriFieldTypeString, alias: Attachment_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Attachment_ID )
• flag ( type: esriFieldTypeString, alias: flag, editable: true, nullable: true, length: 15, defaultValue: null, modelName: flag )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Shape__Area ( type: esriFieldTypeDouble, alias: Shape.STArea(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STArea() )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Editor )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Creator )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• 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 )

Types:

ID: Pre-Design
Name: Pre-Design
Domains:
• projtype:
  Inherited
• supdistrict:
  Inherited
• projphase:
  Inherited
• CM_PUP_Project:
  Inherited
Templates:
• Name: Pre-Design
  Description:
  Prototype:
  Attachment_ID: null
  flag: null
  projid: null
  last_edited_date: null
  projname: null
  projdesc: null
  projlimits: null
  mcas: null
  projtype: null
  supdistrict: null
  jobnum: null
  projphase: Pre-Design
  CM_PUP_Project: 0
  fiscalyr: null
  deliverymethod: null
  fundsource: null
  planstart: null
  planend: null
  estcost: null
  pocname: null
  pocphone: null
  pocemail: null
  actstart: null
  actend: null
  actcost: null
  client: null
  duedate: null
  inistart: null
  inicost: null
  inidays: null
  inifinish: null
  inicomp: null
  desstart: null
  descost: null
  desdays: null
  desfinish: null
  descomp: null
  bidstart: null
  bidcost: null
  biddays: null
  bidfinish: null
  bidcomp: null
  constart: null
  concost: null
  condays: null
  confinish: null
  concomp: null
  closestart: null
  closecost: null
  closedays: null
  closefinish: null
  closecomp: null
  last_edited_user: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Design
Name: Design
Domains:
• projtype:
  Inherited
• supdistrict:
  Inherited
• projphase:
  Inherited
• CM_PUP_Project:
  Inherited
Templates:
• Name: Design
  Description:
  Prototype:
  Attachment_ID: null
  flag: null
  projid: null
  last_edited_date: null
  projname: null
  projdesc: null
  projlimits: null
  mcas: null
  projtype: null
  supdistrict: null
  jobnum: null
  projphase: Design
  CM_PUP_Project: 0
  fiscalyr: null
  deliverymethod: null
  fundsource: null
  planstart: null
  planend: null
  estcost: null
  pocname: null
  pocphone: null
  pocemail: null
  actstart: null
  actend: null
  actcost: null
  client: null
  duedate: null
  inistart: null
  inicost: null
  inidays: null
  inifinish: null
  inicomp: null
  desstart: null
  descost: null
  desdays: null
  desfinish: null
  descomp: null
  bidstart: null
  bidcost: null
  biddays: null
  bidfinish: null
  bidcomp: null
  constart: null
  concost: null
  condays: null
  confinish: null
  concomp: null
  closestart: null
  closecost: null
  closedays: null
  closefinish: null
  closecomp: null
  last_edited_user: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Bid/Award
Name: Bid/Award
Domains:
• projtype:
  Inherited
• supdistrict:
  Inherited
• projphase:
  Inherited
• CM_PUP_Project:
  Inherited
Templates:
• Name: Bid/Award
  Description:
  Prototype:
  Attachment_ID: null
  flag: null
  projid: null
  last_edited_date: null
  projname: null
  projdesc: null
  projlimits: null
  mcas: null
  projtype: null
  supdistrict: null
  jobnum: null
  projphase: Bid/Award
  CM_PUP_Project: 0
  fiscalyr: null
  deliverymethod: null
  fundsource: null
  planstart: null
  planend: null
  estcost: null
  pocname: null
  pocphone: null
  pocemail: null
  actstart: null
  actend: null
  actcost: null
  client: null
  duedate: null
  inistart: null
  inicost: null
  inidays: null
  inifinish: null
  inicomp: null
  desstart: null
  descost: null
  desdays: null
  desfinish: null
  descomp: null
  bidstart: null
  bidcost: null
  biddays: null
  bidfinish: null
  bidcomp: null
  constart: null
  concost: null
  condays: null
  confinish: null
  concomp: null
  closestart: null
  closecost: null
  closedays: null
  closefinish: null
  closecomp: null
  last_edited_user: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Construction
Name: Construction
Domains:
• projtype:
  Inherited
• supdistrict:
  Inherited
• projphase:
  Inherited
• CM_PUP_Project:
  Inherited
Templates:
• Name: Construction
  Description:
  Prototype:
  Attachment_ID: null
  flag: null
  projid: null
  last_edited_date: null
  projname: null
  projdesc: null
  projlimits: null
  mcas: null
  projtype: null
  supdistrict: null
  jobnum: null
  projphase: Construction
  CM_PUP_Project: 0
  fiscalyr: null
  deliverymethod: null
  fundsource: null
  planstart: null
  planend: null
  estcost: null
  pocname: null
  pocphone: null
  pocemail: null
  actstart: null
  actend: null
  actcost: null
  client: null
  duedate: null
  inistart: null
  inicost: null
  inidays: null
  inifinish: null
  inicomp: null
  desstart: null
  descost: null
  desdays: null
  desfinish: null
  descomp: null
  bidstart: null
  bidcost: null
  biddays: null
  bidfinish: null
  bidcomp: null
  constart: null
  concost: null
  condays: null
  confinish: null
  concomp: null
  closestart: null
  closecost: null
  closedays: null
  closefinish: null
  closecomp: null
  last_edited_user: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Post-Construction
Name: Post-Construction
Domains:
• projtype:
  Inherited
• supdistrict:
  Inherited
• projphase:
  Inherited
• CM_PUP_Project:
  Inherited
Templates:
• Name: Post-Construction
  Description:
  Prototype:
  Attachment_ID: null
  flag: null
  projid: null
  last_edited_date: null
  projname: null
  projdesc: null
  projlimits: null
  mcas: null
  projtype: null
  supdistrict: null
  jobnum: null
  projphase: Post-Construction
  CM_PUP_Project: 0
  fiscalyr: null
  deliverymethod: null
  fundsource: null
  planstart: null
  planend: null
  estcost: null
  pocname: null
  pocphone: null
  pocemail: null
  actstart: null
  actend: null
  actcost: null
  client: null
  duedate: null
  inistart: null
  inicost: null
  inidays: null
  inifinish: null
  inicomp: null
  desstart: null
  descost: null
  desdays: null
  desfinish: null
  descomp: null
  bidstart: null
  bidcost: null
  biddays: null
  bidfinish: null
  bidcomp: null
  constart: null
  concost: null
  condays: null
  confinish: null
  concomp: null
  closestart: null
  closecost: null
  closedays: null
  closefinish: null
  closecomp: null
  last_edited_user: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata