units_with_maps

Table actions

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

4 rows where COUNTY = 24, DES_TP = 16 and MNG_AG_TYP = 12

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, YR_EST

MNG_AG_TYP 1

  • Non Profit - Conservation · 4 ✖

DES_TP 1

  • Private Conservation · 4 ✖

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
4321 4321 4320 {"type": "Polygon", "coordinates": [[[-123.72841, 39.25459], [-123.72836, 39.25477], [-123.72774, 39.25477], [-123.72734, 39.25423], [-123.72695, 39.2538], [-123.72614, 39.25278], [-123.72607, 39.25268], [-123.72573, 39.25242], [-123.7255, 39.25223], [-123.7254, 39.25204], [-123.72532, 39.25184], [-123.72532, 39.25161], [-123.72539, 39.25135], [-123.72509, 39.25077], [-123.72528, 39.25029], [-123.72534, 39.24985], [-123.72518, 39.24933], [-123.72499, 39.24893], [-123.72531, 39.24875], [-123.72585, 39.24829], [-123.72603, 39.24822], [-123.72628, 39.24841], [-123.72658, 39.24867], [-123.72676, 39.24878], [-123.72664, 39.24928], [-123.72705, 39.24987], [-123.7272, 39.25039], [-123.72728, 39.25059], [-123.72746, 39.25075], [-123.72761, 39.25109], [-123.7274, 39.25158], [-123.72737, 39.25191], [-123.7272, 39.2526], [-123.72734, 39.25285], [-123.72759, 39.25311], [-123.72813, 39.25374], [-123.72841, 39.25459]]]} Open Access 1 45423 Raven's Call 28205 3353 Friends of the Enchanted Meadow 744 Non Profit 6 Non Profit - Conservation 12 http://www.friendsofenchantedmeadow.org/ Non Governmental Organization 10 3353 Friends of the Enchanted Meadow 730 Non Profit 6 Non Profit - Conservation 12 http://www.friendsofenchantedmeadow.org/raven.html Mendocino 24 23.564 Raven's Call 0 Private Conservation 16 2
4322 4322 4321 {"type": "Polygon", "coordinates": [[[-123.7274, 39.24845], [-123.72682, 39.2487], [-123.72662, 39.2486], [-123.72645, 39.24844], [-123.72609, 39.24815], [-123.72594, 39.24806], [-123.72562, 39.24794], [-123.72529, 39.24766], [-123.72488, 39.24741], [-123.72471, 39.24728], [-123.72437, 39.24658], [-123.72419, 39.2464], [-123.72412, 39.2462], [-123.72418, 39.24532], [-123.72483, 39.24527], [-123.72523, 39.24513], [-123.7251, 39.24577], [-123.72525, 39.24628], [-123.72568, 39.24692], [-123.72603, 39.24724], [-123.72638, 39.24732], [-123.72713, 39.24796], [-123.72724, 39.24812], [-123.72735, 39.24824], [-123.7274, 39.24845]]]} Open Access 1 45424 Albert Cattalini Conservancy 28204 3353 Friends of the Enchanted Meadow 744 Non Profit 6 Non Profit - Conservation 12 http://www.friendsofenchantedmeadow.org/ Non Governmental Organization 10 3353 Friends of the Enchanted Meadow 730 Non Profit 6 Non Profit - Conservation 12 http://www.friendsofenchantedmeadow.org/acc.html Mendocino 24 9.326 Albert Cattalini Conservancy 0 Private Conservation 16 2
9139 9139 9138 {"type": "Polygon", "coordinates": [[[-123.64935, 38.84992], [-123.64931, 38.84997], [-123.64904, 38.85012], [-123.6491, 38.8502], [-123.64922, 38.8503], [-123.64935, 38.85043], [-123.64926, 38.85052], [-123.64925, 38.85081], [-123.64913, 38.85087], [-123.64879, 38.8509], [-123.6488, 38.85097], [-123.64889, 38.851], [-123.64926, 38.851], [-123.64932, 38.85103], [-123.64924, 38.85123], [-123.64905, 38.85129], [-123.64886, 38.85128], [-123.64865, 38.85135], [-123.64865, 38.8514], [-123.64859, 38.85151], [-123.64858, 38.8516], [-123.64874, 38.85164], [-123.64862, 38.8517], [-123.64861, 38.85178], [-123.6485, 38.85183], [-123.64834, 38.85186], [-123.64822, 38.85194], [-123.64778, 38.85177], [-123.6477, 38.85162], [-123.64757, 38.85111], [-123.64735, 38.85059], [-123.64703, 38.8501], [-123.64817, 38.84956], [-123.6482, 38.84968], [-123.64816, 38.84975], [-123.64816, 38.84981], [-123.64797, 38.84979], [-123.64779, 38.84979], [-123.64762, 38.85], [-123.64765, 38.85012], [-123.64778, 38.85034], [-123.64793, 38.85047], [-123.64806, 38.85051], [-123.64829, 38.85043], [-123.64844, 38.85027], [-123.64843, 38.85018], [-123.64865, 38.85004], [-123.64885, 38.84997], [-123.64907, 38.84994], [-123.64935, 38.84992]]]} Open Access 1 48998 Hearn Gulch 33693 3303 Redwood Coast Land Conservancy 904 Non Profit 6 Non Profit - Conservation 12 http://www.rc-lc.org/ Non Governmental Organization 10 3303 Redwood Coast Land Conservancy 879 Non Profit 6 Non Profit - Conservation 12 https://www.rclc.org/hearn-gulch/ Mendocino 24 6.409 Hearn Gulch 2008 Private Conservation 16 2
16810 16810 16809 {"type": "Polygon", "coordinates": [[[-123.53176, 38.79603], [-123.52979, 38.79762], [-123.52905, 38.79637], [-123.52785, 38.79494], [-123.52811, 38.79484], [-123.52838, 38.79482], [-123.5285, 38.79482], [-123.52897, 38.79489], [-123.52942, 38.79536], [-123.53153, 38.79567], [-123.53176, 38.79603]]]} Open Access 1 48503 Redwood Coast Recreation Center 33212 3389 Redwood Coast Recreation Center 1176 Non Profit 6 Non Profit - Conservation 12 http://rcrcpool.org/#about Non Governmental Organization 10 3389 Redwood Coast Recreation Center 1116 Non Profit 6 Non Profit - Conservation 12 http://rcrcpool.org/ Mendocino 24 11.148 Redwood Coast Rec. Ctr. 1999 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]);