Skip to contents

Note: This article is a work in progress

EXAMPLES OF FILES & TEST DATA EJAM CAN IMPORT OR OUTPUT

Sample spreadsheets & shapefiles for trying the web app

Examples of .xlsx files and shapefiles are installed locally with EJAM, as input files you can use to try out EJAM functions or the web app, or to see what an input file should look like.

Files and Datasets Installed with EJAM

For just one topic you can see all files and data objects like this:


topic = "fips"  # or "shape" or "latlon" or "naics" or "address" etc.


# datasets / R objects
cbind(data.in.package  = sort(grep(topic, EJAM:::pkg_data()$Item, value = T)))
#> Get more info with pkg_data(simple = FALSE)
#> 
#> ignoring sortbysize because simple=TRUE
#>      data.in.package                  
#> [1,] "testinput_fips_blockgroups"     
#> [2,] "testinput_fips_cities"          
#> [3,] "testinput_fips_counties"        
#> [4,] "testinput_fips_mix"             
#> [5,] "testinput_fips_states"          
#> [6,] "testinput_fips_tracts"          
#> [7,] "testoutput_ejamit_fips_cities"  
#> [8,] "testoutput_ejamit_fips_counties"

# files
cbind(files.in.package = sort(basename(testdata(topic, quiet = T))))
#>       files.in.package                           
#>  [1,] "cities_2.xlsx"                            
#>  [2,] "counties_in_AL_detailed.xlsx"             
#>  [3,] "counties_in_Alabama.xlsx"                 
#>  [4,] "counties_in_Delaware_invalid.xlsx"        
#>  [5,] "counties_in_Delaware.xlsx"                
#>  [6,] "county_10.xlsx"                           
#>  [7,] "county_100.xlsx"                          
#>  [8,] "county_1000.xlsx"                         
#>  [9,] "county_state_300.xlsx"                    
#> [10,] "fips"                                     
#> [11,] "state_10.xlsx"                            
#> [12,] "state_50.xlsx"                            
#> [13,] "state_county_tract_10.xlsx"               
#> [14,] "testoutput_ejam2excel_fips_cities.xlsx"   
#> [15,] "testoutput_ejam2excel_fips_counties.xlsx" 
#> [16,] "testoutput_ejam2report_fips_cities.html"  
#> [17,] "testoutput_ejam2report_fips_counties.html"
#> [18,] "testoutput_ejam2report_fips_counties.pdf" 
#> [19,] "tract_10.csv"                             
#> [20,] "tract_100.csv"                            
#> [21,] "tract_1000.csv"                           
#> [22,] "tract_state_285.xlsx"

Local folders with sample files

The best, simplest way to see all these files is the function called testdata()


testdata()

# just shapefile examples:
 testdata('shape', quiet = TRUE)

You can try uploading these kinds of files in the web app, for example, by finding them in these local folders where you installed the package:

  • /EJAM/testdata/latlon/testpoints_100.xlsx
  • /EJAM/testdata/shapes/portland_shp.zip
  • etc.

To open the locally installed “testdata” folders (in Windows File Explorer, or MacOS Finder)

Example of using a file in EJAM

testpoint_files <- list.files(
  system.file("testdata/latlon", package = "EJAM"), 
  full.names = T
  )
testpoint_files

latlon_from_anything(testpoint_files[2]) 

Sample R data objects: Examples of inputs & outputs of EJAM functions

The package has a number of data objects, installed as part of EJAM and related packages, that are examples of inputs or intermediate data objects that you can use to try out EJAM functions, or you may just want to see what the outputs and inputs look like, or you could use them for testing purposes.

For documentation on each input or output item (R object), see reference documentation on each object

This code snippet provides a useful list of test/ sample data objects in EJAM and related packages:

POINT DATA (LAT/LON COORDINATES) for testing ejamit(), mapfast(), getblocksnearby(), etc.

See all files and all dataset examples related to one topic:

topic = "fips"
cbind(data.in.package  = sort(grep(topic, EJAM:::pkg_data()$Item, value = T)))
cbind(files.in.package = sort(basename(testdata(topic, quiet = T))))
x <- EJAM:::pkg_data(simple = FALSE)
x <- x[order(x$Package, x$Item), !grepl("size", names(x))]
x[grepl("^testp", x$Item), ]
#>     Package                Item
#> 146    EJAM       testpoints_10
#> 167    EJAM      testpoints_100
#> 168    EJAM   testpoints_100_dt
#> 184    EJAM     testpoints_1000
#> 197    EJAM    testpoints_10000
#> 147    EJAM        testpoints_5
#> 164    EJAM       testpoints_50
#> 176    EJAM      testpoints_500
#> 141    EJAM      testpoints_bad
#> 142    EJAM testpoints_overlap3
#>                                                        Title
#> 146 test points data.frame with columns sitenumber, lat, lon
#> 167 test points data.frame with columns sitenumber, lat, lon
#> 168 test points data.frame with columns sitenumber, lat, lon
#> 184 test points data.frame with columns sitenumber, lat, lon
#> 197 test points data.frame with columns sitenumber, lat, lon
#> 147 test points data.frame with columns sitenumber, lat, lon
#> 164 test points data.frame with columns sitenumber, lat, lon
#> 176 test points data.frame with columns sitenumber, lat, lon
#> 141       test points data.frame with columns note, lat, lon
#> 142       test points data.frame with columns note, lat, lon

