units_with_maps

Table actions

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

1 row where COUNTY = 24 and MNG_AGENCY = 224

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • The Wildlands Conservancy · 1 ✖

ACCESS_TYP 1

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
7473 7473 7472 {"type": "MultiPolygon", "coordinates": [[[[-123.44706, 39.8815], [-123.44699, 39.8844], [-123.44271, 39.8844], [-123.44236, 39.88858], [-123.44241, 39.89214], [-123.43778, 39.89217], [-123.4378, 39.89568], [-123.43791, 39.90283], [-123.43322, 39.90286], [-123.43336, 39.91368], [-123.42408, 39.91373], [-123.41475, 39.91367], [-123.41476, 39.91727], [-123.4055, 39.90996], [-123.4008, 39.91001], [-123.40061, 39.90291], [-123.39632, 39.90291], [-123.39635, 39.89579], [-123.39169, 39.89577], [-123.3917, 39.88855], [-123.39635, 39.88857], [-123.39855, 39.88856], [-123.39845, 39.88426], [-123.39659, 39.88427], [-123.39664, 39.88339], [-123.40446, 39.88328], [-123.40455, 39.87984], [-123.39683, 39.87971], [-123.397, 39.87622], [-123.39703, 39.87487], [-123.39707, 39.87445], [-123.39684, 39.86538], [-123.40104, 39.86537], [-123.40612, 39.86543], [-123.40615, 39.86167], [-123.40612, 39.85884], [-123.40619, 39.85445], [-123.4014, 39.85443], [-123.40138, 39.85272], [-123.40621, 39.85274], [-123.40641, 39.84724], [-123.41197, 39.84725], [-123.41206, 39.84378], [-123.41089, 39.84372], [-123.41072, 39.83567], [-123.41538, 39.83566], [-123.4154, 39.83633], [-123.42046, 39.83622], [-123.42063, 39.83725], [-123.41912, 39.84], [-123.41782, 39.84283], [-123.41768, 39.84531], [-123.42026, 39.84717], [-123.42546, 39.84817], [-123.42746, 39.85064], [-123.42846, 39.85219], [-123.42847, 39.85532], [-123.43348, 39.85724], [-123.43579, 39.85803], [-123.43662, 39.86133], [-123.43512, 39.86134], [-123.43511, 39.86136], [-123.43558, 39.862], [-123.43609, 39.86252], [-123.43635, 39.86272], [-123.43661, 39.86287], [-123.43687, 39.86302], [-123.43724, 39.86317], [-123.43773, 39.86322], [-123.43816, 39.86321], [-123.43844, 39.86331], [-123.43873, 39.86345], [-123.43902, 39.8638], [-123.43978, 39.86506], [-123.43991, 39.86523], [-123.43995, 39.86544], [-123.43999, 39.86558], [-123.43993, 39.86577], [-123.43981, 39.86604], [-123.43938, 39.86684], [-123.43911, 39.86742], [-123.43896, 39.86781], [-123.43894, 39.86791], [-123.4388, 39.86834], [-123.43868, 39.86882], [-123.43852, 39.86993], [-123.43845, 39.87011], [-123.43837, 39.87079], [-123.43829, 39.87097], [-123.43819, 39.87135], [-123.43812, 39.87152], [-123.43798, 39.87231], [-123.4379, 39.87258], [-123.43786, 39.8731], [-123.43787, 39.87323], [-123.43792, 39.87339], [-123.43794, 39.87367], [-123.43821, 39.87427], [-123.43832, 39.87447], [-123.43846, 39.87457], [-123.43858, 39.87471], [-123.43874, 39.87481], [-123.43921, 39.87502], [-123.4398, 39.8754], [-123.44026, 39.87563], [-123.44048, 39.87605], [-123.44069, 39.87635], [-123.44084, 39.87648], [-123.44104, 39.87647], [-123.44113, 39.87666], [-123.44131, 39.87712], [-123.44145, 39.87737], [-123.44162, 39.87757], [-123.44228, 39.87801], [-123.44251, 39.8783], [-123.4426, 39.8785], [-123.44284, 39.87887], [-123.44292, 39.87903], [-123.44314, 39.87929], [-123.44378, 39.87983], [-123.44388, 39.87997], [-123.44421, 39.88016], [-123.44462, 39.88025], [-123.44495, 39.88028], [-123.4456, 39.88039], [-123.44613, 39.88071], [-123.44675, 39.8813], [-123.44706, 39.8815]], [[-123.42393, 39.8867], [-123.42407, 39.88317], [-123.41959, 39.88315], [-123.41973, 39.87971], [-123.41503, 39.87973], [-123.41517, 39.87645], [-123.40595, 39.87634], [-123.40581, 39.87982], [-123.40583, 39.88061], [-123.41029, 39.88059], [-123.41009, 39.88322], [-123.40811, 39.88339], [-123.408, 39.88526], [-123.40799, 39.88855], [-123.41461, 39.88853], [-123.42509, 39.88858], [-123.42508, 39.88686], [-123.42393, 39.8867]], [[-123.40594, 39.87486], [-123.406, 39.86896], [-123.40139, 39.86894], [-123.40146, 39.87488], [-123.40594, 39.87486]]], [[[-123.43351, 39.92448], [-123.42417, 39.9245], [-123.42413, 39.92085], [-123.42868, 39.92084], [-123.42873, 39.91724], [-123.43342, 39.91723], [-123.43345, 39.9207], [-123.43351, 39.92448]]]]} Open Access 1 47601 Spyrock Reserve 31332 3092 The Wildlands Conservancy 228 Non Profit 6 Non Profit - Land Trust 10 http://www.wildlandsconservancy.org/ Non Governmental Organization 10 3092 The Wildlands Conservancy 224 Non Profit 6 Non Profit - Land Trust 10 http://www.wildlandsconservancy.org/preserve_spyrock.html Mendocino 24 5653.511 Spyrock Reserve 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]);