Geodataset Name:       SW_WCP_SEP18
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         782679

DATA SOURCE(S):                    Southwest Florida Water Management District, Mapping and GIS Section
SCALE OF ORIGINAL SOURCE MAPS:     Unknown
GEODATASET EXTENT:                 Southwest Florida Water Management District

PUBLICATION DATE:                  20180516
TIME PERIOD OF CONTENT:            20180912
DOWNLOAD LINK:                     http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: SW_WCP_SEP18.DBF

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item	Item Description
OBJECTID	Internal feature number.
Shape	Feature geometry.
WCP_PERMIT	Well construction permit number
WELL_NBR	The well number. Some locations have more than one well, so this column differentiates between wells.
SITE_NAME	Name for the site.
SITE_TYPE_	Type of site
WCP_PERM_1	The status of the well construction permit. 4 = Under Review 5 = Issued 6 = Completed 7 = Denied 8 = Withdrawn
SITE_STATU	Site status code 0 = Null 1 = Active 2 = Proposed 3 = Denied 4 = Cancelled 5 = Inactive
SITE_STA_1	Site status definition
WELL_USE_T	A description of what the well is used for.
WELL_CASIN	The casing diameter of the well. Measurement in inches.
CASING_TO_	The well depth to the end of the casing. Measurement is in feet.
WELL_DEPTH	The total depth of the well. Measurement is in feet.
STATIC_WAT	The measured water level for the well. Measurements are in feet.
OWNERNAME	Name of the owner of the well.
WELL_LOCAT	Street number where the well is located.
WELL_LOC_1	Street name where the well is located.
WELL_LOC_2	The city where the well is located.
LICENSE_NB	The District's license number of the contractor who constructed the well.
CONTRACTOR	The contractor who constructed the well.
WELL_DRILL	A description of the type of method used to drill the well.
LATITUDE	The latitude coordinates for the site. The latitude angular distance, in degrees, minutes, and seconds, of a point north or south of the Greenwich meridian. Valid range for the District is approximately 26 46' 00"N to 29 32' 00"N.
LONGITUDE	The longitude coordinates for the site. The longitude is the angular distance, in degrees, minutes, and seconds, of a point east or west of the Greenwich meridian. Valid range for the District is approximately 81 18' 00"W to 82 52' 00"W.
UTME	The Universal Tranverse Mercator coordinates of the well in the easting direction.
UTMN	The Universal Tranverse Mercator coordinates of the well in the northing direction.
SECTION_ID	The section (from STR) in which the site is located.
TOWNSHIP_I	The township (from STR) in which the site is located.
RANGE_ID	The range (from STR) in which the site is located.
SPFWE	The Florida state plane west eastng coordinate of the well in feet.
SPFWN	The Florida state plane west northing coordinate of the well in feet.
DCS_FLG	Flag indicating if the well is also associated with a data collection site. 0 = no DC site 1 = DC site
WUP_FLG	Flag indicating if the well is also associated with a water use permit. 0 = no WUP permit 1 = WUP permit
PERMIT_ISS	Permit issue date
LAST_UPDAT	The last date that the WMIS tabular data was edited.
GIS_UPDATE	The date the location was edited by the MGIS staff.
SITE_ID	The unique site id assigned to a point of interest at the District. This is automatically assigned by the WMIS application.
WCP_SITES_	Web link to water management information system info related to well permit
LAT_DD	Latitude in decimal degrees.
LONG_DD	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 WELL_USE_T
FGDLAQDATE	FGDL added field based on date downloaded from source
AUTOID	Unique ID added by GeoPlan

USER NOTES:

The final product was checked against the source material for attribute correctness. The Mapping and GIS section of the Southwest Florida Water Management District corrected any errors found.

There are no known omissions.

GeoPlan relied on the integrity of the attribute information within the original data.

Well Construction Permit locations within the District. Many historical sites did not have latitude and longitude stored for their location. For these sites, address matching, quarter STR centroids, STR centroids, or county centroids were used as the location. These sites date back to approximately 1979-1980 with location reliability being strong after January 2007. Prior to January 2007, the previously mentioned methodology was used to place the well sites. Furthermore, the well construction permit requirement for wells under 4" was enforced in earnest after 1990. Therefore, prior to then many domestic wells may have been constructed that did not get permits and are not in this dataset.

Well Construction Permit locations. This service is for the Open Data Download application for the Southwest Florida Water Management District.

