units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Parks and Recreation 238
- California Department of Fish and Wildlife 231
- San Diego, City of 147
- Sacramento, City of 145
- Los Angeles, City of 119
- Mountains Recreation and Conservation Authority 115
- East Bay Regional Park District 114
- Ventura, City of 104
- Roseville, City of 97
- Consumnes Community Services District 86
- Los Angeles, County of 65
- California State Lands Commission 64
- United States Fish and Wildlife Service 62
- Long Beach, City of 61
- United States Bureau of Land Management 56
- Davis, City of 56
- Irvine, City of 45
- Butte, County of 45
- Poway, City of 43
- United States Forest Service 42
- Tracy, City of 42
- Orange, County of 41
- Folsom, City of 40
- Lake, County of 39
- Murrieta, City of 39
- Rocklin, City of 39
- San Ramon, City of 38
- Sacramento, County of 38
- Midpeninsula Regional Open Space District 38
- Stockton, City of 37
- …
DES_TP >30
- Local Park 2,779
- Local Recreation Area 966
- Local Other or Unknown 703
- Private Conservation 235
- State Conservation Area 219
- Local Conservation Area 213
- Private Recreation or Education 141
- State Park 139
- State Resource Management Area 88
- State Recreation Area 77
- National Wildlife Refuge 55
- State Historic or Cultural Area 41
- National Forest 40
- National Public Lands 39
- Recreation Management Area 22
- National Monument or Landmark 20
- State Other or Unknown 17
- National Recreation Area 13
- National Park 12
- Local Historic or Cultural Area 12
- Federal Other or Unknown 11
- Local Resource Management Area 10
- Conservation Area 9
- Private Other or Unknown 9
- Private Agricultural 8
- Resource Management Area 4
- Historic or Cultural Area 3
- Area of Critical Environmental Concern 2
- Wilderness Area 1
- State Wilderness 1
- …
MNG_AG_TYP 29
- City Agency 3,440
- State Agency 613
- Recreation/Parks District 547
- County Agency 469
- Federal Agency 226
- Non Profit - Land Trust 198
- Open Space District 161
- Community Services District 146
- Home Owners Association 112
- Water District 108
- County Agency - Parks 100
- Non Profit - Conservation 81
- Flood District 51
- Irrigation District 24
- School District 22
- Non Profit - Other 17
- County Agency - Other 11
- Special District - Other 11
- Port/Harbor District 7
- Commercial 7
- Other 5
- Transportation Agency 5
- Conservation District 4
- Cemetery District 3
- Joint Powers Authority 3
- Sanitation District 2
- Mitigation Bank 2
- Non Profit - Education 2
- Fire District 1
ACCESS_TYP 4
- Open Access 5,221
- Restricted Access 607
- No Public Access 380
- Unknown Access 170
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10691 | 10691 | 10690 | {"type": "Polygon", "coordinates": [[[-117.27216, 32.97823], [-117.27163, 32.97837], [-117.27094, 32.97727], [-117.27056, 32.97727], [-117.27028, 32.97763], [-117.27008, 32.97763], [-117.27008, 32.97727], [-117.26992, 32.97726], [-117.27001, 32.9771], [-117.2701, 32.97681], [-117.27025, 32.97658], [-117.27069, 32.97614], [-117.2714, 32.97626], [-117.27163, 32.97667], [-117.27181, 32.97708], [-117.27206, 32.97782], [-117.27216, 32.97823]]]} | Open Access 1 | 19844 | James Scripps Bluff Preserve | 20352 | 1082 | Del Mar, City of 93 | City 2 | City Agency 2 | http://www.delmar.ca.us/203/Beaches-Parks | City 2 | 1082 | Del Mar, City of 91 | City 2 | City Agency 2 | San Diego 4 | 6.327 | James Scripps Bluff Preserve | 0 | Local Conservation Area 4 | 2 | |
10692 | 10692 | 10691 | {"type": "Polygon", "coordinates": [[[-117.08488, 33.12287], [-117.08464, 33.12304], [-117.08445, 33.1233], [-117.0846, 33.1235], [-117.0841, 33.12379], [-117.08436, 33.12439], [-117.08377, 33.12476], [-117.08317, 33.12528], [-117.08246, 33.12364], [-117.0847, 33.12257], [-117.08488, 33.12287]]]} | Open Access 1 | 19847 | Grape Day Park | 19446 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/grape-day-park.aspx | San Diego 4 | 7.661 | Grape Day Park | 0 | Local Park 2 | 4 |
10693 | 10693 | 10692 | {"type": "Polygon", "coordinates": [[[-117.04937, 33.13247], [-117.04883, 33.13273], [-117.0484, 33.13207], [-117.04842, 33.13205], [-117.04818, 33.13167], [-117.04871, 33.13143], [-117.04937, 33.13247]]]} | Restricted Access 2 | 19848 | Oak Hill City Park | 31522 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 1.876 | Oak Hill City Park | 0 | Local Park 2 | 4 | |
10694 | 10694 | 10693 | {"type": "Polygon", "coordinates": [[[-117.03893, 32.78198], [-117.03809, 32.78256], [-117.03789, 32.78231], [-117.03721, 32.78271], [-117.03707, 32.78275], [-117.03552, 32.78275], [-117.03549, 32.78274], [-117.03549, 32.78264], [-117.03552, 32.78261], [-117.03554, 32.78265], [-117.03558, 32.78267], [-117.03607, 32.78267], [-117.03583, 32.78238], [-117.03689, 32.78154], [-117.03893, 32.78174], [-117.03893, 32.78198]]]} | Open Access 1 | 19850 | Sunset Park | 26055 | 1157 | La Mesa, City of 50 | City 2 | City Agency 2 | http://www.cityoflamesa.com/index.aspx?nid=410 | City 2 | 1157 | La Mesa, City of 48 | City 2 | City Agency 2 | http://www.cityoflamesa.com/400/Sunset-Park | San Diego 4 | 6.322 | Sunset Park | 0 | Local Park 2 | 4 |
10695 | 10695 | 10694 | {"type": "Polygon", "coordinates": [[[-117.01581, 32.76824], [-117.01537, 32.76826], [-117.01532, 32.76823], [-117.0153, 32.76819], [-117.01533, 32.76814], [-117.0155, 32.76803], [-117.0158, 32.76803], [-117.01581, 32.76824]]]} | Open Access 1 | 19851 | Porter Park | 23899 | 1157 | La Mesa, City of 50 | City 2 | City Agency 2 | http://www.cityoflamesa.com/index.aspx?nid=410 | City 2 | 1157 | La Mesa, City of 48 | City 2 | City Agency 2 | http://www.cityoflamesa.com/397/Porter-Park | San Diego 4 | 0.245 | Porter Park | 0 | Local Park 2 | 4 |
10696 | 10696 | 10695 | {"type": "Polygon", "coordinates": [[[-117.50348, 33.92772], [-117.50251, 33.92989], [-117.50242, 33.92988], [-117.50156, 33.93086], [-117.50142, 33.93067], [-117.50125, 33.93054], [-117.50115, 33.93049], [-117.50104, 33.93046], [-117.50092, 33.93045], [-117.50058, 33.93051], [-117.50057, 33.93047], [-117.50053, 33.93047], [-117.49988, 33.92856], [-117.50072, 33.92825], [-117.50109, 33.92828], [-117.50152, 33.92826], [-117.50215, 33.92813], [-117.50294, 33.9279], [-117.50347, 33.92771], [-117.50348, 33.92772]]]} | Open Access 1 | 19854 | Golden Park | 19369 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 15.176 | Golden Park | 0 | Local Park 2 | 4 | |
10697 | 10697 | 10696 | {"type": "Polygon", "coordinates": [[[-117.06759, 34.00134], [-117.06759, 34.00144], [-117.0673, 34.0017], [-117.06653, 34.00192], [-117.06612, 34.00192], [-117.06612, 34.00134], [-117.06759, 34.00134]]]} | Open Access 1 | 19879 | Creekside Park | 17783 | 1390 | Calimesa, City of 682 | City 2 | City Agency 2 | http://www.cityofcalimesa.net/ | City 2 | 1390 | Calimesa, City of 673 | City 2 | City Agency 2 | Riverside 10 | 1.689 | Creekside Park | 0 | Local Park 2 | 4 | |
10698 | 10698 | 10697 | {"type": "Polygon", "coordinates": [[[-117.45939, 33.92471], [-117.45996, 33.92582], [-117.46002, 33.92601], [-117.46004, 33.92623], [-117.46002, 33.92641], [-117.45998, 33.92658], [-117.45933, 33.92831], [-117.45763, 33.92787], [-117.45744, 33.92783], [-117.45553, 33.92783], [-117.45536, 33.92785], [-117.45518, 33.92791], [-117.45519, 33.92631], [-117.45527, 33.92629], [-117.45526, 33.92568], [-117.45773, 33.92493], [-117.45804, 33.92488], [-117.45891, 33.92481], [-117.45916, 33.92477], [-117.45939, 33.92471]]]} | Open Access 1 | 19858 | Challen Hill Park | 17115 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 33.132 | Challen Hill Park | 0 | Local Park 2 | 4 | |
10699 | 10699 | 10698 | {"type": "Polygon", "coordinates": [[[-117.44341, 33.90341], [-117.44327, 33.90362], [-117.44303, 33.90377], [-117.44231, 33.90407], [-117.44202, 33.9043], [-117.4418, 33.9046], [-117.44161, 33.90455], [-117.44127, 33.90455], [-117.44128, 33.90379], [-117.44133, 33.90359], [-117.44144, 33.9034], [-117.44156, 33.90326], [-117.44168, 33.90316], [-117.44266, 33.90261], [-117.44271, 33.9026], [-117.44277, 33.90262], [-117.44341, 33.90341]]]} | Open Access 1 | 19860 | Harrison Park | 19702 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 6.028 | Harrison Park | 0 | Local Park 2 | 4 | |
10700 | 10700 | 10699 | {"type": "Polygon", "coordinates": [[[-117.46036, 33.8924], [-117.45897, 33.89319], [-117.45756, 33.89148], [-117.4579, 33.89149], [-117.45792, 33.89136], [-117.45928, 33.89142], [-117.45965, 33.89158], [-117.46036, 33.8924]]]} | Open Access 1 | 19861 | Victoria Cross Park | 27074 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 7.06 | Victoria Cross Park | 0 | Local Park 2 | 4 | |
10701 | 10701 | 10700 | {"type": "Polygon", "coordinates": [[[-117.36263, 33.97145], [-117.36167, 33.97146], [-117.36167, 33.97143], [-117.36207, 33.97142], [-117.36206, 33.97072], [-117.36167, 33.97071], [-117.36167, 33.97062], [-117.36175, 33.97047], [-117.36181, 33.97046], [-117.36219, 33.97059], [-117.36224, 33.97066], [-117.36251, 33.97097], [-117.36262, 33.97106], [-117.36263, 33.97145]]]} | Open Access 1 | 19862 | Dario Vasquez Park | 17926 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 1.193 | Dario Vasquez Park | 0 | Local Park 2 | 4 | |
10702 | 10702 | 10701 | {"type": "Polygon", "coordinates": [[[-121.3766, 36.81988], [-121.37638, 36.82034], [-121.37622, 36.82054], [-121.37608, 36.82049], [-121.37582, 36.82042], [-121.37567, 36.82035], [-121.37558, 36.82029], [-121.3755, 36.82022], [-121.37567, 36.81997], [-121.37564, 36.81989], [-121.37512, 36.81967], [-121.37525, 36.81968], [-121.37551, 36.81974], [-121.37565, 36.81975], [-121.37582, 36.81974], [-121.37603, 36.8197], [-121.37607, 36.81971], [-121.37618, 36.81982], [-121.3763, 36.81987], [-121.37644, 36.8199], [-121.3766, 36.81988]]]} | Open Access 1 | 48643 | Oak Creek Park | 33389 | 317 | San Benito, County of 197 | County 3 | County Agency 3 | http://sbcparks.org/ | County 3 | 317 | San Benito, County of 193 | County 3 | County Agency 3 | https://www.cosb.us/business/county-business-parks/ | San Benito 38 | 1.481 | Oak Creek Park | 0 | Local Park 2 | 4 |
10703 | 10703 | 10702 | {"type": "MultiPolygon", "coordinates": [[[[-117.45748, 33.93032], [-117.45696, 33.93055], [-117.45685, 33.9303], [-117.45635, 33.9303], [-117.45634, 33.92971], [-117.45667, 33.92988], [-117.45692, 33.92988], [-117.45719, 33.92984], [-117.45748, 33.93032]]], [[[-117.46005, 33.93408], [-117.45945, 33.93387], [-117.45903, 33.93388], [-117.45891, 33.93342], [-117.45839, 33.93258], [-117.45813, 33.93269], [-117.45809, 33.93262], [-117.45833, 33.9325], [-117.45785, 33.93171], [-117.45762, 33.93157], [-117.45742, 33.93157], [-117.45754, 33.93125], [-117.45743, 33.93101], [-117.45709, 33.93091], [-117.45701, 33.93071], [-117.45758, 33.93047], [-117.45766, 33.93059], [-117.45798, 33.93077], [-117.45806, 33.93088], [-117.45868, 33.93185], [-117.45891, 33.93175], [-117.45898, 33.93186], [-117.45875, 33.93198], [-117.4592, 33.93271], [-117.45924, 33.93286], [-117.45933, 33.93298], [-117.45956, 33.93287], [-117.45967, 33.93295], [-117.45957, 33.93316], [-117.4598, 33.93348], [-117.45976, 33.93354], [-117.45977, 33.93361], [-117.4598, 33.93366], [-117.45989, 33.93372], [-117.45993, 33.93376], [-117.46002, 33.93393], [-117.46005, 33.93408]]]]} | Open Access 1 | 19859 | El Dorado Open Space Park | 18503 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 8.427 | El Dorado OS Park | 0 | Local Recreation Area 3 | 4 | |
10704 | 10704 | 10703 | {"type": "Polygon", "coordinates": [[[-117.40078, 33.68705], [-117.40065, 33.68723], [-117.40054, 33.68729], [-117.40043, 33.68757], [-117.40029, 33.68771], [-117.40016, 33.68775], [-117.39981, 33.68762], [-117.39954, 33.68758], [-117.39733, 33.68757], [-117.39678, 33.68734], [-117.39588, 33.68656], [-117.39619, 33.68621], [-117.39646, 33.68581], [-117.39663, 33.68543], [-117.39671, 33.6852], [-117.39677, 33.68497], [-117.39714, 33.68509], [-117.39755, 33.68527], [-117.39787, 33.68546], [-117.39829, 33.68576], [-117.39852, 33.6859], [-117.39872, 33.68601], [-117.39938, 33.68628], [-117.39964, 33.68643], [-117.39993, 33.68665], [-117.40016, 33.68679], [-117.40045, 33.68693], [-117.40078, 33.68705]]]} | Open Access 1 | 19875 | McVicker Canyon Park | 28282 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=851 | Riverside 10 | 18.103 | McVicker Canyon Park | 0 | Local Park 2 | 4 |
10705 | 10705 | 10704 | {"type": "Polygon", "coordinates": [[[-117.3338, 33.6662], [-117.33359, 33.66642], [-117.33375, 33.66652], [-117.33364, 33.66653], [-117.33324, 33.66754], [-117.33232, 33.6673], [-117.3322, 33.66738], [-117.33146, 33.66717], [-117.33217, 33.66595], [-117.33228, 33.66585], [-117.33268, 33.66608], [-117.33274, 33.66592], [-117.33238, 33.66571], [-117.33249, 33.66554], [-117.33244, 33.66551], [-117.33254, 33.66534], [-117.3338, 33.6662]]]} | Open Access 1 | 19876 | Swick and Matich Park | 26109 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 7.124 | Swick and Matich Park | 0 | Local Park 2 | 4 | |
10706 | 10706 | 10705 | {"type": "Polygon", "coordinates": [[[-117.2986, 33.66519], [-117.29859, 33.66565], [-117.29855, 33.66584], [-117.29846, 33.66606], [-117.29839, 33.66608], [-117.29804, 33.66592], [-117.29774, 33.66584], [-117.29749, 33.66581], [-117.29721, 33.66581], [-117.29694, 33.66579], [-117.29715, 33.66497], [-117.29785, 33.66509], [-117.29833, 33.66523], [-117.2986, 33.66519]]]} | Open Access 1 | 19877 | Summerhill Park | 25960 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 3.106 | Summerhill Park | 0 | Local Park 2 | 4 | |
10707 | 10707 | 10706 | {"type": "Polygon", "coordinates": [[[-117.11049, 33.47644], [-117.11016, 33.47649], [-117.10983, 33.47658], [-117.10978, 33.47649], [-117.10973, 33.47622], [-117.10966, 33.47605], [-117.11027, 33.47583], [-117.11049, 33.47644]]]} | Open Access 1 | 19945 | John Magee Park | 20454 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 1.004 | John Magee Park | 0 | Local Park 2 | 4 | |
10708 | 10708 | 10707 | {"type": "MultiPolygon", "coordinates": [[[[-117.37087, 33.994], [-117.37078, 33.99435], [-117.37031, 33.99412], [-117.36972, 33.99353], [-117.36958, 33.99334], [-117.36949, 33.99316], [-117.36942, 33.99296], [-117.36938, 33.99277], [-117.36938, 33.99257], [-117.3694, 33.99237], [-117.36946, 33.99218], [-117.36955, 33.99197], [-117.36982, 33.99158], [-117.37012, 33.99184], [-117.36983, 33.99208], [-117.36977, 33.99312], [-117.36986, 33.9934], [-117.37009, 33.99365], [-117.37087, 33.994]]], [[[-117.37086, 33.99581], [-117.37063, 33.99558], [-117.37069, 33.99542], [-117.37072, 33.99526], [-117.37073, 33.99505], [-117.37071, 33.99487], [-117.37066, 33.99469], [-117.3706, 33.99454], [-117.37052, 33.99438], [-117.37041, 33.99424], [-117.37078, 33.99442], [-117.37117, 33.99516], [-117.37118, 33.99526], [-117.37115, 33.99537], [-117.37086, 33.99581]]], [[[-117.39089, 33.99042], [-117.39043, 33.99084], [-117.38686, 33.99507], [-117.3868, 33.99555], [-117.38653, 33.99587], [-117.38657, 33.9959], [-117.38427, 33.99864], [-117.38249, 33.99753], [-117.38234, 33.99761], [-117.38223, 33.99748], [-117.38215, 33.99752], [-117.38192, 33.99732], [-117.3817, 33.99744], [-117.38134, 33.99699], [-117.38069, 33.99734], [-117.38051, 33.99749], [-117.38034, 33.99766], [-117.37982, 33.99846], [-117.37976, 33.99852], [-117.37777, 33.99728], [-117.37773, 33.99731], [-117.37699, 33.9973], [-117.37656, 33.99716], [-117.37477, 33.99998], [-117.37442, 33.99975], [-117.37329, 33.99888], [-117.37358, 33.99866], [-117.37363, 33.99866], [-117.37368, 33.99873], [-117.37379, 33.99867], [-117.37356, 33.99832], [-117.37344, 33.99837], [-117.37299, 33.99865], [-117.37265, 33.99841], [-117.37237, 33.99824], [-117.37197, 33.99803], [-117.37138, 33.99775], [-117.37116, 33.9976], [-117.37098, 33.99745], [-117.37082, 33.99726], [-117.37074, 33.99714], [-117.37064, 33.99692], [-117.37056, 33.99658], [-117.37179, 33.99475], [-117.37179, 33.99474], [-117.37172, 33.9947], [-117.37218, 33.99403], [-117.37276, 33.99431], [-117.37305, 33.99439], [-117.37325, 33.99441], [-117.37344, 33.99439], [-117.37359, 33.99437], [-117.37379, 33.99429], [-117.37395, 33.99422], [-117.37409, 33.9941], [-117.37421, 33.99398], [-117.37506, 33.99271], [-117.37512, 33.99268], [-117.37519, 33.99268], [-117.37549, 33.99282], [-117.37529, 33.99313], [-117.37651, 33.99369], [-117.37669, 33.99393], [-117.3769, 33.99408], [-117.37684, 33.9942], [-117.37732, 33.99442], [-117.37717, 33.99452], [-117.37707, 33.99455], [-117.37701, 33.99458], [-117.37698, 33.99466], [-117.37699, 33.9947], [-117.37703, 33.99474], [-117.37712, 33.99477], [-117.37721, 33.99475], [-117.37724, 33.99472], [-117.37731, 33.99461], [-117.3775, 33.99448], [-117.37753, 33.99443], [-117.37783, 33.99466], [-117.37789, 33.9946], [-117.37801, 33.99467], [-117.37783, 33.99488], [-117.37766, 33.99533], [-117.37764, 33.99544], [-117.3778, 33.99547], [-117.3779, 33.99516], [-117.37801, 33.99493], [-117.37812, 33.99479], [-117.37869, 33.99428], [-117.37876, 33.99418], [-117.3789, 33.99383], [-117.37904, 33.99362], [-117.37944, 33.9938], [-117.37962, 33.99385], [-117.38049, 33.99381], [-117.3807, 33.99384], [-117.38084, 33.99389], [-117.38092, 33.99378], [-117.3809, 33.99376], [-117.38078, 33.99371], [-117.38057, 33.99367], [-117.38026, 33.99367], [-117.3797, 33.99372], [-117.3796, 33.99371], [-117.37951, 33.99368], [-117.37912, 33.9935], [-117.37937, 33.99312], [-117.38044, 33.99363], [-117.38108, 33.9936], [-117.38137, 33.99371], [-117.38161, 33.99374], [-117.38197, 33.9937], [-117.38215, 33.99358], [-117.38205, 33.9935], [-117.38324, 33.99227], [-117.38375, 33.99209], [-117.38449, 33.99162], [-117.3851, 33.9919], [-117.38617, 33.9913], [-117.38799, 33.98968], [-117.38909, 33.99004], [-117.38943, 33.9901], [-117.39011, 33.99028], [-117.39089, 33.99042]], [[-117.37157, 33.99781], [-117.37158, 33.99783], [-117.37171, 33.99777], [-117.37168, 33.99774], [-117.37157, 33.99781]]]]} | Open Access 1 | 19864 | Fairmount Park | 9451 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/facilities.asp | Riverside 10 | 213.051 | Fairmount Park | 0 | Local Park 2 | 4 |
10709 | 10709 | 10708 | {"type": "Polygon", "coordinates": [[[-117.27147, 33.98103], [-117.27074, 33.98105], [-117.27077, 33.98227], [-117.27102, 33.98307], [-117.26991, 33.98309], [-117.26957, 33.98198], [-117.26922, 33.98177], [-117.2686, 33.98153], [-117.26838, 33.98123], [-117.2681, 33.98108], [-117.26807, 33.98093], [-117.26797, 33.9808], [-117.26785, 33.98078], [-117.26794, 33.98044], [-117.26796, 33.98026], [-117.26797, 33.98009], [-117.26794, 33.97977], [-117.26792, 33.97965], [-117.26796, 33.9796], [-117.26815, 33.97959], [-117.26828, 33.9796], [-117.2685, 33.97966], [-117.26861, 33.97971], [-117.26894, 33.97996], [-117.26907, 33.98004], [-117.26923, 33.98011], [-117.26939, 33.98015], [-117.26956, 33.98017], [-117.26973, 33.98017], [-117.2699, 33.98015], [-117.27025, 33.98005], [-117.27046, 33.98003], [-117.27066, 33.98004], [-117.27084, 33.98009], [-117.27102, 33.98017], [-117.27117, 33.98028], [-117.2713, 33.98041], [-117.27139, 33.98058], [-117.27147, 33.98103]]]} | Open Access 1 | 19867 | Hidden Springs Community Park | 19912 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 16.933 | Hidden Springs Community Park | 0 | Local Park 2 | 4 | |
10710 | 10710 | 10709 | {"type": "Polygon", "coordinates": [[[-117.36135, 34.01479], [-117.35954, 34.01846], [-117.35914, 34.01925], [-117.35661, 34.01788], [-117.35432, 34.01711], [-117.35485, 34.01485], [-117.35635, 34.01522], [-117.35656, 34.0142], [-117.35864, 34.01442], [-117.35857, 34.01448], [-117.35858, 34.01449], [-117.36135, 34.01479]]]} | Open Access 1 | 19868 | Ab Brown Sports Complex | 15231 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 53.482 | Ab Brown Sports Complex | 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]);