superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
433 rows where MNG_AGENCY = 4 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 4
- Open Access 408
- No Public Access 14
- Restricted Access 10
- Unknown Access 1
MNG_AG_TYP 1
- City Agency 433
MNG_AGENCY 1
- San Diego, City of · 433 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
790 | 790 | 789 | {"type": "Polygon", "coordinates": [[[-117.10185, 32.75039], [-117.10185, 32.75069], [-117.10169, 32.75069], [-117.10169, 32.75039], [-117.10185, 32.75039]]]} | Open Access 1 | City Heights Square Mini Park | 33550 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.123 | City Heights Square MP | ||
783 | 783 | 782 | {"type": "Polygon", "coordinates": [[[-117.10891, 32.76431], [-117.10845, 32.76431], [-117.10847, 32.76337], [-117.10865, 32.76342], [-117.10891, 32.76431]]]} | Open Access 1 | Terrace Drive Mini Park | https://www.sandiego.gov/sites/default/files/adams.pdf | 33549 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.758 | Terrace Drive MP | |
13011 | 13011 | 13010 | {"type": "Polygon", "coordinates": [[[-117.24499, 32.80093], [-117.24419, 32.8011], [-117.24283, 32.80145], [-117.24267, 32.80102], [-117.24251, 32.80051], [-117.24472, 32.80004], [-117.24499, 32.80093]]]} | Restricted Access 2 | Pacific Beach Community Park | 33345 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 5.466 | Pacific Beach Community Park | ||
12243 | 12243 | 12242 | {"type": "Polygon", "coordinates": [[[-117.24522, 32.80169], [-117.24443, 32.80186], [-117.24419, 32.8011], [-117.24499, 32.80093], [-117.24522, 32.80169]]]} | Open Access 1 | Pacific Beach Recreation Center | https://www.sandiego.gov/park-and-recreation/centers/recctr/pacificb | 33225 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1.663 | Pacific Beach Rec. Ctr. | 1975 |
14588 | 14588 | 14587 | {"type": "Polygon", "coordinates": [[[-117.25401, 32.90718], [-117.25377, 32.90874], [-117.25262, 32.90918], [-117.24994, 32.90895], [-117.24795, 32.9092], [-117.24822, 32.91061], [-117.24923, 32.91094], [-117.25048, 32.91053], [-117.25122, 32.91156], [-117.24972, 32.91275], [-117.24806, 32.91462], [-117.24673, 32.91482], [-117.24619, 32.91416], [-117.24559, 32.91286], [-117.24534, 32.91288], [-117.24527, 32.91268], [-117.24423, 32.90787], [-117.24323, 32.90302], [-117.24456, 32.90286], [-117.24504, 32.90278], [-117.245, 32.90244], [-117.24482, 32.90135], [-117.24476, 32.90057], [-117.24393, 32.90056], [-117.24393, 32.89929], [-117.24361, 32.89931], [-117.24339, 32.89538], [-117.24311, 32.89479], [-117.243, 32.89303], [-117.2429, 32.89074], [-117.24398, 32.89061], [-117.24399, 32.89004], [-117.24568, 32.89008], [-117.24849, 32.8908], [-117.2498, 32.89147], [-117.24979, 32.89123], [-117.24893, 32.89001], [-117.24905, 32.88967], [-117.24895, 32.88953], [-117.24912, 32.88945], [-117.24949, 32.88917], [-117.24956, 32.88871], [-117.24948, 32.88821], [-117.24675, 32.88752], [-117.24675, 32.88716], [-117.24929, 32.88716], [-117.24931, 32.88608], [-117.25316, 32.88609], [-117.25325, 32.88745], [-117.25336, 32.8895], [-117.25341, 32.89232], [-117.25347, 32.89308], [-117.25341, 32.89309], [-117.25342, 32.89313], [-117.25326, 32.89416], [-117.25312, 32.89498], [-117.25313, 32.89595], [-117.2531, 32.89605], [-117.25307, 32.89665], [-117.25207, 32.8971], [-117.24992, 32.89617], [-117.24919, 32.89482], [-117.24868, 32.89411], [-117.2478, 32.89401], [-117.24696, 32.89484], [-117.24697, 32.89486], [-117.24824, 32.89499], [-117.2483, 32.89632], [-117.24733, 32.89744], [-117.24658, 32.89793], [-117.24675, 32.89866], [-117.248, 32.89905], [-117.24715, 32.90057], [-117.24715, 32.90062], [-117.24882, 32.90056], [-117.24967, 32.89857], [-117.25065, 32.89747], [-117.25183, 32.89836], [-117.25235, 32.90141], [-117.25196, 32.90284], [-117.25085, 32.90429], [-117.24791, 32.90569], [-117.24852, 32.90688], [-117.24931, 32.9069], [-117.2531, 32.90488], [-117.2532, 32.90552], [-117.25401, 32.90718]]]} | Restricted Access 2 | Torrey Pines Golf Course | 33030 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 484.297 | Torrey Pines GC | ||
906 | 906 | 905 | {"type": "Polygon", "coordinates": [[[-117.13176, 32.74788], [-117.13144, 32.74787], [-117.13143, 32.74774], [-117.13112, 32.74774], [-117.13112, 32.74748], [-117.13176, 32.74748], [-117.13176, 32.74788]]]} | Open Access 1 | North Park Mini Park | 32786 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.542 | North Park MP | ||
900 | 900 | 899 | {"type": "Polygon", "coordinates": [[[-117.10221, 32.74023], [-117.10218, 32.74028], [-117.10205, 32.74034], [-117.10185, 32.74036], [-117.10159, 32.74049], [-117.10145, 32.74039], [-117.10126, 32.74023], [-117.10127, 32.74021], [-117.10155, 32.74023], [-117.10183, 32.74022], [-117.10184, 32.74017], [-117.10194, 32.74014], [-117.10197, 32.74004], [-117.10219, 32.74017], [-117.10221, 32.74023]]]} | Open Access 1 | Manzanita Gathering Place | http://rootedinplace.com/portfolio-items/manzanita-gathering-place/ | 32782 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.446 | Manzanita Gathering Place | 2013 |
905 | 905 | 904 | {"type": "Polygon", "coordinates": [[[-117.04738, 32.55364], [-117.04717, 32.55399], [-117.04686, 32.55386], [-117.04707, 32.55351], [-117.04738, 32.55364]]]} | Open Access 1 | San Ysidro Mini Park | 32781 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.353 | San Ysidro MP | ||
6243 | 6243 | 6242 | {"type": "Polygon", "coordinates": [[[-117.13531, 32.80963], [-117.13296, 32.80967], [-117.13295, 32.80886], [-117.13279, 32.80885], [-117.13274, 32.80882], [-117.13263, 32.8087], [-117.13257, 32.80854], [-117.13257, 32.80843], [-117.13265, 32.80792], [-117.13264, 32.80786], [-117.1326, 32.8078], [-117.13254, 32.80778], [-117.13225, 32.80775], [-117.13215, 32.80763], [-117.13295, 32.80762], [-117.13297, 32.80837], [-117.13529, 32.80833], [-117.13531, 32.80963]]]} | No Public Access 3 | City of San Diego Open Space | 32304 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 9.043 | City of San Diego OS | ||
13311 | 13311 | 13310 | {"type": "Polygon", "coordinates": [[[-117.13295, 32.80762], [-117.13215, 32.80763], [-117.13148, 32.80686], [-117.13148, 32.80504], [-117.13293, 32.80505], [-117.13295, 32.80618], [-117.13295, 32.80762]]]} | Open Access 1 | Serra Mesa Recreation Center | 32297 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 9.042 | Serra Mesa Rec. Ctr. | ||
4335 | 4335 | 4334 | {"type": "Polygon", "coordinates": [[[-117.00987, 32.55768], [-117.00557, 32.5576], [-117.00555, 32.56025], [-117.00128, 32.56018], [-117.00126, 32.55751], [-116.99834, 32.55745], [-116.99769, 32.55743], [-116.99699, 32.55743], [-116.99699, 32.55385], [-116.99614, 32.55382], [-116.99588, 32.55353], [-116.99536, 32.55264], [-116.99513, 32.55248], [-116.99481, 32.55243], [-116.99449, 32.55257], [-116.99356, 32.55323], [-116.993, 32.55322], [-116.99287, 32.55313], [-116.99284, 32.55268], [-116.99337, 32.55212], [-116.99346, 32.55187], [-116.99337, 32.55162], [-116.99317, 32.55135], [-116.9927, 32.55115], [-116.99269, 32.55005], [-116.99912, 32.55022], [-116.99914, 32.55327], [-116.99985, 32.5533], [-116.99987, 32.55391], [-117.00986, 32.55413], [-117.00985, 32.55619], [-117.00987, 32.55768]]]} | No Public Access 3 | Otay Mitigation Site | 32285 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 200.109 | Otay Mitigation Site | ||
4331 | 4331 | 4330 | {"type": "Polygon", "coordinates": [[[-117.00123, 32.56466], [-117.00121, 32.56728], [-117.00108, 32.56728], [-117.00106, 32.56732], [-117.00068, 32.56736], [-117.00055, 32.56745], [-117.00053, 32.56778], [-117.00042, 32.56807], [-116.99905, 32.56804], [-116.99908, 32.56463], [-117.00123, 32.56466]]]} | No Public Access 3 | Otay Mesa Open Space | 32281 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 17.649 | Otay Mesa OS | ||
319 | 319 | 318 | {"type": "Polygon", "coordinates": [[[-117.06009, 32.76351], [-117.05994, 32.76363], [-117.05895, 32.76366], [-117.05892, 32.76238], [-117.06004, 32.76235], [-117.06009, 32.76351]]]} | Restricted Access 2 | Clay Elementary School Park | 31950 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 3.7 | Clay Elementary School Park | ||
14360 | 14360 | 14359 | {"type": "MultiPolygon", "coordinates": [[[[-116.87263, 32.64332], [-116.87061, 32.64522], [-116.87029, 32.64505], [-116.87093, 32.64366], [-116.87252, 32.64297], [-116.87263, 32.64332]]], [[[-116.87285, 32.64414], [-116.87285, 32.64414], [-116.87206, 32.64428], [-116.87271, 32.64366], [-116.87285, 32.64414]]], [[[-117.10461, 32.76969], [-117.10445, 32.76969], [-117.10461, 32.76951], [-117.10461, 32.76951], [-117.10461, 32.76969]]], [[[-117.1276, 32.76738], [-117.12717, 32.76784], [-117.12705, 32.76778], [-117.12742, 32.76738], [-117.1276, 32.76738]]], [[[-117.21241, 32.80723], [-117.21239, 32.80731], [-117.21232, 32.80734], [-117.2111, 32.80742], [-117.21111, 32.80697], [-117.21157, 32.80696], [-117.21172, 32.80698], [-117.21219, 32.80709], [-117.21237, 32.80716], [-117.21241, 32.80723]]], [[[-117.21219, 32.80689], [-117.21219, 32.80695], [-117.21195, 32.80689], [-117.21195, 32.80689], [-117.21219, 32.80689]]], [[[-117.23137, 32.88833], [-117.22878, 32.89057], [-117.22879, 32.89385], [-117.22675, 32.89645], [-117.22675, 32.89619], [-117.22725, 32.89552], [-117.22708, 32.8954], [-117.22721, 32.89514], [-117.22753, 32.89435], [-117.22772, 32.89381], [-117.22795, 32.89294], [-117.22797, 32.89271], [-117.22797, 32.89157], [-117.22795, 32.89107], [-117.22798, 32.89083], [-117.22816, 32.89009], [-117.22833, 32.89008], [-117.22872, 32.88902], [-117.22917, 32.88808], [-117.22989, 32.8883], [-117.23011, 32.88786], [-117.23073, 32.88808], [-117.23137, 32.88833]]], [[[-117.23982, 32.87111], [-117.23981, 32.87152], [-117.23927, 32.87152], [-117.23951, 32.87136], [-117.23982, 32.87111]]]]} | No Public Access 3 | Unnamed site - San Diego, City of | 31719 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 27.836 | |||
15002 | 15002 | 15001 | {"type": "Polygon", "coordinates": [[[-117.02305, 32.58558], [-117.01876, 32.58555], [-117.01875, 32.58376], [-117.0148, 32.58373], [-117.01447, 32.58354], [-117.01433, 32.57606], [-117.02242, 32.57628], [-117.0226, 32.57717], [-117.02239, 32.57718], [-117.02228, 32.57717], [-117.02221, 32.57699], [-117.02213, 32.57695], [-117.02176, 32.5769], [-117.02167, 32.57671], [-117.02153, 32.5766], [-117.02143, 32.57654], [-117.02118, 32.57659], [-117.02096, 32.57669], [-117.02085, 32.57684], [-117.02075, 32.57687], [-117.02063, 32.57685], [-117.02049, 32.57678], [-117.02041, 32.57685], [-117.02, 32.57685], [-117.01955, 32.57696], [-117.01934, 32.57699], [-117.01922, 32.57693], [-117.01911, 32.57693], [-117.01877, 32.57699], [-117.01863, 32.57698], [-117.01838, 32.57678], [-117.01823, 32.57676], [-117.01815, 32.57677], [-117.01806, 32.57664], [-117.01786, 32.57655], [-117.01771, 32.57646], [-117.01764, 32.57652], [-117.01738, 32.57666], [-117.01729, 32.57688], [-117.01729, 32.57695], [-117.01734, 32.57704], [-117.01734, 32.57712], [-117.01724, 32.57724], [-117.01741, 32.57755], [-117.01743, 32.57766], [-117.01757, 32.57781], [-117.01759, 32.5779], [-117.01753, 32.57803], [-117.01754, 32.57808], [-117.01758, 32.57815], [-117.01753, 32.5783], [-117.01751, 32.57859], [-117.01752, 32.57881], [-117.01758, 32.579], [-117.01765, 32.57912], [-117.01759, 32.57929], [-117.0176, 32.57938], [-117.01768, 32.57961], [-117.01774, 32.57987], [-117.01776, 32.58027], [-117.01773, 32.58055], [-117.01774, 32.5806], [-117.01785, 32.58072], [-117.01788, 32.58097], [-117.01792, 32.58103], [-117.01836, 32.58133], [-117.01845, 32.58134], [-117.01871, 32.58129], [-117.01878, 32.58128], [-117.01886, 32.58129], [-117.01895, 32.58138], [-117.019, 32.58147], [-117.01903, 32.58159], [-117.01898, 32.58167], [-117.01891, 32.58169], [-117.01868, 32.58167], [-117.01861, 32.5817], [-117.01852, 32.58188], [-117.01845, 32.58196], [-117.0184, 32.58238], [-117.01849, 32.58265], [-117.01846, 32.58281], [-117.0184, 32.58286], [-117.01873, 32.58324], [-117.0189, 32.58348], [-117.01924, 32.58413], [-117.01931, 32.58433], [-117.01953, 32.58434], [-117.01997, 32.58424], [-117.02013, 32.58427], [-117.02021, 32.58425], [-117.02029, 32.58418], [-117.02055, 32.58382], [-117.02049, 32.58355], [-117.02039, 32.58323], [-117.02075, 32.58311], [-117.02081, 32.58306], [-117.02092, 32.58288], [-117.02094, 32.58281], [-117.02118, 32.58291], [-117.02149, 32.58274], [-117.0214, 32.58198], [-117.0211, 32.58161], [-117.02126, 32.58163], [-117.02136, 32.58158], [-117.02176, 32.58159], [-117.02191, 32.58155], [-117.0221, 32.58145], [-117.02217, 32.58145], [-117.02223, 32.58147], [-117.02224, 32.58151], [-117.0222, 32.58162], [-117.02222, 32.58164], [-117.02267, 32.5816], [-117.023, 32.58154], [-117.02305, 32.58379], [-117.02305, 32.58558]]]} | Open Access 1 | Hidden Trails Open Space | 31665 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 106.644 | Hidden Trails OS | ||
14181 | 14181 | 14180 | {"type": "Polygon", "coordinates": [[[-117.22618, 32.91131], [-117.22607, 32.91143], [-117.22564, 32.91165], [-117.22564, 32.91169], [-117.22526, 32.91189], [-117.22514, 32.91179], [-117.22525, 32.91171], [-117.22523, 32.91167], [-117.22541, 32.91125], [-117.22559, 32.91056], [-117.2255, 32.91038], [-117.22554, 32.91037], [-117.22564, 32.91044], [-117.22573, 32.91063], [-117.22576, 32.91084], [-117.22581, 32.91085], [-117.22584, 32.91084], [-117.22605, 32.9111], [-117.22609, 32.91124], [-117.22618, 32.91131]]]} | Open Access 1 | Coast View Mini-Park | 31657 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1.569 | Coast View Mini-Park | ||
14167 | 14167 | 14166 | {"type": "Polygon", "coordinates": [[[-117.0489, 32.67824], [-117.04772, 32.67864], [-117.04697, 32.67911], [-117.04638, 32.67955], [-117.04603, 32.67827], [-117.04596, 32.67806], [-117.04688, 32.67781], [-117.04697, 32.6778], [-117.04698, 32.67778], [-117.04668, 32.67615], [-117.04831, 32.67614], [-117.04833, 32.67636], [-117.04857, 32.67756], [-117.04871, 32.67789], [-117.0489, 32.67824]]]} | Restricted Access 2 | Penn Athletic Field | 31636 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 13.871 | Penn Athletic Field | ||
13053 | 13053 | 13052 | {"type": "Polygon", "coordinates": [[[-117.15766, 32.9055], [-117.15651, 32.90626], [-117.1561, 32.90582], [-117.15673, 32.90517], [-117.15693, 32.90501], [-117.15763, 32.90549], [-117.15766, 32.9055]]]} | Restricted Access 2 | Salk Neighborhood Park | 31627 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 2.341 | Salk Neighborhood Park | ||
13809 | 13809 | 13808 | {"type": "MultiPolygon", "coordinates": [[[[-117.05969, 32.76384], [-117.05963, 32.76392], [-117.05829, 32.76395], [-117.05834, 32.7639], [-117.05835, 32.76382], [-117.05963, 32.76378], [-117.05966, 32.76379], [-117.05969, 32.76384]]], [[[-117.06115, 32.76232], [-117.06114, 32.76248], [-117.06111, 32.76257], [-117.06106, 32.76264], [-117.06009, 32.76351], [-117.06004, 32.76235], [-117.06115, 32.76232]]]]} | Restricted Access 2 | Clay Neighborhood Park | 31592 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 2.412 | Clay Neighborhood Park | ||
13010 | 13010 | 13009 | {"type": "Polygon", "coordinates": [[[-117.02716, 32.57161], [-117.02625, 32.5719], [-117.02589, 32.5711], [-117.02577, 32.57094], [-117.02564, 32.57082], [-117.02547, 32.57071], [-117.02522, 32.5706], [-117.02501, 32.57054], [-117.02477, 32.57052], [-117.02459, 32.57053], [-117.02427, 32.5706], [-117.02399, 32.57074], [-117.02375, 32.57093], [-117.02269, 32.57021], [-117.02263, 32.56916], [-117.02312, 32.56929], [-117.0232, 32.5694], [-117.02325, 32.56944], [-117.02381, 32.56969], [-117.02396, 32.56992], [-117.02418, 32.56988], [-117.02471, 32.56986], [-117.0249, 32.56983], [-117.02503, 32.56978], [-117.02526, 32.56966], [-117.0254, 32.56956], [-117.02554, 32.56942], [-117.02626, 32.56929], [-117.02631, 32.56932], [-117.02656, 32.56937], [-117.02697, 32.56951], [-117.02698, 32.57061], [-117.02715, 32.57064], [-117.02716, 32.57161]]]} | Open Access 1 | Cesar Solis Park | 31542 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 15.469 | Cesar Solis Park | 2018 |
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]);