Name: Street Sweeping Route Weekly

Display Field: FULLNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Road segments representing centerlines of all roadways or carriageways in a local government. Typically, this information is compiled from orthoimagery or other aerial photography sources. This representation of the road centerlines support address geocoding and mapping. It also serves as a source for public works and other agencies that are responsible for the active management of the road network.

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: 6328446.04541181
YMin: 1859751.28769973
XMax: 6362932.16869664
YMax: 1882820.4390679
Spatial Reference: 102646 (2230)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[140,140,140,255],"width":1}},"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:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CENTERLINEID (type: esriFieldTypeString, alias: Centerline ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FROMLEFT (type: esriFieldTypeInteger, alias: Left From Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOLEFT (type: esriFieldTypeInteger, alias: Left To Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FROMRIGHT (type: esriFieldTypeInteger, alias: Right From Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TORIGHT (type: esriFieldTypeInteger, alias: Right To Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FULLNAME (type: esriFieldTypeString, alias: Full Road Name, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• FEDROUTE (type: esriFieldTypeString, alias: Federal Route, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FEDRTETYPE (type: esriFieldTypeString, alias: Federal Route Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Freeway: Freeway], [Highway: Highway], [Interstate: Interstate], ... 2 more ...)
• STROUTE (type: esriFieldTypeString, alias: State Route, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• STRTETYPE (type: esriFieldTypeString, alias: State Route Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Freeway: Freeway], [Highway: Highway], [Interstate: Interstate], ... 2 more ...)
• ONEWAYDIR (type: esriFieldTypeString, alias: One Way Indicator, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [From-To: From-To], [To-From: To-From], [Unknown: Unknown], ... 5 more ...)
• ROADLEVEL (type: esriFieldTypeInteger, alias: Above or Below Grade, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-2: Second Subsurface], [-1: Subsurface], [0: Ground Level], ... 4 more ...)
• INWATER (type: esriFieldTypeString, alias: In Water, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Flag: Flag])
• ROADCLASS (type: esriFieldTypeString, alias: Road Class, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Freeway: Freeway], [Highway: Highway], [Ramp: Ramp], ... 11 more ...)
• MTFCC (type: esriFieldTypeString, alias: Census MTFCC Code, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• MUNILEFT (type: esriFieldTypeString, alias: Municipality on Left, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [El Cajon: El Cajon], [La Mesa: La Mesa], [Santee: Santee], ... 4 more ...)
• MUNIRIGHT (type: esriFieldTypeString, alias: Municipality on Right, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [El Cajon: El Cajon], [La Mesa: La Mesa], [Santee: Santee], ... 4 more ...)
• ZIPLEFT (type: esriFieldTypeString, alias: Zip on Left, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ZIPRIGHT (type: esriFieldTypeString, alias: Zip on Right, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• MSAGLEFT (type: esriFieldTypeString, alias: MSAG on Left, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• MSAGRIGHT (type: esriFieldTypeString, alias: MSAG on Right, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• ESNLEFT (type: esriFieldTypeString, alias: ESN on Left, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ESNRIGHT (type: esriFieldTypeString, alias: ESN on Right, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• LASTUPDATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTEDITOR (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PREDIR (type: esriFieldTypeString, alias: PREDIR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [N: N], [S: S], [E: E], ... 1 more ...)
• STNAME (type: esriFieldTypeString, alias: STNAME, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• STSUFFIX (type: esriFieldTypeString, alias: STSUFFIX, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [AVE: AVE], [BLVD: BLVD], [CIR: CIR], ... 15 more ...)
• STFULL (type: esriFieldTypeString, alias: STFULL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CIRELE (type: esriFieldTypeString, alias: Circulation Element, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• SEGCLASS (type: esriFieldTypeString, alias: Road Segment Classication, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ROW (type: esriFieldTypeSmallInteger, alias: Right Of Way Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STFULLGEOCODE (type: esriFieldTypeString, alias: ST FULL GEOCODE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SPEED (type: esriFieldTypeInteger, alias: SPEED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QCNeeded (type: esriFieldTypeString, alias: QC Needed, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• CollectionMethod (type: esriFieldTypeString, alias: Collection Method, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Temp (type: esriFieldTypeString, alias: Temp, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• CalTransFunClass (type: esriFieldTypeString, alias: CalTrans Fun Class, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• RRFunClass (type: esriFieldTypeString, alias: Road Register Functional Class, SQL Type: sqlTypeOther, length: 31, nullable: true, editable: true)
• MPH (type: esriFieldTypeInteger, alias: MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TIME (type: esriFieldTypeInteger, alias: TIME, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MaxHeight (type: esriFieldTypeInteger, alias: Max Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MaxWeight (type: esriFieldTypeInteger, alias: Max Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JOIN_ID (type: esriFieldTypeInteger, alias: JOIN_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• PDAliasName (type: esriFieldTypeString, alias: PD Alias Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OwnedBy (type: esriFieldTypeString, alias: Owned By, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• MaintainedBy (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• BRangeQC (type: esriFieldTypeString, alias: BLock Range QC, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• F_ZLev (type: esriFieldTypeSmallInteger, alias: From Z Level, SQL Type: sqlTypeOther, nullable: true, editable: true)
• T_ZLev (type: esriFieldTypeSmallInteger, alias: To Z Level, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NHSRdType (type: esriFieldTypeString, alias: NHS Road Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• SplitRdCl (type: esriFieldTypeString, alias: SplitRdCl, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Flag: Flag])
• Sweeper (type: esriFieldTypeString, alias: Sweeper, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Flag: Flag])
• SweeperRoute (type: esriFieldTypeString, alias: SweeperRoute, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3])
• SweeperType (type: esriFieldTypeString, alias: SweeperType, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Residential: Residential], [Commercial: Commercial], [Residential Median: Residential Median], ... 3 more ...)
• SweeperMedian (type: esriFieldTypeString, alias: SweeperMedian, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Flag: Flag])
• SweeperLot (type: esriFieldTypeString, alias: SweeperLot, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Flag: Flag])
• SweeperDuration (type: esriFieldTypeString, alias: SweeperDuration, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [TwiceWeekly: TwiceWeekly], [Weekly: Weekly], [TwiceMonthly: TwiceMonthly], ... 3 more ...)
• SweeperDay (type: esriFieldTypeString, alias: SweeperDay, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Monday: Monday], [Tuesday: Tuesday], [Wednesday: Wednesday], ... 5 more ...)
• SweeperWeek (type: esriFieldTypeString, alias: SweeperWeek, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 7 more ...)
• TrashDayOnLeft (type: esriFieldTypeString, alias: Trash Day On Left, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• TrashDayOnRight (type: esriFieldTypeString, alias: Trash Day On Right, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• OldSplitRdCl (type: esriFieldTypeString, alias: OldSplitRdCl, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Flag: Flag])
• OldSweeper (type: esriFieldTypeString, alias: OldSweeper, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Flag: Flag])
• OldSweeperRoute (type: esriFieldTypeString, alias: Old Sweeper Route, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3])
• OldSweeperType (type: esriFieldTypeString, alias: Old Sweeper Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Residential: Residential], [Commercial: Commercial], [Residential Median: Residential Median], ... 3 more ...)
• OldSweeperMedian (type: esriFieldTypeString, alias: Old Sweeper Median, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Flag: Flag])
• OldSweeperLot (type: esriFieldTypeString, alias: Old Sweeper Lot, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Flag: Flag])
• OldSweeperDuration (type: esriFieldTypeString, alias: Old Sweeper Duration, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [TwiceWeekly: TwiceWeekly], [Weekly: Weekly], [TwiceMonthly: TwiceMonthly], ... 3 more ...)
• OldSweeperDay (type: esriFieldTypeString, alias: OldSweeperDay, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Monday: Monday], [Tuesday: Tuesday], [Wednesday: Wednesday], ... 5 more ...)
• OldSweeperWeek (type: esriFieldTypeString, alias: Old Sweeper Week, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 7 more ...)
• OldTrashDayOnLeft (type: esriFieldTypeString, alias: Old Trash Day On Left, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Monday: Monday], [Tuesday: Tuesday], [Wednesday: Wednesday], ... 5 more ...)
• OldTrashDayOnRight (type: esriFieldTypeString, alias: Old Trash Day On Right, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Monday: Monday], [Tuesday: Tuesday], [Wednesday: Wednesday], ... 5 more ...)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• QC_Needed (type: esriFieldTypeString, alias: QC_Needed, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Flag: Flag])
• BikeLane (type: esriFieldTypeString, alias: Bike Lane, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Flag: Flag])
• ConCatTotal (type: esriFieldTypeString, alias: ConCatTotal, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Label (type: esriFieldTypeString, alias: Label, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• MedianPerimeter (type: esriFieldTypeDouble, alias: Median Perimeter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• SweeperMedianDay (type: esriFieldTypeString, alias: SweeperMedianDay, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• SweeperMedianWeek (type: esriFieldTypeString, alias: SweeperMedianWeek, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• SweeperMonthly (type: esriFieldTypeString, alias: SweeperMonthly, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SweeperWeekly (type: esriFieldTypeString, alias: SweeperWeekly, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SweeperTwiceWeekly (type: esriFieldTypeString, alias: SweeperTwiceWeekly, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Street Sweeping Route Weekly
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/6/2026 6:43:25 PM

Schema Last Edit Date: 10/6/2026 6:43:25 PM

Data Last Edit Date: 10/6/2026 6:43:25 PM

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