No positional accuracy was performed on this data set. Historical sites may not be in the correct location due to lack of lat/long in the original IBM tables. Locations were given to these sites by either address matching or using the centroids of the quarter STR, STR, or county.

This data is provided 'as is' and its vertical positional accuracy has not been verified by GeoPlan

REST service is only available from 6 A.M. to 10 P.M. daily. The data are being provided on an 'as is' basis. The District specifically disclaims any warranty, either expressed or implied, including, but not limited to, the implied warranties or merchantability and fitness for a particular use. The entire risk as to quality and performance is with the user. In no event will the District or its staff be liable for any direct, indirect, incidental, special, consequential, or other damages, including loss of profit, arising out of the use of these data even if the District has been advised of the possibility of such damages. All data are intended for resource management use and have not been collected or certified by a Florida-registered Surveyor and Mapper.

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:

Southwest Florida Water Management District: http://www.swfwmd.state.fl.us/ Well construction permits: https://www.swfwmd.state.fl.us/business/epermitting/well-construction-permits SWFWMD History: http://www.swfwmd.state.fl.us/about/history/

DATA LINEAGE SUMMARY:

A python script was written to create a set of views and tables that are joined to create a final table that contains all of the attributes needed for the well construction permit feature class. This script runs daily to update the table. The desired attributes are Permit number, Contractor ID (license number), Owner name, Well Address, Well Diameter, Drilling Method, use of well, Latitude, Longitude, STR, Casing depth, Total Depth, and Static Water Level. Tables were created from the views to increase the speed of updating the final table daily. The relationships between the original views are very convoluted and caused the update to be very slow. The following is a list of views and corresponding tables created in the script. It must occur in this order because some views are dependent on the previous table. View Table wcp_well_completion_info_v wcp_well_completion_info_tbl wcp_str_location_v wcp_str_locaiton_tbl wcp_ownername_v wcp_ownername_tbl wcp_contractor_id_v wcp_contractor_id_tbl wcp_proposed_well_v wcp_proposed_well_tbl wcp_join_well_info_v wcp_join_well_info_tbl Some restrictions to creating the views are: well_casing_type_code_id = 4 (primary casing), permit_nbr <> 0, relationship_type_code_id = 23 (well construction contractor). Two views are created from the wcp_join_well_info_tbl table where one has data where wcp_permit_status_code_id > 5 (issued) and the other has wcp_permit_status_code_id < 6 (completed). This was done because those wells where wcp_permit_status_code_id < 6, the well and site status codes are not desired. These two views are then merged into a single final table. This is done on a daily basis. Process Date: Not complete A python script was written to select records found in the sites_edit feature class, where wcp_flg = 1, and create a new feature class, called sites_edit_wcpflg1. The sites_edit feature class is the layer edited by the GIS Regulatory staff. Then another python script creates a spatial view using the sites_edit_wcpflg1 records and the tabular data. The spatial view allows a 1 to many relationship to be viewed. Several records may exist for a single permit and well number depending on status codes and/or other codes. A feature class is then created from the spatial view to increase the speed of drawing and queries. Attribute indexes are added to site_id and wcp_permit_nbr. This is done on a daily basis. Process Date: Not complete This dataset was downloaded by the GeoPlan Center from the SWFWMD Open Data Portal: http://data.swfwmd.opendata.arcgis.com/ on 9/20/2018. The data was originally in shapefile format. When received the data set was in the following projection: NAD83_HARN_Florida_West_ftUS. The data was projected to Albers NAD 83 HARN. This data is updated daily by the Southwest Florida Water Management District. Please see their data downloads page for the most up-to-date data. - Added the field DESCRIPT based on WELL_USE_T - Added the field FGDLAQDATE based on date downloaded from source. - Upcased all text in the attribute table. - Data set was renamed sw_wcp_sep18 from Well_Construction_Permits - Deleted OBJECTID field - Set metadata time period of content based on the most recent date in the LAST_UPDAT field (20180912) Break down in field changes since last update: New fields: SITE_TYPE_ WCP_PERM_1 SITE_STATU SITE_STA_1 PERMIT_ISS Fields with new names: WELL_LOCA2 is now WELL_LOC_1 WELL_LOCA3 is now WELL_LOC_2 Process Date: 20180921

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:

Southwest Florida Water Management District
SWFWMD
2379 Broad Street (U.S. 41 South)
Brooksville, FL
34604-6899
(352) 796-7211


https://data-swfwmd.opendata.arcgis.com/
data.maps@watermatters.org
Mapping and GIS Section

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