superunits_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

62 rows where ACCESS_TYP = 2, MNG_AG_LEV = 4 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

Suggested facets: MNG_AG_ID, AGNCY_WEB, YR_EST

MNG_AG_TYP 1

  • Recreation/Parks District · 62 ✖

ACCESS_TYP 1

  • Restricted Access · 62 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
318 318 317 {"type": "Polygon", "coordinates": [[[-122.10346, 37.63089], [-122.10346, 37.63092], [-122.10342, 37.63095], [-122.10209, 37.63146], [-122.10118, 37.63149], [-122.10113, 37.62978], [-122.10242, 37.62927], [-122.10248, 37.6293], [-122.10346, 37.63089]]]} Restricted Access 2 Brenkwitz School Park   31949 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 8.676 Brenkwitz School Park  
320 320 319 {"type": "Polygon", "coordinates": [[[-122.11964, 37.68374], [-122.11923, 37.684], [-122.11911, 37.68404], [-122.1168, 37.6842], [-122.11595, 37.68321], [-122.11627, 37.683], [-122.11617, 37.68289], [-122.11753, 37.6819], [-122.11964, 37.68374]]]} Restricted Access 2 Colonial Acres School Park   31951 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 11.664 Colonial Acres School Park  
321 321 320 {"type": "Polygon", "coordinates": [[[-122.05604, 37.67111], [-122.05571, 37.6729], [-122.05568, 37.67326], [-122.05563, 37.67337], [-122.05549, 37.67348], [-122.05533, 37.67354], [-122.05428, 37.67355], [-122.05406, 37.67328], [-122.0545, 37.67093], [-122.05604, 37.67111]]]} Restricted Access 2 East Avenue School Park   31952 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 9.509 East Avenue School Park  
322 322 321 {"type": "Polygon", "coordinates": [[[-122.02891, 37.61505], [-122.02833, 37.61549], [-122.02815, 37.61565], [-122.02808, 37.61564], [-122.02768, 37.6154], [-122.0275, 37.61532], [-122.02734, 37.61528], [-122.02669, 37.61518], [-122.0265, 37.6151], [-122.02633, 37.61497], [-122.02598, 37.61449], [-122.02752, 37.6138], [-122.02891, 37.61502], [-122.02891, 37.61505]]]} Restricted Access 2 El Rancho Verde School Park   31953 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 6.895 El Rancho Verde School Park  
1059 1059 1058 {"type": "Polygon", "coordinates": [[[-116.96711, 33.7251], [-116.96673, 33.72511], [-116.96673, 33.72566], [-116.96295, 33.72571], [-116.96294, 33.7238], [-116.9636, 33.7238], [-116.96476, 33.72315], [-116.96711, 33.72285], [-116.96711, 33.7251]]]} Restricted Access 2 Echo Hills Golf Course   32829 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 25.115 Echo Hills GC  
2264 2264 2263 {"type": "Polygon", "coordinates": [[[-122.09445, 37.88338], [-122.09175, 37.88567], [-122.0913, 37.88555], [-122.09123, 37.88545], [-122.09074, 37.885], [-122.09061, 37.88469], [-122.09012, 37.88429], [-122.08996, 37.88405], [-122.08948, 37.88366], [-122.08937, 37.88343], [-122.08893, 37.8827], [-122.08899, 37.88222], [-122.08811, 37.88179], [-122.08768, 37.88189], [-122.08729, 37.88168], [-122.08774, 37.88148], [-122.08918, 37.88023], [-122.08956, 37.87957], [-122.08961, 37.88149], [-122.09214, 37.88146], [-122.09219, 37.88257], [-122.09319, 37.88257], [-122.09445, 37.88338]]]} Restricted Access 2 Briones/Las Trampas Trail - land bank   16397 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 38.11 Briones/Las Trampas Trail - land bank 2008
2306 2306 2305 {"type": "Polygon", "coordinates": [[[-121.71024, 37.76663], [-121.7079, 37.77415], [-121.70861, 37.775], [-121.70249, 37.77597], [-121.70061, 37.77821], [-121.69776, 37.77918], [-121.69744, 37.77836], [-121.69734, 37.77804], [-121.69726, 37.77786], [-121.69712, 37.77763], [-121.69695, 37.77741], [-121.69671, 37.77718], [-121.69644, 37.77698], [-121.69613, 37.77681], [-121.69552, 37.77656], [-121.69534, 37.77644], [-121.69521, 37.7763], [-121.6951, 37.77608], [-121.69506, 37.77588], [-121.69507, 37.77573], [-121.69515, 37.77546], [-121.69044, 37.77473], [-121.69018, 37.77434], [-121.68764, 37.77437], [-121.68661, 37.77396], [-121.68596, 37.77339], [-121.68504, 37.77299], [-121.68445, 37.77171], [-121.68609, 37.77064], [-121.68392, 37.76844], [-121.68359, 37.76766], [-121.68331, 37.76642], [-121.69247, 37.76646], [-121.69339, 37.76714], [-121.69336, 37.76799], [-121.69716, 37.76913], [-121.69886, 37.76921], [-121.69887, 37.7692], [-121.69888, 37.7665], [-121.71024, 37.76663]]]} Restricted Access 2 Brushy Peak   16455 2062 Livermore Area Recreation and Park District 388 Special District 4 Recreation/Parks District 4 http://www.larpd.dst.ca.us/ Special District 4 513.51 Brushy Peak  
2310 2310 2309 {"type": "Polygon", "coordinates": [[[-121.71059, 37.74507], [-121.71056, 37.74523], [-121.70849, 37.74993], [-121.70578, 37.74938], [-121.70493, 37.74973], [-121.70362, 37.75092], [-121.70222, 37.75251], [-121.70046, 37.75422], [-121.70019, 37.75511], [-121.69957, 37.75587], [-121.69902, 37.75662], [-121.69754, 37.75853], [-121.69725, 37.75852], [-121.69788, 37.75754], [-121.6986, 37.75645], [-121.69922, 37.75567], [-121.69983, 37.75501], [-121.70016, 37.75397], [-121.70184, 37.75238], [-121.70256, 37.75161], [-121.70307, 37.75083], [-121.70471, 37.74935], [-121.70584, 37.74899], [-121.70831, 37.74962], [-121.71036, 37.74507], [-121.71059, 37.74507]]]} Restricted Access 2 Brushy Peak Regional Preserve   16456 2062 Livermore Area Recreation and Park District 388 Special District 4 Recreation/Parks District 4 http://www.larpd.dst.ca.us/ Special District 4 17.32 Brushy Peak RPr 2005
2481 2481 2480 {"type": "Polygon", "coordinates": [[[-122.00373, 37.76975], [-122.00324, 37.76996], [-122.00269, 37.77028], [-122.00215, 37.77041], [-122.00191, 37.77061], [-122.00165, 37.77101], [-122.00127, 37.77147], [-122.00085, 37.77183], [-122.00119, 37.77061], [-122.00129, 37.7703], [-122.00161, 37.77011], [-122.00179, 37.76986], [-122.0018, 37.76926], [-122.00185, 37.76919], [-122.00177, 37.76841], [-122.00137, 37.76813], [-122.00051, 37.76805], [-121.99997, 37.76845], [-121.99925, 37.76789], [-121.99863, 37.76767], [-121.9985, 37.76746], [-121.99807, 37.76732], [-121.99787, 37.76713], [-121.99794, 37.76655], [-121.99769, 37.76609], [-121.99777, 37.76584], [-121.99772, 37.76579], [-121.99705, 37.76618], [-121.99718, 37.76706], [-121.99692, 37.76774], [-121.99579, 37.76749], [-121.99604, 37.76691], [-121.99592, 37.76624], [-121.99563, 37.76595], [-121.99481, 37.76636], [-121.99461, 37.76817], [-121.9942, 37.76856], [-121.99265, 37.76609], [-121.99661, 37.76551], [-121.99928, 37.76518], [-122.00373, 37.76975]]]} Restricted Access 2 Calaveras Ridge Trail - land bank   16671 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 43.388 Calaveras Ridge Trail - land bank  
2820 2820 2819 {"type": "Polygon", "coordinates": [[[-122.02404, 37.66917], [-122.02383, 37.66911], [-122.02395, 37.66891], [-122.02396, 37.66892], [-122.02404, 37.66917]]]} Restricted Access 2 Chabot - Garin Trail Corridor   17108 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 0.064 Chabot - Garin Trail Corridor  
3638 3638 3637 {"type": "Polygon", "coordinates": [[[-122.74565, 38.48914], [-122.74561, 38.49073], [-122.74474, 38.49073], [-122.74477, 38.48913], [-122.74565, 38.48914]]]} Restricted Access 2 Dogbane Preserve   18185 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 3.336 Dogbane Preserve 1997
4253 4253 4252 {"type": "Polygon", "coordinates": [[[-122.04308, 37.68652], [-122.04287, 37.68656], [-122.04248, 37.68602], [-122.04086, 37.68619], [-122.04068, 37.68582], [-122.04091, 37.68578], [-122.04108, 37.68544], [-122.041, 37.68517], [-122.04087, 37.68423], [-122.04073, 37.68369], [-122.04069, 37.68286], [-122.04054, 37.682], [-122.04028, 37.68125], [-122.03894, 37.68066], [-122.03881, 37.68018], [-122.03817, 37.68023], [-122.03823, 37.6797], [-122.03637, 37.68023], [-122.03604, 37.67954], [-122.03613, 37.67873], [-122.03264, 37.67776], [-122.03309, 37.67686], [-122.0338, 37.67677], [-122.0343, 37.67623], [-122.03509, 37.67612], [-122.03518, 37.67667], [-122.03535, 37.67714], [-122.03573, 37.67764], [-122.03624, 37.67795], [-122.03704, 37.67824], [-122.03739, 37.67839], [-122.03772, 37.67857], [-122.03834, 37.67893], [-122.03878, 37.67871], [-122.03935, 37.679], [-122.04007, 37.67865], [-122.04036, 37.67781], [-122.04075, 37.6793], [-122.04214, 37.68386], [-122.04308, 37.68652]]]} Restricted Access 2 Five Canyons trail corridor   18933 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 50.727 Five Canyons trail corridor  
4913 4913 4912 {"type": "Polygon", "coordinates": [[[-122.77518, 38.5124], [-122.77517, 38.51382], [-122.77439, 38.51382], [-122.77438, 38.51457], [-122.77441, 38.51462], [-122.77411, 38.51462], [-122.77416, 38.51461], [-122.77419, 38.51456], [-122.77419, 38.51408], [-122.77381, 38.51408], [-122.77007, 38.51134], [-122.77015, 38.51127], [-122.77266, 38.51126], [-122.77306, 38.5114], [-122.7732, 38.51147], [-122.77398, 38.51204], [-122.77415, 38.51213], [-122.77433, 38.5122], [-122.77453, 38.51225], [-122.77454, 38.5124], [-122.77518, 38.5124]]]} Restricted Access 2 Haroutunian - North   19687 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 17.885 Haroutunian - North 1998
5890 5890 5889 {"type": "Polygon", "coordinates": [[[-121.93333, 36.50126], [-121.93326, 36.50153], [-121.93266, 36.50142], [-121.93222, 36.50145], [-121.93206, 36.50171], [-121.93202, 36.50193], [-121.93202, 36.50211], [-121.93237, 36.50231], [-121.93186, 36.50242], [-121.93146, 36.50254], [-121.93119, 36.50253], [-121.93115, 36.50254], [-121.93127, 36.50272], [-121.93136, 36.50297], [-121.93161, 36.5032], [-121.93153, 36.50331], [-121.93128, 36.50335], [-121.93096, 36.50323], [-121.93074, 36.50311], [-121.93058, 36.50294], [-121.93043, 36.50283], [-121.93107, 36.50243], [-121.93107, 36.50242], [-121.93099, 36.50237], [-121.93084, 36.50218], [-121.93118, 36.50214], [-121.93121, 36.50217], [-121.9315, 36.50207], [-121.93171, 36.50176], [-121.93173, 36.50144], [-121.93207, 36.50111], [-121.9323, 36.50095], [-121.93268, 36.50063], [-121.93302, 36.50082], [-121.93285, 36.50113], [-121.93333, 36.50126]]]} Restricted Access 2 Laidlaw-Apte Pine Forest Reserve   20872 2085 Monterey Peninsula Regional Park District 46 Special District 4 Recreation/Parks District 4 http://www.mprpd.org/ Special District 4 4.783 Laidlaw-Apte Pine Forest Reserve  
6813 6813 6812 {"type": "MultiPolygon", "coordinates": [[[[-118.85683, 34.23954], [-118.8568, 34.23959], [-118.8567, 34.23937], [-118.85683, 34.23954], [-118.85683, 34.23954]]], [[[-118.85689, 34.23975], [-118.85688, 34.23975], [-118.85685, 34.23971], [-118.85685, 34.23971], [-118.85689, 34.23975]]], [[[-118.85275, 34.24064], [-118.85264, 34.24059], [-118.85237, 34.24061], [-118.85243, 34.24058], [-118.85243, 34.2406], [-118.85264, 34.24058], [-118.85275, 34.24064]]], [[[-118.85339, 34.24098], [-118.85317, 34.2408], [-118.85289, 34.2407], [-118.85298, 34.24071], [-118.85321, 34.24082], [-118.85339, 34.24098]]], [[[-118.8536, 34.2412], [-118.85343, 34.24101], [-118.85343, 34.24101], [-118.85345, 34.24102], [-118.8536, 34.2412]]], [[[-118.84856, 34.24296], [-118.84855, 34.24427], [-118.84855, 34.24422], [-118.84856, 34.24296]]], [[[-118.86424, 34.24569], [-118.86392, 34.24579], [-118.86363, 34.24573], [-118.86183, 34.24504], [-118.85909, 34.24514], [-118.85907, 34.24557], [-118.85582, 34.24601], [-118.85521, 34.24539], [-118.85472, 34.24505], [-118.85435, 34.2448], [-118.85356, 34.24447], [-118.85308, 34.24441], [-118.85229, 34.24447], [-118.85197, 34.24434], [-118.85209, 34.24376], [-118.85209, 34.2433], [-118.85238, 34.24315], [-118.85305, 34.24322], [-118.85335, 34.24361], [-118.85382, 34.24395], [-118.85445, 34.24414], [-118.85491, 34.24409], [-118.85552, 34.24377], [-118.85677, 34.24345], [-118.85787, 34.24342], [-118.85893, 34.24344], [-118.86001, 34.24322], [-118.86029, 34.24304], [-118.86109, 34.2424], [-118.86142, 34.24203], [-118.86166, 34.24164], [-118.86184, 34.24115], [-118.86212, 34.24004], [-118.86244, 34.23969], [-118.86267, 34.23997], [-118.86275, 34.24039], [-118.86274, 34.24099], [-118.86322, 34.24375], [-118.86361, 34.24494], [-118.86381, 34.24529], [-118.86424, 34.24569]]], [[[-118.8579, 34.24681], [-118.85901, 34.24664], [-118.8583, 34.24676], [-118.8579, 34.24681]]], [[[-118.85211, 34.24762], [-118.8504, 34.24762], [-118.85038, 34.24535], [-118.84855, 34.24563], [-118.85039, 34.24535], [-118.85042, 34.2476], [-118.85211, 34.24762]]]]} Restricted Access 2 McCrea Ranch   22015 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 63.715 McCrea Ranch 0
7595 7595 7594 {"type": "Polygon", "coordinates": [[[-118.84593, 34.21504], [-118.84583, 34.21528], [-118.84571, 34.21531], [-118.84568, 34.21533], [-118.84565, 34.2154], [-118.84567, 34.21546], [-118.84574, 34.21555], [-118.84592, 34.2167], [-118.84593, 34.21685], [-118.84592, 34.21695], [-118.8459, 34.21703], [-118.84587, 34.21707], [-118.8458, 34.21709], [-118.84297, 34.21682], [-118.84289, 34.21681], [-118.84283, 34.21676], [-118.84283, 34.21639], [-118.84281, 34.21609], [-118.84273, 34.21571], [-118.84263, 34.21539], [-118.84293, 34.21527], [-118.84298, 34.21532], [-118.84309, 34.21537], [-118.84317, 34.21537], [-118.84329, 34.21535], [-118.84357, 34.21536], [-118.84363, 34.21538], [-118.84371, 34.21546], [-118.84383, 34.21548], [-118.84391, 34.21544], [-118.84393, 34.2154], [-118.84394, 34.21536], [-118.84393, 34.2153], [-118.84428, 34.21507], [-118.84495, 34.21509], [-118.84593, 34.21504]]]} Restricted Access 2 Oakbrook Neighborhood Park   23018 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 13.483 Oakbrook Neighborhood Park  
7604 7604 7603 {"type": "Polygon", "coordinates": [[[-121.73098, 38.00441], [-121.73064, 38.0048], [-121.73007, 38.00476], [-121.73001, 38.00463], [-121.72957, 38.00478], [-121.72957, 38.00463], [-121.72949, 38.00436], [-121.72888, 38.00407], [-121.72775, 38.00355], [-121.72714, 38.00337], [-121.72646, 38.00321], [-121.72603, 38.00306], [-121.72553, 38.00283], [-121.72515, 38.00269], [-121.72473, 38.00262], [-121.72411, 38.00265], [-121.72371, 38.00275], [-121.72337, 38.00287], [-121.72318, 38.0029], [-121.7232, 38.00179], [-121.73098, 38.00441]]]} Restricted Access 2 Oakley (Legless Lizard) Land Bank   23030 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 7.853 Oakley (Legless Lizard) Land Bank  
7654 7654 7653 {"type": "Polygon", "coordinates": [[[-122.15145, 37.62482], [-122.1508, 37.62499], [-122.14973, 37.62515], [-122.14837, 37.62508], [-122.14707, 37.62481], [-122.14004, 37.62225], [-122.13959, 37.62203], [-122.13915, 37.62174], [-122.14433, 37.62003], [-122.14478, 37.62002], [-122.14935, 37.61837], [-122.15103, 37.61782], [-122.15106, 37.61893], [-122.15087, 37.61931], [-122.15075, 37.62021], [-122.15092, 37.62129], [-122.15132, 37.6246], [-122.15145, 37.62482]]]} Restricted Access 2 Oliver Property   23136 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 118.29 Oliver Property 1977
7835 7835 7834 {"type": "Polygon", "coordinates": [[[-122.27111, 38.04044], [-122.26883, 38.04296], [-122.26793, 38.04407], [-122.26606, 38.04552], [-122.26345, 38.04303], [-122.2644, 38.04222], [-122.26428, 38.04211], [-122.26433, 38.04207], [-122.26433, 38.04205], [-122.26428, 38.042], [-122.26421, 38.04204], [-122.26333, 38.04124], [-122.26342, 38.04109], [-122.26365, 38.0408], [-122.26384, 38.04059], [-122.26413, 38.04034], [-122.26445, 38.04011], [-122.2648, 38.03991], [-122.26517, 38.03974], [-122.26694, 38.04149], [-122.27043, 38.0391], [-122.27111, 38.04044]]]} Restricted Access 2 San Pablo Bay Regional Shoreline   24966 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 57.656 San Pablo Bay Reg. Shoreline 1976
7849 7849 7848 {"type": "Polygon", "coordinates": [[[-121.45978, 38.51394], [-121.45867, 38.51395], [-121.45865, 38.51401], [-121.45764, 38.51401], [-121.45764, 38.5122], [-121.45977, 38.5122], [-121.45978, 38.51394]]]} Restricted Access 2 Pacific Park   23303 2160 Southgate Recreation and Park District 494 Special District 4 Recreation/Parks District 4 http://www.southgaterecandpark.net/ Special District 4 9.079 Pacific Park  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);