superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, MNG_AGENCY = 342 and MNG_AG_ID = 2117
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
843 | 843 | 842 | {"type": "MultiPolygon", "coordinates": [[[[-118.63657, 34.26504], [-118.63633, 34.26516], [-118.63617, 34.26526], [-118.63601, 34.2654], [-118.63587, 34.26558], [-118.6358, 34.26572], [-118.63574, 34.26588], [-118.63571, 34.26605], [-118.63569, 34.26628], [-118.63564, 34.26647], [-118.63554, 34.26667], [-118.63539, 34.26684], [-118.63447, 34.26759], [-118.63418, 34.26779], [-118.63386, 34.26798], [-118.63327, 34.26823], [-118.63273, 34.2646], [-118.63657, 34.26504]]], [[[-118.63485, 34.26765], [-118.63449, 34.26821], [-118.63372, 34.26845], [-118.63334, 34.26871], [-118.63329, 34.2684], [-118.6338, 34.26819], [-118.63416, 34.26801], [-118.63449, 34.2678], [-118.63477, 34.26758], [-118.63485, 34.26765]]], [[[-118.65762, 34.27232], [-118.65772, 34.2726], [-118.65771, 34.27281], [-118.65769, 34.27297], [-118.65755, 34.27344], [-118.65753, 34.27346], [-118.65749, 34.27338], [-118.65642, 34.27257], [-118.65573, 34.27221], [-118.6555, 34.27195], [-118.65574, 34.2717], [-118.65574, 34.27168], [-118.65499, 34.27151], [-118.65408, 34.27081], [-118.65349, 34.27065], [-118.65242, 34.27019], [-118.65185, 34.27015], [-118.65094, 34.26998], [-118.65002, 34.26966], [-118.65005, 34.26918], [-118.64922, 34.26888], [-118.64886, 34.26879], [-118.64706, 34.26807], [-118.64679, 34.26814], [-118.64604, 34.26809], [-118.6458, 34.26796], [-118.64547, 34.26785], [-118.64495, 34.26758], [-118.64462, 34.26755], [-118.64414, 34.26724], [-118.64391, 34.26694], [-118.64358, 34.26675], [-118.64244, 34.26649], [-118.64221, 34.26578], [-118.64206, 34.2657], [-118.64022, 34.26616], [-118.63857, 34.266], [-118.63825, 34.26619], [-118.63802, 34.26604], [-118.63773, 34.26595], [-118.63661, 34.26612], [-118.63614, 34.26631], [-118.6356, 34.26704], [-118.6354, 34.2672], [-118.63532, 34.26713], [-118.6356, 34.26688], [-118.6357, 34.26676], [-118.63579, 34.26662], [-118.63588, 34.26636], [-118.63591, 34.26604], [-118.63594, 34.26588], [-118.636, 34.26574], [-118.63609, 34.2656], [-118.63624, 34.26544], [-118.63642, 34.2653], [-118.63663, 34.2652], [-118.63687, 34.26513], [-118.63725, 34.26529], [-118.63763, 34.2653], [-118.63817, 34.26541], [-118.6387, 34.26529], [-118.64734, 34.26629], [-118.64784, 34.26632], [-118.6482, 34.26631], [-118.64863, 34.26625], [-118.64905, 34.26617], [-118.64946, 34.26604], [-118.64985, 34.26589], [-118.65022, 34.26569], [-118.65061, 34.26543], [-118.65172, 34.26447], [-118.65208, 34.26407], [-118.65307, 34.2632], [-118.65352, 34.26283], [-118.65404, 34.26249], [-118.65457, 34.26292], [-118.65468, 34.26296], [-118.65481, 34.26299], [-118.65467, 34.26301], [-118.65448, 34.26298], [-118.6544, 34.26301], [-118.65435, 34.26305], [-118.65433, 34.2631], [-118.65433, 34.26316], [-118.65435, 34.2632], [-118.65288, 34.26389], [-118.65203, 34.26446], [-118.65231, 34.26447], [-118.65299, 34.26403], [-118.65496, 34.2631], [-118.65568, 34.26311], [-118.65571, 34.26352], [-118.65601, 34.26352], [-118.65602, 34.26311], [-118.65619, 34.26311], [-118.65614, 34.26652], [-118.6561, 34.26669], [-118.65643, 34.26684], [-118.65636, 34.26696], [-118.65626, 34.2677], [-118.65595, 34.26774], [-118.65595, 34.26944], [-118.6562, 34.26962], [-118.6563, 34.26981], [-118.65688, 34.27019], [-118.65701, 34.27046], [-118.65718, 34.27077], [-118.65734, 34.27095], [-118.6567, 34.2711], [-118.65679, 34.2714], [-118.65666, 34.27168], [-118.65762, 34.27232]]]]} | Open Access 1 | Corriganville Park | http://www.rsrpd.org/park/corrignavilleparkandtrail/corrignavilleparkandtrail.html | 8979 | 2117 | Rancho Simi Open Space Conservation Agency 342 | Special District 4 | Open Space District 6 | Special District 4 | 178.619 | Corriganville Park | ||
15225 | 15225 | 15224 | {"type": "MultiPolygon", "coordinates": [[[[-118.63435, 34.26451], [-118.63268, 34.26432], [-118.63255, 34.26343], [-118.63255, 34.26335], [-118.63296, 34.26341], [-118.633, 34.26352], [-118.63309, 34.26362], [-118.63412, 34.26439], [-118.63421, 34.26445], [-118.63435, 34.26451]]], [[[-118.63408, 34.26421], [-118.63317, 34.26354], [-118.63313, 34.26349], [-118.6331, 34.26343], [-118.63408, 34.26421]]], [[[-118.64241, 34.26544], [-118.63966, 34.26513], [-118.63966, 34.26513], [-118.64074, 34.26487], [-118.64116, 34.26472], [-118.6416, 34.26474], [-118.64193, 34.26496], [-118.64241, 34.26544]]], [[[-118.65257, 34.26332], [-118.65037, 34.26526], [-118.65009, 34.26548], [-118.64982, 34.26565], [-118.64952, 34.2658], [-118.64915, 34.26594], [-118.64882, 34.26603], [-118.64848, 34.26609], [-118.6482, 34.26612], [-118.64791, 34.26612], [-118.64756, 34.2661], [-118.64751, 34.2661], [-118.64747, 34.26603], [-118.64283, 34.26549], [-118.64348, 34.26536], [-118.64388, 34.2654], [-118.64427, 34.26536], [-118.645, 34.26547], [-118.64542, 34.26537], [-118.64602, 34.26547], [-118.64696, 34.26521], [-118.64777, 34.26569], [-118.64823, 34.2657], [-118.64884, 34.26588], [-118.64935, 34.26581], [-118.64963, 34.26569], [-118.64982, 34.26558], [-118.65069, 34.2649], [-118.65252, 34.26328], [-118.65257, 34.26332]]], [[[-118.66075, 34.27569], [-118.66053, 34.27645], [-118.66044, 34.27711], [-118.66003, 34.27729], [-118.65944, 34.27707], [-118.65914, 34.27686], [-118.6588, 34.2768], [-118.65854, 34.27652], [-118.65859, 34.27631], [-118.65852, 34.27578], [-118.65856, 34.27569], [-118.65875, 34.27573], [-118.65911, 34.27539], [-118.65935, 34.27507], [-118.65964, 34.27529], [-118.65991, 34.27524], [-118.65993, 34.27576], [-118.66075, 34.27569]]]]} | Open Access 1 | Rancho Simi Recreation and Park District | 24178 | 2117 | Rancho Simi Open Space Conservation Agency 342 | Special District 4 | Open Space District 6 | Special District 4 | 18.875 | Rancho Simi Rec. and Park District |
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]);