Name: Inspection

Display Field: inspector_name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: bmp_app_type

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspector_name ( type: esriFieldTypeString, alias: Inspector Name, length: 75 , Coded Values: [Mitali Goel: Mitali Goel] , [Alec Gamez: Alec Gamez] , [Cesar Lopez: Cesar Lopez] , ...12 more... )
• inspection_date ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• inspection_type ( type: esriFieldTypeString, alias: Inspection Type, length: 75 , Coded Values: [Initial Inspection: Initial Inspection] , [Prior to Certificate of Occupancy: Prior to Certificate of Occupancy] , [Follow-up Inspection: Follow-up Inspection] , ...4 more... )
• weather_cond ( type: esriFieldTypeString, alias: Weather Condition, length: 50 , Coded Values: [cloudy: cloudy] , [overcast with chance of rain: overcast with chance of rain] , [raining: raining] , ...1 more... )
• bmp_assessment ( type: esriFieldTypeString, alias: BMP Assessment, length: 75 )
• is_bmp_effective ( type: esriFieldTypeString, alias: Is BMP Effective, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• is_workorder_required ( type: esriFieldTypeString, alias: Is Maintenace Required, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• describe_maint_required ( type: esriFieldTypeString, alias: describe_maint_required, length: 250 , Coded Values: [BSNVQM: Basin/Swale Non Vegetated - Quarterly Maintenance] , [BSNVAM: Basin/Swale Non Vegetated - Annual Maintenance] , [BSVQM: Basin/Swale Vegetated - Quarterly Maintenance] , ...19 more... )
• followup_inspection_required ( type: esriFieldTypeString, alias: followup_inspection_required, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• notes ( type: esriFieldTypeString, alias: Notes, length: 500 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• bmp_globelid_rel ( type: esriFieldTypeGUID, alias: bmp_globelid_rel, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• bmp_app_type ( type: esriFieldTypeSmallInteger, alias: Bmp Type )
• maint_activity ( type: esriFieldTypeString, alias: maint_activity, length: 100 )
• inspection_complete ( type: esriFieldTypeString, alias: inspection_complete, length: 20 , Coded Values: [Yes: Yes] , [No: No] )
• quantity ( type: esriFieldTypeDouble, alias: Quantity )
• unit_measure ( type: esriFieldTypeString, alias: Unit of Measurement, length: 25 )
• bmp_notes ( type: esriFieldTypeString, alias: bmp_notes, length: 500 )
• bmp_quantity ( type: esriFieldTypeDouble, alias: bmp_quantity )
• work_order_num ( type: esriFieldTypeString, alias: work_order_num, length: 50 )

Types:

ID: 1
Name: Basin/Swale-Media w/ underdrain (.25 Acre)
Domains:
• inspector_name:
  Inherited
• inspection_type:
  Inherited
• weather_cond:
  Inherited
• bmp_assessment:
  Coded Values: [1- Requires design review: 1- Requires design review] , [2- Faulty- Broken and need repair/replacement to function: 2- Faulty- Broken and need repair/replacement to function] , [3- Effective but requires maintenance: 3- Effective but requires maintenance] , ...2 more...
• is_bmp_effective:
  Inherited
• is_workorder_required:
  Inherited
• describe_maint_required:
  Inherited
• followup_inspection_required:
  Inherited
• maint_activity:
  Coded Values: [Basin/Swale Non Vegetated - Quarterly Maintenance (.25 acre): Basin/Swale Non Vegetated - Quarterly Maintenance (.25 acre)] , [Basin/Swale Non Vegetated - Annual Maintenance (.25 acre): Basin/Swale Non Vegetated - Annual Maintenance (.25 acre)] , [Basin/Swale Vegetated - Quarterly Maintenance (.25 acre): Basin/Swale Vegetated - Quarterly Maintenance (.25 acre)] , ...9 more...

---

ID: 2
Name: Basin/Swale Non-Vegetated (.25 Acre)
Domains:
• inspection_type:
  Inherited
• weather_cond:
  Inherited
• bmp_assessment:
  Coded Values: [1- Requires design review: 1- Requires design review] , [2- Faulty- Broken and need repair/replacement to function: 2- Faulty- Broken and need repair/replacement to function] , [3- Effective but requires maintenance: 3- Effective but requires maintenance] , ...2 more...
• is_bmp_effective:
  Inherited
• is_workorder_required:
  Inherited
• describe_maint_required:
  Inherited
• followup_inspection_required:
  Inherited
• maint_activity:
  Coded Values: [Basin/Swale Non Vegetated - Quarterly Maintenance (.25 acre): Basin/Swale Non Vegetated - Quarterly Maintenance (.25 acre)] , [Basin/Swale Non Vegetated - Annual Maintenance (.25 acre): Basin/Swale Non Vegetated - Annual Maintenance (.25 acre)] , [Basin Mulch remove & replacement (CY): Basin Mulch remove & replacement (CY)] , ...1 more...

---

ID: 3
Name: Basin/Swale Vegetated (.25 Acre)
Domains:
• inspection_type:
  Inherited
• weather_cond:
  Inherited
• bmp_assessment:
  Coded Values: [1- Requires design review: 1- Requires design review] , [2- Faulty- Broken and need repair/replacement to function: 2- Faulty- Broken and need repair/replacement to function] , [3- Effective but requires maintenance: 3- Effective but requires maintenance] , ...2 more...
• is_bmp_effective:
  Inherited
• is_workorder_required:
  Inherited
• describe_maint_required:
  Inherited
• followup_inspection_required:
  Inherited
• maint_activity:
  Coded Values: [Basin/Swale Vegetated - Quarterly Maintenance (.25 acre): Basin/Swale Vegetated - Quarterly Maintenance (.25 acre)] , [Basin/Swale Vegetated - Annual Maintenace (.25 acre): Basin/Swale Vegetated - Annual Maintenace (.25 acre)] , [Vegetation replacement (hydro-seed) (.25 acre): Vegetation replacement (hydro-seed) (.25 acre)] , ...4 more...

---

ID: 4
Name: Storm Filters (Each)
Domains:
• inspection_type:
  Inherited
• weather_cond:
  Inherited
• bmp_assessment:
  Coded Values: [1- Requires design review: 1- Requires design review] , [2- Faulty- Broken and need repair/replacement to function: 2- Faulty- Broken and need repair/replacement to function] , [3- Effective but requires maintenance: 3- Effective but requires maintenance] , ...2 more...
• is_bmp_effective:
  Inherited
• is_workorder_required:
  Inherited
• describe_maint_required:
  Inherited
• followup_inspection_required:
  Inherited
• maint_activity:
  Coded Values: [Storm Filters (inspection & cleaning) (Each Location): Storm Filters (inspection & cleaning) (Each Location)] , [Storm Filters (replacement) (Each Cartridge): Storm Filters (replacement) (Each Cartridge)] , [General labor (Hourly): General labor (Hourly)]

---

ID: 5
Name: Filterra (tree drain) (Each)
Domains:
• inspection_type:
  Inherited
• weather_cond:
  Inherited
• bmp_assessment:
  Coded Values: [1- Requires design review: 1- Requires design review] , [2- Faulty- Broken and need repair/replacement to function: 2- Faulty- Broken and need repair/replacement to function] , [3- Effective but requires maintenance: 3- Effective but requires maintenance] , ...2 more...
• is_bmp_effective:
  Inherited
• is_workorder_required:
  Inherited
• describe_maint_required:
  Inherited
• followup_inspection_required:
  Inherited
• maint_activity:
  Coded Values: [Tree replacement (tree 1-15 gal.) (Each Plant): Tree replacement (tree 1-15 gal.) (Each Plant)] , [Tree replacement (tree 24 gal box) (Each Plant): Tree replacement (tree 24 gal box) (Each Plant)] , [Filterra Maintenance (Each Plant): Filterra Maintenance (Each Plant)] , ...2 more...

---

ID: 6
Name: Pervious Concrete/Asphalt (SF)
Domains:
• inspection_type:
  Inherited
• weather_cond:
  Inherited
• bmp_assessment:
  Coded Values: [1- Requires design review: 1- Requires design review] , [2- Faulty- Broken and need repair/replacement to function: 2- Faulty- Broken and need repair/replacement to function] , [3- Effective but requires maintenance: 3- Effective but requires maintenance] , ...2 more...
• is_bmp_effective:
  Inherited
• is_workorder_required:
  Inherited
• describe_maint_required:
  Inherited
• followup_inspection_required:
  Inherited
• maint_activity:
  Coded Values: [Pervious Concrete/Asphalt Maintenance (SF): Pervious Concrete/Asphalt Maintenance (SF)] , [Pervious Concrete replacement (SF): Pervious Concrete replacement (SF)] , [Pervious Asphalt replacement (SF): Pervious Asphalt replacement (SF)] , ...1 more...

---

ID: 7
Name: Pervious Pavers (SF)
Domains:
• inspection_type:
  Inherited
• weather_cond:
  Inherited
• bmp_assessment:
  Coded Values: [1- Requires design review: 1- Requires design review] , [2- Faulty- Broken and need repair/replacement to function: 2- Faulty- Broken and need repair/replacement to function] , [3- Effective but requires maintenance: 3- Effective but requires maintenance] , ...2 more...
• is_bmp_effective:
  Inherited
• is_workorder_required:
  Inherited
• describe_maint_required:
  Inherited
• followup_inspection_required:
  Inherited
• maint_activity:
  Coded Values: [Pervious Pavers Maintenance (SF): Pervious Pavers Maintenance (SF)] , [General labor (Hourly): General labor (Hourly)]

---

ID: 8
Name: Drain Filters/Baskets (various types) (Each)
Domains:
• inspection_type:
  Inherited
• weather_cond:
  Inherited
• bmp_assessment:
  Coded Values: [1- Requires design review: 1- Requires design review] , [2- Faulty- Broken and need repair/replacement to function: 2- Faulty- Broken and need repair/replacement to function] , [3- Effective but requires maintenance: 3- Effective but requires maintenance] , ...2 more...
• is_bmp_effective:
  Inherited
• is_workorder_required:
  Inherited
• describe_maint_required:
  Inherited
• followup_inspection_required:
  Inherited
• maint_activity:
  Coded Values: [Device repairs & replacement (Parts and labor): Device repairs & replacement (Parts and labor)] , [General labor (Hourly): General labor (Hourly)] , [Clean Drain Filters/Baskets + replace filter/media (various types) (Each Filter Basket): Clean Drain Filters/Baskets + replace filter/media (various types) (Each Filter Basket)]

---

ID: 9
Name: Stormceptor/Sandfilter (Each)
Domains:
• inspection_type:
  Inherited
• weather_cond:
  Inherited
• bmp_assessment:
  Coded Values: [1- Requires design review: 1- Requires design review] , [2- Faulty- Broken and need repair/replacement to function: 2- Faulty- Broken and need repair/replacement to function] , [3- Effective but requires maintenance: 3- Effective but requires maintenance] , ...2 more...
• is_bmp_effective:
  Inherited
• is_workorder_required:
  Inherited
• describe_maint_required:
  Inherited
• followup_inspection_required:
  Inherited
• maint_activity:
  Coded Values: [Stormceptor/Sandfilter (Each Location): Stormceptor/Sandfilter (Each Location)] , [General labor (Hourly): General labor (Hourly)]

---

ID: 10
Name: CDS (Each)
Domains:
• inspection_type:
  Inherited
• weather_cond:
  Inherited
• bmp_assessment:
  Coded Values: [1- Requires design review: 1- Requires design review] , [2- Faulty- Broken and need repair/replacement to function: 2- Faulty- Broken and need repair/replacement to function] , [3- Effective but requires maintenance: 3- Effective but requires maintenance] , ...2 more...
• is_bmp_effective:
  Inherited
• is_workorder_required:
  Inherited
• describe_maint_required:
  Inherited
• followup_inspection_required:
  Inherited
• maint_activity:
  Coded Values: [General labor (Hourly): General labor (Hourly)] , [CDS (Each Location): CDS (Each Location)]

---

ID: 11
Name: Infiltration Cistern (Each)
Domains:
• inspection_type:
  Inherited
• weather_cond:
  Inherited
• bmp_assessment:
  Coded Values: [1- Requires design review: 1- Requires design review] , [2- Faulty- Broken and need repair/replacement to function: 2- Faulty- Broken and need repair/replacement to function] , [3- Effective but requires maintenance: 3- Effective but requires maintenance] , ...2 more...
• is_bmp_effective:
  Inherited
• is_workorder_required:
  Inherited
• describe_maint_required:
  Inherited
• followup_inspection_required:
  Inherited
• maint_activity:
  Coded Values: [Infiltration Cistern (TBD): Infiltration Cistern (TBD)] , [General labor (Hourly): General labor (Hourly)]

---

ID: 12
Name: Debris Boom (Each)
Domains:
• inspection_type:
  Inherited
• weather_cond:
  Inherited
• bmp_assessment:
  Coded Values: [1- Requires design review: 1- Requires design review] , [2- Faulty- Broken and need repair/replacement to function: 2- Faulty- Broken and need repair/replacement to function] , [3- Effective but requires maintenance: 3- Effective but requires maintenance] , ...2 more...
• is_bmp_effective:
  Inherited
• is_workorder_required:
  Inherited
• describe_maint_required:
  Inherited
• followup_inspection_required:
  Inherited
• maint_activity:
  Coded Values: [General labor (Hourly): General labor (Hourly)] , [Debris Boom Cleaning (Each Location): Debris Boom Cleaning (Each Location)] , [Device repairs & replacement (Parts and Labor): Device repairs & replacement (Parts and Labor)]

---

Relationships:

• bmp_maintenance_history (2) -- Related To: Maintenance (5)
• bmp_point (1) -- Related To: BMP Point (0)

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

  Iteminfo   Thumbnail   Metadata