units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
266 rows where LAYER = 14 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, MNG_AG_LEV, PARK_URL, COUNTY, YR_EST, GAP_STS
MNG_AGENCY >30
- Woodbridge Village Association 31
- Home Owners Association - Unknown Name 27
- Rancho Santa Margarita Landscape and Recreation Corporation 18
- Valley-Wide Recreation and Park District 7
- Amerige Heights Community Association 7
- 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
- Private Landowner 3
- Wildlands Inc 3
- East Highlands Ranch MHOA 3
- Northpark Square Maintenance Association 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
- Woodbridge Owners Association 2
- …
DES_TP 19
- Private Recreation or Education 193
- Local Park 36
- Private Conservation 16
- 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 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9390 | 9390 | 9389 | {"type": "Polygon", "coordinates": [[[-120.15384, 39.14012], [-120.15376, 39.14043], [-120.15368, 39.14056], [-120.15361, 39.14109], [-120.15352, 39.14139], [-120.15335, 39.14156], [-120.15315, 39.14172], [-120.15285, 39.14206], [-120.15275, 39.14225], [-120.1527, 39.14246], [-120.15268, 39.14162], [-120.1528, 39.14158], [-120.15291, 39.14152], [-120.15298, 39.14145], [-120.15303, 39.14135], [-120.15304, 39.14125], [-120.153, 39.14107], [-120.153, 39.14086], [-120.15305, 39.14047], [-120.15318, 39.14001], [-120.15368, 39.14001], [-120.15369, 39.14012], [-120.15384, 39.14012]]]} | Restricted Access 2 | 49025 | Tahoe Park | 33726 | 6140 | Lake Tahoe Park Association 908 | Private 7 | Home Owners Associatin 33 | https://www.laketahoeparkassociation.com/ | Private 14 | 6140 | Lake Tahoe Park Association 881 | Private 7 | Home Owners Associatin 31 | https://www.laketahoeparkassociation.com/sub_category_list.asp?category=9&title=Park+and+Beach+General+Policies | Placer 35 | 2.739 | Tahoe Park | 0 | Private Recreation or Education 65 | 4 |
9098 | 9098 | 9097 | {"type": "Polygon", "coordinates": [[[-121.27011, 38.87244], [-121.27017, 38.87246], [-121.2702, 38.87251], [-121.27019, 38.87295], [-121.27017, 38.87318], [-121.27014, 38.87322], [-121.27008, 38.87325], [-121.26912, 38.87324], [-121.26904, 38.8732], [-121.26902, 38.87311], [-121.26902, 38.87278], [-121.26904, 38.87252], [-121.26907, 38.87246], [-121.26913, 38.87245], [-121.27011, 38.87244]]]} | Restricted Access 2 | 48996 | Stone House Park | 33691 | 6139 | Sun City Lincoln Hills Community Association 903 | Private 7 | Home Owners Association 16 | https://suncity-lincolnhills.org/ | Private 14 | 6139 | Sun City Lincoln Hills Community Association 877 | Private 7 | Home Owners Association 15 | Placer 35 | 2.189 | Stone House Park | 0 | Private Recreation or Education 65 | 4 | |
15329 | 15329 | 15328 | {"type": "Polygon", "coordinates": [[[-117.03611, 33.78835], [-117.03606, 33.78836], [-117.03603, 33.78814], [-117.03599, 33.78803], [-117.0359, 33.78786], [-117.03583, 33.78777], [-117.03574, 33.78768], [-117.03558, 33.78755], [-117.03537, 33.78743], [-117.03604, 33.78743], [-117.03599, 33.78773], [-117.03606, 33.7878], [-117.03603, 33.78785], [-117.03602, 33.78791], [-117.03605, 33.78798], [-117.03604, 33.788], [-117.03611, 33.78835]]]} | Open Access 1 | 48972 | Pocket Park at the Cove #2 | 33669 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.446 | PP at the Cove #2 | 0 | Local Park 2 | 4 |
15540 | 15540 | 15539 | {"type": "Polygon", "coordinates": [[[-117.03786, 33.79012], [-117.03745, 33.79026], [-117.03733, 33.79002], [-117.03774, 33.78988], [-117.03786, 33.79012]]]} | Open Access 1 | 48971 | Pocket Park at the Cove #1 | 33668 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.295 | PP at the Cove #1 | 0 | Local Park 2 | 4 |
5694 | 5694 | 5693 | {"type": "MultiPolygon", "coordinates": [[[[-119.63503, 36.86465], [-119.63507, 36.86466], [-119.63533, 36.86484], [-119.63533, 36.86486], [-119.63468, 36.86486], [-119.63468, 36.86484], [-119.63503, 36.86465]]], [[[-119.63664, 36.86487], [-119.63569, 36.86487], [-119.63566, 36.86484], [-119.63602, 36.86449], [-119.63664, 36.86487]]], [[[-119.64194, 36.86363], [-119.64191, 36.86365], [-119.6416, 36.86365], [-119.64158, 36.86363], [-119.6416, 36.86306], [-119.64163, 36.86303], [-119.6419, 36.86303], [-119.64193, 36.86305], [-119.64194, 36.86363]]], [[[-119.64596, 36.86344], [-119.64596, 36.86363], [-119.64537, 36.86363], [-119.64537, 36.86344], [-119.64596, 36.86344]]], [[[-119.64569, 36.86041], [-119.64624, 36.86041], [-119.64627, 36.86042], [-119.6463, 36.86046], [-119.6463, 36.86082], [-119.64628, 36.86085], [-119.64624, 36.86087], [-119.6457, 36.86088], [-119.64566, 36.86086], [-119.64564, 36.86083], [-119.64564, 36.86047], [-119.64565, 36.86043], [-119.64569, 36.86041]]]]} | Restricted Access 2 | 48939 | Unknown park - Harlan Ranch Community Association | 33655 | 6138 | Harlan Ranch Community Association 814 | Private 7 | Home Owners Association 16 | http://www.harlanranchca.com/default.php | Private 14 | 6138 | Harlan Ranch Community Association 793 | Private 7 | Home Owners Association 15 | Fresno 9 | 2.17 | 0 | Private Recreation or Education 65 | 4 | ||
5693 | 5693 | 5692 | {"type": "Polygon", "coordinates": [[[-116.9052, 33.74329], [-116.90501, 33.7433], [-116.905, 33.74348], [-116.90478, 33.74342], [-116.90427, 33.74342], [-116.90426, 33.74343], [-116.90381, 33.74341], [-116.9038, 33.74359], [-116.90363, 33.74359], [-116.90363, 33.74341], [-116.9023, 33.74342], [-116.90203, 33.74347], [-116.90203, 33.74298], [-116.90225, 33.74307], [-116.90248, 33.74307], [-116.90266, 33.74299], [-116.90283, 33.74306], [-116.90306, 33.74306], [-116.90324, 33.74299], [-116.90342, 33.74306], [-116.90364, 33.74306], [-116.90383, 33.74298], [-116.90401, 33.74306], [-116.90423, 33.74306], [-116.90442, 33.74298], [-116.90459, 33.74306], [-116.90482, 33.74305], [-116.905, 33.74298], [-116.905, 33.74326], [-116.9052, 33.74326], [-116.9052, 33.74329]]]} | Restricted Access 2 | 48937 | Unknown park - Briarcliff Homeowners Association | 33654 | 6137 | Briarcliff Homeowners Association 813 | Private 7 | Home Owners Association 16 | https://www.briarcliff.org/ | Private 14 | 6137 | Briarcliff Homeowners Association 792 | Private 7 | Home Owners Association 15 | Riverside 10 | 3.003 | 0 | Private Recreation or Education 65 | 4 | ||
7259 | 7259 | 7258 | {"type": "Polygon", "coordinates": [[[-121.33415, 38.0047], [-121.33339, 38.0049], [-121.33335, 38.0049], [-121.33331, 38.00487], [-121.33306, 38.00439], [-121.33306, 38.00436], [-121.33311, 38.00433], [-121.33386, 38.00414], [-121.33415, 38.0047]]]} | Restricted Access 2 | 48928 | Village Oaks Community Park | 33647 | 6136 | Lincoln Village Home Association 854 | Private 7 | Home Owners Association 16 | Private 14 | 6136 | Lincoln Village Home Association 832 | Private 7 | Home Owners Association 15 | https://www.villageoakscommonareasassociation.org/ | San Joaquin 39 | 1.255 | Village Oaks Community Park | 0 | Private Recreation or Education 65 | 4 | |
1699 | 1699 | 1698 | {"type": "Polygon", "coordinates": [[[-122.08071, 37.59307], [-122.0796, 37.59322], [-122.07977, 37.59352], [-122.07935, 37.59373], [-122.07905, 37.59335], [-122.07908, 37.5932], [-122.07915, 37.59302], [-122.07949, 37.59264], [-122.08002, 37.5929], [-122.08024, 37.59296], [-122.08035, 37.59295], [-122.08046, 37.59291], [-122.08056, 37.59281], [-122.0806, 37.59269], [-122.08068, 37.59269], [-122.08071, 37.59307]]]} | Restricted Access 2 | 48918 | Liberty Park | 33640 | 6135 | Liberty Park Homeowners Association 411 | Private 7 | Home Owners Association 16 | https://libertyparkportal.com/ | Private 14 | 6135 | Liberty Park Homeowners Association 405 | Private 7 | Home Owners Association 15 | Alameda 17 | 1.864 | Liberty Park | 0 | Private Recreation or Education 65 | 4 | |
13918 | 13918 | 13917 | {"type": "Polygon", "coordinates": [[[-122.47779, 37.71752], [-122.47794, 37.71754], [-122.47824, 37.71766], [-122.47842, 37.71779], [-122.47855, 37.71794], [-122.47864, 37.71809], [-122.47866, 37.71822], [-122.47864, 37.7183], [-122.4786, 37.71838], [-122.47849, 37.71848], [-122.47836, 37.71855], [-122.47824, 37.71859], [-122.4781, 37.71859], [-122.47795, 37.71857], [-122.47777, 37.71849], [-122.47759, 37.71838], [-122.47748, 37.71829], [-122.47737, 37.71816], [-122.47731, 37.71806], [-122.47729, 37.71796], [-122.47729, 37.71787], [-122.47733, 37.71778], [-122.47742, 37.71767], [-122.47753, 37.71758], [-122.47763, 37.71754], [-122.47779, 37.71752]]]} | Open Access 1 | 48836 | Robert Pender Park | 33555 | 6134 | Parkmerced Owner LLC 1068 | Private 7 | Home Owners Association 16 | https://www.parkmerced.com/ | Private 14 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/robert-pender-park | San Francisco 13 | 2.548 | Robert Pender Park | 0 | Private Recreation or Education 65 | 4 |
3931 | 3931 | 3930 | {"type": "Polygon", "coordinates": [[[-117.15178, 32.71015], [-117.15154, 32.71016], [-117.15154, 32.71036], [-117.15114, 32.71036], [-117.15113, 32.70953], [-117.15178, 32.70953], [-117.15178, 32.71015]]]} | Open Access 1 | 48832 | Fault Line Park | 33551 | 6133 | Pinnacle International Development, Inc 701 | Private 7 | Commercial 20 | http://www.pinnacleinternational.ca/resume | Private 14 | 6133 | Pinnacle International Development, Inc 689 | Private 7 | Commercial 18 | San Diego 4 | 1.249 | Fault Line Park | 0 | Private Recreation or Education 65 | 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 | |
13701 | 13701 | 13700 | {"type": "MultiPolygon", "coordinates": [[[[-117.63252, 33.4339], [-117.63259, 33.43393], [-117.63262, 33.43399], [-117.63263, 33.43406], [-117.63262, 33.43414], [-117.63251, 33.43429], [-117.63248, 33.43427], [-117.63244, 33.43427], [-117.63226, 33.43438], [-117.6319, 33.43429], [-117.63182, 33.43432], [-117.63142, 33.43433], [-117.63138, 33.43432], [-117.63136, 33.43428], [-117.6312, 33.43434], [-117.63105, 33.43432], [-117.63095, 33.43434], [-117.63103, 33.43432], [-117.63107, 33.43427], [-117.63109, 33.43427], [-117.63111, 33.43423], [-117.63109, 33.43416], [-117.63125, 33.43393], [-117.63252, 33.4339]]], [[[-117.63431, 33.44132], [-117.6342, 33.44142], [-117.63397, 33.44124], [-117.63408, 33.44114], [-117.63431, 33.44132]]]]} | Open Access 1 | 48828 | Pico Park | 33547 | 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/177/2783 | Orange 3 | 1.598 | Pico Park | 0 | Local Park 2 | 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 | |
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 | |
12160 | 12160 | 12159 | {"type": "Polygon", "coordinates": [[[-120.42201, 34.85579], [-120.42022, 34.85579], [-120.42022, 34.85534], [-120.42034, 34.85532], [-120.42045, 34.85527], [-120.42053, 34.85519], [-120.42061, 34.85505], [-120.42068, 34.85503], [-120.4209, 34.85517], [-120.42118, 34.85548], [-120.42138, 34.85563], [-120.42154, 34.8557], [-120.42168, 34.85575], [-120.42182, 34.85578], [-120.42201, 34.85579]]]} | Restricted Access 2 | 48768 | Oak Neighborhood Park | 33495 | 6131 | Rice Ranch Ventures LLC 1009 | Private 7 | Home Owners Association 16 | Private 14 | 6131 | Rice Ranch Ventures LLC 971 | Private 7 | Home Owners Association 15 | Santa Barbara 7 | 1.572 | Oak Neighborhood Park | 0 | Private Recreation or Education 65 | 4 | ||
12454 | 12454 | 12453 | {"type": "Polygon", "coordinates": [[[-119.76638, 36.87034], [-119.76629, 36.87046], [-119.76408, 36.8694], [-119.76326, 36.86965], [-119.76233, 36.87081], [-119.76208, 36.87074], [-119.7624, 36.87065], [-119.76252, 36.87049], [-119.7625, 36.87038], [-119.76256, 36.87037], [-119.76263, 36.87028], [-119.76271, 36.87026], [-119.7628, 36.87015], [-119.76278, 36.87009], [-119.76286, 36.87007], [-119.76291, 36.87001], [-119.76286, 36.86982], [-119.76309, 36.86977], [-119.76322, 36.86962], [-119.76333, 36.8696], [-119.76338, 36.86952], [-119.76353, 36.86947], [-119.76368, 36.86929], [-119.76359, 36.86895], [-119.76313, 36.86876], [-119.76329, 36.86858], [-119.76333, 36.86848], [-119.76336, 36.86837], [-119.76337, 36.86821], [-119.76329, 36.86781], [-119.76331, 36.86778], [-119.76346, 36.86777], [-119.76382, 36.86776], [-119.76417, 36.86781], [-119.76404, 36.86792], [-119.76406, 36.86877], [-119.7637, 36.86896], [-119.76375, 36.86923], [-119.7638, 36.86933], [-119.76389, 36.86937], [-119.76408, 36.86931], [-119.76411, 36.86937], [-119.76417, 36.8694], [-119.76435, 36.86935], [-119.76442, 36.86951], [-119.76448, 36.8695], [-119.76506, 36.86978], [-119.76509, 36.86975], [-119.76525, 36.86982], [-119.76523, 36.86986], [-119.76555, 36.87001], [-119.76558, 36.86999], [-119.76576, 36.87008], [-119.76574, 36.87013], [-119.76616, 36.87034], [-119.76638, 36.87034]]]} | No Public Access 3 | 48758 | Floyd Boler Park | 33798 | 6130 | Park Fort Washington Association 1026 | Private 7 | Home Owners Association 16 | http://parkfortwashington.com/ | Private 14 | 6130 | Park Fort Washington Association 988 | Private 7 | Home Owners Association 15 | Fresno 9 | 3.203 | Floyd Boler Park | 0 | Private Recreation or Education 65 | 4 | |
10628 | 10628 | 10627 | {"type": "Polygon", "coordinates": [[[-117.62852, 33.961], [-117.62791, 33.96119], [-117.6279, 33.96039], [-117.62795, 33.96033], [-117.62821, 33.96032], [-117.62852, 33.961]]]} | Open Access 1 | 48707 | North Meridian Park | 33434 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | San Bernardino 22 | 0.926 | North Meridian Park | 0 | Local Park 2 | 4 | |
10515 | 10515 | 10514 | {"type": "Polygon", "coordinates": [[[-117.63201, 33.95915], [-117.632, 33.95932], [-117.632, 33.95991], [-117.63149, 33.96007], [-117.6312, 33.95941], [-117.63201, 33.95915]]]} | Open Access 1 | 48706 | West Meridian Park | 33436 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | San Bernardino 22 | 1.242 | West Meridian Park | 0 | Local Park 2 | 4 | |
11155 | 11155 | 11154 | {"type": "Polygon", "coordinates": [[[-117.71514, 33.7026], [-117.71503, 33.70272], [-117.71348, 33.70165], [-117.71319, 33.70188], [-117.71283, 33.70221], [-117.71279, 33.70214], [-117.71274, 33.70194], [-117.71273, 33.70165], [-117.71268, 33.70136], [-117.71281, 33.70133], [-117.71297, 33.70113], [-117.71496, 33.70241], [-117.715, 33.70239], [-117.71508, 33.70244], [-117.71514, 33.7026]]]} | Open Access 1 | 48695 | Orchard Trail Park | 33407 | 6128 | Portola Springs Community Association 967 | Private 7 | Home Owners Association 16 | https://portolasprings.org/ | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.227 | Orchard Trail Park | 0 | Local Park 2 | 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 |
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]);