superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 297 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14367 | 14367 | 14366 | {"type": "MultiPolygon", "coordinates": [[[[-117.89005, 34.16595], [-117.88775, 34.16722], [-117.88764, 34.16709], [-117.88749, 34.16698], [-117.88708, 34.16659], [-117.88698, 34.16655], [-117.88689, 34.16653], [-117.88675, 34.16653], [-117.88667, 34.16655], [-117.88624, 34.16672], [-117.88602, 34.16689], [-117.88573, 34.16723], [-117.88558, 34.16751], [-117.88554, 34.16767], [-117.8855, 34.16813], [-117.88554, 34.16826], [-117.88566, 34.16844], [-117.88574, 34.16867], [-117.88588, 34.16897], [-117.88613, 34.1694], [-117.88621, 34.16984], [-117.88623, 34.1701], [-117.88617, 34.17039], [-117.88613, 34.1707], [-117.88603, 34.17095], [-117.88588, 34.17111], [-117.88567, 34.17129], [-117.88529, 34.17166], [-117.88523, 34.17179], [-117.88514, 34.17211], [-117.87297, 34.17211], [-117.87246, 34.16507], [-117.88806, 34.16511], [-117.88809, 34.16594], [-117.89005, 34.16595]]], [[[-117.89007, 34.1702], [-117.89007, 34.17102], [-117.8899, 34.17093], [-117.88961, 34.17125], [-117.88901, 34.17091], [-117.88883, 34.17084], [-117.88857, 34.17079], [-117.88827, 34.17079], [-117.88802, 34.17085], [-117.88778, 34.17095], [-117.88762, 34.17107], [-117.88712, 34.1707], [-117.88699, 34.17082], [-117.88688, 34.17095], [-117.88673, 34.17119], [-117.88654, 34.17181], [-117.88638, 34.17211], [-117.88534, 34.17211], [-117.88545, 34.17174], [-117.88553, 34.17169], [-117.88582, 34.17139], [-117.88603, 34.17122], [-117.88621, 34.17102], [-117.88624, 34.17093], [-117.88632, 34.17074], [-117.88636, 34.1704], [-117.88642, 34.1701], [-117.88641, 34.16983], [-117.88633, 34.16936], [-117.88606, 34.16891], [-117.88586, 34.16845], [-117.88572, 34.1682], [-117.8857, 34.16808], [-117.88575, 34.16765], [-117.88584, 34.16741], [-117.88595, 34.16726], [-117.88623, 34.16694], [-117.88635, 34.16686], [-117.88644, 34.16681], [-117.88678, 34.16669], [-117.88691, 34.1667], [-117.88701, 34.16675], [-117.88734, 34.1671], [-117.88751, 34.16722], [-117.88757, 34.16728], [-117.88783, 34.1677], [-117.88812, 34.16801], [-117.88819, 34.16814], [-117.88823, 34.16827], [-117.88832, 34.16845], [-117.88974, 34.17009], [-117.89007, 34.1702]]], [[[-117.89007, 34.17212], [-117.89007, 34.17212], [-117.8878, 34.17211], [-117.88791, 34.17183], [-117.88795, 34.17163], [-117.88802, 34.1715], [-117.88816, 34.17139], [-117.88826, 34.17135], [-117.88835, 34.17133], [-117.88851, 34.17133], [-117.88866, 34.17138], [-117.88974, 34.17198], [-117.89007, 34.17208], [-117.89007, 34.17212]]], [[[-117.89007, 34.17002], [-117.88986, 34.16996], [-117.88854, 34.16846], [-117.88847, 34.16834], [-117.88842, 34.16824], [-117.8884, 34.16814], [-117.88832, 34.16798], [-117.888, 34.16762], [-117.88789, 34.16744], [-117.88792, 34.16729], [-117.89005, 34.16611], [-117.89007, 34.17002]]], [[[-117.90541, 34.15784], [-117.9054, 34.15837], [-117.90455, 34.15824], [-117.90433, 34.15825], [-117.90415, 34.15832], [-117.90399, 34.15843], [-117.90366, 34.15842], [-117.90326, 34.15845], [-117.90308, 34.15848], [-117.90126, 34.1589], [-117.90099, 34.159], [-117.90058, 34.15916], [-117.89892, 34.16013], [-117.89881, 34.16018], [-117.89842, 34.16046], [-117.89818, 34.16074], [-117.89733, 34.16194], [-117.89668, 34.16145], [-117.8966, 34.16153], [-117.89659, 34.15995], [-117.8961, 34.16015], [-117.89459, 34.16034], [-117.89442, 34.16033], [-117.89427, 34.16024], [-117.89397, 34.16011], [-117.89372, 34.16003], [-117.89325, 34.15994], [-117.89276, 34.15977], [-117.89264, 34.15949], [-117.89224, 34.15922], [-117.89127, 34.15925], [-117.89005, 34.15966], [-117.89005, 34.15775], [-117.90541, 34.15784]]], [[[-117.90541, 34.1585], [-117.9054, 34.15879], [-117.90479, 34.15856], [-117.90458, 34.15851], [-117.90421, 34.15845], [-117.90436, 34.15839], [-117.90454, 34.15837], [-117.90541, 34.1585]]], [[[-117.90754, 34.15881], [-117.90753, 34.15953], [-117.9071, 34.15944], [-117.90649, 34.15922], [-117.90649, 34.15867], [-117.90754, 34.15881]]], [[[-117.90755, 34.15786], [-117.90754, 34.15868], [-117.90649, 34.15852], [-117.9065, 34.15785], [-117.90755, 34.15786]]]]} | Open Access 1 | Unnamed site - Pasadena, City of | 32659 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 363.971 | |||
1230 | 1230 | 1229 | {"type": "Polygon", "coordinates": [[[-118.14566, 34.12655], [-118.14418, 34.12656], [-118.14418, 34.12588], [-118.14436, 34.12587], [-118.14436, 34.12569], [-118.14566, 34.12568], [-118.14566, 34.12655]]]} | Open Access 1 | Allendale Park | http://cityofpasadena.net/PublicWorks/Allendale_Park/ | 15381 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 3.179 | Allendale Park | |
12423 | 12423 | 12422 | {"type": "Polygon", "coordinates": [[[-118.1837, 34.15772], [-118.18336, 34.15767], [-118.18317, 34.15828], [-118.18277, 34.15832], [-118.18247, 34.15829], [-118.18249, 34.15796], [-118.18231, 34.15786], [-118.18215, 34.15784], [-118.182, 34.15788], [-118.18187, 34.15798], [-118.18188, 34.15804], [-118.18199, 34.15824], [-118.18157, 34.1584], [-118.18128, 34.15803], [-118.18158, 34.15788], [-118.18156, 34.1577], [-118.18153, 34.15762], [-118.18145, 34.15748], [-118.18145, 34.1574], [-118.18137, 34.15739], [-118.181, 34.15752], [-118.18084, 34.15726], [-118.18122, 34.157], [-118.18118, 34.15694], [-118.18099, 34.15682], [-118.18082, 34.15677], [-118.18064, 34.15715], [-118.18043, 34.15714], [-118.1799, 34.15721], [-118.17963, 34.15668], [-118.17998, 34.15652], [-118.18004, 34.1564], [-118.18013, 34.15629], [-118.18026, 34.15622], [-118.1805, 34.15616], [-118.18082, 34.15587], [-118.18088, 34.15575], [-118.18089, 34.15564], [-118.18086, 34.15509], [-118.18079, 34.15485], [-118.18146, 34.15487], [-118.18145, 34.15455], [-118.18171, 34.15413], [-118.18202, 34.15386], [-118.18227, 34.15372], [-118.18229, 34.15366], [-118.18235, 34.15362], [-118.18239, 34.15355], [-118.18259, 34.15358], [-118.1837, 34.15772]]]} | Open Access 1 | Annandale Canyon Park | 29437 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 24.85 | Annandale Canyon Park | ||
2226 | 2226 | 2225 | {"type": "Polygon", "coordinates": [[[-118.15657, 34.16124], [-118.15621, 34.16175], [-118.15485, 34.16106], [-118.15557, 34.16043], [-118.15657, 34.16124]]]} | Open Access 1 | Brenner Park | 16353 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 2.724 | Brenner Park | ||
14595 | 14595 | 14594 | {"type": "Polygon", "coordinates": [[[-118.17436, 34.1834], [-118.1743, 34.1834], [-118.17301, 34.18282], [-118.17291, 34.18254], [-118.17283, 34.18244], [-118.17273, 34.18235], [-118.17215, 34.18199], [-118.1718, 34.18194], [-118.17174, 34.18191], [-118.17206, 34.18149], [-118.17211, 34.18112], [-118.17243, 34.18105], [-118.1725, 34.18065], [-118.17248, 34.1804], [-118.17237, 34.18021], [-118.17204, 34.18005], [-118.17168, 34.1796], [-118.17145, 34.17966], [-118.17108, 34.17965], [-118.17031, 34.17951], [-118.17015, 34.17919], [-118.17008, 34.17898], [-118.17006, 34.17881], [-118.17008, 34.17861], [-118.17012, 34.17851], [-118.17025, 34.1783], [-118.17049, 34.17802], [-118.17066, 34.17777], [-118.17073, 34.17761], [-118.17076, 34.17745], [-118.17038, 34.17752], [-118.17042, 34.17743], [-118.17041, 34.17735], [-118.1702, 34.17699], [-118.17015, 34.17694], [-118.17006, 34.17688], [-118.16982, 34.17677], [-118.16947, 34.17648], [-118.16929, 34.17639], [-118.16911, 34.17625], [-118.16886, 34.17611], [-118.16866, 34.17587], [-118.16823, 34.17543], [-118.16806, 34.17524], [-118.16766, 34.17524], [-118.16764, 34.17511], [-118.16728, 34.17524], [-118.16725, 34.17511], [-118.16721, 34.17492], [-118.16711, 34.17363], [-118.16701, 34.17317], [-118.16699, 34.17299], [-118.16696, 34.17178], [-118.16689, 34.17152], [-118.16668, 34.17114], [-118.16661, 34.17084], [-118.16664, 34.1702], [-118.16677, 34.16956], [-118.16679, 34.16932], [-118.16678, 34.16889], [-118.16679, 34.16843], [-118.16677, 34.1682], [-118.16642, 34.1671], [-118.16651, 34.1671], [-118.16652, 34.16709], [-118.16595, 34.16498], [-118.16523, 34.16349], [-118.16589, 34.16329], [-118.16778, 34.16277], [-118.16809, 34.16276], [-118.16841, 34.16264], [-118.16857, 34.16252], [-118.1689, 34.16241], [-118.16896, 34.16226], [-118.17004, 34.16195], [-118.16999, 34.16175], [-118.17002, 34.16172], [-118.16982, 34.16115], [-118.16974, 34.16109], [-118.16967, 34.161], [-118.16928, 34.15992], [-118.16932, 34.15971], [-118.16921, 34.15946], [-118.17032, 34.15985], [-118.171, 34.16012], [-118.17142, 34.16041], [-118.17165, 34.16111], [-118.17241, 34.16315], [-118.17217, 34.16322], [-118.17235, 34.16417], [-118.17242, 34.16439], [-118.17271, 34.16507], [-118.17318, 34.16645], [-118.17352, 34.16795], [-118.17399, 34.16795], [-118.17402, 34.16806], [-118.17425, 34.16914], [-118.17427, 34.16936], [-118.17447, 34.17027], [-118.17448, 34.17049], [-118.17468, 34.17142], [-118.17469, 34.17158], [-118.1748, 34.17226], [-118.17483, 34.17256], [-118.17478, 34.17312], [-118.17472, 34.17342], [-118.17456, 34.17402], [-118.17449, 34.17411], [-118.17437, 34.17418], [-118.17432, 34.17537], [-118.17339, 34.17649], [-118.17258, 34.17743], [-118.17253, 34.17803], [-118.17322, 34.17898], [-118.17357, 34.17931], [-118.1738, 34.17968], [-118.17394, 34.17995], [-118.17402, 34.18031], [-118.17366, 34.1808], [-118.17367, 34.18082], [-118.17359, 34.18104], [-118.1734, 34.18131], [-118.17345, 34.18137], [-118.17332, 34.18178], [-118.17344, 34.18247], [-118.17391, 34.18247], [-118.17394, 34.18268], [-118.17401, 34.18287], [-118.17436, 34.1834]]]} | Restricted Access 2 | Brookside Golf Course | http://www.cityofpasadena.net/PublicWorks/brookside_golf_course/ | 29070 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 293.631 | Brookside GC | |
2289 | 2289 | 2288 | {"type": "Polygon", "coordinates": [[[-118.16869, 34.15351], [-118.16865, 34.15354], [-118.16836, 34.15333], [-118.16826, 34.15332], [-118.16819, 34.15335], [-118.16814, 34.1534], [-118.16812, 34.15344], [-118.16805, 34.15383], [-118.16806, 34.15393], [-118.16779, 34.15411], [-118.16776, 34.15415], [-118.16784, 34.15438], [-118.168, 34.15465], [-118.16854, 34.15527], [-118.16857, 34.15539], [-118.16858, 34.15549], [-118.16855, 34.15561], [-118.1685, 34.15571], [-118.16843, 34.1558], [-118.16832, 34.15588], [-118.16822, 34.15592], [-118.16758, 34.15606], [-118.1676, 34.15659], [-118.16753, 34.15651], [-118.16743, 34.15645], [-118.16732, 34.15641], [-118.1672, 34.15641], [-118.16632, 34.15661], [-118.16607, 34.15669], [-118.16566, 34.15687], [-118.16435, 34.15769], [-118.16411, 34.15782], [-118.16386, 34.15734], [-118.16382, 34.15729], [-118.16343, 34.15642], [-118.16335, 34.1563], [-118.16308, 34.156], [-118.16347, 34.15576], [-118.16293, 34.15456], [-118.16303, 34.15449], [-118.16323, 34.15425], [-118.1628, 34.15332], [-118.16238, 34.15345], [-118.16284, 34.15231], [-118.16271, 34.15135], [-118.16242, 34.1512], [-118.16263, 34.15103], [-118.16247, 34.15079], [-118.16268, 34.15066], [-118.1629, 34.15045], [-118.16304, 34.15034], [-118.16357, 34.15003], [-118.16381, 34.14994], [-118.16408, 34.1497], [-118.16416, 34.14967], [-118.16448, 34.14959], [-118.16455, 34.14954], [-118.16462, 34.14942], [-118.16473, 34.1494], [-118.16452, 34.14863], [-118.16443, 34.1485], [-118.16425, 34.14833], [-118.16468, 34.14833], [-118.1652, 34.14871], [-118.1653, 34.14833], [-118.16548, 34.14831], [-118.16545, 34.14792], [-118.16543, 34.14783], [-118.16538, 34.14775], [-118.1653, 34.14766], [-118.1652, 34.14759], [-118.16509, 34.14755], [-118.16495, 34.14752], [-118.16473, 34.14742], [-118.16432, 34.14709], [-118.16447, 34.14693], [-118.16422, 34.14675], [-118.16411, 34.14655], [-118.16412, 34.14645], [-118.1651, 34.1462], [-118.165, 34.14637], [-118.165, 34.14655], [-118.16541, 34.14669], [-118.16582, 34.14675], [-118.16616, 34.14688], [-118.1662, 34.14692], [-118.1661, 34.14692], [-118.1661, 34.14694], [-118.16613, 34.14696], [-118.16626, 34.14697], [-118.16679, 34.14743], [-118.16676, 34.14781], [-118.16648, 34.14813], [-118.16642, 34.14823], [-118.16635, 34.14836], [-118.16632, 34.1485], [-118.16631, 34.14864], [-118.16632, 34.14876], [-118.16643, 34.14917], [-118.1663, 34.14923], [-118.16597, 34.14903], [-118.1658, 34.14936], [-118.16591, 34.15034], [-118.1661, 34.1504], [-118.16628, 34.15052], [-118.16633, 34.15061], [-118.16656, 34.15077], [-118.16668, 34.1509], [-118.16675, 34.1509], [-118.16678, 34.15112], [-118.16683, 34.15137], [-118.16697, 34.15176], [-118.16717, 34.15215], [-118.16734, 34.15239], [-118.1675, 34.15258], [-118.16768, 34.15276], [-118.16788, 34.15294], [-118.16869, 34.15351]]]} | Open Access 1 | Brookside Park | http://www.cityofpasadena.net/PublicWorks/Brookside_Park1/ | 16431 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 94.225 | Brookside Park | |
12106 | 12106 | 12105 | {"type": "Polygon", "coordinates": [[[-118.16393, 34.16098], [-118.16379, 34.16061], [-118.16342, 34.15865], [-118.16335, 34.15813], [-118.16386, 34.15794], [-118.16423, 34.15776], [-118.16566, 34.15687], [-118.16598, 34.15672], [-118.16632, 34.15661], [-118.16677, 34.15651], [-118.16715, 34.15641], [-118.16734, 34.15642], [-118.16744, 34.15645], [-118.16752, 34.1565], [-118.1676, 34.15659], [-118.16774, 34.15703], [-118.16775, 34.15721], [-118.16774, 34.15747], [-118.16767, 34.15782], [-118.16758, 34.15807], [-118.16741, 34.1584], [-118.16725, 34.15863], [-118.16712, 34.15877], [-118.16692, 34.15897], [-118.16652, 34.15927], [-118.16623, 34.15943], [-118.16566, 34.15966], [-118.16538, 34.15979], [-118.1652, 34.15989], [-118.16452, 34.16034], [-118.16429, 34.16053], [-118.16407, 34.16079], [-118.16393, 34.16098]]]} | Open Access 1 | Brookside Park Area H | 29050 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 27.409 | Brookside Park Area H | ||
3516 | 3516 | 3515 | {"type": "Polygon", "coordinates": [[[-118.16289, 34.14526], [-118.16276, 34.14539], [-118.16263, 34.14547], [-118.16238, 34.14558], [-118.16208, 34.14564], [-118.16161, 34.14564], [-118.16083, 34.1456], [-118.16078, 34.14558], [-118.1607, 34.14534], [-118.1613, 34.14533], [-118.16131, 34.14531], [-118.16126, 34.14517], [-118.16176, 34.14517], [-118.16186, 34.14542], [-118.16205, 34.14541], [-118.16201, 34.14527], [-118.16289, 34.14526]]]} | Open Access 1 | Defenders Park | 18012 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1.669 | Defenders Park | ||
3819 | 3819 | 3818 | {"type": "Polygon", "coordinates": [[[-118.08707, 34.14127], [-118.08706, 34.1421], [-118.08635, 34.14211], [-118.08635, 34.14204], [-118.08628, 34.14203], [-118.08607, 34.14179], [-118.08603, 34.14173], [-118.08594, 34.14163], [-118.08453, 34.14025], [-118.08436, 34.14002], [-118.08426, 34.13981], [-118.08387, 34.13867], [-118.08386, 34.13849], [-118.08413, 34.13849], [-118.08414, 34.1389], [-118.08447, 34.1389], [-118.08445, 34.13992], [-118.08449, 34.14005], [-118.08458, 34.14016], [-118.0847, 34.14024], [-118.08486, 34.14028], [-118.08596, 34.14027], [-118.08595, 34.14115], [-118.0861, 34.14128], [-118.08707, 34.14127]]]} | Open Access 1 | Eaton Blanche Park | http://www.cityofpasadena.net/PublicWorks/Eaton_Blanche_Park/ | 18406 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 5.79 | Eaton Blanche Park | |
12108 | 12108 | 12107 | {"type": "Polygon", "coordinates": [[[-118.08915, 34.15862], [-118.08915, 34.15932], [-118.08913, 34.15934], [-118.0891, 34.15936], [-118.08827, 34.15937], [-118.08808, 34.159], [-118.08793, 34.15862], [-118.08911, 34.15861], [-118.08915, 34.15862]]]} | Open Access 1 | Eaton Sunnyslope Park | http://www.cityofpasadena.net/PublicWorks/Eaton_Sunnyslope_Park/ | 29051 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 2.002 | Eaton Sunnyslope Park | |
4700 | 4700 | 4699 | {"type": "Polygon", "coordinates": [[[-118.12585, 34.14252], [-118.1246, 34.14252], [-118.12459, 34.14175], [-118.12584, 34.14174], [-118.12585, 34.14252]]]} | Open Access 1 | Grant Park | 19439 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 2.458 | Grant Park | ||
12109 | 12109 | 12108 | {"type": "Polygon", "coordinates": [[[-118.08917, 34.15766], [-118.08916, 34.15835], [-118.08914, 34.15838], [-118.08786, 34.15841], [-118.08776, 34.15803], [-118.08769, 34.15766], [-118.08912, 34.15764], [-118.08917, 34.15766]]]} | Open Access 1 | Gwinn Park | http://www.cityofpasadena.net/PublicWorks/Gwinn_Park/ | 29052 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 2.632 | Gwinn Park | |
829 | 829 | 828 | {"type": "Polygon", "coordinates": [[[-118.17822, 34.18964], [-118.17819, 34.19263], [-118.17815, 34.193], [-118.17806, 34.19331], [-118.17775, 34.194], [-118.17757, 34.19423], [-118.17747, 34.1946], [-118.17741, 34.19469], [-118.17729, 34.19479], [-118.17719, 34.19492], [-118.17706, 34.19502], [-118.177, 34.19509], [-118.17696, 34.19517], [-118.17693, 34.19538], [-118.1769, 34.19549], [-118.17674, 34.19575], [-118.17662, 34.19598], [-118.17654, 34.19608], [-118.17642, 34.19615], [-118.17622, 34.19631], [-118.17601, 34.19645], [-118.1759, 34.19658], [-118.17584, 34.19671], [-118.17584, 34.19695], [-118.17579, 34.19709], [-118.17519, 34.19783], [-118.17511, 34.19796], [-118.17507, 34.19812], [-118.17504, 34.19844], [-118.17312, 34.19845], [-118.17367, 34.19703], [-118.17209, 34.19702], [-118.17208, 34.197], [-118.17202, 34.197], [-118.16906, 34.19982], [-118.16779, 34.20095], [-118.16663, 34.20311], [-118.16533, 34.2031], [-118.16511, 34.20252], [-118.16483, 34.2027], [-118.16472, 34.20273], [-118.16473, 34.20269], [-118.16439, 34.20224], [-118.16431, 34.20209], [-118.16426, 34.20177], [-118.16427, 34.20147], [-118.16398, 34.20148], [-118.16491, 34.20016], [-118.16581, 34.19797], [-118.16694, 34.19597], [-118.16718, 34.19568], [-118.16742, 34.1953], [-118.16788, 34.19437], [-118.1679, 34.19424], [-118.16802, 34.19402], [-118.16817, 34.19405], [-118.16841, 34.19353], [-118.16849, 34.19329], [-118.16854, 34.19304], [-118.16856, 34.19258], [-118.16924, 34.19263], [-118.16937, 34.19244], [-118.16936, 34.19242], [-118.1693, 34.19242], [-118.16975, 34.19217], [-118.17023, 34.19159], [-118.17052, 34.19113], [-118.17061, 34.19012], [-118.17151, 34.18957], [-118.17184, 34.18911], [-118.17208, 34.18782], [-118.17289, 34.18645], [-118.17297, 34.18521], [-118.17253, 34.18359], [-118.17272, 34.18369], [-118.17294, 34.18366], [-118.17316, 34.18346], [-118.1749, 34.1842], [-118.17501, 34.18429], [-118.17509, 34.18438], [-118.17517, 34.18452], [-118.17533, 34.18511], [-118.17554, 34.18545], [-118.17566, 34.18584], [-118.17571, 34.18583], [-118.17587, 34.18584], [-118.17603, 34.18584], [-118.17642, 34.18578], [-118.1766, 34.1858], [-118.17707, 34.186], [-118.17769, 34.18616], [-118.17797, 34.18638], [-118.17824, 34.18664], [-118.17847, 34.18693], [-118.17863, 34.18722], [-118.17873, 34.18752], [-118.17876, 34.18784], [-118.17874, 34.18809], [-118.17866, 34.18836], [-118.17858, 34.18854], [-118.17839, 34.18887], [-118.17828, 34.18915], [-118.17821, 34.18946], [-118.1782, 34.18962], [-118.17822, 34.18964]]]} | Open Access 1 | Hahamongna Watershed Park | http://cityofpasadena.net/PublicWorks/hahamongna/ | 8427 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 303.407 | Hahamongna Watershed Park | |
4856 | 4856 | 4855 | {"type": "Polygon", "coordinates": [[[-118.07621, 34.16419], [-118.07389, 34.1642], [-118.07385, 34.16196], [-118.07616, 34.16193], [-118.07621, 34.16419]]]} | Open Access 1 | Hamilton Park | 19620 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 13.14 | Hamilton Park | ||
12129 | 12129 | 12128 | {"type": "Polygon", "coordinates": [[[-118.14136, 34.15891], [-118.14137, 34.15954], [-118.14136, 34.15957], [-118.14132, 34.15958], [-118.14069, 34.15958], [-118.14069, 34.15892], [-118.14136, 34.15891]]]} | Restricted Access 2 | James Madison Park | http://pasadenacsp.org/pcsp/site/joint_use/ | 29094 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1.13 | James Madison Park | |
5507 | 5507 | 5506 | {"type": "Polygon", "coordinates": [[[-118.1198, 34.15534], [-118.11782, 34.15535], [-118.11782, 34.15446], [-118.1198, 34.15446], [-118.1198, 34.15534]]]} | Open Access 1 | Jefferson Park | 20381 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 4.41 | Jefferson Park | ||
5828 | 5828 | 5827 | {"type": "Polygon", "coordinates": [[[-118.15055, 34.17015], [-118.14969, 34.17015], [-118.14969, 34.17057], [-118.14924, 34.17058], [-118.14923, 34.16897], [-118.15054, 34.16896], [-118.15055, 34.17015]]]} | Open Access 1 | La Pintoresca Park | 20787 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 4.406 | La Pintoresca Park | ||
769 | 769 | 768 | {"type": "Polygon", "coordinates": [[[-118.09817, 34.14384], [-118.09793, 34.14384], [-118.09794, 34.1433], [-118.09816, 34.1433], [-118.09817, 34.14384]]]} | Open Access 1 | Lamada Pocket Park | 32702 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 0.313 | Lamada PP | ||
12130 | 12130 | 12129 | {"type": "Polygon", "coordinates": [[[-118.17896, 34.16949], [-118.17802, 34.16949], [-118.17797, 34.1694], [-118.17765, 34.1694], [-118.17764, 34.16937], [-118.17745, 34.16924], [-118.17731, 34.1689], [-118.17725, 34.16889], [-118.17724, 34.16868], [-118.17682, 34.16868], [-118.17682, 34.1686], [-118.1774, 34.1686], [-118.17741, 34.16854], [-118.17892, 34.16941], [-118.17896, 34.16949]]]} | Restricted Access 2 | Linda Vista Park | http://www.lvaa.net/linda-vista-park.html | 29095 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 2.015 | Linda Vista Park | |
6438 | 6438 | 6437 | {"type": "Polygon", "coordinates": [[[-118.16985, 34.14278], [-118.16959, 34.14308], [-118.1692, 34.14334], [-118.16812, 34.14389], [-118.16797, 34.14398], [-118.16783, 34.14409], [-118.16766, 34.14428], [-118.16757, 34.14447], [-118.16748, 34.14453], [-118.16747, 34.14456], [-118.16744, 34.14456], [-118.16743, 34.14473], [-118.16701, 34.14491], [-118.16598, 34.14528], [-118.16486, 34.14554], [-118.16403, 34.14571], [-118.16402, 34.14556], [-118.16404, 34.14544], [-118.1641, 34.1453], [-118.16419, 34.14519], [-118.16428, 34.14512], [-118.16515, 34.14459], [-118.16533, 34.14444], [-118.16541, 34.14433], [-118.16551, 34.14411], [-118.16558, 34.14335], [-118.1656, 34.14328], [-118.16613, 34.1424], [-118.16615, 34.14233], [-118.16613, 34.14214], [-118.16591, 34.14174], [-118.16589, 34.14167], [-118.16589, 34.14157], [-118.16591, 34.14151], [-118.16606, 34.14124], [-118.16607, 34.14115], [-118.16607, 34.14105], [-118.1656, 34.13996], [-118.16556, 34.13981], [-118.16569, 34.13877], [-118.16576, 34.13856], [-118.16585, 34.13845], [-118.166, 34.13833], [-118.16666, 34.13793], [-118.16679, 34.13779], [-118.16682, 34.13771], [-118.16684, 34.13761], [-118.16684, 34.13751], [-118.16682, 34.13742], [-118.16671, 34.13726], [-118.16659, 34.13716], [-118.1661, 34.13689], [-118.16602, 34.13681], [-118.16598, 34.13671], [-118.16598, 34.13664], [-118.16611, 34.13577], [-118.16644, 34.13491], [-118.16646, 34.13481], [-118.16646, 34.13471], [-118.16642, 34.13456], [-118.16634, 34.13443], [-118.16626, 34.13433], [-118.16578, 34.13391], [-118.16573, 34.13382], [-118.16581, 34.13304], [-118.16564, 34.13214], [-118.16555, 34.1319], [-118.16536, 34.1316], [-118.16529, 34.13139], [-118.1653, 34.13116], [-118.16542, 34.1307], [-118.16542, 34.13059], [-118.1654, 34.1305], [-118.16534, 34.13039], [-118.16527, 34.1303], [-118.16518, 34.13022], [-118.16506, 34.13016], [-118.16483, 34.13011], [-118.16456, 34.13012], [-118.16442, 34.13011], [-118.16424, 34.13006], [-118.16409, 34.12997], [-118.16398, 34.12986], [-118.1639, 34.12972], [-118.16384, 34.12955], [-118.16381, 34.12933], [-118.16382, 34.12903], [-118.16402, 34.12903], [-118.16405, 34.12891], [-118.16437, 34.12886], [-118.16506, 34.12835], [-118.16531, 34.12795], [-118.16536, 34.12778], [-118.16532, 34.12752], [-118.16499, 34.12685], [-118.16502, 34.12674], [-118.16504, 34.12646], [-118.16507, 34.12645], [-118.16507, 34.12641], [-118.16505, 34.12638], [-118.1651, 34.12619], [-118.16509, 34.12614], [-118.16505, 34.12609], [-118.16513, 34.12588], [-118.16507, 34.12587], [-118.16504, 34.12581], [-118.16462, 34.12585], [-118.16484, 34.12532], [-118.16506, 34.12514], [-118.16515, 34.12512], [-118.16525, 34.12517], [-118.16543, 34.12545], [-118.16553, 34.12538], [-118.16545, 34.12525], [-118.16538, 34.12509], [-118.16537, 34.12497], [-118.1654, 34.1248], [-118.16542, 34.12479], [-118.16544, 34.12471], [-118.16553, 34.12461], [-118.16584, 34.12415], [-118.16596, 34.12389], [-118.16846, 34.12391], [-118.16826, 34.1243], [-118.16759, 34.12497], [-118.16575, 34.12557], [-118.16552, 34.12605], [-118.16541, 34.12683], [-118.16549, 34.12767], [-118.16552, 34.12776], [-118.16564, 34.128], [-118.16585, 34.12801], [-118.16587, 34.12805], [-118.16585, 34.12836], [-118.16604, 34.12835], [-118.16616, 34.12892], [-118.16595, 34.12897], [-118.16595, 34.12898], [-118.16624, 34.12913], [-118.16639, 34.13092], [-118.16639, 34.13094], [-118.16636, 34.13097], [-118.16666, 34.13196], [-118.16705, 34.13273], [-118.1671, 34.13311], [-118.16706, 34.1333], [-118.16754, 34.1338], [-118.16754, 34.13383], [-118.16723, 34.13398], [-118.16713, 34.13413], [-118.16715, 34.13414], [-118.16721, 34.13412], [-118.16724, 34.13413], [-118.16755, 34.13429], [-118.16762, 34.13446], [-118.16768, 34.13452], [-118.16767, 34.13509], [-118.16837, 34.1355], [-118.16855, 34.13571], [-118.16872, 34.13602], [-118.16884, 34.13655], [-118.16889, 34.13656], [-118.16891, 34.13668], [-118.16838, 34.13746], [-118.169, 34.13787], [-118.16919, 34.13784], [-118.16922, 34.13785], [-118.16876, 34.13917], [-118.16873, 34.13919], [-118.16877, 34.13966], [-118.1689, 34.13966], [-118.16894, 34.14009], [-118.16861, 34.14034], [-118.16919, 34.14068], [-118.16966, 34.14199], [-118.16984, 34.14255], [-118.16985, 34.14278]]]} | Open Access 1 | Lower Arroyo Seco | 21558 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 112.452 | Lower Arroyo Seco |
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]);