FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION

TITLE: SOLID WASTE FACILITIES - JULY 2019

Geodataset Name:       SLDWST_JUL19
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         11181
GENERAL DESCRIPTION:
Statewide coverage of Water Assurance Compliance System (WACS) Solid Waste Facilities
DATA SOURCE(S):                    Florida Department of Environmental Protection
SCALE OF ORIGINAL SOURCE MAPS:     Digital Ortho Quads (DOQs) 1 mt resolution.
GEODATASET EXTENT:                 State of Florida
PUBLICATION DATE: 19990630 TIME PERIOD OF CONTENT: Begin Date: 19990630 End Date: 20190702 DOWNLOAD LINK: http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: SLDWST_JUL19.DBF
ITEM NAME WIDTH TYPE
OBJECTID
4 OID
Shape
4 Geometry
FACILITY_I
8 Double
FACILITY_N
60 String
FACILITY_T
50 String
FACILITY_S
50 String
STATUS_DAT
36 Date
OBJECT_OF_
40 String
CLASS
50 String
CLASS_STAT
50 String
OWNERSHIP
50 String
ADDRESS
50 String
CITY
50 String
ZIP5
8 Double
ZIP4
4 Integer
DISTRICT
4 String
OFFICE
80 String
COUNTY_ID
4 Integer
COUNTY
12 String
PROXIMITY_
254 String
LAT_DD
4 Integer
LAT_MM
4 Integer
LAT_SS
8 Double
LONG_DD
4 Integer
LONG_MM
4 Integer
LONG_SS
8 Double
DATUM_ID
10 String
COORDINATE
254 String
ACCURACY_L
4 Integer
ACCURACY
90 String
QA_STATUS
12 String
COLLECTOR_
30 String
COLLECT_DA
36 Date
VERIFIER_U
30 String
VERIFICATI
36 Date
VERIFY_MET
4 String
DOCUMENTS
130 String
REPORTS
130 String
LAT_DD_1
8 Double
LONG_DD_1
8 Double
MGRS
15 String
GOOGLEMAP
100 String
DESCRIPT
48 String
FGDLAQDATE
36 Date
AUTOID
4 Integer

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item
Item Description
OBJECTID Internal feature number.

Shape Feature geometry.

FACILITY_I Facility ID

FACILITY_N Facility name

FACILITY_T Facility type

FACILITY_S Facility status

STATUS_DAT Date associated with facility status field

OBJECT_OF_ The Object of Interest (the thing regulated, permitted, or tracked). While the BIS Applications group will maintain the Object of Interest code table, the program area will be responsible for determining the taxonomy of codes needed to support their applications and business decisions.

CLASS Class or type of site. For example: landfill, tire disposal, yard trash, etc.

CLASS_STAT Class status

OWNERSHIP Type of ownership

ADDRESS Site address

CITY City where site is located

ZIP5 5-Digit zip

ZIP4 4-Digit zip

DISTRICT Florida Department of Environmental Protection district where site is located
CD = Central District

NED = North East District

NWD = North West District

SED = South East District

SWD = South West District

SD = South District


OFFICE District office

COUNTY_ID County ID. 1-67

COUNTY Florida county where site is located

PROXIMITY_ Description of proximity of point to actual feature being represented

LAT_DD Latitude - Degrees location identifier

LAT_MM Latitude - Minutes location identifier

LAT_SS Latitude - Seconds location identifier

LONG_DD Longitude - Degrees location identifier

LONG_MM Longitude - Minutes location identifier

LONG_SS Longitude - Seconds location identifier

DATUM_ID Datum Identifier
HPGN = High Precision GIS Network / High Precision Geodetic Reference

NAD27 = North American Datum of 1927

NAD83 = North American Datum of 1983

WGS84 = World Geodetic Survey of 1984


COORDINATE Method by which coordinates were acquired

ACCURACY_L Coordinate accuracy level codes
1 = +/-0.01 meter

