superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
433 rows where MNG_AGENCY = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2459 | 2459 | 2458 | {"type": "Polygon", "coordinates": [[[-117.14983, 32.80583], [-117.14965, 32.80592], [-117.14703, 32.80654], [-117.14602, 32.80681], [-117.14593, 32.80695], [-117.14584, 32.80702], [-117.14523, 32.80722], [-117.14465, 32.80723], [-117.14458, 32.80727], [-117.14457, 32.80722], [-117.14459, 32.8071], [-117.14518, 32.8071], [-117.14575, 32.80693], [-117.14612, 32.80616], [-117.14612, 32.80497], [-117.14743, 32.80496], [-117.1476, 32.80493], [-117.14782, 32.80485], [-117.1497, 32.80486], [-117.14967, 32.80509], [-117.14968, 32.80532], [-117.14972, 32.80558], [-117.14983, 32.80583]]]} | Open Access 1 | Cabrillo Heights Park | 16637 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 13.902 | Cabrillo Heights Park | ||
2473 | 2473 | 2472 | {"type": "Polygon", "coordinates": [[[-117.21749, 32.82093], [-117.21709, 32.82138], [-117.21697, 32.82163], [-117.2168, 32.82176], [-117.21674, 32.82186], [-117.21633, 32.82206], [-117.21648, 32.82071], [-117.21427, 32.82069], [-117.21428, 32.8206], [-117.21427, 32.82056], [-117.21423, 32.82051], [-117.21421, 32.81996], [-117.21422, 32.81981], [-117.21423, 32.81979], [-117.21426, 32.81977], [-117.21634, 32.81978], [-117.21635, 32.81989], [-117.21704, 32.82037], [-117.21705, 32.8207], [-117.21735, 32.82072], [-117.21749, 32.82093]]]} | Open Access 1 | Cadman Community Park | 16654 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 8.371 | Cadman Community Park | ||
2528 | 2528 | 2527 | {"type": "Polygon", "coordinates": [[[-117.26968, 32.8112], [-117.26934, 32.81128], [-117.2691, 32.81048], [-117.26942, 32.81041], [-117.26968, 32.8112]]]} | Open Access 1 | Calumet Park | https://www.sandiego.gov/park-and-recreation/parks/regional/shoreline/calumet | 16741 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.727 | Calumet Park | |
2606 | 2606 | 2605 | {"type": "Polygon", "coordinates": [[[-117.13567, 32.94024], [-117.13567, 32.94306], [-117.13387, 32.94399], [-117.13387, 32.94545], [-117.13318, 32.9446], [-117.13359, 32.94384], [-117.13294, 32.94339], [-117.13216, 32.9431], [-117.13152, 32.94316], [-117.13122, 32.94329], [-117.13048, 32.94316], [-117.13011, 32.94321], [-117.12927, 32.94056], [-117.12954, 32.94055], [-117.12985, 32.9406], [-117.13002, 32.94067], [-117.13026, 32.94081], [-117.13039, 32.94086], [-117.13076, 32.94096], [-117.13102, 32.94098], [-117.13183, 32.94098], [-117.13245, 32.94104], [-117.13265, 32.94104], [-117.13279, 32.94103], [-117.13299, 32.94098], [-117.13327, 32.94086], [-117.13343, 32.94075], [-117.13373, 32.94044], [-117.13399, 32.94024], [-117.13425, 32.94028], [-117.13567, 32.94024]]]} | Open Access 1 | Canyonside Community Park | 16829 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 42.799 | Canyonside Community Park | ||
2636 | 2636 | 2635 | {"type": "Polygon", "coordinates": [[[-117.22676, 32.9527], [-117.22588, 32.95285], [-117.22586, 32.95277], [-117.22411, 32.95275], [-117.22403, 32.95237], [-117.22398, 32.95223], [-117.22389, 32.95204], [-117.22378, 32.95187], [-117.22352, 32.95164], [-117.22344, 32.95151], [-117.22331, 32.95095], [-117.22333, 32.95092], [-117.22333, 32.95087], [-117.22339, 32.9508], [-117.22344, 32.95078], [-117.22398, 32.95067], [-117.22425, 32.95054], [-117.22444, 32.95067], [-117.22464, 32.95077], [-117.22483, 32.95085], [-117.22503, 32.95091], [-117.225, 32.951], [-117.22502, 32.95123], [-117.22489, 32.95167], [-117.22523, 32.95167], [-117.22525, 32.95175], [-117.22663, 32.95171], [-117.2267, 32.95198], [-117.22674, 32.95221], [-117.22676, 32.9527]]]} | Open Access 1 | Carmel Creek Neighborhood Park | 16867 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 11.522 | Carmel Creek Neighborhood Park | ||
2810 | 2810 | 2809 | {"type": "Polygon", "coordinates": [[[-117.07578, 32.69652], [-117.07547, 32.69674], [-117.07408, 32.69743], [-117.07343, 32.69763], [-117.07348, 32.69548], [-117.07518, 32.69562], [-117.07514, 32.6957], [-117.07578, 32.69652]]]} | Open Access 1 | Cervantes Canyon Open Space | 17091 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 8.579 | Cervantes Canyon OS | ||
2858 | 2858 | 2857 | {"type": "Polygon", "coordinates": [[[-117.26407, 32.8495], [-117.26406, 32.84954], [-117.26397, 32.8496], [-117.26395, 32.84966], [-117.26387, 32.84972], [-117.26384, 32.84976], [-117.26363, 32.84974], [-117.26402, 32.84939], [-117.26407, 32.8495]]]} | Open Access 1 | Charlotte Park | 17149 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.16 | Charlotte Park | ||
2893 | 2893 | 2892 | {"type": "MultiPolygon", "coordinates": [[[[-117.14406, 32.70147], [-117.1438, 32.70178], [-117.14126, 32.70002], [-117.14133, 32.6999], [-117.14168, 32.70003], [-117.14184, 32.70014], [-117.14188, 32.70009], [-117.14205, 32.70014], [-117.14216, 32.70013], [-117.14406, 32.70147]]], [[[-117.14441, 32.70113], [-117.14421, 32.70131], [-117.14265, 32.70025], [-117.14169, 32.69956], [-117.14176, 32.6995], [-117.14179, 32.69934], [-117.14203, 32.69909], [-117.14229, 32.69886], [-117.14423, 32.70023], [-117.14395, 32.70053], [-117.1438, 32.70042], [-117.14375, 32.70045], [-117.14383, 32.70053], [-117.14392, 32.70058], [-117.14392, 32.70062], [-117.14396, 32.70074], [-117.14401, 32.70083], [-117.14441, 32.70113]]]]} | Open Access 1 | Chicano Park | 17188 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 9.129 | Chicano Park | ||
2910 | 2910 | 2909 | {"type": "MultiPolygon", "coordinates": [[[[-117.12268, 32.69609], [-117.12268, 32.69614], [-117.12249, 32.69637], [-117.12228, 32.69652], [-117.12229, 32.69653], [-117.12235, 32.69653], [-117.12235, 32.6967], [-117.1222, 32.69671], [-117.12219, 32.69676], [-117.12202, 32.69676], [-117.12186, 32.6969], [-117.12186, 32.69698], [-117.12172, 32.69714], [-117.12162, 32.69733], [-117.12157, 32.69751], [-117.12156, 32.69763], [-117.12157, 32.69774], [-117.12147, 32.69775], [-117.12133, 32.6969], [-117.12148, 32.69689], [-117.12178, 32.69653], [-117.12199, 32.69636], [-117.12216, 32.69609], [-117.12268, 32.69609]]], [[[-117.12309, 32.69586], [-117.12232, 32.69587], [-117.12232, 32.69552], [-117.12236, 32.69548], [-117.12309, 32.69548], [-117.12309, 32.69586]]], [[[-117.12309, 32.69542], [-117.12291, 32.69542], [-117.12291, 32.69504], [-117.12308, 32.69505], [-117.12309, 32.69542]]]]} | Open Access 1 | Chollas Creek | 17217 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 2.6 | Chollas Creek | ||
2911 | 2911 | 2910 | {"type": "Polygon", "coordinates": [[[-117.07849, 32.74452], [-117.07627, 32.74598], [-117.0752, 32.74594], [-117.0752, 32.74578], [-117.07529, 32.74568], [-117.07585, 32.74567], [-117.07627, 32.74534], [-117.07627, 32.74509], [-117.07705, 32.74508], [-117.07706, 32.74452], [-117.07849, 32.74452]]]} | Open Access 1 | Chollas Creek Open Space | 17218 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 3.97 | Chollas Creek OS | ||
2973 | 2973 | 2972 | {"type": "MultiPolygon", "coordinates": [[[[-117.10036, 32.74598], [-117.10035, 32.74697], [-117.09995, 32.74698], [-117.09994, 32.74763], [-117.09823, 32.74761], [-117.09825, 32.74597], [-117.10036, 32.74598]]], [[[-117.10081, 32.74598], [-117.10079, 32.74726], [-117.10041, 32.74726], [-117.10042, 32.74598], [-117.10081, 32.74598]]]]} | Open Access 1 | City Heights Community Park | 17300 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 9.544 | City Heights Community Park | ||
3005 | 3005 | 3004 | {"type": "Polygon", "coordinates": [[[-117.22285, 32.8178], [-117.22241, 32.81788], [-117.22193, 32.81697], [-117.22193, 32.81697], [-117.22285, 32.8178]]]} | Open Access 1 | Clairemont Open Space | 17377 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.56 | Clairemont OS | ||
3021 | 3021 | 3020 | {"type": "Polygon", "coordinates": [[[-117.1262, 32.70317], [-117.12603, 32.70317], [-117.12603, 32.70279], [-117.12619, 32.70279], [-117.1262, 32.70317]]]} | Open Access 1 | Clay Avenue Mini Park | 17395 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.166 | Clay Avenue MP | ||
3084 | 3084 | 3083 | {"type": "MultiPolygon", "coordinates": [[[[-117.07929, 32.75187], [-117.07928, 32.75306], [-117.07847, 32.75306], [-117.07843, 32.75304], [-117.0784, 32.75299], [-117.07841, 32.75278], [-117.07845, 32.75266], [-117.0786, 32.75249], [-117.07929, 32.75187]]], [[[-117.08357, 32.75155], [-117.08352, 32.75157], [-117.08352, 32.7525], [-117.08356, 32.75252], [-117.08356, 32.75298], [-117.08332, 32.75306], [-117.08317, 32.75308], [-117.08165, 32.75308], [-117.08164, 32.75303], [-117.08042, 32.75302], [-117.0804, 32.75307], [-117.07989, 32.75305], [-117.07986, 32.753], [-117.07987, 32.75272], [-117.0797, 32.7518], [-117.07969, 32.75052], [-117.07966, 32.7505], [-117.07967, 32.74994], [-117.08202, 32.74993], [-117.08204, 32.75], [-117.08346, 32.75002], [-117.08348, 32.75006], [-117.08343, 32.7513], [-117.08356, 32.75132], [-117.08357, 32.75155]]]]} | Open Access 1 | Colina Del Sol Community Park | 17497 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 31.686 | Colina Del Sol Community Park | ||
3234 | 3234 | 3233 | {"type": "Polygon", "coordinates": [[[-117.114, 32.76764], [-117.11347, 32.76865], [-117.1134, 32.76881], [-117.1122, 32.76881], [-117.11218, 32.76848], [-117.11212, 32.76837], [-117.11191, 32.76791], [-117.11225, 32.76784], [-117.11244, 32.76764], [-117.11287, 32.76774], [-117.11346, 32.76764], [-117.114, 32.76764]]]} | Open Access 1 | Eugene Place Open Space | 18748 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 4.521 | Eugene Place OS | ||
3397 | 3397 | 3396 | {"type": "MultiPolygon", "coordinates": [[[[-117.14914, 32.74577], [-117.14898, 32.74577], [-117.14898, 32.74545], [-117.14914, 32.74545], [-117.14914, 32.74577]]], [[[-117.15002, 32.74527], [-117.14961, 32.74527], [-117.14961, 32.74489], [-117.15001, 32.74489], [-117.15002, 32.74527]]], [[[-117.15044, 32.74483], [-117.15027, 32.74483], [-117.15027, 32.74444], [-117.15044, 32.74444], [-117.15044, 32.74483]]]]} | Open Access 1 | Cypress Canyon Open Space | 17871 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.694 | Cypress Canyon OS | ||
3403 | 3403 | 3402 | {"type": "Polygon", "coordinates": [[[-117.05461, 32.80729], [-117.05411, 32.80771], [-117.05225, 32.80659], [-117.05423, 32.80617], [-117.05443, 32.80698], [-117.05448, 32.8071], [-117.05461, 32.80729]]]} | Open Access 1 | Dailard Neighborhood Park | 17891 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 4.634 | Dailard Neighborhood Park | ||
3424 | 3424 | 3423 | {"type": "MultiPolygon", "coordinates": [[[[-117.08886, 32.7368], [-117.0884, 32.73681], [-117.08804, 32.73721], [-117.08804, 32.73773], [-117.08756, 32.73773], [-117.08721, 32.73811], [-117.08675, 32.73849], [-117.08467, 32.74077], [-117.0838, 32.74172], [-117.08371, 32.74173], [-117.08367, 32.74179], [-117.08366, 32.74147], [-117.08364, 32.74146], [-117.08229, 32.7429], [-117.08215, 32.74301], [-117.08172, 32.74331], [-117.08127, 32.74357], [-117.08079, 32.7438], [-117.08024, 32.74402], [-117.07977, 32.74389], [-117.07977, 32.74377], [-117.08001, 32.74374], [-117.08034, 32.74361], [-117.08085, 32.74338], [-117.08124, 32.74317], [-117.08178, 32.74281], [-117.08216, 32.74248], [-117.08578, 32.73851], [-117.087, 32.73677], [-117.08751, 32.73595], [-117.08886, 32.7368]]], [[[-117.09222, 32.72963], [-117.09179, 32.73052], [-117.09168, 32.73053], [-117.09129, 32.73139], [-117.09131, 32.73141], [-117.09114, 32.73172], [-117.09094, 32.73227], [-117.09061, 32.73284], [-117.09046, 32.73327], [-117.08995, 32.73399], [-117.0894, 32.73505], [-117.08909, 32.73506], [-117.08839, 32.73612], [-117.08748, 32.73562], [-117.08787, 32.73504], [-117.08814, 32.73504], [-117.0886, 32.73447], [-117.08892, 32.73408], [-117.08939, 32.73327], [-117.08961, 32.73326], [-117.08981, 32.7327], [-117.0898, 32.73269], [-117.0897, 32.73269], [-117.09144, 32.72963], [-117.09222, 32.72963]]]]} | Open Access 1 | Chollas Parkway Open Space Park | 30096 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 35.025 | Chollas Parkway OS Park | ||
3526 | 3526 | 3525 | {"type": "Polygon", "coordinates": [[[-117.06406, 32.78016], [-117.06333, 32.78013], [-117.06188, 32.77973], [-117.06192, 32.77935], [-117.06341, 32.77979], [-117.06386, 32.77995], [-117.06406, 32.78016]]]} | Open Access 1 | Del Cerro Open Space | 18024 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1.798 | Del Cerro OS | ||
3559 | 3559 | 3558 | {"type": "Polygon", "coordinates": [[[-117.00881, 32.57966], [-117.00877, 32.57945], [-117.00873, 32.5794], [-117.00866, 32.57937], [-117.00856, 32.57938], [-117.00848, 32.57945], [-117.00848, 32.57952], [-117.0085, 32.57956], [-117.00862, 32.57962], [-117.00863, 32.57965], [-117.00559, 32.57952], [-117.00558, 32.57773], [-117.0088, 32.57781], [-117.00881, 32.57966]]]} | Open Access 1 | Dennery Canyon Vernal Pool Reserve | 18086 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 14.897 | Dennery Canyon Vernal Pool Reserve |
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]);