From a 500-row sample across 22 columns.
order_numberboroughsign_x_coord+22boroughto_streeton_street+2Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| order_number | record_type | order_type | borough | on_street | from_street | to_street | side_of_street | order_completed_on_date | sign_code | sign_description | sign_size |
|---|---|---|---|---|---|---|---|---|---|---|---|
| P-01667780 | Current | P- | Manhattan | 3 AVENUE | EAST 85 STREET | EAST 86 STREET | W | 2023-09-13T00:00:00.000 | PS-127C | 2 HMP SATURDAY 8AM-7PM <-> | 018 X 018 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
order_number | text | Sign, Parking, Regulation, SIMS, STATUS, Location, Street | 0% | P-01737591S-01781429S-01780823 |
record_type | text | The totality of signs associated with "Current" sign orders represents the current asset inventory. Repair (R-) orders are always historical. | 0% | Currentof 1 |
order_type | categorical | Order type, represents both regulatory category and geometry. | 0% | S-P-of 2 |
borough | categorical | Lists which of the five administrative divisions of New York City the work order is located in, written as a word. | 0% | Brooklyn |
GET /api/datasets/nfid-uabd GET /api/datasets/nfid-uabd/quality GET /api/datasets/nfid-uabd/related GET /api/columns?dataset=nfid-uabd
borough| S-01665760 |
| Current |
| S- |
| Bronx |
| EAST 217 STREET |
| WHITE PLAINS ROAD |
| BARNES AVENUE |
| N |
| 2023-09-13T00:00:00.000 |
| PS-191EA |
| TRUCK (SYMBOL) TRUCK LOADING ONLY MONDAY-FRIDAY 8AM-6PM --> (SUPERSEDES SP-449CA & SP-70BA) |
| 018 X 018 |
| P-01667780 | Current | P- | Manhattan | 3 AVENUE | EAST 85 STREET | EAST 86 STREET | W | 2023-09-13T00:00:00.000 | PS-528C | 1 HMP COMMERCIAL VEHICLES ONLY MONDAY-FRIDAY 8AM-7PM <-> | 018 X 024 |
| S-01386969 | Current | S- | Bronx | GERARD AVENUE | MCCLELLAN STREET | EAST 167 STREET | W | 2019-09-04T00:00:00.000 | SI-2091G | NEIGHBORHOOD LOADING ZONE RULES SIGN | 09.5 X 014 |
| S-01367526 | Current | S- | Manhattan | 3 AVENUE | EAST 109 STREET | EAST 110 STREET | E | 2019-05-14T00:00:00.000 | SI-584G | 14 STREET & UNION SQ (BOTTOM LOCATION PANEL)(USE AS EXAMPLE FOR DIFFERENT LOCATION) | 016 X 008 |
| S-01668596 | Current | S- | Bronx | MORRIS AVENUE | EAST 182 STREET | EAST 183 STREET | W | 2023-09-13T00:00:00.000 | PS-113B | NO PARKING (SANITATION BROOM SYMBOL) MONDAY THURSDAY 9AM-10:30AM <-> (SUPERSEDES SP-413C) | 018 X 012 |
| S-01665760 | Current | S- | Bronx | EAST 217 STREET | WHITE PLAINS ROAD | BARNES AVENUE | N | 2023-09-13T00:00:00.000 | PS-32BA | NO PARKING (SANITATION BROOM SYMBOL) MONDAY 9:30AM-11AM --> (SUPERSEDES SP-453CA) | 018 X 012 |
| P-01696468 | Current | P- | Manhattan | MADISON AVENUE | EAST 37 STREET | EAST 38 STREET | W | 2024-02-28T00:00:00.000 | PS-367C | 5 HMP 7PM-MIDNIGHT EXCEPT SUNDAY <-> | 018 X 018 |
| S-01367529 | Current | S- | Manhattan | 3 AVENUE | EAST 112 STREET | EAST 115 STREET | E | 2019-04-10T00:00:00.000 | SI-1913G | NIGHT SERVICE ONLY DESTINATION PANEL (TEXT TO BE MODIFIED AS REQUESTED) | 18.12 X 6 |
| S-01668902 | Current | S- | Brooklyn | STERLING STREET | WASHINGTON AVENUE | BEDFORD AVENUE | S | 2023-09-13T00:00:00.000 | PS-12B | NO PARKING (SANITATION BROOM SYMBOL) TUESDAY FRIDAY 8:30AM-10AM <-> (SUPERSEDES SP-846C) | 018 X 012 |
Showing 12 of 20 columns. All of them are listed below.
QueensManhattanon_street | text | For block front and stretch geometries, where the street the signs are on; for an intersection geometry, the major intersecting street. | 0% | BROADWAY3 AVENUE5 AVENUE |
on_street_suffix | text | Used in cases where an additional field is needed to create a unique location, such as when two streets intersect twice, and/or where there is an additional roadbed. | 97% | N S/RW RDWYE RDWY |
from_street | text | For block front and stretch geometries, the street that intersects at the beginning of the block; for an intersection geometry, the minor intersecting street. | 0% | BROADWAYDEAD END3 AVENUE |
from_street_suffix | text | Used in cases where an additional field is needed to create a unique location, such as when two streets intersect twice, and/or where there is an additional roadbed. | 99% | NSS S/R |
to_street | text | For block front and stretch geometries, the street that intersects at the end of the block; not applicable (null) for an intersection geometry. | 0% | DEAD ENDBROADWAY3 AVENUE |
to_street_suffix | text | Used in cases where an additional field is needed to create a unique location, such as when two streets intersect twice, and/or where there is an additional roadbed. | 99% | ENT RAMPS S/RS |
side_of_street | categorical | For block front and stretch geometries, the side of street, as all block front and stretch orders are written for only one side of a street. | 0% | EWSof 4 |
order_completed_on_date | datetime | The date the order was closed. | 0% | 1972-07-10T00:00:00.0002024-01-30T00:00:00.0002026-07-01T00:00:00.000 |
sign_code | text | A unique identifier for a sign design. (Note, the sign code identifies the sign design, not an instance of a sign on the street that uses that design.) | 0% | PS-1GAPS-1GPS-9A |
sign_description | text | Includes description of regulation and superseding/superseded sign design if any. | 0% | NO STANDING ANYTIME --> …NO STANDING ANYTIME <-> …PAY-BY-CELL LOCATOR NUMB… |
sign_size | text | Dimensions of sign, height by width. | 0% | 018 X 012018 X 018018 X 006 |
sign_design_voided_on_date | datetime | Date the system started blocking the use of a defunct sign design. | 99% | 2017-06-02T00:00:00.0002019-05-22T00:00:00.0002025-11-07T00:00:00.000 |
sign_location | text | Applicable only to intersection geometry orders and null for all others, an acronym that indicates the placement of a sign within an intersection. | 100% | — |
distance_from_intersection | integer | All block front signs have a distance, which is relative to the curb line; intersection signs will have a distance only if the sign is physically located outside the intersection. | 0% | 9040100 |
arrow_direction | categorical | "The direction that an arrow on a sign points. For a block front sign, this is relative to the ""side of street"" direction. For an intersection sign, it is relative to the street that is assumed north. Arrow direction is generally applicable only to block front signs, with one significant exception--""One Way"" intersection signs always have an arrow direction. Only block front signs with a single arrow will have an arrow direction, signs with no arrow or a double arrow will not." | 76% | WestEastSouthof 4 |
facing_direction | categorical | "The general rule is that all intersection signs have a facing direction, with the exception of ""One Way"" signs, which only have an ""arrow points"" direction. There are a few other minor exceptions. The direction that a sign faces is relative to the ""Street Assumed North/South"". Block front signs should never have a facing direction, with a few very minor exceptions." | 100% | SouthNorthWestof 6 |
sheeting_type | categorical | The surface material used for a sign; the current standard is TIII for an intersection sign and "Painted" (PNTD) for a block front sign. | 0% | PNTDTIIIENGGof 5 |
support | text | An acronym that represents the type of structure support the signs. | 0% | DRSAMELP |
sign_notes | text | Notes that provide regulatory information about a particular sign sequence, such as a Bus Stop ID, name or destination, or something unusual about the location or installation of the sign. | 73% | DAYLIGHTINGDROP OFF ONLYJAMAICA |
sign_x_coord | integer | The longitude of the sign location | 8% | 100382310081421027448 |
sign_y_coord | integer | The latitude of the sign location | 8% | 229840244805241127 |