CAGIS data (see install_cagis_data()
) provides a list of all addresses in Hamilton County.
Addresses are filtered for the following criteria:
use only addresses that have
STATUS
ofASSIGNED
orUSING
and are not orphaned (ORPHANFLG == "N"
)omit addresses with
ADDRTYPE
s that are milemarkers (MM
), parks (PAR
), infrastructure projects (PRJ
), cell towers (CTW
), vacant or commercial lots (LOT
), and other miscellaneous non-residential addresses (MIS
,RR
,TBA
)s2 cell is derived from LONGITUDE and LATITUDE fields in CAGIS address database
Value
a simple features object with columns cagis_address
, cagis_address_place
, cagis_address_type
,
cagis_s2
, cagis_parcel_id
, cagis_is_condo
, and a geometry column (s2_geography
)
Examples
cincy_addr_geo()
#> Reading layer `Addresses' from data source
#> `/Users/cole/Library/Application Support/org.R-project.R/R/codec/CAGISOpenDataQ1_2025.gdb'
#> using driver `OpenFileGDB'
#> Simple feature collection with 366792 features and 74 fields
#> Geometry type: POINT
#> Dimension: XY
#> Bounding box: xmin: 1310580 ymin: 378883.3 xmax: 1517634 ymax: 526672.6
#> Projected CRS: NAD83 / Ohio South (ftUS)
#> Simple feature collection with 322403 features and 6 fields (with 1277 geometries empty)
#> Geometry type: POINT
#> Dimension: XY
#> Bounding box: xmin: -84.82008 ymin: 39.02659 xmax: -84.25908 ymax: 39.31411
#> Geodetic CRS: WGS 84 (CRS84)
#> # A tibble: 322,403 × 7
#> cagis_address cagis_address_place cagis_address_type cagis_s2 cagis_parcel_id
#> <chr> <chr> <chr> <s2cell> <chr>
#> 1 9483 ZOLA CT… NA BLD 8840321… 056100270082
#> 2 208 MOHAWK S… NA BLD 8841b3f… 009500020062
#> 3 11800 READIN… U-HAUL - 11800 REA… BLD 8840519… 060800280003
#> 4 12050 PRINCE… STAPLES SRPINGDALE BLD 88404e4… 059900100003
#> 5 6610 PFEIFFE… NA INF 884053e… 060300140062
#> 6 6501 PFEIFFE… NA INF 884053e… 061201400358
#> 7 4244 ROUND B… NA INF 8841ab0… 050001700036
#> 8 8210 MARKET … NA BLD 8840547… 060300080279
#> 9 8212 MARKET … NA BLD 8840547… 060300080279
#> 10 9857 MONTGOM… NA BLD 8840547… 060300080300
#> # ℹ 322,393 more rows
#> # ℹ 2 more variables: cagis_is_condo <lgl>, s2_geography <POINT [°]>