calands: superunits_with_maps: 4 rows where ACCESS_TYP = 1 and MNG

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

4 rows where ACCESS_TYP = 1 and MNG_AGENCY = 492

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME	YR_EST
134	134	133	{"type": "Polygon", "coordinates": [[[-123.69334, 38.89646], [-123.69092, 38.89742], [-123.68781, 38.89884], [-123.68619, 38.8973], [-123.6853, 38.89648], [-123.68339, 38.89464], [-123.68665, 38.89209], [-123.68675, 38.89243], [-123.687, 38.89272], [-123.68732, 38.89305], [-123.6881, 38.8935], [-123.68935, 38.89412], [-123.68975, 38.89423], [-123.69062, 38.89436], [-123.69119, 38.89451], [-123.69155, 38.89485], [-123.69225, 38.89544], [-123.69266, 38.89574], [-123.69321, 38.89625], [-123.69334, 38.89646]]]}	Open Access 1	Pelican Bluffs Reserve	https://www.mendocinolandtrust.org/explore/explore-our-lands/pelican-bluffs/	31827	3128	Mendocino Land Trust 492	Non Profit 6	Non Profit - Land Trust 10	http://mendocinolandtrust.org/	Non Governmental Organization 10	76.551	Pelican Bluffs Reserve	2013
7324	7324	7323	{"type": "Polygon", "coordinates": [[[-123.77319, 39.19854], [-123.77315, 39.19856], [-123.77313, 39.19859], [-123.77318, 39.19869], [-123.7731, 39.19881], [-123.77295, 39.19886], [-123.77288, 39.19886], [-123.77285, 39.19891], [-123.77266, 39.19894], [-123.77259, 39.19893], [-123.77246, 39.19886], [-123.77217, 39.19865], [-123.7721, 39.19858], [-123.77205, 39.19845], [-123.77192, 39.19842], [-123.77169, 39.19843], [-123.77154, 39.19849], [-123.7715, 39.19853], [-123.77132, 39.19859], [-123.7713, 39.19863], [-123.77134, 39.19871], [-123.77132, 39.19875], [-123.77116, 39.19882], [-123.77098, 39.19883], [-123.77066, 39.19902], [-123.77055, 39.19906], [-123.77038, 39.19914], [-123.7703, 39.19921], [-123.77022, 39.19938], [-123.77021, 39.19951], [-123.77023, 39.19957], [-123.77057, 39.1998], [-123.7706, 39.19987], [-123.77059, 39.19997], [-123.77056, 39.20001], [-123.77056, 39.20005], [-123.77067, 39.20013], [-123.77065, 39.20018], [-123.77059, 39.20022], [-123.77032, 39.20016], [-123.7703, 39.20021], [-123.77034, 39.20026], [-123.7706, 39.20034], [-123.77093, 39.20048], [-123.77104, 39.20063], [-123.77104, 39.2007], [-123.77097, 39.20091], [-123.77097, 39.20098], [-123.77101, 39.20105], [-123.77112, 39.20119], [-123.77115, 39.20125], [-123.77114, 39.20139], [-123.77107, 39.20142], [-123.77102, 39.2014], [-123.77098, 39.20136], [-123.77092, 39.20123], [-123.77075, 39.2012], [-123.77056, 39.20126], [-123.77046, 39.20133], [-123.77045, 39.20141], [-123.77036, 39.20145], [-123.77024, 39.2014], [-123.77007, 39.2014], [-123.76996, 39.20136], [-123.76991, 39.20138], [-123.7699, 39.20144], [-123.76998, 39.20155], [-123.76994, 39.20157], [-123.76976, 39.20157], [-123.7697, 39.2016], [-123.76967, 39.20165], [-123.76967, 39.20176], [-123.76965, 39.20182], [-123.76966, 39.20191], [-123.76972, 39.20199], [-123.76983, 39.20207], [-123.76989, 39.20217], [-123.76993, 39.20221], [-123.77003, 39.20222], [-123.77009, 39.20227], [-123.77012, 39.20232], [-123.77009, 39.20244], [-123.7701, 39.20249], [-123.76897, 39.20249], [-123.7688, 39.20209], [-123.76846, 39.20161], [-123.76795, 39.20091], [-123.76759, 39.20046], [-123.76722, 39.20004], [-123.76712, 39.19924], [-123.76704, 39.19901], [-123.76691, 39.19883], [-123.76685, 39.19856], [-123.76682, 39.19828], [-123.76685, 39.19804], [-123.76729, 39.19757], [-123.76746, 39.19727], [-123.76748, 39.19691], [-123.76721, 39.19615], [-123.76708, 39.19595], [-123.76689, 39.19576], [-123.76663, 39.19554], [-123.76623, 39.19532], [-123.76579, 39.19518], [-123.7717, 39.19503], [-123.77175, 39.19513], [-123.77173, 39.19522], [-123.7717, 39.19529], [-123.77154, 39.1953], [-123.77125, 39.19538], [-123.77115, 39.19537], [-123.771, 39.19531], [-123.77092, 39.1953], [-123.77084, 39.19533], [-123.77081, 39.19536], [-123.7708, 39.19541], [-123.77082, 39.19545], [-123.77088, 39.19555], [-123.77093, 39.1956], [-123.77112, 39.19573], [-123.77117, 39.19579], [-123.77118, 39.19597], [-123.77116, 39.19607], [-123.7711, 39.1962], [-123.77107, 39.19633], [-123.77097, 39.19642], [-123.77086, 39.19659], [-123.77081, 39.19672], [-123.77076, 39.19685], [-123.77078, 39.19702], [-123.7709, 39.19719], [-123.77098, 39.19727], [-123.7713, 39.19744], [-123.77192, 39.19764], [-123.77203, 39.19775], [-123.77222, 39.19784], [-123.77225, 39.19794], [-123.77231, 39.19795], [-123.77234, 39.1979], [-123.77237, 39.1979], [-123.77249, 39.19799], [-123.77259, 39.198], [-123.77273, 39.19797], [-123.77288, 39.19805], [-123.77288, 39.19809], [-123.77285, 39.19811], [-123.77285, 39.19814], [-123.77307, 39.19823], [-123.77306, 39.19829], [-123.77317, 39.19833], [-123.77321, 39.19844], [-123.77319, 39.19854]]]}	Open Access 1	Navarro Point Preserve		22677	3128	Mendocino Land Trust 492	Non Profit 6	Non Profit - Land Trust 10	http://mendocinolandtrust.org/	Non Governmental Organization 10	62.518	Navarro Point Preserve
12994	12994	12993	{"type": "Polygon", "coordinates": [[[-123.76772, 39.55769], [-123.76768, 39.55797], [-123.76746, 39.55836], [-123.76737, 39.55841], [-123.76706, 39.55853], [-123.7669, 39.55864], [-123.76691, 39.55873], [-123.76701, 39.55888], [-123.76702, 39.55897], [-123.76695, 39.55912], [-123.7669, 39.55915], [-123.76663, 39.55918], [-123.76648, 39.55917], [-123.76612, 39.55899], [-123.76591, 39.55893], [-123.76587, 39.55894], [-123.76581, 39.55891], [-123.76541, 39.55901], [-123.76476, 39.55906], [-123.7634, 39.55846], [-123.76336, 39.55736], [-123.76357, 39.55752], [-123.7638, 39.55765], [-123.76399, 39.55772], [-123.7645, 39.55785], [-123.76453, 39.55769], [-123.76567, 39.55772], [-123.76569, 39.5577], [-123.76614, 39.55772], [-123.76645, 39.55776], [-123.76694, 39.55771], [-123.76772, 39.55769]]]}	Open Access 1	Seaside Beach		30236	3128	Mendocino Land Trust 492	Non Profit 6	Non Profit - Land Trust 10	http://mendocinolandtrust.org/	Non Governmental Organization 10	11.571	Seaside Beach
12996	12996	12995	{"type": "Polygon", "coordinates": [[[-123.81194, 39.41802], [-123.81192, 39.41832], [-123.81151, 39.41794], [-123.81066, 39.41825], [-123.80979, 39.41781], [-123.8096, 39.41781], [-123.80926, 39.41831], [-123.80924, 39.41858], [-123.8092, 39.41859], [-123.80811, 39.41948], [-123.80819, 39.41855], [-123.80851, 39.4185], [-123.80906, 39.41793], [-123.80955, 39.41729], [-123.81153, 39.41745], [-123.81173, 39.41784], [-123.81194, 39.41802]]]}	Open Access 1	Hare Creek Beach		30238	3128	Mendocino Land Trust 492	Non Profit 6	Non Profit - Land Trust 10	http://mendocinolandtrust.org/	Non Governmental Organization 10	5.829	Hare Creek Beach

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);