Above Ground Resources by US Government | Demographics and Population Studies

About this Dataset

Above Ground Resources

These points are directly sourced from the National Historic Landmarks, National Register, State Register, Local Historic Districts, Local Historic Places, Historic Resources inventories, CHC files, Connecticut Barns listings, Connecticut Arts & letters listings, Connecticut Making Places listings, Connecticut Freedom Trail listings, and various special surveys (Sculpture, Civil War Monuments, Municipal Parks, Town Greens, Historic Bridges). If a resource appears in multiple pdfs, it will appear as one entry.

The geolocation of these points is based on the addresses and pre-existing maps that appear in the associated pdfs of the resources. Some resources were unable to be geolocated; but will still appear in the attribute table of this layer.

The following is a list of the sources for each resource with their associated designation:

1). National Historic Landmark (NHL); with the designation “NHL”.

2). National Register (NR); with the designation “NRIND” for individual resources or NRDIS for NR Districts. A “-C” or a “-NC” is added at the end of NRIND or NRDIS to indicate if it is a contributing or non-contributing resource.

3). Restricted National Register (RNR); with the designation “NRIND” for individual resources or NRDIS for NR Districts. A “-C” or a “-NC” is added at the end of NRIND or NRDIS to indicate if it is a contributing or non-contributing resource. These resources are not geolocated and their pdfs are no available to be viewed on the
Organization: State of Connecticut
Last updated: 2024-02-24T05:42:06.892535
Tags: above-ground-resources, conncris, shpo

Tables

Table 1

@usgov.state_of_connecticut_above_ground_resources.table_1

5.77 MB
103715 rows
87 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "name" VARCHAR,
  "unique_id" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "stnum" DOUBLE,
  "sec_stnum" VARCHAR,
  "st_name" VARCHAR,
  "municip2" VARCHAR,
  "municipali" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "desigstatu" VARCHAR,
  "criterion" VARCHAR,
  "source" VARCHAR,
  "constructd" VARCHAR,
  "periods" VARCHAR,
  "primary_st" VARCHAR,
  "type" VARCHAR,
  "sub_type" VARCHAR,
  "socialhist" VARCHAR,
  "ethnichist" VARCHAR,
  "district_names" VARCHAR,
  "style_note" VARCHAR,
  "type_notes" VARCHAR,
  "bridge_not" VARCHAR,
  "location_n" VARCHAR,
  "restricted" VARCHAR,
  "notes" VARCHAR,
  "opp_zone" DOUBLE,
  "resourcefilter" VARCHAR,
  "preservationrestriction" VARCHAR,
  "restrict_begin" VARCHAR,
  "restrict_end" VARCHAR,
  "cemeteries" VARCHAR,
  "dams" VARCHAR,
  "nhl" VARCHAR,
  "nr" VARCHAR,
  "sr" VARCHAR,
  "local" VARCHAR,
  "bridges" VARCHAR,
  "making_places" VARCHAR,
  "twn_survey1" VARCHAR,
  "twnsur_pg1" VARCHAR,
  "twn_survey2" VARCHAR,
  "twnsur_pg2" VARCHAR,
  "twn_survey3" VARCHAR,
  "twnsur_pg3" VARCHAR,
  "sr_pdf1" VARCHAR,
  "sr_pdf2" VARCHAR,
  "sr_pdf3" VARCHAR,
  "sr_pdf4" VARCHAR,
  "lhd_pdf1" VARCHAR,
  "lhd_pdf2" VARCHAR,
  "lhd_pdf3" VARCHAR,
  "lhd_pdf4" VARCHAR,
  "lhd_pdf5" VARCHAR,
  "lhd_pdf6" VARCHAR,
  "lhp_pdf1" VARCHAR,
  "lhp_pdf2" VARCHAR,
  "lhp_pdf3" VARCHAR,
  "lhp_pdf4" VARCHAR,
  "lhp_pdf5" VARCHAR,
  "lhp_pdf6" VARCHAR,
  "lhp_pdf7" VARCHAR,
  "lhp_pdf8" VARCHAR,
  "lhp_pdf9" VARCHAR,
  "nr_pdf1" VARCHAR,
  "nr_pdf2" VARCHAR,
  "nr_pdf3" VARCHAR,
  "nhl_pdf1" VARCHAR,
  "nhl_pdf2" VARCHAR,
  "ss_mp" VARCHAR,
  "ss_sos" VARCHAR,
  "ss_cwm" VARCHAR,
  "ss_hb" VARCHAR,
  "ss_tg" VARCHAR,
  "cft_pdf1" VARCHAR,
  "cft_pdf2" VARCHAR,
  "cft_pdf3" VARCHAR,
  "chc_pdf" VARCHAR,
  "stateowned" VARCHAR,
  "stateowned2" VARCHAR,
  "barns_link" VARCHAR,
  "creativeplaceslink" VARCHAR
);