units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, MNG_AGENCY = 1, MNG_AG_TYP = 1 and UNIT_NAME = "Big Morongo Canyon Preserve"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11451 | 11451 | 11450 | {"type": "MultiPolygon", "coordinates": [[[[-116.59234, 34.03268], [-116.5923, 34.0347], [-116.59123, 34.03474], [-116.59115, 34.03652], [-116.58466, 34.03678], [-116.58481, 34.03853], [-116.5809, 34.0386], [-116.58091, 34.04038], [-116.57644, 34.04023], [-116.57642, 34.04155], [-116.57328, 34.04159], [-116.57, 34.04162], [-116.56986, 34.04692], [-116.56352, 34.04691], [-116.56354, 34.05456], [-116.55475, 34.05448], [-116.55492, 34.05811], [-116.56122, 34.05806], [-116.56128, 34.05923], [-116.55487, 34.0591], [-116.55488, 34.0601], [-116.55259, 34.06009], [-116.55251, 34.0614], [-116.5501, 34.0614], [-116.54994, 34.06339], [-116.54835, 34.06346], [-116.54828, 34.06424], [-116.54626, 34.06421], [-116.54624, 34.06519], [-116.53262, 34.06536], [-116.53247, 34.07285], [-116.51983, 34.07282], [-116.51988, 34.06964], [-116.51517, 34.06958], [-116.51515, 34.07569], [-116.51343, 34.0757], [-116.51333, 34.07759], [-116.51126, 34.07747], [-116.51124, 34.07925], [-116.50641, 34.07913], [-116.50655, 34.08834], [-116.50548, 34.08832], [-116.50565, 34.09019], [-116.49264, 34.09016], [-116.49274, 34.09717], [-116.49033, 34.09701], [-116.4903, 34.09914], [-116.49031, 34.09915], [-116.49276, 34.09914], [-116.49281, 34.1027], [-116.49049, 34.10282], [-116.49064, 34.10459], [-116.48031, 34.1046], [-116.48035, 34.10279], [-116.48167, 34.10281], [-116.48147, 34.10097], [-116.48384, 34.10094], [-116.48374, 34.09934], [-116.48492, 34.09922], [-116.48503, 34.10082], [-116.48684, 34.10087], [-116.48689, 34.0955], [-116.48821, 34.09556], [-116.48805, 34.09156], [-116.49033, 34.09162], [-116.49023, 34.09017], [-116.49264, 34.09015], [-116.49279, 34.07579], [-116.49276, 34.07578], [-116.49276, 34.07564], [-116.47486, 34.07595], [-116.45762, 34.07597], [-116.45749, 34.04727], [-116.45702, 34.03291], [-116.47522, 34.03278], [-116.49258, 34.03289], [-116.4927, 34.03289], [-116.49271, 34.03282], [-116.50153, 34.03285], [-116.50154, 34.03287], [-116.5104, 34.03285], [-116.51135, 34.03285], [-116.51135, 34.0331], [-116.5124, 34.03294], [-116.5902, 34.03278], [-116.59234, 34.03268]], [[-116.49261, 34.06174], [-116.49262, 34.06173], [-116.49247, 34.04721], [-116.48377, 34.04722], [-116.48374, 34.06177], [-116.49261, 34.06174]]], [[[-116.52859, 34.13276], [-116.52407, 34.13273], [-116.52413, 34.13143], [-116.52327, 34.13146], [-116.52251, 34.12986], [-116.52392, 34.12954], [-116.52402, 34.12872], [-116.51927, 34.12869], [-116.51926, 34.1287], [-116.51951, 34.1302], [-116.51394, 34.13273], [-116.51117, 34.13274], [-116.51124, 34.1208], [-116.49298, 34.12073], [-116.49296, 34.11736], [-116.49486, 34.11749], [-116.49488, 34.11668], [-116.49809, 34.11667], [-116.49814, 34.11471], [-116.49949, 34.11475], [-116.4995, 34.11474], [-116.4994, 34.11285], [-116.49293, 34.11273], [-116.49285, 34.10822], [-116.49684, 34.10815], [-116.4972, 34.1046], [-116.50082, 34.10465], [-116.50082, 34.10624], [-116.50349, 34.10627], [-116.50381, 34.10466], [-116.51143, 34.10466], [-116.51113, 34.11831], [-116.51416, 34.11832], [-116.51433, 34.11849], [-116.51481, 34.11846], [-116.51518, 34.11852], [-116.51538, 34.11911], [-116.51572, 34.11928], [-116.51629, 34.11937], [-116.51724, 34.11932], [-116.51779, 34.11912], [-116.5186, 34.11946], [-116.5186, 34.11969], [-116.5188, 34.12005], [-116.51931, 34.12023], [-116.51985, 34.12026], [-116.52008, 34.12043], [-116.52049, 34.12068], [-116.52062, 34.12082], [-116.52092, 34.12108], [-116.5212, 34.12105], [-116.52187, 34.12102], [-116.52204, 34.12125], [-116.52225, 34.12142], [-116.52343, 34.12171], [-116.52377, 34.12199], [-116.52421, 34.12219], [-116.52451, 34.12242], [-116.52468, 34.12267], [-116.52475, 34.12301], [-116.52512, 34.12318], [-116.52566, 34.12324], [-116.52613, 34.12392], [-116.52681, 34.12431], [-116.52735, 34.12446], [-116.52792, 34.12446], [-116.52802, 34.12457], [-116.52858, 34.1249], [-116.52859, 34.13276]], [[-116.50294, 34.11678], [-116.50298, 34.11475], [-116.50159, 34.11474], [-116.50156, 34.11287], [-116.50032, 34.11286], [-116.50047, 34.11673], [-116.50294, 34.11678]]]]} | Open Access 1 | 23057 | Big Morongo Canyon Preserve | 16082 | 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 | 12367.553 | Big Morongo Canyon Preserve | None 1017 | |||
11485 | 11485 | 11484 | {"type": "Polygon", "coordinates": [[[-116.5984, 34.03271], [-116.59234, 34.03268], [-116.5902, 34.03278], [-116.5124, 34.03294], [-116.51134, 34.0331], [-116.51134, 34.03285], [-116.5104, 34.03285], [-116.50153, 34.03287], [-116.50152, 34.03285], [-116.49272, 34.03282], [-116.4927, 34.03289], [-116.49258, 34.03289], [-116.47522, 34.03278], [-116.45702, 34.03291], [-116.45772, 34.01817], [-116.45778, 34.01446], [-116.45803, 34.00359], [-116.45803, 34.00345], [-116.45798, 34.00344], [-116.45801, 34.00112], [-116.45839, 33.98969], [-116.45767, 33.96133], [-116.47297, 33.96141], [-116.47175, 33.96231], [-116.47324, 33.96232], [-116.47323, 33.9632], [-116.47432, 33.96321], [-116.47429, 33.96409], [-116.4751, 33.96408], [-116.47513, 33.9756], [-116.48787, 33.97591], [-116.4878, 33.9827], [-116.49015, 33.98276], [-116.49012, 33.98814], [-116.49273, 33.98804], [-116.49273, 33.99036], [-116.49276, 33.99373], [-116.49666, 33.99362], [-116.49677, 33.99043], [-116.5102, 33.99039], [-116.51029, 34.00493], [-116.51472, 34.00497], [-116.5145, 34.00902], [-116.51872, 34.00908], [-116.5186, 34.00499], [-116.52808, 34.00506], [-116.56268, 34.0054], [-116.56296, 34.0134], [-116.56305, 34.01633], [-116.56318, 34.02001], [-116.57423, 34.02002], [-116.58056, 34.02007], [-116.58051, 34.0128], [-116.59786, 34.0114], [-116.59794, 34.01826], [-116.5984, 34.03271]], [[-116.46219, 33.9897], [-116.46218, 33.98971], [-116.46227, 33.99671], [-116.46659, 33.99683], [-116.46652, 33.98978], [-116.46219, 33.9897]]]} | Open Access 1 | 23131 | Big Morongo Canyon Preserve | 16082 | 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 | 12448.862 | Big Morongo Canyon Preserve | None 1020 |
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]);