calands: superunits_with_maps: 1 row where ACRES = "1717.803", MNG_AGENCY = 61 and MNG_AG

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

1 row where ACRES = "1717.803", MNG_AGENCY = 61 and MNG_AG_TYP = 10

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
13265	13265	13264	{"type": "Polygon", "coordinates": [[[-121.49851, 38.25558], [-121.49821, 38.25602], [-121.49806, 38.25609], [-121.49789, 38.25614], [-121.49746, 38.25638], [-121.4963, 38.25716], [-121.49603, 38.25762], [-121.49556, 38.25815], [-121.49523, 38.25847], [-121.49483, 38.25863], [-121.49445, 38.25876], [-121.49429, 38.25876], [-121.49389, 38.25893], [-121.4938, 38.25889], [-121.49341, 38.25904], [-121.49309, 38.25931], [-121.49297, 38.25961], [-121.49294, 38.25992], [-121.49299, 38.26064], [-121.49309, 38.26093], [-121.49328, 38.26129], [-121.49388, 38.26202], [-121.49401, 38.26242], [-121.49413, 38.26324], [-121.49426, 38.26357], [-121.49449, 38.2639], [-121.49478, 38.26414], [-121.49489, 38.26415], [-121.49511, 38.26435], [-121.49523, 38.26453], [-121.49532, 38.26455], [-121.49553, 38.26473], [-121.49571, 38.26502], [-121.49661, 38.26509], [-121.4967, 38.26509], [-121.4968, 38.26514], [-121.49702, 38.26521], [-121.497, 38.26527], [-121.49715, 38.26534], [-121.49723, 38.26541], [-121.49752, 38.26545], [-121.49757, 38.26552], [-121.49617, 38.26803], [-121.48474, 38.26798], [-121.47518, 38.26985], [-121.47065, 38.26982], [-121.47063, 38.2699], [-121.46364, 38.26984], [-121.46447, 38.26828], [-121.46431, 38.26749], [-121.46266, 38.26659], [-121.46231, 38.26645], [-121.46231, 38.26641], [-121.46222, 38.26636], [-121.46263, 38.26384], [-121.46105, 38.26172], [-121.46129, 38.2603], [-121.46136, 38.26017], [-121.46149, 38.25921], [-121.46156, 38.25919], [-121.46273, 38.25926], [-121.46468, 38.25956], [-121.46543, 38.25974], [-121.46603, 38.25993], [-121.46634, 38.26001], [-121.46659, 38.26003], [-121.46677, 38.26004], [-121.46696, 38.26002], [-121.46724, 38.25998], [-121.4674, 38.25994], [-121.4676, 38.25986], [-121.46773, 38.25978], [-121.46792, 38.25973], [-121.46829, 38.25957], [-121.46855, 38.25948], [-121.46878, 38.25943], [-121.4691, 38.25943], [-121.47012, 38.25958], [-121.47025, 38.25961], [-121.47061, 38.25977], [-121.47077, 38.25983], [-121.47117, 38.25989], [-121.47143, 38.25988], [-121.47188, 38.25979], [-121.47249, 38.25952], [-121.47258, 38.25951], [-121.47266, 38.25948], [-121.47301, 38.25925], [-121.47345, 38.25902], [-121.47368, 38.25887], [-121.47407, 38.25866], [-121.47434, 38.25855], [-121.4751, 38.2583], [-121.4759, 38.25806], [-121.47625, 38.25781], [-121.47646, 38.25763], [-121.4766, 38.25738], [-121.47663, 38.25729], [-121.47663, 38.25714], [-121.47658, 38.25682], [-121.47657, 38.25664], [-121.47659, 38.25654], [-121.47674, 38.25624], [-121.47686, 38.25608], [-121.47705, 38.2559], [-121.47774, 38.25543], [-121.47837, 38.25493], [-121.47888, 38.25457], [-121.47975, 38.25392], [-121.47992, 38.25376], [-121.48008, 38.25356], [-121.48009, 38.25349], [-121.48008, 38.25341], [-121.47997, 38.25296], [-121.47994, 38.25273], [-121.47985, 38.25245], [-121.47977, 38.2523], [-121.47955, 38.25207], [-121.47932, 38.25187], [-121.47902, 38.25164], [-121.47886, 38.25149], [-121.47879, 38.25139], [-121.47872, 38.25125], [-121.47867, 38.25108], [-121.47865, 38.25075], [-121.47867, 38.25034], [-121.47853, 38.24968], [-121.47847, 38.2493], [-121.47843, 38.24877], [-121.47844, 38.24854], [-121.47851, 38.24809], [-121.47855, 38.24797], [-121.47861, 38.24784], [-121.47892, 38.24742], [-121.47898, 38.24732], [-121.479, 38.24725], [-121.47902, 38.24714], [-121.47898, 38.24694], [-121.47895, 38.24684], [-121.47885, 38.24665], [-121.47879, 38.24644], [-121.4788, 38.24623], [-121.47882, 38.24611], [-121.47888, 38.24601], [-121.47897, 38.24593], [-121.47961, 38.24565], [-121.48044, 38.2452], [-121.48072, 38.24509], [-121.48119, 38.24496], [-121.48135, 38.2449], [-121.48161, 38.24476], [-121.48211, 38.24436], [-121.48247, 38.24405], [-121.48267, 38.24385], [-121.48273, 38.24358], [-121.48277, 38.2433], [-121.48284, 38.24304], [-121.48291, 38.24289], [-121.48316, 38.24261], [-121.4833, 38.24251], [-121.48403, 38.24211], [-121.48428, 38.24193], [-121.48475, 38.24165], [-121.48653, 38.24078], [-121.48698, 38.24042], [-121.48709, 38.24031], [-121.48725, 38.24003], [-121.48746, 38.23957], [-121.4876, 38.23916], [-121.48765, 38.23886], [-121.48762, 38.23864], [-121.48739, 38.23822], [-121.48716, 38.23784], [-121.48697, 38.23745], [-121.48691, 38.23726], [-121.48687, 38.23707], [-121.48684, 38.23681], [-121.48684, 38.23653], [-121.48686, 38.23634], [-121.48694, 38.23614], [-121.48701, 38.23601], [-121.48717, 38.23565], [-121.48726, 38.23552], [-121.48751, 38.23532], [-121.48767, 38.23525], [-121.48787, 38.23511], [-121.48807, 38.23503], [-121.48818, 38.23501], [-121.48832, 38.23502], [-121.48845, 38.23505], [-121.48864, 38.23504], [-121.48894, 38.23495], [-121.48907, 38.23487], [-121.48947, 38.23453], [-121.48982, 38.23407], [-121.48999, 38.23389], [-121.49011, 38.23375], [-121.49045, 38.23348], [-121.4908, 38.23307], [-121.4909, 38.2329], [-121.49099, 38.23268], [-121.49103, 38.23236], [-121.491, 38.2321], [-121.49087, 38.23163], [-121.49086, 38.23145], [-121.49092, 38.23023], [-121.49103, 38.2295], [-121.49111, 38.22931], [-121.49121, 38.22898], [-121.49136, 38.22872], [-121.49164, 38.22831], [-121.49185, 38.22808], [-121.49209, 38.22791], [-121.49219, 38.22781], [-121.49228, 38.22776], [-121.49252, 38.2277], [-121.49262, 38.22771], [-121.49304, 38.22792], [-121.4932, 38.22798], [-121.49337, 38.22803], [-121.49363, 38.22805], [-121.4937, 38.22808], [-121.49396, 38.22851], [-121.49393, 38.22852], [-121.49373, 38.22824], [-121.49364, 38.22824], [-121.49354, 38.22826], [-121.49345, 38.22831], [-121.49343, 38.22837], [-121.49357, 38.22866], [-121.49362, 38.22883], [-121.49436, 38.2306], [-121.4955, 38.23327], [-121.49584, 38.23417], [-121.49608, 38.23462], [-121.4967, 38.23604], [-121.49696, 38.23651], [-121.49723, 38.23717], [-121.49729, 38.2372], [-121.4973, 38.23725], [-121.49728, 38.23727], [-121.49728, 38.23733], [-121.49732, 38.23747], [-121.49741, 38.23759], [-121.49732, 38.23783], [-121.49723, 38.23796], [-121.49672, 38.23847], [-121.49657, 38.2387], [-121.49655, 38.23876], [-121.49643, 38.23882], [-121.4964, 38.23895], [-121.49631, 38.23898], [-121.49616, 38.23923], [-121.49604, 38.23954], [-121.49602, 38.23973], [-121.49601, 38.2399], [-121.49602, 38.23994], [-121.49606, 38.23996], [-121.49601, 38.24019], [-121.49601, 38.24034], [-121.49598, 38.24055], [-121.49592, 38.24078], [-121.49578, 38.24168], [-121.49581, 38.242], [-121.49576, 38.24215], [-121.49576, 38.24279], [-121.49574, 38.24314], [-121.49578, 38.24407], [-121.49599, 38.24502], [-121.49627, 38.24578], [-121.49671, 38.24735], [-121.4968, 38.24772], [-121.49689, 38.24777], [-121.49693, 38.24782], [-121.4969, 38.24792], [-121.49715, 38.24872], [-121.49765, 38.24977], [-121.49778, 38.2501], [-121.49782, 38.25051], [-121.49778, 38.25096], [-121.49772, 38.25146], [-121.49773, 38.25179], [-121.49789, 38.25251], [-121.49795, 38.25288], [-121.49798, 38.25326], [-121.49802, 38.25353], [-121.49806, 38.25399], [-121.49814, 38.25443], [-121.49821, 38.25465], [-121.49843, 38.25518], [-121.49851, 38.25558]]]}	No Public Access 3	Bean Ranch		30587	3091	The Nature Conservancy 61	Non Profit 6	Non Profit - Land Trust 10	http://www.nature.org/	Non Governmental Organization 10	1717.803	Bean Ranch

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]);