About this Dataset

LOCATION.WRM Sample Sites

Locations where environmental sampling has been either planned or performed or may be performed in the future. Some locations have not been sampled; some have been discontinued due to access constraints; some are locations sampled by partner agencies
Organization: City of Austin
Last updated: 2023-08-25T23:13:15.233778
Tags: agoltosocrata, environment, sample, sampling, site, sites, water-quality, watershed-protection, wrm

Tables

Table 1

@usgov.city_of_austin_location_wrm_sample_sites.table_1

2.07 MB
9,126 rows
30 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "wrm_site_id" BIGINT,
  "site_name" VARCHAR,
  "site_short_name" VARCHAR,
  "austin_lake_index_site" VARCHAR,
  "env_integrtiy_index_site" VARCHAR,
  "site_type" VARCHAR,
  "earliest_sampled_date" TIMESTAMP,
  "most_recently_sampled_date" TIMESTAMP,
  "number_of_data_points" BIGINT,
  "number_of_visits" BIGINT,
  "comments" VARCHAR,
  "hydrogeologic_unit" VARCHAR,
  "elevation" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "latlong" VARCHAR,
  "street_address" VARCHAR,
  "state83_longitude" DOUBLE,
  "state83_latitude" DOUBLE,
  "status" VARCHAR,
  "tceq_site_id" DOUBLE,
  "usgs_site_id" DOUBLE,
  "watershed_id" BIGINT,
  "watershed" VARCHAR,
  "fme_date" TIMESTAMP,
  "fulcrum_id" VARCHAR,
  "qapp_references" VARCHAR,
  "watershed_reach_id" VARCHAR
);