New York City Street Sign Installation Work Orders

Approximately 1,000,000 signs are managed by the Department of Transportation on New York City streets. This dataset contains completed sign installations for current and historical signs, including regulatory, warning, guide, and parking signs. The data is provided by data.cityofnewyork.us and was last updated in April 2026.

Use Cases

• Analyze installation patterns by `borough` and `side_of_street` to optimize maintenance crew routing.
• Model the relationship between `sign_description`, `sign_size`, and `order_completed_on_date` to forecast replacement cycles.
• Use `sign_x_coord` and `sign_y_coord` to create a geospatial map of sign density and types across the city.
• Identify trends in `order_type` and `record_type` to assess the volume of new installations versus repairs over time.
• Correlate `sign_code` with `facing_direction` and `arrow_direction` for traffic flow and safety analysis.

Strengths

• Covers a large inventory of approximately 1,000,000 street signs.
• Includes 25 detailed columns per record, such as location coordinates and sign specifications.
• Data is actively maintained, with a last update date in 2026.

Limitations

• Unknown total row count prevents assessment of dataset completeness relative to the stated 1,000,000-sign inventory.
• Geographic coverage is limited solely to New York City, limiting generalizability.
• Sample data is unavailable, preventing verification of data format and quality.

Provenance

Source

data.cityofnewyork.us

Collection Method

Operational records from the Department of Transportation's sign management system.

Time Range

Current and historical records; specific range unknown.

Freshness

Last updated April 2026.

Geography

New York City, USA.