2 = 0.02 to 1.0 meter

3 = 1.1 meter to 10 meters

4 = 10 meters to 20 meters

5 = 20 meters to 50 meters

6 = > 50 meters


ACCURACY Accuracy level
< 0.01 M = CSUR - Cadastral or Land Survey

< 0.1 M = GGPS - Geodetic Quality C/A Code and Carrier Phase GPS

1-5 M = DGPS - Differentially Corrected C/A Code Phase GPS

3-7 M = WGPS - C/A Code Phase GPS with Wide-Area Augmentation Service Correction

5-10 M = DPHO - Digital Aerial Photography

5-50 M = AGPS - Autonomous C/A Code Phase GPS

5-100 M = DMAP - Digital Map Interpolation

20-150 M = CALC - Calculated by GIS Software

50-150 M = LORN - LORAN-C Navigational Device

50-150 M = ADDM - Address Matching / Precision Mapping

50-150 M = MPHO - Manual Aerial Photography With Ground Control

> 150 M = MMAP Manual Map Interpolation

> 150 M = SATI - Satellite Imagery

< 1 Km = ZIP2 - ZIP Code + 2 Segment Centroid

< 0.5 Km4 = ZIP4 - ZIP Code +4 Segment Centroid

< 2 Km4 = ZIPC - ZIP Code Centroid

N/A = Other or unknown


QA_STATUS Reviewing status

COLLECTOR_ The name of the person taking the measurement

COLLECT_DA The date and time on which the measurement was taken

VERIFIER_U Person or FDEP program verifying info

VERIFICATI Date of verification

VERIFY_MET Method of verification
DPHO = Digital Aerial Photography With Ground Control


DOCUMENTS Links to documents in the DepNexus repository

REPORTS Link to facility reports

LAT_DD_1 Latitude in decimal degrees.

LONG_DD_1 Longitude in decimal degrees.

MGRS Military Grid Reference System (MGRS) Coordinate of the Facility. The MGRS is the geocoordinate standard used by NATO militaries for locating points on the earth. The MGRS provides a means to represent any location on the surface of the Earth using an alphanumeric string. Hierarchical references are based on the Universal Transverse Mercator (UTM) coordinate system. The MGRS is used for the entire earth. http://mgrs-data.org/

GOOGLEMAP Webpage hyperlink to location in Google Maps.

DESCRIPT FGDL added field based on CLASS

FGDLAQDATE FGDL added field based on date downloaded from source

AUTOID Unique ID added by GeoPlan


USER NOTES:
Layer was created in ArcGIS 9.2.
Layer has not been completed
GeoPlan relied on the integrity of the attribute information within
the original data.
The Solid Waste Program regulates (permitting, compliance, enforcement) 
the design, construction, operation and maintenance of Solid Waste Facilities. 
It ensures the proper closure and long-term monitoring and maintenance of 
those facilities which have concluded useful production, or which are otherwise 
required by rule to be closed. The program also administers financial responsibility 
requirements designed to guarantee that owners/operators have the financial 
ability to properly close and manage the Solid Waste Facilities

To compile facility specific information on Solid Waste Management 
facilities statewide and monitor their potential to impact ground water.

Accuracy of this layer is intend for displaying the general location of these 
facilities. Layer need revision since the Object of Interest Code was added

Vertical measurements not included in data set yet.

The locational data point of each is provided by the responsible party and 
reviewed by the Florida Department of Environmental Protection (FDEP) 
agency staff. FDEP makes no representations of any kind, including, but 
not limited to, the warranties of merchantability or fitness for a particular use, 
nor are any such warranties to be implied with respect to the digital data layers 
furnished hereunder. FDEP assumes no responsibility to maintain them in any 
manner or form. By using data provided herein, the user acknowledges that 
terms and conditions have been read and that the user is bound by these criteria.

