Name: GIS.GISADMIN.dOutfallInspection

Display Field: SUBWATERSHED

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 10000

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SUBWATERSHED ( type: esriFieldTypeString, alias: Subwatershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBWATERSHED )
• OUTFALLID ( type: esriFieldTypeString, alias: Outfall ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OUTFALLID )
• INSPDATE ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPDATE )
• INSPTIME ( type: esriFieldTypeDate, alias: Inspection Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPTIME )
• INSPBY ( type: esriFieldTypeString, alias: Investigators, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPBY )
• AIRTEMP_F_ ( type: esriFieldTypeString, alias: Air Temp (F), editable: true, nullable: true, length: 10, defaultValue: null, modelName: AIRTEMP_F_ )
• RAINFALL_24_IN ( type: esriFieldTypeString, alias: Rainfall Last 24 hrs (in), editable: true, nullable: true, length: 10, defaultValue: null, modelName: RAINFALL_24_IN )
• RAINFALL_48_IN ( type: esriFieldTypeString, alias: Rainfall Last 48 (in), editable: true, nullable: true, length: 10, defaultValue: null, modelName: RAINFALL_48_IN )
• LANDUSE ( type: esriFieldTypeString, alias: Land Use, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LANDUSE , Coded Values: [INDUSTRIAL: Industrial] , [URBAN: Urban Residential] , [SUBURBAN: Suburban Residential] , ...4 more... )
• LU_OTH_DESC ( type: esriFieldTypeString, alias: Land Use Other Desc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LU_OTH_DESC )
• KNOW_IND ( type: esriFieldTypeString, alias: Know Industries, editable: true, nullable: true, length: 50, defaultValue: null, modelName: KNOW_IND )
• NOTES ( type: esriFieldTypeString, alias: Background data notes, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NOTES )
• OF_CP ( type: esriFieldTypeSmallInteger, alias: Outfall Location Closed Pipe, editable: true, nullable: true, defaultValue: 0, modelName: OF_CP , Coded Values: [1: Yes] , [0: No] )
• OF_CP_MAT ( type: esriFieldTypeString, alias: Outfall Closed Pipe Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OF_CP_MAT , Coded Values: [ACMP: Aluminized Corrugated Metal Pipe] , [CIC: Cast Iron Connector] , [CIP: Cast Iron Pipe] , ...22 more... )
• OF_CP_SHAPE ( type: esriFieldTypeString, alias: Outfall Closed Pipe Shape, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OF_CP_SHAPE , Coded Values: [CIRC: Circular] , [TRAP: Trapezoidal] , [OTH: Other] , ...3 more... )
• OF_CP_SHAPE2 ( type: esriFieldTypeString, alias: Outfall Closed Pipe Shape2, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OF_CP_SHAPE2 )
• OF_CP_DIA ( type: esriFieldTypeString, alias: Outfall Closed Pipe Diameter, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OF_CP_DIA )
• OF_CP_SUB_IW ( type: esriFieldTypeString, alias: Outfall Closed Pipe Submerged In Water, editable: true, nullable: true, length: 10, defaultValue: N, modelName: OF_CP_SUB_IW , Coded Values: [Y: Yes] , [N: No] )
• OF_CP_SUB_WS ( type: esriFieldTypeString, alias: Outfall Closed Pipe Submerged With Sediment, editable: true, nullable: true, length: 10, defaultValue: N, modelName: OF_CP_SUB_WS , Coded Values: [Y: Yes] , [N: No] )
• OF_OD ( type: esriFieldTypeSmallInteger, alias: Outfall Location Open Drainage, editable: true, nullable: true, defaultValue: 0, modelName: OF_OD , Coded Values: [1: Yes] , [0: No] )
• OF_OD_MAT ( type: esriFieldTypeString, alias: Outfall Open Drain Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OF_OD_MAT )
• OF_OD_SHAPE ( type: esriFieldTypeString, alias: Outfall Open Drian Shape, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OF_OD_SHAPE )
• OF_OD_DEPTH ( type: esriFieldTypeString, alias: Outfall Open Drian Depth, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OF_OD_DEPTH )
• OF_OD_TOP ( type: esriFieldTypeString, alias: Outfall Open Drian Top, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OF_OD_TOP )
• OF_OD_BOTTOM ( type: esriFieldTypeString, alias: Outfall Open Drain Bottom, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OF_OD_BOTTOM )
• OF_IN_STREAM ( type: esriFieldTypeSmallInteger, alias: Outfall In Stream, editable: true, nullable: true, defaultValue: 1, modelName: OF_IN_STREAM , Coded Values: [1: Yes] , [0: No] )
• OF_FLOW_PRESENT ( type: esriFieldTypeSmallInteger, alias: Outfall Flow Present, editable: true, nullable: true, defaultValue: 0, modelName: OF_FLOW_PRESENT , Coded Values: [1: Yes] , [0: No] )
• OF_FLOW_DESC ( type: esriFieldTypeString, alias: Outfall Flow Desc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OF_FLOW_DESC )
• FLOW_ODOR ( type: esriFieldTypeString, alias: Flow Odor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FLOW_ODOR , Coded Values: [SEWAGE: Sewage] , [SULFIDE: Sulfide] , [RANCID: Rancid/Sour] , ...2 more... )
• FLOW_COLOR ( type: esriFieldTypeString, alias: Flow Color, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FLOW_COLOR , Coded Values: [CLEAR: Clear] , [BROWN: Brown] , [GRAY: Gray] , ...5 more... )
• FLOW_TURBIDITY ( type: esriFieldTypeSmallInteger, alias: Flowing Turbidity, editable: true, nullable: true, defaultValue: 0, modelName: FLOW_TURBIDITY , Coded Values: [1: Yes] , [0: No] )
• FLOW_FLOATABLES ( type: esriFieldTypeString, alias: Flow Floatables, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FLOW_FLOATABLES , Coded Values: [SEWAGE: Sewage (toilet paper, etc)] , [PETROLEUM: Petroleum (oil sheen)] , [OTHER: Other] , ...1 more... )
• OF_DAMAGE_TYPE ( type: esriFieldTypeString, alias: Outfall Damage Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OF_DAMAGE_TYPE , Coded Values: [PEELING: Peeling Paint] , [SCC: Spalling, cracking, or chipping (CREATE WO)] , [OTHER: Other] , ...2 more... )
• OF_DEPOSIT_TYPE ( type: esriFieldTypeString, alias: Outfall Deposit Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OF_DEPOSIT_TYPE , Coded Values: [OILY: Oily] , [LINE: Flow Line] , [PAINT: Paint] , ...2 more... )
• OF_AB_VEG_TYPE ( type: esriFieldTypeString, alias: Outfall Abnormal Veg Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OF_AB_VEG_TYPE , Coded Values: [EXCESSIVE: Excessive] , [INHIBITED: Inhibited] , [CLEAR: Clear] )
• OF_POOL_QUALITY ( type: esriFieldTypeString, alias: Outfall Poor Pool Quality, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OF_POOL_QUALITY , Coded Values: [COLORS: Colors] , [ALGEA: Excessive Algea] , [FLOATABLES: Floatables] , ...6 more... )
• OF_BENTHIC_GROWTH ( type: esriFieldTypeString, alias: Outfall Benthic Growth, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OF_BENTHIC_GROWTH , Coded Values: [BROWN: Brown] , [GREEN: Green] , [ORANGE: Orange] , ...2 more... )
• OVERALL_CHARAC ( type: esriFieldTypeString, alias: Overall Outfall Characterization, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OVERALL_CHARAC , Coded Values: [NONE: Unlikely - No indication of illicit discharges] , [SOME: Potential - Some likelihood of illicit discharge (i.e., presence of 2 or more indicators)] , [EXISTS: Suspect - Almost certain a discharge exists (i.e., 1 or more indicator with a severity of 3)] , ...1 more... )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID )
• FeatureID ( type: esriFieldTypeString, alias: Feature ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FeatureID )
• OIDKEY ( type: esriFieldTypeInteger, alias: Outfall OID, editable: true, nullable: true, defaultValue: null, modelName: OIDKEY )
• CREATIONUSER ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 20, defaultValue: null, modelName: CREATIONUSER )
• DATECREATED ( type: esriFieldTypeDate, alias: Date Created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: Last Update, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATEMODIFIED )
• LASTUSER ( type: esriFieldTypeString, alias: Editor Name, editable: false, nullable: true, length: 20, defaultValue: null, modelName: LASTUSER )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Image ( type: esriFieldTypeString, alias: Image, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Image )
• FLOWTURB ( type: esriFieldTypeString, alias: FLOWTURB, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FLOWTURB , Coded Values: [Y: Yes] , [N: No] )
• OF_FLOWPRES ( type: esriFieldTypeString, alias: OF_FLOWPRES, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OF_FLOWPRES , Coded Values: [Y: Yes] , [N: No] )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GLOBALID )

