units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 2, GAP_STS = 4 and MNG_AGENCY = 280
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 947 | 947 | 946 | {"type": "MultiPolygon", "coordinates": [[[[-118.30927, 33.77858], [-118.30758, 33.77901], [-118.3066, 33.7792], [-118.30555, 33.77935], [-118.30359, 33.77951], [-118.30379, 33.77922], [-118.30356, 33.7791], [-118.30373, 33.77882], [-118.30371, 33.77863], [-118.30258, 33.77836], [-118.30228, 33.77858], [-118.30213, 33.77866], [-118.30196, 33.77871], [-118.30179, 33.77874], [-118.30145, 33.77873], [-118.30114, 33.77863], [-118.30124, 33.77834], [-118.3011, 33.7783], [-118.30143, 33.77756], [-118.3013, 33.77738], [-118.30092, 33.7772], [-118.30093, 33.77658], [-118.30075, 33.77653], [-118.30073, 33.77656], [-118.3002, 33.77642], [-118.30015, 33.77669], [-118.30004, 33.7768], [-118.29989, 33.77685], [-118.29945, 33.77691], [-118.29942, 33.77696], [-118.29941, 33.77494], [-118.296, 33.77494], [-118.2959, 33.77466], [-118.29444, 33.77083], [-118.29424, 33.77018], [-118.29413, 33.76975], [-118.29404, 33.76934], [-118.29402, 33.76908], [-118.29401, 33.76865], [-118.29405, 33.76753], [-118.29404, 33.76724], [-118.294, 33.76667], [-118.29394, 33.76629], [-118.29718, 33.76629], [-118.29719, 33.76641], [-118.29801, 33.76687], [-118.29825, 33.76705], [-118.29891, 33.76743], [-118.29912, 33.76759], [-118.29932, 33.7677], [-118.30005, 33.76787], [-118.30059, 33.76797], [-118.30179, 33.76827], [-118.30185, 33.76825], [-118.30188, 33.76819], [-118.30407, 33.76881], [-118.30522, 33.76959], [-118.30699, 33.77065], [-118.30701, 33.77105], [-118.30741, 33.77167], [-118.30772, 33.77175], [-118.30895, 33.77159], [-118.30875, 33.77225], [-118.30863, 33.77282], [-118.30859, 33.77321], [-118.3086, 33.77377], [-118.30863, 33.77407], [-118.30927, 33.77858]]], [[[-118.30012, 33.77981], [-118.29971, 33.77989], [-118.29931, 33.78001], [-118.29894, 33.78016], [-118.29858, 33.78034], [-118.29825, 33.78056], [-118.29796, 33.78081], [-118.29759, 33.78122], [-118.2974, 33.78122], [-118.29726, 33.78129], [-118.29689, 33.78086], [-118.29719, 33.7805], [-118.29739, 33.7803], [-118.2976, 33.78013], [-118.2979, 33.77991], [-118.29838, 33.77962], [-118.29904, 33.77935], [-118.29933, 33.77926], [-118.29938, 33.77939], [-118.29967, 33.77967], [-118.29978, 33.77974], [-118.3001, 33.77979], [-118.30012, 33.77981]]]]} | Restricted Access 2 | 5975 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | 18013 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 326.646 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | 0 | Federal Other or Unknown 87 | 4 | ||
| 11423 | 11423 | 11422 | {"type": "MultiPolygon", "coordinates": [[[[-121.30305, 38.54735], [-121.30211, 38.5479], [-121.30127, 38.54837], [-121.2953, 38.55181], [-121.29482, 38.55207], [-121.29427, 38.55231], [-121.2937, 38.5525], [-121.29335, 38.5526], [-121.29265, 38.55275], [-121.29246, 38.55278], [-121.29003, 38.5528], [-121.28957, 38.55274], [-121.28897, 38.55261], [-121.28836, 38.55242], [-121.28791, 38.55226], [-121.28551, 38.5512], [-121.28518, 38.55109], [-121.28486, 38.55102], [-121.28379, 38.55086], [-121.28308, 38.55082], [-121.28265, 38.55083], [-121.28259, 38.54964], [-121.28298, 38.54965], [-121.28397, 38.54949], [-121.28537, 38.54886], [-121.28599, 38.54831], [-121.28692, 38.54751], [-121.28713, 38.54683], [-121.28788, 38.54565], [-121.28812, 38.54522], [-121.28839, 38.54526], [-121.28848, 38.54518], [-121.29005, 38.54547], [-121.29024, 38.54486], [-121.29018, 38.54435], [-121.28998, 38.54383], [-121.28964, 38.54334], [-121.28791, 38.54363], [-121.28759, 38.54403], [-121.28589, 38.54301], [-121.28583, 38.54294], [-121.28639, 38.54202], [-121.28574, 38.54162], [-121.28514, 38.54238], [-121.28501, 38.54227], [-121.28488, 38.54207], [-121.28543, 38.54142], [-121.28547, 38.54098], [-121.28481, 38.54044], [-121.28397, 38.54], [-121.28293, 38.54004], [-121.28244, 38.54027], [-121.28118, 38.53964], [-121.28064, 38.53961], [-121.27946, 38.54002], [-121.27897, 38.54049], [-121.27866, 38.54086], [-121.2783, 38.54113], [-121.27786, 38.54135], [-121.27631, 38.54189], [-121.2764, 38.54203], [-121.27556, 38.54252], [-121.27453, 38.54244], [-121.27376, 38.54246], [-121.27307, 38.54332], [-121.27282, 38.54358], [-121.27375, 38.54468], [-121.27278, 38.54507], [-121.27227, 38.54435], [-121.27224, 38.54368], [-121.27233, 38.54302], [-121.27252, 38.54256], [-121.27246, 38.54215], [-121.27209, 38.54127], [-121.27177, 38.54079], [-121.27132, 38.5405], [-121.27142, 38.5403], [-121.27227, 38.54066], [-121.27301, 38.5409], [-121.27377, 38.54112], [-121.27493, 38.54155], [-121.27598, 38.54132], [-121.27663, 38.54074], [-121.2757, 38.53913], [-121.27535, 38.53918], [-121.27453, 38.53879], [-121.2726, 38.53884], [-121.27114, 38.53948], [-121.27019, 38.54032], [-121.26992, 38.54086], [-121.26982, 38.54135], [-121.26894, 38.54175], [-121.26856, 38.54449], [-121.2689, 38.54555], [-121.26937, 38.54647], [-121.26788, 38.54711], [-121.26917, 38.54757], [-121.26919, 38.54759], [-121.26923, 38.54765], [-121.2689, 38.54865], [-121.2688, 38.54869], [-121.26872, 38.54877], [-121.26856, 38.54887], [-121.26839, 38.54894], [-121.26831, 38.549], [-121.26706, 38.54949], [-121.26703, 38.54956], [-121.2661, 38.54997], [-121.26584, 38.54992], [-121.26464, 38.54933], [-121.26446, 38.54912], [-121.2637, 38.54838], [-121.26341, 38.54821], [-121.26297, 38.54721], [-121.26298, 38.54713], [-121.26297, 38.54709], [-121.26302, 38.54687], [-121.26313, 38.54672], [-121.26313, 38.5467], [-121.26121, 38.54672], [-121.2612, 38.54482], [-121.26109, 38.54475], [-121.26111, 38.53501], [-121.26859, 38.53502], [-121.26859, 38.53527], [-121.28764, 38.5349], [-121.29213, 38.53601], [-121.2884, 38.53879], [-121.28755, 38.53809], [-121.28787, 38.53781], [-121.28787, 38.53779], [-121.28664, 38.53694], [-121.2863, 38.53673], [-121.28504, 38.53627], [-121.28387, 38.53604], [-121.28242, 38.53602], [-121.28172, 38.5361], [-121.28183, 38.53748], [-121.28205, 38.5376], [-121.28355, 38.53763], [-121.28389, 38.53766], [-121.28467, 38.53784], [-121.28628, 38.5387], [-121.28665, 38.5387], [-121.28746, 38.53816], [-121.28831, 38.53886], [-121.28745, 38.53963], [-121.28745, 38.53965], [-121.30255, 38.53981], [-121.30254, 38.54027], [-121.29962, 38.54163], [-121.30305, 38.54735]]], [[[-121.27303, 38.54697], [-121.27298, 38.54745], [-121.27276, 38.5477], [-121.27231, 38.54795], [-121.27189, 38.54805], [-121.27153, 38.54807], [-121.27114, 38.54797], [-121.27069, 38.5477], [-121.27032, 38.54743], [-121.27016, 38.54712], [-121.27014, 38.54691], [-121.27016, 38.54678], [-121.27086, 38.54634], [-121.27185, 38.54597], [-121.27209, 38.54611], [-121.27236, 38.54639], [-121.27303, 38.54697]]]]} | Restricted Access 2 | 22251 | Mather | 21950 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Sacramento 41 | 927.044 | Mather | 0 | Federal Other or Unknown 87 | 4 |
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]);