User:104.7.14.130/sandbox

This is my sandbox I am practicing editing in visual editor for testing purposes lets try pasting directly from a word doc:

Created On 06/13/19 By Ian Hash

Purpose: Calculate an average Site Index Value for Goldbelt project area using FIA database.

Method: Combination of Geospatial analysis and SQL statements

Results: 14 Selected plots produced an average Site index of 66.65 with a range of 33-117

VVV this table pasted perfectly into excel and back into word GREAT!

1.       Download the FIA database here: PNWFIADB https://www.fs.fed.us/pnw/rma/fia-topics/inventory-data/
a.      A data dictionary for this database can be found in the downloaded folder named: FIADB_User_Guide_P2_7-0_national

2.       Query the database for Alaska Plot data

VVV These code blocks are awesome a.      Open the Database in access

You can also add tags to your page! this is awesome!

b.      Select the Create tab Create>Query Design in the top ribbon

c.      Close the “Show Table” Pop up

d.      In the top Ribbon on the select Design>SQL view

e.      Enter the following SQL statement:

f.       This produces a table with all Plot data from Alaska

g.      Right click on the table and save

3.       Export the table

a.      Right click on the table in the navigation pane

i.     Right Click>Export>text file

b.      In Export dialog select output location

c.      Select next

d.      Select “Delimited – Characters such as comma or tab separate each field”

e.      Select next

f.       Select Comma, and check box “Include Field Names on First Row”

g.      Select next

h.      Check the output file and location and select Finish

4.       Import table to ArcGis

a.      In arcMap 10.7 select File>Add Data>Add XY Data

b.      Navigate to and select the .txt file you exported

c.      X field and Y field should auto populate with longitude and latitude respectively, if not use the drop down to select the X and Y fields

d.      Select Edit in the “Coordinate System of Input Coordinates” section

e.      In the search box enter “GCS_WGS_1984” and double click “WGS 1984” that appears under “Geographic Coordinate Systems”

f.       Select OK

5.       Convert the XY data to a FileGeodatabase Shapefile

a.      In ArcMap in the navigation pane right click on the X Y data layer you imported

i.     Right click>Data>Export Data

b.      Select All Features

c.      Select This Layer’s Source Data

d.      Navigate to where you want to save, name your file, and Save as Type “File and Personal Geodatabase feature Classes”

i.     Do not save as a shapefile, this will cause many of the values in your attribute table to truncated

e.      Save

f.       Add layer to map

6.       Clip the new point layer by your desired buffer distance around project area

a.      In this case we used 40 miles

b.      Buffer your Project shapefile

c.      Clip the point layer by the Project buffer

d.      Clip the newly clipped point layer by land area in the region

i.     This is necessary because the FIA plot data includes plots over water, which have no data.

e.      A model for this procedure could look something like this:

7.       Export your new clipped point layer’s table as a .txt and import to access

a.      Right click on the new layer>attributes table

b.      Top left drop down>Export

c.      Export all records, save as a .txt

d.      In access top ribbon External Data>New Data Source>From File>Text File

e.      Select your text file,

i.     delineate with commas

ii. select First Row Contains Field Names

iii. Choose CN as primary Key

iv. Finish

8.       Run following query to select relevant plots and SI information

a.      In access top ribbon Create>Query Design

b.      Close pop up menu

c.      Design>View>SQL

d.      Enter the following query, RUN

e.       This Query will produce a table showing plots with the following characteristics

i.     Ownership Type: Undifferentiated private and Native American.

ii. Forest Type Group: Fir / spruce / mountain hemlock group OR Hemlock / Sitka spruce group

iii. Within 40 miles of AOI

iv. Has a Site Index Value

v.     Note: Grouped by CN and values averages because duplicate values were returned – does not affect SI calculation

Visual example of output, all points are a result of the buffer and clipping model, selected points are a result of the query above, project area in blue

Alternative DB only Method

1.       Query relevant data to the region of your AOI

2.       Determine Lat Long / XY of centroid of your AOI

3.       Calculate distance between Your AOI centroid and all plots in region

4.       Use distance information to query relevant plots

Wow that worked pretty good, it actually pasted the table in perfectly though some of the formatting did not work so well

now below lets try the same thing from a google doc

Created On 06/13/19 By Ian Hash

It seems like it didnt want to come from a google doc

Lets try pasting the word doc with word headings and see if they transfer

VVV WOW this is cool headings in word transfered perfectly and will show up in the table of contents on the published page

