units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
281 rows where DES_TP = 2 and MNG_AGENCY = 4 sorted by rowid descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 281
MNG_AGENCY 1
- San Diego, City of · 281 ✖
DES_TP 1
- Local Park · 281 ✖
Link | rowid ▲ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16308 | 16308 | 16307 | {"type": "MultiPolygon", "coordinates": [[[[-117.0198, 32.82876], [-117.01951, 32.82959], [-117.01936, 32.8301], [-117.01773, 32.83003], [-117.01791, 32.82937], [-117.01801, 32.82935], [-117.01803, 32.82882], [-117.01793, 32.82837], [-117.01781, 32.82808], [-117.01732, 32.82737], [-117.01791, 32.82736], [-117.0198, 32.82876]]], [[[-117.04626, 32.81855], [-117.04598, 32.81888], [-117.04576, 32.81919], [-117.04407, 32.82211], [-117.04113, 32.82749], [-117.04075, 32.82815], [-117.04034, 32.82876], [-117.03996, 32.82928], [-117.03954, 32.82979], [-117.0391, 32.83029], [-117.03793, 32.83145], [-117.03427, 32.83146], [-117.02856, 32.82771], [-117.02747, 32.82882], [-117.02687, 32.82902], [-117.02698, 32.82892], [-117.0266, 32.82839], [-117.02654, 32.82842], [-117.02589, 32.82794], [-117.02548, 32.82847], [-117.02498, 32.82829], [-117.02459, 32.82809], [-117.02386, 32.82757], [-117.02399, 32.82745], [-117.02411, 32.82684], [-117.02346, 32.82662], [-117.02302, 32.82699], [-117.02263, 32.82673], [-117.02249, 32.82686], [-117.02235, 32.82676], [-117.02233, 32.82677], [-117.02208, 32.82659], [-117.01999, 32.82869], [-117.01798, 32.82719], [-117.01706, 32.8272], [-117.01687, 32.82685], [-117.01635, 32.82571], [-117.01586, 32.82388], [-117.01584, 32.82388], [-117.01574, 32.82376], [-117.01563, 32.82364], [-117.01539, 32.82346], [-117.01521, 32.82324], [-117.01505, 32.8231], [-117.01499, 32.823], [-117.01493, 32.82269], [-117.01488, 32.82256], [-117.01458, 32.82224], [-117.01449, 32.82216], [-117.01421, 32.82197], [-117.01183, 32.82066], [-117.01156, 32.82047], [-117.01137, 32.82028], [-117.01119, 32.82005], [-117.01107, 32.81978], [-117.0107, 32.81851], [-117.01061, 32.81816], [-117.0106, 32.81809], [-117.01066, 32.81799], [-117.01075, 32.81793], [-117.01086, 32.81792], [-117.01099, 32.81796], [-117.01107, 32.81805], [-117.01136, 32.81892], [-117.01145, 32.81906], [-117.01158, 32.81921], [-117.01183, 32.81938], [-117.01271, 32.81981], [-117.01289, 32.81988], [-117.01308, 32.81992], [-117.01337, 32.81993], [-117.01361, 32.8199], [-117.01385, 32.81983], [-117.01409, 32.8197], [-117.01425, 32.81957], [-117.01435, 32.81946], [-117.01481, 32.81877], [-117.0147, 32.81871], [-117.01426, 32.81937], [-117.01416, 32.81949], [-117.01399, 32.81963], [-117.01383, 32.81972], [-117.01365, 32.81978], [-117.01341, 32.81982], [-117.01323, 32.81983], [-117.01299, 32.8198], [-117.01277, 32.81972], [-117.0119, 32.81929], [-117.01168, 32.81914], [-117.01156, 32.81899], [-117.01147, 32.81885], [-117.01119, 32.81801], [-117.01113, 32.81792], [-117.01103, 32.81785], [-117.0109, 32.81781], [-117.01075, 32.81782], [-117.01063, 32.81786], [-117.01052, 32.81797], [-117.01048, 32.81805], [-117.01047, 32.81813], [-117.01058, 32.81855], [-117.01023, 32.81751], [-117.00997, 32.81563], [-117.01204, 32.81698], [-117.01391, 32.81818], [-117.0198, 32.8119], [-117.01979, 32.81188], [-117.01937, 32.81159], [-117.01979, 32.81115], [-117.02118, 32.8122], [-117.02174, 32.81214], [-117.02325, 32.81054], [-117.02339, 32.8101], [-117.02316, 32.80969], [-117.02272, 32.80941], [-117.02259, 32.8095], [-117.02245, 32.80957], [-117.02229, 32.80961], [-117.02212, 32.80963], [-117.02193, 32.80962], [-117.02176, 32.80957], [-117.02161, 32.8095], [-117.0215, 32.80942], [-117.0216, 32.80933], [-117.0219, 32.80952], [-117.02312, 32.80816], [-117.02571, 32.80819], [-117.02706, 32.80763], [-117.02759, 32.80851], [-117.02839, 32.80817], [-117.02788, 32.80729], [-117.02849, 32.80704], [-117.02918, 32.80557], [-117.0298, 32.80447], [-117.0313, 32.80375], [-117.03165, 32.80305], [-117.0317, 32.80307], [-117.03622, 32.80401], [-117.03728, 32.80422], [-117.03718, 32.80461], [-117.03774, 32.80471], [-117.0377, 32.80494], [-117.03767, 32.80517], [-117.03767, 32.8054], [-117.03771, 32.80568], [-117.03778, 32.80594], [-117.03785, 32.80614], [-117.03795, 32.80634], [-117.03809, 32.80655], [-117.03832, 32.80684], [-117.03857, 32.80707], [-117.03903, 32.8074], [-117.0394, 32.80757], [-117.03925, 32.80783], [-117.04019, 32.80836], [-117.03971, 32.80914], [-117.03963, 32.80933], [-117.0396, 32.80953], [-117.03959, 32.80986], [-117.03983, 32.81006], [-117.04008, 32.81009], [-117.04005, 32.81052], [-117.04018, 32.81053], [-117.04039, 32.81104], [-117.04042, 32.81119], [-117.04041, 32.81136], [-117.04046, 32.81152], [-117.04087, 32.81226], [-117.04123, 32.81262], [-117.04166, 32.81316], [-117.0432, 32.81475], [-117.04291, 32.8147], [-117.04273, 32.81537], [-117.04315, 32.81545], [-117.0436, 32.81548], [-117.04419, 32.81549], [-117.04512, 32.8158], [-117.04555, 32.8159], [-117.04626, 32.81855]]]]} | Open Access 1 | 1152 | Mission Trails Regional Park | 29248 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.mtrp.org/ | San Diego 4 | 1520.459 | Mission Trails RP | 0 | Local Park 2 | 4 |
15533 | 15533 | 15532 | {"type": "Polygon", "coordinates": [[[-117.0207, 32.5792], [-117.02057, 32.57953], [-117.02033, 32.57995], [-117.02015, 32.57997], [-117.01975, 32.58005], [-117.01946, 32.57923], [-117.01923, 32.57874], [-117.01924, 32.57873], [-117.01922, 32.57857], [-117.01924, 32.57846], [-117.01982, 32.57848], [-117.02008, 32.57856], [-117.02024, 32.57865], [-117.02054, 32.57897], [-117.0207, 32.5792]]]} | Open Access 1 | 46729 | Hidden Trails Neighborhood Park | 30177 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.938 | Hidden Trails Neighborhood Park | 0 | Local Park 2 | 4 | |
15532 | 15532 | 15531 | {"type": "Polygon", "coordinates": [[[-117.1088, 32.74494], [-117.10861, 32.74528], [-117.1085, 32.74535], [-117.10835, 32.74537], [-117.10835, 32.74493], [-117.1088, 32.74494]]]} | Open Access 1 | 46728 | Central Avenue Mini-Park | 30175 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.36 | Central Avenue Mini-Park | 0 | Local Park 2 | 4 | |
15453 | 15453 | 15452 | {"type": "Polygon", "coordinates": [[[-117.22179, 32.95088], [-117.2217, 32.95273], [-117.22121, 32.95271], [-117.2213, 32.95086], [-117.22179, 32.95088]]]} | Open Access 1 | 46723 | Carmel Valley Neighborhood Park | 30153 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.309 | Carmel Valley Neighborhood Park | 0 | Local Park 2 | 4 | |
15452 | 15452 | 15451 | {"type": "Polygon", "coordinates": [[[-117.25523, 32.9504], [-117.25392, 32.95174], [-117.25325, 32.95174], [-117.25326, 32.94894], [-117.25483, 32.94943], [-117.25523, 32.9504]]]} | Open Access 1 | 46722 | Crest Canyon Neighborhood Park | 30149 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.975 | Crest Canyon Neighborhood Park | 0 | Local Park 2 | 4 | |
15451 | 15451 | 15450 | {"type": "Polygon", "coordinates": [[[-117.10104, 32.96786], [-117.0991, 32.9694], [-117.09768, 32.96813], [-117.0991, 32.96695], [-117.0996, 32.96659], [-117.10104, 32.96786]]]} | No Public Access 3 | 46721 | Penasquitos Village Neighborhood Park | 30267 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 12.044 | Penasquitos Village Neighborhood Park | 0 | Local Park 2 | 4 | |
15450 | 15450 | 15449 | {"type": "MultiPolygon", "coordinates": [[[[-117.17858, 32.74951], [-117.17846, 32.74951], [-117.17833, 32.74953], [-117.1778, 32.74972], [-117.17753, 32.74977], [-117.17722, 32.74981], [-117.17664, 32.7498], [-117.17662, 32.74843], [-117.17858, 32.74843], [-117.17858, 32.74951]]], [[[-117.18097, 32.74829], [-117.18082, 32.74902], [-117.18034, 32.74958], [-117.18036, 32.74965], [-117.18012, 32.74979], [-117.17996, 32.74991], [-117.17986, 32.75002], [-117.1796, 32.75018], [-117.17902, 32.75026], [-117.17858, 32.75025], [-117.17857, 32.75041], [-117.17691, 32.75042], [-117.17691, 32.75001], [-117.17694, 32.74996], [-117.17698, 32.74994], [-117.17736, 32.74994], [-117.17766, 32.74989], [-117.17785, 32.74984], [-117.17836, 32.74967], [-117.17852, 32.74964], [-117.17858, 32.74964], [-117.17859, 32.74988], [-117.17898, 32.74984], [-117.17938, 32.74976], [-117.17963, 32.74959], [-117.17975, 32.74948], [-117.18086, 32.74818], [-117.18097, 32.74829]]]]} | Open Access 1 | 46720 | Mission Hills Neighborhood Park | 30142 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 12.537 | Mission Hills Neighborhood Park | 0 | Local Park 2 | 4 | |
15448 | 15448 | 15447 | {"type": "Polygon", "coordinates": [[[-117.25182, 32.75258], [-117.25173, 32.75275], [-117.25162, 32.75308], [-117.25164, 32.75338], [-117.25169, 32.75364], [-117.25108, 32.7537], [-117.2511, 32.75388], [-117.25039, 32.75397], [-117.25039, 32.75404], [-117.25038, 32.75406], [-117.2503, 32.75412], [-117.25024, 32.75413], [-117.25007, 32.75411], [-117.24998, 32.75407], [-117.24955, 32.75381], [-117.24954, 32.75376], [-117.24956, 32.75372], [-117.2496, 32.75371], [-117.24996, 32.75392], [-117.25129, 32.7535], [-117.25129, 32.75348], [-117.25098, 32.75326], [-117.25166, 32.75248], [-117.25182, 32.75258]]]} | Open Access 1 | 46747 | Brighton Park | 30199 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.179 | Brighton Park | 0 | Local Park 2 | 4 | |
15447 | 15447 | 15446 | {"type": "Polygon", "coordinates": [[[-117.08407, 32.90975], [-117.08285, 32.91131], [-117.08227, 32.91152], [-117.08215, 32.91178], [-117.08151, 32.91225], [-117.0807, 32.9115], [-117.081, 32.91127], [-117.08117, 32.9111], [-117.08126, 32.91097], [-117.08159, 32.91042], [-117.08168, 32.91032], [-117.08181, 32.91023], [-117.08259, 32.90987], [-117.08272, 32.90977], [-117.08284, 32.90966], [-117.08285, 32.90976], [-117.08407, 32.90975]]]} | Open Access 1 | 46719 | Jerabek Neighborhood Park | 30141 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.686 | Jerabek Neighborhood Park | 0 | Local Park 2 | 4 | |
15446 | 15446 | 15445 | {"type": "Polygon", "coordinates": [[[-117.09001, 32.91792], [-117.08908, 32.91922], [-117.08685, 32.91954], [-117.08692, 32.91885], [-117.08673, 32.91863], [-117.0868, 32.91854], [-117.08681, 32.91846], [-117.0868, 32.9184], [-117.08649, 32.91803], [-117.08638, 32.91793], [-117.08627, 32.91787], [-117.08616, 32.91784], [-117.08594, 32.91784], [-117.08584, 32.91733], [-117.09001, 32.91792]]]} | Open Access 1 | 46718 | Lakeview Neighborhood Park | 30139 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 13.209 | Lakeview Neighborhood Park | 0 | Local Park 2 | 4 | |
15445 | 15445 | 15444 | {"type": "Polygon", "coordinates": [[[-117.15805, 32.90687], [-117.15726, 32.90718], [-117.15701, 32.90724], [-117.15673, 32.90726], [-117.15644, 32.90724], [-117.15618, 32.90717], [-117.15598, 32.90709], [-117.15558, 32.90688], [-117.1571, 32.90586], [-117.15788, 32.90663], [-117.15792, 32.90663], [-117.15805, 32.90687]]]} | Open Access 1 | 46716 | Maddox Neighborhood Park | 30135 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.813 | Maddox Neighborhood Park | 0 | Local Park 2 | 4 | |
15444 | 15444 | 15443 | {"type": "Polygon", "coordinates": [[[-117.06668, 32.92666], [-117.06635, 32.92652], [-117.0662, 32.9265], [-117.06611, 32.92647], [-117.0658, 32.9261], [-117.06543, 32.9259], [-117.06515, 32.92583], [-117.06473, 32.92578], [-117.06454, 32.92587], [-117.06445, 32.92554], [-117.06413, 32.92492], [-117.06408, 32.92478], [-117.064, 32.92445], [-117.06399, 32.92422], [-117.06401, 32.92418], [-117.06407, 32.92416], [-117.06623, 32.92412], [-117.06647, 32.92415], [-117.06668, 32.92421], [-117.06668, 32.92666]]]} | Open Access 1 | 46715 | Cypress Canyon Neighborhood Park | 30133 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 12.247 | Cypress Canyon Neighborhood Park | 0 | Local Park 2 | 4 | |
15443 | 15443 | 15442 | {"type": "Polygon", "coordinates": [[[-117.10348, 32.93727], [-117.10176, 32.93719], [-117.10182, 32.93612], [-117.10206, 32.93613], [-117.10236, 32.93608], [-117.10259, 32.93596], [-117.1033, 32.93611], [-117.10321, 32.93674], [-117.10325, 32.93692], [-117.10335, 32.93705], [-117.10348, 32.93713], [-117.10348, 32.93727]]]} | Open Access 1 | 46714 | Miramar Ranch North Park | 30132 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.475 | Miramar Ranch North Park | 0 | Local Park 2 | 4 | |
15442 | 15442 | 15441 | {"type": "Polygon", "coordinates": [[[-117.07969, 32.92398], [-117.07969, 32.92402], [-117.07952, 32.92402], [-117.07932, 32.92405], [-117.07894, 32.92421], [-117.07843, 32.92435], [-117.07823, 32.92439], [-117.07812, 32.92435], [-117.07799, 32.92414], [-117.07796, 32.92413], [-117.0781, 32.92372], [-117.0786, 32.92382], [-117.07969, 32.92398]]]} | Open Access 1 | 46713 | Canyon View Mini-Park | 30131 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.504 | Canyon View Mini-Park | 0 | Local Park 2 | 4 | |
15441 | 15441 | 15440 | {"type": "Polygon", "coordinates": [[[-117.11749, 32.94559], [-117.11634, 32.9473], [-117.11585, 32.94711], [-117.11559, 32.94678], [-117.11529, 32.94682], [-117.11529, 32.94667], [-117.11535, 32.94652], [-117.11607, 32.9455], [-117.11609, 32.94537], [-117.11606, 32.94529], [-117.11602, 32.94523], [-117.11665, 32.94433], [-117.11711, 32.94477], [-117.11749, 32.94559]]]} | Open Access 1 | 46712 | Ridgewood Neighborhood Park | 30124 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 8.338 | Ridgewood Neighborhood Park | 0 | Local Park 2 | 4 | |
15440 | 15440 | 15439 | {"type": "Polygon", "coordinates": [[[-117.10802, 32.75155], [-117.10801, 32.75176], [-117.1075, 32.75174], [-117.10749, 32.75181], [-117.10703, 32.7518], [-117.10703, 32.75154], [-117.10802, 32.75155]]]} | Open Access 1 | 46711 | Central Neighborhood Park | 30120 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.589 | Central Neighborhood Park | 0 | Local Park 2 | 4 | |
15439 | 15439 | 15438 | {"type": "Polygon", "coordinates": [[[-117.07486, 32.72154], [-117.07336, 32.72229], [-117.07326, 32.72357], [-117.07298, 32.7236], [-117.07292, 32.72349], [-117.07285, 32.7234], [-117.07263, 32.72318], [-117.07255, 32.72308], [-117.07217, 32.72242], [-117.07243, 32.72241], [-117.07251, 32.72245], [-117.07258, 32.72245], [-117.07265, 32.72243], [-117.0727, 32.72237], [-117.0727, 32.72233], [-117.07269, 32.72228], [-117.07235, 32.72176], [-117.0729, 32.72151], [-117.07288, 32.72064], [-117.07319, 32.72064], [-117.07325, 32.72071], [-117.07334, 32.72073], [-117.07341, 32.72071], [-117.07346, 32.72067], [-117.07348, 32.72062], [-117.07346, 32.72055], [-117.07457, 32.72057], [-117.07443, 32.72092], [-117.07481, 32.72143], [-117.07486, 32.72154]]]} | Open Access 1 | 46710 | Emerald Hills Neighborhood Park | 30112 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.678 | Emerald Hills Neighborhood Park | 0 | Local Park 2 | 4 | |
15438 | 15438 | 15437 | {"type": "Polygon", "coordinates": [[[-117.23713, 32.71023], [-117.23714, 32.71027], [-117.23708, 32.71051], [-117.23699, 32.71048], [-117.23698, 32.7103], [-117.23704, 32.71021], [-117.23713, 32.71023]]]} | Open Access 1 | 46708 | McCall Street Mini-Park | 30099 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.089 | McCall Street Mini-Park | 0 | Local Park 2 | 4 | |
15437 | 15437 | 15436 | {"type": "Polygon", "coordinates": [[[-117.02143, 32.9246], [-117.02138, 32.92468], [-117.02107, 32.92486], [-117.02044, 32.92531], [-117.0203, 32.92543], [-117.01926, 32.9246], [-117.01865, 32.92458], [-117.01852, 32.92429], [-117.01867, 32.92413], [-117.01877, 32.92406], [-117.019, 32.92394], [-117.0196, 32.92371], [-117.0202, 32.92354], [-117.02042, 32.92351], [-117.02063, 32.92357], [-117.02072, 32.92364], [-117.02078, 32.9236], [-117.02128, 32.92411], [-117.02138, 32.92424], [-117.02131, 32.92428], [-117.02143, 32.9246]]]} | Open Access 1 | 46734 | Stonebridge Neighborhood Park | 30182 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 8.155 | Stonebridge Neighborhood Park | 0 | Local Park 2 | 4 | |
15435 | 15435 | 15434 | {"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 | 46706 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.184 | La Jolla Strand Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);