units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by YR_EST descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, COUNTY, YR_EST, GAP_STS
DES_TP >30
ACCESS_TYP 2
- Open Access 238
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 240
MNG_AGENCY 1
- San Francisco, City and County of · 240 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8386 | 8386 | 8385 | {"type": "Polygon", "coordinates": [[[-122.41835, 37.78009], [-122.41831, 37.78014], [-122.41724, 37.78028], [-122.41712, 37.78022], [-122.41685, 37.77889], [-122.41694, 37.77881], [-122.41802, 37.77868], [-122.41807, 37.77871], [-122.41835, 37.78009]]]} | Open Access 1 | 12974 | Helen Diller Civic Center Playgrounds | 31697 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 4.432 | Helen Diller Civic Ctr. Playgrounds | 2018 | None 703 | ||
14691 | 14691 | 14690 | {"type": "Polygon", "coordinates": [[[-122.41621, 37.76434], [-122.41587, 37.76436], [-122.41587, 37.76447], [-122.41537, 37.7645], [-122.41531, 37.76377], [-122.41615, 37.76372], [-122.41621, 37.76434]]]} | Open Access 1 | 45018 | In Chan Kaajal Park | 31768 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/project/proposed-park-site-at-17th-and-folsom/ | San Francisco 13 | 1.398 | In Chan Kaajal Park | 2017 | Local Park 2 | 4 |
7829 | 7829 | 7828 | {"type": "Polygon", "coordinates": [[[-122.50267, 37.76171], [-122.50184, 37.76175], [-122.50179, 37.76106], [-122.50262, 37.76102], [-122.50267, 37.76171]]]} | Open Access 1 | 47708 | Playland at 43rd Avenue | 31457 | 2414 | San Francisco Unified School District 881 | Special District 4 | School District 14 | http://www.sfusd.edu/ | Special District 4 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.382 | Playland at 43rd Avenue | 2016 | None 654 | ||
714 | 714 | 713 | {"type": "Polygon", "coordinates": [[[-122.43637, 37.77699], [-122.43332, 37.77738], [-122.43298, 37.7757], [-122.43603, 37.77532], [-122.43637, 37.77699]]]} | Open Access 1 | 4091 | Alamo Square | 15322 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 12.698 | Alamo Square | 2000 | Local Park 2 | 4 | |
1902 | 1902 | 1901 | {"type": "Polygon", "coordinates": [[[-122.4742, 37.72523], [-122.47387, 37.72523], [-122.4735, 37.72527], [-122.47349, 37.72487], [-122.47322, 37.72486], [-122.47322, 37.7248], [-122.47411, 37.72426], [-122.47414, 37.72425], [-122.47416, 37.72427], [-122.47426, 37.72486], [-122.4742, 37.72523]]]} | Open Access 1 | 16307 | Junipero Serra Playground | 20533 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.545 | Junipero Serra Playground | 2000 | Local Recreation Area 3 | 4 | |
5427 | 5427 | 5426 | {"type": "MultiPolygon", "coordinates": [[[[-122.44577, 37.77293], [-122.44108, 37.77352], [-122.44092, 37.77277], [-122.44562, 37.77218], [-122.44577, 37.77293]]], [[[-122.51084, 37.77123], [-122.51082, 37.77125], [-122.46524, 37.77333], [-122.46492, 37.77336], [-122.45479, 37.77465], [-122.45476, 37.77464], [-122.45474, 37.77462], [-122.45417, 37.77186], [-122.446, 37.7729], [-122.44585, 37.77215], [-122.45402, 37.77111], [-122.454, 37.7709], [-122.45398, 37.77089], [-122.45365, 37.76926], [-122.45362, 37.76924], [-122.45359, 37.76908], [-122.45361, 37.76905], [-122.45324, 37.7672], [-122.45358, 37.76716], [-122.45359, 37.76715], [-122.45351, 37.76675], [-122.45315, 37.76677], [-122.45308, 37.76646], [-122.45319, 37.76644], [-122.45323, 37.76659], [-122.454, 37.76656], [-122.45401, 37.76655], [-122.45397, 37.76634], [-122.45449, 37.76628], [-122.45455, 37.76654], [-122.45478, 37.76653], [-122.45473, 37.76625], [-122.45677, 37.76598], [-122.45701, 37.76598], [-122.45721, 37.76599], [-122.45745, 37.76603], [-122.45764, 37.76608], [-122.45768, 37.76644], [-122.45788, 37.76644], [-122.45859, 37.76637], [-122.46049, 37.76628], [-122.51017, 37.76409], [-122.51021, 37.7641], [-122.51024, 37.76413], [-122.51025, 37.7645], [-122.51017, 37.76568], [-122.51018, 37.76647], [-122.51024, 37.76719], [-122.5103, 37.76771], [-122.51033, 37.76774], [-122.51042, 37.76819], [-122.51042, 37.76835], [-122.51047, 37.7686], [-122.51052, 37.76864], [-122.51063, 37.76917], [-122.51078, 37.77029], [-122.51076, 37.77035], [-122.5107, 37.77037], [-122.51069, 37.77049], [-122.51077, 37.77052], [-122.5108, 37.77056], [-122.51083, 37.77082], [-122.5108, 37.77092], [-122.51084, 37.77123]], [[-122.45534, 37.76755], [-122.45501, 37.76749], [-122.45487, 37.76756], [-122.45487, 37.76808], [-122.45516, 37.76805], [-122.45565, 37.76794], [-122.45563, 37.76789], [-122.45534, 37.76755]], [[-122.4691, 37.7719], [-122.46926, 37.772], [-122.46979, 37.77162], [-122.46885, 37.77083], [-122.46791, 37.77153], [-122.4686, 37.7722], [-122.4691, 37.7719]]]]} | Open Access 1 | 16720 | Golden Gate Park | 10900 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/parks-open-spaces/golden-gate-park-guide/ | San Francisco 13 | 1022.15 | Golden Gate Park | 2000 | Local Park 2 | 4 |
15688 | 15688 | 15687 | {"type": "MultiPolygon", "coordinates": [[[[-122.48702, 37.6263], [-122.48655, 37.62658], [-122.48643, 37.62662], [-122.48629, 37.62664], [-122.48616, 37.62664], [-122.48603, 37.62661], [-122.48592, 37.62657], [-122.48575, 37.62645], [-122.48565, 37.62631], [-122.48562, 37.6262], [-122.48558, 37.62569], [-122.48554, 37.6255], [-122.48541, 37.62524], [-122.48523, 37.62504], [-122.48501, 37.6249], [-122.48476, 37.62481], [-122.48384, 37.62463], [-122.48351, 37.62461], [-122.48332, 37.62463], [-122.48314, 37.62466], [-122.48161, 37.62511], [-122.48145, 37.62518], [-122.4813, 37.62526], [-122.4811, 37.62542], [-122.48093, 37.62562], [-122.48076, 37.62597], [-122.48052, 37.62649], [-122.48042, 37.62664], [-122.4803, 37.62675], [-122.48014, 37.62685], [-122.47997, 37.62693], [-122.47977, 37.62698], [-122.47875, 37.62705], [-122.47843, 37.6271], [-122.4688, 37.62708], [-122.46426, 37.62116], [-122.48041, 37.62146], [-122.48416, 37.62155], [-122.4842, 37.62157], [-122.48433, 37.62181], [-122.48449, 37.62195], [-122.48455, 37.62202], [-122.48465, 37.62231], [-122.48478, 37.62296], [-122.48492, 37.62338], [-122.48502, 37.6247], [-122.48516, 37.62476], [-122.48526, 37.62484], [-122.48533, 37.62493], [-122.48539, 37.62505], [-122.48659, 37.62582], [-122.48702, 37.6263]]], [[[-122.48741, 37.62712], [-122.48228, 37.62711], [-122.48228, 37.62601], [-122.48126, 37.62601], [-122.48125, 37.62656], [-122.48099, 37.62656], [-122.48098, 37.6271], [-122.48003, 37.6271], [-122.48021, 37.62703], [-122.48036, 37.62694], [-122.4805, 37.62682], [-122.48061, 37.6267], [-122.48073, 37.62653], [-122.48111, 37.6257], [-122.48124, 37.62553], [-122.48141, 37.6254], [-122.48169, 37.62527], [-122.48319, 37.62482], [-122.48338, 37.62478], [-122.48358, 37.62477], [-122.48382, 37.62479], [-122.48471, 37.62497], [-122.48493, 37.62506], [-122.4851, 37.62517], [-122.48523, 37.62533], [-122.4853, 37.62544], [-122.48535, 37.62557], [-122.48537, 37.6257], [-122.48542, 37.62622], [-122.48545, 37.62635], [-122.48556, 37.62653], [-122.48573, 37.62667], [-122.4859, 37.62675], [-122.48606, 37.62679], [-122.48625, 37.62681], [-122.48642, 37.62679], [-122.48666, 37.62672], [-122.48715, 37.62643], [-122.48726, 37.62655], [-122.48727, 37.62691], [-122.48741, 37.62712]]], [[[-122.49707, 37.62106], [-122.49634, 37.62137], [-122.49632, 37.62144], [-122.49668, 37.62221], [-122.49506, 37.62934], [-122.49503, 37.62979], [-122.49502, 37.62963], [-122.49501, 37.62962], [-122.49458, 37.62988], [-122.49433, 37.63], [-122.49411, 37.63001], [-122.49409, 37.62982], [-122.49222, 37.62982], [-122.49189, 37.62978], [-122.49148, 37.62965], [-122.49127, 37.62955], [-122.49115, 37.62947], [-122.49101, 37.62934], [-122.49083, 37.62911], [-122.49076, 37.62898], [-122.49068, 37.62876], [-122.49065, 37.62864], [-122.49057, 37.6272], [-122.48958, 37.62723], [-122.48938, 37.62671], [-122.48924, 37.62643], [-122.48908, 37.6262], [-122.48887, 37.62595], [-122.4887, 37.62578], [-122.48815, 37.62535], [-122.48786, 37.62507], [-122.48618, 37.62321], [-122.48574, 37.62275], [-122.48556, 37.62251], [-122.48553, 37.62225], [-122.48562, 37.62203], [-122.48591, 37.62164], [-122.49152, 37.62174], [-122.49152, 37.62169], [-122.49159, 37.62173], [-122.49344, 37.62181], [-122.4931, 37.62054], [-122.49707, 37.62106]]]]} | Restricted Access 2 | 15359 | Sharp Park Golf Course | 33048 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Mateo 15 | 407.344 | Sharp Park GC | 1972 | Local Recreation Area 3 | 4 | |
5058 | 5058 | 5057 | {"type": "Polygon", "coordinates": [[[-122.48732, 37.75739], [-122.48649, 37.75743], [-122.48638, 37.75579], [-122.4872, 37.75575], [-122.48732, 37.75739]]]} | Open Access 1 | 1309 | Sunset Recreation Center | 30853 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/destination/sunset-rec-center-park/ | San Francisco 13 | 3.286 | Sunset Rec. Ctr. | 1940 | Local Recreation Area 3 | 4 |
15692 | 15692 | 15691 | {"type": "Polygon", "coordinates": [[[-122.50507, 37.78524], [-122.50351, 37.78602], [-122.50335, 37.78648], [-122.5024, 37.78704], [-122.5018, 37.78719], [-122.50116, 37.78701], [-122.50101, 37.78639], [-122.5006, 37.7861], [-122.50017, 37.78596], [-122.49951, 37.78644], [-122.49933, 37.78655], [-122.49895, 37.78658], [-122.49859, 37.78658], [-122.49822, 37.78655], [-122.49786, 37.78647], [-122.49731, 37.7863], [-122.49707, 37.78646], [-122.49677, 37.78646], [-122.49596, 37.78658], [-122.49573, 37.78666], [-122.49514, 37.7867], [-122.49423, 37.78648], [-122.49416, 37.78639], [-122.49405, 37.78653], [-122.49392, 37.78679], [-122.49379, 37.78689], [-122.4937, 37.78691], [-122.49333, 37.78174], [-122.5011, 37.78139], [-122.50133, 37.78414], [-122.50414, 37.78401], [-122.50507, 37.78524]]]} | Restricted Access 2 | 17379 | Lincoln Park Golf Course | 33132 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | https://sfrecpark.org/destination/lincoln-park/ | San Francisco 13 | 112.07 | Lincoln Park GC | 1909 | Local Recreation Area 3 | 4 |
39 | 39 | 38 | {"type": "Polygon", "coordinates": [[[-122.41541, 37.74416], [-122.41424, 37.74386], [-122.4139, 37.74373], [-122.41307, 37.74338], [-122.41292, 37.74333], [-122.41277, 37.74333], [-122.41262, 37.74335], [-122.41236, 37.74347], [-122.41201, 37.74361], [-122.41188, 37.74363], [-122.41171, 37.74361], [-122.41023, 37.74309], [-122.41017, 37.74304], [-122.41012, 37.74297], [-122.4101, 37.74289], [-122.4101, 37.74281], [-122.41018, 37.74269], [-122.41031, 37.74257], [-122.41045, 37.74251], [-122.4106, 37.74249], [-122.41164, 37.74243], [-122.41251, 37.7423], [-122.41265, 37.7423], [-122.41416, 37.74251], [-122.41432, 37.74252], [-122.41446, 37.7425], [-122.41461, 37.74246], [-122.41479, 37.74238], [-122.41501, 37.74225], [-122.41512, 37.74222], [-122.4159, 37.74217], [-122.41629, 37.74208], [-122.41647, 37.74206], [-122.41669, 37.74209], [-122.41682, 37.74216], [-122.41689, 37.74222], [-122.41696, 37.74233], [-122.41699, 37.74242], [-122.41698, 37.74251], [-122.41693, 37.74261], [-122.4167, 37.74279], [-122.41662, 37.74291], [-122.41657, 37.74307], [-122.41659, 37.74328], [-122.41655, 37.74337], [-122.41647, 37.74345], [-122.4161, 37.74363], [-122.41597, 37.74372], [-122.41586, 37.74383], [-122.4158, 37.74393], [-122.41575, 37.74406], [-122.41568, 37.74413], [-122.41556, 37.74418], [-122.41541, 37.74416]], [[-122.41555, 37.74286], [-122.41477, 37.74286], [-122.41477, 37.74327], [-122.41556, 37.74326], [-122.41555, 37.74286]]]} | Open Access 1 | 122 | Bernal Heights Park | 16026 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 19.35 | Bernal Heights Park | 0 | Local Park 2 | 4 | |
134 | 134 | 133 | {"type": "Polygon", "coordinates": [[[-122.42226, 37.73435], [-122.42174, 37.73471], [-122.42177, 37.73475], [-122.42174, 37.73506], [-122.42008, 37.73497], [-122.42016, 37.73405], [-122.41919, 37.734], [-122.41925, 37.73328], [-122.41931, 37.73301], [-122.41929, 37.733], [-122.41929, 37.73252], [-122.41954, 37.73252], [-122.41956, 37.73231], [-122.42009, 37.7323], [-122.4201, 37.73232], [-122.42027, 37.73232], [-122.42079, 37.73229], [-122.42084, 37.73243], [-122.42096, 37.7324], [-122.42091, 37.73226], [-122.421, 37.73225], [-122.42145, 37.7331], [-122.4217, 37.73332], [-122.42178, 37.73343], [-122.4221, 37.73413], [-122.42226, 37.73435]]]} | Open Access 1 | 342 | Saint Mary's Playground | 24791 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 13.777 | Saint Mary's Playground | 0 | Local Recreation Area 3 | 4 | |
721 | 721 | 720 | {"type": "Polygon", "coordinates": [[[-122.4813, 37.73044], [-122.48094, 37.73047], [-122.48094, 37.73108], [-122.47952, 37.73106], [-122.47952, 37.73057], [-122.47963, 37.73056], [-122.47999, 37.73047], [-122.48041, 37.73011], [-122.48105, 37.72997], [-122.48129, 37.73025], [-122.4813, 37.73044]]]} | Open Access 1 | 5402 | Rolph-Nicole Park | 24585 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 3.048 | Rolph-Nicole Park | 0 | Local Park 2 | 4 | |
735 | 735 | 734 | {"type": "Polygon", "coordinates": [[[-122.42952, 37.73851], [-122.42949, 37.73855], [-122.4295, 37.73861], [-122.42928, 37.73867], [-122.42929, 37.73892], [-122.4288, 37.73859], [-122.4288, 37.73837], [-122.42926, 37.73806], [-122.42927, 37.73835], [-122.42952, 37.73851]]]} | Open Access 1 | 5513 | Fairmount Plaza | 18812 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.742 | Fairmount Plaza | 0 | Local Park 2 | 4 | |
740 | 740 | 739 | {"type": "MultiPolygon", "coordinates": [[[[-122.43261, 37.73842], [-122.43248, 37.73852], [-122.4324, 37.73848], [-122.43211, 37.73825], [-122.432, 37.7382], [-122.43185, 37.73817], [-122.43168, 37.73818], [-122.43124, 37.7383], [-122.43104, 37.73798], [-122.43159, 37.73777], [-122.43195, 37.73779], [-122.43261, 37.73842]]], [[[-122.43549, 37.74395], [-122.43519, 37.74397], [-122.43518, 37.7439], [-122.435, 37.74391], [-122.43495, 37.74329], [-122.43544, 37.74326], [-122.43547, 37.74327], [-122.43549, 37.74395]]]]} | Open Access 1 | 5519 | Diamond Hights Lot3 | 18142 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.023 | Diamond Hights Lot3 | 0 | Local Other or Unknown 14 | 4 | |
760 | 760 | 759 | {"type": "Polygon", "coordinates": [[[-122.44042, 37.75748], [-122.4401, 37.75772], [-122.44006, 37.7577], [-122.43984, 37.75794], [-122.4397, 37.75788], [-122.43989, 37.75763], [-122.44017, 37.75731], [-122.44042, 37.75748]]]} | Open Access 1 | 5609 | Seward Mini Park | 25330 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.372 | Seward MP | 0 | Local Park 2 | 4 | |
768 | 768 | 767 | {"type": "Polygon", "coordinates": [[[-122.42281, 37.75993], [-122.42246, 37.75995], [-122.42232, 37.75965], [-122.42215, 37.75966], [-122.42211, 37.75927], [-122.42205, 37.75923], [-122.42183, 37.75925], [-122.4218, 37.75887], [-122.4227, 37.75882], [-122.42281, 37.75993]]]} | Open Access 1 | 5666 | Mission Playground | 22307 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.793 | Mission Playground | 0 | Local Recreation Area 3 | 4 | |
785 | 785 | 784 | {"type": "Polygon", "coordinates": [[[-122.40049, 37.76481], [-122.39883, 37.76491], [-122.39873, 37.76382], [-122.40038, 37.76372], [-122.40049, 37.76481]]]} | Open Access 1 | 5773 | Jackson Playground | 20324 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 4.406 | Jackson Playground | 0 | Local Recreation Area 3 | 4 | |
838 | 838 | 837 | {"type": "Polygon", "coordinates": [[[-122.44984, 37.73813], [-122.44957, 37.73918], [-122.44952, 37.73922], [-122.44945, 37.73923], [-122.44886, 37.73921], [-122.44882, 37.7392], [-122.4488, 37.73916], [-122.44882, 37.73902], [-122.44896, 37.73851], [-122.44902, 37.7381], [-122.44907, 37.73808], [-122.44945, 37.73809], [-122.44971, 37.73804], [-122.44978, 37.73805], [-122.44983, 37.73809], [-122.44984, 37.73813]]]} | Open Access 1 | 5466 | Miraloma Playground | 22285 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.208 | Miraloma Playground | 0 | Local Recreation Area 3 | 4 | |
857 | 857 | 856 | {"type": "Polygon", "coordinates": [[[-122.44005, 37.73418], [-122.43989, 37.73445], [-122.43886, 37.73409], [-122.43928, 37.73337], [-122.4397, 37.73337], [-122.43971, 37.73394], [-122.4397, 37.73396], [-122.43966, 37.73396], [-122.43966, 37.73403], [-122.44005, 37.73418]]]} | Open Access 1 | 5558 | Dorothy Erskine Park | 18223 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.6 | Dorothy Erskine Park | 0 | Local Park 2 | 4 | |
863 | 863 | 862 | {"type": "Polygon", "coordinates": [[[-122.46596, 37.74109], [-122.46493, 37.74236], [-122.4645, 37.74212], [-122.46556, 37.74086], [-122.46583, 37.74099], [-122.46595, 37.74107], [-122.46596, 37.74109]]]} | Open Access 1 | 5574 | West Portal Playground | 27374 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.893 | West Portal Playground | 0 | Local Recreation Area 3 | 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]);