superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where MNG_AGENCY = 467 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2850 | 2850 | 2849 | {"type": "Polygon", "coordinates": [[[-120.4915, 37.2933], [-120.49129, 37.29367], [-120.49082, 37.2935], [-120.49103, 37.29312], [-120.4915, 37.2933]]]} | Open Access 1 | Charles Richard Drew Park | 17141 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 0.516 | Charles Richard Drew Park | ||
3613 | 3613 | 3612 | {"type": "Polygon", "coordinates": [[[-120.49375, 37.29584], [-120.49364, 37.29603], [-120.49319, 37.29587], [-120.4933, 37.29568], [-120.49375, 37.29584]]]} | Open Access 1 | Diego Rivera Park | 18153 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 0.253 | Diego Rivera Park | ||
4918 | 4918 | 4917 | {"type": "Polygon", "coordinates": [[[-120.49486, 37.28895], [-120.49462, 37.28936], [-120.49421, 37.28921], [-120.49439, 37.2889], [-120.49456, 37.28896], [-120.49463, 37.28887], [-120.49486, 37.28895]]]} | Open Access 1 | Harriet Tubman Park | 19693 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 0.447 | Harriet Tubman Park | ||
2611 | 2611 | 2610 | {"type": "Polygon", "coordinates": [[[-120.49516, 37.33647], [-120.49512, 37.33651], [-120.49363, 37.33653], [-120.49356, 37.33652], [-120.49344, 37.33648], [-120.49326, 37.33649], [-120.49313, 37.33655], [-120.49309, 37.33658], [-120.49305, 37.33665], [-120.49305, 37.33673], [-120.49312, 37.33691], [-120.49313, 37.33724], [-120.49308, 37.33729], [-120.49169, 37.33729], [-120.49151, 37.33731], [-120.49118, 37.3374], [-120.49074, 37.33762], [-120.49069, 37.33757], [-120.4925, 37.33673], [-120.49234, 37.33648], [-120.49227, 37.33648], [-120.49225, 37.33643], [-120.49196, 37.33608], [-120.49195, 37.33603], [-120.49192, 37.33598], [-120.49182, 37.33592], [-120.49182, 37.33566], [-120.49497, 37.33562], [-120.49505, 37.33564], [-120.49513, 37.33571], [-120.49514, 37.33579], [-120.49516, 37.33647]]]} | Open Access 1 | Rudolph Joseph Merino Neighborhood Park | https://www.cityofmerced.org/Home/Components/FacilityDirectory/FacilityDirectory/48/3557 | 33623 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 8.812 | Rudolph Joseph Merino Neighborhood Park | |
9954 | 9954 | 9953 | {"type": "Polygon", "coordinates": [[[-120.50168, 37.29469], [-120.50126, 37.29543], [-120.50001, 37.29497], [-120.50043, 37.29424], [-120.50168, 37.29469]]]} | Open Access 1 | Stephen Leonard Park | 25831 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 2.699 | Stephen Leonard Park | ||
4120 | 4120 | 4119 | {"type": "Polygon", "coordinates": [[[-120.5026, 37.32463], [-120.50255, 37.32632], [-120.49734, 37.32619], [-120.49733, 37.32628], [-120.49619, 37.32625], [-120.49612, 37.32633], [-120.49608, 37.32681], [-120.49667, 37.32683], [-120.49656, 37.32703], [-120.49646, 37.32775], [-120.49506, 37.32776], [-120.49478, 37.32773], [-120.49448, 37.32767], [-120.49415, 37.32753], [-120.49257, 37.32679], [-120.49224, 37.32671], [-120.49198, 37.32668], [-120.49227, 37.32645], [-120.4925, 37.32639], [-120.4938, 37.32607], [-120.49499, 37.32599], [-120.4955, 37.3258], [-120.4955, 37.32517], [-120.49477, 37.32497], [-120.49422, 37.32489], [-120.49382, 37.32488], [-120.48924, 37.32491], [-120.48822, 37.32573], [-120.48823, 37.32621], [-120.48701, 37.32619], [-120.48707, 37.325], [-120.4871, 37.32472], [-120.5026, 37.32463]]]} | Open Access 1 | Fahrens Park | 18783 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 49.729 | Fahrens Park | ||
11728 | 11728 | 11727 | {"type": "Polygon", "coordinates": [[[-120.50302, 37.31525], [-120.50296, 37.317], [-120.50148, 37.31639], [-120.50151, 37.31494], [-120.5017, 37.31495], [-120.50192, 37.31498], [-120.50302, 37.31525]]]} | Open Access 1 | Carolo Gabriault Park | https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/neighborhood.asp | 28324 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 5.965 | Carolo Gabriault Park | |
11254 | 11254 | 11253 | {"type": "Polygon", "coordinates": [[[-120.50379, 37.28689], [-120.50377, 37.28741], [-120.50297, 37.28742], [-120.50298, 37.28689], [-120.50379, 37.28689]]]} | Open Access 1 | William Lloyd Garrison Park | 27550 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1.021 | William Lloyd Garrison Park | ||
13574 | 13574 | 13573 | {"type": "Polygon", "coordinates": [[[-120.50508, 37.29722], [-120.5047, 37.29789], [-120.5044, 37.29778], [-120.50459, 37.29745], [-120.50461, 37.29727], [-120.50486, 37.29684], [-120.50447, 37.29668], [-120.50449, 37.29664], [-120.50499, 37.29683], [-120.50508, 37.29722]]]} | Open Access 1 | Fredrick Douglas Park | https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/mini.asp | 31014 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 0.902 | Fredrick Douglas Park | |
1953 | 1953 | 1952 | {"type": "Polygon", "coordinates": [[[-120.50555, 37.29161], [-120.50555, 37.29165], [-120.50529, 37.29156], [-120.50523, 37.29164], [-120.504, 37.29119], [-120.50379, 37.29152], [-120.50367, 37.29147], [-120.50412, 37.29068], [-120.50444, 37.29079], [-120.50426, 37.29113], [-120.50468, 37.29129], [-120.50469, 37.29131], [-120.5049, 37.29138], [-120.50492, 37.29138], [-120.50555, 37.29161]]]} | Open Access 1 | Benjamin Banneker Memorial Park | 16013 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 0.977 | Benjamin Banneker Memorial Park | ||
6953 | 6953 | 6952 | {"type": "Polygon", "coordinates": [[[-120.50888, 37.29553], [-120.50884, 37.29726], [-120.50588, 37.29724], [-120.50594, 37.29553], [-120.50888, 37.29553]]]} | Open Access 1 | Merced Youth Sports Complex | 22167 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 12.335 | Merced Youth Sports Complex | ||
6503 | 6503 | 6502 | {"type": "Polygon", "coordinates": [[[-120.51484, 37.28903], [-120.51501, 37.28906], [-120.51515, 37.28915], [-120.51521, 37.28923], [-120.51524, 37.28932], [-120.51522, 37.28946], [-120.51434, 37.29158], [-120.51391, 37.29154], [-120.5146, 37.28986], [-120.51461, 37.28976], [-120.51459, 37.28967], [-120.51448, 37.28949], [-120.51444, 37.28941], [-120.51445, 37.28927], [-120.51453, 37.28915], [-120.51462, 37.28909], [-120.51472, 37.28905], [-120.51484, 37.28903]]]} | Open Access 1 | Macready Park | 21639 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 3.102 | Macready Park | ||
956 | 956 | 955 | {"type": "Polygon", "coordinates": [[[-120.52536, 37.32598], [-120.52391, 37.32599], [-120.52384, 37.32593], [-120.52386, 37.32508], [-120.52382, 37.32494], [-120.52374, 37.32475], [-120.52371, 37.32464], [-120.52376, 37.32459], [-120.52445, 37.32459], [-120.52446, 37.32503], [-120.52536, 37.32503], [-120.52536, 37.32598]]]} | Open Access 1 | Drake Avenue Park | 33589 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 4.224 | Drake Avenue 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]);