this dataset is an inventory of existing pull boxes on Hawaii Highways. Information includes location, condition of the pull box, if the pull box is missing or cracked and whether the pull box is on NHS. https://highways.hidot.hawaii.gov/dataset/Pull-Boxes/2ezm-8jbq
This dataset has the following 29 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| OBJECTID | objectid | number | ArcGIS object key | 204 568 805 599 789 view top 100 |
| ASSET_ID | asset_id | text | Unique Asset Identifier generated by Mandli | -L_7p7u5FwHjykFwgzsdA- -L_8ago4GX5kQ2WaoM-vzk -L_8agSVHT1XuVmBQNLRNF -L_8ahuxG5aYWGsyKWmd_F -L_8ao4pGWaLS0q6HxRUbk view top 100 |
| COMMENTS | comments | text | Rater comment on feature condition | view top 100 |
| PREFIX | prefix | text | The route owner. SR is a state route, CR is a county route. | CR SR RMP IMC SRV view top 100 |
| ROUTE | route | text | The route number | 11 198 186 30 19 view top 100 |
| SESSION_NM | session_nm | text | Mandli naming convention | Hawaii_CR_198_CTR_+_2019 Hawaii_SR_11_CTR_+_2019 Hawaii_CR_186_CTR_-_2019 Maui_SR_30_CTR_+_2019 Hawaii_CR_186_CTR_+_2019 view top 100 |
| ISLAND | island | text | The island name | Hawaii Oahu Maui Kauai view top 100 |
| LANE_ID | lane_id | text | The lane that is traveled. | CTR WB EB NB view top 100 |
| DIRECTION | direction | text | Route direction | +MP -MP view top 100 |
| SURVEYED | surveyed | text | Collection Date | 04-MAR-2019 12-MAR-2019 22-MAR-2019 19-MAR-2019 15-MAR-2019 view top 100 |
| SOURCE | source | text | Collection cycle | MS2019 view top 100 |
| DELIVERYID | deliveryid | text | The data delivery date as a string | MARCH_2020_1 view top 100 |
| LRM_NAME | lrm_name | text | Linear Reference System Name (always CDS) | CDS view top 100 |
| NHS | nhs | text | Whether route is on the National Highway System | NO YES view top 100 |
| PFES_ID | pfes_id | text | PFES link identification | NA Maui_30_+MP_6.82 Hawaii_11_+MP_109.21 Oahu_H-1_+MP_0.096 Hawaii_11_+MP_117.13 view top 100 |
| FRAME | frame | number | Frame of asset | 2878 103 4690 168 79 view top 100 |
| the_geom | the_geom | point | Geometry Data | {"coordinates":[-157.790925042774,21.413299868935],"type":"Point"} {"coordinates":[-157.88502207337,21.327425919203],"type":"Point"} {"coordinates":[-155.316325064095,20.015869049421],"type":"Point"} {"coordinates":[-155.93730404028,19.515770315642],"type":"Point"} {"coordinates":[-156.563287908137,20.791158182856],"type":"Point"} view top 100 |
| GHOSTED | ghosted | text | Copied from previous year observation or brand new observation | NO YES view top 100 |
| E_ELE | e_ele | number | 65.1999969482422 461.100006103516 57 72.1999969482422 65.3000030517578 view top 100 | |
| E_LAT | e_lat | number | 19.2016691 19.20167033 19.2019444 19.20198461 19.20199769 view top 100 | |
| B_ELE | b_ele | number | 65.1999969482422 461.100006103516 57 72.1999969482422 65.3000030517578 view top 100 | |
| MISSING | missing | text | NO YES view top 100 | |
| EMP | emp | number | 0 0.47367 0.20841 9.29506 1.40454 view top 100 | |
| E_LON | e_lon | number | -159.71454979 -159.66708327 -159.66693856 -159.59075536 -159.58813689 view top 100 | |
| B_LON | b_lon | number | -159.35134445 -155.97899173 -158.01827153 -156.4522041 -155.98874054 view top 100 | |
| BMP | bmp | number | 0 0.20841 0.47367 6.14127 9.29506 view top 100 | |
| B_LAT | b_lat | number | 21.3972705 19.62062083 19.49877472 21.40273694 19.62039444 view top 100 | |
| CONDITION | condition | text | Good Poor view top 100 | |
| CRACKED | cracked | text | NO YES view top 100 |