Name: SW_SERVICE_REQUEST_ACCELA_20210507ProdData

Display Field: RecordAddress

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature class is created by a weekly job, which does the following:Deletes records from SW_SERVICE_REQUEST_ACCELAGeocodes addresses from SW_SERVICE_REQUEST_ACCELA_VIEW (view created from data in SQL02V\SQL02INST Accela) using the Parcels Streets Geo geocoding serviceAppends matched or tied geocoding results to SW_SERVICE_REQUEST_ACCELARetains the geocoding results (SW_SERVICE_REQUEST_ACCELA_VIEW_geocode) to create SQL report showing missing or unmatched addresses

Copyright Text: IT Solutions

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 500000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2251426.617968753
YMin: 6885923.790625006
XMax: 2417216.834765628
YMax: 7065939.8125
Spatial Reference: 102738  (2276)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [161, 27, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• RecordAddress ( type: esriFieldTypeString, alias: Record Address, length: 100 )
• Service_Order_Number ( type: esriFieldTypeString, alias: Service Order Number, length: 20 )
• Open_Date ( type: esriFieldTypeDate, alias: Open Date, length: 8 )
• Closed_Date ( type: esriFieldTypeDate, alias: Closed Date, length: 8 )
• Record_Priority ( type: esriFieldTypeString, alias: Record Priority, length: 20 )
• Record_Status ( type: esriFieldTypeString, alias: Record Status, length: 30 )
• Created_By ( type: esriFieldTypeString, alias: Created By, length: 50 )
• Assigned_to_Staff ( type: esriFieldTypeString, alias: Assigned to Staff, length: 50 )
• Child_Record_Exists ( type: esriFieldTypeString, alias: Child Record Exists, length: 5 )
• Detailed_Description ( type: esriFieldTypeString, alias: Detailed Description, length: 4000 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• SW_Documents (0) -- Related To: StormWater.DBO.SW_Documents (1)
• SW_JournalNotes (1) -- Related To: StormWater.DBO.SW_JournalNotes (2)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata