View In:   ArcGIS Online Map Viewer

Name: Public_Works.DBO.Outfall_Inventory

Display Field: OWNER_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: ab5aa710a44f47bfad0ab7a93428aba5

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1370299.2394040972
YMin: 446036.2735339254
XMax: 1394310.8370500952
YMax: 488810.1381172538
Spatial Reference: 2893  (2893)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Inspected
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: No
  Label: No
  Description: N/A
  Symbol:
  
• Value: Yes
  Label: Yes
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Feature Draw Order:

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

Type ID Field: Inspected

Fields:

• OBJECTID_12_13 ( modelName: OBJECTID_12_13, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID_12_13, type: esriFieldTypeOID )
• OBJECTID ( modelName: OBJECTID, nullable: true, editable: true, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeInteger )
• Bank ( modelName: Bank, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Bank, type: esriFieldTypeString )
• Flowing ( modelName: Flowing, nullable: true, editable: true, defaultValue: N/A, length: 5, alias: Flowing, type: esriFieldTypeString )
• Type_1 ( modelName: Type_1, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: Type_1, type: esriFieldTypeString )
• Material ( modelName: Material, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: Material, type: esriFieldTypeString )
• Shape_ ( modelName: Shape_, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Shape_, type: esriFieldTypeString )
• Number_ ( modelName: Number_, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: Number_, type: esriFieldTypeString )
• Diameter ( modelName: Diameter, nullable: true, editable: true, defaultValue: 0, alias: Diameter, type: esriFieldTypeSmallInteger )
• Submerged ( modelName: Submerged, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Submerged, type: esriFieldTypeString )
• Material_2 ( modelName: Material_2, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: Material_2, type: esriFieldTypeString )
• Shape_2 ( modelName: Shape_2, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Shape_2, type: esriFieldTypeString )
• Depth_ ( modelName: Depth_, nullable: true, editable: true, defaultValue: N/A, alias: Depth_, type: esriFieldTypeSmallInteger )
• Width_top ( modelName: Width_top, nullable: true, editable: true, defaultValue: N/A, alias: Width_top, type: esriFieldTypeSmallInteger )
• Width_bottom ( modelName: Width_bottom, nullable: true, editable: true, defaultValue: N/A, alias: Width_bottom, type: esriFieldTypeSmallInteger )
• Condition ( modelName: Condition, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: Condition, type: esriFieldTypeString )
• Odor ( modelName: Odor, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: Odor, type: esriFieldTypeString )
• Unnat_dep_st ( modelName: Unnat_dep_st, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: Unnat_dep_st, type: esriFieldTypeString )
• Veg_Dens ( modelName: Veg_Dens, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: Veg_Dens, type: esriFieldTypeString )
• Benthic_gr ( modelName: Benthic_gr, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: Benthic_gr, type: esriFieldTypeString )
• Pool_Qual ( modelName: Pool_Qual, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: Pool_Qual, type: esriFieldTypeString )
• Misc_Concern ( modelName: Misc_Concern, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: Misc_Concern, type: esriFieldTypeString )
• Flow_Color ( modelName: Flow_Color, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Flow_Color, type: esriFieldTypeString )
• Flow_Turbidity ( modelName: Flow_Turbidity, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: Flow_Turbidity, type: esriFieldTypeString )
• Flow_Floatables ( modelName: Flow_Floatables, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Flow_Floatables, type: esriFieldTypeString )
• Date_Collected ( modelName: Date_Collected, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Date_Collected, type: esriFieldTypeDate )
• Assessor ( modelName: Assessor, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Assessor, type: esriFieldTypeString )
• Diameter_T1 ( modelName: Diameter_T1, nullable: true, editable: true, defaultValue: 0, alias: Diameter_T1, type: esriFieldTypeInteger )
• Other_Notes ( modelName: Other_Notes, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: Other_Notes, type: esriFieldTypeString )
• Y_Coord ( modelName: Y_Coord, nullable: true, editable: true, defaultValue: N/A, alias: Y_Coord, type: esriFieldTypeDouble )
• X_Coord ( modelName: X_Coord, nullable: true, editable: true, defaultValue: N/A, alias: X_Coord, type: esriFieldTypeDouble )
• Photo_1 ( modelName: Photo_1, nullable: true, editable: true, defaultValue: N/A, length: 200, alias: Photo_1, type: esriFieldTypeString )
• QA_QC_Nov2015 ( modelName: QA_QC_Nov2015, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: QA_QC_Nov2015, type: esriFieldTypeString )
• QAQC_NoPic ( modelName: QAQC_NoPic, nullable: true, editable: true, defaultValue: N/A, length: 2, alias: QAQC_NoPic, type: esriFieldTypeString )
• PROP_ID ( modelName: PROP_ID, nullable: true, editable: true, defaultValue: -1, alias: PROP_ID, type: esriFieldTypeInteger )
• ACREAGE ( modelName: ACREAGE, nullable: true, editable: true, defaultValue: N/A, alias: ACREAGE, type: esriFieldTypeDouble )
• PROPERTYOID ( modelName: PROPERTYOID, nullable: true, editable: true, defaultValue: N/A, alias: PROPERTYOID, type: esriFieldTypeInteger )
• LDFOID ( modelName: LDFOID, nullable: true, editable: true, defaultValue: N/A, alias: LDFOID, type: esriFieldTypeInteger )
• ACCOUNT ( modelName: ACCOUNT, nullable: true, editable: true, defaultValue: N/A, length: 7, alias: ACCOUNT, type: esriFieldTypeString )
• ASSESS_DIST ( modelName: ASSESS_DIST, nullable: true, editable: true, defaultValue: N/A, length: 2, alias: ASSESS_DIST, type: esriFieldTypeString )
• LAND_AREA_ACRE ( modelName: LAND_AREA_ACRE, nullable: true, editable: true, defaultValue: N/A, alias: LAND_AREA_ACRE, type: esriFieldTypeDouble )
• LAND_AREA_SQFT ( modelName: LAND_AREA_SQFT, nullable: true, editable: true, defaultValue: N/A, alias: LAND_AREA_SQFT, type: esriFieldTypeDouble )
• PROPERTY_DESC ( modelName: PROPERTY_DESC, nullable: true, editable: true, defaultValue: N/A, length: 72, alias: PROPERTY_DESC, type: esriFieldTypeString )
• SUB_CODE ( modelName: SUB_CODE, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: SUB_CODE, type: esriFieldTypeString )
• PLAT_PARCEL ( modelName: PLAT_PARCEL, nullable: true, editable: true, defaultValue: N/A, length: 5, alias: PLAT_PARCEL, type: esriFieldTypeString )
• OWNER_NAME ( modelName: OWNER_NAME, nullable: true, editable: true, defaultValue: N/A, length: 36, alias: OWNER_NAME, type: esriFieldTypeString )
• ICO_NAME ( modelName: ICO_NAME, nullable: true, editable: true, defaultValue: N/A, length: 36, alias: ICO_NAME, type: esriFieldTypeString )
• MAIL_STREET ( modelName: MAIL_STREET, nullable: true, editable: true, defaultValue: N/A, length: 45, alias: MAIL_STREET, type: esriFieldTypeString )
• MAIL_CITY ( modelName: MAIL_CITY, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: MAIL_CITY, type: esriFieldTypeString )
• MAIL_STATE ( modelName: MAIL_STATE, nullable: true, editable: true, defaultValue: N/A, length: 2, alias: MAIL_STATE, type: esriFieldTypeString )
• MAIL_ZIP5 ( modelName: MAIL_ZIP5, nullable: true, editable: true, defaultValue: N/A, length: 5, alias: MAIL_ZIP5, type: esriFieldTypeString )
• MAIL_IND ( modelName: MAIL_IND, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: MAIL_IND, type: esriFieldTypeString )
• HOUSE_NUMBER ( modelName: HOUSE_NUMBER, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: HOUSE_NUMBER, type: esriFieldTypeString )
• STREET_NAME ( modelName: STREET_NAME, nullable: true, editable: true, defaultValue: N/A, length: 28, alias: STREET_NAME, type: esriFieldTypeString )
• STREET_TYPE ( modelName: STREET_TYPE, nullable: true, editable: true, defaultValue: N/A, length: 4, alias: STREET_TYPE, type: esriFieldTypeString )
• CITY ( modelName: CITY, nullable: true, editable: true, defaultValue: N/A, length: 28, alias: CITY, type: esriFieldTypeString )
• ZIP5 ( modelName: ZIP5, nullable: true, editable: true, defaultValue: N/A, length: 5, alias: ZIP5, type: esriFieldTypeString )
• STRUCTURE_SQ_FT ( modelName: STRUCTURE_SQ_FT, nullable: true, editable: true, defaultValue: N/A, length: 7, alias: STRUCTURE_SQ_FT, type: esriFieldTypeString )
• YEAR_BUILT ( modelName: YEAR_BUILT, nullable: true, editable: true, defaultValue: N/A, length: 4, alias: YEAR_BUILT, type: esriFieldTypeString )
• DEVELOPED ( modelName: DEVELOPED, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: DEVELOPED, type: esriFieldTypeString )
• EXEMPT_CLASS ( modelName: EXEMPT_CLASS, nullable: true, editable: true, defaultValue: N/A, length: 3, alias: EXEMPT_CLASS, type: esriFieldTypeString )
• EXEMPT_STATUS ( modelName: EXEMPT_STATUS, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: EXEMPT_STATUS, type: esriFieldTypeString )
• SCENIC_EASEMENT_IND ( modelName: SCENIC_EASEMENT_IND, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: SCENIC_EASEMENT_IND, type: esriFieldTypeString )
• DOS_ACCOUNT ( modelName: DOS_ACCOUNT, nullable: true, editable: true, defaultValue: N/A, length: 7, alias: DOS_ACCOUNT, type: esriFieldTypeString )
• PARENT_ACCOUNT ( modelName: PARENT_ACCOUNT, nullable: true, editable: true, defaultValue: N/A, length: 7, alias: PARENT_ACCOUNT, type: esriFieldTypeString )
• LDF_ID ( modelName: LDF_ID, nullable: true, editable: true, defaultValue: N/A, alias: LDF_ID, type: esriFieldTypeDouble )
• IN_CITY_LIMITS ( modelName: IN_CITY_LIMITS, nullable: true, editable: true, defaultValue: N/A, length: 5, alias: IN_CITY_LIMITS, type: esriFieldTypeString )
• NEIGHBORHOOD ( modelName: NEIGHBORHOOD, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: NEIGHBORHOOD, type: esriFieldTypeString )
• Full_Address ( modelName: Full_Address, nullable: true, editable: true, defaultValue: N/A, length: 65, alias: Full_Address, type: esriFieldTypeString )
• STArea__ ( modelName: Shape.STArea(), nullable: true, editable: true, defaultValue: N/A, alias: STArea(), type: esriFieldTypeDouble, required: true )
• STLength__ ( modelName: Shape.STLength(), nullable: true, editable: true, defaultValue: N/A, alias: STLength(), type: esriFieldTypeDouble, required: true )
• Resp_Party ( modelName: Resp_Party, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: Resp_Party, type: esriFieldTypeString )
• notes_2016Nov ( modelName: notes_2016Nov, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: notes_2016Nov, type: esriFieldTypeString )
• Priority ( modelName: Priority, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: Priority, type: esriFieldTypeString )
• Outfall_ID ( modelName: Outfall_ID, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: Outfall_ID, type: esriFieldTypeString )
• Maint_ID ( modelName: Maint_ID, nullable: true, editable: true, defaultValue: N/A, alias: Maint_ID, type: esriFieldTypeSmallInteger )
• OutfallsTo ( modelName: OutfallsTo, nullable: true, editable: true, defaultValue: N/A, length: 120, alias: OutfallsTo, type: esriFieldTypeString )
• Inspected ( modelName: Inspected, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: Inspected, type: esriFieldTypeString )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• FacilityID ( modelName: FacilityID, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: FacilityID, type: esriFieldTypeString )

