units_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)
Suggested facets: ACRES, YR_EST
DES_TP 24
MNG_AG_TYP 1
- City Agency 47
MNG_AGENCY 1
- Novato, City of · 47 ✖
ACCESS_TYP 1
- Open Access 47
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14045 | 14045 | 14044 | {"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 | 38046 | Knolltop Tot Lot | 20702 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 0.097 | Knolltop Tot Lot | 0 | Local Recreation Area 3 | 4 | |
8741 | 8741 | 8740 | {"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 | 14192 | Stafford Grove Park | 25773 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 0.262 | Stafford Grove Park | 0 | Local Park 2 | 4 | |
14044 | 14044 | 14043 | {"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 | 38045 | Wallace Family Park | 27218 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 0.372 | Wallace Family Park | 0 | Local Park 2 | 4 | |
11329 | 11329 | 11328 | {"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 | 22052 | Novato Lands 022 | 22928 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 0.548 | Novato Lands 022 | None 995 | |||
9682 | 9682 | 9681 | {"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.10645], [-122.57737, 38.10651], [-122.57742, 38.10628], [-122.57752, 38.10629], [-122.57764, 38.10633], [-122.57839, 38.10667]]]]} | Open Access 1 | 16351 | Novato Lands 018 | 22926 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 0.656 | Novato Lands 018 | None 833 | |||
2180 | 2180 | 2179 | {"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.57168, 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 | 16352 | Novato Lands 023 | 22929 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 0.776 | Novato Lands 023 | None 181 | |||
14424 | 14424 | 14423 | {"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 | 44546 | City of Novato Open Space | 17322 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 0.781 | City of Novato OS | 0 | Local Recreation Area 3 | 4 | |
9562 | 9562 | 9561 | {"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 | 16069 | Pansy Tong Lo Park | 23394 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 0.8 | Pansy Tong Lo Park | 0 | Local Park 2 | 4 | |
9674 | 9674 | 9673 | {"type": "Polygon", "coordinates": [[[-122.58299, 38.10819], [-122.58288, 38.10833], [-122.58288, 38.10837], [-122.58292, 38.10839], [-122.58294, 38.10845], [-122.58289, 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.58277, 38.10885], [-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 | 16349 | Novato Lands 017 | 22925 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 0.849 | Novato Lands 017 | None 828 | |||
9659 | 9659 | 9658 | {"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 | 16346 | Novato Lands 016 | 22924 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 0.951 | Novato Lands 016 | None 824 | |||
8942 | 8942 | 8941 | {"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 | 16341 | Partridge Knolls Tot Lots | 23488 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 1.216 | Partridge Knolls Tot Lots | None 745 | |||
14036 | 14036 | 14035 | {"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.07215], [-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 | 38056 | Hillside Park | 19982 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 1.216 | Hillside Park | 0 | Local Park 2 | 4 | |
9544 | 9544 | 9543 | {"type": "Polygon", "coordinates": [[[-122.51183, 38.05062], [-122.51155, 38.05089], [-122.5111, 38.05093], [-122.51105, 38.05068], [-122.51103, 38.05067], [-122.51092, 38.05008], [-122.51148, 38.05001], [-122.51163, 38.05032], [-122.51183, 38.05062]]]} | Open Access 1 | 16051 | Hamilton Airport Park | 19613 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 1.388 | Hamilton Airport Park | 0 | Local Park 2 | 4 | |
8834 | 8834 | 8833 | {"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 | 16042 | Novato Skate Park | 22931 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 1.722 | Novato Skate Park | 0 | Local Recreation Area 3 | 4 | |
8734 | 8734 | 8733 | {"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.10786], [-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.57915, 38.10752], [-122.5791, 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 | 14179 | Lee Gerner Park | 21133 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 1.981 | Lee Gerner Park | 0 | Local Park 2 | 4 | |
9671 | 9671 | 9670 | {"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.11239], [-122.57749, 38.11249], [-122.57804, 38.11248]]]} | Open Access 1 | 16348 | Novato Lands 010 | 22920 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 2.087 | Novato Lands 010 | None 826 | |||
8733 | 8733 | 8732 | {"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 | 14178 | Bahia Parks | 15756 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 2.102 | Bahia Parks | None 740 | |||
9561 | 9561 | 9560 | {"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 | 16068 | Humman Field | 20147 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 2.401 | Humman Field | 0 | Local Recreation Area 3 | 4 | |
2835 | 2835 | 2834 | {"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.12819], [-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 | 22051 | Novato Lands 012 | 22922 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 2.492 | Novato Lands 012 | None 236 | |||
8740 | 8740 | 8739 | {"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 | 14190 | Slade Park | 25551 | 1226 | Novato, City of 444 | City 2 | City Agency 2 | http://www.ci.novato.ca.us/Index.aspx?page=520 | City 2 | 1226 | Novato, City of 438 | City 2 | City Agency 2 | Marin 23 | 2.663 | Slade Park | 0 | Local Park 2 | 4 |
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]);