units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

4 rows where ACCESS_TYP = 3, COUNTY = 11 and DES_TP = 16

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, MNG_AG_ID

DES_TP 1

  • Private Conservation · 4 ✖

ACCESS_TYP 1

  • No Public Access · 4 ✖
Link rowid ▼ id map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
1753 1753 1752 {"type": "Polygon", "coordinates": [[[-122.49925, 38.63647], [-122.49421, 38.63642], [-122.49417, 38.63271], [-122.48533, 38.63279], [-122.48527, 38.62564], [-122.47606, 38.62561], [-122.4761, 38.62202], [-122.48526, 38.62206], [-122.48527, 38.62563], [-122.48765, 38.62558], [-122.48985, 38.62546], [-122.49439, 38.62527], [-122.49434, 38.62156], [-122.49886, 38.62131], [-122.49897, 38.62494], [-122.49908, 38.62919], [-122.49915, 38.63266], [-122.49925, 38.63647]]]} No Public Access 3 13101 Cleary Reserve 17417 3011 California Biological Field Studies Association 420 Non Profit 6 Non Profit - Conservation 12   Non Governmental Organization 10 3011 California Biological Field Studies Association 414 Non Profit 6 Non Profit - Conservation 12   Napa 11 406.373 Cleary Reserve 0 Private Conservation 16 2
2231 2231 2230 {"type": "Polygon", "coordinates": [[[-122.61347, 38.57103], [-122.60977, 38.57104], [-122.60939, 38.57019], [-122.60879, 38.56687], [-122.61337, 38.56677], [-122.61347, 38.57103]]]} No Public Access 3 47877 Willer Donation 31822 3035 Land Trust of Napa County 140 Non Profit 6 Non Profit - Land Trust 10 http://www.napalandtrust.org/ Non Governmental Organization 10 3035 Land Trust of Napa County 137 Non Profit 6 Non Profit - Land Trust 10   Napa 11 42.637 Willer Donation 2010 Private Conservation 16 2
4195 4195 4194 {"type": "Polygon", "coordinates": [[[-122.40763, 38.56593], [-122.40662, 38.56777], [-122.39871, 38.56771], [-122.39845, 38.56769], [-122.39832, 38.56763], [-122.39815, 38.56748], [-122.39786, 38.56727], [-122.39744, 38.56723], [-122.39806, 38.56708], [-122.3984, 38.5669], [-122.39855, 38.56672], [-122.3986, 38.56653], [-122.39852, 38.56634], [-122.39829, 38.56621], [-122.39817, 38.5661], [-122.39812, 38.566], [-122.39819, 38.56588], [-122.39834, 38.56571], [-122.39836, 38.56558], [-122.39834, 38.56548], [-122.39823, 38.56528], [-122.39822, 38.56512], [-122.39512, 38.56389], [-122.39492, 38.56386], [-122.39459, 38.56008], [-122.39764, 38.56007], [-122.39939, 38.56002], [-122.39966, 38.56388], [-122.40438, 38.56388], [-122.40441, 38.56433], [-122.40763, 38.56593]]]} No Public Access 3 47684 Okin Preserve 31422 3035 Land Trust of Napa County 140 Non Profit 6 Non Profit - Land Trust 10 http://www.napalandtrust.org/ Non Governmental Organization 10 3035 Land Trust of Napa County 137 Non Profit 6 Non Profit - Land Trust 10   Napa 11 122.836 Okin Preserve 0 Private Conservation 16 2
7797 7797 7796 {"type": "Polygon", "coordinates": [[[-122.2747, 38.5643], [-122.27465, 38.57108], [-122.26979, 38.57023], [-122.26488, 38.56972], [-122.26488, 38.563], [-122.2747, 38.5643]]]} No Public Access 3 47668 Cedar Roughs 31409 3097 Wilderness Land Trust 603 Non Profit 6 Non Profit - Land Trust 10 http://www.wildernesslandtrust.org/ Non Governmental Organization 10 3097 Wilderness Land Trust 592 Non Profit 6 Non Profit - Land Trust 10   Napa 11 156.245 Cedar Roughs 0 Private Conservation 16 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
   FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
   FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
   FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
   FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);