Tool Guide: what each workflow is for
Common Workflows
Red Cross Code Lookup
Built-in database of all Red Cross chapters, regions, divisions, and counties. Search by name to find ECODE, RCODE, DCODE, and FIPS codes instantly.
Why Use Codes Instead of Names?
Codes are standardized, unique identifiers that eliminate ambiguity and spelling errors.
ZIP Codes (5-digit)
What: United States Postal Service ZIP Code Tabulation Areas (ZCTA5)
Format: 5
digits (e.g., 33019, 02134)
Why better:
Every ZIP code is unique. "Miami" could refer to the city, county, or
multiple ZIP codes. 33101 is unambiguous.
FIPS Codes (5-digit)
What: Federal Information Processing Standards codes for counties
Format: 5
digits = State FIPS (2) + County FIPS (3), e.g., 12011 =
Florida (12) + Broward County (011)
Why better:
"Dallas" could be Dallas County, TX (48113) or Dallas County,
AL (01047). FIPS codes are unique nationwide and never change.
ECODE (Chapter Code)
What: Unique identifier for Red Cross chapters
Format:
Numeric code (e.g., 1019, 38300)
Why better:
"Red Cross of Kentucky" vs "American Red Cross Kentucky Region" vs "ARC
Kentucky" - all refer to the same chapter, but 1019 is always
correct.
RCODE (Region Code)
What: Unique identifier for Red Cross regions
Format:
Alphanumeric (e.g., 01R04, 38R28)
Why better: Region names change over time, but codes remain stable. "Southeast Region" might become "Southeast and Caribbean Division" - the code stays the same.
DCODE (Division Code)
What: Unique identifier for Red Cross divisions
Format:
Alphanumeric (e.g., D25, D27)
Why better:
Division names are long and can be abbreviated differently. D25
is always "Southeast and Caribbean Division" regardless of how it's written.
Key Benefits:
- No spelling variations (Jefferson vs Jeffersons vs Jefferson County)
- No ambiguity (Dallas city vs Dallas County vs Dallas Parish)
- Standardized format (always 5 digits for FIPS, always consistent)
- Never change (names change, codes stay the same)
- Perfect for joins (codes match exactly, names require fuzzy matching)
- International standards (FIPS is federal standard, ZIP is USPS standard)
Red Cross Enrichment adds geographic hierarchy codes to every row in your file
📥 WHAT YOU UPLOAD
Your CSV with ZIP, County FIPS, County + State, or a cleaned geocoded output
| Building ID | Address | City | ZIP | Status | Owner |
|---|---|---|---|---|---|
| B14625 | 113 S LAS POSAS RD | SAN MARCOS | 92078 | Active | Leased |
📤 WHAT YOU GET BACK
All your original columns + Red Cross geographic hierarchy columns; hardened skill exports also add match audit fields
| Building ID | Address | City | ZIP | Status | Owner | County | FIPS | ECODE | Chapter | RCODE | Region | DCODE | Division |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B14625 | 113 S LAS POSAS RD | SAN MARCOS | 92078 | Active | Leased | San Diego | 6073 | 1019 | San Diego County | 517 | Pacific | 105 | West |
✓ Browser enrichment adds: County, FIPS, ECODE, Chapter, RCODE, Region, DCODE, Division
Production enrichment standard
Do not accept a partial ZIP-only match as complete. For Lives Saved, case leads, or any geocoded operational file, run the hardened geocodio-clean-up or red-cross-enrich skill and expect 100% Red Cross assignment unless a row is explicitly documented as an exception.
- Match order: exact ZIP, lat/lon point in Red Cross county geography, Connecticut planning-region rule, U.S. territory rule, county/state fallback, nearby ZIP prefix fallback, then explicit unmatched review.
- Audit fields: hardened skill exports include
RC_Match_Method,RC_Match_Confidence, andRC_Match_Note. - Connecticut: preserve Census planning-region county-equivalent FIPS
09110-09190. Example: Greater Bridgeport Planning Region is09120; Stratford maps to ARC of Connecticut07038. Do not silently convert it back to old Fairfield County. - Territories: missing territory ZIPs do not prove enrichment failed. Use the explicit territory fallback for USVI, Guam, Northern Mariana Islands, and American Samoa; American Samoa may be region-level when no local chapter ECODE exists in the lookup.
Upload CSV File
Drop CSV file here or click to browse
Upload row-level data with ZIP, County FIPS, or County + State; use the hardened skill for geocoded edge cases
Load 10 sample building records to test enrichment
What This Does
This tool takes your CSV file with geographic identifiers (ZIP codes, FIPS codes, etc.) and automatically creates GeoJSON files at multiple aggregation levels. Perfect for creating choropleth maps in ArcGIS Online, web applications, or data visualization tools.
Geographic Hierarchy
ZIP Codes
Most granular level - includes all original data fields. Perfect for detailed analysis.
Counties
Aggregated from ZIP codes - includes county totals and hierarchy information.
Chapters
Aggregated from counties - boundaries created by merging county polygons.
Regions
Aggregated from chapters - larger geographic areas with regional totals.
Divisions
Highest level - aggregated from regions. Perfect for high-level overviews.
Step 1: Upload Your CSV File
💡 Tip: This tool will automatically aggregate your data by ZIP or County
Load 25 sample ZIP codes with data spanning multiple chapters and regions
Step 3: Select Output Levels
Choose which GeoJSON files you want to create (with hierarchical roll-ups):
Generated Files
Power BI → Orgler URL Converter
Convert Power BI URLs to Orgler format for embedding in Story Maps and RCView dashboards. Paste a single URL below for quick conversion, or scroll down for the Bulk Pipeline to convert many at once and create ArcGIS Dashboards.
How to Use:
- Click "Convert to Orgler URL" to see the sample conversion, or
- Replace the sample URL with your own Power BI report URL
- Click "Convert to Orgler URL"
- Copy the generated URL and use it in your Story Map or RCView embedding code
Note: Orgler URLs are optimized for embedding Power BI reports in ArcGIS Story Maps and RCView dashboards.
PowerBI → Orgler → ArcGIS Dashboard
Paste 1 or 50 Power BI URLs (or upload a CSV). Convert to Orgler URLs, then generate a Python script that creates an ArcGIS Dashboard for each — ready to run in an ArcGIS Online Notebook.
How to Use:
- Add URLs: Paste one or more Power BI URLs (one per line), or upload a CSV that contains Power BI URLs in any column — the tool auto-detects them
- Convert: Click "Convert All URLs" — each PowerBI URL is converted to an Orgler URL. Preview the results in the table
- Stop here if you only need Orgler URLs: Copy them or download a 2-column CSV (PowerBI | Orgler)
- Create ArcGIS Dashboards: Click "Generate Notebook Script" — this produces a complete Python script that creates one ArcGIS Dashboard per URL, each with a full-screen embedded content widget pointing to the Orgler URL
- Run the script: Open an ArcGIS Online Notebook, paste the script, and run it. The notebook is already authenticated — no tokens needed. It creates all dashboards and prints the results
- Get your results: Paste the notebook output back here, then download the final 3-column CSV: PowerBI URL | Orgler URL | Dashboard URL
Extract field names from an ArcGIS Online feature layer and generate inline CSS + HTML pop-up templates ready to paste into ArcGIS Experience Builder, Map Viewer, or Dashboards.
🤖 Pro Workflow: Use AI to Create Beautiful Pop-ups! (Click to expand)
🚀 The Smart Way to Create ArcGIS Pop-ups
ArcGIS pop-ups require INLINE CSS—all styles must be embedded
directly in the HTML using
style="..."
attributes.
External stylesheets and <style>
tags don't work!
ChatGPT, Claude, and other AI assistants excel at creating inline CSS. Provide your field names and design requirements, and they'll generate production-ready pop-up HTML.
📋 Recommended Workflow:
Use this tab to parse field definitions from your FeatureServer → Get clean field list
Example prompt to ChatGPT/Claude:
Copy the AI-generated HTML → Paste into ArcGIS pop-up configuration → Instant professional pop-up!
- Always specify "inline CSS" or "all styles in style attributes"
- Mention your color scheme (Red Cross: var(--arc-red), #c62828)
- Request specific layouts: table, card, header+sections, etc.
- Ask for formatting: commas in numbers, date formatting, currency symbols
- Include emojis or icons for visual appeal (📍 🏘️ 💰 📊 ✅)
- Test in one pop-up, then apply to all features!
How to Use:
- Open your ArcGIS FeatureServer REST page (e.g.,
.../FeatureServer/0) - Scroll down to the Fields: section
- Copy all the field definitions (the entire list showing field names, types, and aliases)
- Paste them into the box below
Quick Reference:
After parsing fields:
- Select which fields to include in your pop-up
- Optionally add a pop-up title
- Optionally group related fields together (e.g., all 2022-2025 fields in one group)
- Click "Generate Pop-up HTML"
- Copy the generated HTML and paste it into ArcGIS Experience Builder or Map Viewer pop-up editor
Note: Generated HTML uses inline CSS matching American Red Cross color standards (#c8102e) and compact Economist-style typography.
Generic Address Geocoder
Geocode addresses from a CSV file to latitude/longitude coordinates. Choose from three providers and get back GeoJSON or CSV files ready for mapping.
📊 Provider Comparison
| Provider | FREE Tier Limit | Credit Card? | Can Cache? | Get API Key |
|---|---|---|---|---|
| Mapbox | 100,000/month FREE | ✗ Yes | ✗ No | Sign up → |
| Geoapify | 3,000/day FREE (~90k/month) | ✓ No | ✓ Yes | Sign up → |
| Bing Maps | 125,000/year FREE (~10k/month) | ✓ No | ⚠ Limited | Sign up → |
How to Use:
- Choose a geocoding provider from the dropdown (Geoapify recommended)
- Get a free API key from the signup link (no credit card needed for Geoapify & Bing)
- Paste your API key in the field above
- Upload a CSV file with address columns (street, city, state, zip, etc.)
- Select which columns contain address information
- Optionally specify a country code to improve accuracy
- Click "Start Geocoding" to process your addresses
- Download the resulting GeoJSON or CSV file with coordinates
Note: Addresses are geocoded one at a time to respect API rate limits. All three providers offer generous free tiers - see comparison table above.
ArcGIS Metadata Updater - ChatGPT Prompt
💡 How Tab 7 + Tab 8 Work Together (Click to expand)
🚀 The Ultimate Workflow
- Copy the ChatGPT prompt below
- Paste into ChatGPT
- Answer questions about your item
- ChatGPT writes professional metadata
- Generate OAuth token (once every 90 days) → Tab 8
- Run:
python3 ~/arcgis_metadata_updater.py - Paste metadata from ChatGPT
- Updates item - NO 2FA!
- ❌ Old way: 10+ min per item (2FA every time)
- ✅ Tab 7 only: 5+ hours for 50 items (2FA×50)
- ✅ Tab 8 only: 2 hours (but inconsistent metadata)
- 🚀 BOTH tabs: ~90 min for 50 items, 0 2FA prompts!
- 🎯 You want AI-written metadata + Automated updates
- 🎯 Quality content + Efficient workflow = PERFECT!
- 🎯 Updating 10+ items (massive time savings!)
ChatGPT Interactive Prompt
- Click "Copy Prompt" above
- Paste into ChatGPT or Claude
- Answer the 8 questions it asks you (one at a time)
- ChatGPT generates your complete Python script
- Copy script → Paste into ArcGIS Notebook → Run!
🔐 ArcGIS OAuth Token Generator
1. Go to ArcGIS Developers
2. Sign in with your ArcGIS account
3. Click "New Application" → Give it a name
4. Under "Authentication" → Copy your Client ID
5. Set Redirect URI to: urn:ietf:wg:oauth:2.0:oob
- Go to ArcGIS Online
- Content → Add Item → Application
- Choose "Application"
- Registered App → OAuth 2.0
- Set redirect URI:
urn:ietf:wg:oauth:2.0:oob - Copy your Client ID
📘 How to Use This Tool
Get your Client ID from your registered OAuth app in ArcGIS Online. Don't have one? See instructions below.
A popup opens → Log in to ArcGIS → Complete 2FA → Authorization code appears → Copy the entire code
Paste authorization code → Click "Get Tokens" → Access and Refresh tokens appear
Click "Save" to download agol_refresh_token.json → Keep this file secure!
Use the saved JSON file with Python scripts to authenticate WITHOUT 2FA for up to 90 days!
📸 High-Resolution Screenshot Capture
🎯 What Is This?
A technique to capture ultra-high-resolution screenshots of web content—especially useful for ArcGIS maps, dashboards, and web apps that need to be printed or used in presentations.
💡 Why Use This?
- Print Quality: Capture maps at 5000×8000 pixels (or larger!) for high-quality printing
- Presentations: Get crystal-clear screenshots for PowerPoint, reports, and posters
- No Pixelation: Unlike normal screenshots that look blurry when zoomed, these stay sharp
- Perfect for Maps: ArcGIS maps, Experience Builder apps, Dashboards—all captured at full resolution
📊 Resolution Comparison
| Method | Resolution | Quality |
|---|---|---|
| ❌ Normal screenshot (laptop) | ~1920×1080 | Pixelated when printed |
| ✅ Custom Device (Kevin's method) | 5000×8000 (or more!) | Crystal clear, print-ready |
📋 How to Do It (Chrome)
- Open your ArcGIS map/dashboard/web app
- Press
F12orCmd+Option+I(Mac) orCtrl+Shift+I(Windows) - DevTools panel opens on the right or bottom
- Click the 📱 Device Toggle icon in top-left of DevTools
- Or press
Cmd+Shift+M(Mac) orCtrl+Shift+M(Windows) - Your page now shows in "mobile device" view
- Click the ⚙️ Settings icon (three dots) next to device selector dropdown
- Settings panel opens on the right
- Click "Devices" in the left menu
- Click "Add custom device..." button
- Device name:
Jumbo(or whatever you want!) - Width:
5000pixels - Height:
8000pixels - Device pixel ratio: Leave as
1 - User agent: Select
Mobile(or Desktop) - Click "Add"
Choose dimensions based on your final print size. Rule of thumb: multiply inches by 150-300 (DPI).
| Poster Size | Acceptable (150 DPI) | High Quality (300 DPI) |
|---|---|---|
| 2' × 3' (24" × 36") |
3600 × 5400
|
7200 × 10800
|
| 3' × 4' (36" × 48") |
5400 × 7200
|
10800 × 14400
|
| Letter (8.5" × 11") |
1275 × 1650
|
2550 × 3300
|
| Tabloid (11" × 17") |
1650 × 2550
|
3300 × 5100
|
💡 For maps viewed from distance (wall posters), 150 DPI is usually perfect. For close inspection (reports), use 300 DPI.
- Close Settings panel
- In the device dropdown (top of page), select "Jumbo"
- Your page now renders at 5000×8000 pixels!
- You'll see scrollbars because it's HUGE - that's normal
- Press
Cmd+Shift+P(Mac) orCtrl+Shift+P(Windows) - Type:
screenshot - Select "Capture full size screenshot"
- Image downloads automatically at FULL 5000×8000 resolution! 🎉
- Use extensions like "GoFullPage" or "Awesome Screenshot"
- They'll capture the entire page at full custom resolution
🌐 Other Browsers
Firefox has similar DevTools! Press F12 → Click device icon → Use
"Responsive Design Mode" →
Set custom dimensions → Use built-in screenshot tool (camera icon)
Edge uses Chromium, so the process is identical to Chrome above!
Enable Developer menu → Enter Responsive Design Mode → Set custom dimensions → Use screenshot extensions
🎯 Perfect For:
Capture web maps at print resolution for reports, posters, and presentations
Get high-res snapshots of Operations Dashboard or Experience Builder apps
Capture full Story Map sections without scrolling or pixelation
Any web application - charts, tables, complex layouts - all crystal clear
🔄 ArcGIS Feature Layer Automation
Automate daily updates to ArcGIS Feature Layers from SharePoint or OneDrive CSV files. This workflow eliminates manual uploads and keeps your maps always up-to-date.
📋 What This Does
Could be a daily export, manual upload, or automated report
Get the SharePoint sharing link or OneDrive sync path
Using ArcGIS Notebooks (cloud) or Python scripts (local Mac)
Every day, hour, or whenever you schedule it
Ask the data owner to:
- Upload their CSV file to SharePoint or OneDrive
- Right-click the file → Share → Copy Link
- Send you the link (looks like:
https://redcross.sharepoint.com/...)
- Go to ArcGIS Online → Content
- Find your feature layer (or create a new one from the CSV first)
- Open the item page
- Look at the URL:
https://redcross.maps.arcgis.com/home/item.html?id=abc123def456 - Copy the ID (the part after
id=)
0ac831210d79488481ebe52b4beba35d
- In ArcGIS Online, go to Content → New Item → Notebook
- Choose Python 3 runtime
- Name it something like "Daily CSV Update - [Your Layer Name]"
- Click Create
Copy and paste this code into a notebook cell:
from arcgis.gis import GIS
from arcgis.features import FeatureLayerCollection
import pandas as pd
# Connect to ArcGIS Online (you're already logged in!)
gis = GIS("home")
# Configuration
SHAREPOINT_CSV_URL = "YOUR_SHAREPOINT_LINK_HERE"
FEATURE_LAYER_ID = "YOUR_LAYER_ID_HERE"
# Download CSV from SharePoint
print("📥 Downloading CSV from SharePoint...")
df = pd.read_csv(SHAREPOINT_CSV_URL)
print(f"✅ Loaded {len(df)} rows")
# Get the feature layer
print("🔍 Finding feature layer...")
item = gis.content.get(FEATURE_LAYER_ID)
flc = FeatureLayerCollection.fromitem(item)
layer = flc.layers[0]
# Delete all existing features
print("🗑️ Deleting old features...")
layer.delete_features(where="1=1")
# Add new features from CSV
print("📤 Uploading new features...")
features = df.to_dict('records')
layer.edit_features(adds=features)
print("✅ Update complete!")YOUR_SHAREPOINT_LINK_HERE and YOUR_LAYER_ID_HERE with
your actual values!
- Click Run on the cell
- Watch the output - you should see "✅ Update complete!"
- Go to your feature layer and verify the data updated
- In the notebook, click Tasks (top menu)
- Click Create Task
- Choose your schedule:
- Daily at 6:00 AM
- Hourly during business hours
- Weekly on Monday mornings
- Click Create
- Done! Your layer will update automatically 🎉
🔧 Troubleshooting
Make sure you own the feature layer or have edit permissions. Check that your OAuth token has the right scopes.
Ensure the SharePoint link has "Anyone with the link" permissions, or share it directly with your ArcGIS email.
Your CSV columns must match the feature layer schema. Create the layer from the CSV first, or add missing fields to the layer.
ArcGIS Notebooks: Check the Tasks panel for errors.
🔍 ArcGIS REST Service Inspector
Quickly explore ArcGIS REST endpoints - see all layers, fields, domains, and metadata without clicking through pages.
- Service name, type, version, copyright
- All layers with feature counts and geometry types
- Complete field list with types, aliases, domains
- Spatial reference and extent information
- Copy metadata as JSON or download as TXT
📝 Arcade Expression Library
Copy/paste common Arcade expressions for pop-ups, labels, symbology, and filters. No Arcade knowledge required!
Arcade is ArcGIS's expression language for creating dynamic content - conditional formatting, calculated fields, custom labels, and more. These pre-built expressions work in ArcGIS Online, Pro, and Experience Builder.
🎨 Quick Symbology Generator
Generate ArcGIS symbology JSON for unique values, class breaks, or single symbols. Copy and paste into your web maps!
Creating custom color ramps, graduated symbols, and category-based styles without manually coding JSON.
Step 1: Select Field
Step 2: Choose Symbology Type
📦 Batch Item Updater
Update title, summary, tags, and metadata for multiple ArcGIS items at once using OAuth authentication.
This tool requires an OAuth refresh token. Use the OAuth Tokens tab (Tool #8) to generate one first!
Rebranding projects, standardizing metadata across 10+ items, or bulk tag updates.
Upload CSV with Items to Update
CSV should have columns: ItemID, NewTitle, NewSummary, NewTags
🔗 Service Dependency Mapper
Discover what maps, dashboards, and apps depend on a feature service before you modify or delete it.
Modifying a service schema (adding/removing fields) will break items that depend on it. Use this tool to assess impact first!
📎 Bulk Attachment Manager
Download all attachments from a feature layer, or upload multiple attachments in bulk using a CSV mapping file.
- Backup disaster damage photos before archiving
- Bulk upload facility inspection photos
- Export all shelter photos for offline use
Mode Selection
One-Step: Street Addresses → Coordinates + Red Cross Hierarchy
This browser tool takes a CSV with street addresses and does the fast ZIP-based pass:
- Geocodes each address via Geocodio API → lat/lng coordinates
- Extracts ZIP code from the geocoded result
- Looks up Red Cross hierarchy using the browser ZIP hierarchy table
Browser output: Your original columns + 12 new columns (Latitude, Longitude, Geocoded_Address, Confidence, County, FIPS, ECODE, Chapter, RCODE, Region, DCODE, Division)
Production case-file rule: After Geocodio, run the hardened geocodio-clean-up skill for the audited Red Cross pass. It uses ZIP first, then point/county, Connecticut planning-region, U.S. territory, and review fallbacks so records do not get stranded only because a ZIP is missing from the lookup table.
Check RC_Match_Method, RC_Match_Confidence, and RC_Match_Note before publishing or mapping.
Geocodio Access
Public users must paste their own Geocodio API key. Owner mode is password protected and uses a server-side key without exposing it in this page. Get a free API key at geocod.io
Safety rule: the owner password is only a trigger for the protected server function. Never put Jeff's Geocodio API key directly into this public page. Vercel must have GEOCODIO_API_KEY and either GEOCODIO_OWNER_PASSWORD or GEOCODIO_OWNER_PASSWORD_SHA256 configured.
Upload CSV with Addresses
Drop CSV file here or click to browse
CSV must have address columns (Street, City, State, ZIP)
Bulk Dashboard Creator — Convert multiple Power BI URLs into ArcGIS Dashboards instantly. Paste your URLs, define report types and regions, and generate a ready-to-run ArcGIS Notebook script that creates all dashboards in one click.
Step 1: Paste Power BI URLs
One URL per line. Include the report type and region as a label before each URL (e.g., DAT Response Overview | Alabama: https://app.powerbi.com/...)
How to Use:
- Paste Power BI URLs with labels:
Report Type | Region: URL - Click "Generate Notebook Script"
- Review the inventory table
- Copy the script into an ArcGIS Online Notebook and run
- All dashboards are created automatically with proper titles, tags, and embedded content
Prerequisite: Create ONE template dashboard manually in AGOL with an Embedded Content widget, then paste its JSON from AGOL Assistant (Data tab) when prompted.
CAP Fluxx Converter — Legacy one-report converter for the older Fluxx partner map export. It converts a single XLSX file into the 57-column CSV format required for the ArcGIS CAP Partner Map feature layer.
DCS Community Partner updates now use the local Python workflow because they require both the Fluxx request report and organization report. Run /Users/jefffranzen/Desktop/RED CROSS/Miscellaneous/fluxx/convert_and_geocode.py for the current two-report process.
Drop Fluxx XLSX File
Drop XLSX file here or click to browse
Legacy input: fluxx_cap_national_ops_summary_partner_map_*.xlsx
How to Use:
- Use this only for the older single partner-map Fluxx export.
- Export the partner map report from Fluxx (XLSX format)
- Drop the file above → review mapping and preview
- Paste your own Geocodio API key or choose owner mode with the protected password → click Geocode
- Click Download CSV if you want a local backup
- Click Sign in to ArcGIS
- Click Overwrite Feature Layer
Do not use this tab for DCS Community Partner updates. Use the local two-report Python workflow documented in CAP_FLUXX_UPDATE_RUNBOOK.md.
Empty fields: Secondary Focus, Tertiary Focus — not in Fluxx. Lat/Lng geocoded by Geocodio before download.
🔧 Experience Builder Hidden Features
Interactive checklist of powerful hidden features in ArcGIS Experience Builder. Star ★ items to prioritize, mark as Tried or Skip as you experiment.
📚 Documentation & Help
Complete reference guide for all Red Cross GIS Tools. Click any section in the Table of Contents to jump directly to that topic.
Table of Contents
🚀 Quick Start Guide
New to Red Cross GIS Tools? Here's the fastest way to get started:
- Code Lookup - Search for any Red Cross code (ECODE, RCODE, DCODE) or location
- Red Cross Enrichment - Upload a CSV with ZIP, FIPS, or County + State to add Red Cross hierarchy columns
- Create GeoJSON - Convert your enriched data into mappable GeoJSON files
All tools run entirely in your browser - no data is sent to any server. Your data stays private and secure.
🔍 Code Lookup
Search and explore the complete American Red Cross organizational hierarchy.
- ZIP lookup table - fast first-pass enrichment for most ZIP-coded records
- County and county-equivalent geography - FIPS mapping, including Connecticut planning-region county equivalents where available
- 226 Chapters - All ECODE assignments
- 48 Regions - All RCODE assignments
- 6 Divisions - All DCODE assignments
Red Cross Enrichment
Enrich your data with Red Cross geographic hierarchy columns, then use the hardened skill pipeline for geocoded production files and edge cases.
- ZIP codes - Column named "Zip", "ZIP", or "ZIP Code"
- County FIPS - 5-digit FIPS codes
- County + State - County name (with/without "County") + State
- Geocoded production files - use the
geocodio-clean-upskill when Latitude/Longitude, Geocodio County, or territory data is available
County - County nameFIPS - 5-digit FIPSECODE - Chapter codeChapter - Chapter nameRCODE - Region codeRegion - Region nameDCODE - Division codeDivision - Division name- Use exact ZIP when the ZIP table has a match.
- If ZIP is missing or absent from the table, use latitude/longitude against Red Cross county geography when available.
- For Connecticut, keep the Census planning-region county-equivalent FIPS codes
09110-09190. Example: Greater Bridgeport Planning Region is09120and Stratford maps to ARC of Connecticut07038. - For U.S. territories, apply explicit territory handling. USVI, Guam, Northern Mariana Islands, and American Samoa must not fail only because the ZIP lookup is incomplete.
- Use county/state and nearby ZIP-prefix fallbacks only when they produce a defensible, auditable assignment.
Hardened outputs include RC_Match_Method, RC_Match_Confidence, and RC_Match_Note. A partial count like 590 of 599 is a review failure, not a finished enrichment.
🗺️ Create GeoJSON
Transform CSV data into professional GeoJSON files with geographic boundaries.
- ZIP - Individual ZIP code boundaries (ZCTA)
- County - County boundaries with FIPS codes
- Chapter - Red Cross chapter territories (ECODE)
- Region - Red Cross region boundaries (RCODE)
- Division - Red Cross division boundaries (DCODE)
🔗 Orgler URL Creator
Convert Power BI report URLs to Orgler format for embedding in ArcGIS Story Maps.
📋 Pop-up Creator
Generate custom ArcGIS pop-up HTML with Red Cross branded inline CSS.
- Paste an ArcGIS REST API feature layer URL
- Tool fetches all field definitions automatically
- Select which fields to include in the pop-up
- Copy the generated HTML with inline CSS
- Paste directly into ArcGIS Pro or Online pop-up configuration
Generic Geocoder
Geocode addresses to GeoJSON or CSV with three FREE provider options.
- Mapbox - 100,000/month (requires credit card)
- Geoapify - 3,000/day (~90k/month, no credit card)
- Bing Maps - 125,000/year (~10k/month, no credit card)
🤖 Metadata Automation
Automate ArcGIS Online metadata updates with OAuth authentication.
- OAuth Sign-in - Full user permissions via implicit grant
- Content Audit - Scan for items missing summary, description, or tags
- 8 Item Types - Feature Layer, Web Map, Dashboard, Experience Builder, etc.
- Direct Updates - Apply changes directly to ArcGIS Online
- Category Assignment - Auto-resolve org category schema paths
🔐 OAuth Tokens
Generate OAuth tokens for ArcGIS API authentication.
- Python scripts that need API access
- Testing API endpoints
- Automating ArcGIS Online workflows
- Accessing protected feature services
📸 Hi-Res Captures
Capture high-resolution screenshots of ArcGIS web maps for publications and reports.
- Publication-quality map images
- Custom dimensions and resolutions
- PNG or JPEG export formats
- Perfect for reports, presentations, and documentation
🔧 OAuth Setup Guide
How to configure OAuth for web applications that need ArcGIS API access.
Step 1: Register OAuth Application
- Sign in to ArcGIS Online as administrator
- Go to Content → My Content
- Click New Item → Application → Application
- Fill in Title, Tags, and Summary
- Click Save
Step 2: Configure Redirect URIs
- Open the newly created application item
- Go to Settings tab
- Under Application, find Registered Info
- Click Update next to Redirect URIs
- Add ALL URLs where your app will be hosted:
http://localhost:8080/your-app/index.html https://yourusername.github.io/your-repo/index.html https://your-domain.com/your-app/index.html
Step 3: Copy Your Client ID
Find the App ID (also called Client ID) - a 16-character alphanumeric string like pyLZqliTbDfPwbi4. Save this for use in your JavaScript code.
🔧 Troubleshooting
❌ "Invalid redirect_uri" Error
Cause: The redirect URI in your browser doesn't match what's registered in ArcGIS Online.
Fix:
- Open browser console to see the exact redirect URI being used
- Go to ArcGIS Online → Content → Your OAuth App → Settings
- Add the EXACT URI (including protocol, port, and path)
- Common issues:
httpvshttps, trailing slashes, different ports
⚠️ "No joins found" when creating GeoJSON
Cause: Your CSV doesn't have the correct ID column for the selected level.
Fix:
- Check that your CSV has the correct ID column (FIPS, ECODE, RCODE, DCODE)
- Verify format: Division codes = "D21", Region codes = "32R16"
- Use Red Cross Enrichment first to add all hierarchy columns
🐢 Slow performance with large files
Cause: Processing large datasets in browser memory.
Fix:
- Use Red Cross Enrichment first to add hierarchy columns
- Start with higher geographic levels (County/Chapter instead of ZIP)
- Close other browser tabs to free memory
🗺️ Territory or Connecticut rows did not enrich
Cause: ZIP-only lookup is not enough for every operational record. Some U.S. territory ZIPs are absent from the local ZIP table, and Connecticut now uses planning regions as county-equivalent geography instead of the old county system.
Fix: Run the hardened geocodio-clean-up or red-cross-enrich skill and review RC_Match_Method, RC_Match_Confidence, and RC_Match_Note. Connecticut planning-region FIPS 09110-09190 should be preserved; territory rows should be assigned through explicit territory fallback when ZIP is missing from the lookup.
❓ Frequently Asked Questions
Q: Is my data sent to any server?
No! Most tools run entirely in your browser. Your data only leaves your computer when you explicitly use a tool that requires API access, such as Generic Geocoder or Geocodio + Red Cross.
Q: How current is the Red Cross hierarchy data?
The browser tools use the local Red Cross lookup package for fast hierarchy lookup. For production enrichment, the maintained skills also use current Red Cross county geometry and org-code lookups so Connecticut planning-region and U.S. territory exceptions can be handled explicitly.
Q: Can I use these tools offline?
Most tools work offline once the page is loaded. Exceptions are tools that fetch geographic boundaries or use external APIs, such as Generic Geocoder, Geocodio + Red Cross, OAuth, or ArcGIS automation.
Q: What file formats are supported?
Input: CSV files. Output: GeoJSON, CSV, and HTML depending on the tool.
Q: Where can I report bugs or request features?
Please open an issue on GitHub: github.com/franzenjb/GeoJSON-Creation-Tool/issues
Red Cross GIS Tools Documentation • Updated January 2025
Made with ❤️ for the American Red Cross