The Florida Geographic Data Library is a collection of Geospatial Data
compiled by the University of Florida GeoPlan Center with support from
the Florida Department of Transportation. GIS data available in FGDL is
collected from various state, federal, and other agencies (data sources)
who are data stewards, producers, or publishers. The data available in
FGDL may not be the most current version of the data offered by the
data source. University of Florida GeoPlan Center makes no guarantees
about the currentness of the data and suggests that data users check
with the data source to see if more recent versions of the data exist.

Furthermore, the GIS data available in the FGDL are provided 'as is'.
The University of Florida GeoPlan Center makes no warranties, guaranties
or representations as to the truth, accuracy or completeness of the data
provided by the data sources. The University of Florida GeoPlan Center
makes no representations or warranties about the quality or suitability
of the materials, either expressly or implied, including but not limited
to any implied warranties of merchantability, fitness for a particular
purpose, or non-infringement. The University of Florida GeoPlan Center
shall not be liable for any damages suffered as a result of using,
modifying, contributing or distributing the materials.

A note about data scale: 

Scale is an important factor in data usage.  Certain scale datasets
are not suitable for some project, analysis, or modeling purposes.
Please be sure you are using the best available data. 

1:24000 scale datasets are recommended for projects that are at the
county level.
1:24000 data should NOT be used for high accuracy base mapping such
as property parcel boundaries.
1:100000 scale datasets are recommended for projects that are at the
multi-county or regional level.
1:125000 scale datasets are recommended for projects that are at the
regional or state level or larger.

Vector datasets with no defined scale or accuracy should be
considered suspect. Make sure you are familiar with your data
before using it for projects or analysis. Every effort has been
made to supply the user with data documentation. For additional
information, see the References section and the Data Source Contact
section of this documentation. For more information regarding
scale and accuracy, see our webpage at:
http://geoplan.ufl.edu/education.html

REFERENCES:
FDEP Solid Waste Info:
https://floridadep.gov/waste/permitting-compliance-assistance/content/solid-waste-section

DATA LINEAGE SUMMARY:
Features were digitized by looking the 1994, 1999 2004 Digital Ortho Quads 
on the screen. The department used flat maps, micro fish, and the application 
to find GIS locations.
Process Date: 2000

