superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 349 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9396 | 9396 | 9395 | {"type": "Polygon", "coordinates": [[[-122.49669, 37.96715], [-122.49667, 37.96721], [-122.49592, 37.96699], [-122.49597, 37.96691], [-122.49669, 37.96715]]]} | Open Access 1 | Schoen Park | 25188 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 0.144 | Schoen Park | ||
4151 | 4151 | 4150 | {"type": "Polygon", "coordinates": [[[-122.55648, 38.01214], [-122.55599, 38.01179], [-122.55595, 38.01168], [-122.55606, 38.01156], [-122.55608, 38.0116], [-122.5563, 38.01176], [-122.55648, 38.01214]]]} | Open Access 1 | Hillview Park | 19995 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 0.256 | Hillview Park | ||
8810 | 8810 | 8809 | {"type": "Polygon", "coordinates": [[[-122.46007, 37.99457], [-122.46004, 37.9947], [-122.46, 37.99476], [-122.45989, 37.9948], [-122.45967, 37.9948], [-122.45971, 37.99448], [-122.45998, 37.99449], [-122.46004, 37.99451], [-122.46007, 37.99457]]]} | Open Access 1 | Riviera Park | 24470 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 0.26 | Riviera Park | ||
1539 | 1539 | 1538 | {"type": "Polygon", "coordinates": [[[-122.5502, 38.00939], [-122.55012, 38.00945], [-122.54982, 38.00947], [-122.54931, 38.0094], [-122.54916, 38.0094], [-122.54923, 38.00917], [-122.54928, 38.00921], [-122.5497, 38.00926], [-122.5502, 38.00939]]]} | Open Access 1 | Arbor Park | 15558 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 0.39 | Arbor Park | ||
7684 | 7684 | 7683 | {"type": "Polygon", "coordinates": [[[-122.54385, 37.99802], [-122.5434, 37.99805], [-122.5434, 37.99818], [-122.54339, 37.9982], [-122.54319, 37.99824], [-122.54311, 37.99821], [-122.54296, 37.99806], [-122.54319, 37.9979], [-122.54332, 37.99776], [-122.54385, 37.99802]]]} | Open Access 1 | Oliver Hartzell Park | 23135 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 0.445 | Oliver Hartzell Park | ||
1544 | 1544 | 1543 | {"type": "Polygon", "coordinates": [[[-122.521, 37.95815], [-122.52092, 37.95822], [-122.52034, 37.95778], [-122.52075, 37.95756], [-122.521, 37.95815]]]} | Open Access 1 | Bret Harte Park | 16367 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 0.446 | Bret Harte Park | ||
7279 | 7279 | 7278 | {"type": "Polygon", "coordinates": [[[-122.55487, 38.01144], [-122.55481, 38.01151], [-122.5546, 38.01138], [-122.554, 38.01106], [-122.55359, 38.01089], [-122.55277, 38.01068], [-122.55267, 38.01072], [-122.55259, 38.01097], [-122.55234, 38.01092], [-122.55234, 38.01067], [-122.55227, 38.01044], [-122.55214, 38.01025], [-122.55207, 38.01018], [-122.55213, 38.01009], [-122.55419, 38.01106], [-122.55487, 38.01144]]]} | Open Access 1 | Munson Park | 22600 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1.461 | Munson Park | ||
10070 | 10070 | 10069 | {"type": "Polygon", "coordinates": [[[-122.54553, 37.98269], [-122.54484, 37.98336], [-122.54403, 37.98282], [-122.54483, 37.98213], [-122.54515, 37.98242], [-122.54553, 37.98269]]]} | Open Access 1 | Sun Valley Park | 25980 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 2.186 | Sun Valley Park | ||
6501 | 6501 | 6500 | {"type": "Polygon", "coordinates": [[[-122.54738, 38.01028], [-122.54739, 38.0108], [-122.54735, 38.01093], [-122.54723, 38.01115], [-122.54687, 38.01101], [-122.54632, 38.01093], [-122.54627, 38.01071], [-122.54612, 38.01056], [-122.54633, 38.0103], [-122.54635, 38.01007], [-122.54658, 38.00996], [-122.54738, 38.01028]]]} | Open Access 1 | Oleander Park | 23115 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 2.457 | Oleander Park | ||
6422 | 6422 | 6421 | {"type": "Polygon", "coordinates": [[[-122.53664, 37.99347], [-122.53657, 37.99396], [-122.53654, 37.99405], [-122.53648, 37.99414], [-122.53634, 37.99425], [-122.53551, 37.99472], [-122.53509, 37.99415], [-122.53543, 37.99399], [-122.53533, 37.99383], [-122.53555, 37.99361], [-122.53559, 37.99349], [-122.53567, 37.99339], [-122.53664, 37.99347]]]} | Open Access 1 | Los Ranchitos Park | 21530 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 3.0 | Los Ranchitos Park | ||
6632 | 6632 | 6631 | {"type": "Polygon", "coordinates": [[[-122.55746, 38.0049], [-122.55744, 38.00514], [-122.55741, 38.00531], [-122.55734, 38.00551], [-122.55725, 38.0057], [-122.55712, 38.0059], [-122.55697, 38.00608], [-122.55683, 38.00621], [-122.55656, 38.00661], [-122.55645, 38.00653], [-122.55555, 38.00624], [-122.55585, 38.00587], [-122.55595, 38.00587], [-122.55606, 38.00583], [-122.55746, 38.0049]]]} | Open Access 1 | Maria B. Freitas Park | 21809 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 3.128 | Maria B. Freitas Park | ||
15256 | 15256 | 15255 | {"type": "Polygon", "coordinates": [[[-122.56119, 38.01484], [-122.56081, 38.01574], [-122.56009, 38.01556], [-122.56001, 38.01559], [-122.55991, 38.01583], [-122.55985, 38.01581], [-122.55994, 38.01559], [-122.55995, 38.01537], [-122.55993, 38.01522], [-122.55987, 38.01508], [-122.55978, 38.01495], [-122.55961, 38.01478], [-122.55945, 38.01469], [-122.5593, 38.01462], [-122.55952, 38.01435], [-122.55967, 38.01442], [-122.55997, 38.01452], [-122.56119, 38.01484]]]} | Open Access 1 | Terra Linda Recreation Center | 26254 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 3.197 | Terra Linda Rec. Ctr. | ||
1853 | 1853 | 1852 | {"type": "Polygon", "coordinates": [[[-122.51876, 37.96858], [-122.5186, 37.96924], [-122.51825, 37.96918], [-122.5183, 37.9689], [-122.51767, 37.96879], [-122.51757, 37.96906], [-122.5165, 37.96887], [-122.51706, 37.9669], [-122.51742, 37.9671], [-122.51727, 37.96713], [-122.5172, 37.9672], [-122.51697, 37.96809], [-122.51697, 37.96813], [-122.51701, 37.96818], [-122.51708, 37.96822], [-122.51876, 37.96858]]]} | Open Access 1 | Beach Park | 15908 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 3.941 | Beach Park | ||
10856 | 10856 | 10855 | {"type": "Polygon", "coordinates": [[[-122.48506, 37.9904], [-122.4847, 37.99067], [-122.48418, 37.99068], [-122.48346, 37.99005], [-122.48384, 37.98964], [-122.48353, 37.9895], [-122.48355, 37.98939], [-122.48354, 37.98924], [-122.48342, 37.98896], [-122.48372, 37.98885], [-122.48354, 37.98849], [-122.48355, 37.98837], [-122.48362, 37.98813], [-122.48373, 37.98792], [-122.48389, 37.9875], [-122.48387, 37.98735], [-122.48391, 37.98727], [-122.4844, 37.9874], [-122.48457, 37.98747], [-122.48472, 37.98756], [-122.48431, 37.98794], [-122.48418, 37.98812], [-122.48408, 37.98831], [-122.48404, 37.98846], [-122.48403, 37.98856], [-122.48404, 37.98876], [-122.48409, 37.98896], [-122.48418, 37.98914], [-122.48477, 37.99007], [-122.48485, 37.99019], [-122.48506, 37.9904]]]} | Open Access 1 | Victor Jones Park | 27070 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 5.995 | Victor Jones Park | ||
9221 | 9221 | 9220 | {"type": "Polygon", "coordinates": [[[-122.57743, 38.0188], [-122.57718, 38.0189], [-122.57672, 38.01915], [-122.57711, 38.01956], [-122.57686, 38.01978], [-122.57647, 38.01976], [-122.57628, 38.01931], [-122.5762, 38.019], [-122.57568, 38.01907], [-122.57551, 38.01907], [-122.57558, 38.01855], [-122.57545, 38.01839], [-122.57639, 38.01757], [-122.5772, 38.01793], [-122.57743, 38.0188]]]} | Open Access 1 | San Margarita Park | 24946 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 6.039 | San Margarita Park | ||
4551 | 4551 | 4550 | {"type": "Polygon", "coordinates": [[[-122.53788, 37.96488], [-122.53788, 37.96491], [-122.53737, 37.96486], [-122.53734, 37.965], [-122.53728, 37.9654], [-122.53779, 37.96546], [-122.53766, 37.96625], [-122.5356, 37.96604], [-122.53582, 37.96468], [-122.53788, 37.96488]]]} | Open Access 1 | Gerstle Park | 19279 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 6.207 | Gerstle Park | ||
9248 | 9248 | 9247 | {"type": "Polygon", "coordinates": [[[-122.49481, 37.97153], [-122.49427, 37.97171], [-122.49413, 37.9716], [-122.49395, 37.97156], [-122.49337, 37.97157], [-122.4926, 37.97154], [-122.49248, 37.97178], [-122.49233, 37.97172], [-122.49225, 37.97153], [-122.49237, 37.97151], [-122.49246, 37.97112], [-122.49244, 37.97089], [-122.49247, 37.97074], [-122.49271, 37.97044], [-122.49287, 37.97014], [-122.4932, 37.97024], [-122.49479, 37.97084], [-122.49481, 37.97153]]]} | Open Access 1 | San Rafael Lands 008 | 24979 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 6.404 | San Rafael Lands 008 | ||
8042 | 8042 | 8041 | {"type": "Polygon", "coordinates": [[[-122.47354, 37.99367], [-122.47315, 37.99433], [-122.47294, 37.99495], [-122.4727, 37.99491], [-122.47252, 37.99493], [-122.47236, 37.99499], [-122.47216, 37.99511], [-122.47201, 37.99497], [-122.47125, 37.99471], [-122.47133, 37.99452], [-122.4714, 37.99429], [-122.47145, 37.99406], [-122.47147, 37.99364], [-122.4715, 37.99347], [-122.47157, 37.99329], [-122.47169, 37.99312], [-122.47223, 37.99324], [-122.47222, 37.99328], [-122.47224, 37.99334], [-122.47228, 37.99339], [-122.47235, 37.99342], [-122.47243, 37.99342], [-122.4725, 37.99339], [-122.47255, 37.99335], [-122.47257, 37.99331], [-122.47298, 37.99336], [-122.47354, 37.99367]]]} | Open Access 1 | Peacock Gap Neighborhood Park | 23544 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 7.115 | Peacock Gap Neighborhood Park | ||
13517 | 13517 | 13516 | {"type": "Polygon", "coordinates": [[[-122.49889, 37.96947], [-122.49879, 37.96966], [-122.49802, 37.97002], [-122.49766, 37.97016], [-122.49731, 37.97028], [-122.49713, 37.97033], [-122.49695, 37.97036], [-122.49659, 37.97038], [-122.49622, 37.97037], [-122.49578, 37.9703], [-122.49568, 37.97019], [-122.49615, 37.96878], [-122.4984, 37.96946], [-122.49886, 37.96944], [-122.49889, 37.96947]]]} | Open Access 1 | Unnamed site - San Rafael, City of | 32671 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 7.23 | |||
7838 | 7838 | 7837 | {"type": "Polygon", "coordinates": [[[-122.55036, 37.97204], [-122.55036, 37.97278], [-122.54993, 37.9729], [-122.54972, 37.97325], [-122.54989, 37.97359], [-122.55013, 37.97375], [-122.54972, 37.97401], [-122.54931, 37.97406], [-122.54913, 37.97424], [-122.54895, 37.97428], [-122.54857, 37.97423], [-122.54841, 37.97385], [-122.54797, 37.97389], [-122.54794, 37.97376], [-122.54841, 37.9737], [-122.54859, 37.97357], [-122.54802, 37.97172], [-122.54851, 37.9716], [-122.54843, 37.97182], [-122.54863, 37.97227], [-122.54882, 37.97242], [-122.54902, 37.97247], [-122.5499, 37.97205], [-122.55036, 37.97204]]]} | Open Access 1 | San Rafael Lands 004 | 24975 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 8.185 | San Rafael Lands 004 |
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]);