| description:
|
<DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>This data set is known as Water Use Permitting Facilities and consists of wells, pumps and culverts. These facilities are within the 16 counties located in the jurisdictional area of the South Florida Water Management District. The facilities represent a subset of all wells, pumps and culverts associated with Water Use Permits. A Water Use Permit is required for all water uses except single family and duplex use and fire fighting. A Water Use Permit (WUP) allows withdrawal of a specified amount of water, either from the ground or from a lake or river. The water can be used for a public water supply; to irrigate crops, nursery plants or golf courses; or for industrial processes. There are two types of Water Use Permits: general and individual. General permits are issued by District staff. Individual permits are issued by District's Governing Board. Water use is divided into five use types depending on the land use. Many water use permits are for combined use.</SPAN></SPAN></P><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>The query used to extract this subset is as follows -</SPAN></SPAN></P><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>select A.permit_no, A.app_no, A.actual_permit_file, A.project_name, L.lu_code, A.acres_served, C.id, C.facinv_type, C.name, C.pumptype_code, C.pump_diameter, C.cul_diameter, C.well_diameter, C.pump_capacity, C.pump_intake_depth, C.pump_intake_elevation, C.invert_elevation, C.pump_coordx, C.pump_coordy, C.well_depth, C.cased_depth, T.usests_code, C.facwlsts_code, W.factypwu_code, Y.name, Z.display_name from admin A, wu_app_facility B, wu_fac_inv C, wu_fac_sts_trk T, wu_fac_sources S, app_landuses L, wu_fac_wu_type W, tl_sources Y, app_reviewers X, tl_reviewers Z where A.app_no = L.admin_app_no and A.app_no = B.admin_app_no and B.facinv_id = C.id and L.use_priority = 1 and C.id = T.facinv_id(+) and C.id = S.facinv_id(+) and W.facinv_id(+) = C.id and S.source_id = Y.id and ((A.ACTIVE_MOD = 'Y') or (NVL(A.final_action_date,sysdate-16) &gt;= (sysdate-15))) and A.permit_no like %county_num% and A.app_no = X.admin_app_no and X.rev_sys_id = Z.sys_id and T.end_date is null and X.rev_type = 'WU'</</SPAN></SPAN></P><P><SPAN /></P></DIV></DIV></DIV> |
| licenseInfo:
|
<DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>This dataset is made available to the public in response to the Florida Public Records Law, Florida Statutes, Chapter 119. Any information, including but not limited to software and data, received from the South Florida Water Management District ("DISTRICT") is provided "AS IS" without warranty of any kind, and the District expressly disclaims all express and implied warranties, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. The entire risk as to the results and performance of any information obtained from the District is entirely assumed by the recipient.</SPAN></SPAN></P><P><SPAN /></P></DIV></DIV></DIV> |
| tags:
|
["Culverts","Wells","Permits","pumps","Water use permits","WUP","facilities","SFWMD","Water Management District","South Florida"] |