Name: Site Work Orders

Display Field: NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: a67272d575bc452bbc960d45d79e7dd0

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: true
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: false
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:

Fields:

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

Templates:

• Name: Site Work Orders
  Description:
  Prototype:
  SPLIT_ZN_INITIALS: null
  ACCELA_NUM: null
  SITE_ID: null
  TYPE: null
  ORACLE_ID: null
  INCIDENT_ID: null
  ECP_REQ: null
  ECP_APPROVED: null
  PCRCP_REQ: null
  PCRCP_APPROVED: null
  CGP_REQ: null
  TNR_NUMBER: null
  ARAP_REQ: null
  ARAP_NUMBER: null
  PD_SD: null
  BMP_INSPECTION_REQ: null
  CP_PENDING: null
  CEASE_DESIST: null
  INSPECTION_FREQ: null
  DATE_OPENED: null
  DATE_CLOSED: null
  DATE_REMOVED: null
  CONST_COMPLETED: null
  DISCHARGE: null
  DISTURBED_ACRES: null
  SITE_NAME: null
  HISTORICAL_SITE: null
  BMP_NAME: null
  HISTORICAL_BMP: null
  BMP_QUANT: null
  BMP_TYPE: null
  COMMENT: null
  BMP_MAINT_STATUS: null
  BMP_LAT: null
  BMP_LON: null
  APPROVAL_DATE: null
  STATUS: null
  PLAN_NAME: null
  ID: null
  AN: null
  NAME: null
  COMPLAINT_SOURCE: null
  RP_NAME: null
  RP_ADDRESS: null
  RP_CITY: null
  RP_PHONE: null
  MATERIAL: null
  CODE: null
  SW_FEE_APPLIED: null
  SW_STATUS: null
  BMP_INSP_REQ: null
  IMPERVIOUS_AREA: null
  CGP_RECEIPT: null
  REC_EDIT_MODE: null
  BMP2_NAME: null
  BMP2_LAT: null
  BMP2_LON: null
  BMP2_TYPE: null
  BMP2_COMMENT: null
  BMP3_NAME: null
  BMP3_LAT: null
  BMP3_LON: null
  BMP3_TYPE: null
  BMP3_COMMENT: null
  NEXT_INSPECTION_DATE: null
  SW_ZONE: null
  LAST_INSPECTION_DATE: null
  Acres: null
  C90_INSPECTION_REQ: null
  ADDRESS: null
  
  Drawing Tool: esriFeatureEditToolNone

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)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata