superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 43, MNG_AG_TYP = 4 and YR_EST = 1986
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 1 ✖
MNG_AGENCY 1
- Marin County Open Space District · 1 ✖
ACCESS_TYP 1
- Open Access · 1 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14766 | 14766 | 14765 | {"type": "Polygon", "coordinates": [[[-122.56426, 38.11867], [-122.56315, 38.11914], [-122.56284, 38.11934], [-122.5624, 38.11973], [-122.5619, 38.12009], [-122.56146, 38.12059], [-122.56117, 38.12076], [-122.56075, 38.12092], [-122.56043, 38.1212], [-122.56016, 38.12134], [-122.55997, 38.12147], [-122.55968, 38.12173], [-122.55946, 38.12189], [-122.55916, 38.12206], [-122.55883, 38.12217], [-122.55698, 38.12336], [-122.55627, 38.12376], [-122.55494, 38.12443], [-122.55479, 38.12464], [-122.55471, 38.12543], [-122.55461, 38.12583], [-122.55451, 38.12599], [-122.55407, 38.12627], [-122.55373, 38.12644], [-122.55363, 38.12652], [-122.55353, 38.12664], [-122.55342, 38.1268], [-122.55333, 38.12702], [-122.55331, 38.12717], [-122.55338, 38.12749], [-122.5534, 38.12778], [-122.55337, 38.12806], [-122.5533, 38.12833], [-122.55319, 38.1286], [-122.55303, 38.12886], [-122.5528, 38.12908], [-122.55253, 38.12927], [-122.55223, 38.12943], [-122.55143, 38.12967], [-122.55096, 38.1297], [-122.55078, 38.12973], [-122.5503, 38.12992], [-122.54981, 38.13005], [-122.54935, 38.13008], [-122.54929, 38.13019], [-122.55047, 38.13066], [-122.5504, 38.13089], [-122.55002, 38.13086], [-122.54949, 38.1309], [-122.54921, 38.13099], [-122.54902, 38.13111], [-122.54884, 38.13126], [-122.54877, 38.13153], [-122.5487, 38.13201], [-122.54863, 38.13236], [-122.54851, 38.13265], [-122.54827, 38.13289], [-122.54744, 38.13363], [-122.54686, 38.13444], [-122.54673, 38.1345], [-122.54609, 38.13407], [-122.54517, 38.13326], [-122.54512, 38.13236], [-122.5441, 38.13187], [-122.54362, 38.13132], [-122.54335, 38.13137], [-122.54291, 38.13111], [-122.54274, 38.13031], [-122.5422, 38.13015], [-122.54185, 38.13049], [-122.54104, 38.13065], [-122.54049, 38.13109], [-122.53973, 38.13088], [-122.54032, 38.12927], [-122.53981, 38.1292], [-122.5393, 38.12958], [-122.53873, 38.12945], [-122.53879, 38.12859], [-122.5385, 38.12842], [-122.53742, 38.12932], [-122.5373, 38.12998], [-122.53646, 38.12992], [-122.53567, 38.12921], [-122.53626, 38.128], [-122.53586, 38.12769], [-122.53504, 38.12788], [-122.5334, 38.12854], [-122.53313, 38.12884], [-122.53282, 38.12892], [-122.53141, 38.12872], [-122.53068, 38.12816], [-122.5306, 38.12771], [-122.53123, 38.12743], [-122.53128, 38.12672], [-122.53174, 38.12628], [-122.5316, 38.12597], [-122.53104, 38.1257], [-122.53028, 38.12608], [-122.52946, 38.1261], [-122.52921, 38.1265], [-122.52774, 38.12624], [-122.52769, 38.12612], [-122.52811, 38.12602], [-122.52817, 38.12604], [-122.52821, 38.12609], [-122.52838, 38.12605], [-122.52839, 38.126], [-122.52843, 38.12597], [-122.52959, 38.12571], [-122.52995, 38.12558], [-122.53021, 38.12542], [-122.53043, 38.12524], [-122.53112, 38.12446], [-122.53137, 38.12425], [-122.53163, 38.12411], [-122.53262, 38.12368], [-122.53441, 38.12323], [-122.53474, 38.12317], [-122.53496, 38.12317], [-122.53723, 38.1233], [-122.53761, 38.12329], [-122.53799, 38.12322], [-122.53827, 38.12313], [-122.53861, 38.12298], [-122.53884, 38.12283], [-122.53928, 38.12244], [-122.53962, 38.12221], [-122.53999, 38.122], [-122.54053, 38.12175], [-122.54066, 38.12196], [-122.54096, 38.12226], [-122.54108, 38.12227], [-122.54136, 38.12234], [-122.54174, 38.12234], [-122.54205, 38.12455], [-122.54072, 38.12551], [-122.54004, 38.12655], [-122.54091, 38.12676], [-122.54137, 38.1259], [-122.54214, 38.12595], [-122.54324, 38.12757], [-122.54377, 38.12621], [-122.54439, 38.12597], [-122.54441, 38.12587], [-122.54509, 38.126], [-122.54568, 38.12589], [-122.54572, 38.1253], [-122.54594, 38.12499], [-122.54605, 38.12439], [-122.54622, 38.12406], [-122.54625, 38.12373], [-122.54621, 38.12294], [-122.54712, 38.12221], [-122.54701, 38.122], [-122.54712, 38.12195], [-122.54737, 38.12225], [-122.54772, 38.1224], [-122.54831, 38.12184], [-122.54831, 38.12182], [-122.54783, 38.12136], [-122.54797, 38.1212], [-122.55038, 38.12198], [-122.5508, 38.12068], [-122.5509, 38.12045], [-122.55091, 38.12041], [-122.55155, 38.12072], [-122.55226, 38.12038], [-122.55289, 38.12], [-122.5538, 38.12032], [-122.55415, 38.12014], [-122.55478, 38.12019], [-122.55524, 38.12011], [-122.55533, 38.11963], [-122.55549, 38.1196], [-122.5557, 38.11969], [-122.55842, 38.11911], [-122.55843, 38.1191], [-122.55817, 38.11854], [-122.55787, 38.11854], [-122.55786, 38.11848], [-122.55844, 38.11821], [-122.55919, 38.11802], [-122.55882, 38.11707], [-122.56054, 38.11662], [-122.56077, 38.11678], [-122.56136, 38.11676], [-122.5624, 38.11702], [-122.56264, 38.11754], [-122.56341, 38.1178], [-122.56376, 38.11784], [-122.56408, 38.11811], [-122.56426, 38.11867]]]} | Open Access 1 | Rush Creek Open Space Preserve | http://www.marincountyparks.org/depts/pk/divisions/open-space/rush-creek | 31486 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 488.63 | Rush Creek OSP | 1986 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);