Name: RALEIGH.SWS_COLLECTION

Display Field: F_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2054405.34009589
YMin: 714789.954798549
XMax: 2148818.06728056
YMax: 808364.606559634
Spatial Reference: 102719 (2264)

Drawing Info:

{"renderer":{"authoringInfo":{"visualVariables":[{"type":"transparencyInfo","minSliderValue":0.080928500744047616,"maxSliderValue":288.84788139384921}]},"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[168,0,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,255,255,255],"width":0.75}},"visualVariables":[{"type":"transparencyInfo","valueExpressionTitle":"Custom","valueExpression":"var createdDate = $feature.CREATED_DATE;\nvar monthsOld = DateDiff(Now(), createdDate, 'months');\nreturn monthsOld * 3; // Adjust multiplier for gradual fade","stops":[{"value":0.080928500744047616,"transparency":70},{"value":288.84788139384921,"transparency":30}],"legendOptions":{"title":"Custom","showLegend":false}}]},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Time Info:

Start Time Field: CREATED_DATE
End Time Field: null
Track ID Field: null
Time Extent
[2/19/2025 1:08:57 PM UTC, 2/19/2025 1:08:57 PM UTC]

Time Reference: UTC
Time Interval: -1
Time Interval Units: esriTimeUnitsSeconds
Has Live Data: true
Export Options:

Use Time: true
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

Has Attachments: false

Has Geometry Properties: false

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)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SCORE (type: esriFieldTypeSmallInteger, alias: SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_NAME (type: esriFieldTypeString, alias: F_NAME, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• L_NAME (type: esriFieldTypeString, alias: L_NAME, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• STNO (type: esriFieldTypeInteger, alias: STNO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STPRE (type: esriFieldTypeString, alias: STPRE, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• STNAME (type: esriFieldTypeString, alias: STNAME, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• STTYPE (type: esriFieldTypeString, alias: STTYPE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• N7 (type: esriFieldTypeString, alias: N7, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• APT (type: esriFieldTypeString, alias: APT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• ZIPCODE (type: esriFieldTypeString, alias: ZIPCODE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 33, nullable: true, editable: true)
• ADDRESS_CI (type: esriFieldTypeString, alias: ADDRESS_CI, SQL Type: sqlTypeOther, length: 42, nullable: true, editable: true)
• SERVICEDAY (type: esriFieldTypeString, alias: SERVICEDAY, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SUPERVISOR (type: esriFieldTypeString, alias: SUPERVISOR, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• SEMIROUTE (type: esriFieldTypeString, alias: SEMIROUTE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• ACCOUNT_NU (type: esriFieldTypeInteger, alias: ACCOUNT_NU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ACCOUNT_ID (type: esriFieldTypeString, alias: ACCOUNT_ID, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• ITEM_TYPE (type: esriFieldTypeString, alias: ITEM_TYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• RECYCLE (type: esriFieldTypeString, alias: RECYCLE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• GARBAGE (type: esriFieldTypeString, alias: GARBAGE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• YARDWASTE (type: esriFieldTypeString, alias: YARDWASTE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• BAL_DAY (type: esriFieldTypeString, alias: BAL_DAY, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• CART_SIZ_1 (type: esriFieldTypeString, alias: CART_SIZ_1, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SER_WEEK (type: esriFieldTypeString, alias: SER_WEEK, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DAY_WEEK (type: esriFieldTypeString, alias: DAY_WEEK, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PHASE (type: esriFieldTypeString, alias: PHASE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• REC_SUP (type: esriFieldTypeSmallInteger, alias: REC_SUP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECYCLE_SS (type: esriFieldTypeString, alias: RECYCLE_SS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GARBAGE_SS (type: esriFieldTypeString, alias: GARBAGE_SS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• YW_SS (type: esriFieldTypeString, alias: YW_SS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• YW_SUP (type: esriFieldTypeDouble, alias: YW_SUP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• NEED_ASSIS (type: esriFieldTypeString, alias: NEED_ASSIS, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• REGION (type: esriFieldTypeString, alias: REGION, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• TEMP_REC (type: esriFieldTypeString, alias: TEMP_REC, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• TEMP_GAR (type: esriFieldTypeString, alias: TEMP_GAR, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• TEMP_YW (type: esriFieldTypeString, alias: TEMP_YW, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 15, 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)
• RTEOPTNEW (type: esriFieldTypeString, alias: RTEOPTNEW, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CSAID (type: esriFieldTypeInteger, alias: CSAID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REC_UNIT (type: esriFieldTypeSmallInteger, alias: REC_UNIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GAR_UNIT (type: esriFieldTypeSmallInteger, alias: GAR_UNIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MULTIFAMILY (type: esriFieldTypeString, alias: MULTIFAMILY, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• SP_ID_REC (type: esriFieldTypeString, alias: SP_ID_REC, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SP_ID_GAR (type: esriFieldTypeString, alias: SP_ID_GAR, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PREM_ID (type: esriFieldTypeString, alias: PREM_ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ACCT_ID (type: esriFieldTypeString, alias: ACCT_ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ACCT_EMAIL (type: esriFieldTypeString, alias: ACCT_EMAIL, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ACCT_PHONE (type: esriFieldTypeString, alias: ACCT_PHONE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ACCT_NAME (type: esriFieldTypeString, alias: ACCT_NAME, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• CITY_LIMITS (type: esriFieldTypeString, alias: CITY_LIMITS, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• G_SUBROUTE (type: esriFieldTypeString, alias: Garbage Sub Route, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• G_SUBSECTION (type: esriFieldTypeString, alias: G_SUBSECTION, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• R_SUBROUTE (type: esriFieldTypeString, alias: R_SUBROUTE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• YW_SUBROUTE (type: esriFieldTypeString, alias: Yard Waste Sub Route, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• YW_SUBSECTION (type: esriFieldTypeString, alias: YW_SUBSECTION, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• YW_WEEK (type: esriFieldTypeString, alias: YW_WEEK, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• R_SUBSECTION (type: esriFieldTypeString, alias: R_SUBSECTION, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• YW_AB_ROUTE (type: esriFieldTypeString, alias: YW_AB_ROUTE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• YW_AB_SUBSEC (type: esriFieldTypeString, alias: YW_AB_SUBSEC, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SERVICE_TYPE (type: esriFieldTypeString, alias: SERVICE_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Exception: Exception], [NAP: NAP], [Regular: Regular])
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• YARDWASTEBIN_OPT_OUT (type: esriFieldTypeString, alias: YARDWASTEBIN_OPT_OUT, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)

Templates:

Name: RALEIGH.SWS_COLLECTION
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/19/2025 1:38:17 PM

Schema Last Edit Date: 2/19/2025 1:38:17 PM

Data Last Edit Date: 2/19/2025 1:38:17 PM

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