units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 2 and YR_EST = 2006
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_TYP, AGNCY_WEB, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9815 | 9815 | 9814 | {"type": "MultiPolygon", "coordinates": [[[[-118.0981, 33.75518], [-118.09806, 33.75524], [-118.09723, 33.75729], [-118.09712, 33.75727], [-118.09712, 33.7574], [-118.09718, 33.75742], [-118.09712, 33.75756], [-118.09679, 33.75796], [-118.09678, 33.7574], [-118.09397, 33.75741], [-118.0981, 33.75518]]], [[[-118.10823, 33.7587], [-118.10791, 33.75879], [-118.10789, 33.75877], [-118.10682, 33.75905], [-118.10565, 33.75931], [-118.10521, 33.75938], [-118.10477, 33.75942], [-118.10433, 33.75944], [-118.10388, 33.75944], [-118.10387, 33.7595], [-118.09897, 33.75948], [-118.09898, 33.75944], [-118.09888, 33.75943], [-118.09766, 33.75943], [-118.09756, 33.75944], [-118.09753, 33.75948], [-118.09711, 33.75947], [-118.09713, 33.75927], [-118.09719, 33.75906], [-118.09855, 33.75569], [-118.0987, 33.75543], [-118.09888, 33.75522], [-118.0991, 33.75502], [-118.09928, 33.75491], [-118.10004, 33.75448], [-118.10066, 33.75425], [-118.10133, 33.7539], [-118.1015, 33.75378], [-118.10179, 33.75355], [-118.10197, 33.75343], [-118.10391, 33.75239], [-118.1039, 33.75304], [-118.10392, 33.75305], [-118.10544, 33.75188], [-118.10505, 33.75144], [-118.10335, 33.75235], [-118.10275, 33.75234], [-118.10578, 33.75071], [-118.10581, 33.75113], [-118.10588, 33.75155], [-118.10546, 33.75189], [-118.10624, 33.75276], [-118.10496, 33.75373], [-118.10575, 33.75452], [-118.10487, 33.7551], [-118.10823, 33.7587]]], [[[-118.1037, 33.76073], [-118.10224, 33.76073], [-118.10201, 33.76064], [-118.10203, 33.75976], [-118.10363, 33.75977], [-118.10369, 33.75982], [-118.1037, 33.76073]]], [[[-118.1044, 33.76679], [-118.10413, 33.76701], [-118.10379, 33.76693], [-118.10378, 33.76689], [-118.10341, 33.76687], [-118.10336, 33.76683], [-118.1034, 33.76645], [-118.10346, 33.76609], [-118.1044, 33.76679]]], [[[-118.11507, 33.76323], [-118.11475, 33.7634], [-118.11459, 33.76373], [-118.11427, 33.76414], [-118.11409, 33.76433], [-118.11382, 33.76457], [-118.11347, 33.76479], [-118.11321, 33.76491], [-118.1129, 33.76502], [-118.1124, 33.76514], [-118.1115, 33.76493], [-118.11152, 33.76491], [-118.11151, 33.7649], [-118.11107, 33.76499], [-118.11113, 33.76522], [-118.10929, 33.76562], [-118.10921, 33.76539], [-118.10584, 33.76612], [-118.10538, 33.76627], [-118.10496, 33.76644], [-118.10362, 33.76543], [-118.10389, 33.76452], [-118.10395, 33.76416], [-118.10399, 33.76388], [-118.104, 33.7635], [-118.10401, 33.76043], [-118.104, 33.7599], [-118.10408, 33.7599], [-118.10408, 33.75983], [-118.10459, 33.75981], [-118.10511, 33.75977], [-118.10561, 33.7597], [-118.10597, 33.75963], [-118.10599, 33.75965], [-118.10654, 33.75953], [-118.10656, 33.75946], [-118.10676, 33.75945], [-118.10678, 33.75947], [-118.10725, 33.75935], [-118.10805, 33.75914], [-118.10805, 33.75911], [-118.10954, 33.7587], [-118.10954, 33.75868], [-118.11055, 33.75842], [-118.11056, 33.75844], [-118.1106, 33.75844], [-118.11072, 33.75876], [-118.11112, 33.75891], [-118.11151, 33.75866], [-118.11346, 33.76076], [-118.11388, 33.76125], [-118.11425, 33.76177], [-118.11479, 33.76278], [-118.11483, 33.76277], [-118.11507, 33.76323]]], [[[-118.1102, 33.76604], [-118.10804, 33.76789], [-118.10525, 33.76728], [-118.10565, 33.76708], [-118.10606, 33.76694], [-118.1102, 33.76604]]], [[[-118.11134, 33.76537], [-118.11087, 33.76547], [-118.11087, 33.76547], [-118.11104, 33.76532], [-118.11134, 33.76537]]]]} | Restricted Access 2 | 47917 | Los Cerritos Wetlands | 32016 | 2418 | Los Cerritos Wetland Authority 929 | Special District 4 | Joint Powers Authority 24 | http://intoloscerritoswetlands.org | Special District 4 | 2418 | Los Cerritos Wetland Authority 902 | Special District 4 | Joint Powers Authority 23 | http://intoloscerritoswetlands.org/ | Los Angeles 6 | 311.339 | Los Cerritos Wetlands | 2006 | Local Conservation Area 4 | 2 |
9865 | 9865 | 9864 | {"type": "Polygon", "coordinates": [[[-118.10578, 33.7507], [-118.10168, 33.75292], [-118.10147, 33.75304], [-118.1011, 33.75333], [-118.10089, 33.75347], [-118.10032, 33.75377], [-118.09988, 33.75392], [-118.09965, 33.75401], [-118.09891, 33.75441], [-118.09869, 33.75454], [-118.09849, 33.7547], [-118.09831, 33.75488], [-118.09809, 33.75518], [-118.09198, 33.75848], [-118.09204, 33.75945], [-118.09112, 33.75945], [-118.09164, 33.75896], [-118.09157, 33.75739], [-118.09158, 33.75387], [-118.08764, 33.75239], [-118.08918, 33.75013], [-118.08922, 33.7501], [-118.08929, 33.7501], [-118.08955, 33.75023], [-118.08964, 33.75031], [-118.08979, 33.75034], [-118.08981, 33.75036], [-118.08981, 33.75039], [-118.08968, 33.75066], [-118.08941, 33.75105], [-118.08933, 33.7512], [-118.08928, 33.75135], [-118.08892, 33.7513], [-118.08888, 33.7515], [-118.0888, 33.75161], [-118.08872, 33.75167], [-118.08845, 33.75179], [-118.08832, 33.75191], [-118.08825, 33.75207], [-118.08825, 33.75224], [-118.08832, 33.75239], [-118.0884, 33.75248], [-118.08851, 33.75255], [-118.08863, 33.7526], [-118.08876, 33.75262], [-118.08888, 33.75261], [-118.08905, 33.75257], [-118.08918, 33.75249], [-118.08938, 33.75251], [-118.08938, 33.7526], [-118.0894, 33.75269], [-118.08945, 33.7528], [-118.08953, 33.75288], [-118.08963, 33.75295], [-118.08975, 33.753], [-118.08987, 33.75303], [-118.09001, 33.75303], [-118.0903, 33.75291], [-118.09037, 33.75284], [-118.09043, 33.75276], [-118.09054, 33.7525], [-118.09066, 33.75228], [-118.09075, 33.7521], [-118.0908, 33.75192], [-118.09083, 33.75172], [-118.09086, 33.75163], [-118.09109, 33.75129], [-118.09134, 33.75085], [-118.09161, 33.75067], [-118.09171, 33.75057], [-118.09192, 33.75029], [-118.09201, 33.75014], [-118.09208, 33.75006], [-118.09226, 33.74999], [-118.09225, 33.74995], [-118.09219, 33.74988], [-118.09207, 33.74981], [-118.09207, 33.7498], [-118.09274, 33.75002], [-118.09392, 33.75049], [-118.09404, 33.75021], [-118.0943, 33.75006], [-118.09489, 33.75005], [-118.09567, 33.74976], [-118.09748, 33.74977], [-118.09918, 33.74999], [-118.09978, 33.74999], [-118.10013, 33.74989], [-118.10034, 33.74971], [-118.10036, 33.74943], [-118.10071, 33.74928], [-118.10082, 33.74891], [-118.1013, 33.74875], [-118.10131, 33.74888], [-118.10216, 33.74867], [-118.10286, 33.74859], [-118.10307, 33.74855], [-118.10332, 33.74869], [-118.1034, 33.74872], [-118.10342, 33.74871], [-118.10352, 33.74876], [-118.10373, 33.74893], [-118.10379, 33.74891], [-118.10399, 33.74944], [-118.10574, 33.74945], [-118.10578, 33.7507]]]} | Restricted Access 2 | 47918 | Los Cerritos Wetlands | 32016 | 2418 | Los Cerritos Wetland Authority 929 | Special District 4 | Joint Powers Authority 24 | http://intoloscerritoswetlands.org | Special District 4 | 2418 | Los Cerritos Wetland Authority 902 | Special District 4 | Joint Powers Authority 23 | http://intoloscerritoswetlands.org/ | Orange 3 | 196.293 | Los Cerritos Wetlands | 2006 | Local Conservation Area 4 | 2 |
16944 | 16944 | 16943 | {"type": "Polygon", "coordinates": [[[-122.64929, 38.49868], [-122.64914, 38.49872], [-122.64901, 38.4988], [-122.6489, 38.4989], [-122.64884, 38.49901], [-122.6488, 38.49912], [-122.6488, 38.49924], [-122.64817, 38.49896], [-122.648, 38.49906], [-122.64602, 38.49904], [-122.64464, 38.49892], [-122.64157, 38.49828], [-122.64048, 38.4982], [-122.63995, 38.49843], [-122.63855, 38.49832], [-122.63752, 38.49783], [-122.63694, 38.498], [-122.63675, 38.49867], [-122.63629, 38.49901], [-122.63575, 38.49931], [-122.63418, 38.50055], [-122.63629, 38.50362], [-122.64069, 38.5036], [-122.64077, 38.50728], [-122.64017, 38.50767], [-122.6393, 38.50829], [-122.63932, 38.50826], [-122.6393, 38.50821], [-122.639, 38.50804], [-122.63784, 38.5084], [-122.63158, 38.51022], [-122.62288, 38.50997], [-122.6228, 38.50987], [-122.62239, 38.50957], [-122.62224, 38.50941], [-122.62216, 38.50927], [-122.62202, 38.50917], [-122.62177, 38.50893], [-122.62175, 38.50886], [-122.62151, 38.50868], [-122.62101, 38.50848], [-122.62053, 38.50846], [-122.62019, 38.50842], [-122.6199, 38.50829], [-122.61969, 38.50828], [-122.61957, 38.50824], [-122.6193, 38.50804], [-122.61911, 38.50738], [-122.61907, 38.50735], [-122.619, 38.50719], [-122.61875, 38.50706], [-122.61842, 38.50707], [-122.61802, 38.50695], [-122.61785, 38.50695], [-122.61776, 38.50693], [-122.61763, 38.50696], [-122.61743, 38.50694], [-122.61698, 38.50677], [-122.61629, 38.50629], [-122.61625, 38.50628], [-122.61568, 38.50593], [-122.61495, 38.50564], [-122.61414, 38.50543], [-122.61408, 38.50545], [-122.61396, 38.50544], [-122.61302, 38.50578], [-122.61262, 38.50579], [-122.61255, 38.50583], [-122.61239, 38.50584], [-122.61207, 38.50581], [-122.61183, 38.50568], [-122.61169, 38.50555], [-122.61153, 38.50552], [-122.61152, 38.50553], [-122.61159, 38.5076], [-122.61405, 38.50761], [-122.6166, 38.50994], [-122.60967, 38.50997], [-122.60857, 38.49909], [-122.60853, 38.4956], [-122.6135, 38.49559], [-122.61367, 38.4994], [-122.63133, 38.49922], [-122.63517, 38.49898], [-122.63515, 38.49793], [-122.63588, 38.49767], [-122.63584, 38.49644], [-122.64068, 38.49719], [-122.64382, 38.49558], [-122.64277, 38.49505], [-122.64275, 38.49291], [-122.64348, 38.4925], [-122.64292, 38.49197], [-122.64279, 38.49202], [-122.64265, 38.49203], [-122.64252, 38.49199], [-122.64234, 38.49191], [-122.64166, 38.4915], [-122.64144, 38.49133], [-122.64134, 38.49118], [-122.6413, 38.49106], [-122.6412, 38.49053], [-122.6411, 38.49036], [-122.64079, 38.49006], [-122.64066, 38.48988], [-122.64049, 38.48942], [-122.6404, 38.4893], [-122.64028, 38.48924], [-122.64017, 38.48922], [-122.64001, 38.48584], [-122.64922, 38.48596], [-122.64926, 38.48754], [-122.64935, 38.49519], [-122.64929, 38.49868]], [[-122.63965, 38.50753], [-122.63965, 38.50752], [-122.63829, 38.5068], [-122.63821, 38.50687], [-122.63793, 38.50722], [-122.63914, 38.5079], [-122.63965, 38.50753]]]} | Restricted Access 2 | 29388 | Saddle Mountain Open Space Preserve | 24775 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 975.177 | Saddle Mtn. OSP | 2006 | Local Conservation Area 4 | 2 |
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]);