Layer updated with the revised script as requested by Lee Martin and Casey Taylor: CREATE OR REPLACE VIEW waste_facs_pt_geometry_vw ( facility_id, facility_name, facility_type, facility_status, status_date, object_of_interest, class, class_status, ownership, address, city, zip5, zip4, district, office, county_id, county, proximity_id, lat_dd, lat_mm, lat_ss, long_dd, long_mm, long_ss, datum_id, coordinate_method_id, accuracy_level, accuracy, qa_status, collector_user_name, collect_date, verifier_user_name, verification_date, verify_method_id, geometry, objectid ) AS SELECT wf.wacs_facility_id facility_id, wf.name facility_name, (select Initcap(description) from wacs.wacs_facility_type_codes where wacs_facility_type_id = wf.wftc_wacs_facility_type_id) facility_type, (select Initcap(description) from wacs.facility_status_codes where facility_STATUS_ID = wf.fsc3_facility_status_id) facility_status, wf.facility_status_date, (Select Initcap(Name) from FDM.object_of_interest_codes where object_of_interest_id = gl.oic_object_of_interest_id) object_of_interest, decode(gl.oic_object_of_interest_id, 'DISPS',(select description from wacs.facility_class_type_codes, wacs.solid_waste_landfills sl where sl.solid_waste_landfill_id = gl.swl_solid_waste_landfill_id and facility_class_type_id = sl.fctc_facility_class_type_id) , 'PROCE',(select description from wacs.facility_class_type_codes, wacs.solid_waste_processings sp where sp.solid_waste_processing_id = gl.swp_solid_waste_processing_id and facility_class_type_id = sp.fctc_facility_class_type_id),null) class_type, decode(gl.oic_object_of_interest_id, 'DISPS',(select Initcap(description) from wacs.facility_status_codes, wacs.solid_waste_landfills sl where sl.solid_waste_landfill_id = gl.swl_solid_waste_landfill_id and facility_status_id = sl.fsc3_facility_status_id), 'PROCE',(select Initcap(description) from wacs.facility_status_codes, wacs.solid_waste_processings sp where sp.solid_waste_processing_id = gl.swp_solid_waste_processing_id and facility_status_id = sp.fsc3_facility_status_id),null) class_status, (select Initcap(description) from wacs.wacs_ownership_type_codes where WACS_ownership_type_ID = wf.wotc_wacs_ownership_type_id ) owner_type, wf.address, Initcap(wf.city), wf.zip5, wf.zip4, wf.dis_district_abbreviation district, (select Initcap(Name) from fdm.office_codes oc where oc.office_id = wf.oc2_office_id and oc.ddc_dep_district_id = wf.dis_district_abbreviation), wf.cc_county_id county_id, (select Initcap(Name) from BIS_LIB.county_codes where county_id = wf.cc_county_id), (select description from fdm.proximity_codes where gl.PC2_proximity_id = proximity_id), gl.lat_dd_nbr,gl.lat_mm_nbr,gl.lat_ss_nbr,gl.long_dd_nbr,gl.long_mm_nbr,gl.long_ss_nbr, gl.DC4_DATUM_ID, (select description from fdm.coordinate_method_codes where CMC2_COORDINATE_METHOD_ID = COORDINATE_METHOD_ID), gl.CALC_COORD_ACCURACY_LEVEL_ID, (select Range_begin||' - '||Range_end||' meters' from BIS_LIB.coordinate_accuracy_codes where coordinate_accuracy_id = gl.CALC_COORD_ACCURACY_LEVEL_ID), Initcap(gl.VSC1_VERIFICATION_STATUS_ID), /* Fields following this comment will be needed by DQD. */ gl.COLLECTOR_USER_NAME, gl.COLLECT_DATE, gl.VERIFIER_USER_NAME, gl.VERIFICATION_DATE, gl.CMC2_VERIFIED_COORD_METHOD_ID, CASE when long_dd_nbr < 78 THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when long_dd_nbr > 88 THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when long_dd_nbr is NULL THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when long_mm_nbr < 0 THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when long_mm_nbr >= 60 THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when long_mm_nbr is NULL THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when long_ss_nbr < 0 THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when long_ss_nbr >= 60 THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when long_ss_nbr is NULL THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when lat_dd_nbr < 23 THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when lat_dd_nbr > 32 THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when lat_dd_nbr is NULL THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when lat_mm_nbr < 0 THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when lat_mm_nbr >= 60 THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when lat_mm_nbr is NULL THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when lat_ss_nbr < 0 THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when lat_ss_nbr >= 60 THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) when lat_ss_nbr is NULL THEN MDSYS.SDO_GEOMETRY(2001, 1000001, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL) ELSE mdsys.sdo_cs.transform( -- trasnform from lat/long to albers mdsys.sdo_geometry ( -- create the lat/long geometry 2001, -- 2D point feature decode(dc4_datum_id, 'NAD27', 8260, 'NAD83', 8265, 'WGS84', 8307, 'HARN', 8265, NULL, 8265, 8265), -- cover the datums we are likely to find mdsys.sdo_point_type( -- make a point from the lat/long ( -(abs(NVL(long_dd_nbr,0)) + (NVL(long_mm_nbr,0)/60) + (NVL(long_ss_nbr,0)/3600)) ), (abs(NVL(lat_dd_nbr,0)) + (NVL(lat_mm_nbr,0)/60) + (NVL(lat_ss_nbr,0)/3600)), null), null, -- no element info array null ), -- no ordinate array 1000001 ) END geometry, -- transform to the fdep albers srid rownum FROM wacs.wacs_facilities wf, wacs.wacs_geographic_locations gl WHERE wf.wftc_wacs_facility_type_id in (3) AND gl.oic_object_of_interest_id IN ('FACIL' , 'DISPS' , 'PROCE') AND wf.wacs_facility_id not in -- new exclude query per Lee Martin 10-24-11 ( SELECT distinct wf1_wacs_facility_id from wacs.FAC_WASTES_HANDLED fwh WHERE fwh.WTC_WASTE_TYPE_ID = 161 union select distinct wf1_wacs_facility_id from wacs.solid_waste_landfills where fctc_facility_class_type_id = 530 or fsc3_facility_status_id = 'M' union select distinct wf1_wacs_facility_id from wacs.solid_waste_processings where fctc_facility_class_type_id = 530 or fsc3_facility_status_id = 'M' ) AND wf.wacs_facility_id = gl.wf1_wacs_facility_id AND GL.WACS_GEO.SDO_GTYPE IN (2001) Order by facility_id, facility_status Process Date: 20121102
Added 2 new fields DOCUMENTS and REPORTS. These fields contain document links to DepNexus and links to a reporting application respectively. Process Date: 20171220
This dataset was downloaded by the GeoPlan Center on 7/8/2019 from the FDEP website (http://geodata.dep.state.fl.us/). The data was received as a geodatabase and was in the following projection: NAD_1983_HARN_Florida_GDL_Albers. - Added a DESCRIPT field based on CLASS - Added fields LAT_DD_1, LONG_DD_1, MGRS, and GOOGLEMAP. LAT_DD_1 and LONG_DD_1 were calculated using the calculate geometry command and selecting decimal degrees as the units. MGRS was calculated using the Convert Coordinate Notation tool and selecting Output coordinate Format as MGRS. The GOOGLEMAP field was calculated by concatenating: "https://www.google.com/maps/place/" & [MGRS]. - Added FGDLAQDATE field based on date downloaded from source - Upcased all records in the table except for DOCUMENTSand REPORTS fields. - Updated metadata ground condition to reflect changes apparent in the data as noted in the COLLECT_DA field (7/2/2019) - Changed name of data set from WASTE_FACS_PT_SP to sldwst_jul19 Process Date: 20190708
Dataset copied. Process Date: 20190721
MAP PROJECTION PARAMETERS:

Projection                          ALBERS
Datum                               HPGN
Units                               METERS
Spheroid                            GRS1980
1st Standard Parallel               24  0  0.000
2nd Standard Parallel               31 30  0.000
Central Meridian                   -84 00  0.000
Latitude of Projection's Origin     24  0  0.000
False Easting (meters)              400000.00000
False Northing (meters)             0.00000

DATA SOURCE CONTACT (S):

Name:
Abbr. Name:
Address:


Phone:

Web site:
E-mail:
Contact Person:
         Phone:
        E-mail:
Florida Department of Environmental Protection (FDEP) OTIS/GIS Section
FDEP
2600 Blairstone Road
Tallahassee, Florida
32399-2400
(850) 245-8758

http://geodata.dep.state.fl.us/ GIS.Librarian@dep.state.fl.us Chris Williams

FGDL CONTACT:
Name:                   FLORIDA GEOGRAPHIC DATA LIBRARY
Abbr. Name:             FGDL
Address:                Florida Geographic Data Library
                        431 Architecture Building
                        PO Box 115706
                        Gainesville, FL  32611-5706
Web site:               http://www.fgdl.org

Contact FGDL: 

      Technical Support:	        http://www.fgdl.org/fgdlfeed.html
      FGDL Frequently Asked Questions:  http://www.fgdl.org/fgdlfaq.html
      FGDL Mailing Lists:		http://www.fgdl.org/fgdl-l.html
      For FGDL Software:                http://www.fgdl.org/software.html