superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where MNG_AGENCY = 20
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6451 | 6451 | 6450 | {"type": "Polygon", "coordinates": [[[-122.35987, 37.94279], [-122.35986, 37.94446], [-122.35939, 37.94449], [-122.35942, 37.94601], [-122.35933, 37.94601], [-122.35841, 37.94373], [-122.35893, 37.94324], [-122.35949, 37.94288], [-122.35987, 37.94279]]]} | Open Access 1 | Lucas Park | 21574 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 5.806 | Lucas Park | ||
6653 | 6653 | 6652 | {"type": "Polygon", "coordinates": [[[-122.3504, 37.91529], [-122.3498, 37.9153], [-122.34977, 37.91532], [-122.34975, 37.9152], [-122.34969, 37.91514], [-122.34949, 37.91514], [-122.34942, 37.91523], [-122.34929, 37.91526], [-122.34919, 37.91526], [-122.34861, 37.91481], [-122.34859, 37.91481], [-122.34851, 37.91471], [-122.34742, 37.91561], [-122.3474, 37.91583], [-122.34583, 37.9161], [-122.34549, 37.91613], [-122.34512, 37.91603], [-122.34483, 37.91576], [-122.34478, 37.91528], [-122.34467, 37.91473], [-122.34598, 37.9147], [-122.34649, 37.91431], [-122.34649, 37.91407], [-122.34727, 37.9135], [-122.34728, 37.91394], [-122.34757, 37.91418], [-122.35036, 37.91428], [-122.3504, 37.91529]]]} | Open Access 1 | Marina Park | 21835 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 17.101 | Marina Park | ||
6727 | 6727 | 6726 | {"type": "Polygon", "coordinates": [[[-122.35991, 37.92563], [-122.3599, 37.92738], [-122.35822, 37.92738], [-122.35824, 37.92652], [-122.356, 37.92651], [-122.356, 37.92562], [-122.35817, 37.92564], [-122.35816, 37.92537], [-122.35867, 37.92535], [-122.35869, 37.92563], [-122.35991, 37.92563]]]} | Open Access 1 | Martin Luther King Jr. Park | 21914 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 12.188 | Martin Luther King Jr. Park | ||
6940 | 6940 | 6939 | {"type": "Polygon", "coordinates": [[[-122.31198, 37.91187], [-122.31137, 37.91213], [-122.31113, 37.91177], [-122.31143, 37.91164], [-122.31163, 37.91193], [-122.31194, 37.91181], [-122.31198, 37.91187]]]} | Open Access 1 | Mendocino Park | 22150 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.4 | Mendocino Park | ||
7037 | 7037 | 7036 | {"type": "Polygon", "coordinates": [[[-122.32224, 37.93726], [-122.32192, 37.93762], [-122.3213, 37.93766], [-122.32099, 37.93777], [-122.32019, 37.93753], [-122.31996, 37.93752], [-122.31993, 37.93731], [-122.32079, 37.93728], [-122.32174, 37.93695], [-122.32224, 37.93726]]]} | Open Access 1 | Mira Vista Park | 22279 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.382 | Mira Vista Park | ||
7151 | 7151 | 7150 | {"type": "Polygon", "coordinates": [[[-122.32076, 37.91089], [-122.32036, 37.9111], [-122.32004, 37.91085], [-122.32053, 37.91061], [-122.32076, 37.91089]]]} | Open Access 1 | Monterey Playlot | 22430 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.438 | Monterey Playlot | ||
7374 | 7374 | 7373 | {"type": "Polygon", "coordinates": [[[-122.34151, 37.93148], [-122.34115, 37.93471], [-122.3389, 37.93439], [-122.33892, 37.93148], [-122.34151, 37.93148]]]} | Open Access 1 | Nicholl Park | 22747 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 18.004 | Nicholl Park | ||
7466 | 7466 | 7465 | {"type": "Polygon", "coordinates": [[[-122.36678, 37.96058], [-122.36672, 37.96196], [-122.36471, 37.96199], [-122.3647, 37.96103], [-122.3657, 37.96093], [-122.36591, 37.96089], [-122.36616, 37.96081], [-122.36659, 37.96061], [-122.36678, 37.96058]]]} | Open Access 1 | North Richmond Ballfield | 22855 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 5.433 | North Richmond Ballfield | ||
7944 | 7944 | 7943 | {"type": "Polygon", "coordinates": [[[-122.35362, 37.98233], [-122.35355, 37.98332], [-122.3531, 37.98328], [-122.35252, 37.98313], [-122.35277, 37.98227], [-122.35362, 37.98233]]]} | Open Access 1 | Parchester Park | 23416 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.212 | Parchester Park | ||
8233 | 8233 | 8232 | {"type": "Polygon", "coordinates": [[[-122.32541, 37.92277], [-122.32536, 37.92398], [-122.32459, 37.92398], [-122.32469, 37.92347], [-122.32472, 37.92316], [-122.32465, 37.92275], [-122.32541, 37.92277]]]} | Open Access 1 | Plaza One Park | 23780 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.1 | Plaza One Park | ||
8275 | 8275 | 8274 | {"type": "Polygon", "coordinates": [[[-122.41635, 37.94604], [-122.41628, 37.94614], [-122.41509, 37.94594], [-122.41481, 37.94585], [-122.41211, 37.94404], [-122.41218, 37.94401], [-122.41487, 37.94575], [-122.41517, 37.94583], [-122.41548, 37.94587], [-122.41568, 37.94584], [-122.41635, 37.94604]]]} | Open Access 1 | Point Molate Beach Park | 23855 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 1.192 | Point Molate Beach Park | ||
8467 | 8467 | 8466 | {"type": "Polygon", "coordinates": [[[-122.2723, 37.96335], [-122.27203, 37.96346], [-122.27169, 37.96393], [-122.27124, 37.96394], [-122.27115, 37.96354], [-122.27107, 37.96286], [-122.27137, 37.96259], [-122.27174, 37.96242], [-122.27217, 37.96301], [-122.2723, 37.96335]]]} | Open Access 1 | Rain Cloud Park | 24082 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.934 | Rain Cloud Park | ||
8683 | 8683 | 8682 | {"type": "Polygon", "coordinates": [[[-122.3323, 37.98394], [-122.33204, 37.98385], [-122.33063, 37.98502], [-122.32884, 37.9864], [-122.32844, 37.98703], [-122.32811, 37.98759], [-122.32668, 37.98749], [-122.32657, 37.98714], [-122.32591, 37.98422], [-122.32657, 37.98412], [-122.32749, 37.98509], [-122.32835, 37.98501], [-122.3309, 37.98364], [-122.3314, 37.98355], [-122.33171, 37.98357], [-122.33185, 37.98361], [-122.3323, 37.98394]], [[-122.32884, 37.98558], [-122.32902, 37.98554], [-122.32922, 37.98553], [-122.32944, 37.9853], [-122.32973, 37.98505], [-122.32976, 37.98493], [-122.32969, 37.98487], [-122.32953, 37.98491], [-122.32932, 37.98492], [-122.32915, 37.98489], [-122.32854, 37.98515], [-122.3282, 37.98537], [-122.32796, 37.98547], [-122.32775, 37.98547], [-122.32761, 37.98544], [-122.32737, 37.9853], [-122.32725, 37.98521], [-122.32697, 37.98492], [-122.32676, 37.98476], [-122.32657, 37.98475], [-122.32661, 37.9849], [-122.32667, 37.98506], [-122.32676, 37.98518], [-122.32689, 37.98545], [-122.32695, 37.98564], [-122.32705, 37.98575], [-122.32719, 37.98588], [-122.32729, 37.98603], [-122.32727, 37.9861], [-122.32707, 37.98621], [-122.32695, 37.98634], [-122.3269, 37.98649], [-122.32689, 37.98662], [-122.32694, 37.98676], [-122.32711, 37.98691], [-122.32733, 37.98693], [-122.32779, 37.98693], [-122.32793, 37.98686], [-122.32801, 37.98675], [-122.32806, 37.98662], [-122.32811, 37.98622], [-122.32817, 37.98603], [-122.32832, 37.98581], [-122.32852, 37.98566], [-122.32884, 37.98558]]]} | Open Access 1 | Richmond | 24339 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 18.719 | Richmond | ||
9507 | 9507 | 9506 | {"type": "Polygon", "coordinates": [[[-122.34496, 37.94599], [-122.34331, 37.946], [-122.34329, 37.94522], [-122.34411, 37.94522], [-122.34411, 37.94553], [-122.34415, 37.94561], [-122.34422, 37.94565], [-122.34432, 37.94566], [-122.34435, 37.9457], [-122.34442, 37.94572], [-122.34448, 37.94571], [-122.34457, 37.94567], [-122.34495, 37.94567], [-122.34496, 37.94599]]]} | Open Access 1 | Wendell Park | 27345 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.186 | Wendell Park | ||
9588 | 9588 | 9587 | {"type": "Polygon", "coordinates": [[[-122.36415, 37.95346], [-122.36411, 37.95466], [-122.36246, 37.95466], [-122.36246, 37.95346], [-122.36415, 37.95346]]]} | Open Access 1 | Shield Ried Park | 25406 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 4.845 | Shield Ried Park | ||
9592 | 9592 | 9591 | {"type": "Polygon", "coordinates": [[[-122.34512, 37.90866], [-122.34504, 37.90865], [-122.3448, 37.90869], [-122.34432, 37.90896], [-122.34401, 37.90901], [-122.34399, 37.9079], [-122.34439, 37.90788], [-122.3451, 37.90764], [-122.34512, 37.90866]]]} | Open Access 1 | Shimada Friendship Park | 25411 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.745 | Shimada Friendship Park | ||
9601 | 9601 | 9600 | {"type": "Polygon", "coordinates": [[[-122.36073, 37.91008], [-122.3591, 37.91005], [-122.35912, 37.90945], [-122.36066, 37.90945], [-122.36073, 37.91008]]]} | Open Access 1 | Sheridan Point Park | 25394 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.347 | Sheridan Point Park | ||
10036 | 10036 | 10035 | {"type": "Polygon", "coordinates": [[[-122.36656, 37.93894], [-122.36623, 37.93894], [-122.36622, 37.93901], [-122.36587, 37.93901], [-122.36587, 37.9385], [-122.36656, 37.9385], [-122.36656, 37.93894]]]} | Open Access 1 | Stuart Playground | 25935 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.794 | Stuart Playground | ||
10364 | 10364 | 10363 | {"type": "Polygon", "coordinates": [[[-122.32467, 37.939], [-122.32467, 37.939], [-122.32412, 37.94027], [-122.32333, 37.9387], [-122.32424, 37.93848], [-122.32435, 37.93882], [-122.32447, 37.93893], [-122.32467, 37.939]]]} | Open Access 1 | Tiller Park | 26364 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 2.807 | Tiller Park | ||
10800 | 10800 | 10799 | {"type": "Polygon", "coordinates": [[[-122.35897, 37.93446], [-122.35888, 37.93458], [-122.35876, 37.93467], [-122.35862, 37.9347], [-122.35847, 37.93468], [-122.35833, 37.93462], [-122.35805, 37.93439], [-122.35804, 37.93416], [-122.35896, 37.93416], [-122.35897, 37.93446]]]} | Open Access 1 | Veteran's Memorial Park | 27013 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.984 | Veteran's Memorial 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]);