View In:   ArcGIS Online Map Viewer

Name: doee.DOEE.General_Facility_2

Display Field: FACILITYNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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: 390624.4589009522
YMin: 127327.73000370942
XMax: 406432.02919925534
YMax: 146512.2842147369
Spatial Reference: 26985  (26985)

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

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• OUTFALLID ( type: esriFieldTypeString, alias: Outfall ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OUTFALLID )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Address )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Watershed , Coded Values: [Anacostia River: Anacostia River] , [Rock Creek: Rock Creek] , [Potomac River: Potomac River] , ...1 more... )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACID )
• SCHID_FK ( type: esriFieldTypeInteger, alias: Schedule ID, editable: true, nullable: true, defaultValue: null, modelName: SCHID_FK )
• DATE ( type: esriFieldTypeDate, alias: Date of inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date )
• FACILITYNAME ( type: esriFieldTypeString, alias: Facility Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Facility_Name )
• FACILITYSIZE ( type: esriFieldTypeString, alias: Facility Size, editable: true, nullable: true, length: 7, defaultValue: null, modelName: FACILITYSIZE , Coded Values: [Small: Small] , [Medium: Medium] , [Large: Large] )
• FACILITYOPERATIONS ( type: esriFieldTypeString, alias: Select a facility type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FACILITYOPERATIONS , Coded Values: [Restaurant: Restaurant] , [Solid Waste Management: Solid Waste Management] , [Scrap Yard: Scrap Yard] , ...16 more... )
• MASTERBUSINESSLICENSE ( type: esriFieldTypeSmallInteger, alias: Master Business License, editable: true, nullable: true, defaultValue: 1, modelName: Master_Business_Licnese , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• LICENSENUMBERMB ( type: esriFieldTypeString, alias: Master Business License Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: License_Number_Mb )
• EXPIRATIONDATEMB ( type: esriFieldTypeDate, alias: Master Business License Expiration Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Expiration_Date )
• OCCUPANCYLICENSE ( type: esriFieldTypeSmallInteger, alias: Occupancy Permit, editable: true, nullable: true, defaultValue: 1, modelName: Occupancy_License , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• LICENSENUMBEROC ( type: esriFieldTypeString, alias: Occupancy Permit Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: License_Number_Oc )
• DATEOFISSUE ( type: esriFieldTypeDate, alias: Occupancy Permit Issue Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Expiration_Date_Oc )
• PERMITS ( type: esriFieldTypeSmallInteger, alias: Does facility have NPDES permit, editable: true, nullable: true, defaultValue: 1, modelName: PERMITS , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• PERMITDESC ( type: esriFieldTypeString, alias: If yes, Multi-Sector General Permit or Individual Permit, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERMITDESC )
• FACILITYOPNAR ( type: esriFieldTypeString, alias: Facility operations description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FACILITYOPNAR )
• ODOR ( type: esriFieldTypeSmallInteger, alias: Odor, editable: true, nullable: true, defaultValue: 1, modelName: ODOR , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• ODORDESC ( type: esriFieldTypeString, alias: If yes, describe, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ODORDESC )
• DUST ( type: esriFieldTypeSmallInteger, alias: Excessive Dust, editable: true, nullable: true, defaultValue: 1, modelName: DUST , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• DUSTDESC ( type: esriFieldTypeString, alias: If yes, describe, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DUSTDESC )
• DEGRADEDSTREAM ( type: esriFieldTypeSmallInteger, alias: Degraded Stream in vicinity, editable: true, nullable: true, defaultValue: 1, modelName: DEGRADEDSTREAM , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• DEGRADEDSTREAMDESC ( type: esriFieldTypeString, alias: If yes, describe, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DEGRADEDSTREAMDESC )
• STRESSEDVEG ( type: esriFieldTypeSmallInteger, alias: Stressed vegetation, editable: true, nullable: true, defaultValue: 1, modelName: STRESSEDVEG , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• STRESSEDVEGDESC ( type: esriFieldTypeString, alias: If yes, describe, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STRESSEDVEGDESC )
• EVIDENCE ( type: esriFieldTypeSmallInteger, alias: Evidence of spills/releases, editable: true, nullable: true, defaultValue: 1, modelName: EVIDENCE , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• EVIDENCEDESC ( type: esriFieldTypeString, alias: If yes, describe, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EVIDENCEDESC )
• WASTEWATER ( type: esriFieldTypeSmallInteger, alias: Does facility generate wastewater, editable: true, nullable: true, defaultValue: 1, modelName: WASTEWATER , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• WATEWATERLOCATION ( type: esriFieldTypeString, alias: If yes, where is the wastewater discharged, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WATEWATERLOCATION , Coded Values: [Sanitary Sewer: Sanitary Sewer] , [MS4: MS4] , [Unknown: Unknown] , ...3 more... )
• WATEWATERLOCATION2 ( type: esriFieldTypeString, alias: If yes, where is the wastewater discharged, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WATEWATERLOCATION2 , Coded Values: [Sanitary Sewer: Sanitary Sewer] , [MS4: MS4] , [Unknown: Unknown] , ...3 more... )
• BMPSINSTALLED ( type: esriFieldTypeSmallInteger, alias: Does facility have BMPs for stormwater or wastewater, editable: true, nullable: true, defaultValue: 1, modelName: BMPSINSTALLED , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• BMPSLIST1 ( type: esriFieldTypeString, alias: Additional BMPs, editable: true, nullable: true, length: 75, defaultValue: null, modelName: BMPSLIST , Coded Values: [Oil/Grit Separator: Oil/Grit Separator] , [Bioretention Area, Rain Garden, or Constructed Wetland: Bioretention Area, Rain Garden, or Constructed Wetland] , [Dry Rentention Basin: Dry Rentention Basin] , ...5 more... )
• BMPSLIST2 ( type: esriFieldTypeString, alias: Additional BMPs, editable: true, nullable: true, length: 75, defaultValue: Not Applicable, modelName: BMPSLIST2 , Coded Values: [Oil/Grit Separator: Oil/Grit Separator] , [Bioretention Area, Rain Garden, or Constructed Wetland: Bioretention Area, Rain Garden, or Constructed Wetland] , [Dry Rentention Basin: Dry Rentention Basin] , ...5 more... )
• BMPSLIST3 ( type: esriFieldTypeString, alias: Additional BMPs, editable: true, nullable: true, length: 75, defaultValue: Not Applicable, modelName: BMPSLIST3 , Coded Values: [Oil/Grit Separator: Oil/Grit Separator] , [Bioretention Area, Rain Garden, or Constructed Wetland: Bioretention Area, Rain Garden, or Constructed Wetland] , [Dry Rentention Basin: Dry Rentention Basin] , ...5 more... )
• BMPSLIST4 ( type: esriFieldTypeString, alias: Additional BMPs, editable: true, nullable: true, length: 75, defaultValue: Not Applicable, modelName: BMPSLIST4 , Coded Values: [Oil/Grit Separator: Oil/Grit Separator] , [Bioretention Area, Rain Garden, or Constructed Wetland: Bioretention Area, Rain Garden, or Constructed Wetland] , [Dry Rentention Basin: Dry Rentention Basin] , ...5 more... )
• BMPSLIST5 ( type: esriFieldTypeString, alias: Additional BMPs, editable: true, nullable: true, length: 75, defaultValue: Not Applicable, modelName: BMPSLIST5 , Coded Values: [Oil/Grit Separator: Oil/Grit Separator] , [Bioretention Area, Rain Garden, or Constructed Wetland: Bioretention Area, Rain Garden, or Constructed Wetland] , [Dry Rentention Basin: Dry Rentention Basin] , ...5 more... )
• BMPSLIST6 ( type: esriFieldTypeString, alias: Additional BMPs, editable: true, nullable: true, length: 75, defaultValue: Not Applicable, modelName: BMPSLIST6 , Coded Values: [Oil/Grit Separator: Oil/Grit Separator] , [Bioretention Area, Rain Garden, or Constructed Wetland: Bioretention Area, Rain Garden, or Constructed Wetland] , [Dry Rentention Basin: Dry Rentention Basin] , ...5 more... )
• BMPSLIST7 ( type: esriFieldTypeString, alias: Additional BMPs, editable: true, nullable: true, length: 75, defaultValue: Not Applicable, modelName: BMPSLIST7 , Coded Values: [Oil/Grit Separator: Oil/Grit Separator] , [Bioretention Area, Rain Garden, or Constructed Wetland: Bioretention Area, Rain Garden, or Constructed Wetland] , [Dry Rentention Basin: Dry Rentention Basin] , ...5 more... )
• BMPSMAINTAINED ( type: esriFieldTypeSmallInteger, alias: Are BMPs properly maintained, editable: true, nullable: true, defaultValue: 1, modelName: BMPSMAINTAINED , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• BMPSMAINTAINEDDESC ( type: esriFieldTypeString, alias: If no, describe, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BMPSMAINTAINEDDESC )
• PRETREAT ( type: esriFieldTypeSmallInteger, alias: Does facility pre-treat wastewater, editable: true, nullable: true, defaultValue: 1, modelName: PRETREAT , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• PRETREATDESC ( type: esriFieldTypeString, alias: What type of pre-treatment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRETREATDESC )
• SAMPLE ( type: esriFieldTypeSmallInteger, alias: Does the facility analyze wastewater discharge, editable: true, nullable: true, defaultValue: 1, modelName: SAMPLE , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• HAZARDWASTE ( type: esriFieldTypeSmallInteger, alias: Does facility generate or store hazardous waste, editable: true, nullable: true, defaultValue: 1, modelName: HAZARDWASTE , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• HAZWASTEPERMIT ( type: esriFieldTypeSmallInteger, alias: Does facility have an EPA ID number, editable: true, nullable: true, defaultValue: 1, modelName: HAZWASTEPERMIT , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• DRAINS ( type: esriFieldTypeSmallInteger, alias: Does facility have floor drains in garage, editable: true, nullable: true, defaultValue: 1, modelName: DRAINS , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• DRAINSNUMBER ( type: esriFieldTypeSmallInteger, alias: If yes, how many, editable: true, nullable: true, defaultValue: null, modelName: DRAINSNUMBER )
• DRAINSDISCHARGE ( type: esriFieldTypeString, alias: Where do the floor drains discharge, editable: true, nullable: true, length: 25, defaultValue: null, modelName: DRAINSDISCHARGE , Coded Values: [Sanitary Sewer: Sanitary Sewer] , [MS4: MS4] , [Unknown: Unknown] , ...3 more... )
• PRECAUTIONDESC ( type: esriFieldTypeString, alias: Has the facility taken precautions to prevent fluids from entering floor drains, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRECAUTIONDESC )
• DISPOSAL ( type: esriFieldTypeString, alias: How are fluids disposed of, editable: true, nullable: true, length: 14, defaultValue: null, modelName: DISPOSAL , Coded Values: [Sanitary Sewer: Sanitary Sewer] , [MS4: MS4] , [Street/Lot: Street/Lot] , ...3 more... )
• CONTAINERS ( type: esriFieldTypeSmallInteger, alias: All wastes stored in labeled and sealed containers, editable: true, nullable: true, defaultValue: 1, modelName: CONTAINERS , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• CHEMICALS ( type: esriFieldTypeSmallInteger, alias: Evidence of chemicals or automotive fluids in a sink or other drain, editable: true, nullable: true, defaultValue: 1, modelName: CHEMICALS , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• CHEMICALDESC ( type: esriFieldTypeString, alias: If yes, describe, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CHEMICALDESC )
• POLLUTANTS ( type: esriFieldTypeSmallInteger, alias: Evidence of pollutants to water drainage, editable: true, nullable: true, defaultValue: 1, modelName: POLLUTANTS , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• POLLUTANTSDESC ( type: esriFieldTypeString, alias: If yes, description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: POLLUTANTSDESC )
• SWEEPINGS ( type: esriFieldTypeSmallInteger, alias: Are contaminated floor sweepings from sanding or other operations entering MS4, editable: true, nullable: true, defaultValue: 1, modelName: SWEEPINGS , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• SWEEPINGSDESC ( type: esriFieldTypeString, alias: If yes, describe, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SWEEPINGSDESC )
• SECONDARY ( type: esriFieldTypeSmallInteger, alias: Secondary containment for all stored hazmat and automotive fluids, editable: true, nullable: true, defaultValue: 1, modelName: SECONDARY , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• FACILITYEXT ( type: esriFieldTypeString, alias: Overall condition of facility exterior, editable: true, nullable: true, length: 9, defaultValue: null, modelName: FACILITYEXT , Coded Values: [Excellent: Excellent] , [Fair: Fair] , [Good: Good] , ...1 more... )
• FACILITYINT ( type: esriFieldTypeString, alias: Overall condition of facility interior, editable: true, nullable: true, length: 9, defaultValue: null, modelName: FACILITYINT , Coded Values: [Excellent: Excellent] , [Fair: Fair] , [Good: Good] , ...1 more... )
• OVERALL ( type: esriFieldTypeString, alias: Overall condition of facility records, editable: true, nullable: true, length: 9, defaultValue: null, modelName: OVERALL , Coded Values: [Excellent: Excellent] , [Fair: Fair] , [Good: Good] , ...1 more... )
• RECOMMENDATIONS ( type: esriFieldTypeString, alias: Pollution prevention recommendations, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Recommendations )
• HOUSEKEEPING ( type: esriFieldTypeString, alias: Describe housekeeping practices, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HOUSEKEEPING , Coded Values: [Excellent: Excellent] , [Fair: Fair] , [Good: Good] , ...1 more... )
• AREAOFCONCERN ( type: esriFieldTypeString, alias: Areas of concern, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AREAOFCONCERN )
• ACTIONS ( type: esriFieldTypeString, alias: Corrective actions being taken, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Actions )
• DIRECTIVETABLE ( type: esriFieldTypeSmallInteger, alias: Are site directives issued, editable: true, nullable: true, defaultValue: null, modelName: DIRECTIVETABLE , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• REVISITDATE ( type: esriFieldTypeDate, alias: Date of reinspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REVISITDATE )
• CONTACTNAME ( type: esriFieldTypeString, alias: Contact Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONTACTNAME )
• PHONENUMBER ( type: esriFieldTypeString, alias: Contact Phone, editable: true, nullable: true, length: 12, defaultValue: null, modelName: PHONENUMBER )
• CONTACTEMAIL ( type: esriFieldTypeString, alias: Contact Email, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONTACTEMAIL )
• CONTACTADDRESS ( type: esriFieldTypeString, alias: Contact Address (if different), editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONTACTADDRESS )
• CONTACTTITLE ( type: esriFieldTypeString, alias: Contact Title, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTACTTITLE )
• PARENTCOMPANY ( type: esriFieldTypeString, alias: Parent Company (if different), editable: true, nullable: true, length: 255, defaultValue: null, modelName: PARENTCOMPANY )
• EXISTING ( type: esriFieldTypeSmallInteger, alias: Existing, editable: true, nullable: true, defaultValue: null, modelName: EXISTING , Coded Values: [2: NA] , [0: Yes] , [1: No] )
• ENFORCEMENTACTION ( type: esriFieldTypeString, alias: Enforcement Action, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ENFORCEMENTACTION , Coded Values: [SiteDirective: Site Directive] , [AdminOrder: Administrative Order] , [EmergOrder: Emergency Order] , ...5 more... )
• ENFORCEMENTACTIONDATE ( type: esriFieldTypeDate, alias: Enforcement Action Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ENFORCEMENTACTIONDATE )
• NOI ( type: esriFieldTypeSmallInteger, alias: Notice of Infraction issued, editable: true, nullable: true, defaultValue: 1, modelName: NOI , Coded Values: [2: NA] , [0: Yes] , [1: No] )

Templates:

• Name: doee.DOEE.General_Facility_2
  Description:
  Prototype:
  ENFORCEMENTACTIONDATE: null
  OUTFALLID: null
  ADDRESS: null
  WATERSHED: null
  FACILITYID: null
  SCHID_FK: null
  DATE: null
  FACILITYNAME: null
  FACILITYSIZE: null
  FACILITYOPERATIONS: null
  MASTERBUSINESSLICENSE: 1
  LICENSENUMBERMB: null
  EXPIRATIONDATEMB: null
  OCCUPANCYLICENSE: 1
  LICENSENUMBEROC: null
  DATEOFISSUE: null
  PERMITS: 1
  PERMITDESC: null
  FACILITYOPNAR: null
  ODOR: 1
  ODORDESC: null
  DUST: 1
  DUSTDESC: null
  DEGRADEDSTREAM: 1
  DEGRADEDSTREAMDESC: null
  STRESSEDVEG: 1
  STRESSEDVEGDESC: null
  EVIDENCE: 1
  EVIDENCEDESC: null
  WASTEWATER: 1
  WATEWATERLOCATION: null
  WATEWATERLOCATION2: null
  BMPSINSTALLED: 1
  BMPSLIST1: null
  BMPSLIST2: Not Applicable
  BMPSLIST3: Not Applicable
  BMPSLIST4: Not Applicable
  BMPSLIST5: Not Applicable
  BMPSLIST6: Not Applicable
  BMPSLIST7: Not Applicable
  BMPSMAINTAINED: 1
  BMPSMAINTAINEDDESC: null
  PRETREAT: 1
  PRETREATDESC: null
  SAMPLE: 1
  HAZARDWASTE: 1
  HAZWASTEPERMIT: 1
  DRAINS: 1
  DRAINSNUMBER: null
  DRAINSDISCHARGE: null
  PRECAUTIONDESC: null
  DISPOSAL: null
  CONTAINERS: 1
  CHEMICALS: 1
  CHEMICALDESC: null
  POLLUTANTS: 1
  POLLUTANTSDESC: null
  SWEEPINGS: 1
  SWEEPINGSDESC: null
  SECONDARY: 1
  FACILITYEXT: null
  FACILITYINT: null
  OVERALL: null
  RECOMMENDATIONS: null
  HOUSEKEEPING: null
  AREAOFCONCERN: null
  ACTIONS: null
  DIRECTIVETABLE: null
  NOI: 1
  REVISITDATE: null
  CONTACTNAME: null
  PHONENUMBER: null
  CONTACTEMAIL: null
  CONTACTADDRESS: null
  CONTACTTITLE: null
  PARENTCOMPANY: null
  EXISTING: null
  ENFORCEMENTACTION: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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   Update Metadata