Layers:

Layer: Facilities (0)

Name: Facilities

Display Field: fa_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 9b60cf1eaeb34437b4e6aab26f307b84

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

Extent:
XMin: -80.93220949999994
YMin: 27.846171000000027
XMax: -80.46993899999995
YMax: 28.759173944000054
Spatial Reference: 4326  (4326)



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: 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: true
Supports Query With LOD Spatial Reference: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• sqg_facility_id ( nullable: true, editable: true, defaultValue: null, length: 8, type: esriFieldTypeString, modelName: SQG_FACILITY_ID, alias: SQG Facility ID )
• fa_num ( nullable: true, editable: true, defaultValue: null, length: 7, type: esriFieldTypeString, modelName: FA_NUM, alias: Facility ID )
• fa_epa ( nullable: true, editable: true, defaultValue: null, length: 12, type: esriFieldTypeString, modelName: FA_EPA, alias: EPA ID )
• fa_other ( nullable: true, editable: true, defaultValue: NONE, length: 15, type: esriFieldTypeString, modelName: FA_OTHER, alias: License Number )
• fa_name ( nullable: false, editable: true, defaultValue: null, length: 75, type: esriFieldTypeString, modelName: FA_NAME, alias: Facility Name )
• fa_status ( nullable: false, editable: true, defaultValue: P, length: 1, type: esriFieldTypeString, modelName: FA_STATUS, alias: Facility Status , Coded Values: [A: Active Waste Generator] , [D: Duplicate Facility] , [I: Inactive (Does Not Generate Waste)] , ...3 more... )
• fa_follow ( nullable: false, editable: true, defaultValue: V, length: 1, type: esriFieldTypeString, modelName: FA_FOLLOW, alias: Follow-up Status , Coded Values: [A: Schedule Compliance Assistance Visit] , [C: Call Contact Again] , [D: DEP District Referral] , ...9 more... )
• fa_addr ( nullable: false, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: FA_ADDR, alias: Mailing Street Address )
• fa_city ( nullable: false, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: FA_CITY, alias: Mailing City )
• fa_st ( nullable: false, editable: true, defaultValue: null, length: 2, type: esriFieldTypeString, modelName: FA_ST, alias: Mailing State )
• fa_zip ( nullable: false, editable: true, defaultValue: null, length: 9, type: esriFieldTypeString, modelName: FA_ZIP, alias: Mailing Zip Code )
• fa_laddr ( nullable: false, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: FA_LADDR, alias: Location Street Address )
• fa_locat ( nullable: false, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: FA_LOCAT, alias: Location City )
• fa_lzip ( nullable: false, editable: true, defaultValue: null, length: 9, type: esriFieldTypeString, modelName: FA_LZIP, alias: Location Zip Code )
• fa_sic ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: FA_SIC, alias: Primary SIC Code )
• secondarysic ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: SecondarySIC, alias: Secondary SIC Code )
• fa_emps ( nullable: true, editable: true, defaultValue: null, length: 6, type: esriFieldTypeString, modelName: FA_EMPS, alias: Number of Employees )
• businessage ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: BusinessAge, alias: Years in Business )
• currentuse ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: CurrentUse, alias: Current Use )
• locationtype ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, modelName: LocationType, alias: Location Type , Coded Values: [COMMERCIAL: Commercial] , [RESIDENTIAL: Residential] )
• fa_gstat ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: FA_GSTAT, alias: Generator Status , Coded Values: [C: Very Small Quantity Generator] , [L: Large Quantity Generator] , [R: Small Quantity Generator] , ...2 more... )
• fa_vtype ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: FA_VTYPE, alias: Verification Type , Coded Values: [P: Phone Call] , [S: Survey] , [V: Verification] )
• fa_vdate ( nullable: true, editable: true, defaultValue: null, length: 8, type: esriFieldTypeString, modelName: FA_VDATE, alias: FDEP Verification Date (Required ex.20230630) )
• fa_ocont ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: FA_OCONT, alias: County Inspector , Coded Values: [Debra Boothe: Debra Boothe] , [Pamela McRoy: Pamela McRoy] , [Generic User: Generic User] , ...1 more... )
• fa_fcont ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: FA_FCONT, alias: Facility Contact )
• fa_ctitle ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: FA_CTITLE, alias: Facility Contact Title )
• responsibleperson ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: ResponsiblePerson, alias: Responsible Person )
• responsibletitle ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: ResponsibleTitle, alias: Responsible Person Title )
• fa_phone ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: FA_PHONE, alias: Facility Phone Number )
• email ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: Email, alias: Facility Email )
• p2inspectionzone ( nullable: true, editable: true, defaultValue: null, length: 2, type: esriFieldTypeString, modelName: P2InspectionZone, alias: Inspection Zone )
• waterprovider ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: WaterProvider, alias: Water Provider , Coded Values: [Brevard County: Brevard County] , [Barefoot Bay: Barefoot Bay] , [Cocoa: City of Cocoa] , ...6 more... )
• sewerprovider ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: SewerProvider, alias: Sewer Provider , Coded Values: [Brevard County: Brevard County] , [Barefoot Bay: Barefoot Bay] , [Cocoa: City of Cocoa] , ...6 more... )
• firedistrict ( nullable: true, editable: true, defaultValue: null, length: 25, type: esriFieldTypeString, modelName: FireDistrict, alias: Fire District , Coded Values: [Brevard County: Brevard County] , [KSC CCAFS: KSC CCAFS] , [Cape Canaveral: Cape Canaveral] , ...13 more... )
• fa_comm1 ( nullable: true, editable: true, defaultValue: null, length: 78, type: esriFieldTypeString, modelName: FA_COMM1, alias: Comments 1 )
• fa_comm2 ( nullable: true, editable: true, defaultValue: null, length: 78, type: esriFieldTypeString, modelName: FA_COMM2, alias: Comments 2 )
• fa_nextw ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: FA_NEXTW, alias: Last Waste Record )
• fa_total ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: FA_TOTAL, alias: Total HW Produced per Year (lbs) )
• fa_qmgt ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, modelName: FA_QMGT, alias: Questionable Management , Coded Values: [00000: No] , [00001: Disposal] , [00010: Storage] , ...1 more... )
• fa_update ( nullable: true, editable: true, defaultValue: null, length: 8, type: esriFieldTypeString, modelName: FA_UPDATE, alias: FDEP Last Edit Date )
• fa_dol ( nullable: true, editable: true, defaultValue: null, length: 9, type: esriFieldTypeString, modelName: FA_DOL, alias: Department of Labor ID )
• fa_utype ( nullable: true, editable: true, defaultValue: null, length: 16, type: esriFieldTypeString, modelName: FA_UTYPE, alias: FDEP Update Type )
• fa_ladnum ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: FA_LADNUM, alias: Location Address Number )
• fa_laddir ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: FA_LADDIR, alias: Location Address Direction )
• fa_ladtype ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: FA_LADTYPE, alias: Location Street Type )
• fa_lasuite ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: FA_LASUITE, alias: Location Suite Number )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
• created_date ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
• verificationdate ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: verificationdate, alias: Verification Date )
• fdepupdate_fa ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: fdepupdate_fa, alias: fdepupdate_fa )
• followupdate ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: followupdate, alias: Follow-up Date )
• plannedassessmentdate ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: plannedassessmentdate, alias: Planned Assessment Date )
• fa_oname ( nullable: true, editable: true, defaultValue: 5, length: 2, alias: County Number, type: esriFieldTypeString )
Templates:
• Name: Facilities
  Description:
  Prototype:
  fa_phone: null
  fa_epa: null
  fa_emps: null
  p2inspectionzone: null
  sqg_facility_id: null
  secondarysic: null
  fa_zip:
  fa_num: null
  fa_utype: null
  fa_comm2: null
  fa_lzip:
  fa_comm1: null
  fa_oname: 5
  sewerprovider: null
  fa_vdate: null
  verificationdate: null
  fa_name:
  fa_status: P
  fa_dol: null
  fa_nextw: null
  fa_st:
  responsibletitle: null
  businessage: null
  fa_qmgt: null
  fa_city:
  fa_gstat: null
  fa_ocont: null
  firedistrict: null
  fa_fcont: null
  fa_update: null
  fa_ladnum: null
  followupdate: null
  fa_ctitle: null
  fa_follow: V
  fa_locat:
  fa_ladtype: null
  fa_sic: null
  email: null
  fa_addr:
  plannedassessmentdate: null
  waterprovider: null
  fa_total: null
  fa_laddr:
  fa_vtype: null
  fa_lasuite: null
  fdepupdate_fa: null
  fa_other: NONE
  fa_laddir: null
  currentuse: null
  locationtype: null
  responsibleperson: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• Inspections (0) -- Related To: Inspections (3)

Tables:

Table: P2_InspectionAttachments (2)

Name: P2_InspectionAttachments

Display Field: inspectionid_attachments

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 9b60cf1eaeb34437b4e6aab26f307b84

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• inspectionid_attachments ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: InspectionID_Attachments, alias: Inspection ID )
• inspectionguid_attachments ( nullable: true, editable: true, defaultValue: null, length: 38, type: esriFieldTypeGUID, modelName: InspectionGUID_Attachments, alias: Inspection GUID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
• created_date ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
Templates:
• Name: P2_InspectionAttachments
  Description:
  Prototype:
  inspectionid_attachments: null
  inspectionguid_attachments: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Inspections (2) -- Related To: Inspections (3)

Table: Inspections (3)

Name: Inspections

Display Field: facilityname

Type: Table

Geometry Type: N/A

Description: Brevard County SQG Facilities Inspections (Read Only View)

Service Item Id: 9b60cf1eaeb34437b4e6aab26f307b84

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• inspectionid ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: InspectionID, alias: Inspection ID )
• facilityid ( nullable: true, editable: true, defaultValue: null, length: 7, type: esriFieldTypeString, modelName: FacilityID, alias: Facility ID )
• epaid ( nullable: true, editable: true, defaultValue: null, length: 12, type: esriFieldTypeString, modelName: EPAID, alias: EPA ID )
• licensenumber ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, modelName: LicenseNumber, alias: License Number )
• facilityname ( nullable: true, editable: true, defaultValue: null, length: 40, type: esriFieldTypeString, modelName: FacilityName, alias: Facility Name )
• facilitystatus ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: FacilityStatus, alias: Facility Status , Coded Values: [A: Active Waste Generator] , [D: Duplicate Facility] , [I: Inactive (Does Not Generate Waste)] , ...3 more... )
• facilityaddress ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: FacilityAddress, alias: Location Street Address )
• facilitycity ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: FacilityCity, alias: Location City )
• facilityzip ( nullable: true, editable: true, defaultValue: null, length: 9, type: esriFieldTypeString, modelName: FacilityZip, alias: Location Zip Code )
• facilitycontact ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: FacilityContact, alias: Facility Contact )
• contacttitle ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: ContactTitle, alias: Facility Contact Title )
• phone ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: Phone, alias: Facility Phone Number )
• primarysic ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: PrimarySIC, alias: Primary SIC Code )
• inspector ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: Inspector, alias: Inspector , Coded Values: [Debra Boothe: Debra Boothe] , [Pamela McRoy: Pamela McRoy] , [Generic User: Generic User] , ...1 more... )
• bldgmaintby ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: BldgMaintBy, alias: Building Maintained By , Coded Values: [CONTRACTOR: Contractor] , [GENERATOR: Generator] , [LANDLORD: Landlord] , ...2 more... )
• bldgmaintname ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: BldgMaintName, alias: Building Maintenance Name )
• lightingmaintby ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: LightingMaintBy, alias: Lighting Maintained By , Coded Values: [CONTRACTOR: Contractor] , [GENERATOR: Generator] , [LANDLORD: Landlord] , ...2 more... )
• lightingmaintname ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: LightingMaintName, alias: Lighting Maintenance Name )
• pestcontrolby ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: PestControlBy, alias: Pest Control By , Coded Values: [CONTRACTOR: Contractor] , [GENERATOR: Generator] , [LANDLORD: Landlord] , ...2 more... )
• pestcontrolname ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: PestControlName, alias: Pest Control Name )
• lawnmaintby ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: LawnMaintBy, alias: Lawn Maintained By , Coded Values: [CONTRACTOR: Contractor] , [GENERATOR: Generator] , [LANDLORD: Landlord] , ...2 more... )
• lawnmaintname ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: LawnMaintName, alias: Lawn Maintenance Name )
• vehiclemaintby ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: VehicleMaintBy, alias: Vehicle Maintained By , Coded Values: [CONTRACTOR: Contractor] , [GENERATOR: Generator] , [LANDLORD: Landlord] , ...2 more... )
• vehiclemaintname ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: VehicleMaintName, alias: Vehicle Maintenance Name )
• biohazardby ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: BioHazardBy, alias: BioHazard Disposal By , Coded Values: [CONTRACTOR: Contractor] , [GENERATOR: Generator] , [LANDLORD: Landlord] , ...2 more... )
• biohazardname ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: BioHazardName, alias: BioHazard Disposal Name )
• floordrains ( nullable: true, editable: true, defaultValue: null, length: 2, type: esriFieldTypeString, modelName: FloorDrains, alias: Floor Drains , Coded Values: [N: No] , [NA: Not Applicable] , [Y: Yes] )
• floordrainlocation ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: FloorDrainLocation, alias: Floor Drain Location )
• storagearea ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: StorageArea, alias: Storage Area , Coded Values: [IN_OUT: Inside/Outside] , [INSIDE: Inside] , [NA: Not Applicable] , ...1 more... )
• storageareacondition ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: StorageAreaCondition, alias: Storage Area Condition , Coded Values: [AVG: Average] , [GOOD: Good] , [POOR: Poor] )
• containercondition ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: ContainerCondition, alias: Container Condition , Coded Values: [AVG: Average] , [GOOD: Good] , [POOR: Poor] )
• infosupplied ( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: InfoSupplied, alias: Information Supplied )
• additionalinfo ( nullable: true, editable: true, defaultValue: null, length: 500, type: esriFieldTypeString, modelName: AdditionalInfo, alias: Additional Information Requested )
• generatorstatus ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: GeneratorStatus, alias: Generator Status , Coded Values: [C: Very Small Quantity Generator] , [L: Large Quantity Generator] , [R: Small Quantity Generator] , ...2 more... )
• hw_yearly_total ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: HW_Yearly_Total, alias: Total HW Produced per Year (lbs) )
• hw_monthly_total ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: HW_Monthly_Total, alias: Total HW Produced per Month (lbs) )
• ahw_monthly_total ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: AHW_Monthly_Total, alias: Total Acute HW Produced per Month (lbs) )
• comments ( nullable: true, editable: true, defaultValue: null, length: 5000, type: esriFieldTypeString, modelName: Comments, alias: Comments )
• insptimestamp ( nullable: true, editable: true, defaultValue: null, length: 12, type: esriFieldTypeString, modelName: InspTimeStamp, alias: Time Stamp )
• facilityguid ( nullable: true, editable: true, defaultValue: null, length: 38, type: esriFieldTypeGUID, modelName: FacilityGUID, alias: Facility GUID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
• created_date ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
• inspectiondate ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: inspectiondate, alias: inspectiondate )
• email_insp ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: email_insp, alias: Facility Email )
• secondarysic_insp ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: secondarysic_insp, alias: Secondary SIC Code )
• currentuse_insp ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: currentuse_insp, alias: Current Use )
• p2inspectionzone_insp ( nullable: true, editable: true, defaultValue: null, length: 2, type: esriFieldTypeString, modelName: p2inspectionzone_insp, alias: P2 Inspection Zone )
• waterprovider_insp ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: waterprovider_insp, alias: Water Provider , Coded Values: [Brevard County: Brevard County] , [Barefoot Bay: Barefoot Bay] , [Cocoa: City of Cocoa] , ...6 more... )
• sewerprovider_insp ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: sewerprovider_insp, alias: Sewer Provider , Coded Values: [Brevard County: Brevard County] , [Barefoot Bay: Barefoot Bay] , [Cocoa: City of Cocoa] , ...6 more... )
• firedistrict_insp ( nullable: true, editable: true, defaultValue: null, length: 25, type: esriFieldTypeString, modelName: firedistrict_insp, alias: Fire District , Coded Values: [Brevard County: Brevard County] , [KSC CCAFS: KSC CCAFS] , [Cape Canaveral: Cape Canaveral] , ...13 more... )
Templates:
• Name: P2_Inspections
  Description:
  Prototype:
  storageareacondition: null
  infosupplied: null
  licensenumber: null
  lightingmaintname: null
  vehiclemaintname: null
  facilityid: null
  waterprovider_insp: null
  primarysic: null
  generatorstatus: null
  p2inspectionzone_insp: null
  facilityguid: null
  inspectiondate: null
  sewerprovider_insp: null
  facilityname: null
  lawnmaintby: null
  vehiclemaintby: null
  floordrains: null
  facilitycity: null
  facilityaddress: null
  email_insp: null
  inspectionid: null
  bldgmaintname: null
  lightingmaintby: null
  floordrainlocation: null
  ahw_monthly_total: null
  facilitycontact: null
  biohazardname: null
  hw_monthly_total: null
  firedistrict_insp: null
  secondarysic_insp: null
  bldgmaintby: null
  hw_yearly_total: null
  currentuse_insp: null
  comments: null
  containercondition: null
  inspector: null
  facilitystatus: null
  insptimestamp: null
  additionalinfo: null
  facilityzip: null
  epaid: null
  phone: null
  contacttitle: null
  lawnmaintname: null
  pestcontrolname: null
  storagearea: null
  biohazardby: null
  pestcontrolby: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• InspectionAttachments (2) -- Related To: P2_InspectionAttachments (2)
