Leaflet map of race restrictive covenants in property deeds in Connecticut, 1930s-40s
https://ontheline.github.io/otl-covenants/index-caption.html
- map.geojson -- spatial data joined with contents of table below, stored in this GitHub
- otl-covenants-table -- working copy of data in Google Sheet https://docs.google.com/spreadsheets/d/1yLGLmTzrkiaVJENkbWISFTSfH-Gm569UD-O206kPSFo/edit#gid=322703715, with backup XLSX in this GitHub repo
- table-ct-land-records-online -- working copy in Google Sheet https://docs.google.com/spreadsheets/d/1t6UFa-y7HmiulmLxydlfXevpquFRF5JZD7OsBxdq0R4/edit#gid=0 and backup CSV in this GitHub repo
- Property deed research in Connecticut towns:
- Katie Cambell: West Hartford, Summer 2010
- David K. Ware: Manchester (see “The Black and White of Greenway: Racially Restrictive Covenants in Manchester, Connecticut,” 2020, https://ssrn.com/abstract=3546228), Newington 2023, East Haddam 2024
- June Gold: Hamden, 2023-24
- Leaflet map by Ilya Ilyakou and Jack Dougherty, which replaces the 2012 UConn MAGIC Google Map http://magic.lib.uconn.edu/otl/doclink_covenant.html
- If you know of other restrictive covenants by race or religion, anywhere in Connecticut, contact the author [email protected]
- Overview: draw in GeoJson.io, data entry in Google Sheet, join in MapShaper, republish in Datawrapper, save to GitHub
- Scan historical documents, add metadata, and upload to
pdfGitHub folder using id format - to draw new polygons, upload to geojson.io, draw and name id, then export
- to enter new data, go to data in Google Sheet; avoid empty rows at bottom for cleaner pivot table
- download data as CSV
- upload existing map.geojson to mapshaper.org
- console: -filter-fields id (to remove all fields except geospatial id)
- upload CSV and rename to 'data'
- console: -join data keys=id,id
- export with option: extension='.geojson', upload to GitHub
- save XLSX backup to https://github.com/ontheline/otl-covenants
- Republish two linked Datawrapper tables in OTL Team folder
- Racist Covenants Located To Date by Connecticut Town https://app.datawrapper.de/archive/team/Fj3ATkF7/63725#/dCnch
- Search by Street Name for CT Racist Covenants https://app.datawrapper.de/archive/team/Fj3ATkF7/63725#/j4lCy
- Live map and two tables appears on live sites: https://myCTdeed.com and (only map and main table in book) https://ontheline.trincoll.edu/restricting.html
see working Google Sheet https://docs.google.com/spreadsheets/d/1RtxNexc0S8gZyZVimdwM0FO-kq8xPw3HMaP2Ku5a8KI/edit#gid=0
- Not yet mapped: Moodus Estates subdivision, lot 8, block 37, warranty deed by Edward L. Parker of The Lake Realty Company, filed 5 Nov 1949 in Dade County Florida (after the 1948 Shelley decision), recorded 21 December 1950 (more than one year later) in East Haddam land records, book 66, page 103, document 77018571, no online image currently available, also need map image. Historical source submitted by Bob Rentenauer, 10 December 2019.