superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
433 rows where MNG_AGENCY = 4 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_NAME, PARK_URL, ACRES, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12858 | 12858 | 12857 | {"type": "Polygon", "coordinates": [[[-117.28189, 32.83958], [-117.28193, 32.83972], [-117.28192, 32.83996], [-117.28186, 32.84009], [-117.28177, 32.84012], [-117.28183, 32.84005], [-117.28187, 32.83996], [-117.28184, 32.83978], [-117.28186, 32.83966], [-117.28184, 32.8396], [-117.28166, 32.8394], [-117.28178, 32.83935], [-117.28165, 32.83905], [-117.28144, 32.83869], [-117.28137, 32.83828], [-117.28159, 32.83823], [-117.28158, 32.83837], [-117.28163, 32.83853], [-117.28162, 32.83855], [-117.28162, 32.83871], [-117.28165, 32.83879], [-117.28166, 32.83888], [-117.28169, 32.83893], [-117.28172, 32.83915], [-117.28175, 32.83921], [-117.28179, 32.83925], [-117.2818, 32.83933], [-117.28183, 32.83939], [-117.28185, 32.83953], [-117.28189, 32.83958]]]} | Open Access 1 | Nicholson's Point Park | 30083 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.516 | Nicholson's Point Park | ||
12968 | 12968 | 12967 | {"type": "Polygon", "coordinates": [[[-117.28087, 32.84301], [-117.28083, 32.8432], [-117.28076, 32.84327], [-117.28045, 32.84348], [-117.2802, 32.84361], [-117.27997, 32.8438], [-117.27941, 32.8441], [-117.27929, 32.84422], [-117.27922, 32.84424], [-117.27904, 32.84421], [-117.27907, 32.84411], [-117.27939, 32.84394], [-117.27965, 32.84375], [-117.28006, 32.84357], [-117.28036, 32.84341], [-117.28049, 32.84331], [-117.28065, 32.84315], [-117.28083, 32.8429], [-117.28087, 32.84301]]]} | Open Access 1 | Cuvier Park | https://www.sandiego.gov/park-and-recreation/parks/regional/shoreline/cuvier | 30204 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.83 | Cuvier Park | |
12864 | 12864 | 12863 | {"type": "Polygon", "coordinates": [[[-117.28052, 32.82902], [-117.28046, 32.82895], [-117.28037, 32.82891], [-117.28028, 32.82889], [-117.28018, 32.82889], [-117.27954, 32.82622], [-117.27957, 32.82621], [-117.27964, 32.82638], [-117.27975, 32.82669], [-117.27975, 32.82677], [-117.27984, 32.82694], [-117.27988, 32.82704], [-117.28, 32.8272], [-117.27998, 32.8274], [-117.28, 32.82748], [-117.28006, 32.8276], [-117.28007, 32.82775], [-117.28014, 32.82788], [-117.28025, 32.82832], [-117.28032, 32.82845], [-117.28034, 32.82855], [-117.28042, 32.82869], [-117.28042, 32.82876], [-117.28052, 32.82902]]]} | Open Access 1 | La Jolla Strand Park | 30089 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1.184 | La Jolla Strand Park | ||
12832 | 12832 | 12831 | {"type": "Polygon", "coordinates": [[[-117.28011, 32.82509], [-117.28009, 32.82536], [-117.28002, 32.82566], [-117.27999, 32.82612], [-117.27954, 32.82622], [-117.27953, 32.82616], [-117.27953, 32.82584], [-117.27996, 32.82511], [-117.28011, 32.82509]]]} | Open Access 1 | Hermosa Terrace Park | 30053 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.993 | Hermosa Terrace Park | ||
12922 | 12922 | 12921 | {"type": "Polygon", "coordinates": [[[-117.27582, 32.84928], [-117.27579, 32.84933], [-117.27562, 32.84944], [-117.27548, 32.84959], [-117.27529, 32.8496], [-117.27524, 32.84962], [-117.27515, 32.8497], [-117.27499, 32.8497], [-117.27487, 32.84974], [-117.27481, 32.84987], [-117.27466, 32.85002], [-117.27461, 32.85011], [-117.27452, 32.85017], [-117.27446, 32.85031], [-117.27437, 32.85038], [-117.27429, 32.8504], [-117.27422, 32.85045], [-117.27401, 32.85053], [-117.27394, 32.85052], [-117.27363, 32.85067], [-117.27355, 32.85067], [-117.27333, 32.85072], [-117.27323, 32.85076], [-117.27317, 32.85077], [-117.27323, 32.85063], [-117.27321, 32.85053], [-117.27301, 32.85027], [-117.27296, 32.85026], [-117.27282, 32.85018], [-117.273, 32.85018], [-117.2732, 32.85014], [-117.27343, 32.85007], [-117.27384, 32.84984], [-117.27417, 32.84958], [-117.27433, 32.8494], [-117.27444, 32.8492], [-117.27448, 32.84906], [-117.27519, 32.84903], [-117.27553, 32.84894], [-117.27568, 32.84889], [-117.27569, 32.84887], [-117.27577, 32.84884], [-117.27576, 32.84894], [-117.27578, 32.84897], [-117.27576, 32.84903], [-117.27578, 32.84905], [-117.27582, 32.84922], [-117.27582, 32.84928]]]} | Open Access 1 | Ellen Browning Scripps Neighborhood Park | https://www.sandiego.gov/park-and-recreation/parks/regional/shoreline/ebscripps | 30159 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 5.122 | Ellen Browning Scripps Neighborhood Park | |
10839 | 10839 | 10838 | {"type": "Polygon", "coordinates": [[[-117.27442, 32.82285], [-117.27439, 32.82288], [-117.2744, 32.82331], [-117.27434, 32.82333], [-117.27422, 32.82306], [-117.27402, 32.8227], [-117.27427, 32.82259], [-117.27442, 32.82285]]]} | Open Access 1 | Via Del Norte Mini Park | 27065 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.364 | Via Del Norte MP | ||
9922 | 9922 | 9921 | {"type": "Polygon", "coordinates": [[[-117.27336, 32.83015], [-117.27336, 32.83015], [-117.27246, 32.83038], [-117.27278, 32.82957], [-117.27315, 32.8295], [-117.27336, 32.83015]]]} | Open Access 1 | Starkey Mini-Park | 25806 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1.169 | Starkey Mini-Park | ||
13712 | 13712 | 13711 | {"type": "Polygon", "coordinates": [[[-117.27323, 32.85056], [-117.27322, 32.85066], [-117.27317, 32.85074], [-117.27304, 32.85083], [-117.27295, 32.85079], [-117.27295, 32.85077], [-117.27298, 32.85075], [-117.273, 32.85069], [-117.27288, 32.8505], [-117.27277, 32.85041], [-117.27279, 32.85034], [-117.27299, 32.85025], [-117.27317, 32.85046], [-117.27323, 32.85056]]]} | Open Access 1 | La Jolla Cove | http://www.lajollabythesea.com/la-jolla-cove | 31200 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.352 | La Jolla Cove | |
5818 | 5818 | 5817 | {"type": "Polygon", "coordinates": [[[-117.273, 32.81695], [-117.27253, 32.81748], [-117.27252, 32.81747], [-117.27251, 32.81744], [-117.27266, 32.817], [-117.27267, 32.81695], [-117.27265, 32.81686], [-117.27284, 32.81681], [-117.27286, 32.81666], [-117.27291, 32.81663], [-117.273, 32.81695]]]} | Open Access 1 | La Jolla Hermosa Park | 20765 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.384 | La Jolla Hermosa Park | ||
8306 | 8306 | 8305 | {"type": "Polygon", "coordinates": [[[-117.27204, 32.82394], [-117.27142, 32.82407], [-117.27131, 32.82376], [-117.27003, 32.82349], [-117.26893, 32.82328], [-117.26882, 32.82295], [-117.26794, 32.82312], [-117.26812, 32.8227], [-117.26774, 32.82258], [-117.26743, 32.82238], [-117.2686, 32.82167], [-117.26947, 32.82277], [-117.26976, 32.82262], [-117.27094, 32.82258], [-117.27156, 32.82298], [-117.27199, 32.8238], [-117.27204, 32.82394]]]} | Open Access 1 | Soledad Open Space Park | 25598 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 10.293 | Soledad OS Park | ||
12856 | 12856 | 12855 | {"type": "Polygon", "coordinates": [[[-117.27039, 32.84609], [-117.27014, 32.84608], [-117.26993, 32.8462], [-117.27002, 32.84597], [-117.27002, 32.84574], [-117.27016, 32.84595], [-117.27039, 32.84609]]]} | Open Access 1 | Union Place Circle Mini-Park | 30081 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.154 | Union Place Circle Mini-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 | |
10415 | 10415 | 10414 | {"type": "Polygon", "coordinates": [[[-117.26941, 32.81012], [-117.26933, 32.81014], [-117.26906, 32.8095], [-117.26872, 32.80895], [-117.26853, 32.80873], [-117.26761, 32.80787], [-117.26712, 32.80775], [-117.26643, 32.80781], [-117.26592, 32.80794], [-117.2658, 32.80803], [-117.26517, 32.80813], [-117.26497, 32.808], [-117.26421, 32.80759], [-117.2632, 32.80662], [-117.2628, 32.80601], [-117.26241, 32.80562], [-117.26225, 32.80557], [-117.26168, 32.80584], [-117.26133, 32.80617], [-117.26132, 32.8064], [-117.26108, 32.8064], [-117.26106, 32.80664], [-117.261, 32.80664], [-117.26095, 32.80666], [-117.26091, 32.80675], [-117.26066, 32.80692], [-117.26032, 32.80662], [-117.26027, 32.80665], [-117.26021, 32.80662], [-117.2602, 32.8066], [-117.26021, 32.80655], [-117.26096, 32.80596], [-117.26069, 32.80555], [-117.26185, 32.80493], [-117.26129, 32.80439], [-117.26166, 32.80431], [-117.26217, 32.80495], [-117.26218, 32.80497], [-117.26267, 32.80555], [-117.26275, 32.80571], [-117.26294, 32.80599], [-117.26339, 32.80658], [-117.26366, 32.80686], [-117.26367, 32.80689], [-117.26402, 32.80723], [-117.26435, 32.8075], [-117.2647, 32.80774], [-117.26506, 32.8079], [-117.26523, 32.80795], [-117.26535, 32.80797], [-117.26561, 32.80797], [-117.26574, 32.80795], [-117.26606, 32.80785], [-117.26637, 32.80771], [-117.26657, 32.80766], [-117.26693, 32.80762], [-117.26716, 32.80762], [-117.26733, 32.80764], [-117.26754, 32.80771], [-117.26771, 32.80781], [-117.26793, 32.80798], [-117.26805, 32.80812], [-117.26834, 32.80836], [-117.26853, 32.80855], [-117.26853, 32.80857], [-117.26877, 32.80883], [-117.26896, 32.8091], [-117.26915, 32.80943], [-117.26933, 32.80988], [-117.26941, 32.81012]]]} | Open Access 1 | Tourmaline Surfing Park | 26479 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 8.047 | Tourmaline Surfing Park | ||
14892 | 14892 | 14891 | {"type": "Polygon", "coordinates": [[[-117.26515, 32.8438], [-117.26511, 32.84397], [-117.26505, 32.84395], [-117.26498, 32.84389], [-117.26497, 32.84379], [-117.26498, 32.84377], [-117.26501, 32.84375], [-117.26509, 32.84374], [-117.26513, 32.84377], [-117.26515, 32.8438]]]} | Open Access 1 | Ludington Heights Open Space Park West | 21584 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.075 | Ludington Heights OS Park West | ||
5820 | 5820 | 5819 | {"type": "Polygon", "coordinates": [[[-117.26413, 32.82818], [-117.26378, 32.82828], [-117.26336, 32.82803], [-117.26327, 32.82825], [-117.2632, 32.82823], [-117.26309, 32.82823], [-117.26284, 32.82834], [-117.26253, 32.82854], [-117.26228, 32.82857], [-117.26208, 32.82853], [-117.26208, 32.82838], [-117.26183, 32.82841], [-117.26175, 32.82826], [-117.26166, 32.82822], [-117.26165, 32.82805], [-117.26172, 32.82796], [-117.26163, 32.82784], [-117.26181, 32.82772], [-117.26193, 32.82775], [-117.26207, 32.82758], [-117.26227, 32.82744], [-117.26252, 32.82746], [-117.26312, 32.82771], [-117.26413, 32.82818]]]} | Open Access 1 | La Jolla Bluebird Canyon Open Space | 20762 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 3.715 | La Jolla Bluebird 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 | ||
12134 | 12134 | 12133 | {"type": "Polygon", "coordinates": [[[-117.26243, 32.81163], [-117.26192, 32.81174], [-117.26174, 32.81106], [-117.26223, 32.81095], [-117.26243, 32.81163]]]} | Open Access 1 | Bird Rock Neighborhood Park | 30091 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.929 | Bird Rock Neighborhood Park | ||
12929 | 12929 | 12928 | {"type": "Polygon", "coordinates": [[[-117.26049, 32.80372], [-117.26017, 32.80392], [-117.26018, 32.804], [-117.25938, 32.80418], [-117.25951, 32.80404], [-117.25999, 32.80376], [-117.26024, 32.80342], [-117.26049, 32.80372]]]} | Open Access 1 | Palisades North Neighborhood Park | 30164 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.651 | Palisades North Neighborhood Park | ||
12957 | 12957 | 12956 | {"type": "Polygon", "coordinates": [[[-117.25994, 32.80298], [-117.25981, 32.80306], [-117.25952, 32.80239], [-117.25945, 32.80228], [-117.25935, 32.80219], [-117.25919, 32.80211], [-117.2593, 32.80184], [-117.25941, 32.80193], [-117.25954, 32.80211], [-117.25969, 32.80243], [-117.2598, 32.80281], [-117.25994, 32.80298]]]} | Open Access 1 | Palisades South Neighborhood Park | 30193 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.502 | Palisades South Neighborhood Park | ||
14889 | 14889 | 14888 | {"type": "Polygon", "coordinates": [[[-117.25989, 32.84535], [-117.25988, 32.84542], [-117.25976, 32.84547], [-117.25976, 32.84541], [-117.25979, 32.84531], [-117.25984, 32.84528], [-117.25985, 32.84529], [-117.25988, 32.84531], [-117.25989, 32.84535]]]} | Open Access 1 | Ludington Heights Open Space Park East | 21583 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.042 | Ludington Heights OS Park East |
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]);