Layers:

Layer: UST Tank Facility for report (1)

Name: UST Tank Facility for report

Display Field: FacilityName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 10000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: -1.135915216E7
YMin: 4438172.934799999
XMax: -1.05312468431E7
YMax: 4866174.789899997
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Facility_Compliance
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: In Compliance
  Label: In Compliance
  Description: N/A
  Symbol:
  
• Value: Out of Compliance
  Label: Out of Compliance
  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: Facility_Compliance

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, length: 8, defaultValue: null, modelName: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FacilityID )
• FacilityName ( type: esriFieldTypeString, alias: Facility Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FacilityName )
• TypeFacility ( type: esriFieldTypeString, alias: Type Facility, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TypeFacility )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Address )
• County ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: County )
• KDHEDistrict ( type: esriFieldTypeString, alias: KDHEDistrict, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: KDHEDistrict )
• Coordinates ( type: esriFieldTypeString, alias: Coordinates, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Coordinates )
• ownerIdFormatted ( type: esriFieldTypeString, alias: ownerIdFormatted, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ownerIdFormatted )
• ownerName ( type: esriFieldTypeString, alias: owner Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ownerName )
• ustpermitnumber ( type: esriFieldTypeString, alias: UST Permit Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ustpermitnumber )
• ustpermitstatus ( type: esriFieldTypeString, alias: UST Permit Status, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ustpermitstatus )
• USTPermitIssueDate ( type: esriFieldTypeString, alias: UST Permit Issue Date, editable: true, nullable: true, length: 30, defaultValue: null, modelName: USTPermitIssueDate )
• USTPermitEfctvDate ( type: esriFieldTypeString, alias: UST Permit Efctv Date, editable: true, nullable: true, length: 30, defaultValue: null, modelName: USTPermitEfctvDate )
• USTPermitExprDate ( type: esriFieldTypeString, alias: UST Permit Expr Date, editable: true, nullable: true, length: 30, defaultValue: null, modelName: USTPermitExprDate )
• astpermitnumber ( type: esriFieldTypeString, alias: AST Permit Number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: astpermitnumber )
• astpermitstatus ( type: esriFieldTypeString, alias: AST Permit Status, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: astpermitstatus )
• astpermitissuedate ( type: esriFieldTypeString, alias: AST Permit Issue Date, editable: true, nullable: true, length: 30, defaultValue: null, modelName: astpermitissuedate )
• astpermitefctvdate ( type: esriFieldTypeString, alias: AST Permit Efctv Date, editable: true, nullable: true, length: 30, defaultValue: null, modelName: astpermitefctvdate )
• astpermitexprdate ( type: esriFieldTypeString, alias: AST Permit Expr Date, editable: true, nullable: true, length: 30, defaultValue: null, modelName: astpermitexprdate )
• LinkFacilityReport ( type: esriFieldTypeString, alias: LinkFacilityReport, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LinkFacilityReport )
• LinkOwnerReport ( type: esriFieldTypeString, alias: LinkOwnerReport, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LinkOwnerReport )
• MapSymbol1 ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MapSymbol1 )
• Financial_Tanks ( type: esriFieldTypeString, alias: Financial Tanks, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Financial_Tanks )
• Financial_ExpireDate ( type: esriFieldTypeString, alias: Financial ExpireDate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Financial_ExpireDate )
• Financial_Status ( type: esriFieldTypeString, alias: Financial Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Financial_Status )
• Financial_Explain ( type: esriFieldTypeString, alias: Financial Explain, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Financial_Explain )
• Facility_Compliance ( type: esriFieldTypeString, alias: Facility Compliance, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Facility_Compliance )
• FacilityID_NUM ( type: esriFieldTypeInteger, alias: FacilityID_NUM, editable: true, nullable: true, defaultValue: null, modelName: FacilityID_NUM )
• OwnerID_NUM ( type: esriFieldTypeInteger, alias: OwnerID_NUM, editable: true, nullable: true, defaultValue: null, modelName: OwnerID_NUM )
• LinkTankDetails ( type: esriFieldTypeString, alias: LinkTankDetails, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LinkTankDetails )
Types:
ID: In Compliance
Name: In Compliance
Domains:
Templates:
• Name: In Compliance
  Description:
  Prototype:
  OwnerID_NUM: null
  LinkTankDetails: null
  FacilityID: null
  FacilityName: null
  TypeFacility: null
  Address: null
  County: null
  KDHEDistrict: null
  Coordinates: null
  ownerIdFormatted: null
  ownerName: null
  ustpermitnumber: null
  ustpermitstatus: null
  USTPermitIssueDate: null
  USTPermitEfctvDate: null
  USTPermitExprDate: null
  astpermitnumber: null
  astpermitstatus: null
  astpermitissuedate: null
  astpermitefctvdate: null
  astpermitexprdate: null
  LinkFacilityReport: null
  LinkOwnerReport: null
  MapSymbol1: null
  Financial_Tanks: null
  Financial_ExpireDate: null
  Financial_Status: null
  Financial_Explain: null
  Facility_Compliance: In Compliance
  FacilityID_NUM: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Out of Compliance
Name: Out of Compliance
Domains:
Templates:
• Name: Out of Compliance
  Description:
  Prototype:
  OwnerID_NUM: null
  LinkTankDetails: null
  FacilityID: null
  FacilityName: null
  TypeFacility: null
  Address: null
  County: null
  KDHEDistrict: null
  Coordinates: null
  ownerIdFormatted: null
  ownerName: null
  ustpermitnumber: null
  ustpermitstatus: null
  USTPermitIssueDate: null
  USTPermitEfctvDate: null
  USTPermitExprDate: null
  astpermitnumber: null
  astpermitstatus: null
  astpermitissuedate: null
  astpermitefctvdate: null
  astpermitexprdate: null
  LinkFacilityReport: null
  LinkOwnerReport: null
  MapSymbol1: null
  Financial_Tanks: null
  Financial_ExpireDate: null
  Financial_Status: null
  Financial_Explain: null
  Facility_Compliance: Out of Compliance
  FacilityID_NUM: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• SDE.BER_TANK_COMP_FACILITY_PERMIT_RULE_mdltbl_4relate (0) -- Related To: Facility Permit Rule (17)
• SDE.BER_TANK_COMP_FACILITY_COMPLY_RULE_mdltbl_4relate (1) -- Related To: Facility Compliance Rule (16)
• SDE.BER_TANK_COMP_FACILITY_ABOPERATORS_static_4relate (2) -- Related To: Facility AB Operators (15)

Tables:

Table: Facility AB Operators (15)

Name: Facility AB Operators

Display Field: Operator_Name

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 10000

MaxSelectionCount: 0

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

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, length: 8, defaultValue: null, modelName: OBJECTID )
• Operator_Name ( type: esriFieldTypeString, alias: Operator Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Operator_Name )
• Operator_ID ( type: esriFieldTypeString, alias: Operator ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Operator_ID )
• Certification_Status ( type: esriFieldTypeString, alias: Certification Status, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Certification_Status )
• Certification_Effective_Date ( type: esriFieldTypeString, alias: Effective Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Certification_Effective_Date )
• Certification_Expire_Date ( type: esriFieldTypeString, alias: Expire Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Certification_Expire_Date )
• FacilityID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FacilityID )
• Owner_ID ( type: esriFieldTypeString, alias: Owner ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Owner_ID )
• FacilityID_NUM ( type: esriFieldTypeInteger, alias: FacilityID_NUM, editable: true, nullable: true, defaultValue: null, modelName: FacilityID_NUM )
• OwnerID_NUM ( type: esriFieldTypeInteger, alias: OwnerID_NUM, editable: true, nullable: true, defaultValue: null, modelName: OwnerID_NUM )
Templates:
• Name: Facility AB Operators
  Description:
  Prototype:
  FacilityID_NUM: null
  OwnerID_NUM: null
  Operator_Name: null
  Operator_ID: null
  Certification_Status: null
  Certification_Effective_Date: null
  Certification_Expire_Date: null
  FacilityID: null
  Owner_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SDE.BER_TANK_COMP_FACILITY_ACTIVE_POINT_STATIC_4REPORT (2) -- Related To: UST Tank Facility for report (1)

Table: Facility Compliance Rule (16)

Name: Facility Compliance Rule

Display Field: FacilityName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 10000

MaxSelectionCount: 0

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

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FacilityName ( type: esriFieldTypeString, alias: FacilityName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FacilityName )
• OwnerID ( type: esriFieldTypeString, alias: Owner ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OwnerID )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FacilityID )
• Comp_Rule1 ( type: esriFieldTypeString, alias: Compliance Rule/Item, editable: true, nullable: false, length: 51, defaultValue: null, modelName: Comp_Rule1 )
• Comp_Apply_To2 ( type: esriFieldTypeString, alias: Compliance Applies to, editable: true, nullable: false, length: 21, defaultValue: null, modelName: Comp_Apply_To2 )
• Affected_Tanks3 ( type: esriFieldTypeString, alias: Affected Tanks, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: Affected_Tanks3 )
• affected_Basin4 ( type: esriFieldTypeString, alias: Affected Spill Basins, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: affected_Basin4 )
• affected_lines5 ( type: esriFieldTypeString, alias: Affected Lines, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: affected_lines5 )
• affected_dispenser6 ( type: esriFieldTypeString, alias: Affected Dispensers, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: affected_dispenser6 )
• TestDate7 ( type: esriFieldTypeString, alias: Test Date, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TestDate7 )
• DueDate8 ( type: esriFieldTypeString, alias: Due Date, editable: true, nullable: true, length: 30, defaultValue: null, modelName: DueDate8 )
• Comply_Status9 ( type: esriFieldTypeString, alias: Compliance Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comply_Status9 )
• Comply_explain10 ( type: esriFieldTypeString, alias: Explanation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comply_explain10 )
• prmtNum ( type: esriFieldTypeString, alias: Permit Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: prmtNum )
• FacilityID_NUM ( type: esriFieldTypeInteger, alias: FacilityID_NUM, editable: true, nullable: true, defaultValue: null, modelName: FacilityID_NUM )
• OwnerID_NUM ( type: esriFieldTypeInteger, alias: OwnerID_NUM, editable: true, nullable: true, defaultValue: null, modelName: OwnerID_NUM )
Templates:
• Name: Facility Compliance Rule
  Description:
  Prototype:
  FacilityID_NUM: null
  OwnerID_NUM: null
  FacilityName: null
  OwnerID: null
  FacilityID: null
  Comp_Rule1:
  Comp_Apply_To2:
  Affected_Tanks3: null
  affected_Basin4: null
  affected_lines5: null
  affected_dispenser6: null
  TestDate7: null
  DueDate8: null
  Comply_Status9: null
  Comply_explain10: null
  prmtNum: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SDE.BER_TANK_COMP_FACILITY_ACTIVE_POINT_STATIC_4REPORT (1) -- Related To: UST Tank Facility for report (1)

Table: Facility Permit Rule (17)

Name: Facility Permit Rule

Display Field: FacilityName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 10000

MaxSelectionCount: 0

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

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, length: 8, defaultValue: null, modelName: OBJECTID )
• PermitItem ( type: esriFieldTypeString, alias: Permit Item, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PermitItem )
• FacilityName ( type: esriFieldTypeString, alias: Facility Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FacilityName )
• ownerid ( type: esriFieldTypeString, alias: Owner ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ownerid )
• FacilityID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FacilityID )
• Affected_Tanks ( type: esriFieldTypeString, alias: Affected Tanks, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Affected_Tanks )
• TestDate ( type: esriFieldTypeString, alias: Most recent Approved Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TestDate )
• PermitExplanation ( type: esriFieldTypeString, alias: Explanation, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PermitExplanation )
• FacilityID_NUM ( type: esriFieldTypeInteger, alias: FacilityID_NUM, editable: true, nullable: true, defaultValue: null, modelName: FacilityID_NUM )
• OwnerID_NUM ( type: esriFieldTypeInteger, alias: OwnerID_NUM, editable: true, nullable: true, defaultValue: null, modelName: OwnerID_NUM )
Templates:
• Name: Facility Permit Rule
  Description:
  Prototype:
  FacilityID_NUM: null
  OwnerID_NUM: null
  PermitItem: null
  FacilityName: null
  ownerid: null
  FacilityID: null
  Affected_Tanks: null
  TestDate: null
  PermitExplanation: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SDE.BER_TANK_COMP_FACILITY_ACTIVE_POINT_STATIC_4REPORT (0) -- Related To: UST Tank Facility for report (1)