units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 48 and DES_TP = 1
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11249 | 11249 | 11248 | {"type": "MultiPolygon", "coordinates": [[[[-119.52826, 37.16345], [-119.52821, 37.16701], [-119.52375, 37.16695], [-119.52377, 37.16344], [-119.52826, 37.16345]]], [[[-119.53282, 37.13508], [-119.53274, 37.14124], [-119.52837, 37.14127], [-119.52834, 37.14819], [-119.52384, 37.14811], [-119.52392, 37.13028], [-119.52388, 37.12887], [-119.52387, 37.12886], [-119.52386, 37.12887], [-119.52388, 37.12798], [-119.52432, 37.12785], [-119.52486, 37.12758], [-119.52512, 37.12758], [-119.52575, 37.12788], [-119.52755, 37.12886], [-119.52757, 37.12897], [-119.52794, 37.12926], [-119.52822, 37.1295], [-119.52874, 37.12968], [-119.52894, 37.1298], [-119.5289, 37.13507], [-119.53282, 37.13508]]], [[[-119.53723, 37.1442], [-119.5372, 37.14808], [-119.53273, 37.1481], [-119.53274, 37.14423], [-119.53723, 37.1442]]], [[[-119.61692, 37.30088], [-119.61691, 37.30384], [-119.61553, 37.30385], [-119.61553, 37.30089], [-119.61692, 37.30088]]], [[[-119.62369, 37.17656], [-119.62196, 37.18051], [-119.62002, 37.18013], [-119.62165, 37.17615], [-119.62369, 37.17656]]], [[[-119.65408, 37.23158], [-119.65265, 37.23286], [-119.64805, 37.23058], [-119.64409, 37.22798], [-119.64094, 37.22618], [-119.64094, 37.22419], [-119.64403, 37.22585], [-119.6455, 37.22679], [-119.64741, 37.22813], [-119.64764, 37.22814], [-119.64925, 37.22923], [-119.65408, 37.23158]]], [[[-119.65213, 37.38486], [-119.65203, 37.38827], [-119.65007, 37.3883], [-119.65006, 37.38665], [-119.64777, 37.38665], [-119.64779, 37.38485], [-119.65213, 37.38486]]], [[[-119.66698, 37.23784], [-119.66552, 37.23913], [-119.66411, 37.23866], [-119.66077, 37.23777], [-119.66205, 37.23659], [-119.6641, 37.23708], [-119.66698, 37.23784]]], [[[-119.67289, 37.12264], [-119.6728, 37.1261], [-119.6636, 37.12641], [-119.66359, 37.12292], [-119.67289, 37.12264]]], [[[-119.68136, 37.32282], [-119.67235, 37.32283], [-119.67228, 37.31894], [-119.68134, 37.31893], [-119.68136, 37.32282]]], [[[-119.69249, 37.19337], [-119.68877, 37.19651], [-119.68553, 37.19383], [-119.6841, 37.19418], [-119.68249, 37.19032], [-119.68434, 37.18983], [-119.68595, 37.19348], [-119.68957, 37.19077], [-119.69249, 37.19337]]], [[[-119.69606, 37.28801], [-119.69556, 37.28959], [-119.69345, 37.28787], [-119.69295, 37.28901], [-119.68909, 37.28714], [-119.68965, 37.28598], [-119.69078, 37.28598], [-119.69079, 37.28597], [-119.68799, 37.28416], [-119.68554, 37.2816], [-119.68677, 37.28036], [-119.68938, 37.28261], [-119.68938, 37.28283], [-119.69274, 37.2852], [-119.69606, 37.28801]]], [[[-119.70237, 37.40995], [-119.68838, 37.4102], [-119.68852, 37.40277], [-119.70223, 37.40276], [-119.70237, 37.40995]]], [[[-119.69837, 37.3739], [-119.69797, 37.38477], [-119.69338, 37.38475], [-119.6937, 37.37392], [-119.69837, 37.3739]]], [[[-119.7123, 37.27216], [-119.71149, 37.27492], [-119.71083, 37.276], [-119.71093, 37.27216], [-119.7123, 37.27216]]], [[[-119.71769, 37.28894], [-119.7176, 37.29195], [-119.71651, 37.29032], [-119.71467, 37.29146], [-119.71177, 37.28873], [-119.71372, 37.28757], [-119.71317, 37.28691], [-119.71323, 37.2838], [-119.71476, 37.28578], [-119.7175, 37.28862], [-119.71769, 37.28894]]], [[[-119.71451, 37.26594], [-119.71473, 37.26741], [-119.71385, 37.27063], [-119.71331, 37.27086], [-119.71333, 37.26734], [-119.71451, 37.26594]]], [[[-119.73125, 37.30848], [-119.73124, 37.31027], [-119.72669, 37.31027], [-119.72669, 37.30847], [-119.73125, 37.30848]]], [[[-119.7528, 37.3485], [-119.75249, 37.34857], [-119.7516, 37.34894], [-119.75098, 37.34907], [-119.74989, 37.3492], [-119.7497, 37.34926], [-119.74891, 37.34965], [-119.74863, 37.34975], [-119.74855, 37.34977], [-119.74765, 37.34973], [-119.74726, 37.3498], [-119.74687, 37.34992], [-119.74583, 37.3505], [-119.74514, 37.35077], [-119.74508, 37.3508], [-119.745, 37.35082], [-119.74381, 37.35122], [-119.74384, 37.34446], [-119.75274, 37.34476], [-119.7528, 37.3485]]], [[[-119.75281, 37.35211], [-119.74382, 37.35194], [-119.74381, 37.35139], [-119.74506, 37.35097], [-119.74517, 37.35096], [-119.74525, 37.35091], [-119.74594, 37.35065], [-119.74696, 37.35007], [-119.74732, 37.34996], [-119.74767, 37.3499], [-119.74857, 37.34993], [-119.74869, 37.3499], [-119.74884, 37.34987], [-119.74901, 37.3498], [-119.74979, 37.34941], [-119.74994, 37.34936], [-119.75102, 37.34923], [-119.75168, 37.3491], [-119.75256, 37.34872], [-119.7528, 37.34867], [-119.75281, 37.35211]]], [[[-119.7723, 37.12716], [-119.7684, 37.12984], [-119.76618, 37.13076], [-119.76363, 37.13403], [-119.763, 37.1357], [-119.76311, 37.13715], [-119.76253, 37.13715], [-119.7623, 37.13738], [-119.76153, 37.13655], [-119.76265, 37.13346], [-119.76552, 37.13006], [-119.7661, 37.12979], [-119.76763, 37.12976], [-119.76764, 37.12905], [-119.77139, 37.12643], [-119.7723, 37.12716]]], [[[-119.77507, 37.37408], [-119.77495, 37.3812], [-119.77063, 37.38122], [-119.77069, 37.37407], [-119.77507, 37.37408]], [[-119.7735, 37.37495], [-119.77157, 37.37494], [-119.77174, 37.37884], [-119.77365, 37.37886], [-119.7735, 37.37495]]], [[[-119.92056, 37.14103], [-119.91579, 37.14105], [-119.91589, 37.14031], [-119.91608, 37.13996], [-119.91642, 37.13958], [-119.91662, 37.1389], [-119.91702, 37.13777], [-119.91716, 37.13727], [-119.92054, 37.13728], [-119.92056, 37.14103]]], [[[-119.91689, 37.13727], [-119.91676, 37.13771], [-119.91636, 37.13885], [-119.91614, 37.13957], [-119.91615, 37.13724], [-119.91689, 37.13727]]], [[[-119.99311, 37.1845], [-119.99304, 37.18767], [-119.99145, 37.18527], [-119.99002, 37.18599], [-119.99125, 37.18798], [-119.98868, 37.18798], [-119.98869, 37.18448], [-119.99311, 37.1845]]]]} | Open Access 1 | 21630 | BLM | 16162 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Madera 48 | 1586.685 | BLM | 1899 | National Public Lands 1 | 3 | |
| 13010 | 13010 | 13009 | {"type": "MultiPolygon", "coordinates": [[[[-119.57776, 37.08324], [-119.57335, 37.08293], [-119.57341, 37.09006], [-119.56427, 37.08996], [-119.56419, 37.09714], [-119.5693, 37.09728], [-119.57331, 37.09731], [-119.5733, 37.1009], [-119.56937, 37.10089], [-119.56935, 37.10261], [-119.56943, 37.11188], [-119.55581, 37.11186], [-119.55575, 37.11541], [-119.55576, 37.11542], [-119.56478, 37.11541], [-119.56478, 37.1157], [-119.56399, 37.11562], [-119.5632, 37.11559], [-119.56255, 37.11563], [-119.56109, 37.11566], [-119.56028, 37.11575], [-119.55989, 37.11574], [-119.5586, 37.11557], [-119.55677, 37.1155], [-119.55635, 37.1155], [-119.55536, 37.11557], [-119.55483, 37.11568], [-119.55385, 37.11593], [-119.55345, 37.1161], [-119.55303, 37.1163], [-119.55264, 37.11659], [-119.55231, 37.11679], [-119.55196, 37.11695], [-119.55162, 37.11707], [-119.5513, 37.11714], [-119.55097, 37.1172], [-119.55049, 37.11718], [-119.54985, 37.11708], [-119.54927, 37.11696], [-119.54868, 37.11682], [-119.5482, 37.11665], [-119.54724, 37.11608], [-119.54673, 37.11567], [-119.54635, 37.1153], [-119.5456, 37.11445], [-119.54524, 37.11409], [-119.54491, 37.11365], [-119.54437, 37.11266], [-119.54375, 37.11185], [-119.54345, 37.1116], [-119.54304, 37.11121], [-119.54226, 37.11074], [-119.54226, 37.10789], [-119.538, 37.10783], [-119.53793, 37.10385], [-119.53868, 37.10183], [-119.53887, 37.10142], [-119.53897, 37.101], [-119.53902, 37.10075], [-119.53948, 37.09929], [-119.54106, 37.09641], [-119.54269, 37.09534], [-119.54609, 37.09512], [-119.54727, 37.09488], [-119.5482, 37.09452], [-119.54868, 37.09438], [-119.54962, 37.09404], [-119.54991, 37.09394], [-119.55182, 37.09316], [-119.55301, 37.09265], [-119.55452, 37.0919], [-119.5557, 37.09082], [-119.55776, 37.08927], [-119.55894, 37.08817], [-119.5595, 37.08662], [-119.55976, 37.08463], [-119.55981, 37.08323], [-119.56055, 37.08156], [-119.56118, 37.07955], [-119.56182, 37.07765], [-119.5627, 37.07654], [-119.56334, 37.07505], [-119.56334, 37.07405], [-119.5628, 37.07323], [-119.56124, 37.07194], [-119.56133, 37.07164], [-119.56119, 37.07128], [-119.56096, 37.07107], [-119.56099, 37.07034], [-119.56201, 37.06942], [-119.56236, 37.06896], [-119.56241, 37.0686], [-119.56216, 37.06684], [-119.5619, 37.06617], [-119.56182, 37.06572], [-119.56193, 37.06544], [-119.5623, 37.06503], [-119.56404, 37.06452], [-119.56887, 37.06425], [-119.57075, 37.06448], [-119.5709, 37.06436], [-119.57135, 37.06437], [-119.57375, 37.06514], [-119.57546, 37.06537], [-119.57581, 37.06569], [-119.57774, 37.07953], [-119.57776, 37.08324]], [[-119.55108, 37.11543], [-119.55109, 37.11542], [-119.55092, 37.11185], [-119.54678, 37.11184], [-119.54674, 37.11538], [-119.55108, 37.11543]]], [[[-119.60095, 37.08506], [-119.59645, 37.08506], [-119.59645, 37.08329], [-119.60094, 37.08328], [-119.60095, 37.08506]]], [[[-119.60835, 37.07603], [-119.60546, 37.07857], [-119.60401, 37.0777], [-119.60599, 37.07603], [-119.60835, 37.07603]]]]} | Open Access 1 | 31044 | BLM | 16162 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Madera 48 | 2388.269 | BLM | 1899 | National Public Lands 1 | 3 |
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]);