Types:

ID: No
Name: No
Domains:
Templates:
• Name: No
  Description:
  Prototype:
  Benthic_gr: null
  MAIL_CITY: null
  STArea__: null
  ACREAGE: null
  Flow_Turbidity: null
  PROPERTYOID: null
  X_Coord: null
  PROPERTY_DESC: null
  Flow_Color: null
  OBJECTID: null
  ACCOUNT: null
  LDFOID: null
  Veg_Dens: null
  Diameter_T1: 0
  Pool_Qual: null
  YEAR_BUILT: null
  Full_Address: null
  notes_2016Nov: null
  Inspected: No
  MAIL_ZIP5: null
  LDF_ID: null
  Priority: null
  PROP_ID: -1
  MAIL_IND: null
  Outfall_ID: null
  PLAT_PARCEL: null
  MAIL_STREET: null
  Resp_Party: null
  ICO_NAME: null
  Width_bottom: null
  Flow_Floatables: null
  Other_Notes: null
  MAIL_STATE: null
  QA_QC_Nov2015: null
  QAQC_NoPic: null
  Type_1: null
  IN_CITY_LIMITS: null
  Odor: null
  DOS_ACCOUNT: null
  SUB_CODE: null
  HOUSE_NUMBER: null
  EXEMPT_CLASS: null
  Bank: null
  ASSESS_DIST: null
  Flowing: null
  Date_Collected: null
  Submerged: null
  STLength__: null
  FacilityID: null
  Depth_: null
  LAND_AREA_SQFT: null
  DEVELOPED: null
  STREET_TYPE: null
  OWNER_NAME: null
  Width_top: null
  STREET_NAME: null
  Material_2: null
  PARENT_ACCOUNT: null
  NEIGHBORHOOD: null
  OutfallsTo: null
  Shape_2: null
  Diameter: 0
  Condition: null
  EXEMPT_STATUS: null
  LAND_AREA_ACRE: null
  Y_Coord: null
  Misc_Concern: null
  Material: null
  Number_: null
  STRUCTURE_SQ_FT: null
  CITY: null
  Unnat_dep_st: null
  Shape_: null
  Maint_ID: null
  Photo_1: null
  Assessor: null
  SCENIC_EASEMENT_IND: null
  ZIP5: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Yes
Name: Yes
Domains:
Templates:
• Name: Yes
  Description:
  Prototype:
  Benthic_gr: null
  MAIL_CITY: null
  STArea__: null
  ACREAGE: null
  Flow_Turbidity: null
  PROPERTYOID: null
  X_Coord: null
  PROPERTY_DESC: null
  Flow_Color: null
  OBJECTID: null
  ACCOUNT: null
  LDFOID: null
  Veg_Dens: null
  Diameter_T1: 0
  Pool_Qual: null
  YEAR_BUILT: null
  Full_Address: null
  notes_2016Nov: null
  Inspected: Yes
  MAIL_ZIP5: null
  LDF_ID: null
  Priority: null
  PROP_ID: -1
  MAIL_IND: null
  Outfall_ID: null
  PLAT_PARCEL: null
  MAIL_STREET: null
  Resp_Party: null
  ICO_NAME: null
  Width_bottom: null
  Flow_Floatables: null
  Other_Notes: null
  MAIL_STATE: null
  QA_QC_Nov2015: null
  QAQC_NoPic: null
  Type_1: null
  IN_CITY_LIMITS: null
  Odor: null
  DOS_ACCOUNT: null
  SUB_CODE: null
  HOUSE_NUMBER: null
  EXEMPT_CLASS: null
  Bank: null
  ASSESS_DIST: null
  Flowing: null
  Date_Collected: null
  Submerged: null
  STLength__: null
  FacilityID: null
  Depth_: null
  LAND_AREA_SQFT: null
  DEVELOPED: null
  STREET_TYPE: null
  OWNER_NAME: null
  Width_top: null
  STREET_NAME: null
  Material_2: null
  PARENT_ACCOUNT: null
  NEIGHBORHOOD: null
  OutfallsTo: null
  Shape_2: null
  Diameter: 0
  Condition: null
  EXEMPT_STATUS: null
  LAND_AREA_ACRE: null
  Y_Coord: null
  Misc_Concern: null
  Material: null
  Number_: null
  STRUCTURE_SQ_FT: null
  CITY: null
  Unnat_dep_st: null
  Shape_: null
  Maint_ID: null
  Photo_1: null
  Assessor: null
  SCENIC_EASEMENT_IND: null
  ZIP5: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• Maintenance Records (0) -- Related To: Public_Works.DBO.Outfall_Inspection_Records (1)

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

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

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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