superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
47 rows where MNG_AGENCY = 438 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5688 | 5688 | 5687 | {"type": "Polygon", "coordinates": [[[-122.54914, 38.10824], [-122.54909, 38.10831], [-122.54903, 38.10833], [-122.54883, 38.10823], [-122.54892, 38.10809], [-122.54903, 38.10813], [-122.54905, 38.1082], [-122.54914, 38.10824]]]} | Open Access 1 | Knolltop Tot Lot | 20702 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 0.097 | Knolltop Tot Lot | ||
9893 | 9893 | 9892 | {"type": "Polygon", "coordinates": [[[-122.57836, 38.11028], [-122.57813, 38.11063], [-122.57791, 38.11055], [-122.57803, 38.11021], [-122.57836, 38.11028]]]} | Open Access 1 | Stafford Grove Park | 25773 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 0.262 | Stafford Grove Park | ||
9388 | 9388 | 9387 | {"type": "Polygon", "coordinates": [[[-122.55513, 38.06704], [-122.55509, 38.06722], [-122.55483, 38.06718], [-122.5545, 38.06718], [-122.55446, 38.06716], [-122.55444, 38.0671], [-122.55462, 38.06687], [-122.55513, 38.06704]]]} | Open Access 1 | Wallace Family Park | 27218 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 0.372 | Wallace Family Park | ||
7524 | 7524 | 7523 | {"type": "MultiPolygon", "coordinates": [[[[-122.57915, 38.10415], [-122.57867, 38.10393], [-122.57818, 38.10371], [-122.57821, 38.10366], [-122.57897, 38.10399], [-122.57915, 38.10415]]], [[[-122.57995, 38.10471], [-122.57975, 38.10498], [-122.57973, 38.10493], [-122.57967, 38.10489], [-122.57946, 38.10462], [-122.57899, 38.10438], [-122.57905, 38.1043], [-122.57995, 38.10471]]]]} | Open Access 1 | Novato Lands 022 | 22928 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 0.548 | Novato Lands 022 | ||
7522 | 7522 | 7521 | {"type": "MultiPolygon", "coordinates": [[[[-122.57601, 38.10683], [-122.57592, 38.1069], [-122.57548, 38.10646], [-122.57534, 38.1064], [-122.57541, 38.10617], [-122.57567, 38.10649], [-122.57601, 38.10683]]], [[[-122.57839, 38.10667], [-122.57828, 38.10681], [-122.57761, 38.10646], [-122.57737, 38.10651], [-122.57742, 38.10628], [-122.57752, 38.10629], [-122.57764, 38.10633], [-122.57839, 38.10667]]]]} | Open Access 1 | Novato Lands 018 | 22926 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 0.656 | Novato Lands 018 | ||
7525 | 7525 | 7524 | {"type": "Polygon", "coordinates": [[[-122.57366, 38.10079], [-122.57357, 38.10091], [-122.57344, 38.10082], [-122.57315, 38.10066], [-122.57274, 38.10058], [-122.57229, 38.1004], [-122.57169, 38.10044], [-122.57158, 38.10026], [-122.57169, 38.1003], [-122.57209, 38.10027], [-122.57229, 38.10027], [-122.57292, 38.1005], [-122.57302, 38.10049], [-122.57308, 38.10039], [-122.57339, 38.10052], [-122.57335, 38.1006], [-122.57347, 38.10065], [-122.57366, 38.10079]]]} | Open Access 1 | Novato Lands 023 | 22929 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 0.778 | Novato Lands 023 | ||
2260 | 2260 | 2259 | {"type": "Polygon", "coordinates": [[[-122.58444, 38.12454], [-122.58436, 38.12459], [-122.5843, 38.12467], [-122.58429, 38.12474], [-122.58432, 38.12491], [-122.58424, 38.12509], [-122.58378, 38.12498], [-122.58375, 38.12473], [-122.58342, 38.12458], [-122.58345, 38.12454], [-122.58381, 38.12464], [-122.58405, 38.12441], [-122.58444, 38.12454]]]} | Open Access 1 | City of Novato Open Space | 17322 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 0.783 | City of Novato OS | ||
7921 | 7921 | 7920 | {"type": "Polygon", "coordinates": [[[-122.54628, 38.10563], [-122.54644, 38.10593], [-122.54644, 38.10602], [-122.54641, 38.1061], [-122.54633, 38.10618], [-122.54624, 38.10623], [-122.54589, 38.10628], [-122.54581, 38.10602], [-122.54594, 38.10557], [-122.54628, 38.10563]]]} | Open Access 1 | Pansy Tong Lo Park | 23394 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 0.8 | Pansy Tong Lo Park | ||
7520 | 7520 | 7519 | {"type": "Polygon", "coordinates": [[[-122.58299, 38.10819], [-122.58288, 38.10833], [-122.58288, 38.10836], [-122.58292, 38.10839], [-122.58294, 38.10845], [-122.5829, 38.10851], [-122.58292, 38.10863], [-122.58297, 38.10866], [-122.58298, 38.10869], [-122.58258, 38.10924], [-122.58252, 38.10927], [-122.58235, 38.10927], [-122.5824, 38.10903], [-122.5825, 38.10895], [-122.58276, 38.10884], [-122.58265, 38.1082], [-122.58252, 38.10811], [-122.58244, 38.1082], [-122.58221, 38.1081], [-122.58235, 38.1079], [-122.58299, 38.10819]]]} | Open Access 1 | Novato Lands 017 | 22925 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 0.854 | Novato Lands 017 | ||
7519 | 7519 | 7518 | {"type": "MultiPolygon", "coordinates": [[[[-122.58622, 38.11244], [-122.58596, 38.11282], [-122.58593, 38.11266], [-122.58588, 38.11258], [-122.58582, 38.11252], [-122.58563, 38.1124], [-122.58545, 38.11224], [-122.58556, 38.11208], [-122.58564, 38.11216], [-122.58579, 38.11237], [-122.58584, 38.11238], [-122.5861, 38.11235], [-122.58622, 38.11244]]], [[[-122.58805, 38.11364], [-122.5879, 38.11386], [-122.58777, 38.11368], [-122.58767, 38.11328], [-122.58756, 38.11317], [-122.58733, 38.11316], [-122.58711, 38.11326], [-122.58728, 38.11301], [-122.58736, 38.11299], [-122.58753, 38.11299], [-122.5877, 38.11302], [-122.58779, 38.11313], [-122.58793, 38.11354], [-122.58801, 38.11359], [-122.58805, 38.11364]]]]} | Open Access 1 | Novato Lands 016 | 22924 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 0.952 | Novato Lands 016 | ||
7997 | 7997 | 7996 | {"type": "Polygon", "coordinates": [[[-122.58391, 38.1262], [-122.58371, 38.12671], [-122.58365, 38.12676], [-122.58358, 38.12678], [-122.58348, 38.12676], [-122.58324, 38.12661], [-122.58301, 38.12642], [-122.58288, 38.12629], [-122.58287, 38.12626], [-122.58289, 38.12622], [-122.58315, 38.12607], [-122.58333, 38.12602], [-122.58345, 38.12603], [-122.58387, 38.12613], [-122.58391, 38.12616], [-122.58391, 38.1262]]]} | Open Access 1 | Partridge Knolls Tot Lots | 23488 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1.216 | Partridge Knolls Tot Lots | ||
5171 | 5171 | 5170 | {"type": "Polygon", "coordinates": [[[-122.56117, 38.07261], [-122.56102, 38.0727], [-122.5608, 38.07244], [-122.56044, 38.07264], [-122.56031, 38.07249], [-122.56005, 38.07227], [-122.55995, 38.07214], [-122.55991, 38.07205], [-122.55989, 38.07193], [-122.55989, 38.07182], [-122.55992, 38.07173], [-122.55995, 38.07171], [-122.55999, 38.0717], [-122.56041, 38.07178], [-122.56032, 38.0721], [-122.56099, 38.07235], [-122.56117, 38.07261]]]} | Open Access 1 | Hillside Park | 19982 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1.221 | Hillside Park | ||
4851 | 4851 | 4850 | {"type": "Polygon", "coordinates": [[[-122.51183, 38.05062], [-122.51155, 38.05089], [-122.5111, 38.05093], [-122.51105, 38.05069], [-122.51103, 38.05067], [-122.51092, 38.05008], [-122.51148, 38.05001], [-122.51163, 38.05032], [-122.51183, 38.05062]]]} | Open Access 1 | Hamilton Airport Park | 19613 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1.388 | Hamilton Airport Park | ||
7527 | 7527 | 7526 | {"type": "Polygon", "coordinates": [[[-122.52882, 38.06152], [-122.52875, 38.06167], [-122.52792, 38.06152], [-122.52761, 38.06135], [-122.52785, 38.06108], [-122.52726, 38.0607], [-122.52747, 38.06048], [-122.5286, 38.06125], [-122.52874, 38.06138], [-122.52882, 38.06152]]]} | Open Access 1 | Novato Skate Park | 22931 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1.725 | Novato Skate Park | ||
6077 | 6077 | 6076 | {"type": "Polygon", "coordinates": [[[-122.581, 38.1081], [-122.5809, 38.10823], [-122.58084, 38.10819], [-122.58055, 38.10821], [-122.58039, 38.10812], [-122.58018, 38.10787], [-122.57967, 38.10776], [-122.57965, 38.10774], [-122.5795, 38.10771], [-122.57942, 38.10758], [-122.57933, 38.10753], [-122.57915, 38.10757], [-122.57914, 38.10752], [-122.57909, 38.10741], [-122.57874, 38.10726], [-122.57855, 38.10712], [-122.57861, 38.10698], [-122.57873, 38.1068], [-122.57942, 38.1071], [-122.57928, 38.10729], [-122.57928, 38.10731], [-122.57968, 38.10741], [-122.57995, 38.1075], [-122.581, 38.1081]]]} | Open Access 1 | Lee Gerner Park | 21133 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1.982 | Lee Gerner Park | ||
7515 | 7515 | 7514 | {"type": "Polygon", "coordinates": [[[-122.57804, 38.11248], [-122.57804, 38.11251], [-122.5763, 38.11256], [-122.57663, 38.11153], [-122.57714, 38.11164], [-122.57743, 38.11219], [-122.57749, 38.11238], [-122.5775, 38.11249], [-122.57804, 38.11248]]]} | Open Access 1 | Novato Lands 010 | 22920 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 2.089 | Novato Lands 010 | ||
1719 | 1719 | 1718 | {"type": "MultiPolygon", "coordinates": [[[[-122.52389, 38.12522], [-122.52389, 38.12522], [-122.52333, 38.12483], [-122.52387, 38.12479], [-122.52389, 38.12522]]], [[[-122.52425, 38.1221], [-122.52398, 38.12218], [-122.52386, 38.12215], [-122.52348, 38.12221], [-122.52347, 38.12219], [-122.52351, 38.12214], [-122.52383, 38.122], [-122.52402, 38.12194], [-122.52406, 38.12199], [-122.52418, 38.12197], [-122.52425, 38.1221]]], [[[-122.52404, 38.12401], [-122.52378, 38.12434], [-122.52372, 38.12432], [-122.52364, 38.12389], [-122.52383, 38.12391], [-122.52404, 38.12401]]], [[[-122.52489, 38.12285], [-122.52461, 38.12315], [-122.52442, 38.12306], [-122.52467, 38.12274], [-122.52489, 38.12285]]], [[[-122.52548, 38.12203], [-122.52521, 38.12241], [-122.52494, 38.12237], [-122.52523, 38.12199], [-122.52548, 38.12203]]], [[[-122.52746, 38.12235], [-122.52742, 38.1225], [-122.52698, 38.12231], [-122.52693, 38.12224], [-122.527, 38.12188], [-122.52719, 38.12194], [-122.52734, 38.12206], [-122.52744, 38.1222], [-122.52746, 38.12235]]], [[[-122.52871, 38.12423], [-122.52819, 38.12425], [-122.52817, 38.1242], [-122.52811, 38.12416], [-122.52846, 38.12385], [-122.52855, 38.12392], [-122.52864, 38.12403], [-122.52869, 38.12414], [-122.52871, 38.12423]]]]} | Open Access 1 | Bahia Parks | 15756 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 2.101 | Bahia Parks | ||
5295 | 5295 | 5294 | {"type": "Polygon", "coordinates": [[[-122.55636, 38.10843], [-122.55629, 38.10852], [-122.55601, 38.10863], [-122.55542, 38.10906], [-122.5552, 38.10902], [-122.55477, 38.10847], [-122.555, 38.10787], [-122.55636, 38.10843]]]} | Open Access 1 | Humman Field | 20147 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 2.401 | Humman Field | ||
7517 | 7517 | 7516 | {"type": "Polygon", "coordinates": [[[-122.6038, 38.12679], [-122.6033, 38.12757], [-122.60324, 38.12769], [-122.6032, 38.12782], [-122.60318, 38.12803], [-122.60321, 38.1282], [-122.60328, 38.12836], [-122.60342, 38.12858], [-122.60268, 38.12874], [-122.60278, 38.12763], [-122.60304, 38.12714], [-122.60324, 38.12665], [-122.6038, 38.12679]]]} | Open Access 1 | Novato Lands 012 | 22922 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 2.492 | Novato Lands 012 | ||
8278 | 8278 | 8277 | {"type": "Polygon", "coordinates": [[[-122.56052, 38.10124], [-122.56043, 38.10138], [-122.55845, 38.10046], [-122.55862, 38.10039], [-122.55951, 38.09996], [-122.56052, 38.10124]]]} | Open Access 1 | Slade Park | 25551 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 2.662 | Slade 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]);