calands: superunits_with_maps: 2 rows where MNG_AGENCY = 859 and MNG_AG

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

2 rows where MNG_AGENCY = 859 and MNG_AG_LEV = 4

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
9183	9183	9182	{"type": "MultiPolygon", "coordinates": [[[[-116.56364, 33.11825], [-116.55962, 33.1184], [-116.55967, 33.12184], [-116.55916, 33.12188], [-116.55924, 33.12381], [-116.55473, 33.12403], [-116.55462, 33.12208], [-116.55564, 33.12201], [-116.55545, 33.10781], [-116.55541, 33.10779], [-116.55544, 33.10415], [-116.55533, 33.10051], [-116.55939, 33.10043], [-116.55951, 33.10399], [-116.56342, 33.10381], [-116.56349, 33.10731], [-116.56364, 33.11825]]], [[[-116.59542, 33.15573], [-116.58232, 33.15643], [-116.58105, 33.15221], [-116.58537, 33.15193], [-116.58535, 33.14991], [-116.58968, 33.14953], [-116.58971, 33.15165], [-116.59408, 33.15137], [-116.59542, 33.15573]]], [[[-116.61024, 33.11223], [-116.60655, 33.11585], [-116.60292, 33.11583], [-116.60304, 33.1155], [-116.60306, 33.11537], [-116.60306, 33.11515], [-116.60273, 33.11376], [-116.60264, 33.11354], [-116.60255, 33.11339], [-116.60216, 33.11299], [-116.6021, 33.11295], [-116.60206, 33.11289], [-116.60201, 33.11275], [-116.60204, 33.11268], [-116.60214, 33.11256], [-116.60234, 33.11244], [-116.60259, 33.11233], [-116.60271, 33.11228], [-116.60296, 33.11222], [-116.60328, 33.11219], [-116.60345, 33.11212], [-116.60351, 33.11209], [-116.60365, 33.11196], [-116.60378, 33.11176], [-116.60385, 33.11152], [-116.60385, 33.11129], [-116.60381, 33.11113], [-116.60375, 33.11101], [-116.6034, 33.11055], [-116.60321, 33.11025], [-116.60315, 33.10998], [-116.60314, 33.10982], [-116.6031, 33.10966], [-116.603, 33.10943], [-116.60285, 33.10916], [-116.60263, 33.10865], [-116.6069, 33.10865], [-116.60691, 33.11222], [-116.61024, 33.11223]]], [[[-116.60366, 33.11132], [-116.60366, 33.11148], [-116.60362, 33.11165], [-116.60351, 33.11184], [-116.60341, 33.11194], [-116.60332, 33.112], [-116.6032, 33.11203], [-116.60284, 33.11208], [-116.60256, 33.11216], [-116.60257, 33.10898], [-116.60291, 33.1097], [-116.60295, 33.10986], [-116.60299, 33.11018], [-116.60304, 33.11034], [-116.60329, 33.11073], [-116.60357, 33.11107], [-116.60364, 33.11122], [-116.60366, 33.11132]]], [[[-116.73282, 33.12416], [-116.72863, 33.12404], [-116.71995, 33.12392], [-116.71989, 33.12778], [-116.71994, 33.13029], [-116.71894, 33.12855], [-116.71794, 33.12675], [-116.71666, 33.12415], [-116.71148, 33.11444], [-116.71153, 33.11315], [-116.71147, 33.11126], [-116.71146, 33.10951], [-116.7114, 33.10578], [-116.71987, 33.10558], [-116.72399, 33.10562], [-116.72398, 33.10933], [-116.7282, 33.10929], [-116.7283, 33.11298], [-116.73253, 33.11295], [-116.73266, 33.11669], [-116.72838, 33.11669], [-116.72845, 33.12038], [-116.73275, 33.1204], [-116.73282, 33.12416]], [[-116.71786, 33.11216], [-116.71989, 33.11215], [-116.7199, 33.11121], [-116.71568, 33.11125], [-116.71571, 33.11216], [-116.71786, 33.11216]]], [[[-116.74109, 33.1079], [-116.74108, 33.10916], [-116.73672, 33.10922], [-116.73671, 33.10849], [-116.739, 33.10849], [-116.73919, 33.10866], [-116.73938, 33.10856], [-116.73993, 33.10789], [-116.74109, 33.1079]]], [[[-116.77148, 33.11263], [-116.76714, 33.1127], [-116.76717, 33.12036], [-116.76284, 33.12036], [-116.76285, 33.1242], [-116.74993, 33.12419], [-116.74983, 33.11661], [-116.76279, 33.1166], [-116.76278, 33.11275], [-116.76713, 33.11269], [-116.76713, 33.11085], [-116.77147, 33.11083], [-116.77148, 33.11263]]], [[[-116.96257, 33.06565], [-116.95798, 33.06557], [-116.95791, 33.06161], [-116.96238, 33.06154], [-116.96257, 33.06565]]], [[[-117.01587, 33.10181], [-117.00721, 33.10173], [-117.00723, 33.09846], [-117.01352, 33.09829], [-117.01389, 33.09866], [-117.01411, 33.09881], [-117.01437, 33.09891], [-117.01466, 33.09898], [-117.01494, 33.09899], [-117.01505, 33.09902], [-117.01527, 33.09906], [-117.01553, 33.09906], [-117.01564, 33.09904], [-117.01586, 33.09905], [-117.01585, 33.09912], [-117.01587, 33.10181]]], [[[-117.03205, 33.04178], [-117.02982, 33.0424], [-117.02925, 33.04297], [-117.02937, 33.04402], [-117.02816, 33.04403], [-117.02819, 33.04383], [-117.02815, 33.04362], [-117.02825, 33.04325], [-117.02852, 33.0431], [-117.02857, 33.04285], [-117.02888, 33.0425], [-117.02865, 33.04161], [-117.02863, 33.04105], [-117.02873, 33.04094], [-117.02876, 33.04048], [-117.02901, 33.03959], [-117.02902, 33.03946], [-117.02898, 33.03928], [-117.02916, 33.039], [-117.02917, 33.03852], [-117.02989, 33.03839], [-117.03039, 33.03864], [-117.03073, 33.0387], [-117.03191, 33.03867], [-117.03205, 33.04178]]], [[[-117.0431, 33.0404], [-117.04234, 33.04173], [-117.04209, 33.04158], [-117.04186, 33.04141], [-117.04138, 33.0416], [-117.04066, 33.04106], [-117.0402, 33.04144], [-117.04051, 33.04183], [-117.04078, 33.04227], [-117.04082, 33.04235], [-117.04078, 33.04269], [-117.04076, 33.04278], [-117.0408, 33.04288], [-117.04083, 33.04291], [-117.04157, 33.04309], [-117.04105, 33.04401], [-117.03222, 33.04407], [-117.03187, 33.03647], [-117.03625, 33.0365], [-117.03627, 33.03787], [-117.03772, 33.03788], [-117.03774, 33.03944], [-117.03738, 33.03944], [-117.03737, 33.03946], [-117.0376, 33.03953], [-117.03769, 33.03958], [-117.03771, 33.03962], [-117.03777, 33.03965], [-117.03872, 33.04036], [-117.03891, 33.04043], [-117.03915, 33.04002], [-117.03915, 33.03946], [-117.04057, 33.03948], [-117.04058, 33.04037], [-117.0431, 33.0404]], [[-117.03526, 33.04035], [-117.03408, 33.04032], [-117.03407, 33.0424], [-117.03523, 33.04239], [-117.03526, 33.04035]], [[-117.04018, 33.04145], [-117.04003, 33.04122], [-117.03946, 33.04081], [-117.0386, 33.04165], [-117.03828, 33.04199], [-117.03952, 33.04202], [-117.04001, 33.04161], [-117.04018, 33.04145]]], [[[-117.08807, 33.07148], [-117.08733, 33.07483], [-117.08719, 33.07507], [-117.08712, 33.07514], [-117.08674, 33.07532], [-117.08707, 33.07476], [-117.08715, 33.07448], [-117.08715, 33.0743], [-117.08712, 33.07423], [-117.08682, 33.07349], [-117.0868, 33.07337], [-117.08681, 33.07317], [-117.08687, 33.07303], [-117.08698, 33.07287], [-117.0871, 33.07278], [-117.08713, 33.0728], [-117.08726, 33.07272], [-117.08724, 33.07269], [-117.08738, 33.07195], [-117.08607, 33.0716], [-117.08608, 33.07132], [-117.08807, 33.07148]]], [[[-117.13947, 33.04016], [-117.13514, 33.04016], [-117.13512, 33.04084], [-117.13399, 33.04103], [-117.13276, 33.0414], [-117.13197, 33.0423], [-117.13159, 33.04282], [-117.13122, 33.04321], [-117.13101, 33.04348], [-117.13078, 33.04382], [-117.12669, 33.04383], [-117.12669, 33.03929], [-117.13096, 33.0393], [-117.13098, 33.03878], [-117.13275, 33.03877], [-117.13276, 33.03653], [-117.13453, 33.03651], [-117.13946, 33.03649], [-117.13947, 33.04016]]], [[[-117.12723, 33.03666], [-117.1267, 33.03665], [-117.1267, 33.03659], [-117.12721, 33.03658], [-117.12723, 33.03666]]], [[[-117.2474, 32.97836], [-117.24168, 32.97829], [-117.24007, 32.97858], [-117.23873, 32.97897], [-117.23871, 32.9777], [-117.2359, 32.97769], [-117.23589, 32.97824], [-117.23054, 32.97821], [-117.23052, 32.97748], [-117.23055, 32.9772], [-117.23063, 32.97688], [-117.23075, 32.97656], [-117.23089, 32.97626], [-117.23099, 32.97611], [-117.23119, 32.97583], [-117.23144, 32.97557], [-117.23171, 32.97533], [-117.23211, 32.97505], [-117.23268, 32.97477], [-117.23304, 32.97465], [-117.2334, 32.97456], [-117.23688, 32.97409], [-117.23729, 32.97401], [-117.23762, 32.97391], [-117.23784, 32.97383], [-117.2382, 32.97365], [-117.23858, 32.9734], [-117.23889, 32.97314], [-117.23904, 32.97297], [-117.2392, 32.97277], [-117.23934, 32.97257], [-117.23948, 32.97231], [-117.23958, 32.97204], [-117.23966, 32.97176], [-117.24045, 32.97176], [-117.24046, 32.97462], [-117.24175, 32.97464], [-117.24175, 32.9743], [-117.24287, 32.97407], [-117.24306, 32.97398], [-117.24305, 32.97482], [-117.24306, 32.97483], [-117.24737, 32.97395], [-117.2474, 32.97836]]], [[[-117.24735, 32.97286], [-117.24305, 32.97281], [-117.24305, 32.97158], [-117.24317, 32.97158], [-117.24315, 32.97207], [-117.24328, 32.97224], [-117.24361, 32.97234], [-117.24382, 32.97234], [-117.24398, 32.97218], [-117.24405, 32.97187], [-117.24405, 32.97166], [-117.24394, 32.97137], [-117.24371, 32.97114], [-117.2437, 32.97056], [-117.2445, 32.96992], [-117.24635, 32.96992], [-117.24591, 32.96921], [-117.24734, 32.96922], [-117.24734, 32.97169], [-117.24735, 32.97286]]], [[[-117.26235, 32.97049], [-117.26211, 32.97088], [-117.26009, 32.96991], [-117.25848, 32.97116], [-117.25599, 32.97118], [-117.25595, 32.9703], [-117.25172, 32.97117], [-117.25111, 32.97119], [-117.25033, 32.97051], [-117.24968, 32.96839], [-117.24944, 32.96746], [-117.25596, 32.96753], [-117.25599, 32.96812], [-117.25807, 32.96814], [-117.25841, 32.96814], [-117.25888, 32.96806], [-117.25973, 32.9678], [-117.26055, 32.96864], [-117.26088, 32.96904], [-117.26112, 32.96943], [-117.26155, 32.96979], [-117.26146, 32.9699], [-117.26137, 32.96987], [-117.26133, 32.96998], [-117.26152, 32.9701], [-117.26186, 32.97027], [-117.26235, 32.97049]]]]}	No Public Access 3	San Dieguito River Park		24869	2134	San Dieguito River Park Joint Powers Authority 859	Special District 4	Open Space District 6	http://www.sdrp.org/	Special District 4	2521.71	San Dieguito River Park
13054	13054	13053	{"type": "MultiPolygon", "coordinates": [[[[-116.75415, 33.11659], [-116.74551, 33.11663], [-116.74542, 33.1129], [-116.7368, 33.11289], [-116.73672, 33.10922], [-116.74108, 33.10916], [-116.75405, 33.10902], [-116.75415, 33.11659]]], [[[-117.06775, 33.06646], [-117.06716, 33.06725], [-117.06706, 33.06737], [-117.06694, 33.06746], [-117.06674, 33.06757], [-117.06659, 33.06761], [-117.06614, 33.06765], [-117.06615, 33.06699], [-117.06613, 33.06643], [-117.06607, 33.06616], [-117.06632, 33.0655], [-117.06657, 33.06554], [-117.06673, 33.06562], [-117.06685, 33.06575], [-117.06695, 33.066], [-117.06705, 33.06609], [-117.06732, 33.06576], [-117.06738, 33.06579], [-117.06713, 33.06614], [-117.06775, 33.06646]]], [[[-117.10005, 33.06801], [-117.10004, 33.0681], [-117.09918, 33.06793], [-117.09753, 33.06784], [-117.09802, 33.06603], [-117.09804, 33.06572], [-117.09794, 33.06545], [-117.09654, 33.06581], [-117.09615, 33.06577], [-117.09574, 33.06582], [-117.09543, 33.06595], [-117.09509, 33.06631], [-117.09347, 33.06618], [-117.09346, 33.06612], [-117.08977, 33.06581], [-117.08962, 33.067], [-117.08943, 33.06903], [-117.08916, 33.07157], [-117.08882, 33.07154], [-117.08889, 33.07096], [-117.08854, 33.07087], [-117.08821, 33.07118], [-117.08815, 33.07128], [-117.08807, 33.07148], [-117.08524, 33.07125], [-117.08536, 33.07057], [-117.08613, 33.07023], [-117.08581, 33.06924], [-117.08589, 33.06833], [-117.08632, 33.06777], [-117.08753, 33.06777], [-117.08762, 33.06754], [-117.08779, 33.06623], [-117.0888, 33.0652], [-117.08987, 33.06471], [-117.09055, 33.05824], [-117.09085, 33.05853], [-117.09103, 33.05874], [-117.09121, 33.05888], [-117.09135, 33.05904], [-117.09166, 33.05919], [-117.09172, 33.05933], [-117.09174, 33.05947], [-117.09168, 33.05958], [-117.09166, 33.05978], [-117.09201, 33.05974], [-117.09213, 33.05976], [-117.09228, 33.05987], [-117.09235, 33.06], [-117.09239, 33.06006], [-117.0926, 33.06017], [-117.09276, 33.06029], [-117.09296, 33.06034], [-117.09301, 33.06038], [-117.09333, 33.06052], [-117.09392, 33.06053], [-117.09428, 33.06063], [-117.09463, 33.06078], [-117.09508, 33.06103], [-117.09529, 33.06109], [-117.09542, 33.06115], [-117.09562, 33.0613], [-117.09573, 33.06147], [-117.09574, 33.06156], [-117.0957, 33.06166], [-117.09562, 33.06174], [-117.09547, 33.06184], [-117.09542, 33.06191], [-117.09538, 33.06199], [-117.09537, 33.0621], [-117.09538, 33.06216], [-117.09548, 33.06228], [-117.09549, 33.06242], [-117.09547, 33.06251], [-117.09535, 33.06269], [-117.09535, 33.06283], [-117.09531, 33.06299], [-117.09522, 33.06312], [-117.09503, 33.06331], [-117.09488, 33.06337], [-117.09467, 33.06338], [-117.09466, 33.06342], [-117.09476, 33.06346], [-117.09479, 33.0635], [-117.09473, 33.06365], [-117.09478, 33.06366], [-117.09495, 33.06356], [-117.09516, 33.06349], [-117.09559, 33.06346], [-117.09593, 33.06338], [-117.09621, 33.06337], [-117.09651, 33.06334], [-117.09673, 33.06338], [-117.09686, 33.06339], [-117.09697, 33.06341], [-117.09717, 33.06354], [-117.09725, 33.06361], [-117.0973, 33.06372], [-117.09732, 33.06386], [-117.09722, 33.06435], [-117.09726, 33.06436], [-117.09732, 33.0643], [-117.0975, 33.06423], [-117.09765, 33.06421], [-117.09778, 33.06421], [-117.09805, 33.06426], [-117.0982, 33.06433], [-117.09831, 33.06441], [-117.0985, 33.06459], [-117.09858, 33.06472], [-117.09862, 33.06486], [-117.09863, 33.06508], [-117.09869, 33.0652], [-117.09873, 33.06524], [-117.09874, 33.06531], [-117.0988, 33.06542], [-117.09884, 33.06552], [-117.09888, 33.06574], [-117.09888, 33.06593], [-117.0988, 33.06612], [-117.09881, 33.06652], [-117.09908, 33.06711], [-117.09908, 33.06717], [-117.09906, 33.06724], [-117.09902, 33.0673], [-117.09894, 33.06734], [-117.09888, 33.06737], [-117.0988, 33.06738], [-117.09872, 33.06737], [-117.09864, 33.06733], [-117.09861, 33.06734], [-117.09869, 33.06746], [-117.0987, 33.06753], [-117.09868, 33.06761], [-117.09872, 33.06763], [-117.09888, 33.0676], [-117.09912, 33.0676], [-117.09942, 33.06765], [-117.09966, 33.06771], [-117.0997, 33.06775], [-117.09978, 33.06779], [-117.09995, 33.06782], [-117.10003, 33.06789], [-117.10005, 33.06801]], [[-117.0942, 33.06134], [-117.09419, 33.06132], [-117.09309, 33.06103], [-117.09303, 33.06117], [-117.09413, 33.06148], [-117.0942, 33.06134]]], [[[-117.13513, 33.04138], [-117.13481, 33.04144], [-117.13446, 33.04154], [-117.13417, 33.04167], [-117.13391, 33.04181], [-117.13368, 33.04198], [-117.13347, 33.04219], [-117.13332, 33.04215], [-117.13314, 33.04241], [-117.13296, 33.04272], [-117.13279, 33.04268], [-117.13263, 33.04303], [-117.13264, 33.04305], [-117.13281, 33.04311], [-117.13271, 33.04335], [-117.13284, 33.04341], [-117.13268, 33.04382], [-117.13078, 33.04382], [-117.13101, 33.04348], [-117.13122, 33.04321], [-117.13159, 33.04282], [-117.13197, 33.0423], [-117.13276, 33.0414], [-117.13399, 33.04103], [-117.13512, 33.04084], [-117.13513, 33.04138]]], [[[-117.25126, 32.9784], [-117.2474, 32.97836], [-117.2474, 32.98092], [-117.24741, 32.98098], [-117.24658, 32.98117], [-117.24639, 32.98118], [-117.2461, 32.98118], [-117.24268, 32.98074], [-117.24047, 32.98063], [-117.24017, 32.98064], [-117.23874, 32.98074], [-117.23873, 32.97897], [-117.24007, 32.97858], [-117.24168, 32.97829], [-117.24739, 32.97836], [-117.24737, 32.97395], [-117.24781, 32.97386], [-117.24927, 32.97325], [-117.24998, 32.97311], [-117.2509, 32.97555], [-117.25119, 32.97663], [-117.25137, 32.97716], [-117.25143, 32.97786], [-117.25126, 32.9784]]], [[[-117.24306, 32.97398], [-117.24287, 32.97407], [-117.24176, 32.9743], [-117.24176, 32.97464], [-117.24045, 32.97462], [-117.24045, 32.97178], [-117.23966, 32.97176], [-117.23971, 32.97146], [-117.23971, 32.9712], [-117.23969, 32.97091], [-117.23965, 32.97065], [-117.24127, 32.97067], [-117.24169, 32.97116], [-117.24305, 32.97158], [-117.24306, 32.97398]]]]}	Open Access 1	San Dieguito River Park	http://www.sdrp.org/wordpress/trails/	30289	2134	San Dieguito River Park Joint Powers Authority 859	Special District 4	Open Space District 6	http://www.sdrp.org/	Special District 4	539.324	San Dieguito River Park

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