units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,196 rows where COUNTY = 3 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, GAP_STS
MNG_AGENCY >30
- Irvine, City of 101
- Orange, County of 95
- Huntington Beach, City of 76
- Newport Beach, City of 65
- Anaheim, City of 59
- Fullerton, City of 58
- Mission Viejo, City of 47
- Santa Ana, City of 46
- Costa Mesa, City of 32
- Lake Forest, City of 31
- Woodbridge Village Association 31
- Yorba Linda, City of 30
- Laguna Niguel, City of 29
- San Juan Capistrano, City of 24
- Westminster, City of 24
- San Clemente, City of 24
- Dana Point, City of 22
- La Habra, City of 22
- Fountain Valley, City of 21
- Orange, City of 20
- Garden Grove, City of 19
- Cypress, City of 19
- Rancho Santa Margarita Landscape and Recreation Corporation 18
- Laguna Beach, City of 17
- Aliso Viejo, City of 17
- Placentia, City of 16
- Tustin, City of 16
- Brea, City of 15
- Seal Beach, City of 13
- Laguna Hills, City of 13
- …
DES_TP >30
- Local Park 793
- Private Recreation or Education 143
- Local Recreation Area 92
- Local Other or Unknown 70
- Local Conservation Area 25
- Private Conservation 11
- State Park 8
- State Conservation Area 7
- Local Historic or Cultural Area 4
- National Forest 1
- None 1
- None 1
- State 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
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 1,011
- Restricted Access 178
- Unknown Access 4
- No Public Access 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1665 | 1665 | 1664 | {"type": "Polygon", "coordinates": [[[-117.78817, 33.666], [-117.78729, 33.66687], [-117.78636, 33.66624], [-117.78725, 33.66535], [-117.78817, 33.666]]]} | Restricted Access 2 | 12583 | Royal Oak Park | 24713 | 6014 | Oak Creek Village Maintenance Association 405 | Private 7 | Home Owners Association 16 | Private 14 | 6014 | Oak Creek Village Maintenance Association 399 | Private 7 | Home Owners Association 15 | Orange 3 | 3.524 | Royal Oak Park | 0 | Private Recreation or Education 65 | 4 | ||
3512 | 3512 | 3511 | {"type": "Polygon", "coordinates": [[[-117.8, 33.63663], [-117.79999, 33.63665], [-117.80001, 33.63696], [-117.79993, 33.63714], [-117.79993, 33.63721], [-117.79994, 33.63725], [-117.79977, 33.63733], [-117.79914, 33.63718], [-117.79908, 33.63712], [-117.799, 33.63711], [-117.799, 33.63679], [-117.79894, 33.63605], [-117.79896, 33.63585], [-117.79913, 33.63589], [-117.79912, 33.63598], [-117.79915, 33.63606], [-117.79936, 33.6362], [-117.79941, 33.63622], [-117.79964, 33.63623], [-117.79976, 33.63628], [-117.79994, 33.63648], [-117.79998, 33.63654], [-117.8, 33.63663]]]} | Restricted Access 2 | 36116 | HOA Community Park | 31986 | 6028 | Turtle Rock Ridge Association 652 | Private 7 | Home Owners Association 16 | Private 14 | 6028 | Turtle Rock Ridge Association 641 | Private 7 | Home Owners Association 15 | Orange 3 | 2.684 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | ||
3513 | 3513 | 3512 | {"type": "Polygon", "coordinates": [[[-117.81397, 33.68873], [-117.81343, 33.68929], [-117.81316, 33.68912], [-117.81251, 33.68866], [-117.81295, 33.68837], [-117.81303, 33.68829], [-117.81307, 33.68822], [-117.81318, 33.68818], [-117.81397, 33.68873]]]} | Restricted Access 2 | 36118 | Santa Clara Park | 32396 | 6018 | Paseo Westpark Maintenance Association 653 | Private 7 | Home Owners Association 16 | Private 14 | 6018 | Paseo Westpark Maintenance Association 642 | Private 7 | Home Owners Association 15 | Orange 3 | 2.033 | Santa Clara Park | 0 | Private Recreation or Education 65 | 4 | ||
3843 | 3843 | 3842 | {"type": "Polygon", "coordinates": [[[-117.82217, 33.64995], [-117.82193, 33.64998], [-117.82124, 33.65], [-117.82125, 33.6497], [-117.8212, 33.64969], [-117.82123, 33.64946], [-117.8212, 33.64942], [-117.82123, 33.6492], [-117.82123, 33.64892], [-117.82118, 33.64891], [-117.82121, 33.64871], [-117.82121, 33.64864], [-117.82141, 33.64862], [-117.82155, 33.64859], [-117.82174, 33.64887], [-117.82151, 33.649], [-117.82152, 33.64906], [-117.82168, 33.64925], [-117.82175, 33.64926], [-117.82188, 33.64941], [-117.82183, 33.64946], [-117.82217, 33.64995]]]} | Restricted Access 2 | 35490 | Paseo Park | 32335 | 6001 | Broadmoor Campus View Community Association 691 | Private 7 | Home Owners Association 16 | Private 14 | 6001 | Broadmoor Campus View Community Association 681 | Private 7 | Home Owners Association 15 | Orange 3 | 2.01 | Paseo Park | 0 | Private Recreation or Education 65 | 4 | ||
3919 | 3919 | 3918 | {"type": "Polygon", "coordinates": [[[-117.62662, 33.59091], [-117.62663, 33.59093], [-117.62662, 33.591], [-117.62606, 33.5917], [-117.62547, 33.59254], [-117.62527, 33.59238], [-117.62515, 33.59227], [-117.62488, 33.59227], [-117.62481, 33.59233], [-117.62478, 33.59237], [-117.6247, 33.59236], [-117.62464, 33.59239], [-117.62436, 33.59244], [-117.62411, 33.5927], [-117.62405, 33.59275], [-117.62399, 33.59277], [-117.62389, 33.59271], [-117.62381, 33.59272], [-117.62369, 33.59249], [-117.62358, 33.59244], [-117.62362, 33.59238], [-117.6237, 33.59216], [-117.62369, 33.5921], [-117.62365, 33.59207], [-117.62346, 33.59204], [-117.62344, 33.59205], [-117.62341, 33.59202], [-117.62334, 33.59198], [-117.6233, 33.59179], [-117.62307, 33.5917], [-117.62309, 33.59165], [-117.62305, 33.59163], [-117.62323, 33.59136], [-117.62358, 33.59091], [-117.62376, 33.59095], [-117.62418, 33.59107], [-117.62426, 33.59106], [-117.62461, 33.59095], [-117.62472, 33.59087], [-117.62497, 33.59047], [-117.62533, 33.59009], [-117.62588, 33.59031], [-117.62586, 33.59037], [-117.62591, 33.59045], [-117.62609, 33.59052], [-117.62635, 33.59074], [-117.62662, 33.59091]]]} | Restricted Access 2 | 36105 | Oak Tree Park | 32384 | 6047 | L F Maintenance Corporation 697 | Private 7 | Home Owners Association 16 | Private 14 | 6047 | L F Maintenance Corporation 687 | Private 7 | Home Owners Association 15 | Orange 3 | 12.69 | Oak Tree Park | 0 | Private Recreation or Education 65 | 4 | ||
3925 | 3925 | 3924 | {"type": "Polygon", "coordinates": [[[-117.80367, 33.69677], [-117.80367, 33.69684], [-117.80303, 33.69712], [-117.80284, 33.6968], [-117.80285, 33.69674], [-117.80285, 33.69669], [-117.80271, 33.69652], [-117.80257, 33.69625], [-117.80257, 33.69623], [-117.80263, 33.69619], [-117.80272, 33.69616], [-117.80332, 33.69605], [-117.80341, 33.69613], [-117.8035, 33.69638], [-117.80367, 33.69677]]]} | Restricted Access 2 | 36161 | Santa Luisa Park | 32290 | 6018 | Paseo Westpark Maintenance Association 653 | Private 7 | Home Owners Association 16 | Private 14 | 6018 | Paseo Westpark Maintenance Association 642 | Private 7 | Home Owners Association 15 | Orange 3 | 1.832 | Santa Luisa Park | 0 | Private Recreation or Education 65 | 4 | ||
6064 | 6064 | 6063 | {"type": "Polygon", "coordinates": [[[-117.79972, 33.84507], [-117.79958, 33.84561], [-117.79822, 33.84561], [-117.7985, 33.84485], [-117.79865, 33.84464], [-117.79925, 33.84493], [-117.79948, 33.84501], [-117.79972, 33.84507]]]} | Restricted Access 2 | 47367 | HOA Community Park | 32230 | 6112 | Westridge Homeowners Association 825 | Private 7 | Home Owners Association 16 | Private 14 | 6112 | Westridge Homeowners Association 804 | Private 7 | Home Owners Association 15 | Orange 3 | 2.472 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | ||
8241 | 8241 | 8240 | {"type": "Polygon", "coordinates": [[[-117.78052, 33.66198], [-117.78052, 33.66204], [-117.78004, 33.66252], [-117.77971, 33.66281], [-117.77938, 33.66301], [-117.77934, 33.66295], [-117.77937, 33.66293], [-117.77939, 33.66289], [-117.77936, 33.66283], [-117.77923, 33.66266], [-117.77886, 33.66229], [-117.7792, 33.66209], [-117.77967, 33.66174], [-117.77987, 33.66157], [-117.77992, 33.66157], [-117.78052, 33.66198]]]} | Restricted Access 2 | 12576 | Ravencreek Park | 24198 | 6014 | Oak Creek Village Maintenance Association 405 | Private 7 | Home Owners Association 16 | Private 14 | 6014 | Oak Creek Village Maintenance Association 399 | Private 7 | Home Owners Association 15 | Orange 3 | 2.918 | Ravencreek Park | 0 | Private Recreation or Education 65 | 4 | ||
8253 | 8253 | 8252 | {"type": "MultiPolygon", "coordinates": [[[[-117.80373, 33.69585], [-117.80368, 33.69586], [-117.80361, 33.69579], [-117.80358, 33.69562], [-117.80356, 33.69525], [-117.80357, 33.69497], [-117.80364, 33.69489], [-117.80369, 33.69489], [-117.80367, 33.69514], [-117.80367, 33.69539], [-117.80369, 33.69561], [-117.80373, 33.69585]]], [[[-117.80489, 33.69297], [-117.80459, 33.69323], [-117.8044, 33.69345], [-117.80423, 33.69367], [-117.80458, 33.69394], [-117.80481, 33.6942], [-117.80478, 33.69444], [-117.80466, 33.69494], [-117.80369, 33.69485], [-117.80369, 33.69479], [-117.80366, 33.69478], [-117.80362, 33.69469], [-117.80377, 33.69422], [-117.80389, 33.694], [-117.80415, 33.69359], [-117.80449, 33.69321], [-117.80476, 33.69296], [-117.80487, 33.69295], [-117.80489, 33.69297]]]]} | Restricted Access 2 | 12621 | Santa Cruz Park | 25083 | 6018 | Paseo Westpark Maintenance Association 653 | Private 7 | Home Owners Association 16 | Private 14 | 6018 | Paseo Westpark Maintenance Association 642 | Private 7 | Home Owners Association 15 | Orange 3 | 3.171 | Santa Cruz Park | 0 | Private Recreation or Education 65 | 4 | ||
9776 | 9776 | 9775 | {"type": "Polygon", "coordinates": [[[-117.79917, 33.70162], [-117.79896, 33.70148], [-117.79893, 33.70151], [-117.79887, 33.70146], [-117.79889, 33.70143], [-117.79859, 33.70122], [-117.79855, 33.70125], [-117.79849, 33.7012], [-117.79852, 33.70117], [-117.79822, 33.70096], [-117.79818, 33.70099], [-117.79812, 33.70094], [-117.79814, 33.70091], [-117.798, 33.7008], [-117.79809, 33.7007], [-117.79794, 33.7006], [-117.79788, 33.70065], [-117.79788, 33.70063], [-117.79785, 33.70061], [-117.79782, 33.70061], [-117.79786, 33.70055], [-117.79756, 33.70035], [-117.7975, 33.70038], [-117.79746, 33.70035], [-117.79743, 33.70036], [-117.79739, 33.7004], [-117.79723, 33.7003], [-117.79704, 33.70049], [-117.79702, 33.70047], [-117.79702, 33.70042], [-117.79723, 33.70021], [-117.79725, 33.70014], [-117.7973, 33.70015], [-117.79744, 33.70024], [-117.79754, 33.70021], [-117.79778, 33.70037], [-117.79786, 33.70029], [-117.79787, 33.7003], [-117.79784, 33.70037], [-117.79787, 33.70045], [-117.79796, 33.70049], [-117.79805, 33.70048], [-117.79821, 33.70059], [-117.79833, 33.70048], [-117.79832, 33.70046], [-117.79837, 33.70041], [-117.79839, 33.70042], [-117.79864, 33.70017], [-117.79861, 33.70013], [-117.79866, 33.70008], [-117.7987, 33.7001], [-117.79883, 33.69998], [-117.798, 33.69939], [-117.7983, 33.69909], [-117.79817, 33.699], [-117.79826, 33.6989], [-117.79719, 33.69814], [-117.79754, 33.69802], [-117.79764, 33.69806], [-117.79779, 33.69828], [-117.79799, 33.69851], [-117.7982, 33.6987], [-117.79867, 33.69904], [-117.79879, 33.69915], [-117.79888, 33.69928], [-117.79895, 33.69943], [-117.79899, 33.69965], [-117.79897, 33.6998], [-117.79893, 33.69995], [-117.79887, 33.70008], [-117.79878, 33.70019], [-117.7984, 33.70058], [-117.79823, 33.70071], [-117.7982, 33.70076], [-117.79819, 33.70082], [-117.79822, 33.7009], [-117.79826, 33.70094], [-117.79847, 33.70104], [-117.79917, 33.70154], [-117.79919, 33.70158], [-117.79917, 33.70162]]]} | Restricted Access 2 | 47906 | Windwood Park | 31992 | 6033 | Windwood Homeowners Association 926 | Private 7 | Home Owners Association 16 | Private 14 | 6033 | Windwood Homeowners Association 899 | Private 7 | Home Owners Association 15 | Orange 3 | 3.259 | Windwood Park | 0 | Private Recreation or Education 65 | 4 | ||
11154 | 11154 | 11153 | {"type": "Polygon", "coordinates": [[[-117.79698, 33.70006], [-117.79706, 33.70012], [-117.79707, 33.70016], [-117.79689, 33.70036], [-117.79686, 33.70044], [-117.79687, 33.70049], [-117.79677, 33.70052], [-117.7967, 33.70048], [-117.79666, 33.70047], [-117.79649, 33.70063], [-117.79644, 33.7006], [-117.79664, 33.7004], [-117.79662, 33.70038], [-117.79668, 33.70036], [-117.79698, 33.70006]]]} | Open Access 1 | 48692 | Flagstone Park | 18936 | 6033 | Windwood Homeowners Association 926 | Private 7 | Home Owners Association 16 | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 0.248 | Flagstone Park | 0 | Local Park 2 | 4 | ||
13144 | 13144 | 13143 | {"type": "Polygon", "coordinates": [[[-117.6363, 33.4373], [-117.63625, 33.43732], [-117.63621, 33.43736], [-117.63622, 33.43744], [-117.63619, 33.43747], [-117.63618, 33.43754], [-117.63611, 33.43758], [-117.6361, 33.43765], [-117.636, 33.43768], [-117.63601, 33.43753], [-117.63591, 33.4373], [-117.63591, 33.43715], [-117.63589, 33.4371], [-117.6358, 33.43706], [-117.6357, 33.43709], [-117.63566, 33.43715], [-117.63567, 33.4372], [-117.6357, 33.43723], [-117.63547, 33.43703], [-117.63541, 33.437], [-117.63532, 33.43699], [-117.63532, 33.43695], [-117.63553, 33.43688], [-117.63566, 33.43668], [-117.6357, 33.43666], [-117.63577, 33.43667], [-117.63585, 33.43672], [-117.63594, 33.43687], [-117.63593, 33.43698], [-117.63596, 33.43709], [-117.63593, 33.43725], [-117.63595, 33.43735], [-117.63598, 33.43737], [-117.63604, 33.43735], [-117.6362, 33.43724], [-117.63627, 33.43727], [-117.6363, 33.4373]]]} | Open Access 1 | 48825 | Vista Del Sol Park | 33544 | 6132 | Marblehead Development Partners LLC 1045 | Private 7 | Home Owners Association 16 | Private 14 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/175/2553?npage=2 | Orange 3 | 0.637 | Vista Del Sol Park | 0 | Local Park 2 | 4 | |
13387 | 13387 | 13386 | {"type": "MultiPolygon", "coordinates": [[[[-117.77787, 33.66018], [-117.77767, 33.66024], [-117.77753, 33.66007], [-117.77771, 33.66001], [-117.77781, 33.66014], [-117.77787, 33.66018]]], [[[-117.77865, 33.66076], [-117.77852, 33.66089], [-117.77851, 33.66081], [-117.77834, 33.66068], [-117.77808, 33.66045], [-117.77791, 33.66033], [-117.77806, 33.66028], [-117.77813, 33.66029], [-117.77831, 33.66048], [-117.77864, 33.66072], [-117.77865, 33.66076]]], [[[-117.77919, 33.66114], [-117.77911, 33.66122], [-117.77891, 33.66107], [-117.77891, 33.66103], [-117.77875, 33.66092], [-117.7788, 33.66087], [-117.77886, 33.66087], [-117.77918, 33.66109], [-117.77919, 33.66114]]], [[[-117.77972, 33.66147], [-117.77973, 33.66152], [-117.77964, 33.66161], [-117.77944, 33.66145], [-117.77944, 33.6614], [-117.77928, 33.66129], [-117.77933, 33.66125], [-117.7794, 33.66124], [-117.77972, 33.66147]]]]} | Restricted Access 2 | 35484 | HOA Community Park | 31987 | 6010 | Kelsey Lane Maintenance Association 1048 | Private 7 | Home Owners Association 16 | Private 14 | 6010 | Kelsey Lane Maintenance Association 1007 | Private 7 | Home Owners Association 15 | Orange 3 | 0.707 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | ||
13393 | 13393 | 13392 | {"type": "MultiPolygon", "coordinates": [[[[-117.76801, 33.72396], [-117.7679, 33.72407], [-117.76547, 33.72239], [-117.76549, 33.72235], [-117.76324, 33.72075], [-117.76331, 33.72068], [-117.7644, 33.72146], [-117.76468, 33.72143], [-117.76505, 33.72105], [-117.76505, 33.72104], [-117.7648, 33.72087], [-117.76485, 33.72087], [-117.76489, 33.72089], [-117.76535, 33.72123], [-117.76538, 33.72127], [-117.76512, 33.7211], [-117.76472, 33.72152], [-117.76482, 33.72176], [-117.76801, 33.72396]]], [[[-117.7666, 33.72009], [-117.76619, 33.7205], [-117.7656, 33.72009], [-117.76568, 33.72], [-117.76591, 33.71964], [-117.76599, 33.71961], [-117.76651, 33.71998], [-117.76658, 33.72004], [-117.7666, 33.72009]]], [[[-117.76799, 33.72153], [-117.76787, 33.72166], [-117.76783, 33.72168], [-117.76758, 33.72151], [-117.76751, 33.72154], [-117.76742, 33.72148], [-117.76744, 33.72142], [-117.76696, 33.72106], [-117.76688, 33.7211], [-117.76677, 33.72102], [-117.7668, 33.72096], [-117.76629, 33.7206], [-117.76645, 33.72045], [-117.76696, 33.7208], [-117.76703, 33.72076], [-117.76714, 33.72083], [-117.76712, 33.72092], [-117.7676, 33.72125], [-117.76768, 33.72121], [-117.76779, 33.72129], [-117.76776, 33.72137], [-117.76799, 33.72153]]]]} | Restricted Access 2 | 35496 | HOA Community Park | 32300 | 6036 | Woodside-Irvine Homeowners Association 1051 | Private 7 | Home Owners Association 16 | Private 14 | 6036 | Woodside-Irvine Homeowners Association 1010 | Private 7 | Home Owners Association 15 | Orange 3 | 4.445 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | ||
13395 | 13395 | 13394 | {"type": "Polygon", "coordinates": [[[-117.81031, 33.63096], [-117.81033, 33.63157], [-117.8103, 33.63183], [-117.81026, 33.63185], [-117.80958, 33.63183], [-117.80933, 33.63128], [-117.80932, 33.63125], [-117.80933, 33.63121], [-117.80973, 33.63106], [-117.80993, 33.63099], [-117.81026, 33.63092], [-117.81031, 33.63096]]]} | Restricted Access 2 | 35498 | Sierra Ridge Park | 31873 | 6021 | Sierra Bonita Community Association 1053 | Private 7 | Home Owners Association 16 | Private 14 | 6021 | Sierra Bonita Community Association 1012 | Private 7 | Home Owners Association 15 | Orange 3 | 1.826 | Sierra Ridge Park | 0 | Private Recreation or Education 65 | 4 | ||
13396 | 13396 | 13395 | {"type": "Polygon", "coordinates": [[[-117.81538, 33.63248], [-117.81494, 33.63243], [-117.8149, 33.63239], [-117.81501, 33.63206], [-117.81515, 33.63176], [-117.81531, 33.63144], [-117.81536, 33.63142], [-117.81579, 33.63157], [-117.81582, 33.63161], [-117.81557, 33.63212], [-117.81544, 33.63246], [-117.81538, 33.63248]]]} | Restricted Access 2 | 35499 | Sierra Oro Park | 31876 | 6021 | Sierra Bonita Community Association 1053 | Private 7 | Home Owners Association 16 | Private 14 | 6021 | Sierra Bonita Community Association 1012 | Private 7 | Home Owners Association 15 | Orange 3 | 1.427 | Sierra Oro Park | 0 | Private Recreation or Education 65 | 4 | ||
13444 | 13444 | 13443 | {"type": "Polygon", "coordinates": [[[-117.8192, 33.63243], [-117.81917, 33.63249], [-117.81854, 33.6334], [-117.81848, 33.6334], [-117.81807, 33.63318], [-117.81807, 33.63316], [-117.81809, 33.63311], [-117.81839, 33.63259], [-117.8186, 33.63226], [-117.81865, 33.63225], [-117.81894, 33.63233], [-117.81916, 33.6324], [-117.8192, 33.63243]]]} | Restricted Access 2 | 35620 | Sierra Boca Park | 32318 | 6021 | Sierra Bonita Community Association 1053 | Private 7 | Home Owners Association 16 | Private 14 | 6021 | Sierra Bonita Community Association 1012 | Private 7 | Home Owners Association 15 | Orange 3 | 1.696 | Sierra Boca Park | 0 | Private Recreation or Education 65 | 4 | ||
13456 | 13456 | 13455 | {"type": "Polygon", "coordinates": [[[-117.82149, 33.63571], [-117.82142, 33.63563], [-117.82134, 33.63549], [-117.82188, 33.63469], [-117.82195, 33.63468], [-117.82244, 33.63492], [-117.82245, 33.63495], [-117.82244, 33.63498], [-117.82194, 33.63571], [-117.82189, 33.63572], [-117.82149, 33.63571]]]} | Restricted Access 2 | 35674 | Sierra Amigo Park | 31993 | 6021 | Sierra Bonita Community Association 1053 | Private 7 | Home Owners Association 16 | Private 14 | 6021 | Sierra Bonita Community Association 1012 | Private 7 | Home Owners Association 15 | Orange 3 | 1.663 | Sierra Amigo Park | 0 | Private Recreation or Education 65 | 4 | ||
13461 | 13461 | 13460 | {"type": "Polygon", "coordinates": [[[-117.80198, 33.70068], [-117.80192, 33.70074], [-117.80161, 33.70026], [-117.80139, 33.69982], [-117.80015, 33.69992], [-117.79916, 33.69984], [-117.79919, 33.69972], [-117.80014, 33.69978], [-117.80133, 33.69968], [-117.80117, 33.69913], [-117.8011, 33.69879], [-117.80097, 33.69768], [-117.80103, 33.69767], [-117.80109, 33.69772], [-117.80121, 33.69876], [-117.80128, 33.69916], [-117.80152, 33.69981], [-117.80176, 33.70031], [-117.80198, 33.70068]]]} | Restricted Access 2 | 35680 | HOA Community Park | 31871 | 6033 | Windwood Homeowners Association 926 | Private 7 | Home Owners Association 16 | Private 14 | 6033 | Windwood Homeowners Association 899 | Private 7 | Home Owners Association 15 | Orange 3 | 1.688 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | ||
13544 | 13544 | 13543 | {"type": "Polygon", "coordinates": [[[-117.63464, 33.44433], [-117.63368, 33.44513], [-117.63359, 33.44529], [-117.63357, 33.44527], [-117.63343, 33.44529], [-117.63333, 33.44533], [-117.63317, 33.44552], [-117.63307, 33.44557], [-117.63301, 33.44552], [-117.63294, 33.44537], [-117.63296, 33.44526], [-117.63278, 33.44448], [-117.63247, 33.44421], [-117.63228, 33.44418], [-117.63214, 33.44405], [-117.63214, 33.444], [-117.63222, 33.44385], [-117.63236, 33.44332], [-117.6324, 33.44296], [-117.63253, 33.44286], [-117.63261, 33.44289], [-117.63314, 33.4433], [-117.63313, 33.44335], [-117.63427, 33.4443], [-117.63438, 33.44434], [-117.63448, 33.44433], [-117.63456, 33.44428], [-117.63464, 33.44433]]]} | Open Access 1 | 48827 | Jim Johnson Memorial Sports Park | 33546 | 6132 | Marblehead Development Partners LLC 1045 | Private 7 | Home Owners Association 16 | Private 14 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/187/2783 | Orange 3 | 7.375 | Jim Johnson Memorial Sports Park | 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]);