20240422
21020400
1.0
FALSE
JSONToFeatures ..\json\apcd_raster_data.json D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\SD_PresTime_AirNow Polygon
Project D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\SD_PresTime_AirNow D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow PROJCS["NAD_1983_StatePlane_California_VI_FIPS_0406_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",6561666.666666666],PARAMETER["False_Northing",1640416.666666667],PARAMETER["Central_Meridian",-116.25],PARAMETER["Standard_Parallel_1",32.78333333333333],PARAMETER["Standard_Parallel_2",33.88333333333333],PARAMETER["Latitude_Of_Origin",32.16666666666666],UNIT["Foot_US",0.3048006096012192]] WGS_1984_(ITRF00)_To_NAD_1983 PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0]] NO_PRESERVE_SHAPE # NO_VERTICAL
AddField D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow PM10AQI "Double (double precision)" # # # # NULLABLE NON_REQUIRED #
CalculateField D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow PM10AQI !PM10_AQI! "Python 3" # Text NO_ENFORCE_DOMAINS
AddField D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow AQI "Double (double precision)" # # # AQI NULLABLE NON_REQUIRED #
CalculateField D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow AQI maxCalculator(!OZONE_AQI!, !PM25_AQI!, !PM10AQI!) "Python 3" "def maxCalculator(*args):
valid_args = set()
for arg in args:
if arg:
valid_args.add(arg)
return max(valid_args)" Text NO_ENFORCE_DOMAINS
FeatureClassToFeatureClass D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb APCD_Air_Quality_Points # "AQSID "EPA AQS ID" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,AQSID,0,256;CountryCode "Country Code" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,CountryCode,0,256;DataSource "Data Source" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,DataSource,0,256;EPARegion "EPA Region" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,EPARegion,0,256;Elevation "Elevation" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,Elevation,-1,-1;GMTOffset "GMT Offset Amount (hours)" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,GMTOffset,-1,-1;Latitude "Latitude" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,Latitude,-1,-1;LocalTimeString "Local Time at Monitor" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,LocalTimeString,0,256;Longitude "Longitude" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,Longitude,-1,-1;OZONE "OZONE" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,OZONE,-1,-1;OZONEPM_AQI "Ozone & PM AQI" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,OZONEPM_AQI,-1,-1;OZONEPM_AQI_LABEL "Ozone & PM AQI (For Labeling)" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,OZONEPM_AQI_LABEL,0,256;OZONEPM_AQI_SORT "Ozone & PM AQI (For Sorting)" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,OZONEPM_AQI_SORT,-1,-1;OZONE_AQI "Ozone AQI" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,OZONE_AQI,-1,-1;OZONE_AQI_LABEL "Ozone AQI (For Labeling)" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,OZONE_AQI_LABEL,0,256;OZONE_AQI_SORT "Ozone AQI (For Sorting)" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,OZONE_AQI_SORT,-1,-1;OZONE_Measured "Ozone Measured at Site" true true false 4 Long 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,OZONE_Measured,-1,-1;OZONE_Unit "Ozone Unit of Measure" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,OZONE_Unit,0,256;PM10 "PM10" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM10,0,256;PM10_AQI "PM10 AQI" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM10_AQI,0,256;PM10_AQI_LABEL "PM10 AQI (For Labeling)" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM10_AQI_LABEL,0,256;PM10_AQI_SORT "PM10 AQI (For Sorting)" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM10_AQI_SORT,-1,-1;PM10_Measured "PM10 Measured at Site" true true false 4 Long 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM10_Measured,-1,-1;PM10_Unit "PM10 Unit of Measure" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM10_Unit,0,256;PM25 "PM2.5" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM25,-1,-1;PM25_AQI "PM2.5 AQI" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM25_AQI,-1,-1;PM25_AQI_LABEL "PM2.5 AQI (For Labeling)" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM25_AQI_LABEL,0,256;PM25_AQI_SORT "PM2.5 AQI (For Sorting)" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM25_AQI_SORT,-1,-1;PM25_Measured "PM2.5 Measured at Site" true true false 4 Long 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM25_Measured,-1,-1;PM25_Unit "PM2.5 Unit of Measure" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM25_Unit,0,256;PM_AQI "PM2.5 & PM10 AQI" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM_AQI,-1,-1;PM_AQI_LABEL "PM2.5 & PM10 AQI (For Labeling)" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM_AQI_LABEL,0,256;PM_AQI_SORT "PM2.5 & PM10 AQI (For Sorting)" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM_AQI_SORT,-1,-1;ReportingArea_PipeDelimited "Reporting Area(s)" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,ReportingArea_PipeDelimited,0,256;SiteName "Site Name" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,SiteName,0,256;StateName "State Name" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,StateName,0,256;Status "Site Operational Status" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,Status,0,256;ValidTime "ValidTime" true true false 8 Date 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,ValidTime,-1,-1;MonitorType "MonitorType" true true false 256 Text 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,MonitorType,0,256;PM10AQI "PM10AQI" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,PM10AQI,-1,-1;AQI "AQI" true true false 8 Double 0 0,First,#,D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\Reprojected_AirNow,AQI,-1,-1" #
Copy D:\ETL_Processes\APCD_Raster\fgdb\airpollutionpackage.gdb\APCD_Air_Quality_Points ..\connections\ustlcscsd0020_SDEP_sangis.sde\SDEP.SANGIS.APCD_Air_Quality_Points FeatureClass #
ChangePrivileges ..\connections\ustlcscsd0020_SDEP_sangis.sde\APCD_Air_Quality_Points cosd_map_app_intranet "Grant view privileges" "Do not change edit privileges"
Server=USTLCSCSD0020; Service=sde:sqlserver:USTLCSCSD0020,1453; Database=SDEP; User=sangis; Version=sde.DEFAULT
ArcSDE Connection
APCD_Air_Quality_Points
002
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_California_VI_FIPS_0406_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WKT>PROJCS["NAD_1983_StatePlane_California_VI_FIPS_0406_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",6561666.666666666],PARAMETER["False_Northing",1640416.666666667],PARAMETER["Central_Meridian",-116.25],PARAMETER["Standard_Parallel_1",32.78333333333333],PARAMETER["Standard_Parallel_2",33.88333333333333],PARAMETER["Latitude_Of_Origin",32.16666666666666],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2230]]</WKT><XOrigin>-118608900</XOrigin><YOrigin>-91259500</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102646</WKID><LatestWKID>2230</LatestWKID></ProjectedCoordinateSystem>
20240422
20530300
20240422
20530300
Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 14393) ; Esri ArcGIS 12.9.0.31656
APCD_IDW_Points
APCD
IDW
Monitoring station points used in creating the APCD IDW rasters. Note that not all stations are APCD stations.
File Geodatabase Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
APCD_Air_Quality_Points
Feature Class
0
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
AQSID
EPA AQS ID
String
256
0
0
CountryCode
Country Code
String
256
0
0
DataSource
Data Source
String
256
0
0
EPARegion
EPA Region
String
256
0
0
Elevation
Elevation
Double
8
0
0
GMTOffset
GMT Offset Amount (hours)
Double
8
0
0
Latitude
Latitude
Double
8
0
0
LocalTimeString
Local Time at Monitor
String
256
0
0
Longitude
Longitude
Double
8
0
0
OZONE
OZONE
Double
8
0
0
OZONEPM_AQI
Ozone & PM AQI
Double
8
0
0
OZONEPM_AQI_LABEL
Ozone & PM AQI (For Labeling)
String
256
0
0
OZONEPM_AQI_SORT
Ozone & PM AQI (For Sorting)
Double
8
0
0
OZONE_AQI
Ozone AQI
Double
8
0
0
OZONE_AQI_LABEL
Ozone AQI (For Labeling)
String
256
0
0
OZONE_AQI_SORT
Ozone AQI (For Sorting)
Double
8
0
0
OZONE_Measured
Ozone Measured at Site
Integer
4
0
0
OZONE_Unit
Ozone Unit of Measure
String
256
0
0
PM10
PM10
String
256
0
0
PM10_AQI
PM10 AQI
String
256
0
0
PM10_AQI_LABEL
PM10 AQI (For Labeling)
String
256
0
0
PM10_AQI_SORT
PM10 AQI (For Sorting)
Double
8
0
0
PM10_Measured
PM10 Measured at Site
Integer
4
0
0
PM10_Unit
PM10 Unit of Measure
String
256
0
0
PM25
PM2.5
Double
8
0
0
PM25_AQI
PM2.5 AQI
Double
8
0
0
PM25_AQI_LABEL
PM2.5 AQI (For Labeling)
String
256
0
0
PM25_AQI_SORT
PM2.5 AQI (For Sorting)
Double
8
0
0
PM25_Measured
PM2.5 Measured at Site
Integer
4
0
0
PM25_Unit
PM2.5 Unit of Measure
String
256
0
0
PM_AQI
PM2.5 & PM10 AQI
Double
8
0
0
PM_AQI_LABEL
PM2.5 & PM10 AQI (For Labeling)
String
256
0
0
PM_AQI_SORT
PM2.5 & PM10 AQI (For Sorting)
Double
8
0
0
ReportingArea_PipeDelimited
Reporting Area(s)
String
256
0
0
SiteName
Site Name
String
256
0
0
StateName
State Name
String
256
0
0
Status
Site Operational Status
String
256
0
0
ValidTime
ValidTime
Date
8
0
0
MonitorType
MonitorType
String
256
0
0
PM10AQI
PM10AQI
Double
8
0
0
AQI
AQI
Double
8
0
0
20240422
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKgvLSG+tJLW4UtDIMMAxUn8RzU9ABRRRQAUUUUAFFFFABRRRQAUU
UUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRR
QAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAMllSCF5ZG2oilmPoByaIp
EmiSWM7kdQyn1Bp9FABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUU
AFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAQfaf9O+zeRN
/q/M87b+764259e+PSp6KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiig
AooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAC
iiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK
KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooo
oAKKKKACiiigAooooAKKKKACiiigAooooAgvPtX2Kb7D5P2rYfK8/Ozd23Y5x9KlTdsXfjfj5tvT
PtTqKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigA
ooooAKKKKACiiigAooooAKKKRmVEZ2ICqMknsKAFoqG1uoL21iuraVZYJVDxup4YHoRU1ABRRRQA
UUUUAFFFIGUsVDDcOSM8igBaKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiioLmGSdYxHcPAVkVyUAO4Dqpz2NAE9FFFABUK2tul3
JdLCguJFVHkA+ZlXOAT6DJ/OpqKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKrzWvnXdtcefOnkFj5aPhJMjHzDvjqPQ0AWKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACop7mC1RXnmSJWYIpdsAsTgD6k1LSMquAGUMAc8jPNAC0UUUAFF
FFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRUEVqkNzPOrSlpypYNISowM
fKDwv4daAJ6KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK
KKACiiigAooooAKKKKACiiigAooooAKKKhe0hku4rpkzNErIjZPAbGeOnYUATU2Tf5beXt34O3d0
z2zTqha6hW7S1LHznQuq7TyAQDz07igB1v532aL7Ts8/YPM8vO3djnGecZqSiigAooooAKKKKACi
iigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKK
KACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigD/9k=