SOUTHWEST FLORIDA WATER MANAGEMENT DISTRICT WELL CONSTRUCTION PERMIT LOCATIONS - OCTOBER 2011

Metadata:

• Identification_Information
• Data_Quality_Information
• Spatial_Data_Organization_Information
• Spatial_Reference_Information
• Entity_and_Attribute_Information
• Distribution_Information
• Metadata_Reference_Information

Identification_Information:

Citation:

Citation_Information:

Originator:

Southwest Florida Water Management District, Mapping and GIS Section

Publication_Date: 20111014

Title:

SOUTHWEST FLORIDA WATER MANAGEMENT DISTRICT WELL CONSTRUCTION PERMIT LOCATIONS - OCTOBER 2011

Geospatial_Data_Presentation_Form: vector digital data

Publication_Information:

Publication_Place: Brooksville, FL

Publisher: Southwest Florida Water Management District

Other_Citation_Details: Southwest Florida Water Management District

Online_Linkage:

<http://www.swfwmd.state.fl.us/data/gis/layer_library/category/regulatory>

Description:

Abstract:

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.

Purpose:

This data layer represents the locations of all well construction sites permitted within the District, including historical sites. The historical sites were obtained from the IBM databases.

Time_Period_of_Content:

Time_Period_Information:

Single_Date/Time:

Calendar_Date: 20111014

Currentness_Reference: publication date

Status:

Progress: Complete

Maintenance_and_Update_Frequency: As needed

Spatial_Domain:

Bounding_Coordinates:

West_Bounding_Coordinate: -87.429040

East_Bounding_Coordinate: -79.872251

North_Bounding_Coordinate: 30.983191

South_Bounding_Coordinate: 24.492815

Keywords:

Theme:

Theme_Keyword_Thesaurus: ISO 19115 Topic Category

Theme_Keyword: inlandWaters

Theme_Keyword: environment

Theme:

Theme_Keyword_Thesaurus: NONE

Theme_Keyword: WCP

Theme_Keyword: Well Construction Sites

Theme_Keyword: Well Construction Permits

Place:

Place_Keyword_Thesaurus: none

Place_Keyword: Southwest Florida Water Management District

Place_Keyword: SWFWMD

Access_Constraints: None

Use_Constraints:

These data were not collected under the supervision of a licensed Professional Surveyor and Mapper. Use of these data requires a general understanding of GIS.

Point_of_Contact:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization: Southwest Florida Water Management District

Contact_Person: Mapping and GIS Section

Contact_Address:

Address_Type: mailing and physical address

Address: 2379 Broad Street (U.S. 41 South)

City: Brooksville

State_or_Province: FL

Postal_Code: 34604-6899

Contact_Voice_Telephone: (352) 796-7211

Contact_Facsimile_Telephone: (352) 540-6018

Contact_Electronic_Mail_Address: info@WaterMatters.org

Hours_of_Service: 8:00 a.m. to 5:00 p.m.

Native_Data_Set_Environment:

Microsoft Windows XP Version 5.1 (Build 2600) Service Pack 3; ESRI ArcCatalog 9.3.1.4000

Cross_Reference:

Citation_Information:

Other_Citation_Details:

Southwest Florida Water Management District: <http://www.swfwmd.state.fl.us/>
Well contruction permits: <http://www.swfwmd.state.fl.us/permits/wellconstruction/>
SWFWMD History: <http://www.swfwmd.state.fl.us/about/history/>

Data_Quality_Information:

Attribute_Accuracy:

Attribute_Accuracy_Report:

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

Logical_Consistency_Report:

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.

Completeness_Report: There are no known omissions.

Positional_Accuracy:

Horizontal_Positional_Accuracy:

Horizontal_Positional_Accuracy_Report:

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.

Vertical_Positional_Accuracy:

Vertical_Positional_Accuracy_Report:

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

Lineage:

Source_Information:

Source_Citation:

Citation_Information:

Originator: Southwest Florida Water Management District

Publication_Date: Unpublished Material

Title: Edited sites feature class found in SDE

Publication_Information:

Publication_Place: 2379 Broad St., Brooksville, FL 34604-6899

Publisher:

Resource Regulation Department, Southwest Florida Water Management District

Other_Citation_Details:

This feature class was created by using the original IBM tables. Points were created from latitude and longitude when available. Otherwise, the point was address matched or the centroid of the quarter STR, STR or county was used.

Source_Scale_Denominator: Unknown

Type_of_Source_Media: online

Source_Time_Period_of_Content:

Time_Period_Information:

Single_Date/Time:

Calendar_Date: daily

Source_Currentness_Reference: publication date

Source_Citation_Abbreviation: SWFWMD

Source_Contribution: Spatial and Attribute Information

Source_Information:

Source_Citation:

Citation_Information:

Originator: Southwest Florida Water Management District

Publication_Date: Daily

Title: Oracle Tables for permits

Publication_Information:

Publication_Place: 2379 Broad St., Brooksville, FL 34604-6899

Publisher: SWFWMD

Other_Citation_Details:

These tables were derived from the original IBM tables. The following tables were used to retrieve the desired information on the wells: permit.site, permit.well_site, permit.wcp_application_well, permit.wcp_application, permit.str_code, permit.well_permit_casing, permit.well_permit_drilling, permit.registered_user, permit.permit_app_party, common.party_relationship, permit.wcp_contractor, common.party, permit.well_completion, permit.well_casing, permit.well_drill_method_code, and permit.well_use_type_code.

Source_Time_Period_of_Content:

Time_Period_Information:

Single_Date/Time:

Source_Currentness_Reference: publication date

Source_Citation_Abbreviation: PermitTables

Process_Step:

Process_Description:

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.

Source_Used_Citation_Abbreviation: PermitTables

Process_Date: Not complete

Process_Contact:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization: Southwest Florida Water Management District

Contact_Person: Mapping and GIS Section

Contact_Address:

Address_Type: mailing and physical address

Address: 2379 Broad Street (U.S. 41 South)

City: Brooksville

State_or_Province: FL

Postal_Code: 34604-6899

Contact_Voice_Telephone: (352) 796-7211

Contact_Facsimile_Telephone: (352) 540-6018

Hours_of_Service: 8:00 a.m. to 5:00 p.m.

Process_Step:

Process_Description:

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.

Source_Used_Citation_Abbreviation: sites_edit

Process_Date: Not complete

Process_Contact:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization: Southwest Florida Water Management District

Contact_Person: Mapping and GIS Section

Contact_Address:

Address_Type: mailing and physical address

Address: 2379 Broad Street (U.S. 41 South)

City: Brooksville

State_or_Province: FL

Postal_Code: 34604

Contact_Voice_Telephone: (352) 796-7211

Contact_Facsimile_Telephone: (352) 540-6018

Hours_of_Service: 8:00 a.m. to 5:00 p.m.

Process_Step:

Process_Description:

This dataset was received by the GeoPlan Center via ftp on 10/14/2011. The data was originally in shapefile format. When received the data set was in the following projection: NAD_1983_HARN_StatePlane_Florida_West_FIPS_0902_Feet. 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_oct11 from WCP_SITES - Deleted OBJECTID field

Source_Used_Citation_Abbreviation: GeoPlan

Process_Date: 20111014

Spatial_Data_Organization_Information:

Direct_Spatial_Reference_Method: Vector

Point_and_Vector_Object_Information:

SDTS_Terms_Description:

SDTS_Point_and_Vector_Object_Type: Entity point

Point_and_Vector_Object_Count: 671203

Spatial_Reference_Information:

Horizontal_Coordinate_System_Definition:

Planar:

Map_Projection:

Map_Projection_Name: Albers Conical Equal Area

Albers_Conical_Equal_Area:

Standard_Parallel: 24.000000

Standard_Parallel: 31.500000

Longitude_of_Central_Meridian: -84.000000

Latitude_of_Projection_Origin: 24.000000

False_Easting: 400000.000000

False_Northing: 0.000000

Planar_Coordinate_Information:

Planar_Coordinate_Encoding_Method: coordinate pair

Coordinate_Representation:

Abscissa_Resolution: 0.002048

Ordinate_Resolution: 0.002048

Planar_Distance_Units: meters

Geodetic_Model:

Horizontal_Datum_Name: D_North_American_1983_HARN

Ellipsoid_Name: Geodetic Reference System 80

Semi-major_Axis: 6378137.000000

Denominator_of_Flattening_Ratio: 298.257222

