superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Petaluma-Marsh-WA"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11980 | 11980 | 11979 | {"type": "MultiPolygon", "coordinates": [[[[-122.50114, 38.09994], [-122.50105, 38.1015], [-122.50039, 38.10059], [-122.499, 38.10057], [-122.49875, 38.10216], [-122.49645, 38.10216], [-122.49538, 38.10416], [-122.49482, 38.10786], [-122.49494, 38.10802], [-122.49512, 38.10812], [-122.49479, 38.11012], [-122.49321, 38.10974], [-122.49147, 38.10844], [-122.49022, 38.10783], [-122.48838, 38.10633], [-122.48807, 38.1053], [-122.49074, 38.1003], [-122.4917, 38.09961], [-122.4927, 38.0996], [-122.49266, 38.0997], [-122.49268, 38.09971], [-122.50114, 38.09994]]], [[[-122.49857, 38.10988], [-122.49834, 38.10988], [-122.49752, 38.10958], [-122.49546, 38.10951], [-122.49547, 38.10864], [-122.49723, 38.10861], [-122.49814, 38.10929], [-122.49857, 38.10988]]], [[[-122.5038, 38.11388], [-122.50155, 38.11561], [-122.50118, 38.11577], [-122.5013, 38.11583], [-122.50058, 38.11604], [-122.49981, 38.11605], [-122.49878, 38.11598], [-122.49802, 38.11541], [-122.49878, 38.11482], [-122.4999, 38.11526], [-122.49989, 38.11525], [-122.49865, 38.11461], [-122.50105, 38.1126], [-122.50133, 38.11229], [-122.5038, 38.11388]]], [[[-122.51907, 38.12211], [-122.51647, 38.12333], [-122.51648, 38.12325], [-122.51647, 38.12324], [-122.51603, 38.12344], [-122.51603, 38.12345], [-122.51626, 38.12339], [-122.51628, 38.12365], [-122.51592, 38.12382], [-122.51633, 38.12415], [-122.51641, 38.12492], [-122.51663, 38.12487], [-122.51727, 38.12984], [-122.51416, 38.13009], [-122.5136, 38.12791], [-122.51321, 38.12493], [-122.51322, 38.12474], [-122.51189, 38.12118], [-122.51184, 38.12117], [-122.51187, 38.12113], [-122.51145, 38.12078], [-122.51163, 38.12053], [-122.51136, 38.12041], [-122.51154, 38.12036], [-122.51313, 38.11831], [-122.51319, 38.11839], [-122.5133, 38.11843], [-122.51345, 38.11821], [-122.5134, 38.11815], [-122.51409, 38.11715], [-122.51416, 38.11716], [-122.51425, 38.11707], [-122.51437, 38.11689], [-122.5144, 38.11689], [-122.51781, 38.11932], [-122.51868, 38.12171], [-122.51907, 38.12211]], [[-122.51512, 38.12386], [-122.51511, 38.12385], [-122.51483, 38.12397], [-122.51472, 38.1241], [-122.51321, 38.12465], [-122.51321, 38.12468], [-122.51485, 38.12409], [-122.51512, 38.12386]]], [[[-122.56457, 38.15666], [-122.55567, 38.15676], [-122.55448, 38.15531], [-122.55067, 38.1569], [-122.54745, 38.15692], [-122.54501, 38.15676], [-122.54452, 38.15664], [-122.54437, 38.15648], [-122.54433, 38.15638], [-122.54389, 38.15649], [-122.54119, 38.15303], [-122.53735, 38.14988], [-122.53286, 38.14676], [-122.52803, 38.14438], [-122.52209, 38.1411], [-122.51694, 38.13633], [-122.51478, 38.13251], [-122.51468, 38.13212], [-122.51627, 38.13138], [-122.51706, 38.13118], [-122.51803, 38.13102], [-122.51874, 38.13137], [-122.51978, 38.13144], [-122.52048, 38.13164], [-122.52049, 38.13167], [-122.52066, 38.1316], [-122.52066, 38.13158], [-122.52035, 38.13153], [-122.52445, 38.12626], [-122.52463, 38.12608], [-122.52491, 38.12586], [-122.52522, 38.12567], [-122.52547, 38.12556], [-122.52547, 38.12542], [-122.52551, 38.1253], [-122.52559, 38.12518], [-122.52568, 38.1251], [-122.52578, 38.12503], [-122.5259, 38.12499], [-122.52604, 38.12496], [-122.52619, 38.12495], [-122.52633, 38.12497], [-122.52647, 38.12502], [-122.52662, 38.1251], [-122.5267, 38.12518], [-122.52618, 38.12545], [-122.52619, 38.12578], [-122.5273, 38.12616], [-122.5292, 38.1265], [-122.52946, 38.1261], [-122.53028, 38.12608], [-122.53105, 38.1257], [-122.5316, 38.12597], [-122.53175, 38.12628], [-122.53128, 38.12672], [-122.53123, 38.12743], [-122.53061, 38.12773], [-122.53068, 38.12816], [-122.53141, 38.12872], [-122.53283, 38.12892], [-122.53313, 38.12884], [-122.5334, 38.12854], [-122.53505, 38.12788], [-122.53585, 38.12769], [-122.53627, 38.128], [-122.53568, 38.12921], [-122.53646, 38.12992], [-122.53729, 38.12998], [-122.53742, 38.12933], [-122.53849, 38.12842], [-122.53879, 38.12859], [-122.53874, 38.12946], [-122.5393, 38.12958], [-122.53981, 38.1292], [-122.54033, 38.12926], [-122.53975, 38.13088], [-122.54048, 38.13109], [-122.54104, 38.13065], [-122.54185, 38.13049], [-122.5422, 38.13015], [-122.54275, 38.13031], [-122.54291, 38.13112], [-122.54335, 38.13137], [-122.54362, 38.13132], [-122.5441, 38.13187], [-122.54513, 38.13236], [-122.54517, 38.13326], [-122.54609, 38.13408], [-122.54674, 38.1345], [-122.54687, 38.13444], [-122.54743, 38.13363], [-122.54723, 38.134], [-122.547, 38.13431], [-122.54671, 38.1349], [-122.54578, 38.13505], [-122.54666, 38.13534], [-122.54709, 38.13675], [-122.54356, 38.13802], [-122.54201, 38.13874], [-122.54054, 38.13918], [-122.53814, 38.13924], [-122.53576, 38.13903], [-122.53333, 38.1384], [-122.52503, 38.13628], [-122.52444, 38.1365], [-122.52411, 38.13711], [-122.52417, 38.13777], [-122.5246, 38.13837], [-122.52713, 38.14002], [-122.52879, 38.14152], [-122.52916, 38.14165], [-122.53802, 38.14178], [-122.53803, 38.14181], [-122.54702, 38.14199], [-122.55455, 38.14188], [-122.56274, 38.15239], [-122.56348, 38.15205], [-122.56353, 38.15167], [-122.56375, 38.15167], [-122.56379, 38.15349], [-122.56381, 38.1535], [-122.56423, 38.1533], [-122.56423, 38.15445], [-122.56425, 38.15501], [-122.56431, 38.15548], [-122.5644, 38.15598], [-122.56457, 38.15666]]], [[[-122.56838, 38.17684], [-122.56835, 38.17711], [-122.56819, 38.17741], [-122.56797, 38.17773], [-122.56764, 38.17802], [-122.56724, 38.17832], [-122.56685, 38.17867], [-122.56656, 38.17899], [-122.56634, 38.17934], [-122.56601, 38.18], [-122.56584, 38.18022], [-122.5657, 38.18051], [-122.56554, 38.18078], [-122.56537, 38.18113], [-122.56523, 38.18151], [-122.56514, 38.18194], [-122.56514, 38.1821], [-122.56518, 38.18231], [-122.56525, 38.18251], [-122.56535, 38.18264], [-122.56566, 38.18288], [-122.56595, 38.18303], [-122.56623, 38.18317], [-122.5667, 38.18332], [-122.56665, 38.19084], [-122.56166, 38.1909], [-122.56162, 38.19679], [-122.56031, 38.19676], [-122.56133, 38.19638], [-122.56133, 38.19635], [-122.56054, 38.19644], [-122.55956, 38.19663], [-122.5584, 38.19691], [-122.55741, 38.19723], [-122.55666, 38.19756], [-122.55568, 38.19811], [-122.55458, 38.19876], [-122.55365, 38.19927], [-122.55238, 38.19955], [-122.55133, 38.19951], [-122.55052, 38.19928], [-122.54988, 38.19878], [-122.54906, 38.19782], [-122.54858, 38.19663], [-122.54805, 38.19559], [-122.54781, 38.19444], [-122.54757, 38.19343], [-122.54739, 38.19247], [-122.54733, 38.19188], [-122.54703, 38.19151], [-122.54686, 38.19096], [-122.54655, 38.18827], [-122.54607, 38.18621], [-122.54553, 38.18446], [-122.54497, 38.18333], [-122.54409, 38.18202], [-122.54204, 38.17931], [-122.54061, 38.1779], [-122.53886, 38.17657], [-122.53647, 38.17484], [-122.53378, 38.17282], [-122.5333, 38.17238], [-122.53286, 38.1718], [-122.53269, 38.17148], [-122.53257, 38.17115], [-122.53248, 38.17081], [-122.53245, 38.17051], [-122.53245, 38.17012], [-122.5325, 38.16978], [-122.53259, 38.16944], [-122.53272, 38.16912], [-122.5329, 38.16879], [-122.53311, 38.1685], [-122.53336, 38.16821], [-122.53364, 38.16795], [-122.53397, 38.16771], [-122.5343, 38.1675], [-122.53458, 38.16736], [-122.53487, 38.16724], [-122.53516, 38.16713], [-122.53547, 38.16704], [-122.54012, 38.16615], [-122.54191, 38.16557], [-122.54343, 38.16445], [-122.54509, 38.16329], [-122.5458, 38.16218], [-122.5458, 38.16189], [-122.54732, 38.16144], [-122.5532, 38.15826], [-122.55359, 38.15836], [-122.55464, 38.15856], [-122.55581, 38.15891], [-122.55624, 38.15905], [-122.55678, 38.15931], [-122.55722, 38.15955], [-122.55751, 38.15976], [-122.55776, 38.15992], [-122.55813, 38.1603], [-122.55823, 38.16048], [-122.55833, 38.16076], [-122.55843, 38.16112], [-122.5585, 38.16146], [-122.55851, 38.16178], [-122.55845, 38.16222], [-122.55832, 38.16269], [-122.55816, 38.16309], [-122.55783, 38.16367], [-122.55719, 38.16447], [-122.55632, 38.16515], [-122.55605, 38.16534], [-122.55572, 38.16554], [-122.55494, 38.16592], [-122.55444, 38.16611], [-122.55403, 38.1663], [-122.55303, 38.1668], [-122.55225, 38.16738], [-122.55211, 38.1676], [-122.55199, 38.16789], [-122.55196, 38.16808], [-122.55196, 38.16828], [-122.55198, 38.16847], [-122.55204, 38.16876], [-122.55214, 38.16901], [-122.55232, 38.16921], [-122.55255, 38.1694], [-122.55313, 38.16966], [-122.55383, 38.16982], [-122.5548, 38.16982], [-122.55523, 38.1698], [-122.55588, 38.16962], [-122.55648, 38.16943], [-122.5569, 38.16927], [-122.55774, 38.169], [-122.55829, 38.1688], [-122.55863, 38.16872], [-122.55912, 38.16867], [-122.55949, 38.16867], [-122.55993, 38.16863], [-122.56081, 38.16864], [-122.56133, 38.16868], [-122.56188, 38.16874], [-122.56255, 38.16888], [-122.56312, 38.16911], [-122.56341, 38.16927], [-122.56385, 38.16965], [-122.56406, 38.17002], [-122.56414, 38.17022], [-122.56419, 38.17077], [-122.5642, 38.17213], [-122.56411, 38.17248], [-122.56403, 38.17306], [-122.564, 38.17363], [-122.56419, 38.17421], [-122.56441, 38.17456], [-122.56461, 38.17482], [-122.56501, 38.17523], [-122.56561, 38.17544], [-122.566, 38.1755], [-122.56663, 38.17566], [-122.56775, 38.17614], [-122.56806, 38.17633], [-122.56824, 38.17652], [-122.56838, 38.17684]]], [[[-122.55563, 38.09543], [-122.55146, 38.09632], [-122.55121, 38.09633], [-122.55104, 38.09631], [-122.55088, 38.09626], [-122.55067, 38.09615], [-122.5505, 38.096], [-122.55042, 38.09589], [-122.55036, 38.09576], [-122.55031, 38.09539], [-122.55026, 38.09517], [-122.55018, 38.09494], [-122.54948, 38.09356], [-122.54935, 38.09335], [-122.5492, 38.09314], [-122.54903, 38.09295], [-122.54883, 38.09277], [-122.54862, 38.09261], [-122.54838, 38.09246], [-122.54813, 38.09233], [-122.55032, 38.08953], [-122.54457, 38.08265], [-122.54434, 38.08275], [-122.54433, 38.08277], [-122.55, 38.08956], [-122.5479, 38.09223], [-122.54755, 38.09211], [-122.54728, 38.09205], [-122.547, 38.092], [-122.54672, 38.09198], [-122.54644, 38.09197], [-122.54616, 38.09199], [-122.54528, 38.09212], [-122.54472, 38.09223], [-122.54418, 38.09237], [-122.54365, 38.09254], [-122.54308, 38.09278], [-122.54292, 38.09282], [-122.54276, 38.09285], [-122.5426, 38.09285], [-122.54243, 38.09283], [-122.54228, 38.09278], [-122.54214, 38.09272], [-122.54201, 38.09264], [-122.53812, 38.08967], [-122.53784, 38.08947], [-122.53754, 38.0893], [-122.53722, 38.08914], [-122.53667, 38.08893], [-122.53646, 38.08883], [-122.5361, 38.08859], [-122.53593, 38.08846], [-122.53566, 38.08815], [-122.53546, 38.08781], [-122.53539, 38.08763], [-122.53534, 38.08745], [-122.5388, 38.08478], [-122.53989, 38.08427], [-122.54116, 38.08424], [-122.54192, 38.08388], [-122.54177, 38.08365], [-122.54102, 38.08382], [-122.54087, 38.08366], [-122.54096, 38.08347], [-122.54143, 38.08319], [-122.54304, 38.08253], [-122.54471, 38.08192], [-122.54481, 38.08205], [-122.54522, 38.08286], [-122.54542, 38.0832], [-122.54584, 38.08381], [-122.55563, 38.09543]]], [[[-122.56449, 38.11876], [-122.56466, 38.11927], [-122.56485, 38.12007], [-122.56512, 38.12238], [-122.56513, 38.12264], [-122.5651, 38.12291], [-122.56506, 38.12308], [-122.56486, 38.12373], [-122.56455, 38.12466], [-122.56409, 38.12612], [-122.56384, 38.12698], [-122.56339, 38.12838], [-122.5631, 38.12905], [-122.5623, 38.13059], [-122.5622, 38.13084], [-122.56214, 38.1311], [-122.56162, 38.1311], [-122.56149, 38.13106], [-122.56142, 38.13097], [-122.5614, 38.13083], [-122.56129, 38.13066], [-122.56111, 38.13053], [-122.56081, 38.13039], [-122.56052, 38.1304], [-122.55996, 38.13046], [-122.55956, 38.13059], [-122.55925, 38.13074], [-122.55901, 38.13102], [-122.55888, 38.13187], [-122.55875, 38.13218], [-122.5586, 38.13243], [-122.55827, 38.13266], [-122.55789, 38.13284], [-122.55745, 38.13287], [-122.55718, 38.13272], [-122.55702, 38.13252], [-122.557, 38.13229], [-122.55709, 38.13194], [-122.55712, 38.13153], [-122.55708, 38.13112], [-122.55698, 38.13076], [-122.55666, 38.13039], [-122.55635, 38.13021], [-122.55607, 38.13017], [-122.55566, 38.13022], [-122.55515, 38.13044], [-122.55463, 38.13074], [-122.55427, 38.13102], [-122.55414, 38.13132], [-122.55404, 38.1318], [-122.55416, 38.13212], [-122.55409, 38.13246], [-122.55399, 38.1326], [-122.55378, 38.13273], [-122.55345, 38.13283], [-122.55306, 38.13285], [-122.55278, 38.13277], [-122.55259, 38.13267], [-122.5524, 38.13248], [-122.55213, 38.13203], [-122.55179, 38.13164], [-122.55134, 38.13131], [-122.55091, 38.13108], [-122.55047, 38.1309], [-122.5504, 38.13089], [-122.55045, 38.13065], [-122.54927, 38.13018], [-122.54936, 38.13007], [-122.54981, 38.13005], [-122.5503, 38.12992], [-122.55078, 38.12973], [-122.55096, 38.1297], [-122.55143, 38.12967], [-122.55223, 38.12943], [-122.55253, 38.12927], [-122.55279, 38.12908], [-122.55303, 38.12885], [-122.55319, 38.1286], [-122.5533, 38.12833], [-122.55337, 38.12806], [-122.5534, 38.12777], [-122.55338, 38.12749], [-122.55331, 38.12717], [-122.55333, 38.12702], [-122.55342, 38.1268], [-122.55353, 38.12664], [-122.55363, 38.12652], [-122.55373, 38.12644], [-122.55407, 38.12627], [-122.55451, 38.12599], [-122.55461, 38.12582], [-122.55471, 38.12543], [-122.55479, 38.12463], [-122.55494, 38.12443], [-122.55627, 38.12376], [-122.55698, 38.12336], [-122.55883, 38.12217], [-122.55916, 38.12206], [-122.55946, 38.12189], [-122.55968, 38.12173], [-122.55997, 38.12147], [-122.56016, 38.12134], [-122.56043, 38.1212], [-122.56075, 38.12092], [-122.56117, 38.12076], [-122.56146, 38.12059], [-122.5619, 38.12009], [-122.5624, 38.11973], [-122.56283, 38.11934], [-122.56314, 38.11914], [-122.56426, 38.11867], [-122.5643, 38.11877], [-122.56449, 38.11876]]], [[[-122.56423, 38.15117], [-122.56048, 38.14635], [-122.56338, 38.14622], [-122.56351, 38.14618], [-122.56369, 38.14607], [-122.56391, 38.1459], [-122.56395, 38.14584], [-122.56397, 38.14577], [-122.56362, 38.14174], [-122.56372, 38.14172], [-122.56366, 38.14093], [-122.56384, 38.14093], [-122.5642, 38.14592], [-122.56425, 38.14707], [-122.56423, 38.15117]]], [[[-122.58185, 38.20121], [-122.5677, 38.20133], [-122.56716, 38.20042], [-122.56646, 38.19937], [-122.56527, 38.19837], [-122.56446, 38.19786], [-122.57922, 38.19779], [-122.57905, 38.19795], [-122.57859, 38.19813], [-122.57789, 38.19826], [-122.57714, 38.19835], [-122.57653, 38.19847], [-122.57627, 38.19862], [-122.57608, 38.19887], [-122.57606, 38.19916], [-122.57632, 38.19961], [-122.57708, 38.20044], [-122.57779, 38.20076], [-122.57824, 38.20067], [-122.57855, 38.20052], [-122.57925, 38.19981], [-122.57956, 38.19946], [-122.57995, 38.19927], [-122.58035, 38.19927], [-122.58067, 38.19963], [-122.58105, 38.20042], [-122.58134, 38.20076], [-122.58175, 38.20116], [-122.58185, 38.20121]]]]} | Open Access 1 | Petaluma Marsh Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Petaluma-Marsh-WA | 30485 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 4420.47 | Petaluma Marsh Wildlife Area | 1979 |
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]);