units_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)
DES_TP 15
- Local Park 21
- Local Recreation Area 1
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 35
MNG_AGENCY 1
- San Rafael, City of · 35 ✖
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES ▼ | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14845 | 14845 | 14844 | {"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 | 45352 | Schoen Park | 25188 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 0.144 | Schoen Park | 0 | Local Park 2 | 4 | |
14050 | 14050 | 14049 | {"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 | 38051 | Hillview Park | 19995 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 0.256 | Hillview Park | 0 | Local Park 2 | 4 | |
9563 | 9563 | 9562 | {"type": "Polygon", "coordinates": [[[-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.46008, 37.99457], [-122.46004, 37.9947]]]} | Open Access 1 | 16081 | Riviera Park | 24470 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 0.26 | Riviera Park | 0 | Local Park 2 | 4 | |
14049 | 14049 | 14048 | {"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 | 38050 | Arbor Park | 15558 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 0.39 | Arbor Park | 0 | Local Park 2 | 4 | |
9596 | 9596 | 9595 | {"type": "Polygon", "coordinates": [[[-122.54385, 37.99802], [-122.54339, 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 | 16138 | Oliver Hartzell Park | 23135 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 0.443 | Oliver Hartzell Park | 0 | Local Park 2 | 4 | |
8760 | 8760 | 8759 | {"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 | 14240 | Bret Harte Park | 16367 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 0.446 | Bret Harte Park | 0 | Local Park 2 | 4 | |
9597 | 9597 | 9596 | {"type": "Polygon", "coordinates": [[[-122.55487, 38.01144], [-122.55481, 38.01151], [-122.5546, 38.01138], [-122.554, 38.01106], [-122.55359, 38.01089], [-122.55276, 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.01024], [-122.55207, 38.01018], [-122.55213, 38.01009], [-122.55419, 38.01106], [-122.55487, 38.01144]]]} | Open Access 1 | 16142 | Munson Park | 22600 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 1.46 | Munson Park | 0 | Local Park 2 | 4 | |
8759 | 8759 | 8758 | {"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 | 14238 | Sun Valley Park | 25980 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 2.186 | Sun Valley Park | 0 | Local Park 2 | 4 | |
8758 | 8758 | 8757 | {"type": "Polygon", "coordinates": [[[-122.54738, 38.01028], [-122.54739, 38.01079], [-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 | 14237 | Oleander Park | 23115 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 2.457 | Oleander Park | 0 | Local Park 2 | 4 | |
14051 | 14051 | 14050 | {"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.53544, 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 | 38052 | Los Ranchitos Park | 21530 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 2.999 | Los Ranchitos Park | 0 | Local Park 2 | 4 | |
8754 | 8754 | 8753 | {"type": "Polygon", "coordinates": [[[-122.55746, 38.0049], [-122.55744, 38.00514], [-122.55741, 38.00532], [-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 | 14229 | Maria B. Freitas Park | 21809 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 3.128 | Maria B. Freitas Park | 0 | Local Park 2 | 4 | |
16923 | 16923 | 16922 | {"type": "Polygon", "coordinates": [[[-122.56119, 38.01484], [-122.56081, 38.01574], [-122.56009, 38.01555], [-122.56001, 38.01559], [-122.55991, 38.01583], [-122.55985, 38.01581], [-122.55994, 38.01559], [-122.55996, 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 | 16140 | Terra Linda Recreation Center | 26254 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 3.195 | Terra Linda Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
9641 | 9641 | 9640 | {"type": "Polygon", "coordinates": [[[-122.51876, 37.96858], [-122.5186, 37.96924], [-122.51825, 37.96918], [-122.51831, 37.96891], [-122.51766, 37.96878], [-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 | 16225 | Beach Park | 15908 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 3.935 | Beach Park | 0 | Local Park 2 | 4 | |
6416 | 6416 | 6415 | {"type": "Polygon", "coordinates": [[[-122.48506, 37.9904], [-122.4847, 37.99067], [-122.48418, 37.99068], [-122.48346, 37.99005], [-122.48385, 37.98964], [-122.48353, 37.9895], [-122.48355, 37.98939], [-122.48354, 37.98924], [-122.48342, 37.98896], [-122.48373, 37.98886], [-122.48354, 37.98849], [-122.48355, 37.98837], [-122.48362, 37.98813], [-122.48373, 37.98792], [-122.48389, 37.98749], [-122.48387, 37.98735], [-122.48391, 37.98727], [-122.4844, 37.9874], [-122.48457, 37.98747], [-122.48472, 37.98756], [-122.48431, 37.98795], [-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 | 1887 | Victor Jones Park | 27070 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 5.987 | Victor Jones Park | 0 | Local Park 2 | 4 | |
8753 | 8753 | 8752 | {"type": "Polygon", "coordinates": [[[-122.57743, 38.0188], [-122.57718, 38.0189], [-122.57671, 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.01854], [-122.57545, 38.01839], [-122.57639, 38.01757], [-122.5772, 38.01793], [-122.57743, 38.0188]]]} | Open Access 1 | 14227 | San Margarita Park | 24946 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 6.03 | San Margarita Park | 0 | Local Park 2 | 4 | |
8757 | 8757 | 8756 | {"type": "Polygon", "coordinates": [[[-122.53788, 37.96488], [-122.53788, 37.96491], [-122.53737, 37.96486], [-122.53734, 37.96499], [-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 | 14236 | Gerstle Park | 19279 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 6.203 | Gerstle Park | 0 | Local Park 2 | 4 | |
9642 | 9642 | 9641 | {"type": "Polygon", "coordinates": [[[-122.49481, 37.97153], [-122.49427, 37.97171], [-122.49413, 37.9716], [-122.49395, 37.97156], [-122.49337, 37.97157], [-122.49259, 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 | 16227 | San Rafael Lands 008 | 24979 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 6.402 | San Rafael Lands 008 | None 821 | |||
9551 | 9551 | 9550 | {"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 | 16083 | Peacock Gap Neighborhood Park | 23544 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 7.114 | Peacock Gap Neighborhood Park | 0 | Local Park 2 | 4 | |
4790 | 4790 | 4789 | {"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 | 48141 | Unnamed site - San Rafael, City of | 32671 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 7.23 | 0 | Local Other or Unknown 14 | 4 | ||
9600 | 9600 | 9599 | {"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.97384], [-122.54797, 37.97389], [-122.54794, 37.97376], [-122.54841, 37.9737], [-122.5486, 37.97357], [-122.54802, 37.97172], [-122.54851, 37.9716], [-122.54843, 37.97182], [-122.54863, 37.97228], [-122.54882, 37.97242], [-122.54902, 37.97247], [-122.5499, 37.97205], [-122.55036, 37.97204]]]} | Open Access 1 | 16148 | San Rafael Lands 004 | 24975 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 8.175 | San Rafael Lands 004 | None 810 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);