DTS/DFM Sign Inventory - Fort St. to River St. as of: 2014-08-07

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.honolulu.gov
Id 8hqv-tn8i
Name DTS/DFM Sign Inventory - Fort St. to River St. as of: 2014-08-07
Category Transportation
Created 2015-05-15T21:30:51Z
Publication Date 2015-05-15T21:44:53Z

Columns

| Included | Schema Type    | Field Name | Name       | Data Type     | Render Type   |
| ======== | ============== | ========== | ========== | ============= | ============= |
| Yes      | series tag     | point_id   | POINT_ID   | text          | number        |
| Yes      | series tag     | pole_type  | POLE_TYPE  | text          | text          |
| Yes      | numeric metric | numplates  | NUMPLATES  | number        | number        |
| Yes      | series tag     | signmsg1   | SIGNMSG1   | text          | text          |
| Yes      | series tag     | signmsg2   | SIGNMSG2   | text          | text          |
| Yes      | series tag     | signmsg3   | SIGNMSG3   | text          | text          |
| Yes      | series tag     | signmsg4   | SIGNMSG4   | text          | text          |
| Yes      | series tag     | signmsg5   | SIGNMSG5   | text          | text          |
| Yes      | series tag     | signmsg6   | SIGNMSG6   | text          | text          |
| Yes      | numeric metric | offset     | OFFSET     | number        | number        |
| Yes      | series tag     | pic        | PIC        | text          | text          |
| Yes      | time           | dateinven  | DATEINVEN  | calendar_date | calendar_date |
| Yes      | series tag     | material1  | MATERIAL1  | text          | text          |
| Yes      | series tag     | material2  | MATERIAL2  | text          | text          |
| Yes      | series tag     | material3  | MATERIAL3  | text          | text          |
| Yes      | series tag     | material4  | MATERIAL4  | text          | text          |
| Yes      | series tag     | material5  | MATERIAL5  | text          | text          |
| Yes      | series tag     | material6  | MATERIAL6  | text          | text          |
| Yes      | series tag     | inventory  | INVENTORY  | text          | text          |
| No       |                | xcoord     | XCOORD     | number        | number        |
| No       |                | ycoord     | YCOORD     | number        | number        |
| Yes      | series tag     | daterepl1  | DATEREPL1  | text          | text          |
| Yes      | series tag     | daterepl2  | DATEREPL2  | text          | text          |
| Yes      | series tag     | daterepl3  | DATEREPL3  | text          | text          |
| Yes      | series tag     | daterepl4  | DATEREPL4  | text          | text          |
| Yes      | series tag     | daterepl5  | DATEREPL5  | text          | text          |
| Yes      | series tag     | daterepl6  | DATEREPL6  | text          | text          |
| Yes      | numeric metric | dateinstl1 | DATEINSTL1 | number        | number        |
| Yes      | numeric metric | dateinstl2 | DATEINSTL2 | number        | number        |
| Yes      | numeric metric | dateinstl3 | DATEINSTL3 | number        | number        |
| Yes      | numeric metric | dateinstl4 | DATEINSTL4 | number        | number        |
| Yes      | numeric metric | dateinstl5 | DATEINSTL5 | number        | number        |
| Yes      | numeric metric | dateinstl6 | DATEINSTL6 | number        | number        |
| Yes      | numeric metric | height_ft  | Height_ft  | number        | number        |
| Yes      | numeric metric | height_in  | Height_In  | number        | number        |
| Yes      | series tag     | pic2       | PIC2       | text          | text          |
| Yes      | series tag     | signclr1   | SIGNCLR1   | text          | text          |
| Yes      | series tag     | signclr2   | SIGNCLR2   | text          | text          |
| Yes      | series tag     | signclr3   | SIGNCLR3   | text          | text          |
| Yes      | series tag     | signclr4   | SIGNCLR4   | text          | text          |
| Yes      | series tag     | signclr5   | SIGNCLR5   | text          | text          |
| Yes      | series tag     | signclr6   | SIGNCLR6   | text          | text          |
| Yes      | numeric metric | horiz_gap  | Horiz_Gap  | number        | number        |
| Yes      | series tag     | comments   | Comments   | text          | text          |

Time Field

Value = dateinven
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = xcoord,ycoord

Data Commands

series e:8hqv-tn8i d:2011-12-15T00:00:00.000Z t:signclr1="Black on White" t:point_id=2 t:signmsg1="SPEED LIMIT [25] (R2-1)" t:pic=.\CCH_Signs\Images\2.jpg t:inventory=RTD_GPS t:pole_type="Traffic Signals w/Pedestrian Signals" m:height_ft=6 m:offset=0 m:horiz_gap=0 m:numplates=1 m:height_in=8

series e:8hqv-tn8i d:2011-12-15T00:00:00.000Z t:signclr1="Green on White" t:point_id=3 t:comments="GPS point visually adjusted to aerial image" t:signclr2="Red on White" t:signmsg2="TOW-AWAY ZONE [3:30 PM TO 5:30 PM EXCEPT SATURDAYS SUNDAYS AND STATE HOLIDAYS] (R9)" t:signmsg1="1 HR PARKING [7 AM TO 3:30 PM MON THRU FRI, 7 AM TO 6PM SATURDAYS EXCEPT SUNDAYS STATE HOLIDAYS] (R7-108)" t:pic=.\CCH_Signs\Images\3.jpg t:inventory=Adjusted t:pole_type="Street Light Standard" m:height_ft=7 m:offset=0 m:horiz_gap=0 m:numplates=2 m:height_in=2

series e:8hqv-tn8i d:2011-12-15T00:00:00.000Z t:signclr1="Red on White" t:point_id=4 t:material2="Diamond Grade" t:comments="GPS point visually adjusted to aerial image" t:signclr2="Red on White" t:signmsg2="TOW-AWAY ZONE [3:30 PM TO 5:30 PM EXCEPT SATURDAYS SUNDAYS AND STATE HOLIDAYS] (R9)" t:signmsg1="FREIGHT LOADING ZONE - [7:00 AM TO 3:30 PM MON THRU FRI, 7:00 AM TO 4:00 PM SATURDAYS EXCEPT SUNDAYS AND STATE HOLIDAYS] (R9)" t:pic=.\CCH_Signs\Images\4.jpg t:inventory=Adjusted t:pole_type=Round m:height_ft=7 m:offset=0 m:horiz_gap=0 m:numplates=2 m:dateinstl2=7012008 m:height_in=2.5

Meta Commands

metric m:numplates p:integer l:NUMPLATES t:dataTypeName=number

metric m:offset p:integer l:OFFSET t:dataTypeName=number

metric m:dateinstl1 p:integer l:DATEINSTL1 t:dataTypeName=number

metric m:dateinstl2 p:integer l:DATEINSTL2 t:dataTypeName=number

metric m:dateinstl3 p:integer l:DATEINSTL3 t:dataTypeName=number

metric m:dateinstl4 p:integer l:DATEINSTL4 t:dataTypeName=number

metric m:dateinstl5 p:integer l:DATEINSTL5 t:dataTypeName=number

metric m:dateinstl6 p:integer l:DATEINSTL6 t:dataTypeName=number

metric m:height_ft p:integer l:Height_ft t:dataTypeName=number

metric m:height_in p:float l:Height_In t:dataTypeName=number

metric m:horiz_gap p:integer l:Horiz_Gap t:dataTypeName=number

entity e:8hqv-tn8i l:"DTS/DFM Sign Inventory - Fort St. to River St.  as of: 2014-08-07" t:url=https://data.honolulu.gov/api/views/8hqv-tn8i

property e:8hqv-tn8i t:meta.view d:2017-09-25T07:24:56.160Z v:averageRating=0 v:name="DTS/DFM Sign Inventory - Fort St. to River St.  as of: 2014-08-07" v:id=8hqv-tn8i v:category=Transportation

property e:8hqv-tn8i t:meta.view.owner d:2017-09-25T07:24:56.160Z v:displayName="Karl Sueyoshi" v:id=b4zr-4dtj v:screenName="Karl Sueyoshi"

property e:8hqv-tn8i t:meta.view.tableauthor d:2017-09-25T07:24:56.160Z v:displayName="Karl Sueyoshi" v:roleName=publisher v:id=b4zr-4dtj v:screenName="Karl Sueyoshi"

Top Records

| point_id | pole_type                              | numplates | signmsg1                                                                                                                      | signmsg2                                                                            | signmsg3                    | signmsg4                   | signmsg5 | signmsg6 | offset | pic                         | dateinven           | material1 | material2     | material3 | material4 | material5 | material6 | inventory | xcoord         | ycoord         | daterepl1 | daterepl2 | daterepl3 | daterepl4 | daterepl5 | daterepl6 | dateinstl1 | dateinstl2 | dateinstl3 | dateinstl4 | dateinstl5 | dateinstl6 | height_ft | height_in      | pic2                         | signclr1       | signclr2       | signclr3      | signclr4      | signclr5 | signclr6 | horiz_gap | comments                                    | 
| ======== | ====================================== | ========= | ============================================================================================================================= | =================================================================================== | =========================== | ========================== | ======== | ======== | ====== | =========================== | =================== | ========= | ============= | ========= | ========= | ========= | ========= | ========= | ============== | ============== | ========= | ========= | ========= | ========= | ========= | ========= | ========== | ========== | ========== | ========== | ========== | ========== | ========= | ============== | ============================ | ============== | ============== | ============= | ============= | ======== | ======== | ========= | =========================================== | 
| 2        | Traffic Signals w/Pedestrian Signals   | 1         | SPEED LIMIT [25] (R2-1)                                                                                                       |                                                                                     |                             |                            |          |          | 0      | .\CCH_Signs\Images\2.jpg    | 2011-12-15T00:00:00 |           |               |           |           |           |           | RTD_GPS   | 21.30964784967 | 21.30964784967 |           |           |           |           |           |           |            |            |            |            |            |            | 6         | 8.00000000000  |                              | Black on White |                |               |               |          |          | 0         |                                             | 
| 3        | Street Light Standard                  | 2         | 1 HR PARKING [7 AM TO 3:30 PM MON THRU FRI, 7 AM TO 6PM SATURDAYS EXCEPT SUNDAYS STATE HOLIDAYS] (R7-108)                     | TOW-AWAY ZONE [3:30 PM TO 5:30 PM EXCEPT SATURDAYS SUNDAYS AND STATE HOLIDAYS] (R9) |                             |                            |          |          | 0      | .\CCH_Signs\Images\3.jpg    | 2011-12-15T00:00:00 |           |               |           |           |           |           | Adjusted  | 21.30973760583 | 21.30973760583 |           |           |           |           |           |           |            |            |            |            |            |            | 7         | 2.00000000000  |                              | Green on White | Red on White   |               |               |          |          | 0         | GPS point visually adjusted to aerial image | 
| 4        | Round                                  | 2         | FREIGHT LOADING ZONE - [7:00 AM TO 3:30 PM MON THRU FRI, 7:00 AM TO 4:00 PM SATURDAYS EXCEPT SUNDAYS AND STATE HOLIDAYS] (R9) | TOW-AWAY ZONE [3:30 PM TO 5:30 PM EXCEPT SATURDAYS SUNDAYS AND STATE HOLIDAYS] (R9) |                             |                            |          |          | 0      | .\CCH_Signs\Images\4.jpg    | 2011-12-15T00:00:00 |           | Diamond Grade |           |           |           |           | Adjusted  | 21.30981735468 | 21.30981735468 |           |           |           |           |           |           |            | 7012008    |            |            |            |            | 7         | 2.50000000000  |                              | Red on White   | Red on White   |               |               |          |          | 0         | GPS point visually adjusted to aerial image | 
| 5        | Pedestrian Signal                      | 1         | NO [RIGHT] TURN ON RED (R10-11a)                                                                                              |                                                                                     |                             |                            |          |          | 0      | .\CCH_Signs\Images\5.jpg    | 2011-12-15T00:00:00 |           |               |           |           |           |           | Adjusted  | 21.30987519016 | 21.30987519016 |           |           |           |           |           |           |            |            |            |            |            |            | 6         | 11.50000000000 |                              | Black on White |                |               |               |          |          | 0         | GPS point visually adjusted to aerial image | 
| 6        | Traffic Signals w/Pedestrian Signals   | 1         | ONE WAY - Left (R6-1L)                                                                                                        |                                                                                     |                             |                            |          |          | 0      | .\CCH_Signs\Images\6.jpg    | 2011-12-15T00:00:00 |           |               |           |           |           |           | Adjusted  | 21.30987737775 | 21.30987737775 |           |           |           |           |           |           |            |            |            |            |            |            | 6         | 11.50000000000 |                              | Black on White |                |               |               |          |          | 0         | GPS point visually adjusted to aerial image | 
| 7        | Street Light Standard                  | 1         | NO [RIGHT] TURN ON RED (R10-11a)                                                                                              |                                                                                     |                             |                            |          |          | 0      | .\CCH_Signs\Images\7.jpg    | 2011-12-15T00:00:00 |           |               |           |           |           |           | Adjusted  | 21.30996315379 | 21.30996315379 |           |           |           |           |           |           |            |            |            |            |            |            | 7         | 3.50000000000  |                              | Black on White |                |               |               |          |          | 0         | GPS point visually adjusted to aerial image | 
| 8        | Street Light Standard                  | 1         | SPEED LIMIT [25] (R2-1)                                                                                                       |                                                                                     |                             |                            |          |          | 0      | .\CCH_Signs\Images\8.jpg    | 2011-12-15T00:00:00 |           |               |           |           |           |           | Adjusted  | 21.31029235213 | 21.31029235213 |           |           |           |           |           |           |            |            |            |            |            |            | 6         | 7.00000000000  |                              | Black on White |                |               |               |          |          | 0         | GPS point visually adjusted to aerial image | 
| 9        | Round                                  | 1         | TOW-AWAY ZONE [6:30 AM TO 5:30 PM EXCEPT SATURDAYS SUNDAYS AND HOLIDAYS] (R9)                                                 |                                                                                     |                             |                            |          |          | 0      | .\CCH_Signs\Images\9.jpg    | 2011-12-15T00:00:00 |           |               |           |           |           |           | RTD_GPS   | 21.31035915124 | 21.31035915124 |           |           |           |           |           |           |            |            |            |            |            |            | 7         | 11.50000000000 |                              | Red on White   |                |               |               |          |          | 0         |                                             | 
| 10       | Street Light Standard w/Traffic Signal | 2         | ONE WAY - Right (R6-1R)                                                                                                       | ONE WAY - Left (R6-1L)                                                              |                             |                            |          |          | 0      | .\CCH_Signs\Images\10_1.jpg | 2011-12-15T00:00:00 |           |               |           |           |           |           | RTD_GPS   | 21.31047798788 | 21.31047798788 |           |           |           |           |           |           |            |            |            |            |            |            | 8         | 0.00000000000  | C:\CCH_Signs\Images\10_2.jpg | Black on White | Black on White |               |               |          |          | 0         |                                             | 
| 11       | Street Light Standard                  | 4         | [EXCEPT BIKES] plaque (R3 P)                                                                                                  | NO TURNS (R3-3)                                                                     | 6" [BETHEL ST 1100>] (D3-1) | 6" [S HOTEL ST 40>] (D3-1) |          |          | 0      | .\CCH_Signs\Images\11.jpg   | 2011-12-15T00:00:00 |           |               |           |           |           |           | RTD_GPS   | 21.31050390018 | 21.31050390018 |           |           |           |           |           |           |            |            |            |            |            |            | 7         | 1.50000000000  |                              | Black on White | Black on White | White on Blue | White on Blue |          |          | 0         |                                             |