superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where MNG_AGENCY = 167 and MNG_AG_TYP = 2 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12365 | 12365 | 12364 | {"type": "Polygon", "coordinates": [[[-121.72825, 38.55739], [-121.72825, 38.55745], [-121.72788, 38.55754], [-121.72781, 38.55741], [-121.7282, 38.5573], [-121.72825, 38.55739]]]} | Open Access 1 | Pole Line/Snyder Greenbelt | 30925 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.145 | Pole Line/Snyder Greenbelt | ||
13490 | 13490 | 13489 | {"type": "Polygon", "coordinates": [[[-121.73123, 38.54961], [-121.73123, 38.54972], [-121.73057, 38.5497], [-121.73057, 38.54959], [-121.73123, 38.54961]]]} | Open Access 1 | N Street Mini-Park | http://cityofdavis.org/Home/Components/FacilityDirectory/FacilityDirectory/40/2926?npage=3 | 30908 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.176 | N Street Mini-Park | |
3761 | 3761 | 3760 | {"type": "Polygon", "coordinates": [[[-121.7412, 38.54418], [-121.74079, 38.54425], [-121.74073, 38.54406], [-121.74114, 38.54399], [-121.7412, 38.54418]]]} | Open Access 1 | E Street Plaza | 18332 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.201 | E Street Plaza | ||
13491 | 13491 | 13490 | {"type": "Polygon", "coordinates": [[[-121.70244, 38.54454], [-121.70243, 38.54488], [-121.7019, 38.54488], [-121.70188, 38.5448], [-121.70188, 38.54471], [-121.70185, 38.54466], [-121.70208, 38.54454], [-121.70244, 38.54454]]]} | Open Access 1 | Woodbridge Park | http://cityofdavis.org/Home/Components/FacilityDirectory/FacilityDirectory/80/2926?npage=7 | 30909 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.434 | Woodbridge Park | |
7494 | 7494 | 7493 | {"type": "Polygon", "coordinates": [[[-121.75072, 38.57381], [-121.75068, 38.57385], [-121.75067, 38.57395], [-121.75049, 38.57408], [-121.75035, 38.57409], [-121.75034, 38.57399], [-121.7503, 38.57395], [-121.75016, 38.57394], [-121.75011, 38.57395], [-121.75011, 38.57366], [-121.75028, 38.57367], [-121.75032, 38.57366], [-121.75035, 38.57362], [-121.75065, 38.57367], [-121.75065, 38.57373], [-121.75072, 38.57381]]]} | Open Access 1 | Northstar Pocket Park | 22894 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.476 | Northstar PP | ||
2730 | 2730 | 2729 | {"type": "Polygon", "coordinates": [[[-121.73627, 38.55082], [-121.73586, 38.55084], [-121.73586, 38.54976], [-121.73598, 38.55013], [-121.73622, 38.55068], [-121.73627, 38.55082]]]} | Open Access 1 | Cedar Park | 16997 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.504 | Cedar Park | ||
13525 | 13525 | 13524 | {"type": "Polygon", "coordinates": [[[-121.71815, 38.54367], [-121.71806, 38.54371], [-121.7178, 38.54394], [-121.71777, 38.544], [-121.71748, 38.54417], [-121.7174, 38.54417], [-121.71696, 38.54438], [-121.71693, 38.54442], [-121.71683, 38.54441], [-121.7168, 38.54437], [-121.71646, 38.54437], [-121.71612, 38.54441], [-121.71608, 38.54449], [-121.71599, 38.54449], [-121.71597, 38.54442], [-121.71598, 38.54423], [-121.71602, 38.54425], [-121.71609, 38.54424], [-121.71613, 38.54431], [-121.71647, 38.54429], [-121.7168, 38.54429], [-121.71685, 38.5442], [-121.71697, 38.54419], [-121.71703, 38.54425], [-121.71736, 38.54409], [-121.71736, 38.54404], [-121.71769, 38.54392], [-121.7177, 38.54381], [-121.71776, 38.5438], [-121.71781, 38.54378], [-121.71784, 38.54374], [-121.71785, 38.54369], [-121.7181, 38.5436], [-121.71815, 38.54367]]]} | Open Access 1 | Village Park Greenbelt | 30930 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.689 | Village Park Greenbelt | ||
13482 | 13482 | 13481 | {"type": "Polygon", "coordinates": [[[-121.71597, 38.54423], [-121.71597, 38.54442], [-121.71564, 38.54442], [-121.71562, 38.54448], [-121.71527, 38.54448], [-121.71528, 38.54408], [-121.71532, 38.54404], [-121.71581, 38.54387], [-121.71586, 38.54387], [-121.7159, 38.5439], [-121.71594, 38.54398], [-121.71593, 38.54403], [-121.7159, 38.5441], [-121.7159, 38.54415], [-121.71593, 38.5442], [-121.71597, 38.54423]]]} | Open Access 1 | Village Park | http://cityofdavis.org/Home/Components/FacilityDirectory/FacilityDirectory/66/2926?npage=6 | 30901 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.792 | Village Park | |
12353 | 12353 | 12352 | {"type": "Polygon", "coordinates": [[[-121.78125, 38.55388], [-121.78121, 38.55395], [-121.77637, 38.55395], [-121.77637, 38.55388], [-121.78125, 38.55388]]]} | Open Access 1 | Arroyo Greenbelt | 30916 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.805 | Arroyo Greenbelt | ||
3094 | 3094 | 3093 | {"type": "Polygon", "coordinates": [[[-121.75127, 38.54762], [-121.75021, 38.54761], [-121.75021, 38.54761], [-121.75024, 38.54751], [-121.75032, 38.54742], [-121.7507, 38.5472], [-121.75085, 38.54718], [-121.75111, 38.54725], [-121.75118, 38.5473], [-121.75125, 38.54745], [-121.75127, 38.54762]]]} | Open Access 1 | College Park | 17507 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.816 | College Park | ||
740 | 740 | 739 | {"type": "Polygon", "coordinates": [[[-121.69931, 38.55911], [-121.69852, 38.55911], [-121.69853, 38.55865], [-121.6989, 38.55856], [-121.6991, 38.55855], [-121.69916, 38.55857], [-121.69919, 38.55862], [-121.69919, 38.55889], [-121.69918, 38.55896], [-121.69918, 38.55901], [-121.69924, 38.55908], [-121.69931, 38.55911]]]} | Open Access 1 | Mace Ranch Mini Park | http://cityofdavis.org/Home/Components/FacilityDirectory/FacilityDirectory/38/2926?npage=3 | 30912 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.836 | Mace Ranch MP | |
4824 | 4824 | 4823 | {"type": "Polygon", "coordinates": [[[-121.7605, 38.56573], [-121.7605, 38.56632], [-121.75984, 38.56631], [-121.75985, 38.56573], [-121.7605, 38.56573]]]} | Open Access 1 | Hacienda Park | 19586 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.923 | Hacienda Park | ||
12367 | 12367 | 12366 | {"type": "Polygon", "coordinates": [[[-121.72151, 38.54523], [-121.72126, 38.54534], [-121.72098, 38.54568], [-121.72014, 38.54595], [-121.71938, 38.54626], [-121.71931, 38.54607], [-121.72014, 38.54585], [-121.72092, 38.54558], [-121.7208, 38.54534], [-121.72084, 38.54531], [-121.72143, 38.54507], [-121.72151, 38.54523]]]} | Open Access 1 | Rosecreek Greenbelt | 30927 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 0.931 | Rosecreek Greenbelt | ||
734 | 734 | 733 | {"type": "Polygon", "coordinates": [[[-121.71434, 38.56981], [-121.71412, 38.56993], [-121.71347, 38.56998], [-121.71348, 38.56937], [-121.71412, 38.56938], [-121.71419, 38.56958], [-121.71434, 38.56981]]]} | Open Access 1 | Wildhorse Mini Park | 27515 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1.015 | Wildhorse MP | ||
11170 | 11170 | 11169 | {"type": "Polygon", "coordinates": [[[-121.79276, 38.55281], [-121.79186, 38.55291], [-121.7918, 38.55291], [-121.79176, 38.55286], [-121.79166, 38.55227], [-121.79266, 38.55227], [-121.79276, 38.55281]]]} | Open Access 1 | Whaleback Park | 27447 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1.432 | Whaleback Park | ||
12352 | 12352 | 12351 | {"type": "MultiPolygon", "coordinates": [[[[-121.71844, 38.55656], [-121.71844, 38.55688], [-121.71773, 38.55687], [-121.71774, 38.55665], [-121.71778, 38.5566], [-121.718, 38.5566], [-121.71814, 38.55665], [-121.71829, 38.55666], [-121.71836, 38.55663], [-121.71837, 38.55656], [-121.71844, 38.55656]]], [[[-121.71989, 38.55189], [-121.71986, 38.55299], [-121.71958, 38.55299], [-121.71944, 38.55326], [-121.71936, 38.55325], [-121.71937, 38.55286], [-121.71952, 38.55285], [-121.71954, 38.55227], [-121.71889, 38.55225], [-121.7189, 38.55211], [-121.71989, 38.55189]]]]} | Open Access 1 | Sunnyside Greenbelt | 30913 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1.794 | Sunnyside Greenbelt | ||
13509 | 13509 | 13508 | {"type": "Polygon", "coordinates": [[[-121.71938, 38.54626], [-121.71797, 38.54658], [-121.71751, 38.54664], [-121.71526, 38.54715], [-121.71524, 38.54707], [-121.71632, 38.54682], [-121.71628, 38.5467], [-121.71624, 38.54667], [-121.71627, 38.54659], [-121.71763, 38.54645], [-121.71754, 38.54613], [-121.71761, 38.54612], [-121.71773, 38.54643], [-121.71792, 38.54641], [-121.71932, 38.54609], [-121.71938, 38.54626]]]} | Open Access 1 | Benbow Greenbelt | 30918 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1.852 | Benbow Greenbelt | ||
12368 | 12368 | 12367 | {"type": "Polygon", "coordinates": [[[-121.76135, 38.56357], [-121.76135, 38.56364], [-121.76102, 38.56364], [-121.76096, 38.56373], [-121.7609, 38.56372], [-121.76083, 38.56373], [-121.76077, 38.56363], [-121.76045, 38.56364], [-121.76043, 38.56417], [-121.7601, 38.56417], [-121.76004, 38.56426], [-121.75998, 38.56425], [-121.75991, 38.56426], [-121.75984, 38.56417], [-121.75952, 38.56417], [-121.7595, 38.56461], [-121.75855, 38.56462], [-121.75855, 38.56425], [-121.75915, 38.56425], [-121.75925, 38.56421], [-121.7594, 38.5641], [-121.75953, 38.56406], [-121.76016, 38.56407], [-121.76021, 38.56405], [-121.76023, 38.56401], [-121.76024, 38.56333], [-121.76023, 38.5633], [-121.7602, 38.56328], [-121.76021, 38.56327], [-121.76021, 38.56317], [-121.76047, 38.56317], [-121.76048, 38.56356], [-121.76135, 38.56357]]]} | Open Access 1 | Seville Greenbelt | 30928 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1.864 | Seville Greenbelt | ||
13495 | 13495 | 13494 | {"type": "MultiPolygon", "coordinates": [[[[-121.71336, 38.54141], [-121.71336, 38.54145], [-121.71264, 38.54137], [-121.71249, 38.5414], [-121.71147, 38.54129], [-121.71113, 38.54152], [-121.71015, 38.54194], [-121.71012, 38.54174], [-121.71041, 38.54161], [-121.7108, 38.54148], [-121.71136, 38.54116], [-121.71333, 38.54136], [-121.71333, 38.5414], [-121.71336, 38.54141]]], [[[-121.71491, 38.54131], [-121.71433, 38.54149], [-121.71434, 38.54154], [-121.71352, 38.54153], [-121.71352, 38.54147], [-121.71403, 38.54148], [-121.71418, 38.54145], [-121.71478, 38.54114], [-121.71491, 38.54131]]], [[[-121.71789, 38.54033], [-121.71785, 38.54042], [-121.71718, 38.54027], [-121.71702, 38.54026], [-121.71648, 38.54054], [-121.71587, 38.54072], [-121.71567, 38.5408], [-121.71508, 38.54127], [-121.71492, 38.54107], [-121.71563, 38.54074], [-121.71646, 38.54045], [-121.71703, 38.54016], [-121.71737, 38.54025], [-121.71789, 38.54033]]]]} | Open Access 1 | Oakshade Greenbelt | 30910 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 2.198 | Oakshade Greenbelt | ||
7553 | 7553 | 7552 | {"type": "Polygon", "coordinates": [[[-121.72913, 38.565], [-121.7291, 38.56585], [-121.72823, 38.56583], [-121.72798, 38.56584], [-121.72797, 38.56528], [-121.72791, 38.56495], [-121.72799, 38.56491], [-121.72856, 38.56489], [-121.72882, 38.56499], [-121.72913, 38.565]]]} | Open Access 1 | Oak Grove Park | 22971 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 2.504 | Oak Grove 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]);