View In:   ArcGIS Online Map Viewer

Name: OCSurvey.DBO.InfrastructureProjects

Display Field: projname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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: 5997813.893029138
YMin: 2104085.2265243083
XMax: 6168218.482993558
YMax: 2291617.231708899
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [221, 252, 210, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label:
Description:
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• projid ( type: esriFieldTypeString, alias: Project Identifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: projid )
• 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: 1000, defaultValue: null, modelName: projdesc )
• rationale ( type: esriFieldTypeString, alias: Rationale, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: rationale )
• 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... )
• safety ( type: esriFieldTypeString, alias: Health and Safety, editable: true, nullable: true, length: 5, defaultValue: null, modelName: safety , Coded Values: [Yes: Yes] , [No: No] )
• mandate ( type: esriFieldTypeString, alias: Mandate, editable: true, nullable: true, length: 5, defaultValue: null, modelName: mandate , Coded Values: [Yes: Yes] , [No: No] )
• repair ( type: esriFieldTypeString, alias: Repair or Maintenance, editable: true, nullable: true, length: 5, defaultValue: null, modelName: repair , Coded Values: [Yes: Yes] , [No: No] )
• replace ( type: esriFieldTypeString, alias: Replacement, editable: true, nullable: true, length: 5, defaultValue: null, modelName: replace , Coded Values: [Yes: Yes] , [No: No] )
• expand ( type: esriFieldTypeString, alias: Expansion, editable: true, nullable: true, length: 5, defaultValue: null, modelName: expand , Coded Values: [Yes: Yes] , [No: No] )
• efficient ( type: esriFieldTypeString, alias: Efficiency, editable: true, nullable: true, length: 5, defaultValue: null, modelName: efficient , Coded Values: [Yes: Yes] , [No: No] )
• fiscalyr ( type: esriFieldTypeString, alias: Fiscal Year, editable: true, nullable: true, length: 10, defaultValue: null, modelName: fiscalyr )
• fundsource ( type: esriFieldTypeString, alias: Funding Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fundsource , Coded Values: [Capital Fund: Capital Fund] , [Connection Fee: Connection Fee] , [General Fund: General Fund] , ...7 more... )
• 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: 12, defaultValue: null, modelName: pocphone )
• pocemail ( type: esriFieldTypeString, alias: Contact Email, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pocemail )
• projstatus ( type: esriFieldTypeString, alias: Project Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: projstatus , Coded Values: [Project Initiation: Project Initiation] , [Analysis and Review: Analysis and Review] , [Executive Approval: Executive Approval] , ...1 more... )
• funded ( type: esriFieldTypeString, alias: Funded Project, editable: true, nullable: true, length: 5, defaultValue: null, modelName: funded , Coded Values: [Yes: Yes] , [No: No] )
• 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... )
• 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 )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: status )
• docpath ( type: esriFieldTypeString, alias: Document Path, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: docpath )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Editor )
• Shape__Area ( type: esriFieldTypeDouble, alias: Shape__Area, editable: true, nullable: true, defaultValue: null, modelName: Shape__Area )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape__Length, editable: true, nullable: true, defaultValue: null, modelName: Shape__Length )
• deliverymethod ( type: esriFieldTypeString, alias: Project Delivery Method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: deliverymethod )
• programedyn ( type: esriFieldTypeString, alias: Programed, editable: true, nullable: true, length: 5, defaultValue: null, modelName: programedyn , Coded Values: [Yes: Yes] , [No: No] )
• funding1 ( type: esriFieldTypeString, alias: Project Funding 1, editable: true, nullable: true, length: 20, defaultValue: null, modelName: funding1 )
• funding2 ( type: esriFieldTypeString, alias: Project Funding 2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: funding2 )
• funding3 ( type: esriFieldTypeString, alias: Project Funding 3, editable: true, nullable: true, length: 20, defaultValue: null, modelName: funding3 )
• funding4 ( type: esriFieldTypeString, alias: Project Funding 4, editable: true, nullable: true, length: 20, defaultValue: null, modelName: funding4 )
• funding5 ( type: esriFieldTypeString, alias: Project Funding 5, editable: true, nullable: true, length: 20, defaultValue: null, modelName: funding5 )
• fy2021appfund ( type: esriFieldTypeInteger, alias: FY 20-21 Approved Funding, editable: true, nullable: true, defaultValue: null, modelName: fy2021appfund )
• fy2021encumbrances ( type: esriFieldTypeInteger, alias: FY 20-21 Encumbrances, editable: true, nullable: true, defaultValue: null, modelName: fy2021encumbrances )
• fy2021expenditures ( type: esriFieldTypeInteger, alias: FY 20-21 Expenditures, editable: true, nullable: true, defaultValue: null, modelName: fy2021expenditures )
• fy2021unobligated ( type: esriFieldTypeInteger, alias: FY 20-21 Unobligated Balance, editable: true, nullable: true, defaultValue: null, modelName: fy2021unobligated )
• jobnum ( type: esriFieldTypeString, alias: Job Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: jobnum )
• sectionnum ( type: esriFieldTypeString, alias: Section Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: sectionnum )
• assignedpm ( type: esriFieldTypeString, alias: Assigned Project Manager, editable: true, nullable: true, length: 50, defaultValue: null, modelName: assignedpm )
• pmagency ( type: esriFieldTypeString, alias: PM Agency, editable: true, nullable: true, length: 50, defaultValue: null, modelName: pmagency , Coded Values: [CEO: CEO] , [CEOCIP: CEO CIP] , [FMCUF: FM CUF] , ...13 more... )
• sectionmanager ( type: esriFieldTypeString, alias: Section Manager, editable: true, nullable: true, length: 50, defaultValue: null, modelName: sectionmanager )
• client ( type: esriFieldTypeString, alias: Client, editable: true, nullable: true, length: 50, defaultValue: null, modelName: client , Coded Values: [CEO: CEO] , [CEO CIP: CEO CIP] , [FM CUF: FM CUF] , ...13 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... )
• projlimits ( type: esriFieldTypeString, alias: Project Limits, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: projlimits )
• proctype ( type: esriFieldTypeString, alias: Procurement Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: proctype )
• nextprocaction ( type: esriFieldTypeString, alias: Next Procurement Action, editable: true, nullable: true, length: 255, defaultValue: null, modelName: nextprocaction )
• duedate ( type: esriFieldTypeDate, alias: Due Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: duedate )
• inistart ( type: esriFieldTypeDate, alias: Initiation Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inistart )
• inicost ( type: esriFieldTypeDouble, alias: Initiation Cost, editable: true, nullable: true, defaultValue: null, modelName: inicost )
• inidays ( type: esriFieldTypeInteger, alias: Initiation Days, editable: true, nullable: true, defaultValue: null, modelName: inidays )
• inifinish ( type: esriFieldTypeDate, alias: Initiation Finish Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inifinish )
• inicomp ( type: esriFieldTypeInteger, alias: Initiation Percent Complete, editable: true, nullable: true, defaultValue: null, modelName: inicomp )
• 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 )
• 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 )
• 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 )
• closecost ( type: esriFieldTypeDouble, alias: Close Cost, editable: true, nullable: true, defaultValue: null, modelName: closecost )
• closedays ( type: esriFieldTypeInteger, alias: Close Days, editable: true, nullable: true, defaultValue: null, modelName: closedays )
• closefinish ( type: esriFieldTypeDate, alias: Close Finish Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: closefinish )
• closecomp ( type: esriFieldTypeInteger, alias: Close Percent Complete, editable: true, nullable: true, defaultValue: null, modelName: closecomp )
• projcomp ( type: esriFieldTypeInteger, alias: Project Percent Complete, editable: true, nullable: true, defaultValue: null, modelName: projcomp )
• planned ( type: esriFieldTypeString, alias: Planned, editable: true, nullable: true, length: 10, defaultValue: null, modelName: planned )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 20, defaultValue: null, modelName: State )

Templates:

• Name: OCSurvey.DBO.InfrastructureProjects
  Description:
  Prototype:
  planned: null
  projcomp: null
  State: null
  projid: null
  projname: null
  projdesc: null
  rationale: null
  projtype: null
  safety: null
  mandate: null
  repair: null
  replace: null
  expand: null
  efficient: null
  fiscalyr: null
  fundsource: null
  planstart: null
  planend: null
  estcost: null
  pocname: null
  pocphone: null
  pocemail: null
  projstatus: null
  funded: null
  projphase: null
  actstart: null
  actend: null
  actcost: null
  status: null
  docpath: null
  CreationDate: null
  Creator: null
  EditDate: null
  Editor: null
  Shape__Area: null
  Shape__Length: null
  deliverymethod: null
  programedyn: null
  funding1: null
  funding2: null
  funding3: null
  funding4: null
  funding5: null
  fy2021appfund: null
  fy2021encumbrances: null
  fy2021expenditures: null
  fy2021unobligated: null
  jobnum: null
  sectionnum: null
  assignedpm: null
  pmagency: null
  sectionmanager: null
  client: null
  supdistrict: null
  projlimits: null
  proctype: null
  nextprocaction: null
  duedate: null
  inistart: null
  inicost: null
  inidays: null
  inifinish: null
  inicomp: null
  descost: null
  desdays: null
  desfinish: null
  descomp: null
  bidcost: null
  biddays: null
  bidfinish: null
  bidcomp: null
  concost: null
  condays: null
  confinish: null
  concomp: null
  closecost: null
  closedays: null
  closefinish: null
  closecomp: null
  
  Drawing Tool: esriFeatureEditToolPolygon

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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