• WasteGenerated (3) -- Related To: Waste Generated Reports (4)
• Facilities (0) -- Related To: Facilities (0)

Table: Waste Generated Reports (4)

Name: Waste Generated Reports

Display Field: wa_num

Type: Table

Geometry Type: N/A

Description: Brevard County SQG Facilities Waste Generated Reports (Read Only View)

Service Item Id: 9b60cf1eaeb34437b4e6aab26f307b84

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• wa_num ( nullable: true, editable: true, defaultValue: null, length: 7, type: esriFieldTypeString, modelName: WA_NUM, alias: Facility ID )
• wa_seq ( nullable: true, editable: true, defaultValue: null, length: 3, type: esriFieldTypeString, modelName: WA_SEQ, alias: Waste ID )
• wa_wcode ( nullable: true, editable: true, defaultValue: null, length: 2, type: esriFieldTypeString, modelName: WA_WCODE, alias: Waste Type (old) )
• wa_amt ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: WA_AMT, alias: Waste per Year (lbs) )
• wa_max ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: WA_MAX, alias: HW Produced per Month (lbs) )
• ahw_monthly ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: AHW_Monthly, alias: Acute HW Produced per Month (lbs) )
• wa_scode ( nullable: true, editable: true, defaultValue: null, length: 2, type: esriFieldTypeString, modelName: WA_SCODE, alias: Storage Method , Coded Values: [C1: C1 - 0-9 Gallon Container] , [C3: C3 - 10-39 Gallon Container] , [C5: C5 - 40 or More Gallon Container] , ...11 more... )
• wa_onoff ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: WA_ONOFF, alias: Disposal Location , Coded Values: [O: On-Site] , [F: Off-Site] )
• wa_dcode ( nullable: true, editable: true, defaultValue: null, length: 2, type: esriFieldTypeString, modelName: WA_DCODE, alias: Disposal Method , Coded Values: [AD: AD - Awaiting Disposal (planned)] , [AN: AN - Accumulation (no mangement plan)] , [AO: AO - Mixed w/Used Oil (VSQG)] , ...35 more... )
• wa_update ( nullable: true, editable: true, defaultValue: null, length: 8, type: esriFieldTypeString, modelName: WA_UPDATE, alias: FDEP Last Edit Date )
• wa_total ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: WA_TOTAL, alias: HW Produced per Year (lbs) )
• wa_qmgt ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: WA_QMGT, alias: Questionable Management , Coded Values: [0: No] , [1: Disposal] , [10: Storage] , ...1 more... )
• wa_unit ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: WA_UNIT, alias: Waste Units , Coded Values: [B: Barrel (35 gallon)] , [D: Drum (55 gallon)] , [G: Gallons] , ...6 more... )
• wa_annual ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: WA_ANNUAL, alias: Units per Year )
• wa_month ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: WA_MONTH, alias: Units per Month )
• hazardstatus ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: HazardStatus, alias: Hazardous Status , Coded Values: [A: Acute Hazardous] , [E: Exempt/Excluded] , [G: Regulated] , ...4 more... )
• wasteunitcode ( nullable: true, editable: true, defaultValue: null, length: 5, type: esriFieldTypeString, modelName: WasteUnitCode, alias: Waste Unit Code )
• weightfactor ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: WeightFactor, alias: Weight Factor )
• hauler ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: Hauler, alias: Hauler )
• wa_utype ( nullable: true, editable: true, defaultValue: null, length: 15, type: esriFieldTypeString, modelName: WA_UTYPE, alias: FDEP Update Type )
• wa_comm ( nullable: true, editable: true, defaultValue: null, length: 78, type: esriFieldTypeString, modelName: WA_COMM, alias: Comments )
• wa_nwcode ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: WA_NWCODE, alias: Waste Type , Coded Values: [AMEO: AMEO - Antifreeze (HW except when recycled)] , [AMNO: AMNO - Antifreeze (not HW)] , [BDEB: BDEB - Lead-acid Batteries] , ...72 more... )
• wa_cquest1 ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: WA_CQUEST1, alias: County Data 1 )
• wa_cquest2 ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: WA_CQUEST2, alias: County Data 2 )
• wa_ccode ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: WA_CCODE, alias: Character Code )
• wa_actrec ( nullable: true, editable: true, defaultValue: null, length: 1, type: esriFieldTypeString, modelName: WA_ACTREC, alias: Activity Record )
• wa_epa1 ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: WA_EPA1, alias: EPA HW Code 1 )
• wa_epa2 ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: WA_EPA2, alias: EPA HW Code 2 )
• wa_epa3 ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: WA_EPA3, alias: EPA HW Code 3 )
• wa_epa4 ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: WA_EPA4, alias: EPA HW Code 4 )
• wa_epa5 ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: WA_EPA5, alias: EPA HW Code 5 )
• inspectionid_waste ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: InspectionID_Waste, alias: Inspection ID )
• inspectionguid ( nullable: true, editable: true, defaultValue: null, length: 38, type: esriFieldTypeGUID, modelName: InspectionGUID, alias: Inspection GUID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
• created_date ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
• fdepupdate_wa ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: fdepupdate_wa, alias: fdepupdate_wa )
Templates:
• Name: P2_WasteGenerated
  Description:
  Prototype:
  wa_epa5: null
  wa_epa2: null
  wa_num: null
  wa_epa1: null
  wa_epa4: null
  wa_amt: null
  hazardstatus: null
  wa_epa3: null
  wa_nwcode: null
  wa_update: null
  weightfactor: null
  wa_utype: null
  inspectionguid: null
  wa_actrec: null
  wa_total: null
  wa_comm: null
  inspectionid_waste: null
  wasteunitcode: null
  wa_cquest2: null
  wa_cquest1: null
  wa_unit: null
  wa_qmgt: null
  wa_dcode: null
  ahw_monthly: null
  wa_scode: null
  wa_annual: null
  wa_wcode: null
  wa_onoff: null
  fdepupdate_wa: null
  wa_month: null
  hauler: null
  wa_max: null
  wa_ccode: null
  wa_seq: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Inspections (3) -- Related To: Inspections (3)