units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
528 rows where AGNCY_NAME = 4 sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
DES_TP 22
- Local Park 259
- Local Recreation Area 207
- Local Other or Unknown 15
- Local Conservation Area 9
- Local Historic or Cultural Area 1
- None 1
- Local Resource Management Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 4
- City Agency 505
- Commercial 1
- Non Profit - Other 1
- Other 1
MNG_AGENCY 4
ACCESS_TYP 4
- Open Access 479
- No Public Access 18
- Restricted Access 10
- Unknown Access 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3464 | 3464 | 3463 | {"type": "Polygon", "coordinates": [[[-117.10929, 32.83543], [-117.10844, 32.83653], [-117.10729, 32.83643], [-117.1075, 32.83473], [-117.10749, 32.83455], [-117.10745, 32.83442], [-117.10929, 32.83543]]]} | Open Access 1 | 29255 | Villa Monserate Neighborhood Park | 30087 | 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 | 6.495 | Villa Monserate Neighborhood Park | 0 | Local Park 2 | 4 | |
3749 | 3749 | 3748 | {"type": "Polygon", "coordinates": [[[-117.23506, 32.85683], [-117.235, 32.85729], [-117.23501, 32.85792], [-117.23497, 32.85829], [-117.23342, 32.85801], [-117.23383, 32.85637], [-117.2345, 32.85662], [-117.23502, 32.8568], [-117.23506, 32.85683]]]} | Open Access 1 | 329 | Villa La Jolla Neighborhood Park | 30162 | 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 | 5.772 | Villa La Jolla Neighborhood Park | 0 | Local Park 2 | 4 | |
10570 | 10570 | 10569 | {"type": "Polygon", "coordinates": [[[-117.11737, 32.95676], [-117.11685, 32.95689], [-117.11475, 32.95655], [-117.11508, 32.95519], [-117.11476, 32.95487], [-117.11443, 32.9542], [-117.11463, 32.95401], [-117.11476, 32.95379], [-117.11487, 32.95342], [-117.11497, 32.95297], [-117.11503, 32.95285], [-117.11509, 32.95276], [-117.1157, 32.9532], [-117.11648, 32.95325], [-117.11641, 32.95344], [-117.11642, 32.95381], [-117.11652, 32.95415], [-117.11673, 32.95445], [-117.11715, 32.95492], [-117.11727, 32.95516], [-117.11705, 32.95581], [-117.11711, 32.95608], [-117.11737, 32.95676]]]} | Open Access 1 | 18826 | Views West Neighborhood Park | 30126 | 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 | 19.494 | Views West Neighborhood Park | 0 | Local Park 2 | 4 | |
3039 | 3039 | 3038 | {"type": "Polygon", "coordinates": [[[-117.0793, 32.83623], [-117.07917, 32.83624], [-117.0791, 32.83629], [-117.07905, 32.8363], [-117.07898, 32.83634], [-117.07896, 32.8364], [-117.07891, 32.83644], [-117.07891, 32.83651], [-117.07882, 32.83657], [-117.07879, 32.83666], [-117.07867, 32.83673], [-117.07858, 32.83685], [-117.0785, 32.83688], [-117.0784, 32.83688], [-117.0783, 32.8368], [-117.07884, 32.83628], [-117.07901, 32.83608], [-117.0793, 32.83623]]]} | Open Access 1 | 46761 | Via Playa Los Santos Mini-Park | 30212 | 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.543 | Via Playa Los Santos Mini-Park | 0 | Local Park 2 | 4 | |
10459 | 10459 | 10458 | {"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 | 18494 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.364 | Via Del Norte MP | 0 | Local Park 2 | 4 | |
7774 | 7774 | 7773 | {"type": "Polygon", "coordinates": [[[-117.16031, 32.89806], [-117.16022, 32.89821], [-117.15398, 32.89806], [-117.15425, 32.89773], [-117.15444, 32.89769], [-117.15469, 32.89776], [-117.15494, 32.89762], [-117.15521, 32.89731], [-117.15549, 32.89724], [-117.15572, 32.89727], [-117.15591, 32.89727], [-117.15615, 32.89717], [-117.15638, 32.89692], [-117.15658, 32.89683], [-117.15682, 32.89679], [-117.15734, 32.89679], [-117.15761, 32.89668], [-117.158, 32.89642], [-117.15833, 32.89632], [-117.15896, 32.8963], [-117.15939, 32.89626], [-117.1595, 32.89663], [-117.1597, 32.89687], [-117.16014, 32.89725], [-117.16031, 32.89806]]]} | Open Access 1 | 47656 | Vernal Pool Habitat | 31399 | 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 | 19.103 | Vernal Pool Habitat | None 646 | |||
16012 | 16012 | 16011 | {"type": "MultiPolygon", "coordinates": [[[[-117.07284, 32.70758], [-117.07214, 32.70758], [-117.07203, 32.70744], [-117.07218, 32.70724], [-117.0722, 32.70691], [-117.07203, 32.70673], [-117.07107, 32.70686], [-117.07091, 32.70689], [-117.07092, 32.70466], [-117.07142, 32.70466], [-117.07163, 32.70497], [-117.07266, 32.70701], [-117.07278, 32.70734], [-117.07284, 32.70758]]], [[[-117.07322, 32.70759], [-117.07316, 32.70759], [-117.07308, 32.70728], [-117.07299, 32.70705], [-117.07191, 32.70491], [-117.07177, 32.70467], [-117.07255, 32.70467], [-117.07255, 32.70409], [-117.07296, 32.70409], [-117.07307, 32.70406], [-117.0732, 32.70406], [-117.07317, 32.70595], [-117.07322, 32.70759]]]]} | Open Access 1 | 1809 | Valencia Canyon Ext. Open Space | 26759 | 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.169 | Valencia Canyon Ext. OS | 0 | Local Recreation Area 3 | 4 | |
3038 | 3038 | 3037 | {"type": "Polygon", "coordinates": [[[-117.20615, 32.94968], [-117.20599, 32.94973], [-117.20589, 32.94972], [-117.20586, 32.94969], [-117.20582, 32.94966], [-117.2058, 32.94954], [-117.20574, 32.94943], [-117.20559, 32.94933], [-117.20551, 32.94922], [-117.20548, 32.9491], [-117.20545, 32.94905], [-117.20535, 32.94903], [-117.20517, 32.94907], [-117.20499, 32.94922], [-117.20481, 32.94924], [-117.20472, 32.94928], [-117.20459, 32.94929], [-117.20463, 32.94913], [-117.20468, 32.94902], [-117.2048, 32.94884], [-117.20501, 32.94863], [-117.20519, 32.9488], [-117.20533, 32.94881], [-117.20534, 32.94888], [-117.2054, 32.94893], [-117.20548, 32.94894], [-117.20556, 32.94892], [-117.20585, 32.9492], [-117.20602, 32.9494], [-117.20597, 32.94947], [-117.20597, 32.94954], [-117.20603, 32.9496], [-117.20614, 32.94961], [-117.20615, 32.94968]]]} | Open Access 1 | 46760 | Vail Creek Neighborhood Park | 30211 | 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.269 | Vail Creek Neighborhood Park | 0 | Local Park 2 | 4 | |
2839 | 2839 | 2838 | {"type": "Polygon", "coordinates": [[[-117.15582, 32.75554], [-117.15554, 32.75574], [-117.15531, 32.75552], [-117.15538, 32.75542], [-117.15582, 32.75543], [-117.15582, 32.75554]]]} | Open Access 1 | 68 | Uptown Open Space | 26740 | 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.27 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
5805 | 5805 | 5804 | {"type": "Polygon", "coordinates": [[[-117.15503, 32.75526], [-117.15494, 32.7552], [-117.15494, 32.75483], [-117.15502, 32.75483], [-117.15503, 32.75526]]]} | Open Access 1 | 73 | Uptown Open Space | 26740 | 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.082 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
5837 | 5837 | 5836 | {"type": "Polygon", "coordinates": [[[-117.17083, 32.73648], [-117.1707, 32.73656], [-117.17061, 32.73656], [-117.17033, 32.73618], [-117.17009, 32.7358], [-117.17019, 32.73575], [-117.17083, 32.73648]]]} | Open Access 1 | 196 | Uptown Open Space | 26740 | 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.442 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
6098 | 6098 | 6097 | {"type": "Polygon", "coordinates": [[[-117.15918, 32.75713], [-117.15912, 32.75716], [-117.15916, 32.75725], [-117.15854, 32.75715], [-117.15815, 32.7573], [-117.15747, 32.75732], [-117.15763, 32.75683], [-117.15876, 32.75665], [-117.15867, 32.7564], [-117.15856, 32.75598], [-117.15902, 32.75688], [-117.15918, 32.75713]]]} | Open Access 1 | 18894 | Uptown Open Space | 26740 | 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.149 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
6492 | 6492 | 6491 | {"type": "Polygon", "coordinates": [[[-117.17175, 32.73853], [-117.17141, 32.73854], [-117.17141, 32.7384], [-117.17175, 32.7384], [-117.17175, 32.73853]]]} | Open Access 1 | 180 | Uptown Open Space | 26740 | 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.122 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
10051 | 10051 | 10050 | {"type": "Polygon", "coordinates": [[[-117.16506, 32.75862], [-117.16487, 32.75872], [-117.16435, 32.75831], [-117.16428, 32.7582], [-117.16424, 32.75796], [-117.16418, 32.75793], [-117.16412, 32.75791], [-117.16381, 32.75794], [-117.16365, 32.7579], [-117.16356, 32.75785], [-117.16349, 32.75773], [-117.16345, 32.75754], [-117.16348, 32.75742], [-117.16346, 32.7573], [-117.16342, 32.75727], [-117.16337, 32.75726], [-117.16317, 32.75729], [-117.16304, 32.75725], [-117.16278, 32.75707], [-117.16264, 32.75694], [-117.16289, 32.75677], [-117.16305, 32.75701], [-117.16369, 32.7572], [-117.16372, 32.75726], [-117.16366, 32.75779], [-117.1643, 32.75775], [-117.16447, 32.75793], [-117.16462, 32.75826], [-117.16494, 32.75844], [-117.16506, 32.75862]]]} | Open Access 1 | 18890 | Uptown Open Space | 26740 | 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.772 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
10147 | 10147 | 10146 | {"type": "Polygon", "coordinates": [[[-117.17727, 32.74744], [-117.17689, 32.74791], [-117.17662, 32.74774], [-117.17662, 32.74752], [-117.17714, 32.74736], [-117.17727, 32.74744]]]} | Open Access 1 | 18715 | Uptown Open Space | 26740 | 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.508 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
15958 | 15958 | 15957 | {"type": "MultiPolygon", "coordinates": [[[[-117.16852, 32.75178], [-117.16819, 32.75178], [-117.16819, 32.75095], [-117.16851, 32.75094], [-117.16852, 32.75178]]], [[[-117.17277, 32.75259], [-117.17219, 32.7526], [-117.17221, 32.75382], [-117.17234, 32.75383], [-117.17233, 32.75447], [-117.17188, 32.75448], [-117.17188, 32.75493], [-117.17128, 32.75494], [-117.17129, 32.75521], [-117.17188, 32.75521], [-117.17188, 32.75535], [-117.1704, 32.75535], [-117.1704, 32.75679], [-117.16881, 32.75676], [-117.16879, 32.75595], [-117.16827, 32.75595], [-117.16825, 32.7539], [-117.16825, 32.75383], [-117.16882, 32.75382], [-117.1688, 32.75369], [-117.1688, 32.75301], [-117.16946, 32.75301], [-117.16949, 32.75482], [-117.17153, 32.7548], [-117.17154, 32.75383], [-117.17152, 32.75273], [-117.17153, 32.75233], [-117.17127, 32.75232], [-117.17061, 32.75232], [-117.17062, 32.75197], [-117.17065, 32.75193], [-117.1707, 32.75191], [-117.17127, 32.75191], [-117.17128, 32.75218], [-117.17185, 32.75218], [-117.17186, 32.75225], [-117.17244, 32.75225], [-117.17245, 32.75219], [-117.17277, 32.75219], [-117.17277, 32.75259]]], [[[-117.1731, 32.75421], [-117.17278, 32.75421], [-117.17277, 32.75382], [-117.17309, 32.75381], [-117.1731, 32.75421]]]]} | Open Access 1 | 63 | Uptown Open Space | 26740 | 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 | 22.556 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
15959 | 15959 | 15958 | {"type": "Polygon", "coordinates": [[[-117.15844, 32.75574], [-117.15803, 32.75574], [-117.15769, 32.75634], [-117.15747, 32.75625], [-117.15712, 32.75602], [-117.15701, 32.75585], [-117.15677, 32.7558], [-117.15656, 32.75572], [-117.15644, 32.75554], [-117.15643, 32.75545], [-117.15766, 32.75548], [-117.15765, 32.7543], [-117.15782, 32.75454], [-117.158, 32.75474], [-117.15844, 32.75574]]]} | Open Access 1 | 74 | Uptown Open Space | 26740 | 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.512 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
7856 | 7856 | 7855 | {"type": "MultiPolygon", "coordinates": [[[[-116.93658, 32.65831], [-116.93658, 32.65948], [-116.9331, 32.65944], [-116.9334, 32.65894], [-116.93354, 32.65873], [-116.93365, 32.65861], [-116.93385, 32.65843], [-116.93416, 32.65828], [-116.93436, 32.6582], [-116.93464, 32.65813], [-116.93494, 32.65809], [-116.93575, 32.65812], [-116.93601, 32.65816], [-116.93658, 32.65831]]], [[[-116.94225, 32.64831], [-116.94055, 32.64938], [-116.9405, 32.65025], [-116.93964, 32.64997], [-116.9393, 32.65], [-116.93889, 32.65053], [-116.93851, 32.65043], [-116.93816, 32.65059], [-116.93773, 32.65091], [-116.93735, 32.65137], [-116.93725, 32.65163], [-116.93741, 32.6519], [-116.93945, 32.65199], [-116.93892, 32.65245], [-116.93806, 32.65288], [-116.93725, 32.65338], [-116.93681, 32.65376], [-116.93684, 32.65404], [-116.93709, 32.65421], [-116.93856, 32.65439], [-116.93929, 32.65419], [-116.93906, 32.65482], [-116.9395, 32.65512], [-116.94073, 32.65541], [-116.93973, 32.65549], [-116.93785, 32.65555], [-116.93777, 32.65605], [-116.93682, 32.65603], [-116.93678, 32.65633], [-116.93706, 32.65639], [-116.93724, 32.65649], [-116.9378, 32.65714], [-116.93806, 32.65723], [-116.93834, 32.65765], [-116.93789, 32.65742], [-116.93762, 32.65749], [-116.93753, 32.65766], [-116.93772, 32.658], [-116.93774, 32.65835], [-116.93796, 32.6586], [-116.93804, 32.65879], [-116.93836, 32.65931], [-116.93844, 32.65949], [-116.93794, 32.6591], [-116.93762, 32.65906], [-116.93758, 32.65884], [-116.93729, 32.65869], [-116.93693, 32.65833], [-116.93659, 32.65807], [-116.93658, 32.65808], [-116.93658, 32.6582], [-116.93604, 32.65805], [-116.93589, 32.65802], [-116.93516, 32.65799], [-116.93479, 32.65799], [-116.93457, 32.65803], [-116.93431, 32.6581], [-116.93393, 32.65826], [-116.93372, 32.65838], [-116.93357, 32.65852], [-116.93348, 32.65862], [-116.93325, 32.65895], [-116.93296, 32.65946], [-116.93286, 32.65969], [-116.93255, 32.66064], [-116.93093, 32.66437], [-116.93106, 32.66441], [-116.93216, 32.66184], [-116.93217, 32.66684], [-116.92827, 32.66678], [-116.92782, 32.66679], [-116.92782, 32.67322], [-116.92354, 32.67321], [-116.92351, 32.67684], [-116.91917, 32.67683], [-116.91915, 32.67321], [-116.91491, 32.6732], [-116.91492, 32.6703], [-116.9191, 32.67035], [-116.92346, 32.67044], [-116.92351, 32.6668], [-116.91914, 32.66676], [-116.91915, 32.66401], [-116.91924, 32.66404], [-116.91925, 32.66312], [-116.92781, 32.66319], [-116.9278, 32.65583], [-116.93158, 32.65592], [-116.93153, 32.65584], [-116.93126, 32.65572], [-116.93098, 32.65548], [-116.93094, 32.65536], [-116.93077, 32.65474], [-116.93084, 32.65458], [-116.93119, 32.65423], [-116.93117, 32.65407], [-116.93129, 32.65396], [-116.93172, 32.65328], [-116.93182, 32.6529], [-116.93218, 32.65251], [-116.93217, 32.65222], [-116.93218, 32.65221], [-116.93218, 32.65195], [-116.93224, 32.65149], [-116.93224, 32.65144], [-116.93221, 32.65142], [-116.93192, 32.65122], [-116.93148, 32.65096], [-116.92996, 32.65084], [-116.92965, 32.65036], [-116.93244, 32.64889], [-116.93407, 32.64789], [-116.9349, 32.64813], [-116.93561, 32.6482], [-116.93638, 32.64855], [-116.93691, 32.648], [-116.93754, 32.64776], [-116.93787, 32.64846], [-116.93844, 32.64854], [-116.93923, 32.6478], [-116.94011, 32.64821], [-116.94117, 32.64801], [-116.94165, 32.64797], [-116.94223, 32.6481], [-116.94225, 32.64831]]]]} | Open Access 1 | 47713 | Upper Otay Lakes | 31494 | 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 | 575.207 | Upper Otay Lakes | 0 | None 657 | ||
4469 | 4469 | 4468 | {"type": "Polygon", "coordinates": [[[-117.06249, 32.75242], [-117.06211, 32.75251], [-117.06106, 32.75279], [-117.06087, 32.75234], [-117.0624, 32.75219], [-117.06249, 32.75242]]]} | Open Access 1 | 94 | Unnamed site - San Diego, City of | 28704 | 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.367 | 0 | Local Other or Unknown 14 | 4 | ||
4532 | 4532 | 4531 | {"type": "MultiPolygon", "coordinates": [[[[-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.21219, 32.80689], [-117.21219, 32.80689]]]]} | No Public Access 3 | 18410 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.217 | 0 | Local Other or Unknown 14 | 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]);