View In:   ArcGIS Online Map Viewer

Name: Municipal Drain Inspections

Display Field: drainreach_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 533017.9929
YMin: 4760710.8321
XMax: 557705.4506000001
YMax: 4785161.6457
Spatial Reference: 26917  (26917)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• fulcrum_id ( type: esriFieldTypeString, alias: fulcrum_id, editable: true, nullable: true, length: 100, defaultValue: null, modelName: fulcrum_id )
• created_at ( type: esriFieldTypeDate, alias: created_at, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_at )
• updated_at ( type: esriFieldTypeDate, alias: updated_at, editable: true, nullable: true, length: 8, defaultValue: null, modelName: updated_at )
• created_by ( type: esriFieldTypeString, alias: created_by, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: created_by )
• updated_by ( type: esriFieldTypeString, alias: updated_by, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: updated_by )
• system_created_at ( type: esriFieldTypeDate, alias: system_created_at, editable: true, nullable: true, length: 8, defaultValue: null, modelName: system_created_at )
• system_updated_at ( type: esriFieldTypeDate, alias: system_updated_at, editable: true, nullable: true, length: 8, defaultValue: null, modelName: system_updated_at )
• version ( type: esriFieldTypeInteger, alias: version, editable: true, nullable: true, defaultValue: null, modelName: version )
• status ( type: esriFieldTypeString, alias: status, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: status , Coded Values: [I: INFRASTRUCTURE] , [O: OBSTRUCTION] , [IO: INFRASTRUCTURE/OBSTRUCTION] )
• latitude ( type: esriFieldTypeDouble, alias: latitude, editable: true, nullable: true, defaultValue: null, modelName: latitude )
• longitude ( type: esriFieldTypeDouble, alias: longitude, editable: true, nullable: true, defaultValue: null, modelName: longitude )
• record_description ( type: esriFieldTypeString, alias: record_description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: record_description )
• single_multiple ( type: esriFieldTypeString, alias: single_multiple, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: single_multiple , Coded Values: [S: SINGLE] , [M: MULTIPLE] )
• multiple_feature_description ( type: esriFieldTypeString, alias: multiple_feature_description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: multiple_feature_description )
• drainreach_name ( type: esriFieldTypeString, alias: drainreach_name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: drainreach_name )
• utm_coordinates_wgs84 ( type: esriFieldTypeString, alias: utm_coordinates_wgs84, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: utm_coordinates_wgs84 )
• lot ( type: esriFieldTypeString, alias: lot, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: lot )
• concession ( type: esriFieldTypeString, alias: concession, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: concession )
• geographic_township ( type: esriFieldTypeString, alias: geographic_township, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: geographic_township )
• address_sub_thoroughfare ( type: esriFieldTypeString, alias: address_sub_thoroughfare, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: address_sub_thoroughfare )
• address_thoroughfare ( type: esriFieldTypeString, alias: address_thoroughfare, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: address_thoroughfare )
• address_suite ( type: esriFieldTypeString, alias: address_suite, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: address_suite )
• address_locality ( type: esriFieldTypeString, alias: address_locality, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: address_locality )
• address_sub_admin_area ( type: esriFieldTypeString, alias: address_sub_admin_area, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: address_sub_admin_area )
• address_admin_area ( type: esriFieldTypeString, alias: address_admin_area, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: address_admin_area )
• address_postal_code ( type: esriFieldTypeString, alias: address_postal_code, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: address_postal_code )
• address_country ( type: esriFieldTypeString, alias: address_country, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: address_country )
• address_full ( type: esriFieldTypeString, alias: address_full, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: address_full )
• visit_date ( type: esriFieldTypeString, alias: visit_date, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: visit_date )
• visit_time ( type: esriFieldTypeString, alias: visit_time, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: visit_time )
• photos ( type: esriFieldTypeString, alias: photos, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: photos )
• photos_caption ( type: esriFieldTypeString, alias: photos_caption, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: photos_caption )
• photos_url ( type: esriFieldTypeString, alias: photos_url, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: photos_url )
• primary_feature_description ( type: esriFieldTypeString, alias: primary_feature_description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: primary_feature_description )
• primary_feature_description_oth ( type: esriFieldTypeString, alias: primary_feature_description_other, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: primary_feature_description_oth )
• material ( type: esriFieldTypeString, alias: material, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: material , Coded Values: [CSP: CSP - CORRUGATED STEEL PIPE] , [CDT: CDT - CONCRETE DRAINAGE TILE] , [PDT: PDT - PRIVATE DRAINAGE TILE] , ...9 more... )
• material_other ( type: esriFieldTypeString, alias: material_other, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: material_other )
• obstruction ( type: esriFieldTypeString, alias: obstruction, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: obstruction , Coded Values: [BANK: BANK SLUMPING] , [BEAV: BEAVER DAMN] , [BCON: BROKEN CONCRETE] , ...12 more... )
• obstruction_other ( type: esriFieldTypeString, alias: obstruction_other, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: obstruction_other )
• obs_pcnt ( type: esriFieldTypeString, alias: Portion Obstructed, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: obs_pcnt , Coded Values: [1: 5%] , [2: 10%] , [3: 25%] , ...3 more... )
• condition ( type: esriFieldTypeString, alias: condition, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: condition , Coded Values: [5: NEW] , [4: GOOD] , [3: FAIR] , ...2 more... )
• condition_other ( type: esriFieldTypeString, alias: condition_other, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: condition_other )
• shape_form ( type: esriFieldTypeString, alias: shape_form, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: shape_form , Coded Values: [C: CIRCULAR] , [A: ARCH] , [B: BOX] , ...2 more... )
• shape_other ( type: esriFieldTypeString, alias: shape_other, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: shape_other )
• size_cv ( type: esriFieldTypeString, alias: size_cv, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: size_cv , Coded Values: [100: 100] , [150: 150] , [200: 200] , ...21 more... )
• size_cb ( type: esriFieldTypeString, alias: size_cb, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: size_cb , Coded Values: [1: 600 x 600] , [2: 900 x 900] , [3: 900 x 1200] , ...2 more... )
• size_cb_other ( type: esriFieldTypeString, alias: size_cb_other, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: size_cb_other )
• length ( type: esriFieldTypeDouble, alias: length, editable: true, nullable: true, defaultValue: null, modelName: length )
• unit_of_measure_ln ( type: esriFieldTypeString, alias: unit_of_measure_ln, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: unit_of_measure_ln )
• diameterwidth ( type: esriFieldTypeDouble, alias: diameterwidth, editable: true, nullable: true, defaultValue: null, modelName: diameterwidth )
• unit_of_measure_dm ( type: esriFieldTypeString, alias: unit_of_measure_dm, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: unit_of_measure_dm )
• bank_side ( type: esriFieldTypeString, alias: bank_side, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: bank_side , Coded Values: [N: NORTH] , [E: EAST] , [S: SOUTH] , ...1 more... )
• grate_type ( type: esriFieldTypeString, alias: grate_type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: grate_type , Coded Values: [F: FLAT TOP] , [S: SLOPE TOP] , [B: BIRD CAGE] , ...1 more... )
• grate_type_other ( type: esriFieldTypeString, alias: grate_type_other, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: grate_type_other )
• rodent_grate ( type: esriFieldTypeString, alias: rodent_grate, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: rodent_grate , Coded Values: [Y: YES] , [N: NO] )
• notes ( type: esriFieldTypeString, alias: notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: notes )
• year_recorded_gv ( type: esriFieldTypeString, alias: year_recorded_gv, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: year_recorded_gv )
• time_stamp_visit ( type: esriFieldTypeString, alias: time_stamp_visit, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: time_stamp_visit )
• latitude_1 ( type: esriFieldTypeString, alias: latitude_1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: latitude_1 )
• longitude_1 ( type: esriFieldTypeString, alias: longitude_1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: longitude_1 )
• utm_zone ( type: esriFieldTypeString, alias: utm_zone, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: utm_zone )
• utm_easting ( type: esriFieldTypeString, alias: utm_easting, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: utm_easting )
• utm_northing ( type: esriFieldTypeString, alias: utm_northing, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: utm_northing )
• precision_ ( type: esriFieldTypeString, alias: precision, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: precision_ )
• usng ( type: esriFieldTypeString, alias: usng, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: usng )
• utmconvjs ( type: esriFieldTypeString, alias: utmconvjs, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: utmconvjs )
• usng2js ( type: esriFieldTypeString, alias: usng2js, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: usng2js )
• feature ( type: esriFieldTypeString, alias: Features, editable: true, nullable: true, length: 255, defaultValue: null, modelName: feature , Coded Values: [1: CROSSINGS] , [2: CHANNEL FEATURES] , [3: FIELD FEATURES] , ...1 more... )
• subfeature1 ( type: esriFieldTypeString, alias: Crossings (If Applicable), editable: true, nullable: true, length: 255, defaultValue: null, modelName: subfeature1 , Coded Values: [ACUL: ACCESS CULVERT] , [AGCR: AT-GRADE CROSSING] , [FBRG: FOOT BRIDGE] , ...2 more... )
• subfeature2 ( type: esriFieldTypeString, alias: Channel Features (If Applicable), editable: true, nullable: true, length: 255, defaultValue: null, modelName: subfeature2 , Coded Values: [BSEE: BANK SEEPAGE] , [CHAN: CHANNEL REINFORCEMENT] , [CHUT: CHUTE/DROP STRUCTURE] , ...12 more... )
• subfeature3 ( type: esriFieldTypeString, alias: Field Features (If Applicable), editable: true, nullable: true, length: 255, defaultValue: null, modelName: subfeature3 , Coded Values: [BERM: BERM] , [FEED: FEED BUNKER] , [FREN: FRENCH DRAIN] , ...8 more... )
• InspectionType ( type: esriFieldTypeString, alias: InspectionType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectionType , Coded Values: [Pre-Con: Pre-Construction] , [During Con: During Construction] , [Capital: Capital] )
• DeficiencyType ( type: esriFieldTypeString, alias: Deficiency Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DeficiencyType , Coded Values: [Tile Outlet: Tile Outlet] , [Brushing: Brushing] , [Leveling: Leveling] , ...6 more... )
• Deficiency_Other ( type: esriFieldTypeString, alias: Deficiency Other, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Deficiency_Other )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Inspection_Type ( type: esriFieldTypeString, alias: Inspection_Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Inspection_Type , Coded Values: [Feature: Feature] , [Obstruction: Obstruction] )
• Inspect_Type_OB_F ( type: esriFieldTypeString, alias: Inspect_Type_OB_F, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Inspect_Type_OB_F )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Municipal Drain Inspections
  Description:
  Prototype:
  Inspect_Type_OB_F: null
  fulcrum_id: null
  created_at: null
  updated_at: null
  created_by: null
  updated_by: null
  system_created_at: null
  system_updated_at: null
  version: null
  status: null
  latitude: null
  longitude: null
  record_description: null
  single_multiple: null
  multiple_feature_description: null
  drainreach_name: null
  utm_coordinates_wgs84: null
  lot: null
  concession: null
  geographic_township: null
  address_sub_thoroughfare: null
  address_thoroughfare: null
  address_suite: null
  address_locality: null
  address_sub_admin_area: null
  address_admin_area: null
  address_postal_code: null
  address_country: null
  address_full: null
  visit_date: null
  visit_time: null
  photos: null
  photos_caption: null
  photos_url: null
  primary_feature_description: null
  primary_feature_description_oth: null
  material: null
  material_other: null
  obstruction: null
  obstruction_other: null
  obs_pcnt: null
  condition: null
  condition_other: null
  shape_form: null
  shape_other: null
  size_cv: null
  size_cb: null
  size_cb_other: null
  length: null
  unit_of_measure_ln: null
  diameterwidth: null
  unit_of_measure_dm: null
  bank_side: null
  grate_type: null
  grate_type_other: null
  rodent_grate: null
  notes: null
  year_recorded_gv: null
  time_stamp_visit: null
  latitude_1: null
  longitude_1: null
  utm_zone: null
  utm_easting: null
  utm_northing: null
  precision_: null
  usng: null
  utmconvjs: null
  usng2js: null
  feature: null
  subfeature1: null
  subfeature2: null
  subfeature3: null
  InspectionType: null
  DeficiencyType: null
  Deficiency_Other: null
  InspectionDate: null
  Inspection_Type: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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