units_with_maps

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1,162 rows where MNG_AG_TYP = 4

View and edit SQL

Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, GAP_STS

DES_TP

MNG_AG_TYP

  • Recreation/Parks District · 1,162
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
18 17 {"type": "Polygon", "coordinates": [[[-118.95325, 34.18233], [-118.94954, 34.18265], [-118.94921, 34.18001], [-118.94982, 34.17958], [-118.95014, 34.17942], [-118.95045, 34.17932], [-118.95086, 34.17926], [-118.95165, 34.17922], [-118.9523, 34.17926], [-118.95325, 34.18233]]]} Open Access 1 58 Borchard Park 16277 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 27.263 Borchard Park 0 Local Park 2 4
105 104 {"type": "Polygon", "coordinates": [[[-122.66428, 38.02321], [-122.65316, 38.02895], [-122.6525, 38.02785], [-122.652, 38.02795], [-122.65175, 38.02796], [-122.6513, 38.02794], [-122.65109, 38.02806], [-122.65106, 38.02782], [-122.65177, 38.0272], [-122.6525, 38.02645], [-122.65162, 38.015], [-122.65212, 38.01498], [-122.65215, 38.01512], [-122.65396, 38.01499], [-122.654, 38.0149], [-122.65811, 38.01477], [-122.6581, 38.01483], [-122.65809, 38.01484], [-122.65808, 38.01486], [-122.65811, 38.01504], [-122.65817, 38.01517], [-122.65826, 38.01528], [-122.6584, 38.01537], [-122.65892, 38.01548], [-122.65871, 38.01594], [-122.65871, 38.01595], [-122.65969, 38.01626], [-122.65973, 38.01634], [-122.66083, 38.01663], [-122.66241, 38.01653], [-122.66247, 38.01681], [-122.66323, 38.01713], [-122.66375, 38.0171], [-122.66378, 38.01731], [-122.66378, 38.01752], [-122.66374, 38.01773], [-122.66368, 38.01793], [-122.66345, 38.01848], [-122.66321, 38.01886], [-122.66316, 38.01893], [-122.66208, 38.01993], [-122.66031, 38.02172], [-122.66017, 38.0219], [-122.66012, 38.022], [-122.66005, 38.02221], [-122.66005, 38.02229], [-122.66008, 38.02244], [-122.66015, 38.02259], [-122.66024, 38.02273], [-122.66036, 38.02285], [-122.66053, 38.02293], [-122.6607, 38.023], [-122.66088, 38.02304], [-122.66107, 38.02305], [-122.66127, 38.02304], [-122.66213, 38.02273], [-122.66266, 38.0225], [-122.66279, 38.02243], [-122.66302, 38.02236], [-122.66326, 38.02233], [-122.66358, 38.02236], [-122.6638, 38.02244], [-122.66392, 38.02252], [-122.66397, 38.02257], [-122.66405, 38.02269], [-122.6642, 38.02297], [-122.66428, 38.02321]]]} Open Access 1 294 Roy's Redwoods Open Space Preserve 29292 2070 Marin County Open Space District 44 Special District 4 Recreation/Parks District 4 http://www.marincountyparks.org/Depts/PK.aspx Special District 4 2070 Marin County Open Space District 43 Special District 4 Recreation/Parks District 4 http://www.marincountyparks.org/depts/pk/divisions/open-space/roys-redwoods Marin 23 281.798 Roy's Redwoods OSP 1978 Local Conservation Area 4 2
112 111 {"type": "MultiPolygon", "coordinates": [[[[-121.89676, 36.61064], [-121.89648, 36.61079], [-121.89639, 36.61069], [-121.8964, 36.61049], [-121.89638, 36.61044], [-121.89628, 36.61029], [-121.89611, 36.6101], [-121.89602, 36.61002], [-121.89595, 36.61], [-121.8958, 36.61], [-121.89572, 36.60995], [-121.8956, 36.60978], [-121.89551, 36.6097], [-121.89543, 36.60948], [-121.89573, 36.60943], [-121.89676, 36.61064]]], [[[-121.89709, 36.61029], [-121.89683, 36.61043], [-121.89595, 36.60939], [-121.89629, 36.60934], [-121.89709, 36.61029]]]]} Open Access 1 327 San Carlos Beach Park 24846 2085 Monterey Peninsula Regional Park District 47 Special District 4 Recreation/Parks District 4 http://www.mprpd.org/ Special District 4 2085 Monterey Peninsula Regional Park District 46 Special District 4 Recreation/Parks District 4   Monterey 14 1.92 San Carlos Beach Park 0 Local Park 2 4
195 194 {"type": "Polygon", "coordinates": [[[-117.04739, 34.89181], [-117.04738, 34.89249], [-117.04398, 34.89336], [-117.04397, 34.89172], [-117.04739, 34.89181]]]} Open Access 1 569 Foglesong Park/Eda Henderson Pool 18966 2203 Barstow Recreation and Park District 78 Special District 4 Recreation/Parks District 4   Special District 4 2203 Barstow Recreation and Park District 76 Special District 4 Recreation/Parks District 4   San Bernardino 22 9.887 Foglesong Park/Eda Henderson Pool 0 Local Recreation Area 3 4
197 196 {"type": "Polygon", "coordinates": [[[-118.66428, 34.25904], [-118.66428, 34.26108], [-118.66395, 34.26099], [-118.66351, 34.2609], [-118.66306, 34.26083], [-118.66261, 34.26078], [-118.66216, 34.26077], [-118.66178, 34.26077], [-118.66094, 34.26084], [-118.66094, 34.25904], [-118.66428, 34.25904]]]} Open Access 1 615 Santa Susana Park 25139 2118 Rancho Simi Recreation and Park District 80 Special District 4 Recreation/Parks District 4 http://www.rsrpd.org/ Special District 4 2118 Rancho Simi Recreation and Park District 78 Special District 4 Recreation/Parks District 4   Ventura 8 15.254 Santa Susana Park 0 Local Park 2 4
218 217 {"type": "MultiPolygon", "coordinates": [[[[-122.00283, 37.56787], [-122.00528, 37.56886], [-122.00536, 37.56876], [-122.00637, 37.56915], [-122.00646, 37.56905], [-122.00694, 37.56924], [-122.00841, 37.57037], [-122.00605, 37.57247], [-122.00581, 37.57272], [-122.00563, 37.57245], [-122.00561, 37.57245], [-122.00486, 37.57485], [-122.00167, 37.57418], [-122.00088, 37.57663], [-122.00033, 37.5765], [-121.99656, 37.57363], [-121.99685, 37.57277], [-121.99721, 37.57285], [-121.99723, 37.57284], [-121.99743, 37.56696], [-121.99852, 37.56669], [-121.99871, 37.5667], [-121.9987, 37.56677], [-121.99916, 37.56686], [-121.99961, 37.56698], [-122.00112, 37.56756], [-122.0012, 37.56746], [-122.00224, 37.56786], [-122.00235, 37.56771], [-122.00283, 37.56787]]], [[[-122.00227, 37.57706], [-122.00224, 37.57716], [-122.00227, 37.57718], [-122.00203, 37.57784], [-122.0005, 37.57666], [-122.00227, 37.57706]]], [[[-122.01347, 37.57268], [-122.01183, 37.57446], [-122.01014, 37.57619], [-122.00994, 37.57635], [-122.00973, 37.57651], [-122.00895, 37.57696], [-122.00821, 37.57742], [-122.00796, 37.57759], [-122.0077, 37.57782], [-122.00748, 37.57808], [-122.0073, 37.57835], [-122.00718, 37.57862], [-122.00706, 37.5786], [-122.00686, 37.57917], [-122.00811, 37.57947], [-122.00818, 37.57956], [-122.00772, 37.58092], [-122.00605, 37.58056], [-122.00568, 37.58164], [-122.00418, 37.58051], [-122.00216, 37.57896], [-122.00209, 37.57889], [-122.00203, 37.5788], [-122.00198, 37.57866], [-122.002, 37.57851], [-122.00244, 37.57734], [-122.00248, 37.57728], [-122.00258, 37.57724], [-122.003, 37.57733], [-122.00424, 37.57807], [-122.00588, 37.57674], [-122.00592, 37.57631], [-122.01114, 37.57138], [-122.01347, 37.57268]]]]} Open Access 1 586 Quarry Lakes Regional Recreation Area 30594 2032 East Bay Regional Park District 89 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4   Alameda 17 254.616 Quarry Lakes Reg. Rec. Area 2001 Local Recreation Area 3 4
270 269 {"type": "Polygon", "coordinates": [[[-122.25949, 38.27979], [-122.256, 38.27978], [-122.25255, 38.27973], [-122.25149, 38.27969], [-122.24965, 38.27967], [-122.24894, 38.27968], [-122.24877, 38.2797], [-122.24868, 38.27977], [-122.2455, 38.27976], [-122.24092, 38.27987], [-122.23633, 38.27986], [-122.23623, 38.2692], [-122.23162, 38.2692], [-122.23158, 38.26561], [-122.22698, 38.2656], [-122.21778, 38.26577], [-122.21775, 38.25878], [-122.21356, 38.25877], [-122.21355, 38.25427], [-122.21522, 38.25486], [-122.21607, 38.25492], [-122.21668, 38.25515], [-122.21783, 38.25499], [-122.218, 38.25496], [-122.2181, 38.25491], [-122.21855, 38.25484], [-122.21902, 38.25461], [-122.22004, 38.2545], [-122.22463, 38.2543], [-122.22694, 38.2551], [-122.22708, 38.25525], [-122.22793, 38.25583], [-122.23018, 38.25708], [-122.23043, 38.25707], [-122.23061, 38.25715], [-122.23125, 38.25736], [-122.23153, 38.25752], [-122.2318, 38.2578], [-122.23188, 38.25803], [-122.23203, 38.25818], [-122.23214, 38.25825], [-122.23216, 38.25843], [-122.2361, 38.25846], [-122.23622, 38.26562], [-122.24539, 38.26563], [-122.24554, 38.27172], [-122.24785, 38.27207], [-122.24862, 38.27265], [-122.24555, 38.27268], [-122.24554, 38.27217], [-122.24552, 38.27271], [-122.24869, 38.2727], [-122.25123, 38.27447], [-122.25798, 38.27448], [-122.25809, 38.27431], [-122.25844, 38.27448], [-122.25943, 38.27448], [-122.25949, 38.27979]]]} Open Access 1 916 Skyline Wilderness Park 835 222 California Bureau of Real Estate 111 State 5 State Agency 5 http://www.bre.ca.gov/ Other State 5 2268 Napa County Regional Park and Open Space District 108 Special District 4 Recreation/Parks District 4 http://www.skylinepark.org/ Napa 11 1021.072 Skyline Wilderness Park 1983 Local Conservation Area 4 2
303 302 {"type": "Polygon", "coordinates": [[[-118.87425, 34.22586], [-118.87258, 34.2261], [-118.87258, 34.22433], [-118.87408, 34.22434], [-118.87409, 34.22539], [-118.87418, 34.22551], [-118.87425, 34.22586]]]} Open Access 1 1040 Spring Meadow Park 25741 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 6.467 Spring Meadow Park 0 Local Park 2 4
358 357 {"type": "Polygon", "coordinates": [[[-118.84164, 34.14351], [-118.84162, 34.14361], [-118.84153, 34.1437], [-118.84153, 34.14379], [-118.84163, 34.14385], [-118.84147, 34.14417], [-118.84155, 34.14456], [-118.8412, 34.14464], [-118.84027, 34.14465], [-118.83984, 34.1442], [-118.83987, 34.14412], [-118.84004, 34.14402], [-118.84058, 34.14361], [-118.84113, 34.14306], [-118.84128, 34.14315], [-118.84155, 34.14336], [-118.84164, 34.14351]]]} Open Access 1 1009 Southshore Hills Park 25696 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 4.475 Southshore Hills Park 0 Local Park 2 4
365 364 {"type": "MultiPolygon", "coordinates": [[[[-119.08732, 34.22541], [-119.08716, 34.2256], [-119.08697, 34.22573], [-119.08674, 34.22581], [-119.08637, 34.22589], [-119.08621, 34.22533], [-119.08622, 34.22508], [-119.08664, 34.22498], [-119.08731, 34.22537], [-119.08732, 34.22541]]], [[[-119.08846, 34.22607], [-119.08817, 34.22634], [-119.0866, 34.22666], [-119.08642, 34.22605], [-119.08683, 34.22596], [-119.08707, 34.22587], [-119.08725, 34.22575], [-119.08748, 34.22552], [-119.08752, 34.22551], [-119.08846, 34.22607]]]]} Open Access 1 1045 Springville Park 25752 2113 Pleasant Valley Recreation and Park District 149 Special District 4 Recreation/Parks District 4 http://www.pvrpd.org/ Special District 4 2113 Pleasant Valley Recreation and Park District 145 Special District 4 Recreation/Parks District 4   Ventura 8 4.87 Springville Park 0 Local Park 2 4
368 367 {"type": "Polygon", "coordinates": [[[-118.91305, 34.18088], [-118.91256, 34.18067], [-118.912, 34.18037], [-118.91123, 34.18041], [-118.91136, 34.17666], [-118.91295, 34.17687], [-118.91305, 34.18088]]]} Open Access 1 1056 Stagecoach Inn Park 25777 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 16.214 Stagecoach Inn Park 0 Local Park 2 4
385 384 {"type": "Polygon", "coordinates": [[[-117.15388, 33.67064], [-117.15386, 33.67362], [-117.15375, 33.67366], [-117.15354, 33.67338], [-117.15342, 33.6733], [-117.15342, 33.67327], [-117.15317, 33.67312], [-117.15276, 33.67299], [-117.15275, 33.67297], [-117.15218, 33.67273], [-117.1521, 33.67268], [-117.15205, 33.67268], [-117.15209, 33.67232], [-117.15206, 33.67228], [-117.15172, 33.67207], [-117.15166, 33.67209], [-117.15161, 33.67209], [-117.15158, 33.67206], [-117.15137, 33.67206], [-117.15114, 33.67216], [-117.15096, 33.67243], [-117.15097, 33.67245], [-117.15093, 33.67262], [-117.15094, 33.67265], [-117.15089, 33.67283], [-117.15091, 33.67286], [-117.15091, 33.67306], [-117.15088, 33.67306], [-117.15083, 33.67326], [-117.15041, 33.67303], [-117.15016, 33.67299], [-117.14999, 33.67287], [-117.14973, 33.67259], [-117.14955, 33.67245], [-117.14936, 33.67232], [-117.14933, 33.67232], [-117.14914, 33.6722], [-117.14911, 33.6722], [-117.14903, 33.67215], [-117.14888, 33.67217], [-117.14849, 33.67226], [-117.1482, 33.67272], [-117.14817, 33.6727], [-117.14817, 33.67261], [-117.14814, 33.67256], [-117.1481, 33.67252], [-117.14802, 33.67247], [-117.14821, 33.67255], [-117.14865, 33.67182], [-117.14797, 33.67065], [-117.14945, 33.67065], [-117.14949, 33.67069], [-117.14974, 33.67069], [-117.14978, 33.67065], [-117.15154, 33.67065], [-117.15159, 33.67069], [-117.15184, 33.67069], [-117.15188, 33.67065], [-117.15388, 33.67064]]]} Open Access 1 48338 Lago Vista Sports Park 32901 2171 Valley-Wide Recreation and Park District 160 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/lago-vista-sports-park Riverside 10 28.451 Lago Vista Sports Park 0 Local Recreation Area 3 4
389 388 {"type": "Polygon", "coordinates": [[[-118.80196, 34.27578], [-118.801, 34.27578], [-118.80023, 34.27408], [-118.80034, 34.2741], [-118.80041, 34.27419], [-118.80046, 34.27422], [-118.80057, 34.27424], [-118.80064, 34.27422], [-118.80071, 34.27418], [-118.80074, 34.27413], [-118.80076, 34.27408], [-118.80183, 34.27407], [-118.80196, 34.27578]]]} Open Access 1 1158 Strathearn Historical Park & Museum 25908 2118 Rancho Simi Recreation and Park District 80 Special District 4 Recreation/Parks District 4 http://www.rsrpd.org/ Special District 4 2118 Rancho Simi Recreation and Park District 78 Special District 4 Recreation/Parks District 4   Ventura 8 5.386 Strathearn Historical Park & Museum 0 Local Historic or Cultural Area 19 4
403 402 {"type": "Polygon", "coordinates": [[[-122.51336, 37.9088], [-122.51314, 37.90905], [-122.51286, 37.9095], [-122.51262, 37.91045], [-122.51268, 37.91098], [-122.51245, 37.91139], [-122.51184, 37.91121], [-122.51148, 37.91148], [-122.51096, 37.91151], [-122.51099, 37.91097], [-122.51073, 37.90717], [-122.51103, 37.90745], [-122.51151, 37.90854], [-122.51207, 37.90839], [-122.51279, 37.90839], [-122.51308, 37.90879], [-122.51336, 37.9088]]]} Open Access 1 1554 Tiburon Ridge Open Space Preserve 26341 2070 Marin County Open Space District 44 Special District 4 Recreation/Parks District 4 http://www.marincountyparks.org/Depts/PK.aspx Special District 4 2070 Marin County Open Space District 43 Special District 4 Recreation/Parks District 4   Marin 23 14.684 Tiburon Ridge OSP 0 Local Conservation Area 4 2
447 446 {"type": "Polygon", "coordinates": [[[-119.86022, 34.41121], [-119.86022, 34.41162], [-119.85989, 34.41162], [-119.85989, 34.41121], [-119.86022, 34.41121]]]} Open Access 1 1418 Trigo Pasado Park 26535 2049 Isla Vista Recreation and Park District 174 Special District 4 Recreation/Parks District 4 http://www.ivparks.org/ Special District 4 2049 Isla Vista Recreation and Park District 170 Special District 4 Recreation/Parks District 4   Santa Barbara 7 0.344 Trigo Pasado Park 0 Local Park 2 4
450 449 {"type": "Polygon", "coordinates": [[[-118.84969, 34.15691], [-118.84861, 34.15729], [-118.8484, 34.15705], [-118.84823, 34.15692], [-118.8481, 34.15686], [-118.84745, 34.15669], [-118.8474, 34.15675], [-118.84724, 34.15671], [-118.84701, 34.15669], [-118.84647, 34.15673], [-118.84613, 34.15674], [-118.84609, 34.15669], [-118.84529, 34.15636], [-118.84513, 34.15634], [-118.84475, 34.15615], [-118.84455, 34.15601], [-118.84392, 34.15522], [-118.84377, 34.15509], [-118.84351, 34.15491], [-118.84278, 34.1546], [-118.84282, 34.15435], [-118.84282, 34.15411], [-118.84286, 34.15404], [-118.84303, 34.154], [-118.84331, 34.15383], [-118.84351, 34.15362], [-118.84361, 34.1534], [-118.8436, 34.15311], [-118.84357, 34.15296], [-118.84413, 34.15317], [-118.84731, 34.15444], [-118.84968, 34.15512], [-118.84969, 34.15691]]]} Open Access 1 1427 Triunfo Park 7237 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.lamountains.com/parks.asp?parkid=62 Ventura 8 38.958 Triunfo Park 0 Local Park 2 4
484 483 {"type": "Polygon", "coordinates": [[[-119.86222, 34.40916], [-119.86222, 34.40971], [-119.86197, 34.40971], [-119.86197, 34.40918], [-119.86222, 34.40916]]]} Open Access 1 1943 Window to the Sea Park 27630 2049 Isla Vista Recreation and Park District 174 Special District 4 Recreation/Parks District 4 http://www.ivparks.org/ Special District 4 2049 Isla Vista Recreation and Park District 170 Special District 4 Recreation/Parks District 4   Santa Barbara 7 0.344 Window to the Sea Park 0 Local Park 2 4
487 486 {"type": "Polygon", "coordinates": [[[-119.05827, 34.22788], [-119.05689, 34.22789], [-119.05662, 34.22786], [-119.05661, 34.22533], [-119.05785, 34.22532], [-119.05785, 34.22557], [-119.05784, 34.22566], [-119.05788, 34.22578], [-119.05795, 34.22584], [-119.05803, 34.22588], [-119.05815, 34.2259], [-119.05826, 34.22588], [-119.05827, 34.22788]]]} Open Access 1 1684 Valle Lindo Park 26770 2113 Pleasant Valley Recreation and Park District 149 Special District 4 Recreation/Parks District 4 http://www.pvrpd.org/ Special District 4 2113 Pleasant Valley Recreation and Park District 145 Special District 4 Recreation/Parks District 4   Ventura 8 10.069 Valle Lindo Park 0 Local Park 2 4
491 490 {"type": "Polygon", "coordinates": [[[-119.00089, 34.23254], [-119.0007, 34.23357], [-118.99913, 34.23337], [-118.99889, 34.23332], [-118.99884, 34.23328], [-118.99892, 34.23277], [-118.99894, 34.23232], [-119.00089, 34.23254]]]} Open Access 1 1963 Woodcreek Park 27704 2113 Pleasant Valley Recreation and Park District 149 Special District 4 Recreation/Parks District 4 http://www.pvrpd.org/ Special District 4 2113 Pleasant Valley Recreation and Park District 145 Special District 4 Recreation/Parks District 4   Ventura 8 4.956 Woodcreek Park 0 Local Park 2 4
503 502 {"type": "Polygon", "coordinates": [[[-118.97368, 34.20139], [-118.97368, 34.20163], [-118.97362, 34.20181], [-118.97355, 34.20201], [-118.97325, 34.20261], [-118.9732, 34.20278], [-118.97311, 34.20316], [-118.97299, 34.20341], [-118.97275, 34.20377], [-118.97187, 34.20442], [-118.97113, 34.20556], [-118.96893, 34.20529], [-118.97135, 34.20156], [-118.97201, 34.20157], [-118.97264, 34.20153], [-118.97368, 34.20139]]]} Open Access 1 48367 Camarillo Grove Park 32933 2113 Pleasant Valley Recreation and Park District 149 Special District 4 Recreation/Parks District 4 http://www.pvrpd.org/ Special District 4 2113 Pleasant Valley Recreation and Park District 145 Special District 4 Recreation/Parks District 4 http://www.pvrpd.org/parks/park_list/camarillo_grove_park.asp Ventura 8 25.264 Camarillo Grove Park 0 Local Park 2 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Query took 595.761ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette