units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where AGNCY_LEV = 6, DES_TP = 16, MNG_AG_TYP = 10 and UNIT_NAME = "Elkhorn Slough / Elkhorn Highlands"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Non Profit - Land Trust · 2 ✖
MNG_AGENCY 1
DES_TP 1
- Private Conservation · 2 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9102 | 9102 | 9101 | {"type": "MultiPolygon", "coordinates": [[[[-121.69438, 36.83219], [-121.694, 36.83223], [-121.69334, 36.83226], [-121.69225, 36.83223], [-121.69194, 36.83224], [-121.69079, 36.83233], [-121.68974, 36.83252], [-121.68939, 36.83256], [-121.68904, 36.83258], [-121.68705, 36.83254], [-121.68491, 36.83245], [-121.68276, 36.83254], [-121.68259, 36.83253], [-121.68246, 36.83249], [-121.68253, 36.83133], [-121.68519, 36.83049], [-121.68673, 36.82948], [-121.69189, 36.82775], [-121.69438, 36.83219]]], [[[-121.73536, 36.84127], [-121.73517, 36.84281], [-121.73448, 36.84353], [-121.73374, 36.84382], [-121.73347, 36.84412], [-121.73281, 36.84187], [-121.73329, 36.8416], [-121.73386, 36.84147], [-121.73473, 36.84114], [-121.73536, 36.84127]]], [[[-121.74392, 36.84638], [-121.74377, 36.84775], [-121.74318, 36.84775], [-121.7429, 36.84635], [-121.7436, 36.84633], [-121.74392, 36.84638]]], [[[-121.70214, 36.8456], [-121.69016, 36.8492], [-121.69024, 36.84681], [-121.68956, 36.84312], [-121.68635, 36.84013], [-121.68454, 36.8388], [-121.68434, 36.83862], [-121.68419, 36.83843], [-121.68408, 36.83823], [-121.68286, 36.83575], [-121.68217, 36.83521], [-121.68246, 36.83264], [-121.68263, 36.83267], [-121.68279, 36.83268], [-121.6849, 36.83259], [-121.68705, 36.83268], [-121.68905, 36.83271], [-121.68941, 36.83269], [-121.68978, 36.83265], [-121.69061, 36.83249], [-121.69094, 36.83245], [-121.69205, 36.83237], [-121.69334, 36.83239], [-121.69385, 36.83238], [-121.69445, 36.83232], [-121.69631, 36.8356], [-121.70214, 36.8456]]], [[[-121.75626, 36.85517], [-121.75506, 36.85514], [-121.75507, 36.8548], [-121.75503, 36.85447], [-121.75492, 36.85412], [-121.75479, 36.85386], [-121.75467, 36.85368], [-121.7545, 36.85348], [-121.75334, 36.85229], [-121.75317, 36.85206], [-121.75305, 36.85184], [-121.75297, 36.85162], [-121.75293, 36.85142], [-121.75292, 36.85122], [-121.75292, 36.8507], [-121.75287, 36.85042], [-121.75276, 36.85007], [-121.75255, 36.84971], [-121.75242, 36.84955], [-121.75224, 36.84936], [-121.75078, 36.84808], [-121.75038, 36.8477], [-121.7501, 36.84741], [-121.74907, 36.84621], [-121.74866, 36.84582], [-121.7482, 36.84546], [-121.74745, 36.84496], [-121.7469, 36.84466], [-121.74593, 36.84417], [-121.74541, 36.84398], [-121.74245, 36.84316], [-121.74376, 36.84222], [-121.7451, 36.84161], [-121.74587, 36.84195], [-121.7465, 36.84218], [-121.75028, 36.84336], [-121.75077, 36.84354], [-121.75145, 36.84385], [-121.752, 36.84416], [-121.7525, 36.8445], [-121.75297, 36.84487], [-121.75331, 36.8452], [-121.75362, 36.84554], [-121.75391, 36.8459], [-121.75416, 36.84627], [-121.75647, 36.85021], [-121.75663, 36.85053], [-121.75682, 36.85103], [-121.75693, 36.85145], [-121.75699, 36.85188], [-121.757, 36.85231], [-121.75697, 36.85274], [-121.75693, 36.853], [-121.75684, 36.85334], [-121.75626, 36.85517]]], [[[-121.75969, 36.85239], [-121.75935, 36.85301], [-121.75933, 36.85394], [-121.75959, 36.85525], [-121.75926, 36.85652], [-121.75798, 36.85705], [-121.7567, 36.85712], [-121.75607, 36.85687], [-121.75718, 36.8534], [-121.75726, 36.85304], [-121.75732, 36.85268], [-121.75734, 36.85232], [-121.75734, 36.85204], [-121.75731, 36.85168], [-121.75725, 36.85132], [-121.75718, 36.85105], [-121.75706, 36.8507], [-121.75691, 36.85035], [-121.75678, 36.8501], [-121.7544, 36.84605], [-121.7542, 36.84575], [-121.75391, 36.84538], [-121.7534, 36.84485], [-121.75303, 36.84452], [-121.75252, 36.84415], [-121.75198, 36.84381], [-121.7514, 36.8435], [-121.75092, 36.84329], [-121.75041, 36.84311], [-121.7479, 36.84232], [-121.74809, 36.84208], [-121.74953, 36.84222], [-121.75126, 36.84232], [-121.75259, 36.84252], [-121.75334, 36.84333], [-121.75392, 36.84448], [-121.75479, 36.84557], [-121.75668, 36.84662], [-121.75753, 36.84803], [-121.75837, 36.85021], [-121.75879, 36.85017], [-121.75969, 36.85239]]], [[[-121.76216, 36.84955], [-121.76219, 36.84959], [-121.76272, 36.85212], [-121.76264, 36.85447], [-121.76252, 36.85496], [-121.76202, 36.85566], [-121.76156, 36.85699], [-121.76099, 36.8575], [-121.7606, 36.85762], [-121.76029, 36.85816], [-121.75959, 36.85884], [-121.75955, 36.85886], [-121.75955, 36.85882], [-121.75891, 36.85847], [-121.75792, 36.85791], [-121.75787, 36.85792], [-121.75963, 36.85711], [-121.76072, 36.85573], [-121.7605, 36.85466], [-121.76014, 36.85351], [-121.76056, 36.85236], [-121.7613, 36.8523], [-121.76126, 36.84839], [-121.76216, 36.84955]]], [[[-121.74151, 36.85511], [-121.7415, 36.85581], [-121.74126, 36.85642], [-121.74136, 36.85705], [-121.74133, 36.85795], [-121.74095, 36.85837], [-121.74019, 36.8583], [-121.7403, 36.85954], [-121.74023, 36.85957], [-121.74013, 36.86002], [-121.7397, 36.86003], [-121.73926, 36.85991], [-121.73872, 36.85967], [-121.73627, 36.86054], [-121.73536, 36.86059], [-121.73536, 36.8606], [-121.73549, 36.86093], [-121.73438, 36.86099], [-121.73442, 36.86158], [-121.73413, 36.86166], [-121.73398, 36.8616], [-121.73274, 36.86227], [-121.73274, 36.86072], [-121.73171, 36.86077], [-121.73029, 36.8611], [-121.72905, 36.86157], [-121.72861, 36.86168], [-121.72798, 36.85719], [-121.72794, 36.85719], [-121.72857, 36.86169], [-121.72809, 36.86181], [-121.72574, 36.86198], [-121.72409, 36.86177], [-121.7228, 36.86198], [-121.7228, 36.86186], [-121.72252, 36.86153], [-121.72227, 36.86079], [-121.72209, 36.86055], [-121.72186, 36.86035], [-121.72148, 36.86018], [-121.72053, 36.86], [-121.72014, 36.86002], [-121.71885, 36.85987], [-121.7185, 36.85995], [-121.71885, 36.85585], [-121.71829, 36.85369], [-121.71575, 36.85428], [-121.71483, 36.8541], [-121.71438, 36.85333], [-121.71322, 36.85249], [-121.71296, 36.85247], [-121.71225, 36.85173], [-121.71153, 36.85024], [-121.71155, 36.84823], [-121.71136, 36.84742], [-121.71056, 36.84587], [-121.71042, 36.8459], [-121.7103, 36.84283], [-121.71237, 36.84243], [-121.71443, 36.84281], [-121.71529, 36.84282], [-121.71742, 36.84255], [-121.71811, 36.84268], [-121.71749, 36.84374], [-121.7175, 36.84375], [-121.71752, 36.84374], [-121.71815, 36.84267], [-121.72096, 36.84244], [-121.72325, 36.8434], [-121.72527, 36.84533], [-121.72567, 36.84584], [-121.72637, 36.84656], [-121.72788, 36.84563], [-121.73195, 36.84646], [-121.73126, 36.84676], [-121.73132, 36.84751], [-121.73119, 36.84809], [-121.73187, 36.84858], [-121.73107, 36.84918], [-121.7314, 36.85201], [-121.72977, 36.85553], [-121.7293, 36.85716], [-121.72932, 36.85715], [-121.72981, 36.85552], [-121.73144, 36.852], [-121.7311, 36.84917], [-121.73242, 36.85015], [-121.73714, 36.85232], [-121.737, 36.85303], [-121.7375, 36.85401], [-121.73793, 36.85398], [-121.73832, 36.85457], [-121.73854, 36.85447], [-121.73932, 36.85448], [-121.7398, 36.85478], [-121.74002, 36.85467], [-121.74123, 36.85486], [-121.74151, 36.85511]]]]} | No Public Access 3 | 15058 | Elkhorn Slough / Elkhorn Highlands | 18575 | 3019 | Elkhorn Slough Foundation 464 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.elkhornslough.org | Non Governmental Organization 10 | 3019 | Elkhorn Slough Foundation 457 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 1710.991 | Elkhorn Slough / Elkhorn Highlands | 0 | Private Conservation 16 | 2 | |
9120 | 9120 | 9119 | {"type": "MultiPolygon", "coordinates": [[[[-121.76528, 36.85045], [-121.76545, 36.8534], [-121.76489, 36.8549], [-121.76264, 36.85439], [-121.76272, 36.85211], [-121.76219, 36.84959], [-121.76127, 36.84841], [-121.7613, 36.8523], [-121.76056, 36.85236], [-121.76014, 36.85351], [-121.75969, 36.85239], [-121.76019, 36.85134], [-121.76023, 36.85075], [-121.76009, 36.85016], [-121.75912, 36.84764], [-121.75836, 36.84609], [-121.75825, 36.84599], [-121.75998, 36.84605], [-121.75999, 36.84603], [-121.75958, 36.84534], [-121.75998, 36.84473], [-121.76114, 36.84473], [-121.76224, 36.84753], [-121.76251, 36.84931], [-121.76246, 36.85041], [-121.76251, 36.85043], [-121.76528, 36.85045]]], [[[-121.75955, 36.85886], [-121.75779, 36.85956], [-121.75787, 36.85792], [-121.75791, 36.85791], [-121.75891, 36.85847], [-121.75955, 36.85883], [-121.75955, 36.85886]]], [[[-121.75486, 36.85594], [-121.75386, 36.85512], [-121.7479, 36.85532], [-121.74807, 36.85903], [-121.7498, 36.85846], [-121.74988, 36.86001], [-121.74137, 36.86206], [-121.74143, 36.86316], [-121.74036, 36.86324], [-121.74035, 36.86232], [-121.74034, 36.86231], [-121.74026, 36.86233], [-121.74013, 36.86002], [-121.74317, 36.85988], [-121.74446, 36.85972], [-121.74592, 36.85902], [-121.74694, 36.85942], [-121.74804, 36.85905], [-121.74804, 36.85903], [-121.74481, 36.8557], [-121.74475, 36.8557], [-121.74421, 36.85514], [-121.74321, 36.85587], [-121.7415, 36.85574], [-121.74151, 36.85512], [-121.74123, 36.85486], [-121.74002, 36.85467], [-121.7398, 36.85478], [-121.73931, 36.85448], [-121.73854, 36.85447], [-121.73832, 36.85458], [-121.73793, 36.85398], [-121.7375, 36.85401], [-121.737, 36.85303], [-121.73713, 36.85232], [-121.73242, 36.85015], [-121.73112, 36.84918], [-121.73111, 36.84918], [-121.73111, 36.84921], [-121.73107, 36.84918], [-121.73188, 36.84857], [-121.73517, 36.84862], [-121.73707, 36.84799], [-121.73882, 36.8477], [-121.74096, 36.84754], [-121.74189, 36.84756], [-121.74256, 36.84776], [-121.74417, 36.84774], [-121.74548, 36.84785], [-121.74618, 36.84785], [-121.74707, 36.84807], [-121.7481, 36.84805], [-121.74845, 36.84783], [-121.74879, 36.84714], [-121.74879, 36.8466], [-121.74853, 36.84602], [-121.74857, 36.84595], [-121.74893, 36.84629], [-121.74996, 36.84749], [-121.75025, 36.84779], [-121.75065, 36.84817], [-121.75207, 36.84942], [-121.7523, 36.84965], [-121.75246, 36.84988], [-121.75261, 36.85015], [-121.75271, 36.85044], [-121.75275, 36.85074], [-121.75275, 36.85122], [-121.75277, 36.85147], [-121.75284, 36.85175], [-121.75296, 36.85202], [-121.7531, 36.85225], [-121.75325, 36.85243], [-121.75445, 36.85366], [-121.75463, 36.85392], [-121.75477, 36.8542], [-121.75487, 36.85453], [-121.7549, 36.8548], [-121.75486, 36.85594]]]]} | No Public Access 3 | 15120 | Elkhorn Slough / Elkhorn Highlands | 18575 | 3019 | Elkhorn Slough Foundation 464 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.elkhornslough.org | Non Governmental Organization 10 | 3019 | Elkhorn Slough Foundation 457 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 454.678 | Elkhorn Slough / Elkhorn Highlands | 0 | Private Conservation 16 | 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]);