Skip to content

Weird BINs #46

@olivermesh

Description

@olivermesh

SELECT COUNT(*) FROM ny WHERE bldg_bin = '1000000' returns 335
SELECT COUNT(*) FROM ny WHERE bldg_bin = '2000000' returns 2490
SELECT COUNT(*) FROM ny WHERE bldg_bin = '3000000' returns 4620
SELECT COUNT(*) FROM ny WHERE bldg_bin = '4000000' returns 19874
SELECT COUNT(*) FROM ny WHERE bldg_bin = '5000000' returns 3591

Any idea what's going on here? Is the source data invalid?

Metadata

Metadata

Assignees

No one assigned

    Labels

    invalidThis doesn't seem right

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions