Name: prop407status_06_2023

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -12359390.782094
YMin: 3774171.43876978
XMax: -12328521.9769604
YMax: 3800551.38751164
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"QCT_overlap","field2":"Status","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":0.5},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2},"value":"1,Design","label":"1,Design"},{"symbol":{"type":"esriSLS","style":"esriSLSDash","color":[0,92,230,255],"width":3},"value":"1,Planned","label":"1,Planned"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[244,212,252,255],"toColor":[244,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[190,252,182,255],"toColor":[190,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,182,255],"toColor":[252,210,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,251,252,255],"toColor":[194,251,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,185,252,255],"toColor":[182,185,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[249,252,184,255],"toColor":[249,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,204,255],"toColor":[252,182,204,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,217,252,255],"toColor":[179,217,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,179,252,255],"toColor":[250,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,252,222,255],"toColor":[194,252,222,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,246,212,255],"toColor":[252,246,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,212,255],"toColor":[252,212,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,187,235,255],"toColor":[252,187,235,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: QCT_overlap

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• ProjectName (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• StatusCode (type: esriFieldTypeSmallInteger, alias: StatusCode, SQL Type: sqlTypeOther, nullable: false, editable: true)
• Category (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• Treatment (type: esriFieldTypeString, alias: Treatment, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Lane_Miles (type: esriFieldTypeDouble, alias: Lane Miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Length_ft (type: esriFieldTypeDouble, alias: Length_ft, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ward (type: esriFieldTypeString, alias: Ward(s), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Location_Desc (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
• Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ProjectID (type: esriFieldTypeString, alias: Project/Unit ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Project Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PercentComplete (type: esriFieldTypeString, alias: % Complete (Current Status), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FY_Planned (type: esriFieldTypeString, alias: FY Construction Begin, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• UCC_Update (type: esriFieldTypeString, alias: Status Since Last UCC Meeting, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [New: New], [No Change: No Change], [Updated: Updated])
• NextUCC (type: esriFieldTypeString, alias: Include in Next UCC Meeting?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PM_Name (type: esriFieldTypeString, alias: Project Manager (Last Name), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PM_Backup (type: esriFieldTypeString, alias: Back-up PM (Last Name), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Fund (type: esriFieldTypeString, alias: Fund, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Federal_Fund (type: esriFieldTypeString, alias: Federally Funded?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Consultant (type: esriFieldTypeString, alias: Design Consultant, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DES_Start (type: esriFieldTypeString, alias: Design Start Date, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LastSubmitPercent (type: esriFieldTypeString, alias: Last Submit Percent, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LastSubmitDate (type: esriFieldTypeString, alias: Last Submit Date, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NextSubmitPercent (type: esriFieldTypeString, alias: Next Submit Percent, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NextSubmitDate (type: esriFieldTypeString, alias: Next Submit Date, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DES_Finish (type: esriFieldTypeString, alias: Design Finish Date, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UTILRelocDeadline (type: esriFieldTypeString, alias: Utility Relocation Deadline, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Contractor (type: esriFieldTypeString, alias: Contractor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CON_Advert (type: esriFieldTypeString, alias: Construction Advertisement, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CON_NTP (type: esriFieldTypeString, alias: Notice To Proceed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CON_Finish (type: esriFieldTypeString, alias: Construction Finish, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
• Photo (type: esriFieldTypeString, alias: Photo/URL, SQL Type: sqlTypeOther, length: 1500, nullable: true, editable: true)
• Description (type: esriFieldTypeString, alias: Brief Project Description, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• PM_Email (type: esriFieldTypeString, alias: PM_Email, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PM_Phone (type: esriFieldTypeString, alias: PM_Phone, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Backup_Email (type: esriFieldTypeString, alias: Backup_Email, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Backup_Phone (type: esriFieldTypeString, alias: Backup_Phone, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DATASOURCE (type: esriFieldTypeString, alias: DATASOURCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Paved (type: esriFieldTypeString, alias: Paved, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Con_Finish_Date (type: esriFieldTypeDate, alias: Con_Finish_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ProjectStatus (type: esriFieldTypeString, alias: ProjectStatus, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Con_Begin_Date (type: esriFieldTypeDate, alias: Con_Begin_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Design_Begin_Date (type: esriFieldTypeDate, alias: Design_Begin_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FY_ConstructionBegin (type: esriFieldTypeString, alias: FY_ConstructionBegin, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FY_DesignBegin (type: esriFieldTypeString, alias: FY_DesignBegin, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DesignBegin (type: esriFieldTypeString, alias: DesignBegin, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ConstructionBegin (type: esriFieldTypeString, alias: ConstructionBegin, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DesignFinish (type: esriFieldTypeString, alias: DesignFinish, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ConstructionFinish (type: esriFieldTypeString, alias: ConstructionFinish, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UpdateSummary (type: esriFieldTypeString, alias: UpdateSummary, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
• URL (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
• LocationStatus (type: esriFieldTypeString, alias: LocationStatus, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ART_ELIGIBLE (type: esriFieldTypeString, alias: ART_ELIGIBLE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ART_BUNDLE (type: esriFieldTypeString, alias: ART_BUNDLE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Fed_Fund (type: esriFieldTypeString, alias: Fed_Fund, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RTA_Fund (type: esriFieldTypeString, alias: RTA_Fund, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• County_Fund (type: esriFieldTypeString, alias: County_Fund, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• HURF_Fund (type: esriFieldTypeString, alias: HURF_Fund, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PublicStatus (type: esriFieldTypeString, alias: PublicStatus, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Dept (type: esriFieldTypeString, alias: Dept, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IF_Fund (type: esriFieldTypeString, alias: IF_Fund, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• QCT_overlap (type: esriFieldTypeSmallInteger, alias: QCT_overlap, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 1
Name: 1,Design
Domains:

• Field Name: UCC_Update
  Inherited
  
• Field Name: NextUCC
  Inherited
  
• Field Name: Federal_Fund
  Inherited
  
Templates:

Name: 1,Design
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Status: Design
• QCT_overlap: 1
Name: 1,Planned
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Status: Planned
• QCT_overlap: 1

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/26/2023 8:45:31 PM

Schema Last Edit Date: 6/26/2023 8:45:31 PM

Data Last Edit Date: 6/26/2023 8:45:31 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat