units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
266 rows where LAYER = 14 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Woodbridge Village Association 25
- Home Owners Association - Unknown Name 24
- Rancho Santa Margarita Landscape and Recreation Corporation 16
- Valley-Wide Recreation and Park District 7
- Amerige Heights Community Association 6
- Bellflower, City of 6
- San Clemente, City of 4
- Paseo Westpark Maintenance Association 4
- Deerfield Community Association 4
- Nellie Gail Ranch Owners Association 4
- Westpark Maintenance District 4
- Sierra Bonita Community Association 4
- Town Center Association 4
- Irvine, City of 3
- Quail Hill Community Association 3
- Wildlands Inc 3
- East Highlands Ranch MHOA 3
- Turtle Rock Broadmoor Community Association 3
- Summerly Homes 2
- San Jacinto, City of 2
- Chino, City of 2
- Paramount, City of 2
- West Hollywood, City of 2
- Oak Creek Village Maintenance Association 2
- King City, City of 2
- Broadmoor Campus View Community Association 2
- McCloud River Railroad Company 2
- Private Landowner 2
- Woodbridge Owners Association 2
- Northpark Maintenance Association 2
- …
DES_TP 19
- Private Recreation or Education 175
- Local Park 35
- Private Conservation 15
- Local Recreation Area 6
- Local Conservation Area 1
- Local Other or Unknown 1
- State Recreation Area 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 11
ACCESS_TYP 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12838 | 12838 | 12837 | {"type": "Polygon", "coordinates": [[[-117.61738, 33.6086], [-117.6171, 33.60943], [-117.61703, 33.60972], [-117.6166, 33.61002], [-117.61646, 33.61014], [-117.61636, 33.61027], [-117.61619, 33.61057], [-117.61601, 33.6108], [-117.61571, 33.61109], [-117.61551, 33.61123], [-117.61516, 33.61158], [-117.61508, 33.6117], [-117.61502, 33.61175], [-117.61494, 33.61174], [-117.61488, 33.61166], [-117.61486, 33.61157], [-117.61492, 33.61126], [-117.61479, 33.61102], [-117.61483, 33.6109], [-117.61483, 33.61084], [-117.61473, 33.61064], [-117.61462, 33.61052], [-117.61466, 33.61046], [-117.61474, 33.61], [-117.61492, 33.61003], [-117.61502, 33.61], [-117.61515, 33.60987], [-117.6153, 33.60971], [-117.61543, 33.60951], [-117.61546, 33.60936], [-117.61543, 33.60918], [-117.61543, 33.60909], [-117.61549, 33.60905], [-117.6157, 33.60916], [-117.61596, 33.60923], [-117.61608, 33.60923], [-117.6162, 33.60917], [-117.61636, 33.60902], [-117.61667, 33.60882], [-117.61685, 33.6088], [-117.61698, 33.60876], [-117.61713, 33.60866], [-117.61721, 33.60856], [-117.61738, 33.6086]]]} | Restricted Access 2 | 30286 | Canada Vista Park | 31701 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 9.226 | Canada Vista Park | 0 | Private Recreation or Education 65 | 4 | |
1595 | 1595 | 1594 | {"type": "Polygon", "coordinates": [[[-117.33591, 33.13338], [-117.33487, 33.13375], [-117.33448, 33.13298], [-117.33535, 33.13267], [-117.3354, 33.13267], [-117.33591, 33.13338]]]} | Open Access 1 | 12167 | Cannon Park | 16804 | 6076 | San Diego Gas and Electric 389 | Private 7 | Utility 21 | http://www.sdge.com/ | Private 14 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/cannon.asp | San Diego 4 | 2.282 | Cannon Park | 0 | Local Park 2 | 4 |
13710 | 13710 | 13709 | {"type": "Polygon", "coordinates": [[[-117.63508, 33.43915], [-117.63504, 33.43931], [-117.63483, 33.43958], [-117.6348, 33.43975], [-117.63483, 33.43992], [-117.63482, 33.43996], [-117.6348, 33.43996], [-117.63467, 33.43984], [-117.63463, 33.43977], [-117.63447, 33.43944], [-117.63446, 33.43937], [-117.63453, 33.43926], [-117.63476, 33.43918], [-117.63492, 33.4391], [-117.63508, 33.43915]]]} | Open Access 1 | 48829 | Canyon View Park | 33548 | 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/173/2783 | Orange 3 | 0.667 | Canyon View Park | 0 | Local Park 2 | 4 | |
4456 | 4456 | 4455 | {"type": "Polygon", "coordinates": [[[-117.1099, 33.59108], [-117.10987, 33.59122], [-117.10982, 33.59131], [-117.10976, 33.59136], [-117.10963, 33.59141], [-117.10945, 33.59141], [-117.1093, 33.59153], [-117.10929, 33.59152], [-117.10934, 33.59147], [-117.10936, 33.5914], [-117.10933, 33.59112], [-117.10941, 33.59108], [-117.1099, 33.59108]]]} | Open Access 1 | 48396 | Capri Park | 32961 | 6123 | Brindisi Owners Association 763 | Private 7 | Home Owners Association 16 | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/capri-pocket-park | Riverside 10 | 0.419 | Capri Park | 0 | Local Park 2 | 4 | |
14518 | 14518 | 14517 | {"type": "Polygon", "coordinates": [[[-117.10811, 33.49529], [-117.10821, 33.49558], [-117.10827, 33.49587], [-117.1083, 33.49617], [-117.10829, 33.49646], [-117.10825, 33.49676], [-117.10819, 33.49705], [-117.10803, 33.49747], [-117.10796, 33.49749], [-117.10776, 33.49743], [-117.10774, 33.4972], [-117.10755, 33.49688], [-117.10736, 33.49667], [-117.10713, 33.49651], [-117.10692, 33.49641], [-117.10649, 33.49627], [-117.10633, 33.49651], [-117.10619, 33.49644], [-117.10636, 33.49621], [-117.10614, 33.49606], [-117.1063, 33.49589], [-117.10606, 33.49571], [-117.10605, 33.49549], [-117.10627, 33.49547], [-117.10652, 33.49541], [-117.10641, 33.49515], [-117.10652, 33.49511], [-117.10667, 33.49536], [-117.10698, 33.49519], [-117.10714, 33.49506], [-117.10724, 33.49496], [-117.1074, 33.49473], [-117.10746, 33.4946], [-117.10752, 33.49443], [-117.10767, 33.4943], [-117.10749, 33.49381], [-117.10756, 33.49384], [-117.10811, 33.49529]]]} | Restricted Access 2 | 47181 | Captain Aaron J. Contreras Memorial Park | 31744 | 6111 | Paloma del Sol Homeowners Association 1115 | Private 7 | Home Owners Association 16 | http://www.palomadelsol.net/ | Private 14 | 6111 | Paloma del Sol Homeowners Association 1070 | Private 7 | Home Owners Association 15 | Riverside 10 | 9.154 | Captain Aaron J. Contreras Memorial Park | 0 | Private Recreation or Education 65 | 4 | |
4426 | 4426 | 4425 | {"type": "Polygon", "coordinates": [[[-118.10901, 33.88199], [-118.109, 33.88235], [-118.10866, 33.88235], [-118.10866, 33.88199], [-118.10901, 33.88199]]]} | Open Access 1 | 46311 | Caruthers Park North | 29601 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | https://www.bellflower.org/home/index.asp?page=132 | Los Angeles 6 | 0.313 | Caruthers Park North | 0 | Local Park 2 | 4 |
15256 | 15256 | 15255 | {"type": "MultiPolygon", "coordinates": [[[[-118.109, 33.88327], [-118.10866, 33.88327], [-118.10866, 33.88309], [-118.109, 33.88308], [-118.109, 33.88327]]], [[[-118.10902, 33.88416], [-118.10866, 33.88416], [-118.10866, 33.8838], [-118.10901, 33.8838], [-118.10902, 33.88416]]]]} | Open Access 1 | 46312 | Caruthers Park North | 29601 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | https://www.bellflower.org/home/index.asp?page=132 | Los Angeles 6 | 0.48 | Caruthers Park North | 0 | Local Park 2 | 4 | |
8087 | 8087 | 8086 | {"type": "Polygon", "coordinates": [[[-117.7745, 33.6464], [-117.77409, 33.64642], [-117.77402, 33.64586], [-117.77398, 33.64527], [-117.77395, 33.64518], [-117.77384, 33.64503], [-117.77389, 33.6449], [-117.77386, 33.64479], [-117.77383, 33.64478], [-117.77388, 33.64475], [-117.77385, 33.64452], [-117.77371, 33.64448], [-117.77371, 33.64441], [-117.77368, 33.64437], [-117.77378, 33.6443], [-117.77374, 33.64398], [-117.77357, 33.64362], [-117.77347, 33.64359], [-117.77345, 33.64351], [-117.77342, 33.64347], [-117.77348, 33.64339], [-117.77344, 33.64323], [-117.77344, 33.64295], [-117.77347, 33.64291], [-117.77331, 33.64267], [-117.77328, 33.64258], [-117.77321, 33.64254], [-117.77326, 33.64242], [-117.77312, 33.6422], [-117.7735, 33.64203], [-117.77358, 33.64201], [-117.77377, 33.64198], [-117.77402, 33.64201], [-117.77425, 33.6421], [-117.77442, 33.64219], [-117.77446, 33.64223], [-117.77445, 33.64226], [-117.77431, 33.64238], [-117.77417, 33.64252], [-117.77408, 33.64265], [-117.77401, 33.64278], [-117.77397, 33.64292], [-117.77394, 33.64317], [-117.77396, 33.6433], [-117.77399, 33.6434], [-117.77447, 33.64453], [-117.77457, 33.6449], [-117.7746, 33.64528], [-117.7746, 33.64546], [-117.7745, 33.6464]]]} | Restricted Access 2 | 12174 | Cascade Park | 16939 | 6019 | Quail Hill Community Association 408 | Private 7 | Home Owners Association 16 | http://www.quailhillhoa.org/ | Private 14 | 6019 | Quail Hill Community Association 402 | Private 7 | Home Owners Association 15 | Orange 3 | 7.136 | Cascade Park | 0 | Private Recreation or Education 65 | 4 | |
12833 | 12833 | 12832 | {"type": "Polygon", "coordinates": [[[-117.59395, 33.64177], [-117.59353, 33.64183], [-117.5933, 33.64212], [-117.59332, 33.64226], [-117.5917, 33.6425], [-117.59138, 33.64242], [-117.59072, 33.64304], [-117.59072, 33.64277], [-117.59123, 33.6423], [-117.59111, 33.64158], [-117.59158, 33.64113], [-117.59308, 33.64092], [-117.59309, 33.64101], [-117.59313, 33.64108], [-117.59311, 33.64112], [-117.59339, 33.64129], [-117.59383, 33.64123], [-117.59395, 33.64177]]]} | Restricted Access 2 | 30281 | Central Park | 31698 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 8.304 | Central Park | 0 | Private Recreation or Education 65 | 4 | |
12841 | 12841 | 12840 | {"type": "Polygon", "coordinates": [[[-117.56834, 33.65338], [-117.56831, 33.65345], [-117.56817, 33.65353], [-117.56768, 33.65384], [-117.56738, 33.65406], [-117.56728, 33.65414], [-117.56682, 33.65472], [-117.56663, 33.6549], [-117.56639, 33.65508], [-117.56617, 33.65519], [-117.56594, 33.65527], [-117.56562, 33.6553], [-117.56637, 33.65377], [-117.56695, 33.65295], [-117.56755, 33.65213], [-117.56775, 33.65229], [-117.56794, 33.65253], [-117.56804, 33.65272], [-117.56834, 33.65338]]]} | Restricted Access 2 | 30290 | Central Park | 31698 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 8.176 | Central Park | 0 | Private Recreation or Education 65 | 4 | |
15255 | 15255 | 15254 | {"type": "Polygon", "coordinates": [[[-118.12195, 33.89644], [-118.12189, 33.89649], [-118.12166, 33.89649], [-118.12171, 33.89622], [-118.12195, 33.89622], [-118.12195, 33.89644]]]} | Open Access 1 | 46308 | Chevron Pocket Park | 29600 | 6104 | Chevron Pipe Line Company 1145 | Private 7 | Commercial 20 | http://www.chevronpipeline.com/about/ | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 0.179 | Chevron PP | 0 | Local Park 2 | 4 | |
12832 | 12832 | 12831 | {"type": "Polygon", "coordinates": [[[-117.58827, 33.64485], [-117.58825, 33.64492], [-117.58764, 33.6453], [-117.58743, 33.64541], [-117.5874, 33.64546], [-117.58739, 33.64554], [-117.58742, 33.64563], [-117.58736, 33.64567], [-117.58731, 33.64558], [-117.58728, 33.64541], [-117.58733, 33.64503], [-117.58718, 33.64498], [-117.58713, 33.64495], [-117.58695, 33.64442], [-117.58746, 33.64426], [-117.58748, 33.64432], [-117.58742, 33.6444], [-117.58749, 33.64465], [-117.58757, 33.64469], [-117.58764, 33.64468], [-117.58767, 33.64479], [-117.58817, 33.6447], [-117.58827, 33.64485]]]} | Restricted Access 2 | 30280 | Cielo Vista Park | 31702 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 1.805 | Cielo Vista Park | 0 | Private Recreation or Education 65 | 4 | |
4172 | 4172 | 4171 | {"type": "Polygon", "coordinates": [[[-118.16946, 33.93806], [-118.16891, 33.93872], [-118.16808, 33.93971], [-118.16762, 33.9386], [-118.1679, 33.93827], [-118.1681, 33.93828], [-118.16864, 33.93763], [-118.16946, 33.93806]]]} | Open Access 1 | 46508 | Circle Park | 29791 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1339 | South Gate, City of 645 | City 2 | City Agency 2 | Los Angeles 6 | 4.401 | Circle Park | 0 | Local Park 2 | 4 | |
14779 | 14779 | 14778 | {"type": "Polygon", "coordinates": [[[-116.95147, 32.64226], [-116.95151, 32.64236], [-116.95151, 32.64247], [-116.95145, 32.64258], [-116.95133, 32.64266], [-116.95118, 32.64269], [-116.95105, 32.64267], [-116.95093, 32.6426], [-116.95086, 32.6425], [-116.95084, 32.6424], [-116.95087, 32.6423], [-116.95094, 32.64221], [-116.95103, 32.64215], [-116.95116, 32.64212], [-116.95126, 32.64213], [-116.95138, 32.64218], [-116.95147, 32.64226]]]} | Restricted Access 2 | 45167 | Circle Park | 33367 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.754 | Circle Park | 0 | Private Recreation or Education 65 | 4 | ||
1604 | 1604 | 1603 | {"type": "Polygon", "coordinates": [[[-117.81184, 33.66673], [-117.81155, 33.66748], [-117.81149, 33.66751], [-117.81146, 33.66746], [-117.81132, 33.66739], [-117.81062, 33.66726], [-117.81077, 33.66651], [-117.81184, 33.66673]]]} | Restricted Access 2 | 12272 | Clearbrook Park | 17414 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.0 | Clearbrook Park | 0 | Private Recreation or Education 65 | 4 | |
8497 | 8497 | 8496 | {"type": "Polygon", "coordinates": [[[-122.22153, 37.36198], [-122.22095, 37.36343], [-122.22116, 37.36353], [-122.22107, 37.36357], [-122.22091, 37.36383], [-122.22031, 37.36425], [-122.21982, 37.36432], [-122.21905, 37.36479], [-122.21859, 37.36468], [-122.21792, 37.36468], [-122.21681, 37.36444], [-122.21663, 37.36458], [-122.21652, 37.36457], [-122.21625, 37.36444], [-122.21573, 37.36435], [-122.21511, 37.36387], [-122.21468, 37.36376], [-122.21411, 37.36345], [-122.21396, 37.36339], [-122.21379, 37.36335], [-122.21362, 37.36334], [-122.21345, 37.36335], [-122.21329, 37.36339], [-122.21312, 37.36346], [-122.21298, 37.36354], [-122.21287, 37.36365], [-122.21278, 37.36376], [-122.21271, 37.36391], [-122.21252, 37.36381], [-122.21233, 37.36377], [-122.21212, 37.36376], [-122.21185, 37.3638], [-122.21156, 37.36357], [-122.21116, 37.36334], [-122.21102, 37.36323], [-122.21199, 37.3621], [-122.21094, 37.36096], [-122.20955, 37.35979], [-122.20929, 37.35959], [-122.20817, 37.3594], [-122.20651, 37.35691], [-122.21042, 37.352], [-122.21243, 37.35403], [-122.21338, 37.35413], [-122.21598, 37.35557], [-122.21904, 37.35912], [-122.22061, 37.36021], [-122.22153, 37.36198]]]} | Restricted Access 2 | 13289 | Coal Mine Ridge | 33341 | 6127 | Portola Valley Ranch Home Owners Association 895 | Private 7 | Home Owners Association 16 | Private 14 | 6127 | Portola Valley Ranch Home Owners Association 869 | Private 7 | Home Owners Association 15 | San Mateo 15 | 244.051 | Coal Mine Ridge | 1964 | Private Conservation 16 | 2 | ||
14170 | 14170 | 14169 | {"type": "Polygon", "coordinates": [[[-117.82805, 33.60431], [-117.82783, 33.60453], [-117.82801, 33.60466], [-117.82774, 33.60493], [-117.82762, 33.60484], [-117.82749, 33.60489], [-117.82738, 33.605], [-117.82743, 33.60513], [-117.82749, 33.60518], [-117.82721, 33.60549], [-117.82711, 33.60552], [-117.82676, 33.60536], [-117.8264, 33.60527], [-117.82466, 33.60507], [-117.82341, 33.60491], [-117.82317, 33.6049], [-117.82281, 33.60494], [-117.82257, 33.60499], [-117.82221, 33.60512], [-117.82218, 33.60511], [-117.82208, 33.60516], [-117.82208, 33.60519], [-117.82184, 33.60535], [-117.82159, 33.60557], [-117.82149, 33.60549], [-117.82092, 33.60468], [-117.821, 33.60453], [-117.82197, 33.60432], [-117.82294, 33.60468], [-117.82298, 33.60451], [-117.82297, 33.60445], [-117.82301, 33.60444], [-117.82303, 33.6044], [-117.82302, 33.60436], [-117.82299, 33.60434], [-117.823, 33.60426], [-117.82308, 33.60427], [-117.82311, 33.60425], [-117.82314, 33.6041], [-117.82326, 33.60396], [-117.8234, 33.60382], [-117.82337, 33.6035], [-117.82384, 33.60343], [-117.82448, 33.60363], [-117.82516, 33.60374], [-117.82509, 33.60384], [-117.82509, 33.60385], [-117.82576, 33.60405], [-117.82617, 33.60415], [-117.82627, 33.60415], [-117.82635, 33.60413], [-117.82648, 33.60429], [-117.82645, 33.60436], [-117.82667, 33.60449], [-117.82694, 33.60454], [-117.82738, 33.60462], [-117.82755, 33.60462], [-117.82771, 33.60457], [-117.82788, 33.60444], [-117.82804, 33.6043], [-117.82805, 33.60431]]]} | Restricted Access 2 | 43067 | Coastal Canyon Park | 32381 | 6059 | Newport Coast Community Association 1095 | Private 7 | Home Owners Association 16 | http://www.newportcoast.net/ | Private 14 | 6059 | Newport Coast Community Association 1050 | Private 7 | Home Owners Association 15 | Orange 3 | 17.215 | Coastal Canyon Park | 0 | Private Recreation or Education 65 | 4 | |
3806 | 3806 | 3805 | {"type": "Polygon", "coordinates": [[[-116.97738, 32.65693], [-116.97721, 32.65698], [-116.9771, 32.65706], [-116.97694, 32.65721], [-116.97668, 32.65643], [-116.97706, 32.65643], [-116.97724, 32.65675], [-116.97738, 32.65693]]]} | Restricted Access 2 | 45163 | Cobblestone Park | 33360 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.726 | Cobblestone Park | 0 | Private Recreation or Education 65 | 4 | ||
13442 | 13442 | 13441 | {"type": "Polygon", "coordinates": [[[-117.79103, 33.71118], [-117.79089, 33.71133], [-117.78842, 33.71195], [-117.7883, 33.71185], [-117.78831, 33.71182], [-117.78964, 33.71049], [-117.78969, 33.7105], [-117.79087, 33.71132], [-117.79102, 33.71117], [-117.79103, 33.71118]]]} | Restricted Access 2 | 35617 | Colony Park | 32256 | 6003 | Colony Club Community Association 1055 | Private 7 | Home Owners Association 16 | http://www.colonyirvine.com/ | Private 14 | 6003 | Colony Club Community Association 1014 | Private 7 | Home Owners Association 15 | Orange 3 | 4.08 | Colony Park | 0 | Private Recreation or Education 65 | 4 | |
14017 | 14017 | 14016 | {"type": "Polygon", "coordinates": [[[-118.47347, 34.03122], [-118.47281, 34.03175], [-118.47275, 34.03178], [-118.47267, 34.03175], [-118.47203, 34.03124], [-118.47296, 34.03049], [-118.4734, 34.03086], [-118.47336, 34.03089], [-118.47335, 34.03112], [-118.47347, 34.03122]]]} | Open Access 1 | 46587 | Colorado Center Park | 29890 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 6103 | Private Landowner 774 | Private 7 | Other 26 | Los Angeles 6 | 2.516 | Colorado Ctr. Park | 0 | Private Recreation or Education 65 | 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]);