units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 14, DES_TP = 8 and LABEL_NAME = "Elkhorn Slough ER"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15575 | 15575 | 15574 | {"type": "Polygon", "coordinates": [[[-121.74412, 36.87571], [-121.74366, 36.87559], [-121.74329, 36.87545], [-121.74227, 36.87498], [-121.74082, 36.8726], [-121.74226, 36.87023], [-121.7427, 36.87029], [-121.74329, 36.87006], [-121.74404, 36.87042], [-121.74411, 36.87185], [-121.74417, 36.87201], [-121.74408, 36.87317], [-121.74393, 36.87357], [-121.74369, 36.87428], [-121.74359, 36.87435], [-121.74351, 36.87447], [-121.74349, 36.87456], [-121.7435, 36.87468], [-121.74363, 36.87499], [-121.74412, 36.87566], [-121.74412, 36.87571]]]} | Restricted Access 2 | 44940 | Elkhorn Slough Ecological Reserve | 18581 | 3019 | Elkhorn Slough Foundation 464 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.elkhornslough.org | Non Governmental Organization 10 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Elkhorn-Slough-ER | Monterey 14 | 29.594 | Elkhorn Slough ER | 1980 | State Conservation Area 8 | 2 |
15597 | 15597 | 15596 | {"type": "MultiPolygon", "coordinates": [[[[-121.73236, 36.79888], [-121.73137, 36.80002], [-121.73067, 36.79994], [-121.7301, 36.79964], [-121.72977, 36.79976], [-121.73012, 36.80049], [-121.72931, 36.80116], [-121.72877, 36.80092], [-121.72931, 36.8003], [-121.72898, 36.79952], [-121.72882, 36.79952], [-121.72842, 36.79867], [-121.73236, 36.79888]]], [[[-121.77977, 36.81277], [-121.76922, 36.8129], [-121.76748, 36.81444], [-121.76646, 36.8144], [-121.76597, 36.81294], [-121.76057, 36.81301], [-121.76725, 36.81211], [-121.7663, 36.80814], [-121.7706, 36.80746], [-121.77109, 36.80759], [-121.77177, 36.81056], [-121.77215, 36.81057], [-121.77297, 36.81242], [-121.77977, 36.81235], [-121.77977, 36.81277]]], [[[-121.73306, 36.82909], [-121.73263, 36.82914], [-121.73217, 36.82913], [-121.73186, 36.82907], [-121.73157, 36.82897], [-121.73138, 36.82886], [-121.73118, 36.82869], [-121.73107, 36.82857], [-121.73054, 36.82784], [-121.73037, 36.82767], [-121.73015, 36.82752], [-121.72844, 36.82692], [-121.72874, 36.82643], [-121.72872, 36.82641], [-121.72895, 36.82601], [-121.73112, 36.82614], [-121.73097, 36.82523], [-121.7312, 36.82524], [-121.73202, 36.82557], [-121.73206, 36.82605], [-121.73206, 36.82655], [-121.73203, 36.82682], [-121.73175, 36.82714], [-121.73172, 36.8274], [-121.73189, 36.82754], [-121.73217, 36.82764], [-121.73258, 36.82811], [-121.73272, 36.82834], [-121.7328, 36.82882], [-121.73278, 36.82883], [-121.73306, 36.82909]]], [[[-121.73405, 36.82997], [-121.73375, 36.83014], [-121.73342, 36.83027], [-121.73222, 36.83062], [-121.73203, 36.83066], [-121.7318, 36.83066], [-121.73166, 36.83064], [-121.73147, 36.83058], [-121.72896, 36.82955], [-121.72882, 36.82951], [-121.72859, 36.82946], [-121.72841, 36.82945], [-121.7282, 36.82945], [-121.72798, 36.82948], [-121.72759, 36.82932], [-121.72674, 36.82931], [-121.7272, 36.82906], [-121.72779, 36.82887], [-121.72808, 36.82887], [-121.7283, 36.82901], [-121.72862, 36.82907], [-121.72904, 36.82889], [-121.72949, 36.82883], [-121.73023, 36.82923], [-121.73046, 36.82929], [-121.73085, 36.8292], [-121.73101, 36.82926], [-121.73121, 36.82921], [-121.73186, 36.82922], [-121.73209, 36.82926], [-121.73245, 36.82928], [-121.73274, 36.82927], [-121.73308, 36.82923], [-121.73318, 36.82924], [-121.73328, 36.82929], [-121.73405, 36.82997]]], [[[-121.73412, 36.83009], [-121.7343, 36.83025], [-121.73434, 36.83031], [-121.73437, 36.83041], [-121.73436, 36.83051], [-121.73432, 36.8306], [-121.73395, 36.83107], [-121.73372, 36.83146], [-121.7336, 36.83175], [-121.73315, 36.83304], [-121.73306, 36.83321], [-121.73295, 36.8334], [-121.72948, 36.8322], [-121.72624, 36.83206], [-121.72611, 36.83168], [-121.72608, 36.83144], [-121.7261, 36.83121], [-121.72617, 36.83103], [-121.72629, 36.83086], [-121.72742, 36.82988], [-121.72768, 36.82973], [-121.72787, 36.82966], [-121.72803, 36.82962], [-121.72821, 36.8296], [-121.72842, 36.8296], [-121.72858, 36.82962], [-121.72878, 36.82966], [-121.73137, 36.83072], [-121.73156, 36.83078], [-121.73176, 36.83081], [-121.73199, 36.83081], [-121.73221, 36.83077], [-121.73345, 36.83041], [-121.7338, 36.83027], [-121.73412, 36.83009]]], [[[-121.76204, 36.80362], [-121.76182, 36.80681], [-121.75995, 36.81363], [-121.75361, 36.81455], [-121.75351, 36.81397], [-121.7535, 36.8129], [-121.75296, 36.81286], [-121.751, 36.81309], [-121.74849, 36.81408], [-121.74696, 36.81519], [-121.74501, 36.81619], [-121.74517, 36.81717], [-121.74298, 36.82285], [-121.74011, 36.82951], [-121.74012, 36.82952], [-121.74066, 36.82958], [-121.74, 36.831], [-121.74112, 36.83498], [-121.74214, 36.83679], [-121.74035, 36.83733], [-121.73992, 36.83664], [-121.73965, 36.83613], [-121.73948, 36.83579], [-121.73927, 36.83526], [-121.73915, 36.83491], [-121.73899, 36.83437], [-121.73891, 36.83401], [-121.73884, 36.83364], [-121.73876, 36.83309], [-121.73873, 36.83254], [-121.73872, 36.83217], [-121.73873, 36.8318], [-121.73878, 36.83125], [-121.73886, 36.83071], [-121.73894, 36.83034], [-121.73908, 36.8298], [-121.73919, 36.82945], [-121.73916, 36.82943], [-121.74645, 36.80972], [-121.74697, 36.80828], [-121.74835, 36.80859], [-121.75101, 36.80748], [-121.75352, 36.80502], [-121.75353, 36.80154], [-121.76204, 36.80362]]], [[[-121.74888, 36.80305], [-121.74855, 36.80356], [-121.74831, 36.80399], [-121.7481, 36.80442], [-121.74792, 36.80487], [-121.73893, 36.82919], [-121.73869, 36.82992], [-121.73852, 36.83066], [-121.73842, 36.83142], [-121.73838, 36.83217], [-121.73841, 36.83293], [-121.7385, 36.83368], [-121.73866, 36.83442], [-121.73888, 36.83516], [-121.73909, 36.8357], [-121.73942, 36.83641], [-121.73981, 36.8371], [-121.74026, 36.83776], [-121.74077, 36.8384], [-121.74133, 36.839], [-121.74194, 36.83958], [-121.7426, 36.84012], [-121.74331, 36.84062], [-121.74385, 36.84096], [-121.74318, 36.8414], [-121.74318, 36.84141], [-121.74344, 36.8416], [-121.74184, 36.84299], [-121.7415, 36.84288], [-121.7412, 36.84276], [-121.74091, 36.84262], [-121.74065, 36.84246], [-121.74023, 36.84214], [-121.73946, 36.84143], [-121.73908, 36.84116], [-121.73871, 36.84096], [-121.73826, 36.84077], [-121.73746, 36.8405], [-121.73673, 36.84014], [-121.73648, 36.84004], [-121.73518, 36.8397], [-121.73491, 36.83959], [-121.73459, 36.83943], [-121.73431, 36.83923], [-121.73334, 36.83841], [-121.73323, 36.83827], [-121.73314, 36.83814], [-121.73307, 36.838], [-121.73297, 36.83772], [-121.73287, 36.83754], [-121.73278, 36.83744], [-121.7323, 36.83697], [-121.73225, 36.83691], [-121.73222, 36.83682], [-121.73222, 36.83673], [-121.73231, 36.83604], [-121.73234, 36.8359], [-121.73244, 36.8357], [-121.73276, 36.83524], [-121.73287, 36.83494], [-121.7329, 36.83473], [-121.73296, 36.83387], [-121.73299, 36.83373], [-121.73304, 36.8336], [-121.73326, 36.83325], [-121.73336, 36.83304], [-121.73381, 36.83177], [-121.73392, 36.8315], [-121.73404, 36.83128], [-121.73417, 36.83107], [-121.73452, 36.83062], [-121.73457, 36.8305], [-121.73458, 36.83039], [-121.73453, 36.83024], [-121.73444, 36.83012], [-121.73301, 36.82885], [-121.73291, 36.82827], [-121.73271, 36.82796], [-121.73229, 36.82749], [-121.732, 36.8274], [-121.73193, 36.82734], [-121.73194, 36.82718], [-121.73222, 36.82688], [-121.73226, 36.82651], [-121.73226, 36.82582], [-121.73223, 36.82548], [-121.73127, 36.82508], [-121.7303, 36.82502], [-121.72991, 36.82489], [-121.7293, 36.82431], [-121.72869, 36.82423], [-121.72853, 36.82405], [-121.72875, 36.82351], [-121.72868, 36.82313], [-121.72949, 36.82249], [-121.72994, 36.82209], [-121.7303, 36.82136], [-121.73001, 36.82111], [-121.72934, 36.82101], [-121.7287, 36.82106], [-121.72792, 36.82088], [-121.72792, 36.82071], [-121.72864, 36.82056], [-121.72925, 36.82012], [-121.72996, 36.82006], [-121.73045, 36.81969], [-121.73015, 36.81919], [-121.7296, 36.81901], [-121.72779, 36.8167], [-121.72713, 36.81622], [-121.72607, 36.81576], [-121.72512, 36.81571], [-121.72296, 36.81537], [-121.72163, 36.81533], [-121.72075, 36.81505], [-121.72073, 36.8149], [-121.72093, 36.81481], [-121.7272, 36.81422], [-121.72689, 36.8121], [-121.72779, 36.81186], [-121.73007, 36.81186], [-121.73029, 36.8121], [-121.73045, 36.81207], [-121.73045, 36.81205], [-121.73019, 36.81178], [-121.73032, 36.81081], [-121.73203, 36.81034], [-121.73479, 36.80909], [-121.73481, 36.80894], [-121.73192, 36.81022], [-121.73021, 36.8107], [-121.72898, 36.80893], [-121.72896, 36.80896], [-121.73017, 36.81072], [-121.73014, 36.81073], [-121.73001, 36.81175], [-121.72772, 36.81174], [-121.72683, 36.81198], [-121.72653, 36.80999], [-121.72749, 36.80966], [-121.72854, 36.80914], [-121.72855, 36.80913], [-121.72833, 36.8088], [-121.72889, 36.8085], [-121.72928, 36.80817], [-121.7302, 36.80788], [-121.72991, 36.80743], [-121.72927, 36.80679], [-121.72898, 36.80602], [-121.72887, 36.80542], [-121.72872, 36.8054], [-121.72747, 36.80644], [-121.72726, 36.80642], [-121.72736, 36.80575], [-121.7274, 36.80575], [-121.72906, 36.80489], [-121.72927, 36.80437], [-121.73012, 36.80481], [-121.73028, 36.80511], [-121.73106, 36.80601], [-121.73149, 36.80667], [-121.7321, 36.8068], [-121.73239, 36.80705], [-121.73273, 36.80689], [-121.73331, 36.80672], [-121.73394, 36.80667], [-121.73429, 36.80655], [-121.73528, 36.8065], [-121.73543, 36.80565], [-121.73501, 36.80552], [-121.73456, 36.80547], [-121.73405, 36.80559], [-121.73327, 36.80582], [-121.73322, 36.80567], [-121.73323, 36.80553], [-121.73389, 36.80517], [-121.73433, 36.8049], [-121.73429, 36.80473], [-121.73334, 36.80452], [-121.7325, 36.80477], [-121.7311, 36.80413], [-121.73069, 36.80421], [-121.73022, 36.80424], [-121.72941, 36.80399], [-121.72942, 36.80374], [-121.73039, 36.80372], [-121.73117, 36.80352], [-121.73295, 36.80254], [-121.73225, 36.80121], [-121.73101, 36.80045], [-121.73131, 36.80011], [-121.73434, 36.80128], [-121.73434, 36.8013], [-121.73449, 36.80136], [-121.73597, 36.80268], [-121.73598, 36.80275], [-121.73599, 36.80274], [-121.73636, 36.80091], [-121.73748, 36.8026], [-121.74148, 36.80303], [-121.74154, 36.80189], [-121.74457, 36.80154], [-121.74577, 36.80148], [-121.74526, 36.80058], [-121.74667, 36.80166], [-121.74735, 36.80208], [-121.74763, 36.8021], [-121.74827, 36.802], [-121.74888, 36.80305]]]]} | Open Access 1 | 15312 | Elkhorn Slough Ecological Reserve | 32159 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Elkhorn-Slough-ER | Monterey 14 | 1745.658 | Elkhorn Slough ER | 1980 | State Conservation Area 8 | 2 |
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]);