Vertical_Coordinate_System_Definition:

Altitude_System_Definition:

Altitude_Resolution: 1.000000

Altitude_Encoding_Method:

Explicit elevation coordinate included with horizontal coordinates

Entity_and_Attribute_Information:

Detailed_Description:

Entity_Type:

Entity_Type_Label: SW_WCP_OCT11

Entity_Type_Definition: SW_WCP_OCT11.DBF

Entity_Type_Definition_Source: SWFWMD

Attribute:

Attribute_Label: OBJECTID

Attribute_Definition: Internal feature number.

Attribute_Definition_Source: ESRI

Attribute_Domain_Values:

Unrepresentable_Domain:

Sequential unique whole numbers that are automatically generated.

Attribute:

Attribute_Label: Shape

Attribute_Definition: Feature geometry.

Attribute_Definition_Source: ESRI

Attribute_Domain_Values:

Unrepresentable_Domain: Coordinates defining the features.

Attribute:

Attribute_Label: WCP_PERMIT

Attribute_Definition: Well construction permit number

Attribute:

Attribute_Label: WELL_NBR

Attribute_Definition:

The well number. Some locations have more than one well, so this column differentiates between wells.

Attribute:

Attribute_Label: SITE_NAME

Attribute_Definition: Name for the site.

Attribute:

Attribute_Label: WCP_PERM_1

Attribute_Definition: The status of the well construction permit.

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: 4

Enumerated_Domain_Value_Definition: Under Review

Enumerated_Domain:

Enumerated_Domain_Value: 5

Enumerated_Domain_Value_Definition: Issued

Enumerated_Domain:

Enumerated_Domain_Value: 6

Enumerated_Domain_Value_Definition: Completed

Enumerated_Domain:

Enumerated_Domain_Value: 7

Enumerated_Domain_Value_Definition: Denied

Enumerated_Domain:

Enumerated_Domain_Value: 8

Enumerated_Domain_Value_Definition: Withdrawn

Attribute:

Attribute_Label: WELL_USE_T

Attribute_Definition: A description of what the well is used for.

Attribute:

Attribute_Label: WELL_CASIN

Attribute_Definition: The casing diameter of the well. Measurement in inches.

Attribute:

Attribute_Label: CASING_TO_

Attribute_Definition:

The well depth to the end of the casing. Measurement is in feet.

Attribute:

Attribute_Label: WELL_DEPTH

Attribute_Definition: The total depth of the well. Measurement is in feet.

Attribute:

Attribute_Label: STATIC_WAT

Attribute_Definition:

The measured water level for the well. Measurements are in feet.

Attribute:

Attribute_Label: OWNERNAME

Attribute_Definition: Name of the owner of the well.

Attribute:

Attribute_Label: WELL_LOCAT

Attribute_Definition: Street number where the well is located.

Attribute:

Attribute_Label: WELL_LOC_1

Attribute_Definition: Street name where the well is located.

Attribute:

Attribute_Label: WELL_LOC_2

Attribute_Definition: The city where the well is located.

Attribute:

Attribute_Label: LICENSE_NB

Attribute_Definition:

The District's license number of the contractor who constructed the well.

Attribute:

Attribute_Label: CONTRACTOR

Attribute_Definition: The contractor who constructed the well.

Attribute:

Attribute_Label: WELL_DRILL

Attribute_Definition: A description of the type of method used to drill the well.

Attribute:

Attribute_Label: LATITUDE

Attribute_Definition:

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.

Attribute:

Attribute_Label: LONGITUDE

Attribute_Definition:

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.

Attribute:

Attribute_Label: UTME

Attribute_Definition:

The Universal Tranverse Mercator coordinates of the well in the easting direction.

Attribute:

Attribute_Label: UTMN

Attribute_Definition:

The Universal Tranverse Mercator coordinates of the well in the northing direction.

Attribute:

Attribute_Label: SECTION_ID

Attribute_Definition: The section (from STR) in which the site is located.

Attribute:

Attribute_Label: TOWNSHIP_I

Attribute_Definition: The township (from STR) in which the site is located.

Attribute:

Attribute_Label: RANGE_ID

Attribute_Definition: The range (from STR) in which the site is located.

Attribute:

Attribute_Label: SPFWE

