units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, DES_TP = 49 and LAYER = 13
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
DES_TP 1
- Recreation Management Area · 1 ✖
ACCESS_TYP 1
- No Public Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16180 | 16180 | 16179 | {"type": "MultiPolygon", "coordinates": [[[[-117.97757, 34.12178], [-117.9774, 34.12192], [-117.9774, 34.12228], [-117.97719, 34.12242], [-117.9761, 34.12331], [-117.97597, 34.12347], [-117.97592, 34.12364], [-117.97592, 34.12496], [-117.97572, 34.12497], [-117.97572, 34.12361], [-117.97575, 34.12354], [-117.97573, 34.12353], [-117.97033, 34.12796], [-117.96982, 34.1286], [-117.96965, 34.12872], [-117.96884, 34.12872], [-117.96882, 34.13217], [-117.96572, 34.13217], [-117.96003, 34.1322], [-117.96003, 34.13218], [-117.95996, 34.13218], [-117.96081, 34.1308], [-117.9616, 34.12962], [-117.96161, 34.12952], [-117.96156, 34.12944], [-117.96209, 34.12877], [-117.96263, 34.12815], [-117.96318, 34.1276], [-117.96388, 34.12695], [-117.96407, 34.12708], [-117.96439, 34.12694], [-117.96447, 34.12642], [-117.96487, 34.12604], [-117.96506, 34.12602], [-117.96533, 34.12589], [-117.96635, 34.12499], [-117.96642, 34.12485], [-117.9666, 34.1247], [-117.96674, 34.12462], [-117.96994, 34.12141], [-117.97081, 34.12057], [-117.97169, 34.1198], [-117.9724, 34.11927], [-117.97292, 34.11891], [-117.97492, 34.11765], [-117.97707, 34.11638], [-117.97706, 34.1163], [-117.97756, 34.11602], [-117.97757, 34.12178]]], [[[-117.97438, 34.11716], [-117.9726, 34.11814], [-117.9704, 34.11989], [-117.9693, 34.12103], [-117.96627, 34.12393], [-117.96607, 34.12416], [-117.96466, 34.1255], [-117.96411, 34.12566], [-117.96337, 34.12638], [-117.9635, 34.12667], [-117.96095, 34.12911], [-117.96088, 34.12909], [-117.96081, 34.12909], [-117.96069, 34.12915], [-117.95848, 34.13159], [-117.95825, 34.1318], [-117.958, 34.13199], [-117.95766, 34.13221], [-117.95635, 34.13223], [-117.95357, 34.12911], [-117.94874, 34.13115], [-117.94872, 34.13114], [-117.94869, 34.13117], [-117.94872, 34.13114], [-117.95015, 34.13], [-117.95053, 34.12906], [-117.95066, 34.12822], [-117.95091, 34.12769], [-117.95132, 34.12694], [-117.95196, 34.12641], [-117.9525, 34.12614], [-117.95266, 34.1252], [-117.95313, 34.12443], [-117.95388, 34.12367], [-117.95497, 34.12298], [-117.95542, 34.12235], [-117.95639, 34.12138], [-117.95755, 34.12058], [-117.95858, 34.11969], [-117.95943, 34.11891], [-117.9599, 34.11834], [-117.95999, 34.10704], [-117.96089, 34.10702], [-117.9612, 34.10704], [-117.96166, 34.10709], [-117.96227, 34.10722], [-117.96281, 34.10741], [-117.96315, 34.10756], [-117.96341, 34.1077], [-117.96384, 34.10799], [-117.96462, 34.10857], [-117.96743, 34.11078], [-117.96841, 34.11146], [-117.97068, 34.11327], [-117.97102, 34.11352], [-117.97138, 34.11376], [-117.97188, 34.11404], [-117.97216, 34.11418], [-117.97288, 34.1153], [-117.97296, 34.11554], [-117.9731, 34.11575], [-117.97327, 34.11607], [-117.97332, 34.11632], [-117.97332, 34.11662], [-117.97328, 34.1169], [-117.97438, 34.11716]]], [[[-117.95056, 34.13285], [-117.95008, 34.13335], [-117.94879, 34.13434], [-117.94783, 34.1352], [-117.94707, 34.13546], [-117.94578, 34.13636], [-117.94447, 34.13772], [-117.94261, 34.1365], [-117.94298, 34.13616], [-117.94331, 34.13575], [-117.94405, 34.13496], [-117.94468, 34.13451], [-117.9457, 34.13373], [-117.94647, 34.1332], [-117.94681, 34.1329], [-117.94725, 34.13264], [-117.9477, 34.13231], [-117.94819, 34.13192], [-117.95011, 34.13262], [-117.95024, 34.13273], [-117.95056, 34.13285]]]]} | No Public Access 3 | 48161 | Santa Fe Dam Open Space | 32700 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 950.067 | Santa Fe Dam OS | 0 | Recreation Management Area 49 | 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]);