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)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

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

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata