superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where MNG_AGENCY = 381 and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1568 | 1568 | 1567 | {"type": "Polygon", "coordinates": [[[-122.29323, 37.92431], [-122.2932, 37.92437], [-122.29295, 37.92449], [-122.2925, 37.9246], [-122.29227, 37.92471], [-122.2922, 37.92469], [-122.29195, 37.92447], [-122.29205, 37.92438], [-122.29196, 37.92429], [-122.29188, 37.92414], [-122.29177, 37.92322], [-122.29167, 37.92295], [-122.29239, 37.92207], [-122.29245, 37.92216], [-122.29273, 37.92334], [-122.29277, 37.92369], [-122.29285, 37.92384], [-122.29323, 37.92431]]]} | Open Access 1 | Arlington Park | 15589 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 5.136 | Arlington Park | ||
2603 | 2603 | 2602 | {"type": "Polygon", "coordinates": [[[-122.31752, 37.93106], [-122.31741, 37.9313], [-122.31724, 37.93131], [-122.31721, 37.9316], [-122.31618, 37.93161], [-122.31548, 37.93126], [-122.31551, 37.9312], [-122.31497, 37.93091], [-122.31319, 37.93089], [-122.31322, 37.93019], [-122.31357, 37.93018], [-122.31365, 37.93011], [-122.31363, 37.93003], [-122.31369, 37.93001], [-122.31497, 37.93025], [-122.31541, 37.93027], [-122.31554, 37.9303], [-122.31577, 37.93045], [-122.31578, 37.93047], [-122.31611, 37.93057], [-122.31603, 37.93092], [-122.31635, 37.93091], [-122.31646, 37.93065], [-122.31674, 37.93071], [-122.31675, 37.93073], [-122.31694, 37.93076], [-122.31711, 37.93073], [-122.31712, 37.93078], [-122.31713, 37.93079], [-122.31719, 37.93093], [-122.31752, 37.93093], [-122.31751, 37.93095], [-122.31752, 37.93106]]]} | Open Access 1 | Canyon Trail Park | 16826 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 8.106 | Canyon Trail Park | 1964 | |
2698 | 2698 | 2697 | {"type": "Polygon", "coordinates": [[[-122.3081, 37.92135], [-122.3073, 37.92174], [-122.30696, 37.92206], [-122.30666, 37.92159], [-122.30593, 37.92205], [-122.30545, 37.92149], [-122.30752, 37.92061], [-122.3081, 37.92135]]]} | Open Access 1 | Castro Park | 16962 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 4.513 | Castro Park | ||
2801 | 2801 | 2800 | {"type": "Polygon", "coordinates": [[[-122.30138, 37.91432], [-122.30125, 37.91438], [-122.30128, 37.91442], [-122.29927, 37.91532], [-122.29901, 37.91494], [-122.29897, 37.91484], [-122.29895, 37.91468], [-122.29911, 37.91372], [-122.29911, 37.91367], [-122.29984, 37.9133], [-122.29994, 37.9134], [-122.3005, 37.91313], [-122.30082, 37.91352], [-122.30138, 37.91432]]]} | Open Access 1 | Cerrito Vista Park | 17085 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 7.737 | Cerrito Vista Park | ||
3298 | 3298 | 3297 | {"type": "Polygon", "coordinates": [[[-122.30582, 37.89839], [-122.30562, 37.89844], [-122.30548, 37.89817], [-122.30534, 37.89823], [-122.30547, 37.89852], [-122.30514, 37.89862], [-122.3051, 37.89856], [-122.30479, 37.89865], [-122.30463, 37.89833], [-122.30447, 37.89835], [-122.30453, 37.8985], [-122.30421, 37.8986], [-122.3041, 37.89837], [-122.30218, 37.89852], [-122.30565, 37.89813], [-122.30582, 37.89839]]]} | Open Access 1 | Creekside Park | 17774 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 1.252 | Creekside Park | ||
3894 | 3894 | 3893 | {"type": "Polygon", "coordinates": [[[-122.30377, 37.91511], [-122.30305, 37.91543], [-122.30218, 37.9142], [-122.3029, 37.91388], [-122.30377, 37.91511]]]} | Open Access 1 | El Cerrito Community Swim Center | 18491 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 2.791 | El Cerrito Community Swim Ctr. | ||
4140 | 4140 | 4139 | {"type": "Polygon", "coordinates": [[[-122.3044, 37.90705], [-122.30365, 37.90729], [-122.30392, 37.90777], [-122.30339, 37.90802], [-122.30246, 37.90693], [-122.30352, 37.90671], [-122.30415, 37.90651], [-122.3044, 37.90705]]]} | Open Access 1 | Fairmont Park | 18805 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 3.368 | Fairmont Park | ||
4906 | 4906 | 4905 | {"type": "Polygon", "coordinates": [[[-122.29474, 37.902], [-122.29467, 37.90212], [-122.29448, 37.90213], [-122.29387, 37.90201], [-122.29352, 37.9021], [-122.29336, 37.90153], [-122.29384, 37.9014], [-122.29392, 37.90156], [-122.29424, 37.90146], [-122.29453, 37.90154], [-122.29474, 37.902]]]} | Open Access 1 | Harding Park | 19675 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 1.731 | Harding Park | ||
5281 | 5281 | 5280 | {"type": "Polygon", "coordinates": [[[-122.292, 37.9136], [-122.29092, 37.91405], [-122.29037, 37.91401], [-122.29021, 37.91331], [-122.29022, 37.91327], [-122.29176, 37.91321], [-122.29177, 37.9133], [-122.2918, 37.91336], [-122.29196, 37.91353], [-122.292, 37.9136]]]} | Open Access 1 | Huber Park | 20129 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 2.616 | Huber Park | ||
7640 | 7640 | 7639 | {"type": "MultiPolygon", "coordinates": [[[[-122.32063, 37.92983], [-122.32036, 37.92995], [-122.32026, 37.92983], [-122.32053, 37.92971], [-122.32063, 37.92983]]], [[[-122.32244, 37.93127], [-122.32199, 37.93111], [-122.3219, 37.9311], [-122.32154, 37.93093], [-122.32135, 37.93082], [-122.321, 37.93058], [-122.32082, 37.93044], [-122.32049, 37.93012], [-122.32077, 37.92999], [-122.32096, 37.93018], [-122.32123, 37.93041], [-122.32137, 37.93051], [-122.32173, 37.93073], [-122.32199, 37.93063], [-122.32244, 37.93127]]]]} | Open Access 1 | Ohlone Greenway Park | 23075 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 1.524 | Ohlone Greenway Park | ||
8267 | 8267 | 8266 | {"type": "Polygon", "coordinates": [[[-122.31825, 37.93462], [-122.31775, 37.93493], [-122.31735, 37.93528], [-122.31679, 37.93568], [-122.31669, 37.93567], [-122.31663, 37.93573], [-122.31651, 37.9357], [-122.31796, 37.93444], [-122.31825, 37.93462]]]} | Open Access 1 | Poinsett Park | 23842 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 1.027 | Poinsett Park | ||
10234 | 10234 | 10233 | {"type": "Polygon", "coordinates": [[[-122.31185, 37.93633], [-122.31125, 37.93641], [-122.31076, 37.93581], [-122.31056, 37.93571], [-122.30979, 37.93541], [-122.30973, 37.93533], [-122.30977, 37.93525], [-122.31041, 37.93481], [-122.31113, 37.93536], [-122.31099, 37.93555], [-122.31097, 37.93567], [-122.31117, 37.93578], [-122.31134, 37.9359], [-122.31171, 37.93588], [-122.31185, 37.93633]]]} | Open Access 1 | Tassajara Park | 26195 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 2.857 | Tassajara Park | ||
13738 | 13738 | 13737 | {"type": "MultiPolygon", "coordinates": [[[[-122.30443, 37.92294], [-122.30401, 37.92314], [-122.30408, 37.92332], [-122.30401, 37.92354], [-122.30422, 37.92384], [-122.30247, 37.92464], [-122.30207, 37.92436], [-122.29972, 37.92585], [-122.3003, 37.92643], [-122.30156, 37.92608], [-122.30179, 37.92649], [-122.30193, 37.92651], [-122.30197, 37.92655], [-122.30199, 37.92659], [-122.30194, 37.92675], [-122.30195, 37.92719], [-122.30192, 37.92724], [-122.30201, 37.92728], [-122.30199, 37.92735], [-122.30192, 37.92735], [-122.30199, 37.92757], [-122.3016, 37.92767], [-122.30092, 37.9272], [-122.29991, 37.92708], [-122.29989, 37.92711], [-122.29946, 37.92729], [-122.2987, 37.9265], [-122.29972, 37.92585], [-122.30015, 37.92458], [-122.29997, 37.92377], [-122.30023, 37.92358], [-122.30107, 37.92361], [-122.30108, 37.92359], [-122.29998, 37.92276], [-122.29934, 37.92321], [-122.29848, 37.92338], [-122.29801, 37.92345], [-122.29781, 37.92284], [-122.29932, 37.92216], [-122.29933, 37.92214], [-122.29867, 37.92156], [-122.298, 37.92088], [-122.29768, 37.92058], [-122.29676, 37.91987], [-122.29594, 37.91938], [-122.29536, 37.91863], [-122.29542, 37.91858], [-122.29552, 37.91835], [-122.29563, 37.91824], [-122.29574, 37.91818], [-122.29619, 37.91812], [-122.29637, 37.91811], [-122.29638, 37.91809], [-122.29634, 37.91803], [-122.29794, 37.91777], [-122.29863, 37.91746], [-122.29869, 37.91752], [-122.29902, 37.91746], [-122.29963, 37.91832], [-122.29917, 37.91854], [-122.29951, 37.91903], [-122.30079, 37.91847], [-122.30149, 37.91962], [-122.30235, 37.92081], [-122.30159, 37.92117], [-122.30263, 37.92258], [-122.30271, 37.92319], [-122.30339, 37.92374], [-122.30374, 37.92357], [-122.30372, 37.92316], [-122.3039, 37.92289], [-122.30419, 37.92257], [-122.30429, 37.92269], [-122.30428, 37.92274], [-122.30443, 37.92294]]], [[[-122.30876, 37.92785], [-122.30587, 37.9279], [-122.30563, 37.92705], [-122.30492, 37.92648], [-122.30388, 37.92684], [-122.30325, 37.92733], [-122.30314, 37.92724], [-122.30278, 37.92747], [-122.30275, 37.92743], [-122.30309, 37.92721], [-122.30305, 37.92694], [-122.30313, 37.92679], [-122.30358, 37.92614], [-122.30399, 37.92576], [-122.30447, 37.9261], [-122.30716, 37.9249], [-122.30746, 37.92531], [-122.30777, 37.92516], [-122.30746, 37.92476], [-122.30747, 37.92476], [-122.30779, 37.92516], [-122.30782, 37.92571], [-122.30837, 37.92574], [-122.30839, 37.9258], [-122.3081, 37.92595], [-122.3081, 37.92597], [-122.30829, 37.92621], [-122.30868, 37.92621], [-122.30876, 37.92785]]]]} | Open Access 1 | Hillside Natural Area | http://www.el-cerrito.org/index.aspx?NID=812 | 31244 | 1094 | El Cerrito, City of 381 | City 2 | City Agency 2 | http://www.el-cerrito.org/ | City 2 | 99.015 | Hillside Natural Area |
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]);