superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 4 and PARK_NAME = "Gonzales Canyon Open Space"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14357 | 14357 | 14356 | {"type": "MultiPolygon", "coordinates": [[[[-117.23183, 32.97224], [-117.23171, 32.9731], [-117.23165, 32.97331], [-117.23154, 32.97356], [-117.23138, 32.97382], [-117.2312, 32.97403], [-117.23103, 32.97419], [-117.23061, 32.97453], [-117.22579, 32.97445], [-117.22575, 32.97532], [-117.22527, 32.97542], [-117.22479, 32.97545], [-117.22336, 32.97535], [-117.22335, 32.97529], [-117.22318, 32.97522], [-117.22319, 32.97504], [-117.22318, 32.97489], [-117.22313, 32.97473], [-117.22306, 32.97457], [-117.22308, 32.9744], [-117.22327, 32.97441], [-117.22328, 32.97439], [-117.22282, 32.97395], [-117.22228, 32.97375], [-117.22098, 32.97375], [-117.22029, 32.97315], [-117.22079, 32.97305], [-117.22107, 32.97275], [-117.22159, 32.97255], [-117.22172, 32.97279], [-117.22252, 32.97286], [-117.22284, 32.97269], [-117.22288, 32.9722], [-117.22307, 32.97217], [-117.22341, 32.97204], [-117.22353, 32.97203], [-117.22366, 32.97204], [-117.22378, 32.97207], [-117.22418, 32.97227], [-117.2243, 32.97235], [-117.22446, 32.97241], [-117.22461, 32.97244], [-117.22489, 32.97245], [-117.22501, 32.97243], [-117.22571, 32.97234], [-117.22578, 32.97234], [-117.22582, 32.97236], [-117.22563, 32.97261], [-117.22551, 32.97274], [-117.2255, 32.97287], [-117.22553, 32.97293], [-117.22554, 32.97305], [-117.22546, 32.97315], [-117.22547, 32.9732], [-117.22558, 32.97327], [-117.22568, 32.97344], [-117.22571, 32.97344], [-117.22574, 32.97353], [-117.22574, 32.97364], [-117.22567, 32.97385], [-117.22564, 32.9741], [-117.22558, 32.97415], [-117.22564, 32.97419], [-117.22569, 32.97417], [-117.22598, 32.97416], [-117.22618, 32.97406], [-117.22634, 32.97394], [-117.2264, 32.97385], [-117.22649, 32.97377], [-117.22663, 32.97369], [-117.22663, 32.9735], [-117.22694, 32.97317], [-117.22707, 32.9731], [-117.22784, 32.97252], [-117.22799, 32.97246], [-117.22813, 32.97245], [-117.22827, 32.97248], [-117.2288, 32.97284], [-117.22891, 32.97289], [-117.22903, 32.97293], [-117.229, 32.97302], [-117.22915, 32.97332], [-117.22914, 32.97369], [-117.22922, 32.97378], [-117.23011, 32.97371], [-117.23035, 32.97361], [-117.23048, 32.97349], [-117.23051, 32.97336], [-117.23045, 32.97309], [-117.22969, 32.97281], [-117.22971, 32.97275], [-117.22969, 32.97269], [-117.22965, 32.97264], [-117.22959, 32.97261], [-117.2295, 32.9726], [-117.22941, 32.97264], [-117.22937, 32.97269], [-117.22935, 32.97279], [-117.22931, 32.97282], [-117.22907, 32.97283], [-117.22897, 32.9728], [-117.22887, 32.97276], [-117.22842, 32.97244], [-117.22841, 32.97202], [-117.2288, 32.97183], [-117.22885, 32.97175], [-117.22854, 32.97148], [-117.22822, 32.97131], [-117.22803, 32.97129], [-117.2278, 32.97141], [-117.22774, 32.97183], [-117.22763, 32.97207], [-117.22761, 32.97236], [-117.22749, 32.97253], [-117.22755, 32.9726], [-117.22698, 32.97303], [-117.22682, 32.97309], [-117.22671, 32.97309], [-117.22661, 32.97307], [-117.22653, 32.97303], [-117.22646, 32.97297], [-117.22613, 32.9724], [-117.22615, 32.97229], [-117.22614, 32.97222], [-117.22609, 32.97217], [-117.22603, 32.97214], [-117.2259, 32.97215], [-117.22578, 32.97224], [-117.22478, 32.97234], [-117.2246, 32.97232], [-117.22444, 32.97228], [-117.22387, 32.97199], [-117.22365, 32.97193], [-117.22351, 32.97192], [-117.22338, 32.97194], [-117.22303, 32.97206], [-117.22285, 32.97208], [-117.22319, 32.97186], [-117.22336, 32.97177], [-117.22311, 32.97124], [-117.22338, 32.97089], [-117.22341, 32.97081], [-117.22341, 32.97073], [-117.22336, 32.97061], [-117.22315, 32.97039], [-117.22309, 32.97007], [-117.22307, 32.97005], [-117.22299, 32.97001], [-117.22288, 32.97001], [-117.22271, 32.97006], [-117.22239, 32.96995], [-117.22206, 32.96998], [-117.22175, 32.97018], [-117.22152, 32.97057], [-117.22128, 32.97074], [-117.22115, 32.97089], [-117.2208, 32.97049], [-117.22041, 32.96988], [-117.22048, 32.96981], [-117.2205, 32.96967], [-117.22035, 32.96947], [-117.21995, 32.96928], [-117.21934, 32.96944], [-117.21906, 32.96923], [-117.21884, 32.96923], [-117.21798, 32.96929], [-117.21749, 32.96927], [-117.21714, 32.9695], [-117.21673, 32.96945], [-117.21665, 32.96949], [-117.21615, 32.96942], [-117.21602, 32.96949], [-117.2155, 32.96944], [-117.21531, 32.96957], [-117.2152, 32.96956], [-117.21509, 32.96952], [-117.21446, 32.96916], [-117.21415, 32.96923], [-117.21409, 32.96922], [-117.21366, 32.97006], [-117.21369, 32.97044], [-117.21353, 32.97057], [-117.21333, 32.97114], [-117.21331, 32.97141], [-117.21323, 32.97147], [-117.21317, 32.97159], [-117.21308, 32.97168], [-117.21305, 32.97177], [-117.21302, 32.9718], [-117.21263, 32.97213], [-117.21258, 32.97226], [-117.21252, 32.97225], [-117.21208, 32.97209], [-117.21215, 32.97133], [-117.21194, 32.97123], [-117.21144, 32.97163], [-117.21127, 32.97171], [-117.21122, 32.9718], [-117.21091, 32.9717], [-117.2108, 32.9716], [-117.2108, 32.97149], [-117.21103, 32.97134], [-117.21118, 32.97097], [-117.21126, 32.97073], [-117.2117, 32.97014], [-117.21174, 32.97007], [-117.21176, 32.96997], [-117.21174, 32.96986], [-117.21167, 32.96975], [-117.21157, 32.96967], [-117.21157, 32.96963], [-117.21167, 32.9696], [-117.21173, 32.96953], [-117.21179, 32.96955], [-117.21207, 32.96949], [-117.21225, 32.96927], [-117.21217, 32.96907], [-117.21194, 32.96895], [-117.21063, 32.96895], [-117.21017, 32.96892], [-117.21007, 32.96893], [-117.20998, 32.96876], [-117.21005, 32.9687], [-117.21004, 32.96841], [-117.20946, 32.96838], [-117.20934, 32.96836], [-117.20928, 32.96837], [-117.20923, 32.9684], [-117.20919, 32.96845], [-117.20918, 32.9685], [-117.2087, 32.96848], [-117.20868, 32.96668], [-117.20736, 32.96662], [-117.20698, 32.96655], [-117.20648, 32.96638], [-117.20612, 32.96638], [-117.20518, 32.96555], [-117.20457, 32.96496], [-117.20445, 32.96475], [-117.20435, 32.9643], [-117.2043, 32.96377], [-117.20429, 32.96319], [-117.20638, 32.96324], [-117.20587, 32.96379], [-117.20594, 32.96406], [-117.20614, 32.96425], [-117.20676, 32.96418], [-117.20727, 32.96437], [-117.20736, 32.96421], [-117.20749, 32.96436], [-117.20761, 32.96456], [-117.20742, 32.96477], [-117.20758, 32.96493], [-117.20738, 32.96526], [-117.20755, 32.96555], [-117.20762, 32.96587], [-117.20786, 32.96586], [-117.20798, 32.96573], [-117.20817, 32.96557], [-117.2084, 32.96558], [-117.20879, 32.96553], [-117.20898, 32.96522], [-117.20872, 32.96504], [-117.20866, 32.96497], [-117.20913, 32.96478], [-117.20939, 32.96465], [-117.20958, 32.96452], [-117.20972, 32.96455], [-117.20986, 32.96463], [-117.21013, 32.96496], [-117.21059, 32.96535], [-117.21056, 32.96549], [-117.21085, 32.96573], [-117.2111, 32.966], [-117.21149, 32.96612], [-117.21222, 32.96611], [-117.21222, 32.96584], [-117.21243, 32.96579], [-117.21267, 32.96567], [-117.21271, 32.96566], [-117.21275, 32.96568], [-117.21296, 32.96588], [-117.21317, 32.96601], [-117.21414, 32.96637], [-117.21437, 32.96641], [-117.2146, 32.96643], [-117.21482, 32.96641], [-117.21505, 32.96636], [-117.21521, 32.96629], [-117.21536, 32.96621], [-117.21585, 32.96589], [-117.21598, 32.96578], [-117.21606, 32.96567], [-117.21612, 32.96556], [-117.21622, 32.96527], [-117.21627, 32.96506], [-117.2163, 32.96475], [-117.21628, 32.96444], [-117.21624, 32.96424], [-117.21605, 32.96353], [-117.21598, 32.96337], [-117.21588, 32.96321], [-117.21576, 32.96308], [-117.21559, 32.96294], [-117.21567, 32.96287], [-117.21633, 32.96284], [-117.2162, 32.96248], [-117.21621, 32.96242], [-117.21618, 32.96237], [-117.21623, 32.96233], [-117.21618, 32.96184], [-117.21605, 32.96155], [-117.21597, 32.96153], [-117.21597, 32.96148], [-117.21594, 32.96144], [-117.21598, 32.96139], [-117.21587, 32.96092], [-117.21593, 32.96058], [-117.21588, 32.9604], [-117.21554, 32.96028], [-117.21542, 32.96018], [-117.2154, 32.96002], [-117.21552, 32.95948], [-117.21607, 32.95938], [-117.21632, 32.95932], [-117.21633, 32.95985], [-117.21711, 32.95987], [-117.2171, 32.96004], [-117.21719, 32.96033], [-117.21719, 32.96057], [-117.21706, 32.96078], [-117.21709, 32.96098], [-117.21743, 32.9612], [-117.21714, 32.96142], [-117.21706, 32.96155], [-117.21724, 32.9618], [-117.21739, 32.9619], [-117.21751, 32.96208], [-117.2176, 32.96226], [-117.21774, 32.96234], [-117.21762, 32.96253], [-117.21741, 32.96273], [-117.21751, 32.96298], [-117.21741, 32.96321], [-117.21754, 32.96344], [-117.21772, 32.96366], [-117.21761, 32.96389], [-117.21762, 32.96409], [-117.21772, 32.96428], [-117.21779, 32.96447], [-117.2178, 32.96468], [-117.21773, 32.96504], [-117.21761, 32.96545], [-117.21757, 32.96576], [-117.21758, 32.96598], [-117.21771, 32.96625], [-117.21792, 32.9663], [-117.21802, 32.96636], [-117.21808, 32.96652], [-117.21815, 32.96656], [-117.21844, 32.96653], [-117.21867, 32.96659], [-117.21883, 32.96635], [-117.21872, 32.96559], [-117.21888, 32.96541], [-117.21892, 32.96518], [-117.2189, 32.96471], [-117.21884, 32.9645], [-117.21891, 32.96423], [-117.2192, 32.96391], [-117.21921, 32.96369], [-117.21856, 32.96324], [-117.21865, 32.96282], [-117.21879, 32.96272], [-117.21886, 32.96248], [-117.21884, 32.9624], [-117.21884, 32.96215], [-117.2189, 32.96193], [-117.21882, 32.96161], [-117.219, 32.96094], [-117.21859, 32.96069], [-117.21864, 32.96003], [-117.2186, 32.95989], [-117.21866, 32.95976], [-117.21887, 32.95963], [-117.2192, 32.95954], [-117.21925, 32.95948], [-117.21921, 32.9593], [-117.21914, 32.95917], [-117.21913, 32.95888], [-117.21917, 32.95862], [-117.21926, 32.9584], [-117.21968, 32.95836], [-117.21976, 32.9589], [-117.2208, 32.95996], [-117.22137, 32.95997], [-117.22147, 32.96019], [-117.22155, 32.96023], [-117.22164, 32.96053], [-117.22173, 32.9606], [-117.22204, 32.96071], [-117.22213, 32.96085], [-117.22206, 32.96114], [-117.22214, 32.96123], [-117.22238, 32.96127], [-117.22232, 32.96167], [-117.22246, 32.96185], [-117.22264, 32.9619], [-117.2227, 32.96202], [-117.2228, 32.96208], [-117.22282, 32.96235], [-117.22297, 32.96274], [-117.22309, 32.96291], [-117.22329, 32.96289], [-117.22348, 32.96253], [-117.22347, 32.96243], [-117.22327, 32.96226], [-117.22318, 32.96207], [-117.22311, 32.96144], [-117.22346, 32.96129], [-117.22342, 32.96106], [-117.22306, 32.96063], [-117.22307, 32.95999], [-117.22441, 32.96], [-117.22461, 32.96031], [-117.22477, 32.96043], [-117.22495, 32.96053], [-117.22513, 32.96083], [-117.22534, 32.96112], [-117.2256, 32.96119], [-117.22585, 32.96163], [-117.22597, 32.96177], [-117.22618, 32.96208], [-117.22659, 32.9619], [-117.22677, 32.962], [-117.22692, 32.9623], [-117.22697, 32.96235], [-117.22697, 32.96266], [-117.22685, 32.96276], [-117.22683, 32.96283], [-117.22696, 32.96292], [-117.22703, 32.96301], [-117.22696, 32.96321], [-117.2269, 32.96364], [-117.22612, 32.96365], [-117.2261, 32.96716], [-117.22754, 32.9672], [-117.22754, 32.96761], [-117.2278, 32.96783], [-117.22907, 32.96789], [-117.22959, 32.96861], [-117.22611, 32.96855], [-117.22609, 32.97079], [-117.23034, 32.97084], [-117.23033, 32.97172], [-117.23086, 32.9723], [-117.23183, 32.97224]]], [[[-117.22275, 32.97479], [-117.22271, 32.9753], [-117.22124, 32.97523], [-117.22073, 32.97516], [-117.22025, 32.97502], [-117.21903, 32.97453], [-117.2187, 32.97443], [-117.21835, 32.97436], [-117.21805, 32.97433], [-117.21776, 32.97432], [-117.21659, 32.97434], [-117.21624, 32.97437], [-117.21583, 32.97445], [-117.21544, 32.97456], [-117.21512, 32.97469], [-117.21414, 32.97515], [-117.21387, 32.97526], [-117.21179, 32.97587], [-117.21132, 32.97606], [-117.21106, 32.97619], [-117.21083, 32.97634], [-117.20848, 32.978], [-117.20806, 32.97724], [-117.20997, 32.97461], [-117.20984, 32.97413], [-117.21017, 32.97413], [-117.21048, 32.97409], [-117.21071, 32.97393], [-117.21083, 32.97394], [-117.21099, 32.97392], [-117.21101, 32.974], [-117.21149, 32.97399], [-117.2116, 32.97403], [-117.21201, 32.9739], [-117.21217, 32.97381], [-117.21233, 32.97365], [-117.21243, 32.97345], [-117.21277, 32.97349], [-117.21312, 32.97383], [-117.21323, 32.97406], [-117.21374, 32.97421], [-117.21398, 32.97421], [-117.21407, 32.97411], [-117.21421, 32.97411], [-117.2143, 32.97402], [-117.21424, 32.97387], [-117.21441, 32.97381], [-117.21444, 32.97376], [-117.21466, 32.97372], [-117.21482, 32.97376], [-117.21494, 32.97368], [-117.21505, 32.97349], [-117.21518, 32.97336], [-117.21526, 32.97332], [-117.21539, 32.97339], [-117.21552, 32.97336], [-117.21573, 32.97336], [-117.2161, 32.97341], [-117.21615, 32.97336], [-117.21635, 32.97342], [-117.21658, 32.97344], [-117.21675, 32.97347], [-117.21679, 32.97346], [-117.21721, 32.9736], [-117.21739, 32.9736], [-117.21751, 32.9737], [-117.21762, 32.97366], [-117.21787, 32.97363], [-117.21829, 32.97362], [-117.21848, 32.97372], [-117.21873, 32.97371], [-117.21908, 32.9738], [-117.2196, 32.97399], [-117.2199, 32.97422], [-117.21991, 32.97434], [-117.22231, 32.97439], [-117.22275, 32.97479]]], [[[-117.21458, 32.9623], [-117.21446, 32.96249], [-117.21425, 32.96254], [-117.21407, 32.96263], [-117.21407, 32.96257], [-117.21398, 32.96249], [-117.21361, 32.96237], [-117.21331, 32.96247], [-117.21317, 32.96271], [-117.21355, 32.9634], [-117.21408, 32.96342], [-117.21425, 32.96356], [-117.2142, 32.96375], [-117.21438, 32.96402], [-117.21435, 32.96411], [-117.21446, 32.96427], [-117.21437, 32.96463], [-117.21429, 32.96469], [-117.21428, 32.96478], [-117.21418, 32.96482], [-117.2142, 32.96496], [-117.21431, 32.96516], [-117.2145, 32.96524], [-117.21444, 32.96544], [-117.21449, 32.96552], [-117.21445, 32.96556], [-117.21443, 32.96562], [-117.21438, 32.96563], [-117.21405, 32.96599], [-117.21397, 32.96613], [-117.21336, 32.96591], [-117.21316, 32.96581], [-117.21297, 32.96566], [-117.21261, 32.96524], [-117.21245, 32.96509], [-117.21219, 32.96492], [-117.21191, 32.96479], [-117.21211, 32.96446], [-117.21179, 32.96428], [-117.21171, 32.96412], [-117.21198, 32.96402], [-117.21198, 32.964], [-117.21161, 32.96379], [-117.2116, 32.96372], [-117.21155, 32.96367], [-117.21145, 32.96365], [-117.21144, 32.96359], [-117.21126, 32.96341], [-117.21126, 32.96335], [-117.21114, 32.96306], [-117.21082, 32.96292], [-117.21076, 32.96294], [-117.2107, 32.96289], [-117.21062, 32.96287], [-117.21062, 32.96262], [-117.21033, 32.96234], [-117.21038, 32.96202], [-117.21007, 32.96201], [-117.21001, 32.96205], [-117.20991, 32.962], [-117.2098, 32.96202], [-117.20981, 32.96183], [-117.21081, 32.96187], [-117.21081, 32.96201], [-117.21093, 32.96211], [-117.21097, 32.9624], [-117.21136, 32.96265], [-117.21147, 32.96284], [-117.21196, 32.96325], [-117.2125, 32.96397], [-117.21262, 32.96402], [-117.21288, 32.96418], [-117.21319, 32.96414], [-117.2135, 32.96408], [-117.21356, 32.96397], [-117.21363, 32.96365], [-117.21345, 32.96341], [-117.21326, 32.9634], [-117.2132, 32.96321], [-117.21313, 32.9632], [-117.21306, 32.96303], [-117.21299, 32.96304], [-117.21293, 32.96282], [-117.2128, 32.96261], [-117.21266, 32.96248], [-117.21289, 32.96218], [-117.21273, 32.96209], [-117.21253, 32.96205], [-117.21278, 32.96185], [-117.21298, 32.96177], [-117.21299, 32.96213], [-117.2135, 32.96213], [-117.21369, 32.96205], [-117.21376, 32.96187], [-117.21393, 32.96182], [-117.21396, 32.96122], [-117.21363, 32.96087], [-117.21335, 32.96078], [-117.21278, 32.9607], [-117.21256, 32.9607], [-117.21256, 32.96041], [-117.21296, 32.96011], [-117.21296, 32.95996], [-117.2132, 32.95993], [-117.21366, 32.95983], [-117.21385, 32.95978], [-117.21404, 32.9597], [-117.21405, 32.9607], [-117.2142, 32.9609], [-117.2142, 32.96125], [-117.21441, 32.96133], [-117.21439, 32.96152], [-117.21443, 32.96196], [-117.21449, 32.96214], [-117.21458, 32.9623]]], [[[-117.23778, 32.97136], [-117.23739, 32.97242], [-117.2349, 32.97402], [-117.23458, 32.97408], [-117.2344, 32.97415], [-117.23391, 32.97421], [-117.23343, 32.97401], [-117.23278, 32.97417], [-117.23236, 32.97417], [-117.23091, 32.97453], [-117.23077, 32.97453], [-117.23099, 32.97439], [-117.23115, 32.97426], [-117.23133, 32.97406], [-117.2315, 32.97384], [-117.23163, 32.9736], [-117.23173, 32.97336], [-117.23181, 32.97311], [-117.23186, 32.97285], [-117.23207, 32.97285], [-117.23292, 32.97274], [-117.23301, 32.97271], [-117.23313, 32.97273], [-117.23325, 32.97271], [-117.23337, 32.97269], [-117.23362, 32.9726], [-117.23383, 32.97255], [-117.23403, 32.97245], [-117.23428, 32.97216], [-117.23432, 32.97206], [-117.23435, 32.97198], [-117.23433, 32.97187], [-117.23426, 32.97179], [-117.23424, 32.97171], [-117.23407, 32.97149], [-117.23387, 32.97149], [-117.23376, 32.97153], [-117.23365, 32.97143], [-117.23354, 32.97126], [-117.23347, 32.97121], [-117.23338, 32.97121], [-117.2331, 32.97113], [-117.23308, 32.97094], [-117.23289, 32.97088], [-117.23273, 32.97091], [-117.23264, 32.97097], [-117.23246, 32.97114], [-117.23232, 32.97123], [-117.23227, 32.97126], [-117.23221, 32.97126], [-117.2321, 32.97088], [-117.23459, 32.97089], [-117.23757, 32.97092], [-117.23778, 32.97136]]]]} | Open Access 1 | Gonzales Canyon Open Space | 31369 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 519.049 | Gonzales Canyon OS |
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]);