superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, ACRES = "3037.424" and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15001 | 15001 | 15000 | {"type": "MultiPolygon", "coordinates": [[[[-116.95037, 33.10964], [-116.95001, 33.11701], [-116.94576, 33.11706], [-116.94101, 33.11703], [-116.93637, 33.11709], [-116.93668, 33.10981], [-116.93671, 33.10608], [-116.9277, 33.10613], [-116.92319, 33.10609], [-116.92315, 33.1024], [-116.9185, 33.10234], [-116.91452, 33.10225], [-116.91451, 33.10227], [-116.91449, 33.10601], [-116.91016, 33.10601], [-116.91016, 33.10809], [-116.91014, 33.11019], [-116.90585, 33.11018], [-116.90581, 33.10592], [-116.90151, 33.10587], [-116.90149, 33.09135], [-116.90576, 33.0914], [-116.90576, 33.08682], [-116.90603, 33.0867], [-116.90623, 33.08665], [-116.90645, 33.08663], [-116.90652, 33.08661], [-116.90657, 33.08656], [-116.90718, 33.08657], [-116.90739, 33.08661], [-116.90763, 33.08671], [-116.90792, 33.08693], [-116.90818, 33.08708], [-116.90851, 33.08718], [-116.90867, 33.08719], [-116.90886, 33.08718], [-116.90901, 33.08717], [-116.90916, 33.08712], [-116.90939, 33.087], [-116.90958, 33.08685], [-116.90973, 33.08671], [-116.91012, 33.08619], [-116.9104, 33.08591], [-116.91054, 33.08581], [-116.91088, 33.08559], [-116.91124, 33.08544], [-116.91147, 33.08543], [-116.91202, 33.0855], [-116.91306, 33.08555], [-116.91336, 33.08564], [-116.91372, 33.0858], [-116.91387, 33.08584], [-116.91412, 33.08587], [-116.91435, 33.08583], [-116.9145, 33.08577], [-116.91461, 33.08571], [-116.91666, 33.0843], [-116.91683, 33.08415], [-116.91695, 33.08397], [-116.91699, 33.08387], [-116.91702, 33.08372], [-116.91702, 33.08361], [-116.91695, 33.08323], [-116.91694, 33.08309], [-116.91698, 33.08297], [-116.91702, 33.0829], [-116.91718, 33.08276], [-116.91728, 33.08272], [-116.91745, 33.08268], [-116.91833, 33.08264], [-116.91851, 33.08264], [-116.91873, 33.0827], [-116.91932, 33.08294], [-116.9196, 33.08301], [-116.91978, 33.08302], [-116.92, 33.083], [-116.92054, 33.08289], [-116.92064, 33.08289], [-116.92084, 33.08293], [-116.92102, 33.08304], [-116.92112, 33.08315], [-116.92118, 33.08331], [-116.92119, 33.08341], [-116.92116, 33.08388], [-116.92118, 33.08397], [-116.92118, 33.08409], [-116.92128, 33.08437], [-116.92136, 33.0845], [-116.92247, 33.08589], [-116.9226, 33.08598], [-116.92282, 33.08608], [-116.92296, 33.08612], [-116.9231, 33.08614], [-116.92325, 33.08613], [-116.92338, 33.08611], [-116.92351, 33.08607], [-116.92411, 33.0858], [-116.92431, 33.08576], [-116.92453, 33.08574], [-116.92525, 33.08578], [-116.92535, 33.0858], [-116.92565, 33.08593], [-116.92656, 33.08653], [-116.92676, 33.08665], [-116.92707, 33.08677], [-116.9276, 33.08691], [-116.92762, 33.09523], [-116.9417, 33.09509], [-116.94152, 33.09872], [-116.94634, 33.09872], [-116.94598, 33.10966], [-116.95037, 33.10964]]], [[[-116.92759, 33.07655], [-116.92744, 33.07995], [-116.92748, 33.0867], [-116.92709, 33.0866], [-116.92684, 33.08649], [-116.92578, 33.08581], [-116.92555, 33.0857], [-116.92531, 33.08563], [-116.92514, 33.08561], [-116.92454, 33.08558], [-116.92436, 33.08559], [-116.9242, 33.08561], [-116.92403, 33.08565], [-116.92389, 33.0857], [-116.92361, 33.08583], [-116.92342, 33.08582], [-116.92327, 33.08589], [-116.92313, 33.0859], [-116.92298, 33.08589], [-116.92285, 33.08584], [-116.92272, 33.08574], [-116.92257, 33.08558], [-116.9224, 33.08551], [-116.92144, 33.08427], [-116.92136, 33.08403], [-116.92135, 33.08388], [-116.92138, 33.08338], [-116.92137, 33.08327], [-116.9213, 33.08309], [-116.92112, 33.08288], [-116.92092, 33.08278], [-116.9206, 33.08272], [-116.92044, 33.08274], [-116.91994, 33.08284], [-116.91976, 33.08285], [-116.91957, 33.08284], [-116.91934, 33.08277], [-116.91873, 33.08253], [-116.91846, 33.08247], [-116.91745, 33.08251], [-116.91726, 33.08255], [-116.91705, 33.08263], [-116.91698, 33.08268], [-116.91683, 33.08284], [-116.91676, 33.08304], [-116.91675, 33.08318], [-116.91683, 33.08362], [-116.91682, 33.08374], [-116.91678, 33.0839], [-116.91666, 33.08407], [-116.91654, 33.08417], [-116.91437, 33.08565], [-116.91421, 33.08569], [-116.91393, 33.08569], [-116.91341, 33.08547], [-116.91308, 33.08539], [-116.91204, 33.08534], [-116.91147, 33.08526], [-116.91131, 33.08526], [-116.91117, 33.08529], [-116.91099, 33.08535], [-116.91082, 33.08544], [-116.91063, 33.08554], [-116.91037, 33.08571], [-116.91002, 33.08603], [-116.90967, 33.08649], [-116.90939, 33.08678], [-116.90915, 33.08694], [-116.909, 33.08699], [-116.90884, 33.08702], [-116.90872, 33.08703], [-116.90857, 33.08701], [-116.90828, 33.08692], [-116.90805, 33.08681], [-116.90773, 33.08657], [-116.90745, 33.08645], [-116.90734, 33.08643], [-116.90718, 33.08641], [-116.90621, 33.08639], [-116.90593, 33.08641], [-116.90576, 33.08644], [-116.90575, 33.0799], [-116.90994, 33.07988], [-116.91005, 33.07638], [-116.91005, 33.07606], [-116.91406, 33.07609], [-116.91386, 33.07229], [-116.91884, 33.07241], [-116.91859, 33.07623], [-116.92759, 33.07655]]], [[[-117.00447, 33.07327], [-117.00428, 33.07335], [-117.00391, 33.0734], [-117.0033, 33.0736], [-117.00314, 33.07361], [-117.00277, 33.07356], [-117.00262, 33.07357], [-117.00247, 33.0736], [-117.00222, 33.07371], [-117.00187, 33.07398], [-117.00168, 33.07406], [-116.99795, 33.07481], [-116.99298, 33.07587], [-116.99275, 33.07315], [-117.0015, 33.0732], [-117.00268, 33.07324], [-117.00447, 33.07327]]], [[[-117.02308, 33.06956], [-117.02299, 33.07945], [-117.02171, 33.07996], [-117.02157, 33.08027], [-117.02148, 33.08038], [-117.02131, 33.08048], [-117.0211, 33.08052], [-117.021, 33.08078], [-117.02098, 33.08104], [-117.02087, 33.08151], [-117.02058, 33.08183], [-117.02023, 33.08195], [-117.02, 33.082], [-117.0199, 33.082], [-117.01977, 33.08196], [-117.0197, 33.08199], [-117.01965, 33.08209], [-117.01968, 33.08219], [-117.01995, 33.08269], [-117.02011, 33.08289], [-117.02012, 33.08294], [-117.02009, 33.08299], [-117.01998, 33.08309], [-117.01997, 33.08344], [-117.01993, 33.08354], [-117.01937, 33.0841], [-117.01926, 33.08415], [-117.01916, 33.08416], [-117.01906, 33.08415], [-117.01871, 33.08401], [-117.0183, 33.08373], [-117.01789, 33.08335], [-117.01771, 33.08323], [-117.01724, 33.08311], [-117.01714, 33.08303], [-117.01707, 33.08292], [-117.01696, 33.08292], [-117.01595, 33.08279], [-117.01568, 33.08269], [-117.01554, 33.08265], [-117.01535, 33.08251], [-117.0153, 33.08242], [-117.01516, 33.08229], [-117.01512, 33.08218], [-117.01513, 33.0816], [-117.01516, 33.08156], [-117.01516, 33.08152], [-117.01513, 33.08149], [-117.01494, 33.08147], [-117.01476, 33.08143], [-117.01466, 33.08137], [-117.01443, 33.0813], [-117.01426, 33.0812], [-117.01388, 33.08075], [-117.01384, 33.08066], [-117.01381, 33.08047], [-117.01375, 33.08043], [-117.01361, 33.08027], [-117.01352, 33.08009], [-117.01327, 33.07982], [-117.01322, 33.0797], [-117.01315, 33.07961], [-117.01304, 33.0794], [-117.01294, 33.0793], [-117.01282, 33.07923], [-117.01272, 33.07911], [-117.01263, 33.07893], [-117.0126, 33.07868], [-117.01257, 33.07864], [-117.01229, 33.0786], [-117.01205, 33.0785], [-117.01195, 33.0785], [-117.01184, 33.07846], [-117.01168, 33.07836], [-117.01156, 33.0782], [-117.01151, 33.07816], [-117.01123, 33.07814], [-117.01107, 33.07807], [-117.01059, 33.07792], [-117.01029, 33.07778], [-117.01021, 33.07771], [-117.00983, 33.07751], [-117.00957, 33.07739], [-117.00928, 33.07731], [-117.00907, 33.07721], [-117.00899, 33.07725], [-117.00878, 33.07724], [-117.00873, 33.0772], [-117.00872, 33.07716], [-117.00864, 33.07713], [-117.00856, 33.07704], [-117.00848, 33.07702], [-117.00829, 33.07701], [-117.00826, 33.07694], [-117.00827, 33.0768], [-117.00824, 33.07677], [-117.00818, 33.07678], [-117.0081, 33.07691], [-117.00802, 33.07692], [-117.00769, 33.07666], [-117.00747, 33.07656], [-117.00739, 33.07649], [-117.00721, 33.07651], [-117.00699, 33.07641], [-117.00681, 33.07642], [-117.00665, 33.07637], [-117.0066, 33.07637], [-117.00647, 33.07646], [-117.00641, 33.07648], [-117.00621, 33.07647], [-117.00612, 33.07649], [-117.00602, 33.07649], [-117.0059, 33.07653], [-117.00579, 33.07652], [-117.00553, 33.07643], [-117.00525, 33.07639], [-117.00515, 33.07636], [-117.00503, 33.07626], [-117.00456, 33.07599], [-117.00453, 33.07592], [-117.00451, 33.07589], [-117.00436, 33.07587], [-117.00368, 33.0759], [-117.00365, 33.07593], [-117.00365, 33.07599], [-117.00361, 33.07604], [-117.00325, 33.07624], [-117.00312, 33.07626], [-117.00295, 33.07633], [-117.00285, 33.07652], [-117.00274, 33.0765], [-117.0027, 33.07647], [-117.00267, 33.0764], [-117.0026, 33.07638], [-117.00231, 33.07646], [-117.00221, 33.07648], [-117.00207, 33.07658], [-117.00199, 33.07661], [-117.00191, 33.07661], [-117.00166, 33.07657], [-117.00161, 33.07654], [-117.00159, 33.0765], [-117.00159, 33.07635], [-117.00154, 33.07622], [-117.00156, 33.07617], [-117.00155, 33.07613], [-117.00136, 33.07599], [-117.00128, 33.07597], [-117.00109, 33.07605], [-117.00087, 33.07601], [-117.0007, 33.07609], [-117.00059, 33.0761], [-117.00057, 33.07611], [-117.00057, 33.07613], [-117.00049, 33.07615], [-117.00052, 33.07623], [-117.00052, 33.07631], [-117.00049, 33.07636], [-117.00039, 33.07647], [-117.00036, 33.07661], [-117.00002, 33.07679], [-116.99993, 33.07682], [-116.99977, 33.07683], [-116.99961, 33.07679], [-116.99952, 33.07675], [-116.99938, 33.07678], [-116.99926, 33.07673], [-116.99887, 33.07679], [-116.99882, 33.07676], [-116.99876, 33.07663], [-116.99872, 33.07659], [-116.99867, 33.07658], [-116.99856, 33.07657], [-116.99846, 33.07652], [-116.99841, 33.07652], [-116.99837, 33.07657], [-116.99836, 33.07694], [-116.99833, 33.077], [-116.9983, 33.07702], [-116.99827, 33.07701], [-116.99825, 33.07696], [-116.99822, 33.07695], [-116.99819, 33.07696], [-116.99819, 33.077], [-116.99815, 33.07703], [-116.99805, 33.07701], [-116.998, 33.07702], [-116.99797, 33.07705], [-116.99795, 33.07709], [-116.99797, 33.07713], [-116.99802, 33.07719], [-116.998, 33.07724], [-116.99794, 33.07726], [-116.99788, 33.07724], [-116.99782, 33.07723], [-116.99767, 33.07728], [-116.9976, 33.07724], [-116.9976, 33.07716], [-116.99758, 33.07712], [-116.99754, 33.07711], [-116.99746, 33.07711], [-116.99742, 33.07708], [-116.9974, 33.07697], [-116.99718, 33.07663], [-116.99702, 33.07647], [-116.9968, 33.07652], [-116.99652, 33.07647], [-116.9963, 33.07624], [-116.99606, 33.07635], [-116.99597, 33.07545], [-116.99723, 33.07514], [-116.99801, 33.07497], [-117.00174, 33.07422], [-117.00196, 33.07413], [-117.0023, 33.07386], [-117.00251, 33.07376], [-117.00275, 33.07373], [-117.00314, 33.07377], [-117.00337, 33.07376], [-117.00399, 33.07355], [-117.00438, 33.07349], [-117.00452, 33.07344], [-117.00472, 33.07332], [-117.00514, 33.07321], [-117.01478, 33.07329], [-117.01479, 33.07322], [-117.01873, 33.07318], [-117.01876, 33.06972], [-117.02308, 33.06956]]]]} | Open Access 1 | San Pasqual Trails Open Space | https://www.sandiego.gov/park-and-recreation/parks/osp/sanpasqual | 30281 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 3037.424 | San Pasqual Trails 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]);