Templates:

• Name: GIS.GISADMIN.dOutfallInspection
  Description:
  Prototype:
  OF_FLOWPRES: null
  FLOWTURB: null
  SUBWATERSHED: null
  OUTFALLID: null
  INSPDATE: null
  INSPTIME: null
  INSPBY: null
  AIRTEMP_F_: null
  RAINFALL_24_IN: null
  RAINFALL_48_IN: null
  LANDUSE: null
  LU_OTH_DESC: null
  KNOW_IND: null
  NOTES: null
  OF_CP: 0
  OF_CP_MAT: null
  OF_CP_SHAPE: null
  OF_CP_SHAPE2: null
  OF_CP_DIA: null
  OF_CP_SUB_IW: N
  OF_CP_SUB_WS: N
  OF_OD: 0
  OF_OD_MAT: null
  OF_OD_SHAPE: null
  OF_OD_DEPTH: null
  OF_OD_TOP: null
  OF_OD_BOTTOM: null
  OF_IN_STREAM: 1
  OF_FLOW_PRESENT: 0
  OF_FLOW_DESC: null
  FLOW_ODOR: null
  FLOW_COLOR: null
  FLOW_TURBIDITY: 0
  FLOW_FLOATABLES: null
  OF_DAMAGE_TYPE: null
  OF_DEPOSIT_TYPE: null
  OF_AB_VEG_TYPE: null
  OF_POOL_QUALITY: null
  OF_BENTHIC_GROWTH: null
  OVERALL_CHARAC: null
  AssetID: null
  FeatureID: null
  OIDKEY: null
  Image: null
  REL_GLOBALID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• dOutfall (0) -- Related To: SW Outfall (5)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: DATECREATED
• Creator Field: CREATIONUSER
• Edit Date Field: DATEMODIFIED
• Editor Field: LASTUSER

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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