Name: GISADMIN.StreetSweepingRoutes

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Person responsible for the data (as of September 2013): Frank Foster, Operations Manager, PWA Keep Oakland Clean and Beautiful (KOCB)Subject Matter Experts (as of September 2013): Art Watson and Robert Newman, supervisors, Keep Oakland Clean and BeautifulPerson responsible for the data in GIS (as of September 2013): Noushin AdabiIn 2013, PWA KOCB worked with a GIS intern to replace older, erroneous GIS data with correct data. Data was taken from paper-based maps and tables, and translated to GIS. KOCB staff did intial QC on the data. Further QC identified by Noushin Adabi, performed by KOCB, and updated in GIS by Noushin Adabi.;

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 6027573.32815084
YMin: 2081670.59320976
XMax: 6094722.66957732
YMax: 2148911.99349931
Spatial Reference: 102643 (2227)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,48,145,255],"width":1},"label":"","description":""},"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)
• DYNAMAP_ID (type: esriFieldTypeDouble, alias: DYNAMAP_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• L_F_ADD (type: esriFieldTypeString, alias: L_F_ADD, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• L_T_ADD (type: esriFieldTypeString, alias: L_T_ADD, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• R_F_ADD (type: esriFieldTypeString, alias: R_F_ADD, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• R_T_ADD (type: esriFieldTypeString, alias: R_T_ADD, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• PREFIX (type: esriFieldTypeString, alias: PREFIX, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• SUFFIX (type: esriFieldTypeString, alias: SUFFIX, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• FCC (type: esriFieldTypeString, alias: FCC, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• POSTAL_L (type: esriFieldTypeString, alias: POSTAL_L, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• POSTAL_R (type: esriFieldTypeString, alias: POSTAL_R, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ACC (type: esriFieldTypeString, alias: ACC, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• NAME_TYPE (type: esriFieldTypeString, alias: NAME_TYPE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SHIELD (type: esriFieldTypeString, alias: SHIELD, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• HWY_NUM (type: esriFieldTypeString, alias: HWY_NUM, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SEG_LEN (type: esriFieldTypeDouble, alias: SEG_LEN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPEED (type: esriFieldTypeSmallInteger, alias: SPEED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ONE_WAY (type: esriFieldTypeString, alias: ONE_WAY, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• F_ZLEV (type: esriFieldTypeSmallInteger, alias: F_ZLEV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• T_ZLEV (type: esriFieldTypeSmallInteger, alias: T_ZLEV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FT_COST (type: esriFieldTypeDouble, alias: FT_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TF_COST (type: esriFieldTypeDouble, alias: TF_COST, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FT_DIR (type: esriFieldTypeString, alias: FT_DIR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• TF_DIR (type: esriFieldTypeString, alias: TF_DIR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• NAME_FLAG (type: esriFieldTypeSmallInteger, alias: NAME_FLAG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ROUTE (type: esriFieldTypeString, alias: ROUTE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• DAY_ODD (type: esriFieldTypeString, alias: DAY_ODD, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [E: Everyday], [N-S: No Signage], [N: No Sweeping (Exempt)], ... 48 more ...)
• TIME_ODD (type: esriFieldTypeString, alias: TIME_ODD, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [M2: 3:00AM-6:00AM], [M3: 9:00AM-12:00PM], [A1: 12:30PM-3:30PM], ... 4 more ...)
• DAY_EVEN (type: esriFieldTypeString, alias: DAY_EVEN, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [E: Everyday], [N-S: No Signage], [N: No Sweeping (Exempt)], ... 48 more ...)
• TIME_EVEN (type: esriFieldTypeString, alias: TIME_EVEN, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [M2: 3:00AM-6:00AM], [M3: 9:00AM-12:00PM], [A1: 12:30PM-3:30PM], ... 4 more ...)
• MAPNO (type: esriFieldTypeString, alias: MAPNO, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• DOUBLECK (type: esriFieldTypeString, alias: DOUBLECK, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SIDEOFSTREET (type: esriFieldTypeString, alias: SIDEOFSTREET, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: GISADMIN.StreetSweepingRoutes
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/12/2025 5:21:29 PM

Schema Last Edit Date: 3/12/2025 5:21:29 PM

Data Last Edit Date: 10/19/2020 4:13:34 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat