Name: 2024 Final Resurfacing
Display Field: resurfStName
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: -78.727536726
YMin: 35.747636491
XMax: -78.5353407549999
YMax: 35.893712566
Spatial Reference: 4326 (4326)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[160,64,255,255],"width":1.5}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: true
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID_1
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- COR_STREET (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 253, nullable: true, editable: true)
- PLAN_YEAR (type: esriFieldTypeDouble, alias: Resurfacing Plan Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COR_CURB_N (type: esriFieldTypeDouble, alias: Curb Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PMS_TREATM (type: esriFieldTypeString, alias: Treatment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- LENGTH (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FUNCTIONAL (type: esriFieldTypeString, alias: Functional Class, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- COR_COUNCI (type: esriFieldTypeString, alias: City Council District, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- COR_LEAF_I (type: esriFieldTypeString, alias: Leaf ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- COR_MSD (type: esriFieldTypeString, alias: In MSD, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- COUNTY_ID (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- PMS_BUDGET (type: esriFieldTypeString, alias: Budget, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- MWP_PROJEC (type: esriFieldTypeString, alias: Project Status, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- COMMENT_ID (type: esriFieldTypeDouble, alias: Comment ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DATE_UPDAT (type: esriFieldTypeDate, alias: Date Updated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- COMMENT_ST (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 253, nullable: true, editable: true)
- COR_SURF_A (type: esriFieldTypeDouble, alias: COR_SURF_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TKG_PROJ_G (type: esriFieldTypeString, alias: TKG_PROJ_G, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- USER_UPDAT (type: esriFieldTypeString, alias: USER_UPDAT, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- IDNum (type: esriFieldTypeDouble, alias: IDNum, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Treatment (type: esriFieldTypeString, alias: Treatment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- reportDate (type: esriFieldTypeDate, alias: Date:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- resurfStName (type: esriFieldTypeString, alias: Resurface Street Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ALSTON ST: ALSTON ST], [ASBURY CR: ASBURY CR], [ATKINS DR: ATKINS DR], ... 90 more ...)
- JoinField (type: esriFieldTypeString, alias: JoinField, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- fromNote (type: esriFieldTypeString, alias: From:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- toNote (type: esriFieldTypeString, alias: To:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- lzNote (type: esriFieldTypeString, alias: Leaf Zone:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- inspectorName (type: esriFieldTypeString, alias: Inspector:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Colwell: Colwell], [Terenyi: Terenyi], [Caddell: Caddell], ... 5 more ...)
- lengthFT (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
- widthFT (type: esriFieldTypeDouble, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
- sqYards (type: esriFieldTypeDouble, alias: Main Street Square Yards, SQL Type: sqlTypeOther, nullable: true, editable: true)
- sqYardsNotes (type: esriFieldTypeString, alias: Main Street Calculation Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- culdesacSqYds (type: esriFieldTypeDouble, alias: Cul-De-Sac Square Yards, SQL Type: sqlTypeOther, nullable: true, editable: true)
- culdesacSqYdsNotes (type: esriFieldTypeString, alias: Cul-De-Sac Calculation Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- totalSqYds (type: esriFieldTypeDouble, alias: Total Square Yards, SQL Type: sqlTypeOther, nullable: true, editable: true)
- percentPatch (type: esriFieldTypeInteger, alias: Percent Patching needed, SQL Type: sqlTypeOther, nullable: true, editable: true)
- sqYardsPatch (type: esriFieldTypeDouble, alias: Patching Square Yards Estimate, SQL Type: sqlTypeOther, nullable: true, editable: true)
- manholesCount (type: esriFieldTypeInteger, alias: Number of Manholes, SQL Type: sqlTypeOther, nullable: true, editable: true)
- waterValvesCount (type: esriFieldTypeInteger, alias: Number of Water Valves, SQL Type: sqlTypeOther, nullable: true, editable: true)
- sewerTestStationsCount (type: esriFieldTypeInteger, alias: Number of Sewer Test Stations, SQL Type: sqlTypeOther, nullable: true, editable: true)
- oversizedManholesCount (type: esriFieldTypeInteger, alias: Number of Oversize Manholes, SQL Type: sqlTypeOther, nullable: true, editable: true)
- gasValvesCount (type: esriFieldTypeInteger, alias: Number of Gas Valves, SQL Type: sqlTypeOther, nullable: true, editable: true)
- speedBumpCount (type: esriFieldTypeInteger, alias: Number of Speed Bumps, SQL Type: sqlTypeOther, nullable: true, editable: true)
- millSelection (type: esriFieldTypeString, alias: Mill Selection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Full Mill: Full Mill], [Edge Mill: Edge Mill], [Mill & Fill: Mill & Fill], ... 1 more ...)
- asphaltInGutter (type: esriFieldTypeString, alias: Asphalt In Gutter?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- asphaltaboveGutter (type: esriFieldTypeString, alias: For Full Mill Streets: Is Asphalt above Gutter Pan?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- pavementmarkings (type: esriFieldTypeString, alias: Are there existing pavement markings?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- pvmtmarkingnotes (type: esriFieldTypeString, alias: Describe approximate marking length/type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- signalloops (type: esriFieldTypeString, alias: Are there existing signal loops?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- signalloopnotes (type: esriFieldTypeString, alias: Describe length/quantity of loops present and any issues., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- inDowntown (type: esriFieldTypeString, alias: Is this in the Downtown Business District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- onStreetParkingIssues (type: esriFieldTypeString, alias: Are there on street parking issues?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- StParking_Notes (type: esriFieldTypeString, alias: On street parking issues notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- schoolOnStreet (type: esriFieldTypeString, alias: Is there a school on this street?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- IsBusroute (type: esriFieldTypeString, alias: Is there a bus route on this street?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- TreeNRootIssues (type: esriFieldTypeString, alias: Are there tree branch or root Issues on this street?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- ConcreteDWissues (type: esriFieldTypeString, alias: Are there concrete driveway issues on this street?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- UtilityIssues (type: esriFieldTypeString, alias: Are there utility issues on this street?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- DWissuesSqYd (type: esriFieldTypeDouble, alias: Concrete Driveway Issues Square Yards, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fiveFtSidewalk (type: esriFieldTypeInteger, alias: 5' wide sidewalk, SQL Type: sqlTypeOther, nullable: true, editable: true)
- fourFtSidewalk (type: esriFieldTypeInteger, alias: 4' wide sidewalk, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Ramps (type: esriFieldTypeInteger, alias: Number of Sidewalk Ramps, SQL Type: sqlTypeOther, nullable: true, editable: true)
- concreteCurbAndgutter (type: esriFieldTypeInteger, alias: Remove & Replace Concrete Curb and Gutter (Street Only), SQL Type: sqlTypeOther, nullable: true, editable: true)
- graniteCurbAndgutter (type: esriFieldTypeInteger, alias: Remove & Replace Granite Curb and Gutter (Street Only), SQL Type: sqlTypeOther, nullable: true, editable: true)
- CnGDrngStrctr (type: esriFieldTypeInteger, alias: Remove & Replace Curb and Gutter Around Drainage Structure, SQL Type: sqlTypeOther, nullable: true, editable: true)
- addInspectionNotes (type: esriFieldTypeString, alias: Additional Inspection Notes, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- InspectionStatus (type: esriFieldTypeString, alias: Inspection Status:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Not Started: Not Started], [In Progress: In Progress], [Complete: Complete])
- OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- globalid (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
- Inspector_Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
- CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Creator_1 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
- EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Editor_1 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: 2024 Final Resurfacing
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/23/2024 6:20:21 PM
Schema Last Edit Date: 10/23/2024 6:20:21 PM
Data Last Edit Date: 2/20/2024 2:32:09 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat