elevators
Synced from hadley/elevators
A real-world data-dict.yaml, synced from hadley/elevators. Download the raw file.
elevators.yaml
# source: https://github.com/hadley/elevators
version: 0.1.0
tables:
elevators:
description: >
Registered elevator devices in New York City, as provided by the NYC
Department of Buildings in response to a September 2015 FOIL request.
The data was received in November 2015 and covers ~76k devices.
Includes elevators, escalators, dumbwaiters, and other vertical
transportation devices.
source:
parquet: elevators.parquet
columns:
- name: dv_device_number
type: string
constraints: [primary_key]
description: >
Unique device number assigned by the NYC Department of Buildings.
Can be used to look up a device on the DOB
[Building Information Search](http://a810-bisweb.nyc.gov/bisweb/bispi00.jsp)
(Field 26).
examples: [1D1, 1P26114, 1P47998, 3P14044, 5T722]
- name: device_status
type: enum
values: {A: active, D: dismantled, H: NYCHA, J: no jurisdiction, W: work in progress}
constraints: [required]
description: >
Single-letter code for the device's registration status.
- name: bin
type: number(id)
description: >
Building Identification Number, a unique identifier assigned by
the NYC Department of Buildings to each building. More reliable
than street address for geolocation.
examples: [1000003, 1044931, 2018006, 3329429, 5863656]
- name: tax_block
type: number(id)
description: >
Tax block number within the borough, part of the BBL.
examples: [1, 1726, 3627, 6356, 16350]
- name: tax_lot
type: string
description: >
Tax lot number within the block, part of the BBL. Stored as a
string because some lots have letter suffixes (e.g. `7501T`).
examples: ["1", "276", "483", "992", "7501T"]
- name: house_number
type: string
description: >
Street number portion of the filed at address.
examples: ["1", "55", "200", "521", "72-20"]
- name: street_name
type: string
description: >
Street name portion of the filed at address.
examples: [BROADWAY, EAST 28 ST, FOOD CENTER DRIVE, HOWARD AVE, SEVENTH AVENUE]
- name: zip_code
type: string
description: >
Five-digit ZIP code for the filed at address.
examples: ["10001", "10302", "11109", "11362", "99999"]
- name: borough
type: enum
values: [Bronx, Brooklyn, Manhattan, Queens, Staten Island]
description: >
NYC borough where the device is located. A small number of rows
have this field blank.
- name: device_type
type: enum
values:
- Passenger Elevator (P)
- Freight (F)
- Escalator (E)
- Dumbwaiter (D)
- Sidewalk (S)
- Private Elevator (T)
- Handicap Lift (H)
- Manlift (M)
- Public Elevator (L)
description: >
Type of elevator device.
- name: dv_lastper_insp_date
type: date
range: [1988-08-19, 2015-10-13]
description: >
Date of the last periodic inspection by the NYC Department of
Buildings. May be missing if the device has never been inspected.
Because the data is from late 2015, these dates may no longer be
current.
- name: dv_lastper_insp_disp
type: enum
values: {DF: deficiency found, NV: no violation, PI: partial inspection, VF: violation filed}
description: >
Disposition code from the last periodic inspection.
Missing if no inspection on record.
- name: dv_approval_date
type: date
range: [1925-02-24, 2015-10-16]
description: >
Date the device was approved. Typically reflects when the device
was first registered or last had a major approval action.
- name: dv_manufacturer
type: string
description: >
Name of the device manufacturer as entered by the filer.
Free-text with many inconsistencies (e.g. `OTIS` and
`OTIS ELEV CO` are the same company). Over 2,000 unique values.
Some entries like `HOUSING AUTHORITY` or `PRIVATE RESIDENCE` describe
ownership rather than manufacturer.
examples: [OTIS, HOUSING AUTHORITY, PRIVATE RESIDENCE, MRL ELEVATOR, STALEY]
- name: dv_travel_distance
type: number(quantity)
range: [0, 1300]
description: >
Vertical travel distance of the device in feet. Often omitted
(~62% missing). Parsed from highly inconsistent raw strings.
See travel-distance.qmd for details.
- name: dv_speed_fpm
type: number(quantity)
range: [0, 1800]
description: >
Speed of the device in feet per minute. Common values include
50, 100, 200, 350. Converted from string by extracting leading
numeric values (e.g. `95UP` -> 95). 16 unparseable entries
(e.g. `----`, `VAR`, `EX`) were set to missing.
- name: dv_capacity_lbs
type: number(quantity)
range: [0, 20000]
description: >
Weight capacity of the device in pounds. Common values include
2500, 3000, 3500 for passenger elevators. Converted from string
by fixing `O`/`o` -> `0`, removing commas, and extracting leading
numeric values. 6 unparseable entries (e.g. `ESC`, `NIUD`) were
set to missing.
- name: dv_car_buffer_type
type: enum
values: {S: spring, O: oil}
description: >
Type of car buffer. Often missing, particularly for non-elevator
devices.
- name: dv_governor_type
type: enum
values: {C: centrifugal, F: fly-ball, N: none}
description: >
Type of speed governor. Often missing for non-elevator devices.
- name: dv_machine_type
type: enum
values: {OG: overhead geared, GL: gearless, OH: overhead, BG: basement geared, BD: basement drum, O: other, T: traction}
description: >
Type of hoisting machine. Missing for some devices.
- name: dv_safety_type
type: enum
values: {I: instantaneous, F: flexible guide clamp, G: governor-operated}
description: >
Type of safety device. Missing for roughly half of all devices.
- name: dv_mode_operation
type: enum
values: {A: automatic, P: push button, E: escalator, C: car-switch, D: dumbwaiter, S: signal control, H: handicap}
description: >
Mode of operation. Missing for some devices.
- name: dv_status_date
type: date
range: [1940-07-18, 2015-10-17]
description: >
Date when the device status was last updated.
- name: dv_floor_from
type: string
description: >
Lowest floor served by the device. May be an integer (`1`), a
standard letter code (`B` basement, `C` cellar, `L` lobby,
`G` ground, `M` mezzanine, `SB` sub-basement, `SC`
sub-cellar), or a comma-separated pair indicating two lobby
entry levels (e.g. `B,1`). See floor.qmd for details.
examples: [B, "1", C, SB, "B,1"]
- name: dv_floor_to
type: string
description: >
Highest floor served by the device. Uses the same notation as
`dv_floor_from`. Common letter codes include `PH` (penthouse),
`R` (roof), `T` (top), and `ST` (street). Subject to the same
cleaning as `dv_floor_from`.
examples: ["6", "12", PH, R, ST]
- name: latitude
type: number(quantity)
range: [40.5, 40.9]
description: >
Approximate latitude of the device's building, obtained by
geocoding the BIN, Borough-Block-Lot, or street address via
the NYC Geoclient API. Not authoritative; some values may be
in error.
- name: longitude
type: number(quantity)
range: [-74.3, -73.7]
description: >
Approximate longitude of the device's building, obtained by
geocoding. Not authoritative; some values may be in error.
glossary:
BIN: >
Building Identification Number. A unique numeric identifier assigned
to each building by the NYC Department of Buildings.
BBL: >
Borough-Block-Lot. A three-part identifier (borough code, tax block,
tax lot) used by NYC to uniquely identify a parcel of land for
property tax purposes.
DOB: >
New York City Department of Buildings. The agency responsible for
ensuring the safe and lawful use of buildings and properties.
NYCHA: >
New York City Housing Authority. The public housing authority for NYC,
which manages its own elevator inspection program.
periodic inspection: >
A required inspection of elevator devices conducted by the NYC
Department of Buildings on a regular cycle (typically annual or
biennial depending on device type).
manlift: >
A continuous-loop conveyor with platforms or steps used to transport
people between floors. Largely obsolete and rarely installed new.
sidewalk elevator: >
A freight elevator that opens at sidewalk level, used to move goods
between the sidewalk and a building's basement or cellar.
gearless traction: >
An elevator machine type where the motor directly drives the sheave
without a gearbox. Used in high-rise buildings for high speeds and
smooth operation.
governor: >
A speed-limiting safety device on an elevator. If the car exceeds a
set speed, the governor triggers the safety mechanism to stop the car.
filed at: >
The address where the elevator application or paperwork was filed with
the Department of Buildings. This may differ from the actual physical
location of the device. The BIN or Borough-Block-Lot is generally
more reliable for geolocation.
car buffer: >
A shock-absorbing device at the bottom of the elevator shaft that
cushions the car in the event of an overrun. Spring buffers are used
for lower speeds; oil buffers for higher speeds.