{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "syncEnabled": false, "relationships": [ { "keyField": "inspectionguid_attachments", "role": "esriRelRoleDestination", "composite": true, "name": "Inspections", "relatedTableId": 3, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "P2_InspectionAttachments", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "inspectionid_attachments": null, "inspectionguid_attachments": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": true, "name": "P2_InspectionAttachments", "displayField": "inspectionid_attachments", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "InspectionID_Attachments", "domain": null, "name": "inspectionid_attachments", "alias": "Inspection ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 38, "type": "esriFieldTypeGUID", "modelName": "InspectionGUID_Attachments", "domain": null, "name": "inspectionguid_attachments", "alias": "Inspection GUID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "i535inspectiongu", "isUnique": false, "description": "", "fields": "inspectionguid_attachments", "isAscending": true }, { "name": "r320_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_320", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": true, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "9b60cf1eaeb34437b4e6aab26f307b84", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "InspectionAttachments", "relatedTableId": 2, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "WasteGenerated", "relatedTableId": 4, "id": 3, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "facilityguid", "role": "esriRelRoleDestination", "composite": true, "name": "Facilities", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "P2_Inspections", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "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 } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "Inspections", "displayField": "facilityname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "InspectionID", "domain": null, "name": "inspectionid", "alias": "Inspection ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 7, "type": "esriFieldTypeString", "modelName": "FacilityID", "domain": null, "name": "facilityid", "alias": "Facility ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 12, "type": "esriFieldTypeString", "modelName": "EPAID", "domain": null, "name": "epaid", "alias": "EPA ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "LicenseNumber", "domain": null, "name": "licensenumber", "alias": "License Number" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 40, "type": "esriFieldTypeString", "modelName": "FacilityName", "domain": null, "name": "facilityname", "alias": "Facility Name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "FacilityStatus", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_FacilityStatus_7", "description": "Pollution Prevention facility status", "type": "codedValue", "codedValues": [ { "code": "A", "name": "Active Waste Generator" }, { "code": "D", "name": "Duplicate Facility" }, { "code": "I", "name": "Inactive (Does Not Generate Waste)" }, { "code": "O", "name": "Out of Business" }, { "code": "P", "name": "Potential Generator" }, { "code": "X", "name": "Archive Inactive" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "facilitystatus", "alias": "Facility Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "FacilityAddress", "domain": null, "name": "facilityaddress", "alias": "Location Street Address" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "FacilityCity", "domain": null, "name": "facilitycity", "alias": "Location City" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 9, "type": "esriFieldTypeString", "modelName": "FacilityZip", "domain": null, "name": "facilityzip", "alias": "Location Zip Code" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "FacilityContact", "domain": null, "name": "facilitycontact", "alias": "Facility Contact" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "ContactTitle", "domain": null, "name": "contacttitle", "alias": "Facility Contact Title" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 10, "type": "esriFieldTypeString", "modelName": "Phone", "domain": null, "name": "phone", "alias": "Facility Phone Number" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "PrimarySIC", "domain": null, "name": "primarysic", "alias": "Primary SIC Code" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "Inspector", "domain": { "name": "P2_Inspectors_7_1", "type": "codedValue", "codedValues": [ { "code": "Debra Boothe", "name": "Debra Boothe" }, { "code": "Pamela McRoy", "name": "Pamela McRoy" }, { "code": "Generic User", "name": "Generic User" }, { "code": "Debra Rutland", "name": "Debra Rutland" } ] }, "name": "inspector", "alias": "Inspector" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "BldgMaintBy", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_MaintainedBy", "description": "Pollution Prevention facility maintenance options", "type": "codedValue", "codedValues": [ { "code": "CONTRACTOR", "name": "Contractor" }, { "code": "GENERATOR", "name": "Generator" }, { "code": "LANDLORD", "name": "Landlord" }, { "code": "NA", "name": "Not Applicable" }, { "code": "OTHER", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "bldgmaintby", "alias": "Building Maintained By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "BldgMaintName", "domain": null, "name": "bldgmaintname", "alias": "Building Maintenance Name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "LightingMaintBy", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_MaintainedBy", "description": "Pollution Prevention facility maintenance options", "type": "codedValue", "codedValues": [ { "code": "CONTRACTOR", "name": "Contractor" }, { "code": "GENERATOR", "name": "Generator" }, { "code": "LANDLORD", "name": "Landlord" }, { "code": "NA", "name": "Not Applicable" }, { "code": "OTHER", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lightingmaintby", "alias": "Lighting Maintained By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "LightingMaintName", "domain": null, "name": "lightingmaintname", "alias": "Lighting Maintenance Name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "PestControlBy", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_MaintainedBy", "description": "Pollution Prevention facility maintenance options", "type": "codedValue", "codedValues": [ { "code": "CONTRACTOR", "name": "Contractor" }, { "code": "GENERATOR", "name": "Generator" }, { "code": "LANDLORD", "name": "Landlord" }, { "code": "NA", "name": "Not Applicable" }, { "code": "OTHER", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "pestcontrolby", "alias": "Pest Control By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "PestControlName", "domain": null, "name": "pestcontrolname", "alias": "Pest Control Name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "LawnMaintBy", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_MaintainedBy", "description": "Pollution Prevention facility maintenance options", "type": "codedValue", "codedValues": [ { "code": "CONTRACTOR", "name": "Contractor" }, { "code": "GENERATOR", "name": "Generator" }, { "code": "LANDLORD", "name": "Landlord" }, { "code": "NA", "name": "Not Applicable" }, { "code": "OTHER", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "lawnmaintby", "alias": "Lawn Maintained By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "LawnMaintName", "domain": null, "name": "lawnmaintname", "alias": "Lawn Maintenance Name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "VehicleMaintBy", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_MaintainedBy", "description": "Pollution Prevention facility maintenance options", "type": "codedValue", "codedValues": [ { "code": "CONTRACTOR", "name": "Contractor" }, { "code": "GENERATOR", "name": "Generator" }, { "code": "LANDLORD", "name": "Landlord" }, { "code": "NA", "name": "Not Applicable" }, { "code": "OTHER", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "vehiclemaintby", "alias": "Vehicle Maintained By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "VehicleMaintName", "domain": null, "name": "vehiclemaintname", "alias": "Vehicle Maintenance Name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "BioHazardBy", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_MaintainedBy", "description": "Pollution Prevention facility maintenance options", "type": "codedValue", "codedValues": [ { "code": "CONTRACTOR", "name": "Contractor" }, { "code": "GENERATOR", "name": "Generator" }, { "code": "LANDLORD", "name": "Landlord" }, { "code": "NA", "name": "Not Applicable" }, { "code": "OTHER", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "biohazardby", "alias": "BioHazard Disposal By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "BioHazardName", "domain": null, "name": "biohazardname", "alias": "BioHazard Disposal Name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2, "type": "esriFieldTypeString", "modelName": "FloorDrains", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Y_N_NA", "description": "Yes, No, or Not Applicable stored as Y, N, or NA", "type": "codedValue", "codedValues": [ { "code": "N", "name": "No" }, { "code": "NA", "name": "Not Applicable" }, { "code": "Y", "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "floordrains", "alias": "Floor Drains" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "FloorDrainLocation", "domain": null, "name": "floordrainlocation", "alias": "Floor Drain Location" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "StorageArea", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_StorageArea", "description": "Pollution Prevention storage area locations", "type": "codedValue", "codedValues": [ { "code": "IN_OUT", "name": "Inside/Outside" }, { "code": "INSIDE", "name": "Inside" }, { "code": "NA", "name": "Not Applicable" }, { "code": "OUTSIDE", "name": "Outside" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "storagearea", "alias": "Storage Area" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "StorageAreaCondition", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_Condition", "description": "Pollution Prevention condition description", "type": "codedValue", "codedValues": [ { "code": "AVG", "name": "Average" }, { "code": "GOOD", "name": "Good" }, { "code": "POOR", "name": "Poor" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "storageareacondition", "alias": "Storage Area Condition" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "ContainerCondition", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_Condition", "description": "Pollution Prevention condition description", "type": "codedValue", "codedValues": [ { "code": "AVG", "name": "Average" }, { "code": "GOOD", "name": "Good" }, { "code": "POOR", "name": "Poor" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "containercondition", "alias": "Container Condition" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "InfoSupplied", "domain": null, "name": "infosupplied", "alias": "Information Supplied" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 500, "type": "esriFieldTypeString", "modelName": "AdditionalInfo", "domain": null, "name": "additionalinfo", "alias": "Additional Information Requested" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "GeneratorStatus", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_GeneratorStatus_7", "description": "Pollution Prevention waste generator status", "type": "codedValue", "codedValues": [ { "code": "C", "name": "Very Small Quantity Generator" }, { "code": "L", "name": "Large Quantity Generator" }, { "code": "R", "name": "Small Quantity Generator" }, { "code": "U", "name": "Unverified Generator Status" }, { "code": "N", "name": "Not a HW Generator" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "generatorstatus", "alias": "Generator Status" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "HW_Yearly_Total", "domain": null, "name": "hw_yearly_total", "alias": "Total HW Produced per Year (lbs)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "HW_Monthly_Total", "domain": null, "name": "hw_monthly_total", "alias": "Total HW Produced per Month (lbs)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "AHW_Monthly_Total", "domain": null, "name": "ahw_monthly_total", "alias": "Total Acute HW Produced per Month (lbs)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5000, "type": "esriFieldTypeString", "modelName": "Comments", "domain": null, "name": "comments", "alias": "Comments" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 12, "type": "esriFieldTypeString", "modelName": "InspTimeStamp", "domain": null, "name": "insptimestamp", "alias": "Time Stamp" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 38, "type": "esriFieldTypeGUID", "modelName": "FacilityGUID", "domain": null, "name": "facilityguid", "alias": "Facility GUID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "inspectiondate", "domain": null, "name": "inspectiondate", "alias": "inspectiondate" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "email_insp", "domain": null, "name": "email_insp", "alias": "Facility Email" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "secondarysic_insp", "domain": null, "name": "secondarysic_insp", "alias": "Secondary SIC Code" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "currentuse_insp", "domain": null, "name": "currentuse_insp", "alias": "Current Use" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2, "type": "esriFieldTypeString", "modelName": "p2inspectionzone_insp", "domain": null, "name": "p2inspectionzone_insp", "alias": "P2 Inspection Zone" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "waterprovider_insp", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_WaterProvider_7", "description": "Pollution Prevention facility water source", "type": "codedValue", "codedValues": [ { "code": "Brevard County", "name": "Brevard County" }, { "code": "Barefoot Bay", "name": "Barefoot Bay" }, { "code": "Cocoa", "name": "City of Cocoa" }, { "code": "Melbourne", "name": "City of Melbourne" }, { "code": "Mims", "name": "Mims" }, { "code": "Palm Bay", "name": "City of Palm Bay" }, { "code": "Titusville", "name": "City of Titusville" }, { "code": "West Melbourne", "name": "City of West Melbourne" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "waterprovider_insp", "alias": "Water Provider" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "sewerprovider_insp", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_SewerProvider_7", "description": "Pollution Prevention facility waste water provider", "type": "codedValue", "codedValues": [ { "code": "Brevard County", "name": "Brevard County" }, { "code": "Barefoot Bay", "name": "Barefoot Bay" }, { "code": "Cocoa", "name": "City of Cocoa" }, { "code": "Melbourne", "name": "City of Melbourne" }, { "code": "Mims", "name": "Mims" }, { "code": "Palm Bay", "name": "City of Palm Bay" }, { "code": "Titusville", "name": "City of Titusville" }, { "code": "West Melbourne", "name": "City of West Melbourne" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "sewerprovider_insp", "alias": "Sewer Provider" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "firedistrict_insp", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "FireDistrict_6_7", "description": "List of all Fire Districts", "type": "codedValue", "codedValues": [ { "code": "Brevard County", "name": "Brevard County" }, { "code": "KSC CCAFS", "name": "KSC CCAFS" }, { "code": "Cape Canaveral", "name": "Cape Canaveral" }, { "code": "Cocoa Beach", "name": "Cocoa Beach" }, { "code": "Satellite Beach", "name": "Satellite Beach" }, { "code": "Indian Harbour Beach", "name": "Indian Harbour Beach" }, { "code": "Indialantic", "name": "Indialantic" }, { "code": "Melbourne Beach", "name": "Melbourne Beach" }, { "code": "Titusville", "name": "Titusville" }, { "code": "Rockledge", "name": "Rockledge" }, { "code": "Cocoa", "name": "Cocoa" }, { "code": "Malabar", "name": "Malabar" }, { "code": "Palm Bay", "name": "Palm Bay" }, { "code": "Melbourne", "name": "Melbourne" }, { "code": "PAFB", "name": "PAFB" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "firedistrict_insp", "alias": "Fire District" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "Brevard County SQG Facilities Inspections (Read Only View)", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "i536facilityguid", "isUnique": false, "description": "", "fields": "facilityguid", "isAscending": true }, { "name": "i536inspectionid", "isUnique": false, "description": "", "fields": "inspectionid", "isAscending": true }, { "name": "r321_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_321", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "9b60cf1eaeb34437b4e6aab26f307b84", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "inspectionguid", "role": "esriRelRoleDestination", "composite": true, "name": "Inspections", "relatedTableId": 3, "id": 3, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "P2_WasteGenerated", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "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 } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "Waste Generated Reports", "displayField": "wa_num", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 7, "type": "esriFieldTypeString", "modelName": "WA_NUM", "domain": null, "name": "wa_num", "alias": "Facility ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 3, "type": "esriFieldTypeString", "modelName": "WA_SEQ", "domain": null, "name": "wa_seq", "alias": "Waste ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2, "type": "esriFieldTypeString", "modelName": "WA_WCODE", "domain": null, "name": "wa_wcode", "alias": "Waste Type (old)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "WA_AMT", "domain": null, "name": "wa_amt", "alias": "Waste per Year (lbs)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "WA_MAX", "domain": null, "name": "wa_max", "alias": "HW Produced per Month (lbs)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "AHW_Monthly", "domain": null, "name": "ahw_monthly", "alias": "Acute HW Produced per Month (lbs)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2, "type": "esriFieldTypeString", "modelName": "WA_SCODE", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_StorageMethods", "description": "Pollution Prevention waste storage methods", "type": "codedValue", "codedValues": [ { "code": "C1", "name": "C1 - 0-9 Gallon Container" }, { "code": "C3", "name": "C3 - 10-39 Gallon Container" }, { "code": "C5", "name": "C5 - 40 or More Gallon Container" }, { "code": "CR", "name": "CR - Bulk RCRA Waste Container" }, { "code": "GA", "name": "GA - Piled on the Ground" }, { "code": "GB", "name": "GB - Buried in the Ground" }, { "code": "GF", "name": "GF - Piled on the Floor or Table" }, { "code": "OG", "name": "OG - Other Good" }, { "code": "OL", "name": "OL - Solid Waste Container" }, { "code": "OP", "name": "OP - Parts Washer" }, { "code": "OQ", "name": "OQ - Other Questionable" }, { "code": "TA", "name": "TA - Tank Above Ground" }, { "code": "TB", "name": "TB - Tank Below Ground" }, { "code": "TV", "name": "TV - Vat (open container)" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "wa_scode", "alias": "Storage Method" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "WA_ONOFF", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_DisposalLocation", "description": "Pollution Prevention waste disposal locations", "type": "codedValue", "codedValues": [ { "code": "O", "name": "On-Site" }, { "code": "F", "name": "Off-Site" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "wa_onoff", "alias": "Disposal Location" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2, "type": "esriFieldTypeString", "modelName": "WA_DCODE", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_DisposalMethods", "description": "Pollution Prevention waste disposal methods", "type": "codedValue", "codedValues": [ { "code": "AD", "name": "AD - Awaiting Disposal (planned)" }, { "code": "AN", "name": "AN - Accumulation (no mangement plan)" }, { "code": "AO", "name": "AO - Mixed w/Used Oil (VSQG)" }, { "code": "BE", "name": "BE - Evaporation Only" }, { "code": "BF", "name": "BF - HW Fuel Burn/Blend" }, { "code": "BO", "name": "BO - Open Burning" }, { "code": "BU", "name": "BU - Used Oil Burner" }, { "code": "CU", "name": "CU - Continued Use (parts washer solvent)" }, { "code": "DD", "name": "DD - On-Site Land Disposal" }, { "code": "DG", "name": "DG - Disposal to Groundwater" }, { "code": "DP", "name": "DP - Disposal to Sewer" }, { "code": "DS", "name": "DS - Disposal to Surface Water" }, { "code": "DT", "name": "DT - Disposal to Septic Tank" }, { "code": "EC", "name": "EC - Commercial Laundry" }, { "code": "EE", "name": "EE - Universal Waste" }, { "code": "ER", "name": "ER - Exempt Recycling" }, { "code": "EU", "name": "EU - Used Oil Recycling" }, { "code": "EW", "name": "EW - Industrial Wastewater Treatment" }, { "code": "HH", "name": "HH - HW RCRA Treatment" }, { "code": "HO", "name": "HO - VSQG Collection" }, { "code": "HQ", "name": "HQ - Questionable" }, { "code": "HR", "name": "HR - HW RCRA Reuse/Recycling" }, { "code": "NH", "name": "NH - Non-Haz Management (tested/confirmed)" }, { "code": "NQ", "name": "NQ - Non-Haz Management (not tested/questionable)" }, { "code": "OE", "name": "OE - On-Site Exempt Treatment" }, { "code": "OO", "name": "OO - Other On-Site TDR (comments)" }, { "code": "OP", "name": "OP - On-Site RCRA Permitted Treatment" }, { "code": "OR", "name": "OR - On-Site Recycling/Reuse" }, { "code": "RD", "name": "RD - Reverse Distribution (pharmaceuticals)" }, { "code": "SD", "name": "SD - C&D Landfill/Unlined Landfill" }, { "code": "SF", "name": "SF - Solid Waste Incinerator (WTE)" }, { "code": "SL", "name": "SL - Solid Waste Lined Landfill" }, { "code": "SO", "name": "SO - Other Bad (HHW collection)" }, { "code": "TE", "name": "TE - WW Treatment to Evaporation" }, { "code": "TO", "name": "TO - WW treated Other Disposal" }, { "code": "TP", "name": "TP - WW Treated to POTW" }, { "code": "TS", "name": "TS - WW Treated to Surface Water" }, { "code": "TT", "name": "TT - WW Treated to Septic Tank" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "wa_dcode", "alias": "Disposal Method" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 8, "type": "esriFieldTypeString", "modelName": "WA_UPDATE", "domain": null, "name": "wa_update", "alias": "FDEP Last Edit Date" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "WA_TOTAL", "domain": null, "name": "wa_total", "alias": "HW Produced per Year (lbs)" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "WA_QMGT", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_QMGT_Int", "description": "Pollution Prevention questionable management code for FDEP", "type": "codedValue", "codedValues": [ { "code": 0, "name": "No" }, { "code": 1, "name": "Disposal" }, { "code": 10, "name": "Storage" }, { "code": 11, "name": "Storage/Disposal" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "wa_qmgt", "alias": "Questionable Management" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "WA_UNIT", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_WasteUnits", "description": "Pollution Prevention waste units", "type": "codedValue", "codedValues": [ { "code": "B", "name": "Barrel (35 gallon)" }, { "code": "D", "name": "Drum (55 gallon)" }, { "code": "G", "name": "Gallons" }, { "code": "K", "name": "Kilograms" }, { "code": "P", "name": "Pounds" }, { "code": "T", "name": "Short Tons" }, { "code": "U", "name": "Units" }, { "code": "C", "name": "Cubic Yard" }, { "code": "4", "name": "4' Fluorescent Tube" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "wa_unit", "alias": "Waste Units" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "WA_ANNUAL", "domain": null, "name": "wa_annual", "alias": "Units per Year" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "WA_MONTH", "domain": null, "name": "wa_month", "alias": "Units per Month" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "HazardStatus", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_HazardStatus_4", "description": "Pollution Prevention hazardous waste status", "type": "codedValue", "codedValues": [ { "code": "A", "name": "Acute Hazardous" }, { "code": "E", "name": "Exempt/Excluded" }, { "code": "G", "name": "Regulated" }, { "code": "H", "name": "Hazardous" }, { "code": "P", "name": "Pharmaceutical Subpart P" }, { "code": "R", "name": "Recycled" }, { "code": "U", "name": "Universal" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "hazardstatus", "alias": "Hazardous Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "modelName": "WasteUnitCode", "domain": null, "name": "wasteunitcode", "alias": "Waste Unit Code" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "WeightFactor", "domain": null, "name": "weightfactor", "alias": "Weight Factor" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "Hauler", "domain": null, "name": "hauler", "alias": "Hauler" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "WA_UTYPE", "domain": null, "name": "wa_utype", "alias": "FDEP Update Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 78, "type": "esriFieldTypeString", "modelName": "WA_COMM", "domain": null, "name": "wa_comm", "alias": "Comments" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "WA_NWCODE", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_WasteTypes", "description": "Pollution Prevention waste types", "type": "codedValue", "codedValues": [ { "code": "AMEO", "name": "AMEO - Antifreeze (HW except when recycled)" }, { "code": "AMNO", "name": "AMNO - Antifreeze (not HW)" }, { "code": "BDEB", "name": "BDEB - Lead-acid Batteries" }, { "code": "CWCM", "name": "CWCM - Acidic or Alkaline Wastes (pH<2 or pH>12.5)" }, { "code": "EENU", "name": "EENU - Empty Pesticide Containers (D,U list)" }, { "code": "EMRD", "name": "EMRD - Pesticide Waste Mixtures/Waters" }, { "code": "EPAD", "name": "EPAD - Acute Pesticide Wastes (P list)" }, { "code": "EPRD", "name": "EPRD - Toxic Wastes (D,U list)" }, { "code": "ETAC", "name": "ETAC - Acute Spill Cleanup (P list)" }, { "code": "ETRC", "name": "ETRC - Acute Spill Cleanup (D,U list)" }, { "code": "FFEF", "name": "FFEF - Photographic Silver Recovery Canister" }, { "code": "FFHF", "name": "FFHF - Fixer/Film/Developer Filters (improper disposed)" }, { "code": "FWHF", "name": "FWHF - Photographic Waste (fixer solution)" }, { "code": "FWNF", "name": "FWNF - Photographic Wastes (not HW)" }, { "code": "GFEO", "name": "GFEO - Fuel Filters" }, { "code": "GPID", "name": "GPID - Discarded Gasoline, Diesel, or Other Fuel" }, { "code": "GWEE", "name": "GWEE - Petroleum Contact Waters (PCW)" }, { "code": "HBLT", "name": "HBLT - Distillation Bottoms (halogenated)" }, { "code": "HFLO", "name": "HFLO - Dry Cleaning Filters" }, { "code": "HMLG", "name": "HMLG - Halogenated Solvents (contain chlorine/fluorine)" }, { "code": "HRLG", "name": "HRLG - Absorbents with Halogenated Solvents" }, { "code": "HWET", "name": "HWET - Condensate H2O from Dry Cleaners" }, { "code": "IPHI", "name": "IPHI - Waste Inks (contains heavy metals)" }, { "code": "IPII", "name": "IPII - Waste Inks (flashpoint<140F)" }, { "code": "IPMI", "name": "IPMI - Waste Inks (flashpoint<140F and heavy metals)" }, { "code": "LDEB", "name": "LDEB - Fluorecent Lamps/Devices" }, { "code": "MBHR", "name": "MBHR - Sludges with Heavy Metals" }, { "code": "MFHO", "name": "MFHO - Filters with Heavy Metals" }, { "code": "MSEM", "name": "MSEM - Solids, Scrap Metal, Solder, Circuits" }, { "code": "MSHS", "name": "MSHS - Dust and Solids with Heavy Metals" }, { "code": "MSHU", "name": "MSHU - Lead Backing from X-Ray, Scrap Amalgam" }, { "code": "MWHR", "name": "MWHR - Wash, Rinse, Other Wastewater w/Heavy Metals" }, { "code": "NBLT", "name": "NBLT - Distillation Bottoms (non-halogenated)" }, { "code": "NPIA", "name": "NPIA - Mineral Spirits (parts cleaner)" }, { "code": "NPIG", "name": "NPIG - Non-Halogenated Solvent (ignitible listed only)" }, { "code": "NPLG", "name": "NPLG - Non-Halogenated Solvent (tox, react, acute listed)" }, { "code": "NRLG", "name": "NRLG - Absorbents with Listed Non-Halogenated Solvents" }, { "code": "OBOU", "name": "OBOU - Sludges and Solids w/TC Organics (also soils)" }, { "code": "OLED", "name": "OLED - Other Chemical (not HW)" }, { "code": "OLIU", "name": "OLIU - Other Ignitible Wastes" }, { "code": "OLMD", "name": "OLMD - Other Chemical Lab Packed Waste" }, { "code": "OPAD", "name": "OPAD - Acute Discarded Unused or Off-Spec Chemical" }, { "code": "OPLD", "name": "OPLD - Discarded Unused or Off-Spec Chemical" }, { "code": "OTAC", "name": "OTAC - Acute Chemical Spill Cleanup (P list)" }, { "code": "OWOU", "name": "OWOU - Wastewater eith TC Organics (e.g. benzene)" }, { "code": "PMIP", "name": "PMIP - Ignitible Paint Wastes (flashpoint<140F)" }, { "code": "PMMP", "name": "PMMP - Paint Waste (mixed HW)" }, { "code": "PSHP", "name": "PSHP - Other Paint Wastes w/Heavy Metals" }, { "code": "RDEB", "name": "RDEB - Rechargeable Batteries (Pb acid, NiCad, Hg, Ag)" }, { "code": "SBNG", "name": "SBNG - Solvent Sludges (not HW)" }, { "code": "SBRT", "name": "SBRT - Solvent Distillation Bottoms" }, { "code": "SFNG", "name": "SFNG - Solvent Filters (not HW)" }, { "code": "SMHA", "name": "SMHA - Aqueous Parts Washer with Heavy Metals" }, { "code": "SMLA", "name": "SMLA - Aqueous Parts Washer w/Listed HW" }, { "code": "SMNG", "name": "SMNG - Solvents Mixed (not HW)" }, { "code": "SMRA", "name": "SMRA - Spent Solvents (mix/other)" }, { "code": "SPNA", "name": "SPNA - Aqueous Parts Washer (not HW)" }, { "code": "SRIG", "name": "SRIG - Rags with Ignitible-only Solvents" }, { "code": "SRNG", "name": "SRNG - Dry Rags (not HW) from Ignitible-only Solvents" }, { "code": "TDEB", "name": "TDEB - Mercury Containing Devices (thermostats, etc.)" }, { "code": "UBNE", "name": "UBNE - Oily Sludge (from sump pump outs)" }, { "code": "UCNO", "name": "UCNO - Crushed Oil Filters" }, { "code": "UKEH", "name": "UKEH - Absorbents Contaminated with Oil" }, { "code": "UMEH", "name": "UMEH - Used Oil Contaminated with Halogenated Hazardous Waste" }, { "code": "UOEO", "name": "UOEO - Used Oil Collected by PUOCC FACS" }, { "code": "UPEM", "name": "UPEM - Metalworking (cutting) Oils" }, { "code": "UPEO", "name": "UPEO - Used Oils and Other Lubricants" }, { "code": "UPNO", "name": "UPNO - Non-Hazardous Oils (cooling, etc.)" }, { "code": "UREH", "name": "UREH - Rags with Oil" }, { "code": "UUNO", "name": "UUNO - Uncrushed Oil Filters" }, { "code": "UWNE", "name": "UWNE - Oily Waste Water" }, { "code": "WMHM", "name": "WMHM - Wood-Preserving Wastes" }, { "code": "XDVD", "name": "XDVD - Waste Explosives" }, { "code": "XSVU", "name": "XSVU - Reactive Wastes (solids)" }, { "code": "XWVU", "name": "XWVU - Reactive Wastes (wastewater)" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "wa_nwcode", "alias": "Waste Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "WA_CQUEST1", "domain": null, "name": "wa_cquest1", "alias": "County Data 1" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "WA_CQUEST2", "domain": null, "name": "wa_cquest2", "alias": "County Data 2" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "WA_CCODE", "domain": null, "name": "wa_ccode", "alias": "Character Code" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "WA_ACTREC", "domain": null, "name": "wa_actrec", "alias": "Activity Record" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "WA_EPA1", "domain": null, "name": "wa_epa1", "alias": "EPA HW Code 1" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "WA_EPA2", "domain": null, "name": "wa_epa2", "alias": "EPA HW Code 2" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "WA_EPA3", "domain": null, "name": "wa_epa3", "alias": "EPA HW Code 3" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "WA_EPA4", "domain": null, "name": "wa_epa4", "alias": "EPA HW Code 4" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "WA_EPA5", "domain": null, "name": "wa_epa5", "alias": "EPA HW Code 5" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "InspectionID_Waste", "domain": null, "name": "inspectionid_waste", "alias": "Inspection ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 38, "type": "esriFieldTypeGUID", "modelName": "InspectionGUID", "domain": null, "name": "inspectionguid", "alias": "Inspection GUID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "fdepupdate_wa", "domain": null, "name": "fdepupdate_wa", "alias": "fdepupdate_wa" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "Brevard County SQG Facilities Waste Generated Reports (Read Only View)", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "i537inspectiongu", "isUnique": false, "description": "", "fields": "inspectionguid", "isAscending": true }, { "name": "r322_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_322", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "9b60cf1eaeb34437b4e6aab26f307b84", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 27.846171000000027, "xmin": -80.93220949999994, "ymax": 28.759173944000054, "xmax": -80.46993899999995, "spatialReference": { "falseM": -100000, "xyTolerance": 8.983152841195215E-9, "mUnits": 10000, "zUnits": 10000, "latestWkid": 4326, "zTolerance": 0.001, "wkid": 4326, "xyUnits": 9.999999999999999E8, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "Inspections", "relatedTableId": 3, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Facilities", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "symbol": null, "_constructed": true, "attributes": { "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 } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "Facilities", "allowTrueCurvesUpdates": false, "displayField": "fa_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 8, "type": "esriFieldTypeString", "modelName": "SQG_FACILITY_ID", "domain": null, "name": "sqg_facility_id", "alias": "SQG Facility ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 7, "type": "esriFieldTypeString", "modelName": "FA_NUM", "domain": null, "name": "fa_num", "alias": "Facility ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 12, "type": "esriFieldTypeString", "modelName": "FA_EPA", "domain": null, "name": "fa_epa", "alias": "EPA ID" }, { "nullable": true, "editable": true, "defaultValue": "NONE", "length": 15, "type": "esriFieldTypeString", "modelName": "FA_OTHER", "domain": null, "name": "fa_other", "alias": "License Number" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 75, "type": "esriFieldTypeString", "modelName": "FA_NAME", "domain": null, "name": "fa_name", "alias": "Facility Name" }, { "nullable": false, "editable": true, "defaultValue": "P", "length": 1, "type": "esriFieldTypeString", "modelName": "FA_STATUS", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_FacilityStatus_7", "description": "Pollution Prevention facility status", "type": "codedValue", "codedValues": [ { "code": "A", "name": "Active Waste Generator" }, { "code": "D", "name": "Duplicate Facility" }, { "code": "I", "name": "Inactive (Does Not Generate Waste)" }, { "code": "O", "name": "Out of Business" }, { "code": "P", "name": "Potential Generator" }, { "code": "X", "name": "Archive Inactive" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fa_status", "alias": "Facility Status" }, { "nullable": false, "editable": true, "defaultValue": "V", "length": 1, "type": "esriFieldTypeString", "modelName": "FA_FOLLOW", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_FollowUp", "description": "Pollution Prevention facility follow up status", "type": "codedValue", "codedValues": [ { "code": "A", "name": "Schedule Compliance Assistance Visit" }, { "code": "C", "name": "Call Contact Again" }, { "code": "D", "name": "DEP District Referral" }, { "code": "E", "name": "Code Enforcement Referral" }, { "code": "F", "name": "Fire/Safety Referral" }, { "code": "N", "name": "None Needed" }, { "code": "P", "name": "Send Pamphlets or Guidance" }, { "code": "R", "name": "No Return of Survey" }, { "code": "S", "name": "Not Notified or Surveyed" }, { "code": "T", "name": "Check Against TSD or Transporter Records" }, { "code": "U", "name": "Water/Utilities Referral" }, { "code": "V", "name": "Verify or Reinspect" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fa_follow", "alias": "Follow-up Status" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "FA_ADDR", "domain": null, "name": "fa_addr", "alias": "Mailing Street Address" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "FA_CITY", "domain": null, "name": "fa_city", "alias": "Mailing City" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 2, "type": "esriFieldTypeString", "modelName": "FA_ST", "domain": null, "name": "fa_st", "alias": "Mailing State" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 9, "type": "esriFieldTypeString", "modelName": "FA_ZIP", "domain": null, "name": "fa_zip", "alias": "Mailing Zip Code" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "FA_LADDR", "domain": null, "name": "fa_laddr", "alias": "Location Street Address" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "FA_LOCAT", "domain": null, "name": "fa_locat", "alias": "Location City" }, { "nullable": false, "editable": true, "defaultValue": null, "length": 9, "type": "esriFieldTypeString", "modelName": "FA_LZIP", "domain": null, "name": "fa_lzip", "alias": "Location Zip Code" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "FA_SIC", "domain": null, "name": "fa_sic", "alias": "Primary SIC Code" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "SecondarySIC", "domain": null, "name": "secondarysic", "alias": "Secondary SIC Code" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 6, "type": "esriFieldTypeString", "modelName": "FA_EMPS", "domain": null, "name": "fa_emps", "alias": "Number of Employees" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "BusinessAge", "domain": null, "name": "businessage", "alias": "Years in Business" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "CurrentUse", "domain": null, "name": "currentuse", "alias": "Current Use" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "LocationType", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_LocationType", "description": "Pollution Prevention facility location type from Tax Collector data", "type": "codedValue", "codedValues": [ { "code": "COMMERCIAL", "name": "Commercial" }, { "code": "RESIDENTIAL", "name": "Residential" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "locationtype", "alias": "Location Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "FA_GSTAT", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_GeneratorStatus_7", "description": "Pollution Prevention waste generator status", "type": "codedValue", "codedValues": [ { "code": "C", "name": "Very Small Quantity Generator" }, { "code": "L", "name": "Large Quantity Generator" }, { "code": "R", "name": "Small Quantity Generator" }, { "code": "U", "name": "Unverified Generator Status" }, { "code": "N", "name": "Not a HW Generator" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fa_gstat", "alias": "Generator Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 1, "type": "esriFieldTypeString", "modelName": "FA_VTYPE", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_Verification", "description": "Pollution Prevention facility verification type", "type": "codedValue", "codedValues": [ { "code": "P", "name": "Phone Call" }, { "code": "S", "name": "Survey" }, { "code": "V", "name": "Verification" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fa_vtype", "alias": "Verification Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 8, "type": "esriFieldTypeString", "modelName": "FA_VDATE", "domain": null, "name": "fa_vdate", "alias": "FDEP Verification Date (Required ex.20230630)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "FA_OCONT", "domain": { "name": "P2_Inspectors_7", "type": "codedValue", "codedValues": [ { "code": "Debra Boothe", "name": "Debra Boothe" }, { "code": "Pamela McRoy", "name": "Pamela McRoy" }, { "code": "Generic User", "name": "Generic User" }, { "code": "Debra Rutland", "name": "Debra Rutland" } ] }, "name": "fa_ocont", "alias": "County Inspector" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "FA_FCONT", "domain": null, "name": "fa_fcont", "alias": "Facility Contact" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "FA_CTITLE", "domain": null, "name": "fa_ctitle", "alias": "Facility Contact Title" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "ResponsiblePerson", "domain": null, "name": "responsibleperson", "alias": "Responsible Person" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "ResponsibleTitle", "domain": null, "name": "responsibletitle", "alias": "Responsible Person Title" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 10, "type": "esriFieldTypeString", "modelName": "FA_PHONE", "domain": null, "name": "fa_phone", "alias": "Facility Phone Number" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "Email", "domain": null, "name": "email", "alias": "Facility Email" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 2, "type": "esriFieldTypeString", "modelName": "P2InspectionZone", "domain": null, "name": "p2inspectionzone", "alias": "Inspection Zone" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "WaterProvider", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_WaterProvider_7", "description": "Pollution Prevention facility water source", "type": "codedValue", "codedValues": [ { "code": "Brevard County", "name": "Brevard County" }, { "code": "Barefoot Bay", "name": "Barefoot Bay" }, { "code": "Cocoa", "name": "City of Cocoa" }, { "code": "Melbourne", "name": "City of Melbourne" }, { "code": "Mims", "name": "Mims" }, { "code": "Palm Bay", "name": "City of Palm Bay" }, { "code": "Titusville", "name": "City of Titusville" }, { "code": "West Melbourne", "name": "City of West Melbourne" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "waterprovider", "alias": "Water Provider" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "SewerProvider", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_SewerProvider_7", "description": "Pollution Prevention facility waste water provider", "type": "codedValue", "codedValues": [ { "code": "Brevard County", "name": "Brevard County" }, { "code": "Barefoot Bay", "name": "Barefoot Bay" }, { "code": "Cocoa", "name": "City of Cocoa" }, { "code": "Melbourne", "name": "City of Melbourne" }, { "code": "Mims", "name": "Mims" }, { "code": "Palm Bay", "name": "City of Palm Bay" }, { "code": "Titusville", "name": "City of Titusville" }, { "code": "West Melbourne", "name": "City of West Melbourne" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "sewerprovider", "alias": "Sewer Provider" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "FireDistrict", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "FireDistrict_6_7", "description": "List of all Fire Districts", "type": "codedValue", "codedValues": [ { "code": "Brevard County", "name": "Brevard County" }, { "code": "KSC CCAFS", "name": "KSC CCAFS" }, { "code": "Cape Canaveral", "name": "Cape Canaveral" }, { "code": "Cocoa Beach", "name": "Cocoa Beach" }, { "code": "Satellite Beach", "name": "Satellite Beach" }, { "code": "Indian Harbour Beach", "name": "Indian Harbour Beach" }, { "code": "Indialantic", "name": "Indialantic" }, { "code": "Melbourne Beach", "name": "Melbourne Beach" }, { "code": "Titusville", "name": "Titusville" }, { "code": "Rockledge", "name": "Rockledge" }, { "code": "Cocoa", "name": "Cocoa" }, { "code": "Malabar", "name": "Malabar" }, { "code": "Palm Bay", "name": "Palm Bay" }, { "code": "Melbourne", "name": "Melbourne" }, { "code": "PAFB", "name": "PAFB" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "firedistrict", "alias": "Fire District" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 78, "type": "esriFieldTypeString", "modelName": "FA_COMM1", "domain": null, "name": "fa_comm1", "alias": "Comments 1" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 78, "type": "esriFieldTypeString", "modelName": "FA_COMM2", "domain": null, "name": "fa_comm2", "alias": "Comments 2" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "FA_NEXTW", "domain": null, "name": "fa_nextw", "alias": "Last Waste Record" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "FA_TOTAL", "domain": null, "name": "fa_total", "alias": "Total HW Produced per Year (lbs)" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "modelName": "FA_QMGT", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "P2_QMGT", "description": "Pollution Prevention questionable management code for FDEP", "type": "codedValue", "codedValues": [ { "code": "00000", "name": "No" }, { "code": "00001", "name": "Disposal" }, { "code": "00010", "name": "Storage" }, { "code": "00011", "name": "Storage/Disposal" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "fa_qmgt", "alias": "Questionable Management" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 8, "type": "esriFieldTypeString", "modelName": "FA_UPDATE", "domain": null, "name": "fa_update", "alias": "FDEP Last Edit Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 9, "type": "esriFieldTypeString", "modelName": "FA_DOL", "domain": null, "name": "fa_dol", "alias": "Department of Labor ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 16, "type": "esriFieldTypeString", "modelName": "FA_UTYPE", "domain": null, "name": "fa_utype", "alias": "FDEP Update Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 10, "type": "esriFieldTypeString", "modelName": "FA_LADNUM", "domain": null, "name": "fa_ladnum", "alias": "Location Address Number" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "FA_LADDIR", "domain": null, "name": "fa_laddir", "alias": "Location Address Direction" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "FA_LADTYPE", "domain": null, "name": "fa_ladtype", "alias": "Location Street Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 10, "type": "esriFieldTypeString", "modelName": "FA_LASUITE", "domain": null, "name": "fa_lasuite", "alias": "Location Suite Number" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "verificationdate", "domain": null, "name": "verificationdate", "alias": "Verification Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "fdepupdate_fa", "domain": null, "name": "fdepupdate_fa", "alias": "fdepupdate_fa" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "followupdate", "domain": null, "name": "followupdate", "alias": "Follow-up Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 29, "type": "esriFieldTypeDate", "modelName": "plannedassessmentdate", "domain": null, "name": "plannedassessmentdate", "alias": "Planned Assessment Date" }, { "nullable": true, "editable": true, "defaultValue": "5", "name": "fa_oname", "length": 2, "alias": "County Number", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "i533fa_num", "isUnique": false, "description": "", "fields": "fa_num", "isAscending": true }, { "name": "r318_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_318", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a183_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "9b60cf1eaeb34437b4e6aab26f307b84", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "yoffset": 18, "imageData": "iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7BAAAOwQG4kWvtAAAAGHRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuMzap5+IlAAANKUlEQVR4Xu1ZCVRV5RY+3HuZuYAUKmhmOeCQQk6piJpZWuKznHICAQFJGfR3QCFxVuZ5uFwGRQYZVAYB0bRXr171apn1eg3mwzlxRlQUgcv39v+T6/Vaunqr7sVbyVrfOsdz791nf9/e/7+/c5Skx3+PFXiswGMFHivwWIGOVkA5wlTqPkUp9XlVKfV1MZGeogQsOzqJjr6ffIaF5MI6y9aF2imqYrvLv0vvoahTPaWo4+drOxtUL39SFjbbWhpLiSk6Ojmd3s/RTHJa11WerX5ace09ByMc7W+Mr/ob4WvCv/oZ4Qu69klvBY70lENlJ7u27kmDHBcraYhOk+qo4NMtpXnJ3WW17xPR7waZ4vzzStS/YIPGsZ1x50U7NI7vipvOtrgy1Bon+5vhi15GONhDjkRb6fRcS2l+R+Wpk/vMNJM8M3oo6o85WeGHMd3Q6OqA1nmOaPMegrYlw6AJGI5W/+Fo8R2Ke+5OuDN9IK5N6IXvh3TBh73NkdHFoGGumeStk+R0HdTZWHo5s5fpxa9cnsYV10Fonvs8NG+NQNuq0cD6ccDWicC2CWjb6ILWdWPQvGoUmpYMR+OC59EwdTBOj++HT5zskGVvdGWakfSarvPVavzekmQb1dPso2MT+uKSq6Mg3+pP5EOdgWhXYKcvULQSKAgA0mahLfJFtG5yRvOaUbjjPwy3Fjih/rXn8O8XB+LjYT0R28Xs0wmS1E2rSeoy2JvWCv/9I3rg9KuDqa0d0eJH7R4yisi/ChQT8Q+zgWMVwD8KgIqNJMIMtG13QctGZzQFj8Rtv6G4MWsQLk/sj6/GDECNQzf4WSlW6DJnbcY2j+lm+Pej4/vi2pRBtLafR8vKkWjb7AKo5wFHEoGTHwENZ9F24RjaPs1BW7E/2uJfRstmEiCUBAgahhvujrg6ZQBOufTDp4OeRbKN8dEBkmSjzUR1EquvQhqTbS+/dnzU07j1uhOafIehJWQ02raRADmeaPssE5rLn0LTeg6aW19Cc6IImvfXo63IDa2qabi3eSxuLycBvJ1w9Y2BuDBhAL50sMc+M0WTq0Iap5OktRl0jqUUkGtnoKntb4FbU/vhLq395rdHQxP/CtrK34LmaCI0p8qhufQ+NOdqoPlSDc3hYGhKF6G5xBNNWW/i9obxqPdxwhVaBhecn8F3tqaolMvgZSIxbeaqk1irbaTwUnsZTj0jQ4OzFRo9Haiq49BS6AZNxWJojqyB5rM4aL4g4keToXkvTFxvKfHAvaKFuJvvgcb0OagPGomLk7rjXB8jnLQwwLsKBdZaGCToJGltBg3tJCXs70oCkKurH2qMm290wp2IMbiXO4NEmIPWvQuhqVwKzUEGTXUQNOW+aN3jgWYS6O6uuWjMmI5bSVNxPXg4zo80wbluEs6ZyfGB3BBh5gYZ2sxVJ7GCLaWIfZ0lnHhKhmuDDXFjrj1uRznjbso43EufgObsyWjJeQ2tu1zpOJXgStdc0ZQ+GY2JL+FmpAvqN43E1ZAROP/yE7jQRUKdoQJ/U8gRqpSSdJK0NoN6KCWWYyO1fWNngEsOMlz36I2b4S64HTcOdxLHoyn1RTSljcc9FT8SUsfjbtI4NMa54CYJdWPLaFwLewGXVw/HhWk9cdVahjqZAoeNZVhkKa3RZq46iTWUHGC20qDh6JPUuj0kXHXrQxUdjYbto3EregwJMRaNCYREIs2P8WNxK8YFDRHOqN86ksiPwOXgoahbNoQcZB/cNFbgjEyOamtZ8xRLaZJOktZyUOskC9mxD6wM8L0tte/rXXFpzQBcCSOfv+U5XN8+GPURg3Ej0pGOhPDBuL51EK5uHIjL6/qjLtgBPyzrjQu+RH5sd9w0MMTXpjJk28m+eaGz1EXLueomnLeJFFJlosA/zQ1w5gUTnF3yBM6vtMWFkM6oW98VFzfY4dImO1zcSKDzurCuOB9ii7OrnsCZQBuc87HBlXm2uOOgxAWFDB/bG4LZK9ZTtjLdZKzlqAPpDU+SifyrozS6/m0rx+mZpqj1M0dtgAVOrSCsUuJUMGE1gc5P0rXaIHOcpO+cXWiBi7Ot0DBZiWud5Pi2iyHUzxp/M/FJqY+W09RtuAWm8hl7jOS3vqEN7HQfE5yarcQJdyW+97LA974WOO7XDn5+wotEcFPiLBGve70Trk61wpV+xjhhb4Ty/uaNgU+bzNNttrqJLvcxk1aWGcqavpWTCA5mODPFGqen04uPmdaondV+PDWjE85O64Tzrk+gbooN6l6zwrkhpviulymqHJXNQb1M1lJ6ct2kqPuoikXmUmCRqXTlcxpjtd2NUTvKEqcnEulXOuHcJFrvkwmTOuHMJBLkJUvUDrfA546WKBmivB7Yx4Q/ARrqPk0d32GyufRSgo1BTam17PbnXRQ43tcUx4fREhitxHEXSxwfa4XjZJuPjbBE+XCrxhRH5aG/2Msn6jitDg9vPsdWmpnylFGGqofxx1k9jc8X9DJtyO9n1pA10OKHNCerT9KGWGR59JDPoswsOjy7Dr5ht8XuixAfFkZYB183L9D9u3dwDo/2doEsDNlZ+QJLlr3NBfhz/S0l0pkZeQJ+gaF/PgH8gkKhVu8S8A0I+fMJsDgwBCpVjoC3/9o/nwDeS9cgNW0HUlN3YNHS4F8twF+PHGTvHq5h775Tw44IHCQcEODX+ed6ubksems1klOyBTzfWvV/C8BJvnOomh2qqWQ11RXsQFU5q6os/RFlrGp/Oavcz4+lrLqyTHx+8MB+dph+o1dieC1eiaSkTAEPv5W/KAAnwIlwYvvL97Ly0hJWuq+Y7dtTyPaW7G5H8W62p7iQlYgj/Zs+K91bJL5bWbFPCMbj6EVHeC5egYTEDIGFdP6wpA6/Uy0S5wTKiDAnWlyYxwoLdrGCvByWn7uD5e3KZnk5dCTk7sxuRw5do8925+9iRbvzxO/Ky0pER+iFCAt9GeLi0wXc6fxBArxzqEq0dum+IqpqPpHJEWRzdmSw7Kx0lpWhYhnqVKZO/xGqVJaelsLSVSl0LYVlqtPYjiw1iZElfstF4N3DO+mRd4G7D0NMrErgQQLwdV5J7c7beHdBDttFJDjpDCKrSktiqSkJLCUpniUnxrGkxFgCHRM4+Hms+CwtJZGpSQz+u1wSjncOXw68ox75fuDmsxxRMakC7r7/uwT47s03ME6+gCq3I1stKsoJcaIJ8TEsLjaKxcVEstjoCBYTHU5Hfk6IiRDXE+KihThpqYmiS3JIwMLCXFZWWiwEeOQdsMB7GSKiUgR4N/w0IV798rI9rHB3LttJ7Z6uSmbJVNF4IsUJR0eFs+jI7QJREdsEoiPDWQxd5wLEkziJJBLvgvS0ZJaVqRL7wZ6SAra/Yq9+7AELFgVhe0SSwM+t8KGaKlr3JSyfNrmszHRReU6IVzgq4r+k28lzIYh4VCRVPkpUnneJaH/qmh3U/nm51P5F+ayifA87WKMH659Xe75XILaFJ2Ir4edW+NABEmAvCZBLAqjTWWpSIhGLoQpHsMjwbQLtQmwX10TF42JZckI8S01OaF/3JBzfN3bTtOCbHyfPvcMjb/37CczzDMCWbfECP7fC3MXx3bqQxtfO7AymSk2iDogV7R/FW5+3OnUDF4W3uSo1mTbHNEGaTwje7nz0cY/A4/A1z/cVvSHPE5m70B+btsYJPMgK1xyoYPvIxOTn7hTjjBPllRZr/McNjo+8bDHm+LzPpV0+nzbO9nlfRZsor/i7R/SM+P0qcCe4YXOMwMOsMCdRUlzAcnZmitHHx1tCfLRY39wD5O3aIdY2H23VldzyVtIGV6VflX5Y23EnGLYxWuBhVriGDAsfhXwt3x+DfKzxyVBEE0JsavSdRz7Tf83a4k7w7Q1RhMiHWmFObm9JIa3rTDHLObgn4FXn3fG7JH5fLD77Q8IiBB5mhbkT5Lv4T8kXkZurJj//a0TXq99wJ7h23XaBBwlwiNZzSRGtf6o+9/q88twYVVeV/f7J80pwJxgcuk3g51b48KEDrHRPcXvr03jLVKvELl9ZUfrHIC8EICe4au0WgZ9aYb6u+TM8n/9qerrj5PljbjW96NCrFv6tyXAnuGLNZgG+HO7H48/8fNfnY487Oj7juZn5rffTu99zJ7h89SYBN1oOPEH+oMLXOp/z3NJyZ8fNkN4lr42EuBMMWrlBwM07SAjADQ+f8/xZn7u/0r3Ff0zynOzsBX4IWLFeYIGnvxAgPo4eauiFRmZGmpj1eufftVH5+zGmv+kF/+XrsJQwZ8FiIcD6sFDxsoOPO7318NoQYXXwWri+MR8ePkFY5Mcwc44n3D28sGoVI5ubqR/v7LRB9EExkpMSsGSpP6ZMm435C/3g5rUEb8yaj/lu7li9eiXK6EWIru6tF3FTUxIREBCIadNnY66bN+a7+2DGzDfh4+OLbVu3/OL/D+gFid+SBL3qQmxsDIKWLYfv4iUCy+g8MiIcuwvy/tjV/6lwarVKVHzrls1IV6U9ssr/B/nPip6ML1zOAAAAAElFTkSuQmCC", "xoffset": 0, "width": 18, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "http://gis.brevardfl.gov/portal/portalimages/Symbols/Basic/RedStickpin.png", "height": 18 }, "type": "simple" }, "transparency": 0 }, "geometryField": { "modelName": "Shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint" } ] }