KDHE
2006
BOW_CAFOarea
vector digital data
withheld
BOW_CAFOarea
BOW_ADMIN.FE_FAC_GIS: facility ID
GIS.BOW_ CAFOpoint: progkey
GIS.BOW_ CAFOline
GIS.BOW_ CAFOarea
GIS.BOW_CAFO_HUC12_FACILITY_SUM: Created/updated in a monthly scheduled batch called BOW_HUC12_CAFO_summary.bat (uses vw_bow_cafoemerg spatial view)
All views have: modified <> 'deleted'
GIS.VW_BOW_ CAFOpoint: record = Permit, Certification, Renewal and Status <> closed & inactive - abondoned
GIS.VW_BOW_ CAFOactive: record = Permit, Certification, Renewal and Status = active
GIS.VW_BOW_ CAFOinactive: record = Permit, Certification, Renewal and Status = inactive
GIS.VW_BOW_ CAFOemerg: for emergency information retrieval includes contact info not present in other views.
: record = Permit, Certification, Renewal & Status <> closed & inactive - abondoned. & Feature_type = facility. GIS.VW_BOW_ CAFOline: Permit, Certification, Renewal and Status <> closed & inactive - abondoned
GIS.VW_BOW_ CAFOarea: Permit, Certification, Renewal and Status <> closed & inactive - abondoned
GIS.VW_BOW_ CAFOappfield: above plus a.feature_type in ('Land Application - Solid','Land Application - Liquid','Land Application - S/L')
GIS.VW_BOW_ BWM_FESITE_INFO: Used CAFO burial sites.
VW_BOW_CAFO_FACILITY_REPORT: Program uses to identify facilities with 0 facility points or multiple facility points.
VW_BOW_CAFO_HUC12_FAC_SUM: Program uses for HUC12 facility summaries
SDE outline can be found
API into prod Jan 1, 2009. Contact Terry Medley.
en
pub date
pub date
None planned
-101.679134
-95.920216
39.990431
37.111107
271159.930078
763105.480078
4111301.980078
4426695.109961
REQUIRED: Reference to a formally registered thesaurus or a similar authoritative source of theme keywords.
REQUIRED: Common-use word or phrase used to describe the subject of the data set.
SDE admin
SDE admin
ESRI ArcCatalog 9.3.1.1850
Feature Class
1. BER_ADMIN.ISL_SITES2 (oracle table; Glenna updates)
2. GIS.VW_ISL_SITES2 (base table: complete SDE table view of the BER oracle table)
3. GIS.VW_ISL_LAT_LONG (base table for spatial: only includes ISL with lat/long)
4. GIS.BER_ISL_Process (spatial SDE from #3: geographic proj of 4, intermediate stage)
5. GIS.BER_ISL_facility (spatial SDE from #4: nad83, utm14 spatial)
6. GIS.VW_BER_ISL_external (spatial SDE from #5 joined to #2 for projID, name, status)
7. GIS.VW_BER_ISL_internal (spatial SDE from #5 joined to #2 for all data)
Metadata imported.
withheld
Metadata imported.
withheld
20081222
11405600
Vector
Simple
FALSE
435
TRUE
FALSE
coordinate pair
0.000195
0.000195
meters
North American Datum of 1983
Geodetic Reference System 80
6378137.000000
298.257222
GCS_North_American_1983
NAD_1983_UTM_Zone_14N
1.000000
Explicit elevation coordinate included with horizontal coordinates
BEH_BGA_wblake
Feature Class
435
OBJECTID
Internal feature number.
ESRI
Sequential unique whole numbers that are automatically generated.
OBJECTID
OID
4
10
0
PROGKEY
PROGKEY
String
30
0
0
FEATURE_TYPE
FEATURE_TYPE
String
30
0
0
FEATURE_NAME
FEATURE_NAME
String
50
0
0
COLLECT_DATE
COLLECT_DATE
Date
8
0
0
COLLECT_TIME
COLLECT_TIME
String
15
0
0
COLLECT_METHOD
COLLECT_METHOD
String
30
0
0
COLLECT_BY
COLLECT_BY
String
30
0
0
UPLOAD_BY
UPLOAD_BY
String
30
0
0
UPLOAD_DATE
UPLOAD_DATE
Date
8
0
0
MODIFIED
MODIFIED
String
8
0
0
SHAPE
Feature geometry.
ESRI
Coordinates defining the features.
SHAPE
Geometry
8
0
0
CREATED_USER
CREATED_USER
String
255
0
0
CREATED_DATE
CREATED_DATE
Date
8
0
0
LAST_EDITED_USER
LAST_EDITED_USER
String
255
0
0
LAST_EDITED_DATE
LAST_EDITED_DATE
Date
8
0
0
SHAPE.AREA
SHAPE.AREA
Double
0
0
0
SHAPE.LEN
SHAPE.LEN
Double
0
0
0
Downloadable Data
20090112
KDHE
Marvin Bush
785-2913220
REQUIRED: The mailing and/or physical address for the organization or individual.
REQUIRED: The city of the address.
REQUIRED: The state or province of the address.
REQUIRED: The ZIP or other postal code of the address.
FGDC Content Standards for Digital Geospatial Metadata
FGDC-STD-001-1998
local time
http://www.esri.com/metadata/esriprof80.html
ESRI Metadata Profile
en
20260411
08324700
FALSE
20171204
08444300
20171204
08444300
BEH_BGA_wblake
002
241066.825195
887012.802734
4096873.076953
4427026.547461
1
Projected
GCS_North_American_1983
Linear Unit: Meter (1.000000)
NAD_1983_UTM_Zone_14N
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.0.0'><WKT>PROJCS["NAD_1983_UTM_Zone_14N",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-99.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",26914]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>-9998100</YOrigin><XYScale>5120</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.20000000000000001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>26914</WKID><LatestWKID>26914</LatestWKID></ProjectedCoordinateSystem>
1.0
FGDC CSDGM Metadata
Esri ArcGIS 12.0.1.8933
BEH_BGA_wblake
271159.930078
763105.480078
4426695.109961
4111301.980078
1
-101.679134
-95.920216
39.990431
37.111107
1
1
-102.031142
-94.473207
39.993417
36.938452
ISO 19115 Geographic Information - Metadata
DIS_ESRI1.0
dataset
002
withheld
Feature Class
Enterprise Geodatabase Feature Class
NAD_1983_UTM_Zone_14N
EPSG
6.13(3.0.1)
435
20171204