superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 62 and MNG_AG_TYP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2184 | 2184 | 2183 | {"type": "Polygon", "coordinates": [[[-117.72843, 33.88586], [-117.72826, 33.88624], [-117.72779, 33.88617], [-117.72761, 33.8864], [-117.72743, 33.88639], [-117.7273, 33.88689], [-117.7271, 33.88749], [-117.72611, 33.88751], [-117.727, 33.88512], [-117.72779, 33.88526], [-117.72824, 33.88528], [-117.72829, 33.88532], [-117.72831, 33.88558], [-117.72835, 33.88572], [-117.72843, 33.88586]]]} | Open Access 1 | Box Canyon Park | 16313 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 7.094 | Box Canyon Park | ||
2282 | 2282 | 2281 | {"type": "Polygon", "coordinates": [[[-117.792, 33.87101], [-117.79198, 33.87115], [-117.79198, 33.87145], [-117.79161, 33.87166], [-117.79163, 33.87218], [-117.79114, 33.8722], [-117.79107, 33.87209], [-117.7909, 33.87194], [-117.79159, 33.87124], [-117.792, 33.87101]]]} | Open Access 1 | Brookmont Park | 16425 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1.441 | Brookmont Park | ||
2286 | 2286 | 2285 | {"type": "Polygon", "coordinates": [[[-117.70288, 33.87817], [-117.70251, 33.87832], [-117.70206, 33.87863], [-117.70185, 33.87874], [-117.70172, 33.87879], [-117.70147, 33.87886], [-117.70108, 33.87889], [-117.70017, 33.87881], [-117.69987, 33.87873], [-117.69893, 33.87834], [-117.69873, 33.87829], [-117.69841, 33.87826], [-117.69839, 33.87801], [-117.69991, 33.8781], [-117.70086, 33.87811], [-117.70161, 33.87808], [-117.70218, 33.87803], [-117.70279, 33.87795], [-117.70288, 33.87817]]]} | Open Access 1 | Brush Canyon Park | 16452 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 6.253 | Brush Canyon Park | ||
2309 | 2309 | 2308 | {"type": "Polygon", "coordinates": [[[-117.71543, 33.88099], [-117.71522, 33.88101], [-117.71505, 33.88106], [-117.71493, 33.88115], [-117.71472, 33.88136], [-117.71458, 33.88166], [-117.71451, 33.88166], [-117.71444, 33.88123], [-117.71436, 33.88118], [-117.71431, 33.88118], [-117.71407, 33.88137], [-117.71396, 33.88129], [-117.71391, 33.88128], [-117.71385, 33.88129], [-117.7137, 33.8814], [-117.71361, 33.8814], [-117.71357, 33.88127], [-117.71346, 33.88116], [-117.71338, 33.88111], [-117.71335, 33.88102], [-117.71335, 33.88093], [-117.71337, 33.88087], [-117.71323, 33.88077], [-117.71345, 33.88066], [-117.71368, 33.88049], [-117.71381, 33.88039], [-117.714, 33.8802], [-117.71543, 33.88099]]]} | Open Access 1 | Bryant Ranch Park | 16459 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 3.664 | Bryant Ranch Park | ||
13640 | 13640 | 13639 | {"type": "Polygon", "coordinates": [[[-117.76291, 33.90357], [-117.76253, 33.90422], [-117.76227, 33.90392], [-117.76215, 33.90382], [-117.76202, 33.90375], [-117.76188, 33.9037], [-117.76165, 33.90367], [-117.7617, 33.90353], [-117.76291, 33.90357]]]} | Open Access 1 | Casino Ridge Park | 31111 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 0.986 | Casino Ridge Park | ||
3648 | 3648 | 3647 | {"type": "Polygon", "coordinates": [[[-117.76555, 33.88034], [-117.76461, 33.88017], [-117.76306, 33.88031], [-117.76281, 33.88041], [-117.76189, 33.87954], [-117.76233, 33.87972], [-117.76268, 33.87981], [-117.76335, 33.8799], [-117.76415, 33.87985], [-117.76458, 33.87971], [-117.76515, 33.87938], [-117.76551, 33.87923], [-117.76552, 33.87943], [-117.76549, 33.87972], [-117.76555, 33.88034]]]} | Open Access 1 | Dominguez Trailside Park | 18198 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 4.344 | Dominguez Trailside Park | ||
3801 | 3801 | 3800 | {"type": "Polygon", "coordinates": [[[-117.75005, 33.87785], [-117.74989, 33.87934], [-117.74912, 33.88554], [-117.74839, 33.88686], [-117.74802, 33.88679], [-117.74801, 33.88677], [-117.74797, 33.88676], [-117.74775, 33.88679], [-117.74591, 33.88666], [-117.74591, 33.88628], [-117.74601, 33.88553], [-117.74597, 33.88517], [-117.74588, 33.88488], [-117.7459, 33.88373], [-117.74699, 33.88334], [-117.74711, 33.88264], [-117.74716, 33.88247], [-117.74735, 33.8821], [-117.74739, 33.88218], [-117.74746, 33.8822], [-117.74761, 33.88218], [-117.74778, 33.88213], [-117.74796, 33.88203], [-117.74809, 33.8819], [-117.74816, 33.88181], [-117.74828, 33.88162], [-117.74848, 33.88126], [-117.74858, 33.88093], [-117.74887, 33.87857], [-117.74889, 33.8784], [-117.74887, 33.87835], [-117.74895, 33.87822], [-117.74904, 33.87815], [-117.74927, 33.87802], [-117.74953, 33.87791], [-117.74981, 33.87786], [-117.75005, 33.87785]]]} | Open Access 1 | East Side Community Park | 18382 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 46.319 | East Side Community Park | ||
4138 | 4138 | 4137 | {"type": "Polygon", "coordinates": [[[-117.79359, 33.89317], [-117.7925, 33.89354], [-117.79204, 33.89354], [-117.79144, 33.89368], [-117.79082, 33.89369], [-117.79105, 33.89335], [-117.79115, 33.89317], [-117.79126, 33.89285], [-117.79131, 33.8926], [-117.79134, 33.89305], [-117.79295, 33.89303], [-117.79295, 33.89283], [-117.79312, 33.89282], [-117.79312, 33.89263], [-117.79317, 33.89261], [-117.79317, 33.89234], [-117.79344, 33.89232], [-117.79343, 33.89188], [-117.79357, 33.89188], [-117.79359, 33.89317]]]} | Open Access 1 | Fairmont Knolls Park | 18803 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 4.098 | Fairmont Knolls Park | ||
13638 | 13638 | 13637 | {"type": "Polygon", "coordinates": [[[-117.79417, 33.89983], [-117.7939, 33.89981], [-117.79385, 33.89609], [-117.79364, 33.89607], [-117.79352, 33.88884], [-117.79402, 33.88884], [-117.79412, 33.89626], [-117.79398, 33.89627], [-117.79399, 33.89651], [-117.79412, 33.89653], [-117.79417, 33.89983]]]} | Open Access 1 | Gun Club Road Linear Park | 31110 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 11.419 | Gun Club Road Linear Park | ||
5308 | 5308 | 5307 | {"type": "Polygon", "coordinates": [[[-117.82647, 33.89296], [-117.82647, 33.89501], [-117.82494, 33.89501], [-117.82475, 33.8951], [-117.82447, 33.89519], [-117.82441, 33.89517], [-117.82441, 33.89385], [-117.82506, 33.89384], [-117.82507, 33.89327], [-117.82524, 33.89325], [-117.82543, 33.89329], [-117.8257, 33.89332], [-117.82585, 33.89332], [-117.82599, 33.89329], [-117.8262, 33.8932], [-117.82632, 33.89311], [-117.82647, 33.89296]]]} | Open Access 1 | Hurless Barton Park | 20159 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 8.384 | Hurless Barton Park | ||
5501 | 5501 | 5500 | {"type": "Polygon", "coordinates": [[[-117.75023, 33.88204], [-117.7501, 33.88221], [-117.74999, 33.88239], [-117.74953, 33.88226], [-117.74969, 33.88091], [-117.74971, 33.88107], [-117.75, 33.8819], [-117.75023, 33.88204]]]} | Open Access 1 | Jean Woodard Park | 20374 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1.118 | Jean Woodard Park | ||
5526 | 5526 | 5525 | {"type": "Polygon", "coordinates": [[[-117.80042, 33.89015], [-117.79835, 33.89014], [-117.7983, 33.88891], [-117.7984, 33.88883], [-117.80037, 33.88883], [-117.80042, 33.89015]]]} | Open Access 1 | Jessamyn West Park | 20405 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 6.896 | Jessamyn West Park | ||
5749 | 5749 | 5748 | {"type": "Polygon", "coordinates": [[[-117.79103, 33.87264], [-117.79058, 33.87268], [-117.79038, 33.87272], [-117.78998, 33.87288], [-117.7898, 33.87298], [-117.78901, 33.87354], [-117.78878, 33.87377], [-117.78863, 33.87392], [-117.78844, 33.87421], [-117.78833, 33.87443], [-117.78827, 33.87456], [-117.78824, 33.8747], [-117.78822, 33.87493], [-117.7885, 33.875], [-117.7883, 33.87576], [-117.78825, 33.8761], [-117.78828, 33.87713], [-117.78837, 33.87859], [-117.78835, 33.87892], [-117.78827, 33.87923], [-117.78813, 33.87954], [-117.78793, 33.87983], [-117.78776, 33.88001], [-117.78746, 33.88041], [-117.78723, 33.88029], [-117.78719, 33.88026], [-117.78718, 33.88022], [-117.78783, 33.87925], [-117.78794, 33.87899], [-117.78799, 33.87872], [-117.78794, 33.87714], [-117.7879, 33.87682], [-117.78785, 33.87532], [-117.78781, 33.87462], [-117.78804, 33.87408], [-117.78829, 33.87372], [-117.78846, 33.87353], [-117.78873, 33.87327], [-117.78921, 33.87291], [-117.78964, 33.87252], [-117.79025, 33.87217], [-117.79062, 33.87192], [-117.79087, 33.87211], [-117.79093, 33.87217], [-117.79099, 33.87225], [-117.79102, 33.87235], [-117.79103, 33.87264]]]} | Open Access 1 | Kingsbriar Park | 20666 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 10.666 | Kingsbriar Park | ||
13637 | 13637 | 13636 | {"type": "Polygon", "coordinates": [[[-117.71955, 33.87588], [-117.71947, 33.87591], [-117.7194, 33.87599], [-117.7188, 33.87579], [-117.71887, 33.87567], [-117.71897, 33.87556], [-117.71909, 33.87547], [-117.71923, 33.8754], [-117.71937, 33.87564], [-117.71949, 33.87563], [-117.71955, 33.87588]]]} | Open Access 1 | Las Brisas Park | 31107 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 0.613 | Las Brisas Park | ||
6015 | 6015 | 6014 | {"type": "Polygon", "coordinates": [[[-117.77421, 33.88288], [-117.77418, 33.88292], [-117.77414, 33.88294], [-117.77301, 33.88328], [-117.773, 33.88273], [-117.77295, 33.88171], [-117.77337, 33.88169], [-117.77357, 33.88214], [-117.77368, 33.88232], [-117.77387, 33.88252], [-117.77413, 33.88273], [-117.77419, 33.88281], [-117.77421, 33.88288]]]} | Open Access 1 | Las Palomas Tennis Park | 21062 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 2.926 | Las Palomas Tennis Park | ||
13636 | 13636 | 13635 | {"type": "MultiPolygon", "coordinates": [[[[-117.78127, 33.89583], [-117.78072, 33.89766], [-117.78052, 33.89762], [-117.78091, 33.89661], [-117.78088, 33.89655], [-117.78049, 33.89621], [-117.78049, 33.89612], [-117.78089, 33.89611], [-117.78098, 33.89576], [-117.78127, 33.89583]]], [[[-117.78851, 33.89929], [-117.78656, 33.89912], [-117.78583, 33.8991], [-117.78574, 33.89903], [-117.78572, 33.89835], [-117.78684, 33.89835], [-117.78687, 33.89838], [-117.78695, 33.89852], [-117.78709, 33.89867], [-117.78728, 33.89878], [-117.78751, 33.89885], [-117.78775, 33.89887], [-117.78786, 33.89886], [-117.78801, 33.89883], [-117.78823, 33.89875], [-117.7883, 33.89875], [-117.78842, 33.8988], [-117.78846, 33.89886], [-117.78845, 33.8991], [-117.78849, 33.89919], [-117.78851, 33.89929]]]]} | Open Access 1 | Lucia Kust Park | 31106 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 5.243 | Lucia Kust Park | ||
13812 | 13812 | 13811 | {"type": "Polygon", "coordinates": [[[-117.78951, 33.897], [-117.78951, 33.89703], [-117.78906, 33.89703], [-117.78901, 33.8971], [-117.7886, 33.89748], [-117.78854, 33.89749], [-117.78841, 33.89747], [-117.7883, 33.89754], [-117.78819, 33.89755], [-117.78811, 33.89754], [-117.78792, 33.89757], [-117.78781, 33.89755], [-117.78775, 33.89748], [-117.78745, 33.89731], [-117.78725, 33.89726], [-117.787, 33.89721], [-117.78661, 33.8972], [-117.78637, 33.89713], [-117.78623, 33.89704], [-117.78613, 33.89701], [-117.78606, 33.89696], [-117.78618, 33.89673], [-117.78635, 33.89649], [-117.78655, 33.89626], [-117.78678, 33.89605], [-117.78703, 33.89585], [-117.7873, 33.89567], [-117.78785, 33.89538], [-117.78789, 33.89625], [-117.78889, 33.89625], [-117.78888, 33.89644], [-117.78889, 33.89654], [-117.78894, 33.89666], [-117.789, 33.89674], [-117.78919, 33.89691], [-117.78939, 33.89697], [-117.78951, 33.897]]]} | Open Access 1 | Mustang Fields | 31336 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 9.255 | Mustang Fields | 2017 | |
13625 | 13625 | 13624 | {"type": "Polygon", "coordinates": [[[-117.80884, 33.88104], [-117.80739, 33.88209], [-117.80722, 33.88213], [-117.807, 33.88222], [-117.80693, 33.88222], [-117.80675, 33.88216], [-117.80693, 33.88149], [-117.80694, 33.8814], [-117.80691, 33.8813], [-117.80686, 33.88122], [-117.80678, 33.88115], [-117.80663, 33.88108], [-117.80691, 33.88065], [-117.80809, 33.88063], [-117.80862, 33.8807], [-117.80884, 33.88104]]]} | Open Access 1 | Phillip S. Paxton Equestrian Center | 31085 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 5.417 | Phillip S. Paxton Equestrian Ctr. | ||
13634 | 13634 | 13633 | {"type": "Polygon", "coordinates": [[[-117.78541, 33.90474], [-117.7852, 33.90483], [-117.78511, 33.90484], [-117.78479, 33.9047], [-117.78462, 33.90466], [-117.78444, 33.90463], [-117.78409, 33.90462], [-117.78399, 33.90459], [-117.78389, 33.90453], [-117.78375, 33.90428], [-117.78342, 33.9044], [-117.78343, 33.90368], [-117.78306, 33.90367], [-117.78344, 33.90343], [-117.78347, 33.90345], [-117.78358, 33.90344], [-117.78388, 33.9037], [-117.78402, 33.90378], [-117.78417, 33.90384], [-117.78457, 33.90395], [-117.78477, 33.90406], [-117.78488, 33.90416], [-117.78532, 33.90462], [-117.78541, 33.90474]]]} | Open Access 1 | Quarterhorse Staging Area | 31104 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 3.411 | Quarterhorse Staging Area | ||
8716 | 8716 | 8715 | {"type": "MultiPolygon", "coordinates": [[[[-117.78339, 33.89132], [-117.7834, 33.89134], [-117.7833, 33.89222], [-117.78322, 33.89345], [-117.78315, 33.89373], [-117.78307, 33.89389], [-117.78277, 33.89428], [-117.78215, 33.89503], [-117.7819, 33.89535], [-117.78168, 33.89575], [-117.78164, 33.89576], [-117.78107, 33.89563], [-117.78114, 33.89558], [-117.78122, 33.89531], [-117.78126, 33.89513], [-117.78161, 33.89495], [-117.78177, 33.89483], [-117.78198, 33.89464], [-117.78245, 33.89414], [-117.78284, 33.89367], [-117.78296, 33.89343], [-117.78298, 33.89329], [-117.78302, 33.89126], [-117.78332, 33.89128], [-117.78339, 33.89132]]], [[[-117.78372, 33.8898], [-117.78373, 33.88987], [-117.78369, 33.89009], [-117.7835, 33.89064], [-117.78338, 33.8911], [-117.7833, 33.89114], [-117.78299, 33.8911], [-117.78304, 33.89069], [-117.7832, 33.89065], [-117.78318, 33.89033], [-117.78322, 33.89027], [-117.78322, 33.89021], [-117.78338, 33.8901], [-117.78335, 33.88975], [-117.78364, 33.88976], [-117.78372, 33.8898]]]]} | Open Access 1 | Rio Del Oro Park | 24375 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 6.006 | Rio Del Oro Park |
Advanced export
JSON shape: default, array, newline-delimited
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]);