20230624
10215700
1.0
FALSE
ReforestationNEPAcoverage
002
-118.651086
-118.481161
35.846612
36.092195
1
0.000
https://www.arcgis.com/sharing/rest/content/items/ffb5d20b07464a739b4c9a4d72f2c092/info/thumbnail/ago_downloaded.png
Projected
GCS_North_American_1983
Linear Unit: Meter (1.000000)
<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/3.7.0'><WKT>PROJCS["NAD_1983_UTM_Zone_11N",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",-117.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",26911]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>-9998100</YOrigin><XYScale>450445547.3910538</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>26911</WKID><LatestWKID>26911</LatestWKID></ProjectedCoordinateSystem>
NAD_1983_UTM_Zone_11N
20260602
18032000
20260602
18032000
150000000
5000
FGDC
Esri ArcGIS 13.7.0.1901
Windy Fire Reforestation Units
vector digital data
1
-118.651086
-118.481161
36.092195
35.846612
publication date
2019-07-15
Windy Fire Reforestation Units.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Windy Fire Reforestation Units. These units were determined using the Windy Fire RAVG data identifing high severity areas that were burned in the fire. </SPAN></P></DIV></DIV></DIV>
Gretchen Fitzgerald
Timber
Shapefile
0.000
dataset
EPSG
6.11(3.0.1)
0
Simple
FALSE
0
FALSE
FALSE
ReforestationNEPAcoverage
Feature Class
0
FID
FID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
OBJECTID
OBJECTID
Integer
10
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
OBJECTID_2
OBJECTID_2
Integer
10
10
0
SHAPE
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
STAGE
STAGE
Integer
10
10
0
ACTIVITY_C
ACTIVITY_C
String
254
0
0
ACTIVITY
ACTIVITY
String
254
0
0
FISCAL_YEA
FISCAL_YEA
Integer
10
10
0
DATE_ACCOM
DATE_ACCOM
Date
8
0
0
FACTS_ID
FACTS_ID
String
254
0
0
NBR_UNITS_
NBR_UNITS_
Double
19
0
0
UOM
UOM
String
254
0
0
GIS_ACRES
GIS_ACRES
Double
19
0
0
TIME_BLOCK
TIME_BLOCK
String
254
0
0
SHAPE_Leng
SHAPE_Leng
Double
19
0
0
Shape_Le_1
Shape_Le_1
Double
19
0
0
SHAPE_Area
Shape_Area
Double
19
0
0
Area of feature in internal units squared.
Esri
Positive real numbers that are automatically generated.
Type
Type
String
50
0
0
Shape_Le_2
Shape_Le_2
Double
19
0
0
Acres
Acres
Double
19
0
0
GlobalID
GlobalID
String
38
0
0
20260602
Geospatial Interface Visualization:
HelpId: 690
DistributedIndicator: Y
ProcessId: 1019746010295
ProcessName: R5 Accomplished Plantings by 10 - Year Blocks - RSW
OwnerName: R5
Registry: REGION 05
ProcessType: Visualization
Purpose: This VIS creates a feature class of all Plantings in 10 year blocks. The Planting codes used are:**
4431 - Full planting without concurrent site preparation
4432 - Fill-in planting without concurrent site preparation
4433 - Full re-planting without concurrent site preparation
4434 - Fill-in re-planting without concurrent site preparation
4441 - Full Planting concurrent with site preparation
4442 - Fill-in planting with concurrent site preparation
4443 - Full re-planting with concurrent site preparation
4444 - Fill-in re-planting with concurrent site preparation
There are four 10 - Year Block represented
1: 0 to 10 Years
2: 11 to 20 Years
3: 21 to 30 Years
4: 30+ Years
There are 2 additional VISs that runs off of this output:
1: Additional Activities from Planted Stands - RSW
2: Plantings by Species - FLQ
Data will only be included in the output where a match is found between the Activity Polygon SUID field and the Activity SUID in FACT_ACTV160_VW. Incorrect SUID values and/or missing spatial features will result in incomplete data being returned. Output should be reviewed for accuracy.
Created By: Tim Lindemann R5
** Due to the join nature of this VIS and network load at NITC this VIS can take several minutes to complete. Please be patient.
PreRequisites: Activity Polygon Feature Class in the Forest SDE Library that is data dictionary compliant, Polygons must have a valid SUID that matches corresponding data entered into FACTS.
Results: Standl alone feature class called AccomplishedPlantingsby10YearBlocksRSW in the user GI Output path location
DetailsUrl: http://fsweb.nrm.fs.fed.us/applications/facts/businessdocs.shtml
StandardsUrl: http://fsweb.nrm.fs.fed.us/products/gis/MetadataHTM/Activities/ActivityPolygon.xml
Contact: Joe Sherlock R5
CreatedBy:
CreatedDate: 11/30/2006 8:36:43 AM
ModifiedBy: CKLEIN
ModifiedDate: 6/30/2016 5:33:09 PM
Assigned Keywords:
Activity
Silviculture
Conn Set at Report Generation: CITRIX - Sequoia
R5 Accomplished Plantings by 10 - Year Blocks - RSW
publication date
2019-07-15
Process Step for R5 Accomplished Plantings by 10 - Year Blocks - RSW:
Step Name: RS_WRITER_VE elmt
Step Type: RSW
Sequence: 0
Required: True
Minimum Inputs: 2
Is Distributed: Y
Help ID: 290
Output Feature Template: AccomplishedPlantingsby10YearBlocksRSW
Do not prompt user for selection: False
Each run has own output: False
Input Feature Template: FACTS Activity Polygons
Feature Include Fields:
Field: STAGE
Feature Join Field: SUID
Query Join Field: SUID
Dyn Seg Mode: None
Join Cardinality: OneToMany
Is Outer Join: False
Rt Bmp:
Rt Emp:
Query Name: qryRswAccomplishedPlantingsby10YearBlocksRSW
Query will run on 'NRM Oracle for REGION 05' connection in the current conn set.
SQL:
select SUID, Admin_District_Code, Activity_Code, Activity, Fiscal_Year_Accomplished, Date_Accomplished, Activity_CN, FACTS_ID, NBR_Units_Accomplished, UOM, round(shape_value * 0.0002471054,2 ) as GIS_Acres,
case
when
to_number(to_char(sysdate, 'YYYY'))- to_number(Fiscal_Year_Accomplished) <= 10 then '0 to 10 Years'
when to_number(to_char(sysdate, 'YYYY')) - to_number(Fiscal_Year_Accomplished) <= 20
then '11 to 20 Years'
when to_number(to_char(sysdate, 'YYYY')) - to_number(Fiscal_Year_Accomplished) <= 30
then '21 to 30 Years'
when to_number(to_char(sysdate, 'YYYY')) - to_number(Fiscal_Year_Accomplished) > 30
then '30+ Years'
else 'NA'
end as TIME_BLOCK
from FACT_ACTV160_VW, GI_GUI_SELECTION
where GI_GUI_SELECTION.FEATURE_CN = SUID and RUNTIME_LAYER_ID = ?
and Fiscal_Year_Accomplished is not null
and activity_Code in ('4431','4432','4433','4434','4441','4442','4443','4444')
order by SUID
Parameters (0):
2019-07-15
USDA Forest Service
R5 Accomplished Plantings by 10 - Year Blocks - RSW
FACTS Activity Polygon EDW
SERVER=SDE_EDW;INSTANCE=sde:oracle:SDE_EDW;DBCLIENT=oracle;VERSION=SDE.DEFAULT\HHOSLER.%activitypolygon_subunit
publication date
2019-07-15
Resolved Query SQL:
select SUID, Admin_District_Code, Activity_Code, Activity, Fiscal_Year_Accomplished, Date_Accomplished, Activity_CN, FACTS_ID, NBR_Units_Accomplished, UOM, round(shape_value * 0.0002471054,2 ) as GIS_Acres, case when to_number(to_char(sysdate, 'YYYY'))- to_number(Fiscal_Year_Accomplished) <= 10 then '0 to 10 Years' when to_number(to_char(sysdate, 'YYYY')) - to_number(Fiscal_Year_Accomplished) <= 20 then '11 to 20 Years' when to_number(to_char(sysdate, 'YYYY')) - to_number(Fiscal_Year_Accomplished) <= 30 then '21 to 30 Years' when to_number(to_char(sysdate, 'YYYY')) - to_number(Fiscal_Year_Accomplished) > 30 then '30+ Years' else 'NA' end as TIME_BLOCK from FACT_ACTV160_VW, GI_GUI_SELECTION where GI_GUI_SELECTION.FEATURE_CN = SUID and RUNTIME_LAYER_ID = '1221018389' and Fiscal_Year_Accomplished is not null and activity_Code in ('4431','4432','4433','4434','4441','4442','4443','4444') order by SUID
qryRswAccomplishedPlantingsby10YearBlocksRSW
publication date
2019-07-15
withheld
/9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAP//Z