units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
168 rows where ACCESS_TYP = 2 and MNG_AG_LEV = 6 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, YR_EST, GAP_STS
MNG_AGENCY >30
- Sempervirens Fund 16
- The Nature Conservancy 14
- Land Trust of Napa County 14
- Big Sur Land Trust 14
- Sonoma Land Trust 9
- Center for Natural Lands Management 5
- Solano Land Trust 5
- Truckee Donner Land Trust 5
- Rivers and Lands Conservancy 5
- Sequoia Riverlands Trust 4
- Land Trust of Santa Cruz County 4
- Save Mount Diablo 4
- National Audubon Society 4
- San Diego River Park Foundation 4
- The Wildlands Conservancy 3
- Peninsula Open Space Trust 3
- Mountains Restoration Trust 3
- The Conservation Fund - California 3
- Save the Redwoods League 2
- Santa Lucia Conservancy 2
- Bear Yuba Land Trust 2
- LandPaths 2
- Land Trust for Santa Barbara County 2
- Fallbrook Land Conservancy 2
- Santa Catalina Island Conservancy 2
- Los Angeles Neighborhood Land Trust 2
- Lake County Land Trust 2
- American River Conservancy 2
- Nonprofit Organization - Unknown 2
- John Muir Land Trust 1
- …
DES_TP 12
- Private Conservation 142
- Private Recreation or Education 7
- Private Other or Unknown 7
- Private Agricultural 4
- State Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 4
ACCESS_TYP 1
- Restricted Access · 168 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
442 | 442 | 441 | {"type": "Polygon", "coordinates": [[[-121.93363, 36.54329], [-121.93317, 36.54325], [-121.93307, 36.54313], [-121.93323, 36.54306], [-121.93329, 36.54312], [-121.93337, 36.54317], [-121.93363, 36.54329]]]} | Restricted Access 2 | 1381 | Tor House | 26411 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.129 | Tor House | 0 | Private Conservation 16 | 2 | |
4444 | 4444 | 4443 | {"type": "Polygon", "coordinates": [[[-118.29797, 34.03179], [-118.29758, 34.03179], [-118.29757, 34.03163], [-118.29797, 34.03162], [-118.29797, 34.03179]]]} | Restricted Access 2 | 46513 | Erika J. Glazer Community Garden | 29800 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 0.165 | Erika J. Glazer Community Garden | 0 | Private Conservation 16 | 2 | |
10215 | 10215 | 10214 | {"type": "Polygon", "coordinates": [[[-121.91841, 36.54792], [-121.91818, 36.54805], [-121.91774, 36.54778], [-121.91774, 36.54777], [-121.9183, 36.54778], [-121.91841, 36.54792]]]} | Restricted Access 2 | 17874 | Mission Trails/Probasco | 22315 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.256 | Mission Trails/Probasco | 0 | Private Conservation 16 | 2 | |
2296 | 2296 | 2295 | {"type": "Polygon", "coordinates": [[[-121.93865, 36.50129], [-121.93862, 36.50189], [-121.93831, 36.5019], [-121.93831, 36.50186], [-121.93839, 36.50179], [-121.93842, 36.50173], [-121.9384, 36.50165], [-121.93832, 36.5016], [-121.93831, 36.50147], [-121.93849, 36.50138], [-121.93848, 36.50133], [-121.93865, 36.50129]]]} | Restricted Access 2 | 16894 | Highlands Inn turnout | 19940 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.373 | Highlands Inn turnout | 0 | Private Conservation 16 | 2 | |
15336 | 15336 | 15335 | {"type": "Polygon", "coordinates": [[[-118.30015, 33.94065], [-118.30015, 33.94116], [-118.29968, 33.94116], [-118.29969, 33.94065], [-118.30015, 33.94065]]]} | Restricted Access 2 | 46515 | West Athens Victory Garden | 29801 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://littlegreenfingersla.org/garden/west-athens-victory-garden/ | Los Angeles 6 | 0.591 | West Athens Victory Garden | 2013 | Private Conservation 16 | 2 |
9846 | 9846 | 9845 | {"type": "Polygon", "coordinates": [[[-121.75445, 36.22079], [-121.75378, 36.22097], [-121.75356, 36.22094], [-121.7535, 36.2208], [-121.75377, 36.22063], [-121.75412, 36.22022], [-121.7541, 36.22039], [-121.75416, 36.22056], [-121.75428, 36.2207], [-121.75445, 36.22079]]]} | Restricted Access 2 | 16833 | Henry Miller Library | 19825 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.706 | Henry Miller Library | 0 | Private Conservation 16 | 2 | |
10499 | 10499 | 10498 | {"type": "MultiPolygon", "coordinates": [[[[-122.50461, 38.11713], [-122.50461, 38.11714], [-122.50399, 38.11757], [-122.50451, 38.11703], [-122.50461, 38.11713]]], [[[-122.50863, 38.1256], [-122.50826, 38.12589], [-122.5074, 38.1264], [-122.5073, 38.12632], [-122.5077, 38.12596], [-122.50808, 38.12568], [-122.50863, 38.1256]]]]} | Restricted Access 2 | 18650 | Petaluma River Marsh | 23624 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 0.8 | Petaluma River Marsh | 0 | Private Conservation 16 | 2 | |
16969 | 16969 | 16968 | {"type": "Polygon", "coordinates": [[[-118.6238, 34.10536], [-118.62339, 34.10535], [-118.62338, 34.10426], [-118.62367, 34.10438], [-118.6238, 34.10442], [-118.6238, 34.10536]]]} | Restricted Access 2 | 12501 | Mountains Restoration Trust Parkland | 29662 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 1.053 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
7188 | 7188 | 7187 | {"type": "MultiPolygon", "coordinates": [[[[-118.38426, 33.41378], [-118.3842, 33.41383], [-118.38414, 33.41394], [-118.38401, 33.41383], [-118.384, 33.41378], [-118.38413, 33.41372], [-118.38426, 33.41372], [-118.38426, 33.41378]]], [[[-118.38964, 33.41779], [-118.38964, 33.41785], [-118.38958, 33.41785], [-118.38951, 33.41779], [-118.38951, 33.41769], [-118.38957, 33.41769], [-118.38964, 33.41779]]], [[[-118.40478, 33.42155], [-118.4047, 33.42166], [-118.40464, 33.42166], [-118.40457, 33.42161], [-118.40457, 33.42155], [-118.40464, 33.42149], [-118.4047, 33.42155], [-118.40478, 33.42155]]], [[[-118.40497, 33.42045], [-118.40496, 33.42056], [-118.4049, 33.42056], [-118.40477, 33.42051], [-118.40484, 33.42045], [-118.40497, 33.42045]]], [[[-118.47979, 33.38818], [-118.47972, 33.38823], [-118.47959, 33.38823], [-118.47959, 33.38818], [-118.47946, 33.38806], [-118.47946, 33.38796], [-118.47952, 33.38796], [-118.47959, 33.38802], [-118.47972, 33.38807], [-118.47979, 33.38818]]], [[[-118.4811, 33.38065], [-118.48097, 33.38071], [-118.48091, 33.38065], [-118.4809, 33.38059], [-118.4811, 33.3806], [-118.4811, 33.38065]]], [[[-118.48156, 33.37878], [-118.4815, 33.37889], [-118.48142, 33.37894], [-118.4813, 33.37889], [-118.48129, 33.37878], [-118.48133, 33.37875], [-118.48139, 33.37878], [-118.48144, 33.37879], [-118.48152, 33.37875], [-118.48156, 33.37878]]], [[[-118.4815, 33.37944], [-118.48149, 33.37954], [-118.48142, 33.37955], [-118.48136, 33.37949], [-118.48143, 33.37944], [-118.4815, 33.37944]]], [[[-118.48404, 33.39928], [-118.48397, 33.39934], [-118.48391, 33.39934], [-118.48391, 33.39926], [-118.48396, 33.39927], [-118.48401, 33.39924], [-118.48404, 33.39928]]], [[[-118.48436, 33.39945], [-118.48417, 33.39945], [-118.48417, 33.3994], [-118.48423, 33.39934], [-118.4843, 33.39934], [-118.48436, 33.39945]]], [[[-118.48607, 33.39978], [-118.48594, 33.39984], [-118.48588, 33.39978], [-118.48587, 33.39969], [-118.48595, 33.39971], [-118.48601, 33.39968], [-118.48607, 33.39978]]], [[[-118.52159, 33.4659], [-118.52152, 33.46601], [-118.52146, 33.46606], [-118.52132, 33.46612], [-118.52126, 33.46616], [-118.52119, 33.46606], [-118.5212, 33.46595], [-118.52126, 33.46589], [-118.52133, 33.46589], [-118.52146, 33.46584], [-118.52158, 33.46584], [-118.52159, 33.4659]]], [[[-118.52702, 33.46803], [-118.5269, 33.46799], [-118.52682, 33.468], [-118.52666, 33.46817], [-118.52666, 33.46821], [-118.52663, 33.46821], [-118.52656, 33.46816], [-118.52656, 33.4681], [-118.5267, 33.46799], [-118.52683, 33.46794], [-118.52696, 33.46799], [-118.52702, 33.46799], [-118.52702, 33.46803]]], [[[-118.56014, 33.43285], [-118.56001, 33.43285], [-118.55987, 33.4328], [-118.55988, 33.43274], [-118.55994, 33.43269], [-118.56007, 33.43274], [-118.56014, 33.43279], [-118.56014, 33.43285]]], [[[-118.58083, 33.4493], [-118.58077, 33.44936], [-118.58064, 33.44941], [-118.58051, 33.44931], [-118.58051, 33.44914], [-118.58057, 33.44908], [-118.5807, 33.44909], [-118.58083, 33.4492], [-118.58083, 33.4493]]], [[[-118.60553, 33.47252], [-118.60547, 33.47263], [-118.60527, 33.47264], [-118.60527, 33.47246], [-118.6052, 33.47236], [-118.6052, 33.47225], [-118.60533, 33.47225], [-118.60547, 33.4723], [-118.60553, 33.47242], [-118.60553, 33.47252]]]]} | Restricted Access 2 | 6341 | Offshore Island | 23072 | 3070 | Santa Catalina Island Conservancy 382 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.catalinaconservancy.org/ | Non Governmental Organization 10 | 3070 | Santa Catalina Island Conservancy 377 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 1.431 | Offshore Island | 0 | Private Conservation 16 | 2 | |
4063 | 4063 | 4062 | {"type": "Polygon", "coordinates": [[[-122.00321, 37.0735], [-122.00314, 37.07355], [-122.00311, 37.07363], [-122.00284, 37.07352], [-122.00255, 37.07347], [-122.00256, 37.07375], [-122.00202, 37.07388], [-122.00183, 37.07412], [-122.00138, 37.0739], [-122.00159, 37.07363], [-122.00172, 37.07352], [-122.0019, 37.07342], [-122.00216, 37.07336], [-122.00242, 37.07332], [-122.00269, 37.07334], [-122.00297, 37.0734], [-122.00321, 37.0735]]]} | Restricted Access 2 | 47063 | Glenwood | 30716 | 3036 | Land Trust of Santa Cruz County 121 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 1.506 | Glenwood | 0 | Private Conservation 16 | 2 | |
4594 | 4594 | 4593 | {"type": "Polygon", "coordinates": [[[-117.34544, 33.91468], [-117.34509, 33.91482], [-117.34481, 33.91495], [-117.34443, 33.91447], [-117.3444, 33.91406], [-117.34438, 33.91401], [-117.34438, 33.91173], [-117.34444, 33.9118], [-117.34479, 33.91339], [-117.34492, 33.91372], [-117.34544, 33.91468]]]} | Restricted Access 2 | 35501 | Unnamed site - Riverside Land Conservancy | 28657 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 3.461 | 0 | Private Other or Unknown 399 | 4 | ||
10925 | 10925 | 10924 | {"type": "Polygon", "coordinates": [[[-121.81078, 39.71922], [-121.81078, 39.71922], [-121.8073, 39.71927], [-121.80736, 39.71921], [-121.80879, 39.71919], [-121.80878, 39.71845], [-121.81077, 39.71844], [-121.81078, 39.71922]]]} | Restricted Access 2 | 48675 | Silver Dollar BMX | 33416 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 3395 | Silver Dollar BMX 929 | Non Profit 6 | Non Profit - Other 20 | https://www.usabmx.com/tracks/1344/about | Butte 42 | 3.937 | Silver Dollar BMX | None 953 | ||
9507 | 9507 | 9506 | {"type": "Polygon", "coordinates": [[[-117.77532, 34.12952], [-117.77504, 34.12945], [-117.77433, 34.1294], [-117.77405, 34.12932], [-117.77412, 34.12916], [-117.77405, 34.12898], [-117.77414, 34.12894], [-117.77431, 34.1287], [-117.77434, 34.12868], [-117.77432, 34.1286], [-117.7742, 34.12857], [-117.77402, 34.12834], [-117.77396, 34.12824], [-117.77394, 34.12812], [-117.77421, 34.12799], [-117.77383, 34.12742], [-117.774, 34.1274], [-117.77418, 34.12741], [-117.77492, 34.12751], [-117.77483, 34.12784], [-117.77483, 34.12796], [-117.77491, 34.12831], [-117.77504, 34.12875], [-117.77512, 34.12876], [-117.77516, 34.12873], [-117.77532, 34.12952]]]} | Restricted Access 2 | 47831 | La Verne Heritage Foundation | 31773 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 3382 | La Verne Heritage Foundation 888 | Non Profit 6 | Non Profit - Other 20 | Los Angeles 6 | 4.634 | La Verne Heritage Foundation | None 788 | |||
5753 | 5753 | 5752 | {"type": "Polygon", "coordinates": [[[-119.54118, 36.51798], [-119.54116, 36.52003], [-119.54018, 36.52002], [-119.54021, 36.51798], [-119.54118, 36.51798]]]} | Restricted Access 2 | 3683 | Kingsburg Historical Park | 32675 | 3138 | Kingsburg Historical Society 817 | Non Profit 6 | Non Profit - Other 22 | http://www.kingsburghistoricalpark.org/ | Non Governmental Organization 10 | 3138 | Kingsburg Historical Society 795 | Non Profit 6 | Non Profit - Other 20 | http://kingsburghistoricalpark.org/ | Fresno 9 | 4.887 | Kingsburg Historical Park | 0 | Private Recreation or Education 65 | 4 |
9956 | 9956 | 9955 | {"type": "Polygon", "coordinates": [[[-121.43202, 35.86496], [-121.43153, 35.86465], [-121.42979, 35.86366], [-121.42952, 35.86346], [-121.42931, 35.86325], [-121.4306, 35.86327], [-121.43074, 35.86332], [-121.43083, 35.86332], [-121.43092, 35.86336], [-121.43109, 35.8634], [-121.43128, 35.8635], [-121.43137, 35.86353], [-121.43147, 35.86354], [-121.43164, 35.86366], [-121.43173, 35.86367], [-121.43193, 35.86378], [-121.43198, 35.86385], [-121.43202, 35.86496]]]} | Restricted Access 2 | 17132 | Kopp | 20717 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 5.005 | Kopp | 0 | Private Conservation 16 | 2 | |
12735 | 12735 | 12734 | {"type": "Polygon", "coordinates": [[[-122.14589, 37.21808], [-122.14582, 37.21821], [-122.14578, 37.21847], [-122.14559, 37.21887], [-122.14558, 37.21907], [-122.14553, 37.21919], [-122.14372, 37.2192], [-122.1437, 37.2181], [-122.14589, 37.21808]]]} | Restricted Access 2 | 29766 | Gee | 19247 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 5.342 | Gee | 0 | Private Conservation 16 | 2 | |
4471 | 4471 | 4470 | {"type": "Polygon", "coordinates": [[[-116.62024, 32.8546], [-116.62023, 32.85532], [-116.61829, 32.85533], [-116.61829, 32.85491], [-116.618, 32.85491], [-116.61799, 32.85435], [-116.61875, 32.85434], [-116.61914, 32.85341], [-116.61924, 32.85343], [-116.6193, 32.85399], [-116.61991, 32.8542], [-116.6198, 32.85446], [-116.62024, 32.8546]]]} | Restricted Access 2 | 1199 | Unnamed site - Nonprofit Organization - Unknown | 28649 | 3048 | Nonprofit Organization - Unknown 765 | Non Profit 6 | Non Profit - Other 22 | Non Governmental Organization 10 | 3048 | Nonprofit Organization - Unknown 746 | Non Profit 6 | Non Profit - Other 20 | San Diego 4 | 6.306 | 0 | Private Other or Unknown 399 | 4 | |||
3450 | 3450 | 3449 | {"type": "Polygon", "coordinates": [[[-122.19466, 37.15793], [-122.19268, 37.15833], [-122.19133, 37.15817], [-122.1914, 37.15754], [-122.19169, 37.15748], [-122.19213, 37.15729], [-122.19248, 37.15727], [-122.19291, 37.15713], [-122.19325, 37.15713], [-122.19388, 37.15727], [-122.19424, 37.15748], [-122.19448, 37.15752], [-122.19466, 37.15793]]]} | Restricted Access 2 | 25308 | Griffith | 19515 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 6.861 | Griffith | 0 | Private Conservation 16 | 2 | |
11275 | 11275 | 11274 | {"type": "Polygon", "coordinates": [[[-121.46596, 38.66791], [-121.46595, 38.66872], [-121.46583, 38.66866], [-121.46595, 38.66841], [-121.46579, 38.66833], [-121.46512, 38.6682], [-121.46418, 38.66813], [-121.46331, 38.66809], [-121.463, 38.66824], [-121.46235, 38.66836], [-121.46193, 38.66838], [-121.46111, 38.66833], [-121.46048, 38.66832], [-121.45968, 38.66858], [-121.45913, 38.66879], [-121.45875, 38.66888], [-121.45845, 38.66893], [-121.45814, 38.66895], [-121.4572, 38.66894], [-121.45713, 38.66904], [-121.45712, 38.66929], [-121.4569, 38.66927], [-121.4569, 38.66844], [-121.45715, 38.66844], [-121.4573, 38.66859], [-121.45804, 38.6686], [-121.45838, 38.66858], [-121.45884, 38.66849], [-121.45949, 38.66826], [-121.46, 38.66809], [-121.4603, 38.66801], [-121.46073, 38.66797], [-121.46113, 38.66797], [-121.46194, 38.66802], [-121.46228, 38.66801], [-121.46282, 38.6679], [-121.46319, 38.66773], [-121.46422, 38.66777], [-121.46423, 38.6678], [-121.46516, 38.66788], [-121.46575, 38.66796], [-121.46584, 38.6679], [-121.46596, 38.66791]]]} | Restricted Access 2 | 21781 | Dry Creek Watershed | 18286 | 3061 | Sacramento Valley Conservancy 972 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sacramentovalleyconservancy.org/ | Non Governmental Organization 10 | 3061 | Sacramento Valley Conservancy 937 | Non Profit 6 | Non Profit - Land Trust 10 | Sacramento 41 | 8.226 | Dry Creek Watershed | 0 | Private Conservation 16 | 2 | |
12587 | 12587 | 12586 | {"type": "Polygon", "coordinates": [[[-117.18941, 33.5381], [-117.18772, 33.53937], [-117.1867, 33.53844], [-117.18884, 33.53681], [-117.1892, 33.53738], [-117.18941, 33.5381]]]} | Restricted Access 2 | 48772 | Murrieta Valley Pony Baseball | 33498 | 3397 | Murrieta Valley PONY Baseball, Inc 1031 | Non Profit 6 | Non Profit - Other 22 | https://www.mvpb.org/ | Non Governmental Organization 10 | 3397 | Murrieta Valley PONY Baseball, Inc 992 | Non Profit 6 | Non Profit - Other 20 | https://www.mvpb.org/ | Riverside 10 | 8.519 | Murrieta Valley Pony Baseball | 0 | Private Conservation 16 | 2 |
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]);