units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 2, AGNCY_TYP = 1, DES_TP = 1 and GAP_STS = 3
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3760 | 3760 | 3759 | {"type": "Polygon", "coordinates": [[[-122.95962, 40.7165], [-122.95894, 40.72369], [-122.9584, 40.7272], [-122.95072, 40.72738], [-122.95056, 40.72704], [-122.94975, 40.72649], [-122.94961, 40.72632], [-122.94959, 40.72551], [-122.94491, 40.7255], [-122.94491, 40.72367], [-122.94258, 40.72366], [-122.94259, 40.72273], [-122.94025, 40.72272], [-122.94025, 40.72217], [-122.93902, 40.7227], [-122.939, 40.72267], [-122.93668, 40.72369], [-122.93688, 40.71878], [-122.93878, 40.71586], [-122.93907, 40.71613], [-122.94039, 40.71613], [-122.94432, 40.7162], [-122.95236, 40.71632], [-122.95962, 40.7165]]]} | Restricted Access 2 | 34904 | BLM | 16163 | 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 | Trinity 46 | 463.82 | BLM | 1963 | National Public Lands 1 | 3 | |
3763 | 3763 | 3762 | {"type": "Polygon", "coordinates": [[[-117.39664, 35.73738], [-117.39548, 35.74101], [-117.39454, 35.74102], [-117.39455, 35.74394], [-117.39429, 35.74463], [-117.39234, 35.74464], [-117.39228, 35.74751], [-117.39124, 35.74826], [-117.39002, 35.74841], [-117.38789, 35.74939], [-117.38787, 35.74825], [-117.38344, 35.74826], [-117.38344, 35.75187], [-117.37899, 35.75187], [-117.37899, 35.74464], [-117.38353, 35.74464], [-117.38353, 35.74102], [-117.38788, 35.74101], [-117.38788, 35.73739], [-117.39664, 35.73738]]]} | Restricted Access 2 | 34925 | BLM | 16163 | 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 | San Bernardino 22 | 334.438 | BLM | 1963 | National Public Lands 1 | 3 | |
4144 | 4144 | 4143 | {"type": "Polygon", "coordinates": [[[-122.46384, 39.38383], [-122.45881, 39.38384], [-122.4585, 39.38043], [-122.46379, 39.38038], [-122.46384, 39.38383]]]} | Restricted Access 2 | 47499 | BLM | 16163 | 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 | Colusa 49 | 41.777 | BLM | 1963 | National Public Lands 1 | 3 | |
5580 | 5580 | 5579 | {"type": "Polygon", "coordinates": [[[-121.95567, 37.92322], [-121.95099, 37.92324], [-121.9509, 37.91961], [-121.95562, 37.91959], [-121.95567, 37.92322]]]} | Restricted Access 2 | 29557 | BLM | 16163 | 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 | Contra Costa 12 | 41.201 | BLM | 1963 | National Public Lands 1 | 3 | |
11182 | 11182 | 11181 | {"type": "MultiPolygon", "coordinates": [[[[-122.1646, 39.75799], [-122.16445, 39.7616], [-122.16182, 39.76157], [-122.15957, 39.76157], [-122.15966, 39.75983], [-122.15944, 39.75788], [-122.16324, 39.75792], [-122.1646, 39.75799]]], [[[-122.22022, 39.77673], [-122.22017, 39.78034], [-122.21557, 39.78029], [-122.21553, 39.77668], [-122.22022, 39.77673]]], [[[-122.32796, 39.39913], [-122.3233, 39.39915], [-122.32318, 39.39219], [-122.32786, 39.39215], [-122.32796, 39.39913]]], [[[-122.44682, 39.49066], [-122.44201, 39.49066], [-122.44196, 39.48701], [-122.44676, 39.48701], [-122.44682, 39.49066]]], [[[-122.47449, 39.41647], [-122.47428, 39.42005], [-122.47423, 39.43573], [-122.47424, 39.44169], [-122.46972, 39.44165], [-122.46954, 39.44148], [-122.4696, 39.43437], [-122.46016, 39.43508], [-122.45966, 39.42802], [-122.45902, 39.42438], [-122.45382, 39.42443], [-122.45339, 39.42079], [-122.4591, 39.42054], [-122.45911, 39.41686], [-122.4591, 39.41685], [-122.45347, 39.41699], [-122.45338, 39.40587], [-122.45331, 39.40583], [-122.45328, 39.4024], [-122.45183, 39.4023], [-122.45182, 39.40231], [-122.44821, 39.40234], [-122.44808, 39.39874], [-122.44355, 39.39869], [-122.44372, 39.39139], [-122.44692, 39.39142], [-122.44725, 39.38407], [-122.4473, 39.38406], [-122.4472, 39.38393], [-122.45099, 39.38399], [-122.45882, 39.38397], [-122.45881, 39.38384], [-122.46383, 39.38383], [-122.46406, 39.40553], [-122.46415, 39.40913], [-122.46969, 39.40894], [-122.46969, 39.40931], [-122.4697, 39.40944], [-122.4697, 39.41637], [-122.47423, 39.41644], [-122.47424, 39.41646], [-122.47449, 39.41647]]], [[[-122.47411, 39.44842], [-122.47408, 39.44843], [-122.47409, 39.44854], [-122.47395, 39.44888], [-122.4739, 39.45054], [-122.4696, 39.45055], [-122.46956, 39.44879], [-122.46954, 39.44511], [-122.47411, 39.44517], [-122.47411, 39.44842]]], [[[-122.47452, 39.39851], [-122.47451, 39.40208], [-122.4701, 39.40204], [-122.46977, 39.40208], [-122.46984, 39.39842], [-122.47014, 39.39845], [-122.47452, 39.39851]]], [[[-122.49255, 39.43829], [-122.49251, 39.44913], [-122.48796, 39.44909], [-122.48801, 39.4461], [-122.48818, 39.4461], [-122.48821, 39.43911], [-122.48969, 39.4385], [-122.49057, 39.43796], [-122.49208, 39.43782], [-122.49248, 39.43757], [-122.49248, 39.43828], [-122.49255, 39.43829]]], [[[-122.49248, 39.43738], [-122.49205, 39.43768], [-122.49185, 39.43768], [-122.49049, 39.4378], [-122.48954, 39.43838], [-122.48895, 39.43868], [-122.48827, 39.43892], [-122.4884, 39.43469], [-122.49247, 39.43476], [-122.49248, 39.43738]]], [[[-122.49535, 39.52955], [-122.49043, 39.52997], [-122.48854, 39.5234], [-122.49324, 39.5231], [-122.49535, 39.52955]]], [[[-122.50277, 39.57036], [-122.50165, 39.5704], [-122.50164, 39.57042], [-122.49808, 39.57047], [-122.49799, 39.56647], [-122.50263, 39.56654], [-122.50277, 39.57036]]], [[[-122.5029, 39.58858], [-122.49833, 39.5886], [-122.4983, 39.58502], [-122.50284, 39.58495], [-122.5029, 39.58858]]], [[[-122.50742, 39.57752], [-122.50741, 39.58113], [-122.50291, 39.58118], [-122.50279, 39.57764], [-122.50742, 39.57752]]], [[[-122.51816, 39.43183], [-122.51808, 39.43541], [-122.51028, 39.43512], [-122.51031, 39.42805], [-122.51419, 39.42803], [-122.51423, 39.43163], [-122.51816, 39.43183]]], [[[-122.51655, 39.60657], [-122.5119, 39.6066], [-122.51172, 39.60295], [-122.51645, 39.60292], [-122.51655, 39.60657]]], [[[-122.51977, 39.41379], [-122.51972, 39.421], [-122.51571, 39.42085], [-122.51572, 39.41366], [-122.51977, 39.41379]]], [[[-122.51987, 39.39939], [-122.5158, 39.39919], [-122.51584, 39.39176], [-122.51982, 39.39197], [-122.51987, 39.39939]]], [[[-122.5628, 39.51771], [-122.55827, 39.5177], [-122.55822, 39.51056], [-122.56266, 39.51055], [-122.5628, 39.51771]]], [[[-122.56321, 39.55891], [-122.5632, 39.56262], [-122.55855, 39.5626], [-122.55856, 39.55893], [-122.56321, 39.55891]]], [[[-122.56775, 39.55532], [-122.56306, 39.55536], [-122.56303, 39.55173], [-122.56771, 39.55169], [-122.56775, 39.55532]]], [[[-122.58225, 39.53707], [-122.58223, 39.53753], [-122.58221, 39.5407], [-122.57748, 39.54075], [-122.57751, 39.53712], [-122.57266, 39.53719], [-122.57282, 39.53705], [-122.5728, 39.5366], [-122.57274, 39.5364], [-122.57262, 39.53617], [-122.57282, 39.53601], [-122.57294, 39.53585], [-122.57298, 39.53577], [-122.5768, 39.53609], [-122.58162, 39.53613], [-122.58224, 39.53706], [-122.58225, 39.53707]]], [[[-122.57746, 39.54441], [-122.57744, 39.54796], [-122.5727, 39.548], [-122.57273, 39.54439], [-122.57746, 39.54441]]], [[[-122.59174, 39.71995], [-122.58962, 39.71997], [-122.58981, 39.72721], [-122.58736, 39.72723], [-122.58776, 39.74186], [-122.58786, 39.75022], [-122.58801, 39.7561], [-122.57835, 39.75612], [-122.5779, 39.74174], [-122.5735, 39.74169], [-122.57363, 39.73446], [-122.57837, 39.73452], [-122.57833, 39.73094], [-122.57369, 39.73089], [-122.57369, 39.72982], [-122.57362, 39.72364], [-122.5783, 39.72366], [-122.57828, 39.71992], [-122.58276, 39.71993], [-122.58281, 39.71263], [-122.58324, 39.71262], [-122.58347, 39.70429], [-122.58806, 39.70369], [-122.58849, 39.68822], [-122.5901, 39.68813], [-122.59012, 39.69564], [-122.58999, 39.70345], [-122.58989, 39.7126], [-122.5899, 39.71261], [-122.59154, 39.71261], [-122.59174, 39.71995]]], [[[-122.5874, 39.59871], [-122.58738, 39.60237], [-122.58257, 39.60241], [-122.5825, 39.59877], [-122.5874, 39.59871]]], [[[-122.58919, 39.62838], [-122.58286, 39.62841], [-122.58281, 39.62486], [-122.5879, 39.62486], [-122.58915, 39.62483], [-122.58919, 39.62838]]], [[[-122.5901, 39.66765], [-122.58977, 39.66765], [-122.58976, 39.66766], [-122.58984, 39.67119], [-122.58988, 39.6712], [-122.58986, 39.67448], [-122.5899, 39.67454], [-122.58993, 39.67481], [-122.59002, 39.67481], [-122.58996, 39.67484], [-122.58999, 39.67829], [-122.58996, 39.6783], [-122.59006, 39.68178], [-122.59008, 39.68513], [-122.58855, 39.6854], [-122.58835, 39.66767], [-122.58999, 39.66759], [-122.5901, 39.66765]]], [[[-122.61522, 39.53729], [-122.6152, 39.54066], [-122.61027, 39.54064], [-122.61038, 39.53729], [-122.61522, 39.53729]]]]} | Restricted Access 2 | 21454 | BLM | 16163 | 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 | Glenn 55 | 4738.203 | BLM | 1963 | National Public Lands 1 | 3 | |
13036 | 13036 | 13035 | {"type": "MultiPolygon", "coordinates": [[[[-120.89266, 38.89126], [-120.89257, 38.89479], [-120.89056, 38.89479], [-120.89053, 38.89645], [-120.89055, 38.8965], [-120.89052, 38.89651], [-120.89051, 38.89665], [-120.89026, 38.89606], [-120.88994, 38.89557], [-120.8897, 38.89539], [-120.8902, 38.89507], [-120.8902, 38.89505], [-120.88701, 38.89192], [-120.8863, 38.89232], [-120.88538, 38.89288], [-120.88669, 38.89416], [-120.88634, 38.89408], [-120.88574, 38.89398], [-120.88504, 38.89384], [-120.88368, 38.89339], [-120.88316, 38.89325], [-120.88272, 38.89324], [-120.88239, 38.89325], [-120.88173, 38.89342], [-120.88175, 38.89109], [-120.88161, 38.88749], [-120.88598, 38.88758], [-120.88601, 38.88811], [-120.88448, 38.8884], [-120.88543, 38.89022], [-120.88525, 38.89116], [-120.88723, 38.89118], [-120.8875, 38.89026], [-120.89055, 38.89032], [-120.89056, 38.89124], [-120.89266, 38.89126]]], [[[-120.89052, 38.89708], [-120.8905, 38.89832], [-120.88629, 38.89826], [-120.88628, 38.8948], [-120.88172, 38.89471], [-120.88173, 38.89359], [-120.88261, 38.89353], [-120.88289, 38.89353], [-120.88321, 38.89357], [-120.88468, 38.89404], [-120.88557, 38.89425], [-120.88708, 38.89452], [-120.88862, 38.89603], [-120.88939, 38.89557], [-120.88966, 38.89576], [-120.89001, 38.89629], [-120.89025, 38.8967], [-120.89052, 38.89708]]], [[[-120.90802, 38.89769], [-120.90801, 38.8995], [-120.90421, 38.90102], [-120.90182, 38.89809], [-120.89949, 38.89818], [-120.89948, 38.89819], [-120.90211, 38.9014], [-120.90057, 38.90137], [-120.89993, 38.90132], [-120.89957, 38.90128], [-120.8991, 38.90119], [-120.89758, 38.90074], [-120.89596, 38.90018], [-120.89767, 38.90006], [-120.89943, 38.89996], [-120.89948, 38.89911], [-120.89947, 38.89808], [-120.90172, 38.89795], [-120.90373, 38.89788], [-120.90802, 38.89769]]], [[[-120.908, 38.89979], [-120.90797, 38.90135], [-120.90794, 38.90478], [-120.90656, 38.90475], [-120.90316, 38.90188], [-120.90172, 38.90292], [-120.90342, 38.90439], [-120.90344, 38.90474], [-120.90345, 38.90756], [-120.90024, 38.90617], [-120.89942, 38.90698], [-120.89945, 38.90553], [-120.89607, 38.90576], [-120.89515, 38.90581], [-120.89522, 38.90208], [-120.89524, 38.90015], [-120.89592, 38.90046], [-120.89747, 38.90106], [-120.89842, 38.90136], [-120.89937, 38.90157], [-120.90043, 38.90171], [-120.90143, 38.90177], [-120.90226, 38.90178], [-120.90291, 38.90174], [-120.90321, 38.90174], [-120.90373, 38.90161], [-120.90439, 38.90138], [-120.90532, 38.90099], [-120.90561, 38.90082], [-120.908, 38.89979]]]]} | Restricted Access 2 | 34872 | BLM | 16163 | 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 | El Dorado 34 | 313.299 | BLM | 1963 | National Public Lands 1 | 3 | |
13037 | 13037 | 13036 | {"type": "MultiPolygon", "coordinates": [[[[-120.91216, 38.91541], [-120.91209, 38.91725], [-120.90299, 38.9179], [-120.90314, 38.91614], [-120.91216, 38.91541]]], [[[-120.91554, 38.91278], [-120.91489, 38.9134], [-120.91489, 38.91518], [-120.91293, 38.91536], [-120.9126, 38.91537], [-120.91264, 38.91385], [-120.91256, 38.91389], [-120.90898, 38.91085], [-120.908, 38.91025], [-120.90805, 38.90805], [-120.91228, 38.90808], [-120.9148, 38.90807], [-120.91488, 38.91165], [-120.91488, 38.91253], [-120.9149, 38.91254], [-120.91511, 38.91239], [-120.91554, 38.91278]]]]} | Restricted Access 2 | 34873 | BLM | 16163 | 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 | El Dorado 34 | 121.211 | BLM | 1963 | National Public Lands 1 | 3 | |
13054 | 13054 | 13053 | {"type": "Polygon", "coordinates": [[[-122.17843, 39.75789], [-122.17369, 39.75785], [-122.17368, 39.75452], [-122.17834, 39.75457], [-122.17843, 39.75789]]]} | Restricted Access 2 | 34910 | BLM | 16163 | 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 | Glenn 55 | 36.703 | BLM | 1963 | National Public Lands 1 | 3 | |
13056 | 13056 | 13055 | {"type": "Polygon", "coordinates": [[[-116.45767, 33.96133], [-116.44054, 33.96104], [-116.44043, 33.94685], [-116.44884, 33.94684], [-116.44926, 33.95001], [-116.45349, 33.95007], [-116.45355, 33.94677], [-116.45738, 33.94676], [-116.45767, 33.96133]]]} | Restricted Access 2 | 34913 | BLM | 16163 | 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 | Riverside 10 | 583.754 | BLM | 1963 | 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]);