20260914
10134700
1.0
FALSE
AAH_all_Highway
-13833102.328500
-12723853.898800
3834973.342000
5161799.897500
1
Projected
GCS_WGS_1984
Linear Unit: Meter (1.000000)
WGS_1984_Web_Mercator_Auxiliary_Sphere
<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/3.4.0'><WKT>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],AUTHORITY["EPSG",3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem>
20260911
11213300
20260911
11213300
AAH_all_Highway
2026-09-11T00:00:00
2026-09-11T00:00:00
Statewide polyline feature class of Adopt-A-Highway (AAH) sites across all 12 Caltrans districts, merged into a single layer for display in the statewide AAH web map with district toggle/filter. Each feature is a highway segment along the State Highway Network that is available for adoption, adopted, vacant, or not adoptable. Geometry is generated by linear referencing each segment's begin and end postmiles along the SHN centerline (SHN_lines) via the Caltrans LRS measureToGeometry operation; each travel direction on a divided highway is placed on its own alignment. The published status field (Status_Pub, aliased 'Status': Adopted, Available Pending Site Review, Vacant, Not Adoptable) drives the map symbology. Location and status depend on the source Adopt-A-Highway database; users should verify critical sites against the district AAH coordinator's records.
The AAH_all_Highway feature class displays Adopt-A-Highway sites as highway segments for the entire California State Highway Network, merged from all 12 Caltrans districts into one statewide layer. It is produced by the AAH application-to-feature pipeline, which ingests each district's GIS join query exports (D##_qry_GIS_Join_EN1 and _WS1), drops personally identifiable applicant contact fields, and generates line geometry by linear referencing each site's begin and end postmiles along the State Highway Network centerline (SHN_lines) using the Caltrans LRS measureToGeometry REST operation.
Each travel direction on a divided highway is derived from the source direction and placed as a separate feature on its own alignment; directions are never merged. The map status class (Status_Pub, aliased 'Status') is derived by the pipeline's reclassification step from the source adoption status, with 'Vacant (NSR)' promoted to 'Available Pending Site Review'. The published schema is a curated subset for public display: feature key (id_AHH_Join), district, county, route, begin/end postmile and postmile span (pm_span_mi), direction, city, begin/end postmile landmark descriptions, location type, maintenance region, and the derived public status (Status_Pub, aliased 'Status'). Source applicant, contact, and group fields are not included.
Sites with real postmile length (pm_span_mi greater than zero) are placed in this layer; single-postmile 'other location' sites are placed in the companion AAH_all_other_loc point layer. Approximately 99.4% of source rows are successfully placed statewide. The layer is establish-then-update: the schema is created on the first run and subsequently truncated and reloaded. Spatial reference follows the SHN_lines source; confirm before publishing.
adopt-a-highway
AAH
statewide
litter removal
highway sponsorship
adoptable sites
Caltrans
state highway
highway segments
postmile
linear referencing
LRS
SHN
maintenance
GIS
None. This dataset is approved for public distribution. Personally identifiable applicant contact information from the source Adopt-A-Highway database is removed during processing.
vector
018
California
2026-09-08T00:00:00
1
-124.264872
-114.300324
42.005477
32.544307
Esri ArcGIS 13.4.0.55405
AAH_all_Highway
Feature Class
Statewide polyline feature class of Adopt-A-Highway (AAH) sites across all 12 Caltrans districts, merged into a single layer for display in the statewide AAH web map with district toggle/filter.
Caltrans
15360
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.
Shape_Length
Shape_Length
System-managed length of the polyline geometry, in the linear unit of the feature class spatial reference, automatically calculated and maintained by ArcGIS. Present in AAH_all_Highway only.
Adopt-A-Highway
Double
8
3.9072
177119.492
meters
Positive real numbers that are automatically generated.
8
0
0
Status_Pub
Status
Published Adopt-A-Highway status class shown on the map (aliased 'Status'): Adopted, Available Pending Site Review, Vacant, or Not Adoptable. Derived by the pipeline's reclassification step from the source adoption status; a source status of 'Vacant (NSR)' is promoted to 'Available Pending Site Review'.
Adopt-A-Highway
String
39
Status_Pub values
Adopt-A-Highway
39
0
0
LocationType
Location Type
Facility classification of the site (e.g., Freeway Section, Conventional Highway Section, Vista Point, Turnout, Park & Ride, Interchange). Determines whether a site is represented as a highway segment (AAH_all_Highway) or an 'other location' point (AAH_all_other_loc).
Adopt-A-Highway
String
38
LocationType values
Adopt-A-Highway
38
0
0
District
District
Caltrans district responsible for the site, 01 through 12. Stored as text.
Adopt-A-Highway
String
20
District values
Adopt-A-Highway
20
0
0
County1
County
Caltrans county code for the site (aliased 'County'), carried from the source join query's begin-postmile county.
Adopt-A-Highway
String
20
Free text
20
0
0
ROUTE
Route
State highway route number on which the site is located (e.g., 5, 101, 605).
Adopt-A-Highway
Integer
4
1
980
4
0
0
BeginPM
Begin Postmile
Beginning postmile of the site (aliased 'Begin Postmile'), in miles measured from the county line along the route.
Adopt-A-Highway
Double
8
Free text
8
0
0
EndPM
End Postmile
Ending postmile of the site (aliased 'End Postmile'), in miles measured from the county line along the route. For single-postmile 'other location' sites this equals or nearly equals BeginPM.
Adopt-A-Highway
Double
8
Free text
8
0
0
AAH_Region
Maint Region
Caltrans maintenance region grouping for the site (aliased 'Maint Region'), e.g., NW, SE.
Adopt-A-Highway
String
20
AAH_Region values
Adopt-A-Highway
20
0
0
pm_span_mi
Total Postmile
Length of the site in postmiles (EndPM minus BeginPM), in miles (aliased 'Total Postmile'). Sites with real length appear in AAH_all_Highway; single-postmile sites (span at or near zero) appear in AAH_all_other_loc.
Adopt-A-Highway
Double
8
0.004
93.2
miles
8
0
0
Direction
Direction
Travel direction of the site (NB, SB, EB, WB). Each direction on a divided highway is placed as a separate feature on its own alignment.
Adopt-A-Highway
String
20
Direction values
Adopt-A-Highway
20
0
0
strCity
City
City or community nearest the site (aliased 'City').
Adopt-A-Highway
String
40
Free text
40
0
0
strBegPMDescr
Begin PM Description
Landmark description of the beginning postmile (aliased 'Begin PM Description'), e.g., a cross street, ramp, or bridge.
Adopt-A-Highway
String
70
Free text
70
0
0
strEndPMDescr
End PM Description
Landmark description of the ending postmile (aliased 'End PM Description').
Adopt-A-Highway
String
70
Free text
70
0
0
id_AHH_Join
id_AHH_Join
Composite site key combining site id, travel direction, and route (e.g., '111NB001'); links the feature back to the source Adopt-A-Highway records.
Adopt-A-Highway
String
20
Free text
20
0
0
AAH_all_Highway
Shape_Length
System-managed length of the polyline geometry, in the linear unit of the feature class spatial reference, automatically calculated and maintained by ArcGIS. Present in AAH_all_Highway only.
Adopt-A-Highway
FLOAT
Min: 3.9072; Max: 177119.492
Status_Pub
Published Adopt-A-Highway status class shown on the map (aliased 'Status'): Adopted, Available Pending Site Review, Vacant, or Not Adoptable. Derived by the pipeline's reclassification step from the source adoption status; a source status of 'Vacant (NSR)' is promoted to 'Available Pending Site Review'.
Adopt-A-Highway
STRING
Not Adoptable
Adopted
Available Pending Site Review
Vacant
LocationType
Facility classification of the site (e.g., Freeway Section, Conventional Highway Section, Vista Point, Turnout, Park & Ride, Interchange). Determines whether a site is represented as a highway segment (AAH_all_Highway) or an 'other location' point (AAH_all_other_loc).
Adopt-A-Highway
STRING
Conventional Highway Section
Freeway Section
Interchange/Ramps Only
Vista Points/Turnouts Only
Park and Ride
Other
City Street
Bike Path
Expressway
Interchange/TurnoutsOnly
District
Caltrans district responsible for the site, 01 through 12. Stored as text.
Adopt-A-Highway
STRING
D08
D06
D04
D11
D03
D02
D10
D07
D05
D09
D01
D12
County1
Caltrans county code for the site (aliased 'County'), carried from the source join query's begin-postmile county.
Adopt-A-Highway
STRING
Free text
ROUTE
State highway route number on which the site is located (e.g., 5, 101, 605).
Adopt-A-Highway
INTEGER
Min: 1.0; Max: 980.0
BeginPM
Beginning postmile of the site (aliased 'Begin Postmile'), in miles measured from the county line along the route.
Adopt-A-Highway
FLOAT
Free text
EndPM
Ending postmile of the site (aliased 'End Postmile'), in miles measured from the county line along the route. For single-postmile 'other location' sites this equals or nearly equals BeginPM.
Adopt-A-Highway
FLOAT
Free text
AAH_Region
Caltrans maintenance region grouping for the site (aliased 'Maint Region'), e.g., NW, SE.
Adopt-A-Highway
STRING
NW
pm_span_mi
Length of the site in postmiles (EndPM minus BeginPM), in miles (aliased 'Total Postmile'). Sites with real length appear in AAH_all_Highway; single-postmile sites (span at or near zero) appear in AAH_all_other_loc.
Adopt-A-Highway
FLOAT
Min: 0.004; Max: 93.2
Direction
Travel direction of the site (NB, SB, EB, WB). Each direction on a divided highway is placed as a separate feature on its own alignment.
Adopt-A-Highway
STRING
NB
SB
EB
WB
NAN
strCity
City or community nearest the site (aliased 'City').
Adopt-A-Highway
STRING
Free text
strBegPMDescr
Landmark description of the beginning postmile (aliased 'Begin PM Description'), e.g., a cross street, ramp, or bridge.
Adopt-A-Highway
STRING
Free text
strEndPMDescr
Landmark description of the ending postmile (aliased 'End PM Description').
Adopt-A-Highway
STRING
Free text
id_AHH_Join
Composite site key combining site id, travel direction, and route (e.g., '111NB001'); links the feature back to the source Adopt-A-Highway records.
Adopt-A-Highway
STRING
Free text
20260911
93d5c7fe-b05a-4eee-8d13-71898e4c2aa2
State Wide Program Manager
Caltrans
HQ
007
AAH.HQ@dot.ca.gov
dataset
District GIS join query exports (D##_qry_GIS_Join_EN1 and _WS1 Excel files) for all 12 districts are ingested into pandas and merged. Personally identifiable applicant contact fields (GroupContactLast, GroupContactFirst, GroupContactEmail) are dropped, along with internal source fields not needed for public display, leaving the curated published schema. Null status values are filled before status derivation to prevent blank rows from being misclassified. Line geometry is built by linear referencing each row's begin and end postmiles along SHN_lines via the Caltrans LRS measureToGeometry REST operation; a cross-county fallback handles realignment sequences whose postmiles run continuously across county lines. Each travel direction is placed on its own alignment. A reclassification step derives the public status class (Status_Pub) from the source adoption status field, promoting 'Vacant (NSR)' to 'Available Pending Site Review'. Per-district review CSVs (placed rows, unplaced rows with reason codes, and location-type QC) are written for quality control. The feature class is created on first run and truncated-and-reloaded on subsequent runs.
File Geodatabase Feature Class
10.0
dataset
EPSG
6.18.3(9.3.1.2)
15360
Simple
FALSE
15360
TRUE
FALSE