units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 17 and DES_TP = 8
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15583 | 15583 | 15582 | {"type": "MultiPolygon", "coordinates": [[[[-122.10851, 37.57261], [-122.10771, 37.57585], [-122.10625, 37.5766], [-122.10464, 37.57543], [-122.10395, 37.5745], [-122.10196, 37.57425], [-122.09941, 37.57655], [-122.09863, 37.57851], [-122.09762, 37.57924], [-122.09462, 37.57929], [-122.09254, 37.57957], [-122.09229, 37.57988], [-122.09018, 37.57887], [-122.0876, 37.57882], [-122.08733, 37.57871], [-122.08715, 37.57861], [-122.08711, 37.57848], [-122.08659, 37.57379], [-122.08811, 37.57303], [-122.0895, 37.57225], [-122.0909, 37.57194], [-122.09475, 37.57101], [-122.10007, 37.56978], [-122.09984, 37.56954], [-122.0984, 37.5684], [-122.09829, 37.56783], [-122.09828, 37.56764], [-122.09816, 37.56745], [-122.09814, 37.56679], [-122.09837, 37.56629], [-122.10804, 37.56921], [-122.10793, 37.5703], [-122.10798, 37.5709], [-122.10851, 37.57261]], [[-122.10599, 37.57282], [-122.10652, 37.57186], [-122.1062, 37.57085], [-122.10581, 37.57036], [-122.10544, 37.57021], [-122.10489, 37.57059], [-122.10339, 37.57152], [-122.10319, 37.57172], [-122.10294, 37.57184], [-122.10231, 37.57143], [-122.10072, 37.57013], [-122.10028, 37.56971], [-122.1001, 37.56977], [-122.1021, 37.5715], [-122.10263, 37.5719], [-122.10268, 37.57208], [-122.10269, 37.57232], [-122.1029, 37.57271], [-122.10371, 37.57344], [-122.10419, 37.57427], [-122.10453, 37.57477], [-122.10491, 37.57491], [-122.1051, 37.57517], [-122.10528, 37.57566], [-122.10553, 37.57585], [-122.10581, 37.57596], [-122.10609, 37.57582], [-122.10621, 37.5754], [-122.10603, 37.57492], [-122.10595, 37.57451], [-122.1061, 37.57367], [-122.1061, 37.57308], [-122.10599, 37.57282]]], [[[-122.15148, 37.6176], [-122.14477, 37.62002], [-122.13858, 37.62004], [-122.13441, 37.62181], [-122.133, 37.6225], [-122.12668, 37.62247], [-122.1261, 37.62264], [-122.12543, 37.62272], [-122.12285, 37.62263], [-122.12301, 37.62135], [-122.123, 37.62134], [-122.12283, 37.62133], [-122.12264, 37.62254], [-122.12243, 37.62226], [-122.11291, 37.62106], [-122.10399, 37.6184], [-122.10324, 37.61614], [-122.10325, 37.61575], [-122.10327, 37.61559], [-122.10344, 37.61525], [-122.10349, 37.61494], [-122.1038, 37.61455], [-122.10431, 37.6143], [-122.10439, 37.61408], [-122.10429, 37.61387], [-122.10417, 37.61351], [-122.10244, 37.6113], [-122.102, 37.61121], [-122.10137, 37.6116], [-122.10098, 37.61195], [-122.1005, 37.61249], [-122.10035, 37.61253], [-122.09988, 37.61253], [-122.09932, 37.61257], [-122.09774, 37.61317], [-122.09764, 37.60551], [-122.09077, 37.60542], [-122.0915, 37.60423], [-122.0922, 37.60283], [-122.0926, 37.60156], [-122.09285, 37.60006], [-122.09309, 37.59836], [-122.09308, 37.59631], [-122.09297, 37.5953], [-122.09307, 37.59489], [-122.09342, 37.59457], [-122.09399, 37.59423], [-122.09518, 37.59394], [-122.09659, 37.59393], [-122.10333, 37.59408], [-122.10452, 37.59382], [-122.10518, 37.59355], [-122.10947, 37.59105], [-122.11062, 37.59089], [-122.11214, 37.59089], [-122.11347, 37.59111], [-122.11918, 37.59279], [-122.12001, 37.59294], [-122.12238, 37.59348], [-122.12353, 37.59354], [-122.13668, 37.59328], [-122.14106, 37.59435], [-122.14735, 37.59511], [-122.14674, 37.59535], [-122.14671, 37.59606], [-122.147, 37.59668], [-122.14646, 37.59709], [-122.14641, 37.59757], [-122.14682, 37.59819], [-122.14727, 37.59827], [-122.14723, 37.59863], [-122.14719, 37.59934], [-122.14721, 37.59992], [-122.14699, 37.60028], [-122.146, 37.60088], [-122.14592, 37.60172], [-122.14593, 37.60181], [-122.14546, 37.60231], [-122.14411, 37.60384], [-122.14348, 37.60427], [-122.14224, 37.60574], [-122.142, 37.60645], [-122.14178, 37.60676], [-122.1415, 37.60684], [-122.13963, 37.60665], [-122.13758, 37.60623], [-122.13563, 37.60597], [-122.1352, 37.60601], [-122.13481, 37.60621], [-122.13457, 37.60649], [-122.13412, 37.60809], [-122.13397, 37.60873], [-122.13358, 37.60949], [-122.13323, 37.61012], [-122.13306, 37.6107], [-122.13316, 37.61116], [-122.13337, 37.61158], [-122.13359, 37.61178], [-122.13462, 37.61234], [-122.13516, 37.61256], [-122.13541, 37.6128], [-122.13546, 37.61318], [-122.13523, 37.61354], [-122.13443, 37.61395], [-122.13349, 37.61422], [-122.13195, 37.61446], [-122.1306, 37.61441], [-122.12937, 37.61444], [-122.12873, 37.61474], [-122.1281, 37.61528], [-122.12816, 37.61597], [-122.12811, 37.61666], [-122.12802, 37.61723], [-122.12767, 37.61762], [-122.12656, 37.61809], [-122.12551, 37.61839], [-122.1248, 37.61843], [-122.12444, 37.6189], [-122.12555, 37.61886], [-122.12618, 37.61853], [-122.12679, 37.6183], [-122.1275, 37.61813], [-122.12852, 37.61773], [-122.129, 37.61681], [-122.12903, 37.61612], [-122.12895, 37.61593], [-122.129, 37.61554], [-122.12923, 37.61532], [-122.13013, 37.6151], [-122.1312, 37.61504], [-122.13253, 37.61498], [-122.13434, 37.61472], [-122.13489, 37.61471], [-122.13518, 37.61458], [-122.13581, 37.61417], [-122.13626, 37.61353], [-122.13629, 37.61305], [-122.13613, 37.61255], [-122.13584, 37.61223], [-122.1348, 37.61178], [-122.13415, 37.61147], [-122.13397, 37.61126], [-122.13406, 37.61052], [-122.1348, 37.60933], [-122.13492, 37.609], [-122.13498, 37.60802], [-122.1351, 37.60727], [-122.13554, 37.60707], [-122.13611, 37.60712], [-122.13655, 37.60722], [-122.13779, 37.60777], [-122.1384, 37.60796], [-122.1406, 37.60875], [-122.14128, 37.60878], [-122.1418, 37.60858], [-122.14221, 37.60838], [-122.14247, 37.60807], [-122.14264, 37.60748], [-122.14258, 37.60746], [-122.14277, 37.60705], [-122.14261, 37.60682], [-122.14284, 37.60616], [-122.14361, 37.60509], [-122.14398, 37.6047], [-122.14497, 37.60399], [-122.14548, 37.60334], [-122.14607, 37.60278], [-122.14625, 37.60345], [-122.14638, 37.60429], [-122.14707, 37.60495], [-122.14714, 37.60553], [-122.14711, 37.60619], [-122.1474, 37.6065], [-122.14663, 37.60674], [-122.14747, 37.60737], [-122.14836, 37.61021], [-122.14903, 37.61482], [-122.15005, 37.61634], [-122.15109, 37.61696], [-122.15148, 37.6176]]], [[[-122.09165, 37.59228], [-122.09115, 37.5923], [-122.09117, 37.59121], [-122.09161, 37.59183], [-122.09165, 37.59193], [-122.09167, 37.59204], [-122.09165, 37.59228]]], [[[-122.14755, 37.59403], [-122.14079, 37.59318], [-122.13633, 37.5922], [-122.12605, 37.59215], [-122.12243, 37.59219], [-122.12073, 37.59197], [-122.11607, 37.59085], [-122.11342, 37.5901], [-122.11224, 37.58978], [-122.11106, 37.5897], [-122.10978, 37.58983], [-122.10872, 37.59007], [-122.10394, 37.59271], [-122.10362, 37.59287], [-122.10318, 37.59301], [-122.10283, 37.59309], [-122.09481, 37.59278], [-122.09394, 37.59292], [-122.09237, 37.59362], [-122.09202, 37.59328], [-122.09204, 37.59255], [-122.09202, 37.59163], [-122.09154, 37.59163], [-122.09165, 37.58494], [-122.09638, 37.58317], [-122.09587, 37.58037], [-122.09789, 37.58016], [-122.09885, 37.5799], [-122.09952, 37.57936], [-122.10127, 37.57589], [-122.10184, 37.57552], [-122.10219, 37.57534], [-122.10256, 37.57533], [-122.10302, 37.57549], [-122.10322, 37.5757], [-122.10291, 37.57998], [-122.10433, 37.58178], [-122.10715, 37.58098], [-122.11424, 37.5734], [-122.11863, 37.57426], [-122.11909, 37.57431], [-122.11965, 37.57432], [-122.12546, 37.57341], [-122.12904, 37.57119], [-122.13395, 37.56663], [-122.1434, 37.58219], [-122.14539, 37.58277], [-122.14739, 37.58484], [-122.14755, 37.59403]]], [[[-122.13425, 37.62343], [-122.13425, 37.62343], [-122.13143, 37.62438], [-122.13185, 37.62338], [-122.13273, 37.62282], [-122.13425, 37.62343]]]]} | Open Access 1 | 9456 | Eden Landing Ecological Reserve | 32155 | 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/Eden-Landing-ER | Alameda 17 | 5803.055 | Eden Landing ER | 1998 | 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]);