Download the FIA database here: PNWFIADB https://www.fs.fed.us/pnw/rma/fia-topics/inventory-data/
a.      A data dictionary for this database can be found in the downloaded folder named: FIADB_User_Guide_P2_7-0_national

Query the database for Alaska Plot data
b.      Open the Database in access

c.      Select the Create tab Create>Query Design in the top ribbon

d.      Close the “Show Table” Pop up

e.      In the top Ribbon on the select Design>SQL view

f.       Enter the following SQL statement:

g.      This produces a table with all Plot data from Alaska

h.      Right click on the table and save

Export the table
i.        Right click on the table in the navigation pane

i.     Right Click>Export>text file

j.        In Export dialog select output location

k.      Select next

l.        Select “Delimited – Characters such as comma or tab separate each field”

m.    Select next

n.      Select Comma, and check box “Include Field Names on First Row”

o.      Select next

p.      Check the output file and location and select Finish

Import table to ArcGis
q.      In arcMap 10.7 select File>Add Data>Add XY Data

r.       Navigate to and select the .txt file you exported

s.       X field and Y field should auto populate with longitude and latitude respectively, if not use the drop down to select the X and Y fields

t.       Select Edit in the “Coordinate System of Input Coordinates” section

u.      In the search box enter “GCS_WGS_1984” and double click “WGS 1984” that appears under “Geographic Coordinate Systems”

v.      Select OK

Convert the XY data to a FileGeodatabase Shapefile
w.    In ArcMap in the navigation pane right click on the X Y data layer you imported

i.     Right click>Data>Export Data

x.      Select All Features

y.      Select This Layer’s Source Data

z.      Navigate to where you want to save, name your file, and Save as Type “File and Personal Geodatabase feature Classes”

i.     Do not save as a shapefile, this will cause many of the values in your attribute table to truncated

aa. Save

bb. Add layer to map

Clip the new point layer by your desired buffer distance around project area
cc. In this case we used 40 miles

dd. Buffer your Project shapefile

ee. Clip the point layer by the Project buffer

ff. Clip the newly clipped point layer by land area in the region

i.     This is necessary because the FIA plot data includes plots over water, which have no data.

gg. A model for this procedure could look something like this:

Export your new clipped point layer’s table as a .txt and import to access
hh. Right click on the new layer>attributes table

ii. Top left drop down>Export

jj. Export all records, save as a .txt

kk. In access top ribbon External Data>New Data Source>From File>Text File

ll. Select your text file,

i.     delineate with commas

ii. select First Row Contains Field Names

iii. Choose CN as primary Key

iv. Finish

Close pop up menu
mm.                      Design>View>SQL

nn. Enter the following query, RUN

Test math formula
$$1+\cos(23)/\ln(2)$$

 { "type": "FeatureCollection", "name": "kml2Geojsontest", "crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } }, "features": [ { "type": "Feature", "properties": { "Name": "kml2Geojsontest", "description": null, "tessellate": 1 }, "geometry": { "type": "Polygon", "coordinates": [ [ [ -91.17711167051911, 45.866031505038002 ], [ -91.174590676768076, 45.84340719927075 ], [ -91.129278873937167, 45.841654476744097 ], [ -91.129175618212741, 45.864937854117748 ], [ -91.17711167051911, 45.866031505038002 ] ] ] } } ] }

Basic Graph can also be imported through json code
{	"version": 2, "width": 400, "height": 200, "data": [ {			"name": "table", "values": [ {					"x": 1, "y": 1 },				{					"x": 2, "y": 3 },				{					"x": 3, "y": 2 },				{					"x": 4, "y": 4 }			]		}	],	"scales": [ {			"name": "x", "type": "linear", "range": "width", "zero": false, "domain": { "data": "table", "field": "x" }		},		{			"name": "y", "type": "linear", "range": "height", "nice": true, "domain": { "data": "table", "field": "y" }		}	],	"axes": [ {			"type": "x", "scale": "x" },		{			"type": "y", "scale": "y" }	],	"marks": [ {			"type": "area", "from": { "data": "table" },			"properties": { "enter": { "x": { "scale": "x", "field": "x" },					"y": { "scale": "y", "field": "y" },					"y2": { "scale": "y", "value": 0 },					"fill": { "value": "steelblue" },					"interpolate": { "value": "monotone" }				}			}		}	] }

google datastudio report
 Category:Tags __NOINDEX__ __NEWSECTIONLINK__