Jonah Adkins jonahadkins

## test_gadm.geojson

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jonahadkins
                / test_gadm.geojson
            
            
              Created
              March 16, 2022 12:48
            
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## index.html
<!DOCTYPE html>
<meta charset="utf-8">
<style>

body {
  background: #fcfcfa;
  height: 500px;
  position: relative;
  width: 960px;
}

## show_related_records.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              2 stars
            
          
                jonahadkins
                / show_related_records.md
            
            
              Last active
              March 22, 2023 21:10
            
              
                Esri Arcade Labeling Expression To Show Related Records
              
          
    Esri Arcade Labeling Expression
Finds related records between two layers in a web map.
var aTable = $feature.aTableAttributeID;
var relate = "bTableAttributeID = '" + $feature.aTableAttributeID + "'";
var bTable = FeatureSetByName($map, 'bTableNameInWebMap');
var match = Filter(bTable, relate);
var cnt = Count(match);


## index.html
<!DOCTYPE html>
<html>

<head>
    <meta charset='utf-8' />
    <meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
    <script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.51.0/mapbox-gl.js'></script>
    <link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.51.0/mapbox-gl.css' rel='stylesheet' />

    <style>

## When_DateDiff.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                jonahadkins
                / When_DateDiff.md
            
            
              Last active
              March 17, 2023 04:27
            
          
    Esri Arcade Labeling Expression
When today's date is 12/24/36 months from attribute date, label the date with green/yellow/red.
when (
(DateDiff(Today(), $feature.date, 'months') <= 12),
'<CLR green = "255">' + TEXT($feature.date, 'D MMM YYYY') +'</CLR>',
(DateDiff(Today(), $feature.date, 'months') <= 24) ,
'' + TEXT($feature.date, 'D MMM YYYY') +'',


## index.html
<!DOCTYPE html>
<html>
<head>
    <meta charset='utf-8' />
    <title>test</title>
    <meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
    <script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.44.1/mapbox-gl.js'></script>
    <link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.44.1/mapbox-gl.css' rel='stylesheet' />
    <style>
        body { margin:0; padding:0; }

## web_map_zoom_scales.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jonahadkins
                / web_map_zoom_scales.md
            
            
              Created
              January 23, 2018 22:12
            
          
    24 : 70.53107625

23 : 141.0621525

22 : 282.124305

21 : 564.24861

20 : 1128.497220

19 : 2256.994440

18 : 4513.988880

17 : 9027.977761

16 : 18055.955520

15 : 36111.911040

  
## oracle_table_size_in_mb.sql
col a format a15 heading 'snapshot|date'
col b format a25 heading 'table|name'
col c format 999,999,999 'space|used|total'

select
to_char(begin_interval_time, 'yy/mm/dd hh24:mm') a,
object_name b,
space_used_total c

from

## ne_10m_geography_marine_polys.geojson

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jonahadkins
                / ne_10m_geography_marine_polys.geojson
            
            
              Created
              August 2, 2017 13:29
            
              
                simple_ne_10m_marine_poly
              
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## .block
license: gpl-3.0
	<!DOCTYPE html>
	<meta charset="utf-8">
	<style>

	body {
	background: #fcfcfa;
	height: 500px;
	position: relative;
	width: 960px;
	}
	<!DOCTYPE html>
	<html>

	<head>
	<meta charset='utf-8' />
	<meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
	<script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.51.0/mapbox-gl.js'></script>
	<link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.51.0/mapbox-gl.css' rel='stylesheet' />

	<style>
	col a format a15 heading 'snapshot\|date'
	col b format a25 heading 'table\|name'
	col c format 999,999,999 'space\|used\|total'

	select
	to_char(begin_interval_time, 'yy/mm/dd hh24:mm') a,
	object_name b,
	space_used_total c

	from