units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
268 rows where DES_TP = 65 sorted by MNG_AG_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, PARK_URL, COUNTY, YR_EST
MNG_AGENCY >30
- Woodbridge Village Association 30
- Mountains Restoration Trust 26
- Home Owners Association - Unknown Name 25
- Rancho Santa Margarita Landscape and Recreation Corporation 17
- Amerige Heights Community Association 7
- Los Angeles Neighborhood Land Trust 6
- San Dieguito River Valley Land Conservancy 5
- Arroyos and Foothills Conservancy 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
- Private Landowner 3
- Odd Fellows Sierra Recreation Association 3
- Northpark Square Maintenance Association 3
- Turtle Rock Broadmoor Community Association 3
- Oak Creek Village Maintenance Association 2
- Quail Hill Community Association 2
- Truckee Donner Land Trust 2
- Trinidad Coastal Land Trust 2
- Broadmoor Campus View Community Association 2
- Trust for Public Land 2
- Woodbridge Owners Association 2
- Northpark Maintenance Association 2
- Windwood Homeowners Association 2
- Johnson Ranch Community Association 2
- Woodbury Community Association 2
- John Muir Land Trust 1
- …
MNG_AG_TYP 10
ACCESS_TYP 4
- Restricted Access 194
- Open Access 48
- No Public Access 25
- Unknown Access 1
DES_TP 1
- Private Recreation or Education · 268 ✖
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 | |
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 | |
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 | |
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 | |
8432 | 8432 | 8431 | {"type": "Polygon", "coordinates": [[[-122.11451, 37.7016], [-122.11439, 37.70152], [-122.11433, 37.70151], [-122.11428, 37.70154], [-122.11413, 37.70143], [-122.11426, 37.70132], [-122.11449, 37.7013], [-122.11457, 37.70147], [-122.11456, 37.70154], [-122.11451, 37.7016]]]} | Restricted Access 2 | 15177 | HOA Community Park | 33332 | 6126 | Marcella Renaissance Owners Association 893 | Private 7 | Home Owners Association 16 | Private 14 | 6126 | Marcella Renaissance Owners Association 867 | Private 7 | Home Owners Association 15 | Alameda 17 | 0.195 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | ||
6655 | 6655 | 6654 | {"type": "Polygon", "coordinates": [[[-121.25053, 37.83022], [-121.25041, 37.83025], [-121.25037, 37.8303], [-121.25035, 37.83035], [-121.25038, 37.83055], [-121.25038, 37.83155], [-121.25035, 37.83159], [-121.25031, 37.83161], [-121.24949, 37.83154], [-121.24871, 37.83154], [-121.24865, 37.8315], [-121.24865, 37.83055], [-121.24868, 37.83035], [-121.24867, 37.83031], [-121.24862, 37.83025], [-121.24851, 37.83021], [-121.25053, 37.83022]]]} | Restricted Access 2 | 48404 | Stockbridge Park | 32972 | 6125 | Woodbridge Owners Association 839 | Private 7 | Home Owners Association 16 | http://www.ourwoodbridge.net/ | Private 14 | 6125 | Woodbridge Owners Association 816 | Private 7 | Home Owners Association 15 | San Joaquin 39 | 5.608 | Stockbridge Park | 0 | Private Recreation or Education 65 | 4 | |
14372 | 14372 | 14371 | {"type": "Polygon", "coordinates": [[[-121.25374, 37.83022], [-121.2534, 37.83022], [-121.2534, 37.83037], [-121.2532, 37.83037], [-121.25318, 37.83028], [-121.25309, 37.83022], [-121.24498, 37.83021], [-121.24495, 37.82959], [-121.24471, 37.82949], [-121.24473, 37.82943], [-121.24474, 37.82938], [-121.24471, 37.82933], [-121.24467, 37.82928], [-121.24444, 37.82917], [-121.24416, 37.82898], [-121.24384, 37.8288], [-121.24381, 37.82876], [-121.24381, 37.82871], [-121.24388, 37.82854], [-121.24397, 37.82828], [-121.24404, 37.82793], [-121.24405, 37.82728], [-121.24412, 37.82707], [-121.24411, 37.827], [-121.24406, 37.82695], [-121.24407, 37.82661], [-121.24419, 37.82661], [-121.24425, 37.82773], [-121.24501, 37.82774], [-121.24513, 37.83008], [-121.25373, 37.83009], [-121.25374, 37.83022]]]} | Restricted Access 2 | 44476 | Plaza Park | 32971 | 6125 | Woodbridge Owners Association 839 | Private 7 | Home Owners Association 16 | http://www.ourwoodbridge.net/ | Private 14 | 6125 | Woodbridge Owners Association 816 | Private 7 | Home Owners Association 15 | San Joaquin 39 | 7.49 | Plaza Park | 0 | Private Recreation or Education 65 | 4 | |
1118 | 1118 | 1117 | {"type": "Polygon", "coordinates": [[[-117.15742, 32.70928], [-117.15639, 32.70929], [-117.15639, 32.70847], [-117.15742, 32.70847], [-117.15742, 32.70928]]]} | Restricted Access 2 | 47585 | The Park at Petco Park | 31312 | 6117 | Petco Park Owner 322 | Private 7 | Commercial 20 | http://www.petcoparkinsider.com/park-at-the-park | Private 14 | 6117 | Petco Park Owner 319 | Private 7 | Commercial 18 | http://www.petcoparkinsider.com/park-at-the-park | San Diego 4 | 2.17 | The Park at Petco Park | 0 | Private Recreation or Education 65 | 4 |
6993 | 6993 | 6992 | {"type": "Polygon", "coordinates": [[[-121.24324, 37.83763], [-121.24319, 37.83766], [-121.24315, 37.83772], [-121.24315, 37.83793], [-121.24308, 37.83812], [-121.24299, 37.83831], [-121.24286, 37.83848], [-121.24261, 37.83871], [-121.24241, 37.83883], [-121.24208, 37.83897], [-121.24171, 37.83906], [-121.24133, 37.83908], [-121.24108, 37.83906], [-121.24072, 37.83897], [-121.24039, 37.83883], [-121.2401, 37.83863], [-121.23987, 37.83839], [-121.23976, 37.83821], [-121.23968, 37.83802], [-121.23965, 37.8379], [-121.23966, 37.8378], [-121.23969, 37.83779], [-121.23969, 37.83771], [-121.23966, 37.83765], [-121.23958, 37.8376], [-121.23959, 37.83758], [-121.24321, 37.83759], [-121.24324, 37.83763]]]} | Restricted Access 2 | 47557 | Liberty Park | 31274 | 6116 | Del Webb 847 | Private 7 | Home Owners Association 16 | https://www.delwebb.com | Private 14 | 6116 | Del Webb 825 | Private 7 | Home Owners Association 15 | San Joaquin 39 | 10.142 | Liberty 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 | ||
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 | |
4781 | 4781 | 4780 | {"type": "Polygon", "coordinates": [[[-117.09427, 33.49075], [-117.09413, 33.4908], [-117.09236, 33.48975], [-117.09204, 33.48957], [-117.09188, 33.48943], [-117.09177, 33.48927], [-117.0916, 33.48886], [-117.09146, 33.48864], [-117.09201, 33.48839], [-117.09211, 33.48855], [-117.09206, 33.4891], [-117.09194, 33.48924], [-117.09198, 33.4893], [-117.09222, 33.48943], [-117.09228, 33.48942], [-117.09233, 33.48948], [-117.09239, 33.48951], [-117.09237, 33.48959], [-117.09326, 33.49009], [-117.09336, 33.49005], [-117.09339, 33.49009], [-117.09345, 33.49012], [-117.09356, 33.49012], [-117.09361, 33.4902], [-117.09398, 33.49024], [-117.09411, 33.49022], [-117.09427, 33.49075]]]} | Restricted Access 2 | 47164 | Unknown Park - Paseo del Sol Master Association | 31757 | 6110 | Paseo del Sol Master Association 780 | Private 7 | Home Owners Association 16 | http://www.twmc.com/paseodelsol/ | Private 14 | 6110 | Paseo del Sol Master Association 760 | Private 7 | Home Owners Association 15 | Riverside 10 | 2.526 | 0 | Private Recreation or Education 65 | 4 | ||
8502 | 8502 | 8501 | {"type": "Polygon", "coordinates": [[[-122.23966, 37.81022], [-122.23962, 37.81033], [-122.23902, 37.8103], [-122.239, 37.81013], [-122.23843, 37.81001], [-122.2356, 37.81012], [-122.23559, 37.81013], [-122.23561, 37.81043], [-122.23556, 37.81043], [-122.23553, 37.81013], [-122.23548, 37.81012], [-122.23515, 37.81018], [-122.23484, 37.81029], [-122.23459, 37.81043], [-122.23429, 37.81067], [-122.23402, 37.81056], [-122.23368, 37.81045], [-122.23349, 37.81031], [-122.23331, 37.81025], [-122.23306, 37.8104], [-122.23303, 37.81037], [-122.23329, 37.81021], [-122.23396, 37.81012], [-122.23487, 37.80994], [-122.2355, 37.80984], [-122.23544, 37.80953], [-122.23549, 37.80952], [-122.23556, 37.80983], [-122.23608, 37.80979], [-122.23649, 37.80977], [-122.23689, 37.80977], [-122.23744, 37.8098], [-122.23793, 37.80986], [-122.23838, 37.80993], [-122.23878, 37.81001], [-122.23929, 37.81014], [-122.23941, 37.80984], [-122.23946, 37.80985], [-122.23935, 37.81015], [-122.23966, 37.81022]]]} | Restricted Access 2 | 13317 | Oak Grove Park | 31754 | 6106 | Lakeshore Homes Association 896 | Private 7 | Home Owners Association 16 | http://lakeshorehomes.net/administration/parks-committee | Private 14 | 6106 | Lakeshore Homes Association 870 | Private 7 | Home Owners Association 15 | Alameda 17 | 4.164 | Oak Grove 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 | ||
14630 | 14630 | 14629 | {"type": "Polygon", "coordinates": [[[-122.25647, 37.85554], [-122.25626, 37.85557], [-122.25622, 37.85524], [-122.25641, 37.85523], [-122.25647, 37.85554]]]} | Open Access 1 | 47647 | Bateman Park | 31391 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 6103 | Private Landowner 774 | Private 7 | Other 26 | Alameda 17 | 0.16 | Bateman 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]);