Name: Site Work Orders

Display Field: NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: d2e38ad636d044188f5e4762c6113073

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SITE_ID ( type: esriFieldTypeDouble, alias: SITE_ID )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 50 , Coded Values: [ECP: ECP] , [BMP: BMP] , [IDDE: IDDE] , ...5 more... )
• ORACLE_ID ( type: esriFieldTypeInteger, alias: ORACLE_ID )
• INCIDENT_ID ( type: esriFieldTypeInteger, alias: INCIDENT_ID )
• ECP_REQ ( type: esriFieldTypeString, alias: ECP_REQ, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• ECP_APPROVED ( type: esriFieldTypeString, alias: ECP_APPROVED, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• PCRCP_REQ ( type: esriFieldTypeString, alias: PCRCP_REQ, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• PCRCP_APPROVED ( type: esriFieldTypeString, alias: PCRCP_APPROVED, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• CGP_REQ ( type: esriFieldTypeString, alias: CGP_REQ, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• TNR_NUMBER ( type: esriFieldTypeString, alias: TNR_NUMBER, length: 50 )
• ARAP_REQ ( type: esriFieldTypeString, alias: ARAP_REQ, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• ARAP_NUMBER ( type: esriFieldTypeString, alias: ARAP_NUMBER, length: 50 )
• PD_SD ( type: esriFieldTypeString, alias: PD_SD, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• BMP_INSPECTION_REQ ( type: esriFieldTypeString, alias: BMP_INSPECTION_REQ, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• CP_PENDING ( type: esriFieldTypeString, alias: CP_PENDING, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• CEASE_DESIST ( type: esriFieldTypeString, alias: CP_DESIST, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• INSPECTION_FREQ ( type: esriFieldTypeDouble, alias: INSPECTION_FREQ , Coded Values: [1: 1] , [7: 7] , [14: 14] , ...8 more... )
• DATE_OPENED ( type: esriFieldTypeDate, alias: DATE_OPENED, length: 8 )
• DATE_CLOSED ( type: esriFieldTypeDate, alias: DATE_CLOSED, length: 8 )
• DATE_REMOVED ( type: esriFieldTypeDate, alias: DATE_REMOVED, length: 8 )
• CONST_COMPLETED ( type: esriFieldTypeString, alias: CONST_COMPLETED, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• DISCHARGE ( type: esriFieldTypeString, alias: DISCHARGE, length: 50 , Coded Values: [P: Reported] , [O: Observed] , [D: Discharged] , ...1 more... )
• DISTURBED_ACRES ( type: esriFieldTypeDouble, alias: DISTURBED_ACRES )
• SITE_NAME ( type: esriFieldTypeString, alias: SITE_NAME, length: 50 )
• HISTORICAL_SITE ( type: esriFieldTypeString, alias: HISTORICAL_SITE, length: 50 )
• BMP_NAME ( type: esriFieldTypeString, alias: BMP_NAME, length: 50 )
• HISTORICAL_BMP ( type: esriFieldTypeString, alias: HISTORICAL_BMP, length: 50 )
• BMP_QUANT ( type: esriFieldTypeInteger, alias: BMP_QUANT , Range: [0, 99] )
• BMP_TYPE ( type: esriFieldTypeString, alias: BMP_TYPE, length: 50 , Coded Values: [SWALE: SWALE] , [DETENTION BASIN: DETENTION BASIN] , [RETENTION BASIN: RETENTION BASIN] , ...6 more... )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, length: 2000 )
• BMP_MAINT_STATUS ( type: esriFieldTypeString, alias: MAINT_STATUS, length: 50 , Coded Values: [MAINTAINED: MAINTAINED] , [UNMAINTAINED: UNMAINTAINED] , [CONSTRUCTION: CONSTRUCTION] , ...1 more... )
• BMP_LAT ( type: esriFieldTypeDouble, alias: BMP_LAT )
• BMP_LON ( type: esriFieldTypeDouble, alias: BMP_LON )
• APPROVAL_DATE ( type: esriFieldTypeDate, alias: APPROVAL_DATE, length: 8 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 50 , Coded Values: [Open: Open] , [Closed: Closed] , [In Progress: In Progress] , ...4 more... )
• PLAN_NAME ( type: esriFieldTypeString, alias: PLAN_NAME, length: 50 )
• ID ( type: esriFieldTypeString, alias: ID, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• AN ( type: esriFieldTypeString, alias: AN, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• NAME ( type: esriFieldTypeString, alias: NAME, length: 50 )
• COMPLAINT_SOURCE ( type: esriFieldTypeString, alias: COMPLAINT_SOURCE, length: 50 )
• RP_NAME ( type: esriFieldTypeString, alias: RP_NAME, length: 100 )
• RP_ADDRESS ( type: esriFieldTypeString, alias: RP_ADDRESS, length: 100 )
• RP_CITY ( type: esriFieldTypeString, alias: RP_CITY, length: 50 )
• RP_PHONE ( type: esriFieldTypeString, alias: RP_PHONE, length: 50 )
• MATERIAL ( type: esriFieldTypeDouble, alias: MATERIAL , Coded Values: [0: UNKNOWN] , [1: TRASH] , [2: CONSTRUCTION MATERIALS] , ...10 more... )
• CODE ( type: esriFieldTypeString, alias: CODE, length: 50 , Coded Values: [U1: Condo-Townhouse] , [U2: Apartment High-Rise] , [U3: Large SFR] , ...7 more... )
• SW_FEE_APPLIED ( type: esriFieldTypeString, alias: SW_FEE_APPLIED, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• SW_STATUS ( type: esriFieldTypeString, alias: STATUS, length: 50 , Coded Values: [OPEN: OPEN] , [CLOSED: CLOSED] , [REVIEW: REVIEW] , ...4 more... )
• BMP_INSP_REQ ( type: esriFieldTypeString, alias: BMP_INSP_REQ, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• IMPERVIOUS_AREA ( type: esriFieldTypeDouble, alias: IMPERVIOUS_AREA )
• CGP_RECEIPT ( type: esriFieldTypeString, alias: CGP_RECEIPT, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• REC_EDIT_MODE ( type: esriFieldTypeString, alias: REC_EDIT_MODE, length: 50 , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...1 more... )
• BMP2_NAME ( type: esriFieldTypeString, alias: BMP2_NAME, length: 50 )
• BMP2_LAT ( type: esriFieldTypeDouble, alias: BMP2_LAT )
• BMP2_LON ( type: esriFieldTypeDouble, alias: BMP2_LON )
• BMP2_TYPE ( type: esriFieldTypeString, alias: BMP2_TYPE, length: 50 , Coded Values: [SWALE: SWALE] , [DETENTION BASIN: DETENTION BASIN] , [RETENTION BASIN: RETENTION BASIN] , ...6 more... )
• BMP2_COMMENT ( type: esriFieldTypeString, alias: BMP2_COMMENT, length: 500 )
• BMP3_NAME ( type: esriFieldTypeString, alias: BMP3_NAME, length: 50 )
• BMP3_LAT ( type: esriFieldTypeDouble, alias: BMP3_LAT )
• BMP3_LON ( type: esriFieldTypeDouble, alias: BMP3_LON )
• BMP3_TYPE ( type: esriFieldTypeString, alias: BMP3_TYPE, length: 50 , Coded Values: [SWALE: SWALE] , [DETENTION BASIN: DETENTION BASIN] , [RETENTION BASIN: RETENTION BASIN] , ...6 more... )
• BMP3_COMMENT ( type: esriFieldTypeString, alias: BMP3_COMMENT, length: 500 )
• NEXT_INSPECTION_DATE ( type: esriFieldTypeDate, alias: NEXT_INSPECTION_DATE, length: 8 )
• SW_ZONE ( type: esriFieldTypeString, alias: SW_ZONE, length: 50 )
• LAST_INSPECTION_DATE ( type: esriFieldTypeDate, alias: LAST_INSPECTION_DATE, length: 8 )
• Acres ( type: esriFieldTypeDouble, alias: Acres )
• C90_INSPECTION_REQ ( type: esriFieldTypeString, alias: C90_INSPECTION_REQ, length: 30 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 100 )
• SPLIT_ZN_INITIALS ( type: esriFieldTypeString, alias: SPLIT_ZN_INITIALS, length: 10 )
• ACCELA_NUM ( type: esriFieldTypeString, alias: ACCELA_NUM, length: 50 )

Relationships:

• ORDERS_TO_ACTIVITIES (3) -- Related To: Work Order Activities (4)
• ORDERS_TO_SITES (0) -- Related To: All Site Locations (0)
• ORDERS_TO_SITES (2) -- Related To: SWPP Locations (2)

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

  Iteminfo   Thumbnail   Metadata