Layers:

Layer: SW_SERVICE_REQUEST_ACCELA_20210507ProdData (0)

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)

Tables:

Table: StormWater.DBO.SW_Documents (1)

Name: StormWater.DBO.SW_Documents

Display Field: Record

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Record ( type: esriFieldTypeString, alias: Record, length: 255 )
• DocumentLink ( type: esriFieldTypeString, alias: DocumentLink, length: 255 )

Relationships:

• SW_SERVICE_REQUEST_ACCELA (0) -- Related To: SW_SERVICE_REQUEST_ACCELA_20210507ProdData (0)

Table: StormWater.DBO.SW_JournalNotes (2)

Name: StormWater.DBO.SW_JournalNotes

Display Field: Record

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Record ( type: esriFieldTypeString, alias: Record, length: 255 )
• Category ( type: esriFieldTypeString, alias: Category, length: 255 )
• Source ( type: esriFieldTypeString, alias: Source, length: 255 )
• Subject ( type: esriFieldTypeString, alias: Subject, length: 255 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• Created_By ( type: esriFieldTypeString, alias: Created_By, length: 255 )
• Created_Date ( type: esriFieldTypeDate, alias: Created_Date, length: 8 )
• Created_Time ( type: esriFieldTypeDate, alias: Created_Time, length: 8 )

Relationships:

• SW_SERVICE_REQUEST_ACCELA (1) -- Related To: SW_SERVICE_REQUEST_ACCELA_20210507ProdData (0)