units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

196 rows where ACCESS_TYP = 1, COUNTY = 23 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 196 ✖
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
637 637 636 {"type": "Polygon", "coordinates": [[[-122.56171, 37.90549], [-122.56153, 37.90597], [-122.56084, 37.90597], [-122.56053, 37.90588], [-122.5609, 37.9053], [-122.56144, 37.905], [-122.56164, 37.90502], [-122.56165, 37.90534], [-122.56171, 37.90549]]]} Open Access 1 4911 Earnscliff Canyon Park 18357 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 1.834 Earnscliff Canyon Park 0 Local Park 2 4
767 767 766 {"type": "Polygon", "coordinates": [[[-122.56127, 37.90272], [-122.56111, 37.90294], [-122.56104, 37.90321], [-122.56096, 37.90329], [-122.56054, 37.90341], [-122.56012, 37.90317], [-122.55964, 37.90307], [-122.55927, 37.90288], [-122.559, 37.9024], [-122.55868, 37.90221], [-122.55918, 37.90164], [-122.55976, 37.90179], [-122.55993, 37.90166], [-122.5605, 37.90225], [-122.56127, 37.90272]]]} Open Access 1 5001 Edgewood Park 18441 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 5.983 Edgewood Park 0 Local Park 2 4
769 769 768 {"type": "Polygon", "coordinates": [[[-122.54807, 37.9076], [-122.5477, 37.9077], [-122.54767, 37.90763], [-122.54751, 37.90744], [-122.54733, 37.90731], [-122.54718, 37.90725], [-122.54716, 37.90719], [-122.54716, 37.90716], [-122.54723, 37.90719], [-122.5476, 37.90693], [-122.54792, 37.90723], [-122.54807, 37.9076]]]} Open Access 1 5019 Mill Velley City Park 22237 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 0.821 Mill Velley City Park 0 Local Park 2 4
842 842 841 {"type": "MultiPolygon", "coordinates": [[[[-122.54096, 37.90615], [-122.54093, 37.90638], [-122.54083, 37.90634], [-122.54085, 37.90616], [-122.54069, 37.90599], [-122.54027, 37.90594], [-122.54011, 37.90602], [-122.54012, 37.90627], [-122.53975, 37.9063], [-122.53916, 37.9065], [-122.53892, 37.90674], [-122.53856, 37.90649], [-122.53811, 37.90567], [-122.53785, 37.90537], [-122.53769, 37.90537], [-122.5378, 37.905], [-122.53838, 37.90496], [-122.53828, 37.90534], [-122.53841, 37.90535], [-122.53885, 37.90385], [-122.53915, 37.90385], [-122.53881, 37.90491], [-122.53912, 37.90581], [-122.5396, 37.90603], [-122.54025, 37.90584], [-122.54057, 37.90586], [-122.54058, 37.90588], [-122.54068, 37.90591], [-122.54079, 37.90589], [-122.54096, 37.90615]]], [[[-122.5387, 37.90385], [-122.53841, 37.90484], [-122.53787, 37.90489], [-122.53792, 37.90474], [-122.53795, 37.90454], [-122.53776, 37.90455], [-122.53771, 37.90435], [-122.53773, 37.90434], [-122.53778, 37.90453], [-122.53808, 37.9045], [-122.53808, 37.9044], [-122.53811, 37.90439], [-122.53807, 37.90384], [-122.5387, 37.90385]]]]} Open Access 1 4948 Boyle Park 16317 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 6.861 Boyle Park 0 Local Park 2 4
847 847 846 {"type": "Polygon", "coordinates": [[[-122.53111, 37.89916], [-122.53088, 37.89927], [-122.53057, 37.89945], [-122.53032, 37.89967], [-122.5302, 37.89979], [-122.53006, 37.89974], [-122.53013, 37.89958], [-122.53076, 37.89894], [-122.53111, 37.89916]]]} Open Access 1 4979 Freeman Park 19092 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 0.66 Freeman Park 0 Local Park 2 4
898 898 897 {"type": "Polygon", "coordinates": [[[-122.55026, 37.90193], [-122.54988, 37.90234], [-122.54978, 37.90226], [-122.54932, 37.90212], [-122.54961, 37.90158], [-122.5498, 37.90167], [-122.55001, 37.90147], [-122.55005, 37.90145], [-122.55026, 37.90161], [-122.55026, 37.90193]]]} Open Access 1 5020 Kathleen Norris Memorial Park 20558 1204 Mill Valley, City of 227 City 2 City Agency 2 http://www.cityofmillvalley.org/Index.aspx?page=416 City 2 1204 Mill Valley, City of 223 City 2 City Agency 2   Marin 23 1.194 Kathleen Norris Memorial Park 0 Local Park 2 4
1349 1349 1348 {"type": "Polygon", "coordinates": [[[-122.53016, 37.96819], [-122.53012, 37.96849], [-122.52961, 37.96844], [-122.52958, 37.96857], [-122.52959, 37.96858], [-122.5301, 37.96863], [-122.5299, 37.96998], [-122.52887, 37.96988], [-122.52883, 37.9701], [-122.52651, 37.96875], [-122.52664, 37.96792], [-122.52781, 37.96801], [-122.52783, 37.96793], [-122.53016, 37.96819]]]} Open Access 1 7681 Albert Park 15338 1312 San Rafael, City of 352 City 2 City Agency 2 http://www.cityofsanrafael.org/comsvcs-home/ City 2 1312 San Rafael, City of 349 City 2 City Agency 2   Marin 23 13.115 Albert Park 0 Local Park 2 4
1845 1845 1844 {"type": "Polygon", "coordinates": [[[-122.50067, 37.9218], [-122.49945, 37.92181], [-122.49936, 37.9201], [-122.50047, 37.91971], [-122.50066, 37.92009], [-122.50067, 37.9218]]]} Open Access 1 14087 San Clemente Park 24850 1070 Corte Madera, Town of 431 City 2 City Agency 2 http://www.ci.corte-madera.ca.us/199/Parks-Recreation City 2 1070 Corte Madera, Town of 425 City 2 City Agency 2   Marin 23 5.785 San Clemente Park 0 Local Park 2 4
1863 1863 1862 {"type": "MultiPolygon", "coordinates": [[[[-122.58022, 37.98301], [-122.58014, 37.98311], [-122.57993, 37.98309], [-122.57917, 37.98294], [-122.57907, 37.98292], [-122.57872, 37.98261], [-122.57838, 37.98254], [-122.57833, 37.98259], [-122.57821, 37.98251], [-122.5781, 37.98251], [-122.57801, 37.9826], [-122.57779, 37.98246], [-122.57791, 37.98233], [-122.57834, 37.98228], [-122.57848, 37.98228], [-122.57864, 37.98235], [-122.57887, 37.98237], [-122.57877, 37.98255], [-122.57895, 37.98269], [-122.57906, 37.98272], [-122.57908, 37.98268], [-122.5792, 37.98277], [-122.57919, 37.98281], [-122.57933, 37.98285], [-122.57947, 37.98287], [-122.57953, 37.98292], [-122.58022, 37.98301]]], [[[-122.57817, 37.98218], [-122.57799, 37.9822], [-122.5779, 37.98195], [-122.57804, 37.98182], [-122.57817, 37.98218]]]]} Open Access 1 14215 Lansdale Park 21015 1292 San Anselmo, City of 437 City 2 City Agency 2 http://www.townofsananselmo.org/index.aspx?nid=106 City 2 1292 San Anselmo, City of 431 City 2 City Agency 2   Marin 23 1.158 Lansdale Park 0 Local Park 2 4
1873 1873 1872 {"type": "Polygon", "coordinates": [[[-122.46707, 37.88146], [-122.46653, 37.88124], [-122.46589, 37.88087], [-122.46559, 37.88065], [-122.46532, 37.88041], [-122.46513, 37.88021], [-122.46483, 37.87984], [-122.46419, 37.87897], [-122.46388, 37.87861], [-122.46349, 37.87828], [-122.4633, 37.87796], [-122.46307, 37.87767], [-122.46282, 37.87739], [-122.46263, 37.87722], [-122.46342, 37.87788], [-122.46385, 37.87832], [-122.46603, 37.88068], [-122.46632, 37.88098], [-122.46669, 37.88126], [-122.46707, 37.88146]]]} Open Access 1 16022 Belvedere Lands 004 15999 1026 Belvedere, City of 443 City 2 City Agency 2 http://www.cityofbelvedere.org/ City 2 1026 Belvedere, City of 437 City 2 City Agency 2   Marin 23 2.781 Belvedere Lands 004   None 152  
1874 1874 1873 {"type": "MultiPolygon", "coordinates": [[[[-122.61561, 38.09426], [-122.61442, 38.09946], [-122.61303, 38.0978], [-122.61249, 38.09808], [-122.61247, 38.09805], [-122.61306, 38.09774], [-122.61342, 38.09727], [-122.6135, 38.09715], [-122.61413, 38.09738], [-122.6146, 38.09657], [-122.61398, 38.09633], [-122.61426, 38.09579], [-122.61395, 38.09568], [-122.61396, 38.09562], [-122.61438, 38.09555], [-122.61416, 38.09521], [-122.61357, 38.09523], [-122.61307, 38.09534], [-122.61282, 38.09479], [-122.6123, 38.09499], [-122.61222, 38.09517], [-122.61218, 38.09516], [-122.61255, 38.09437], [-122.61169, 38.09409], [-122.61165, 38.09402], [-122.61152, 38.09387], [-122.61139, 38.09378], [-122.61161, 38.09349], [-122.61119, 38.09339], [-122.61084, 38.09339], [-122.61016, 38.09354], [-122.60989, 38.09372], [-122.60966, 38.09393], [-122.60951, 38.09416], [-122.6094, 38.09464], [-122.6094, 38.09491], [-122.60923, 38.09494], [-122.6091, 38.09501], [-122.60864, 38.09462], [-122.60839, 38.09496], [-122.60841, 38.09591], [-122.60821, 38.09675], [-122.6083, 38.09729], [-122.60888, 38.09728], [-122.60899, 38.09741], [-122.60885, 38.09747], [-122.60887, 38.09751], [-122.60838, 38.09754], [-122.60836, 38.09807], [-122.60867, 38.09849], [-122.60888, 38.09905], [-122.60877, 38.09906], [-122.60848, 38.09941], [-122.60858, 38.0998], [-122.60908, 38.09999], [-122.60961, 38.10011], [-122.6097, 38.10001], [-122.61007, 38.10029], [-122.61033, 38.10081], [-122.61076, 38.10069], [-122.61084, 38.10086], [-122.6102, 38.10106], [-122.60996, 38.10099], [-122.60951, 38.10025], [-122.60877, 38.10009], [-122.60845, 38.09995], [-122.60828, 38.09962], [-122.60827, 38.09932], [-122.60866, 38.09894], [-122.60851, 38.09855], [-122.60845, 38.09847], [-122.6063, 38.09751], [-122.60833, 38.09474], [-122.60859, 38.09448], [-122.609, 38.09481], [-122.60929, 38.09441], [-122.60931, 38.09405], [-122.60954, 38.09375], [-122.60981, 38.09368], [-122.61029, 38.09335], [-122.61123, 38.093], [-122.6116, 38.09279], [-122.61368, 38.09432], [-122.61449, 38.09381], [-122.61561, 38.09426]]], [[[-122.61166, 38.09956], [-122.61166, 38.09957], [-122.61109, 38.09958], [-122.61092, 38.09951], [-122.61105, 38.09944], [-122.6114, 38.09953], [-122.61166, 38.09956]]], [[[-122.61422, 38.10051], [-122.61422, 38.10064], [-122.6141, 38.10125], [-122.613, 38.10123], [-122.61246, 38.10146], [-122.61187, 38.10159], [-122.61149, 38.1014], [-122.61134, 38.1013], [-122.61255, 38.10103], [-122.613, 38.10064], [-122.61273, 38.1003], [-122.61294, 38.10019], [-122.61298, 38.10003], [-122.61249, 38.0994], [-122.61252, 38.09939], [-122.61281, 38.09974], [-122.61289, 38.09975], [-122.61364, 38.10067], [-122.61422, 38.10051]]], [[[-122.61482, 38.10239], [-122.61404, 38.10248], [-122.61368, 38.10266], [-122.6136, 38.10252], [-122.61389, 38.10236], [-122.61407, 38.10217], [-122.6141, 38.10204], [-122.61397, 38.10191], [-122.61408, 38.1018], [-122.61412, 38.10178], [-122.6142, 38.1018], [-122.61414, 38.10209], [-122.61457, 38.10212], [-122.61476, 38.10202], [-122.61482, 38.10239]]], [[[-122.61463, 38.09971], [-122.61455, 38.10011], [-122.6143, 38.10025], [-122.61425, 38.10019], [-122.61449, 38.10006], [-122.61458, 38.09964], [-122.61463, 38.09971]]]]} Open Access 1 16029 Novato Lands 008 22918 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 40.983 Novato Lands 008   None 153  
1875 1875 1874 {"type": "Polygon", "coordinates": [[[-122.47958, 37.85038], [-122.47942, 37.85069], [-122.47929, 37.85087], [-122.4792, 37.85087], [-122.47929, 37.85065], [-122.47936, 37.85055], [-122.47945, 37.85045], [-122.47954, 37.85038], [-122.47958, 37.85038]]]} Open Access 1 14407 Tiffany Beach 26358 1327 Sausalito, City of 445 City 2 City Agency 2 http://www.ci.sausalito.ca.us/index.aspx?page=156 City 2 1327 Sausalito, City of 439 City 2 City Agency 2   Marin 23 0.14 Tiffany Beach 0 Local Park 2 4
1884 1884 1883 {"type": "MultiPolygon", "coordinates": [[[[-122.52606, 38.05916], [-122.52581, 38.05915], [-122.52559, 38.05905], [-122.52536, 38.05898], [-122.52502, 38.05895], [-122.52492, 38.05887], [-122.52492, 38.05882], [-122.52477, 38.05882], [-122.52476, 38.05887], [-122.52465, 38.05894], [-122.52381, 38.0589], [-122.5239, 38.0578], [-122.52378, 38.05772], [-122.52321, 38.05712], [-122.5231, 38.05716], [-122.52298, 38.05699], [-122.52259, 38.05723], [-122.52277, 38.05741], [-122.52277, 38.05745], [-122.52273, 38.05751], [-122.5228, 38.05758], [-122.52287, 38.05755], [-122.52292, 38.05757], [-122.5231, 38.05775], [-122.52282, 38.05791], [-122.52282, 38.0577], [-122.52251, 38.05774], [-122.52245, 38.05763], [-122.52236, 38.05756], [-122.52227, 38.05752], [-122.52215, 38.05749], [-122.52215, 38.05721], [-122.5225, 38.05698], [-122.5225, 38.05636], [-122.52225, 38.05605], [-122.52196, 38.05598], [-122.52157, 38.05609], [-122.52143, 38.05637], [-122.52132, 38.05668], [-122.52114, 38.057], [-122.5208, 38.05731], [-122.52076, 38.05765], [-122.52089, 38.05796], [-122.52089, 38.05839], [-122.5213, 38.05841], [-122.52127, 38.05875], [-122.51914, 38.05854], [-122.51906, 38.05851], [-122.51903, 38.05844], [-122.51913, 38.05822], [-122.51957, 38.05837], [-122.51967, 38.05814], [-122.51976, 38.05818], [-122.52088, 38.05685], [-122.52088, 38.05683], [-122.52042, 38.05659], [-122.52067, 38.0563], [-122.52091, 38.0561], [-122.52124, 38.05589], [-122.52156, 38.05577], [-122.52315, 38.05541], [-122.52456, 38.05763], [-122.52491, 38.05814], [-122.52524, 38.05854], [-122.52563, 38.05892], [-122.52565, 38.05894], [-122.52577, 38.05894], [-122.52606, 38.05916]]], [[[-122.53179, 38.06079], [-122.53147, 38.06072], [-122.53075, 38.06077], [-122.53046, 38.06068], [-122.53057, 38.05939], [-122.53088, 38.05941], [-122.53116, 38.05991], [-122.53131, 38.06015], [-122.53166, 38.06063], [-122.53179, 38.06079]]]]} Open Access 1 16079 Novato Lands 003 22914 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 19.741 Novato Lands 003   None 154  
1889 1889 1888 {"type": "MultiPolygon", "coordinates": [[[[-122.51814, 37.94731], [-122.51808, 37.94738], [-122.5172, 37.94701], [-122.51733, 37.94698], [-122.51747, 37.94708], [-122.51786, 37.94725], [-122.51814, 37.94731]]], [[[-122.51865, 37.94666], [-122.51818, 37.94725], [-122.51807, 37.94719], [-122.51789, 37.94716], [-122.51753, 37.947], [-122.51744, 37.94694], [-122.51736, 37.94684], [-122.51772, 37.94632], [-122.51826, 37.94655], [-122.51832, 37.94661], [-122.51835, 37.94669], [-122.51841, 37.94674], [-122.51851, 37.94674], [-122.51856, 37.94671], [-122.51859, 37.94665], [-122.51865, 37.94666]]]]} Open Access 1 16154 Greenbrae School Park 19474 1170 Larkspur, City of 450 City 2 City Agency 2 http://www.ci.larkspur.ca.us/index.aspx?nid=207 City 2 1170 Larkspur, City of 444 City 2 City Agency 2   Marin 23 1.644 Greenbrae School Park 0 Local Park 2 4
1907 1907 1906 {"type": "MultiPolygon", "coordinates": [[[[-122.60556, 38.1149], [-122.60527, 38.11572], [-122.60515, 38.11562], [-122.60439, 38.11485], [-122.60437, 38.11452], [-122.60378, 38.11432], [-122.60378, 38.11431], [-122.60399, 38.11435], [-122.60407, 38.11435], [-122.60477, 38.11452], [-122.60473, 38.11467], [-122.60478, 38.11473], [-122.60556, 38.1149]]], [[[-122.60834, 38.11742], [-122.60813, 38.11758], [-122.60579, 38.11663], [-122.60541, 38.1165], [-122.60554, 38.11627], [-122.60562, 38.1162], [-122.60593, 38.11642], [-122.60834, 38.11742]]]]} Open Access 1 16354 Novato Lands 009 22919 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 3.534 Novato Lands 009   None 155  
1908 1908 1907 {"type": "Polygon", "coordinates": [[[-122.52168, 37.93833], [-122.52146, 37.93845], [-122.52134, 37.938], [-122.52124, 37.93801], [-122.52119, 37.9379], [-122.52087, 37.93787], [-122.52102, 37.93776], [-122.52144, 37.93755], [-122.52168, 37.93833]]]} Open Access 1 16356 Higgins Dock 19926 1070 Corte Madera, Town of 431 City 2 City Agency 2 http://www.ci.corte-madera.ca.us/199/Parks-Recreation City 2 1070 Corte Madera, Town of 425 City 2 City Agency 2   Marin 23 0.624 Higgins Dock   None 156  
1962 1962 1961 {"type": "Polygon", "coordinates": [[[-122.53386, 37.92951], [-122.53344, 37.92993], [-122.53223, 37.92992], [-122.53201, 37.92936], [-122.5319, 37.92936], [-122.53147, 37.92871], [-122.531, 37.92809], [-122.53218, 37.92813], [-122.53313, 37.92911], [-122.53386, 37.92951]]]} Open Access 1 15080 Centennial Park 17021 1170 Larkspur, City of 450 City 2 City Agency 2 http://www.ci.larkspur.ca.us/index.aspx?nid=207 City 2 1170 Larkspur, City of 444 City 2 City Agency 2   Marin 23 6.074 Centennial Park 0 Local Park 2 4
2147 2147 2146 {"type": "MultiPolygon", "coordinates": [[[[-122.53885, 37.92553], [-122.53794, 37.92553], [-122.53818, 37.92437], [-122.53881, 37.92437], [-122.53885, 37.92553]]], [[[-122.53836, 37.92432], [-122.53814, 37.92432], [-122.53814, 37.92432], [-122.53816, 37.92423], [-122.53836, 37.92423], [-122.53836, 37.92432]]], [[[-122.53853, 37.92375], [-122.53852, 37.9239], [-122.53823, 37.9239], [-122.53826, 37.92376], [-122.53853, 37.92375]]]]} Open Access 1 16011 Larkspur Lands 004 21032 1170 Larkspur, City of 450 City 2 City Agency 2 http://www.ci.larkspur.ca.us/index.aspx?nid=207 City 2 1170 Larkspur, City of 444 City 2 City Agency 2   Marin 23 2.286 Larkspur Lands 004   None 174  
2148 2148 2147 {"type": "Polygon", "coordinates": [[[-122.45562, 37.87341], [-122.4553, 37.87328], [-122.45521, 37.87326], [-122.45512, 37.87316], [-122.45502, 37.87312], [-122.45478, 37.87315], [-122.45449, 37.87308], [-122.45431, 37.87305], [-122.45404, 37.87304], [-122.45367, 37.87306], [-122.45342, 37.87306], [-122.45289, 37.873], [-122.45271, 37.87296], [-122.45245, 37.87285], [-122.45194, 37.87251], [-122.45148, 37.87227], [-122.45132, 37.87221], [-122.45115, 37.87218], [-122.45097, 37.87216], [-122.45081, 37.87217], [-122.45072, 37.87209], [-122.45083, 37.87205], [-122.45113, 37.87203], [-122.45149, 37.87219], [-122.45178, 37.87229], [-122.45235, 37.87243], [-122.4524, 37.87249], [-122.45241, 37.87261], [-122.45251, 37.87268], [-122.45275, 37.87272], [-122.45302, 37.87274], [-122.45325, 37.8728], [-122.45363, 37.87285], [-122.45414, 37.87291], [-122.45457, 37.87293], [-122.45485, 37.87296], [-122.45543, 37.87296], [-122.45562, 37.87341]]]} Open Access 1 16015 Point Tiburon Shoreline Park 31724 1348 Tiburon, Town of 486 City 2 City Agency 2 http://www.ci.tiburon.ca.us/ City 2 1348 Tiburon, Town of 477 City 2 City Agency 2   Marin 23 2.267 Point Tiburon Shoreline Park 0 Local Park 2 4
2149 2149 2148 {"type": "Polygon", "coordinates": [[[-122.46161, 37.87736], [-122.46118, 37.87759], [-122.46109, 37.87757], [-122.46043, 37.87756], [-122.46026, 37.87689], [-122.46161, 37.87736]]]} Open Access 1 16016 Zelinksy Park 27860 1348 Tiburon, Town of 486 City 2 City Agency 2 http://www.ci.tiburon.ca.us/ City 2 1348 Tiburon, Town of 477 City 2 City Agency 2   Marin 23 1.209 Zelinksy Park 0 Local Park 2 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);