Attribute_Definition:

The Florida state plane west eastng coordinate of the well in feet.

Attribute:

Attribute_Label: SPFWN

Attribute_Definition:

The Florida state plane west northing coordinate of the well in feet.

Attribute:

Attribute_Label: DCS_FLG

Attribute_Definition:

Flag indicating if the well is also associated with a data collection site.

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: 0

Enumerated_Domain_Value_Definition: no DC site

Enumerated_Domain:

Enumerated_Domain_Value: 1

Enumerated_Domain_Value_Definition: DC site

Attribute:

Attribute_Label: WUP_FLG

Attribute_Definition:

Flag indicating if the well is also associated with a water use permit.

Attribute_Domain_Values:

Enumerated_Domain:

Enumerated_Domain_Value: 0

Enumerated_Domain_Value_Definition: no WUP permit

Enumerated_Domain:

Enumerated_Domain_Value: 1

Enumerated_Domain_Value_Definition: WUP permit

Attribute:

Attribute_Label: LAST_UPDAT

Attribute_Definition: The last date that the WMIS tabular data was edited.

Attribute:

Attribute_Label: GIS_UPDATE

Attribute_Definition: The date the location was edited by the MGIS staff.

Attribute:

Attribute_Label: SITE_ID

Attribute_Definition:

The unique site id assigned to a point of interest at the District. This is automatically assigned by the WMIS application.

Attribute:

Attribute_Label: WCP_SITES_

Attribute_Definition:

Web link to water management information system info related to well permit

Attribute:

Attribute_Label: DESCRIPT

Attribute_Definition: FGDL added field based on WELL_USE_T

Attribute_Definition_Source: GeoPlan

Attribute:

Attribute_Label: FGDLAQDATE

Attribute_Definition: FGDL added field based on date downloaded from source

Attribute_Definition_Source: GeoPlan

Attribute:

Attribute_Label: AUTOID

Attribute_Definition: Unique ID added by GeoPlan

Attribute_Definition_Source: GeoPlan

Distribution_Information:

Distributor:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization: Florida Geographic Data Library (FGDL)

Contact_Address:

Address_Type: mailing address

Address: 431 Architecture PO Box 115706

City: Gainesville

State_or_Province: Florida

Postal_Code: 32611-5706

Country: United States

Contact_Electronic_Mail_Address: Web site: <http://www.fgdl.org>

Contact_Electronic_Mail_Address: Technical Support: <http://www.fgdl.org/fgdlfeed.html>

Contact_Electronic_Mail_Address: For FGDL Software: <http://www.fgdl.org/software.html>

Contact_Electronic_Mail_Address:

FGDL Frequently Asked Questions: <http://www.fgdl.org/fgdlfaq.html>

Contact_Electronic_Mail_Address: Mailing list for FGDL: <http://www.fgdl.org/fgdl-l.html>

Resource_Description: DOWNLOADABLE DATA

Distribution_Liability:

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>

Standard_Order_Process:

Digital_Form:

Digital_Transfer_Information:

Transfer_Size: 17.923

Technical_Prerequisites:

This data is intended for use with a Geographic Information Systems or Remote Sensing software package.

Metadata_Reference_Information:

Metadata_Date: 20111121

Metadata_Contact:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization: Southwest Florida Water Management District

Contact_Person: Mapping and GIS Section

Contact_Address:

Address_Type: mailing and physical address

Address: 2379 Broad Street (U.S. 41 South)

City: Brooksville

State_or_Province: FL

Postal_Code: 34604-6899

Contact_Voice_Telephone: (352) 796-7211

Contact_Facsimile_Telephone: (352) 540-6018

Contact_Electronic_Mail_Address: info@WaterMatters.org

Hours_of_Service: 8:00 a.m. to 5:00 p.m.

Metadata_Standard_Name: FGDC Content Standards for Digital Geospatial Metadata

Metadata_Standard_Version: FGDC-STD-001-1998

Metadata_Time_Convention: local time

Metadata_Extensions:

Online_Linkage: <http://www.esri.com/metadata/esriprof80.html>

Profile_Name: ESRI Metadata Profile

Metadata_Extensions:

Online_Linkage: <http://www.esri.com/metadata/esriprof80.html>

Profile_Name: ESRI Metadata Profile