STREET ADDRESSES for testing geocoding in latlon_from_address() etc.

x[grepl("^test_", x$Item), ]
#> [1] Package Item    Title  
#> <0 rows> (or 0-length row.names)
cat("\n\n")

FACILITY REGISTRY IDs for testing latlon_from_regid() etc.

x[grepl("^test[^op_]", x$Item), ]
#>     Package                              Item
#> 144    EJAM               testinput_address_2
#> 150    EJAM               testinput_address_9
#> 145    EJAM           testinput_address_parts
#> 157    EJAM           testinput_address_table
#> 165    EJAM         testinput_address_table_9
#> 158    EJAM testinput_address_table_goodnames
#> 159    EJAM  testinput_address_table_withfull
#> 132    EJAM        testinput_fips_blockgroups
#> 61     EJAM             testinput_fips_cities
#> 62     EJAM           testinput_fips_counties
#> 63     EJAM                testinput_fips_mix
#> 64     EJAM             testinput_fips_states
#> 133    EJAM             testinput_fips_tracts
#> 65     EJAM                    testinput_mact
#> 66     EJAM                   testinput_naics
#> 67     EJAM            testinput_program_name
#> 160    EJAM          testinput_program_sys_id
#> 68     EJAM                   testinput_regid
#> 69     EJAM             testinput_registry_id
#> 173    EJAM                testinput_shapes_2
#> 70     EJAM                     testinput_sic
#> 172    EJAM                      testshapes_2
#>                                                        Title
#> 144            datasets for trying address-related functions
#> 150            datasets for trying address-related functions
#> 145            datasets for trying address-related functions
#> 157            datasets for trying address-related functions
#> 165            datasets for trying address-related functions
#> 158            datasets for trying address-related functions
#> 159            datasets for trying address-related functions
#> 132                       testinput_fips_blockgroups dataset
#> 61                             testinput_fips_cities dataset
#> 62                           testinput_fips_counties dataset
#> 63                                testinput_fips_mix dataset
#> 64                             testinput_fips_states dataset
#> 133                            testinput_fips_tracts dataset
#> 65                                    testinput_mact dataset
#> 66                                   testinput_naics dataset
#> 67                            testinput_program_name dataset
#> 160    test data, EPA program system ID numbers to try using
#> 68  test data, EPA Facility Registry ID numbers to try using
#> 69  test data, EPA Facility Registry ID numbers to try using
#> 173                               testinput_shapes_2 dataset
#> 70                                     testinput_sic dataset
#> 172                                     testshapes_2 dataset
cat("\n\n")

EXAMPLES OF OUTPUTS from ejamit(), getblocksnearby(), etc., you can use as inputs to ejam2report(), ejam2excel(), ejam2ratios(), ejam2barplot(), doaggregate(), etc.

x[grepl("^testout", x$Item), ]
#>     Package                                      Item
#> 209    EJAM     testoutput_doaggregate_1000pts_1miles
#> 202    EJAM      testoutput_doaggregate_100pts_1miles
#> 193    EJAM       testoutput_doaggregate_10pts_1miles
#> 210    EJAM          testoutput_ejamit_1000pts_1miles
#> 203    EJAM           testoutput_ejamit_100pts_1miles
#> 198    EJAM            testoutput_ejamit_10pts_1miles
#> 200    EJAM             testoutput_ejamit_fips_cities
#> 201    EJAM           testoutput_ejamit_fips_counties
#> 195    EJAM                testoutput_ejamit_shapes_2
#> 205    EJAM testoutput_getblocksnearby_1000pts_1miles
#> 191    EJAM  testoutput_getblocksnearby_100pts_1miles
#> 183    EJAM   testoutput_getblocksnearby_10pts_1miles
#>                                                                  Title
#> 209                                       test output of doaggregate()
#> 202                                       test output of doaggregate()
#> 193                                       test output of doaggregate()
#> 210                                            test output of ejamit()
#> 203                                            test output of ejamit()
#> 198                                            test output of ejamit()
#> 200                              testoutput_ejamit_fips_cities dataset
#> 201                            testoutput_ejamit_fips_counties dataset
#> 195                                 testoutput_ejamit_shapes_2 dataset
#> 205 test output of getblocksnearby(), and is an input to doaggregate()
#> 191 test output of getblocksnearby(), and is an input to doaggregate()
#> 183 test output of getblocksnearby(), and is an input to doaggregate()
cat("\n\n")

LARGE DATASETS USED BY THE PACKAGE

Note that the largest files used by the package are mostly the block-related datasets with info about population size and location of US blocks, the facility datasets with info about EPA-regulated sites, and the blockgroup-related datasets with EJSCREEN indicators.

Some datasets get downloaded by the package at installation or launch or as needed. See the article on Updating EJAM Datasets for more information on these.

Also see reference documentation for each dataset.