|
FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION VERSION 2007 TITLE: TANKS - NOV 2007 Geodataset Name: TANKS_NOV07 Geodataset Type: SHAPEFILE Geodataset Feature: Point Feature Count: 89038 |
|
GENERAL DESCRIPTION:
|
|
DATA SOURCE(S): Florida Department of Environmental Protection SCALE OF ORIGINAL SOURCE MAPS: N/A DATE OF AUTOMATION OF SOURCE: 20071107 GEODATASET EXTENT: State of Florida |
FEATURE ATTRIBUTE TABLES:
Datafile Name: TANKS_NOV07.DBF
| ITEM NAME | WIDTH | TYPE | N. DECIMAL DEGREES |
|
LAT_DD
|
7 | Number | --- |
|
LAT_MM
|
19 | Number | 4 |
|
LAT_SS
|
9 | Number | --- |
|
LONG_DD
|
9 | Number | --- |
|
LONG_MM
|
19 | Number | 4 |
|
LONG_SS
|
9 | Number | --- |
|
COLLECT_CM
|
20 | String | --- |
|
SWSC_SWAP_
|
10 | String | --- |
|
TANK_ID
|
5 | String | --- |
|
SC5_SUBSTA
|
32 | String | --- |
|
FACSUB
|
8 | Date | --- |
|
LAT_DMS
|
4 | Number | --- |
|
LONG_DMS
|
7 | Number | --- |
|
LATITUDE
|
7 | Number | --- |
|
LONGITUDE
|
4 | Number | --- |
|
X
|
9 | Number | --- |
|
Y
|
20 | String | --- |
|
COUNTY
|
50 | String | --- |
|
FAC_ID
|
14 | String | --- |
|
FAC_NAME
|
14 | String | --- |
|
FAC_ADDR
|
19 | Float | 11 |
|
FAC_CITY
|
45 | String | --- |
|
FAC_ZIP
|
19 | Float | 11 |
|
FPHONE
|
25 | String | --- |
|
FAC_STAT
|
19 | Float | 11 |
|
FAC_TYPE
|
10 | String | --- |
|
TYPEDESC
|
19 | Float | 11 |
|
FGDLAQDATE
|
14 | Number | --- |
|
AUTOID
|
71 | String | --- |
|
SUBSTANCE
|
30 | String | --- |
|
DESCRIPT
|
85 | String | --- |
|
TANK_COUNT
|
85 | String | --- |
|
SHAPE
|
4 | Geometry | --- |
FEATURE ATTRIBUTE TABLES CODES AND VALUES:
| Item | Item Description | |
| LAT_DD |
Latitude Degrees |
|
| LAT_MM |
Latitude Minutes |
|
| LAT_SS |
Latitude Seconds |
|
| LONG_DD |
Longitude Degrees |
|
| LONG_MM |
Longitude Minutes |
|
| LONG_SS |
Longitude Seconds |
|
| COLLECT_CM |
FDEP field |
|
| SWSC_SWAP_ |
FDEP field |
|
| TANK_ID |
Tank ID Number |
|
| SC5_SUBSTA |
Substance
|
|
| FACSUB |
Facility ID and Tank Substance |
|
| LAT_DMS |
Latitude Degrees Minutes Seconds |
|
| LONG_DMS |
Longitude Degrees Minutes Seconds |
|
| LATITUDE |
Latitude |
|
| LONGITUDE |
Longitude |
|
| X |
ESRI item which denotes the X coordinate of the geocoded feature. |
|
| Y |
ESRI item which denotes the Y coordinate of the geocoded feature. |
|
| COUNTY |
County Code to County Name Conversion, Number to Name.
|
|
| FAC_ID |
Facility Identification Code |
|
| FAC_NAME |
Facility Name |
|
| FAC_ADDR |
Facility Address |
|
| FAC_CITY |
Facility City |
|
| FAC_ZIP |
Facility Zip Code |
|
| FPHONE |
Phone number |
|
| FAC_STAT |
Facility status codes
|
|
| FAC_TYPE |
Facility type codes
|
|
| TYPEDESC |
The Description of the type of facility that has the tank.
|
|
| FGDLAQDATE |
FGDL added field based on date downloaded from source |
|
| AUTOID |
Unique ID added by GeoPlan |
|
| SUBSTANCE |
Type of Substance in Tank |
|
| DESCRIPT |
Site Name, Tank Substance, Number of Tanks |
|
| TANK_COUNT |
Number of Tanks |
|
| SHAPE |
Feature geometry. |
This data is provided 'as is'. GeoPlan relied on the integrity of the original data layer's topology |
This data is provided 'as is' by GeoPlan and is complete to our knowledge. |
GeoPlan relied on the integrity of the attribute information within the original data. |
This dataset is a combination of regulated and unregulated storage tanks from the Florida Department of Environmental Protection (FDEP). The data does not include facilities deemed to be sensitive by the FDEP. Requests for sensitive facilities need to be sent to the appropriate division of FDEP. Tank Facility - All Locations & Lat/Long Information (by County) [November 7, 2007] Excel spreadsheet of the regulated and unregulated facilities registered with the Department and tracked for active storage tanks, storage tank history, or cleanup activity. Information includes facility identification number, site location information with latitude/longitude, and facility type and status. Data is taken from the Storage Tank & Contamination Monitoring database. FLORIDA DEPARTMENT OF ENVIRONMENTAL PROTECTION STORAGE TANK AND CONTAMINATION MONITORING DATABASE CODES LIST ftp://ftp.dep.state.fl.us/pub/reports/codes/fs_codes.pdf SPECIAL NOTE: This dataset was created from a database dump, which included regulated and unregulated tanks, not the spreadsheets by county, which include only regulated tanks, and are available at: http://www.dep.state.fl.us/waste/quick_topics/database_reports/pages/stcm/storagetank/stcm_allll.htm Like previous datasets, except this dataset includes unregulated tanks as well as regulated tanks, also this dataset includes tanks that contain petroleum as well as other substances. The database provides more point locations and latitude and longitude for every point. The county spreadsheets, available online, only contain regulated tanks and do not contain as many latitude and longitude coordinates. What is Geocoding? Geocoding is term used to describe the act of address matching. Geocoding is the process of finding a geographic location (x, y point) for an address (such as street number and name, city, state, and ZIP Code) on a map. Geocoding is based off the typical address scheme for the US, in which one side of the street contains even house numbers while the other side of the street contains odd house numbers. The geocoding process uses an algorithm to find the geographic location of addresses. First, a street segment is identified using the zip code and street name. Next, the geographic location of the address is matched using the building number to determine how far down the street and on which side of the street the building is located. Geocoding Accuracy The locational accuracy of geocoded addresses may vary from urban to rural areas due to the algorithm used to generate the geographic locations of addresses. The algorithm assumes that the size of parcels are equivalent along a road route. This assumption tends to be more consistent in urban areas, where the size of parcels vary less than in rural areas. Consequently, the results of geocoded addresses in urban areas are usually more reliable than those in rural areas. For example, the locational accuracy of rural addresses can be slightly off because some parcels along a rural route may be 15 acres while others may be 2.5 acres, but the geocoding algorithm assumes that the addresses are distributed evenly along the route. |
The data was created to serve as base information for use in GIS systems for a variety of planning and analytical purposes. |
This data is provided 'as is' and its horizontal positional accuracy has not been verified by GeoPlan |
This data is provided 'as is' and its vertical positional accuracy has not been verified by GeoPlan |
THE DATA INCLUDED IN FGDL ARE 'AS IS' AND SHOULD NOT BE CONSTRUED AS LEGALLY BINDING. 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 |
Florida Department of Environmental Protection website: http://www.dep.state.fl.us/waste/quick_topics /database_reports/pages/stcm/storagetank/stcm_allll.htm http://www.dep.state.fl.us/waste/quick_topic /database_reports/pages/stcm/petro_reports.htm http://www.dep.state.fl.us/waste/quick_topics /database_reports/pages/stcm/storagetank_reports.htm http://www.dep.state.fl.us/waste/quick_topics /database_reports/pages/stcm/stcm_reports.htm http://www.dep.state.fl.us/waste/quick_topics /database_reports/default.htm |
Received 4 spreadsheets containing petroleum tank locations from Ruchi Manchanda (FDEP, 850-245-8250) on 11/07/07. The data was provided in Excel spreadsheets. The fields LT_SS and LG_SS were formatted as numbers with 4 decimal places. The spreadsheets were exported as a dbf 4. The spreadsheets were combined into a single dbf 4 using the Append tool in ArcGIS There were originally 181861 records in the datasets provided. An ID field was added and calculated by OID + 1 Duplicate records were deleted *A new field was created (FACSUB) and calculated by combining the FACID and the tank substance (SC5_SUBSTA) to get field values similar to "850001 - A". *The data was then summarized by the new FACSUB field to return the minimum AUTOID for each unique record and calculate a count field. *This database was joined to the original dataset based on the AUTOID field. *The records that had an AUTOID were selected and exported as a new database. *This was done in order to create a database that included all locations that had a tank, but multiple records for places that had multiple tank substances on site. Added LAT_DMS and LONG_DMS fields (Text fields with length of 14) Calculated LAT_DMS with LAT_DMS = [LAT_DD] & " " & [LAT_MM] & " " & [LAT_SS] Calculated LONG_DMS with LONG_DMS= [LONG_DD] & " " & [LONG_MM] & " " & [LONG_SS] Added LATITUDE field (Double) Added LONGITUDE field (Double) Calculated LATITUDE field with LATITUDE = ([LAT_SS]/3600)+( [LAT_MM]/60)+ [LAT_DD] Calculated LONGITUDE field with LONGITUDE = ([LONG_SS]/3600)+( [LONG_MM]/60)+ [LONG_DD] Made LONGITUDE negative by LONG = - [LONG] The data was mapped using the "Display XY Data" command in ArcMap and noting the coordinate system as WGS 1984. All 91133 records had an XY coordinate There were 2095 records that were located in the Gulf of Mexico and were deleted from the dataset. This left 89038 records. There were 173 additional records that fell outside the county boundaries of Florida and in bodies of water, these records were left in the dataset. It is assumed that the accuracy of these points will be improved as the dataset is updated by FDEP. All fields were standardized to match the existing dataset Fields were added X-Double Y-Double COUNTY-Short FAC_ID-Double, length of 14 FAC_NAME-Text, length of 71 FAC_ADDR-Text, length of 45 FAC_CITY-Text, length of 25 FAC_ZIP-Long, length of 7 FPHONE-Text, length of 20 FAC_STAT-Text, length of 10 FAC_TYPE-Text, length of 5 TYPEDESC-Text, length of 32 DESCRIPT-Text, length of 32 FGDLAQDATE-Date AUTOID-Long Fields were calculated X=X coordinate of point in meters Y=Y coordinate of point in meters COUNTY=[CC_COUNTY] FAC_ID= [FACILITY_I] FAC_NAME=[NAME] FAC_ADDR= [ADDRESS1] FAC_CITY= [CITY] FAC_ZIP=[ZIP5] FPHONE= [old_petroleumtanks_oct07.FPHONE] (The FPHONE field in a previous dataset that was provided to the GeoPlan Center. Some fields have blank values) FAC_STAT= [FSC2_FAC_S] FAC_TYPE= [FTC1_FAC_T] TYPEDESC= [DESCRIPTIO] DESCRIPT=TYPEDESC FGDLAQDATE=11/07/2007 AUTOID=[FID] +1 A number of fields were also deleted to maintain consistency. These included CC_COUNTY_, FACILITY_I, NAME, ADDRESS1, CITY, SC1_STATE_, ZIP5, FSC2_FAC_S, FTC1_FAC_T, DESCRIPTIO, OID_1, FACSUB_1, Cnt_FACSUB_, Min_AUTOID; many of these were in the original dataset and were not required after new standardized fields were added and calculated based on their contents. Added a "Dummy" field to calc [FAC_NAME] & " [" & [SC5_SUBSTA] & "--" & [Tank_Count] & "]" Found longest record from the "Dummy" and added Descript based on the expression above. Deleted "Dummy" field Upcased fields Process Date: 20071107 |
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 2600 Blair Stone Road Tallahassee, FL 32399-2400 850-245-8705 |
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