Spatial Data in CEIDARS

LinYing LiEmission Inventory Workshop

March 13, 2006

Air Resources Board

Emission Inventory WorkshopSpring 2006 2

Outline of the Topics Significance of spatial data in CEIDARS Spatial coordinate systems Types of spatial data Spatial data fields in CEIDARS Tools for populating spatial data Tools for mapping spatial data Tools for updating spatial data in CEIDARS

Air Resources Board

Emission Inventory WorkshopSpring 2006 3

Why is Location Important? Emission inventory is the foundation for air

quality management and regulatory activities at local, regional, state, and national levels

Incomplete and inaccurate data downgrades the value of emission inventory

Location information is a critical component for emission inventory, especially for non-mobile sources

Air Resources Board

Emission Inventory WorkshopSpring 2006 4

Geographic Coordinate Systems

Equator

X

Z

Y

P

(0,0,0)

longitude

latit

ude

Pri

me M

eri

dia

n

Air Resources Board

Emission Inventory WorkshopSpring 2006 5

Geographic Coordinate Systems

Latitude/LongitudeIn California, 32.50o < Latitude < 42.00o

-124.25o <Longitude< -114.15o

Decimal Degrees34o15’30’’ = 34 + 15/60 + 30/3600= 34.25833o

Air Resources Board

Emission Inventory WorkshopSpring 2006 6

Projected Coordinate Systems

Universal Transverse Mercator (UTM) Easting, Northing, Zone

Datum NAD27, NAD83

Spheroid Clarke1866, WGS84

Air Resources Board

Emission Inventory WorkshopSpring 2006 7

Types of Spatial Data in CEIDARS Administrative District

county, air basin, air district Postal Address

street address, city, zip code Geographic Coordinate System

longitude and latitude Projected Coordinate System

UTM North and East Public Land Survey System

meridian base, township, range, section

Air Resources Board

Emission Inventory WorkshopSpring 2006 8

Spatial Fields in CEIDARS County, Air Basin, Air District in all Tables

CO, AB, DIS Facility Address (FACxxxx)

FSTREET, FCITY, FZIP, FZIPEXT Facility Coordinates (FACxxxx)

COORD_SYS, DATUM, SPHEROID, X_USERCOORD, Y_USERCOORD,

Stack Coordinates (STKxxxx) COORD_SYS, DATUM, SPHEROID,

X_USERCOORD, Y_USERCOORD Device Survey Location (DEVxxxx)

TWNSHP, RANGE, SECT

Air Resources Board

Emission Inventory WorkshopSpring 2006 9

UTM Zones

abs(Longitude)>120o

abs(Longitude)<120o

Air Resources Board

Emission Inventory WorkshopSpring 2006 10

Rounding Errors CARB has UTMs in Kilometers, not meters UTM Easting (UE) - 6 digits

1000 meters - 649.0 100 meters - 649.1 10 meters - 649.12 1 meters - 649.123

UTM Northing (UN) - 7 digits UTM Zone (UZ) 10 or 11

Air Resources Board

Emission Inventory WorkshopSpring 2006 11

Sources for Coordinates GPS Receiver (Best) Assessor’s Parcels (Good) GIS Layer (Good) Address Matching (Adequate)

Arc GIS Google Earth Web Tools

Air Resources Board

Emission Inventory WorkshopSpring 2006 12

Magellan GPS 315 Low cost (< $200) PC cable available 2 AA batteries A lithium backup battery Weather proof

Air Resources Board

Emission Inventory WorkshopSpring 2006 13

Spatial Fields Populated By ARB

Facility Coordinates (FACxxxx) UE_NAD83, UN_NAD83, LAT_NAD83, LON_NAD83

Stack Coordinates (STKxxxx) UE_NAD83, UN_NAD83, LAT_NAD83, LON_NAD83

Spatial data were populated and uploaded to CEIDARS for 1990-2002

Air Resources Board

Emission Inventory WorkshopSpring 2006 14

Steps to Populate ARB Spatial Data Fields in CEIDARS

ZIP, CITY, CO ?

Street Address ?

GeoCoding using GIS, Google Earth, etc.

Transfer to NAD83 longitude and latitude

Convert UTM from NAD27 to NAD83

X,Y_UserCoord ?no

yes

no

yes

yesUsing Centroid of the Area

GeoTrans

Air Resources Board

Emission Inventory WorkshopSpring 2006 15

Tools to Populate ARB Spatial Data Fields – GeoCoding

Air Resources Board

Emission Inventory WorkshopSpring 2006 16

Tools to Populate ARB Spatial Data Fields - Lat/Lon Picker

Air Resources Board

Emission Inventory WorkshopSpring 2006 17

Tools to Populate ARB Spatial Data Fields – Google Earth

Air Resources Board

Emission Inventory WorkshopSpring 2006 18

Tools to Populate ARB Spatial Data Fields - GeoTrans

Air Resources Board

Emission Inventory WorkshopSpring 2006 19

Tools to Map CEIDARS Spatial Data: Facility Locator

Air Resources Board

Emission Inventory WorkshopSpring 2006 20

Tools to Map CEIDARS Spatial Data: Facility Locator

Air Resources Board

Emission Inventory WorkshopSpring 2006 21

Tools to Map CEIDARS Spatial Data: MAAPS

Air Resources Board

Emission Inventory WorkshopSpring 2006 22

Tools to Map CEIDARS Spatial Data: Google Map

Air Resources Board

Emission Inventory WorkshopSpring 2006 23

Tools to Map CEIDARS Spatial Data: EnviroMapper

Air Resources Board

Emission Inventory WorkshopSpring 2006 24

Tools to Map CEIDARS Spatial Data: CHAPIS

Air Resources Board

Emission Inventory WorkshopSpring 2006 25

Tools to update CEIDARS Spatial Data: CEIDARS Online

Air Resources Board

Emission Inventory WorkshopSpring 2006 26

Tools to update CEIDARS Spatial Data: CEIDARS Online

Air Resources Board

Emission Inventory WorkshopSpring 2006 27

Tools to update CEIDARS Spatial Data: CEIDARS Online

Air Resources Board

Emission Inventory WorkshopSpring 2006 28

Web Resources

Google Earth http://earth.google.com/index.html

GeoTrans http://earth-info.nima.mil/GandG/geotrans/

MAAPS http://dtscnet.dtsc.ca.gov/edet/maaps_edet/index.cfm

EnviroMapper http://www.epa.gov/compliance/whereyoulive/

ejtool.html CHAPIS

http://www.arb.ca.gov/gismo/chapis_v01_6_1_04/ CEIDARS Online

http://www.arb.ca.gov/app/emsinv/dist/