Spatial SQL: Code Reference

7.9 Validators

7.33

select
    *
from
    nyc_building_footprints
where
    st_isvalid(geom) is false

7.34

select
    mpluto_bbl,
    st_isvaliddetail(geom)
from
    nyc_building_footprints
where
    mpluto_bbl in ('1022430261', '1016710039', '4039760001')

7.35

select
    mpluto_bbl,
    st_isvalidreason(geom)
from
    nyc_building_footprints
where
    mpluto_bbl in ('1022430261', '1016710039', '4039760001')

7.36

select
    mpluto_bbl,
    st_isvalid(st_makevalid(geom))
from
    nyc_building_footprints
where
    mpluto_bbl in ('1022430261', '1016710039', '4039760001')

7.37

select
    st_srid(geom)
from
    nyc_building_footprints
limit
    3

7.38

select
    ogc_fid,
    st_transform(geom, 2263) as geom
from
    nyc_building_footprints
limit
    3