Layers:

Layer: OCSurvey.DBO.InfrastructureProjects (0)

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• projid ( type: esriFieldTypeString, alias: Project Identifier, length: 50 )
• projname ( type: esriFieldTypeString, alias: Project Name, length: 255 )
• projdesc ( type: esriFieldTypeString, alias: Description, length: 1000 )
• rationale ( type: esriFieldTypeString, alias: Rationale, length: 1000 )
• projtype ( type: esriFieldTypeString, alias: Project Type, length: 50 , Coded Values: [Bikeway/Trail: Bikeway/Trail] , [External: External] , [Facilities: Facilities] , ...7 more... )
• safety ( type: esriFieldTypeString, alias: Health and Safety, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• mandate ( type: esriFieldTypeString, alias: Mandate, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• repair ( type: esriFieldTypeString, alias: Repair or Maintenance, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• replace ( type: esriFieldTypeString, alias: Replacement, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• expand ( type: esriFieldTypeString, alias: Expansion, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• efficient ( type: esriFieldTypeString, alias: Efficiency, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• fiscalyr ( type: esriFieldTypeString, alias: Fiscal Year, length: 10 )
• fundsource ( type: esriFieldTypeString, alias: Funding Source, length: 50 , Coded Values: [Capital Fund: Capital Fund] , [Connection Fee: Connection Fee] , [General Fund: General Fund] , ...7 more... )
• planstart ( type: esriFieldTypeDate, alias: Planned Start Date, length: 8 )
• planend ( type: esriFieldTypeDate, alias: Planned End Date, length: 8 )
• estcost ( type: esriFieldTypeDouble, alias: Estimated Cost )
• pocname ( type: esriFieldTypeString, alias: Contact Name, length: 255 )
• pocphone ( type: esriFieldTypeString, alias: Contact Phone, length: 12 )
• pocemail ( type: esriFieldTypeString, alias: Contact Email, length: 255 )
• projstatus ( type: esriFieldTypeString, alias: Project Status, length: 50 , Coded Values: [Project Initiation: Project Initiation] , [Analysis and Review: Analysis and Review] , [Executive Approval: Executive Approval] , ...1 more... )
• funded ( type: esriFieldTypeString, alias: Funded Project, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• projphase ( type: esriFieldTypeString, alias: Project Phase, length: 255 , Coded Values: [Design: Design] , [Construction: Construction] , [Complete: Complete] , ...3 more... )
• actstart ( type: esriFieldTypeDate, alias: Actual Start Date, length: 8 )
• actend ( type: esriFieldTypeDate, alias: Actual End Date, length: 8 )
• actcost ( type: esriFieldTypeDouble, alias: Actual Cost )
• status ( type: esriFieldTypeString, alias: Status, length: 1000 )
• docpath ( type: esriFieldTypeString, alias: Document Path, length: 1000 )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 50 )
• Shape__Area ( type: esriFieldTypeDouble, alias: Shape__Area )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape__Length )
• deliverymethod ( type: esriFieldTypeString, alias: Project Delivery Method, length: 50 )
• programedyn ( type: esriFieldTypeString, alias: Programed, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• funding1 ( type: esriFieldTypeString, alias: Project Funding 1, length: 20 )
• funding2 ( type: esriFieldTypeString, alias: Project Funding 2, length: 20 )
• funding3 ( type: esriFieldTypeString, alias: Project Funding 3, length: 20 )
• funding4 ( type: esriFieldTypeString, alias: Project Funding 4, length: 20 )
• funding5 ( type: esriFieldTypeString, alias: Project Funding 5, length: 20 )
• fy2021appfund ( type: esriFieldTypeInteger, alias: FY 20-21 Approved Funding )
• fy2021encumbrances ( type: esriFieldTypeInteger, alias: FY 20-21 Encumbrances )
• fy2021expenditures ( type: esriFieldTypeInteger, alias: FY 20-21 Expenditures )
• fy2021unobligated ( type: esriFieldTypeInteger, alias: FY 20-21 Unobligated Balance )
• jobnum ( type: esriFieldTypeString, alias: Job Number, length: 20 )
• sectionnum ( type: esriFieldTypeString, alias: Section Number, length: 20 )
• assignedpm ( type: esriFieldTypeString, alias: Assigned Project Manager, length: 50 )
• pmagency ( type: esriFieldTypeString, alias: PM Agency, length: 50 , Coded Values: [CEO: CEO] , [CEOCIP: CEO CIP] , [FMCUF: FM CUF] , ...13 more... )
• sectionmanager ( type: esriFieldTypeString, alias: Section Manager, length: 50 )
• client ( type: esriFieldTypeString, alias: Client, length: 50 , Coded Values: [CEO: CEO] , [CEO CIP: CEO CIP] , [FM CUF: FM CUF] , ...13 more... )
• supdistrict ( type: esriFieldTypeSmallInteger, alias: Supervisorial District , Coded Values: [1: 1st] , [2: 2nd] , [3: 3rd] , ...4 more... )
• projlimits ( type: esriFieldTypeString, alias: Project Limits, length: 1000 )
• proctype ( type: esriFieldTypeString, alias: Procurement Type, length: 255 )
• nextprocaction ( type: esriFieldTypeString, alias: Next Procurement Action, length: 255 )
• duedate ( type: esriFieldTypeDate, alias: Due Date, length: 8 )
• inistart ( type: esriFieldTypeDate, alias: Initiation Start Date, length: 8 )
• inicost ( type: esriFieldTypeDouble, alias: Initiation Cost )
• inidays ( type: esriFieldTypeInteger, alias: Initiation Days )
• inifinish ( type: esriFieldTypeDate, alias: Initiation Finish Date, length: 8 )
• inicomp ( type: esriFieldTypeInteger, alias: Initiation Percent Complete )
• descost ( type: esriFieldTypeDouble, alias: Design Cost )
• desdays ( type: esriFieldTypeInteger, alias: Design Days )
• desfinish ( type: esriFieldTypeDate, alias: Design Finish Date, length: 8 )
• descomp ( type: esriFieldTypeInteger, alias: Design Percent Complete )
• bidcost ( type: esriFieldTypeDouble, alias: Bid Cost )
• biddays ( type: esriFieldTypeInteger, alias: Bid Days )
• bidfinish ( type: esriFieldTypeDate, alias: Bid Finish Date, length: 8 )
• bidcomp ( type: esriFieldTypeInteger, alias: Bid Percent Complete )
• concost ( type: esriFieldTypeDouble, alias: Construction Cost )
• condays ( type: esriFieldTypeInteger, alias: Construction Days )
• confinish ( type: esriFieldTypeDate, alias: Construction Finish Date, length: 8 )
• concomp ( type: esriFieldTypeInteger, alias: Construction Percent Complete )
• closecost ( type: esriFieldTypeDouble, alias: Close Cost )
• closedays ( type: esriFieldTypeInteger, alias: Close Days )
• closefinish ( type: esriFieldTypeDate, alias: Close Finish Date, length: 8 )
• closecomp ( type: esriFieldTypeInteger, alias: Close Percent Complete )
• projcomp ( type: esriFieldTypeInteger, alias: Project Percent Complete )
• planned ( type: esriFieldTypeString, alias: Planned, length: 10 )
• State ( type: esriFieldTypeString, alias: State, length: 20 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Tables:

Table: OCSurvey.DBO.Project_Comments (2)

Name: OCSurvey.DBO.Project_Comments

Display Field: name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• projid ( type: esriFieldTypeGUID, alias: Project Identifier, length: 38 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• name ( type: esriFieldTypeString, alias: Name, length: 150 )
• submitdt ( type: esriFieldTypeDate, alias: Date Submitted, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 50 )