superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AG_TYP = 4 and YR_EST = 1984
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- Recreation/Parks District · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14708 | 14708 | 14707 | {"type": "MultiPolygon", "coordinates": [[[[-122.29778, 37.37792], [-122.2977, 37.3782], [-122.29751, 37.37842], [-122.29705, 37.37865], [-122.29581, 37.37867], [-122.29579, 37.37994], [-122.29562, 37.37938], [-122.29518, 37.37891], [-122.29391, 37.3789], [-122.29387, 37.38057], [-122.28673, 37.38057], [-122.2867, 37.38161], [-122.28231, 37.38161], [-122.28227, 37.38814], [-122.28082, 37.38773], [-122.28025, 37.38768], [-122.2795, 37.38774], [-122.2783, 37.38797], [-122.27756, 37.38796], [-122.27657, 37.38789], [-122.27585, 37.38775], [-122.27523, 37.3878], [-122.2748, 37.3879], [-122.27428, 37.38789], [-122.27329, 37.38801], [-122.2733, 37.38159], [-122.27326, 37.37799], [-122.27373, 37.37798], [-122.27865, 37.3766], [-122.27777, 37.37518], [-122.27747, 37.37428], [-122.27673, 37.37381], [-122.27614, 37.37296], [-122.27641, 37.37176], [-122.27656, 37.37071], [-122.27657, 37.36964], [-122.27721, 37.36879], [-122.27712, 37.36698], [-122.2868, 37.36709], [-122.28674, 37.37861], [-122.2915, 37.37861], [-122.29219, 37.37791], [-122.29239, 37.37791], [-122.29238, 37.37769], [-122.29211, 37.37757], [-122.29219, 37.37749], [-122.2926, 37.37757], [-122.29276, 37.3777], [-122.29279, 37.37787], [-122.29277, 37.3779], [-122.29278, 37.37792], [-122.29778, 37.37792]]], [[[-122.31237, 37.32216], [-122.31219, 37.32245], [-122.31171, 37.32232], [-122.31152, 37.32177], [-122.31139, 37.32155], [-122.31124, 37.32135], [-122.311, 37.32114], [-122.31082, 37.3211], [-122.31068, 37.32109], [-122.31039, 37.32112], [-122.31007, 37.32111], [-122.30957, 37.32102], [-122.3093, 37.32104], [-122.30893, 37.3211], [-122.30819, 37.32115], [-122.30798, 37.32116], [-122.30769, 37.32113], [-122.30743, 37.32096], [-122.30737, 37.32069], [-122.3074, 37.32055], [-122.30755, 37.32034], [-122.3077, 37.32018], [-122.30753, 37.32006], [-122.30733, 37.31988], [-122.30726, 37.31955], [-122.30734, 37.31914], [-122.30742, 37.31893], [-122.30759, 37.31873], [-122.30783, 37.31852], [-122.3081, 37.31834], [-122.30844, 37.31823], [-122.30878, 37.31818], [-122.30918, 37.31817], [-122.30943, 37.31818], [-122.30974, 37.31815], [-122.30977, 37.31789], [-122.30973, 37.31743], [-122.30967, 37.31711], [-122.30943, 37.31694], [-122.30944, 37.3166], [-122.3096, 37.3164], [-122.30971, 37.31595], [-122.30971, 37.31546], [-122.30975, 37.31528], [-122.31004, 37.31473], [-122.31059, 37.31429], [-122.31021, 37.31412], [-122.31033, 37.31387], [-122.3103, 37.3137], [-122.31211, 37.31329], [-122.31205, 37.31341], [-122.31199, 37.31348], [-122.31177, 37.31363], [-122.31162, 37.31371], [-122.31162, 37.31372], [-122.3117, 37.31372], [-122.31186, 37.31378], [-122.31196, 37.3139], [-122.31198, 37.31402], [-122.31192, 37.31416], [-122.31186, 37.31427], [-122.31156, 37.31453], [-122.31127, 37.31466], [-122.31096, 37.31475], [-122.31063, 37.31502], [-122.31033, 37.31539], [-122.31029, 37.31559], [-122.3104, 37.31602], [-122.3102, 37.31676], [-122.31032, 37.31693], [-122.31036, 37.31705], [-122.3104, 37.3173], [-122.31046, 37.31785], [-122.31045, 37.3181], [-122.31037, 37.31842], [-122.31018, 37.31866], [-122.30979, 37.31874], [-122.3089, 37.31872], [-122.30854, 37.31878], [-122.3084, 37.31884], [-122.30819, 37.31901], [-122.30805, 37.31916], [-122.30795, 37.31958], [-122.30833, 37.31973], [-122.30846, 37.3199], [-122.30848, 37.32018], [-122.3084, 37.32037], [-122.3082, 37.32058], [-122.3082, 37.3206], [-122.3087, 37.32057], [-122.30893, 37.32043], [-122.30943, 37.32048], [-122.30961, 37.32047], [-122.31028, 37.32057], [-122.31059, 37.32055], [-122.31089, 37.32055], [-122.31127, 37.32063], [-122.31159, 37.32082], [-122.31181, 37.32104], [-122.31201, 37.3213], [-122.31216, 37.32156], [-122.31237, 37.32216]]], [[[-122.31171, 37.31299], [-122.30924, 37.31361], [-122.30895, 37.31369], [-122.30858, 37.31384], [-122.30842, 37.31371], [-122.30972, 37.31236], [-122.31041, 37.31218], [-122.31059, 37.31255], [-122.3114, 37.31234], [-122.31171, 37.31299]]]]} | Restricted Access 2 | La Honda Creek Open Space Preserve | 20760 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 594.748 | La Honda Creek OSP | 1984 | |
15560 | 15560 | 15559 | {"type": "Polygon", "coordinates": [[[-122.50541, 37.90591], [-122.50534, 37.90605], [-122.50522, 37.90616], [-122.50459, 37.90659], [-122.50382, 37.90704], [-122.50302, 37.90743], [-122.50219, 37.90777], [-122.50306, 37.90921], [-122.50301, 37.90921], [-122.503, 37.90923], [-122.5049, 37.91201], [-122.50298, 37.912], [-122.49848, 37.91207], [-122.49852, 37.91398], [-122.49878, 37.91399], [-122.49879, 37.91419], [-122.49867, 37.9142], [-122.49868, 37.91522], [-122.49851, 37.91523], [-122.49854, 37.91707], [-122.49504, 37.9171], [-122.49504, 37.91835], [-122.49507, 37.91938], [-122.49505, 37.92006], [-122.49507, 37.92109], [-122.49451, 37.92098], [-122.49223, 37.92006], [-122.49223, 37.91987], [-122.49322, 37.91967], [-122.49336, 37.91953], [-122.49337, 37.91852], [-122.49214, 37.91723], [-122.49208, 37.91533], [-122.48721, 37.91542], [-122.48643, 37.91494], [-122.48659, 37.91492], [-122.48671, 37.91487], [-122.48683, 37.91481], [-122.48693, 37.91471], [-122.48698, 37.91462], [-122.48701, 37.91452], [-122.487, 37.91416], [-122.48796, 37.91426], [-122.48822, 37.91388], [-122.48798, 37.91363], [-122.4881, 37.91295], [-122.48762, 37.91287], [-122.48746, 37.91285], [-122.48729, 37.91287], [-122.48709, 37.91293], [-122.48679, 37.91307], [-122.48619, 37.91331], [-122.48584, 37.91313], [-122.48495, 37.91399], [-122.48425, 37.91354], [-122.48423, 37.91235], [-122.48228, 37.9111], [-122.48225, 37.91002], [-122.48313, 37.91002], [-122.48365, 37.9096], [-122.48363, 37.9088], [-122.48223, 37.90818], [-122.48221, 37.90669], [-122.48226, 37.90505], [-122.4841, 37.90617], [-122.48678, 37.9079], [-122.48759, 37.90775], [-122.48808, 37.908], [-122.4882, 37.90808], [-122.48859, 37.90739], [-122.48946, 37.90655], [-122.49045, 37.90632], [-122.49166, 37.90576], [-122.4919, 37.90567], [-122.49233, 37.90566], [-122.49197, 37.90645], [-122.49204, 37.90683], [-122.49381, 37.90723], [-122.49382, 37.90786], [-122.4943, 37.90815], [-122.49519, 37.90782], [-122.4953, 37.90669], [-122.49637, 37.90626], [-122.49695, 37.90579], [-122.49702, 37.90586], [-122.4965, 37.90663], [-122.49633, 37.90706], [-122.49698, 37.90724], [-122.49692, 37.90747], [-122.49688, 37.90769], [-122.49688, 37.90778], [-122.49691, 37.90788], [-122.497, 37.908], [-122.49712, 37.90808], [-122.49726, 37.90813], [-122.49743, 37.90814], [-122.49733, 37.90834], [-122.49744, 37.90873], [-122.49717, 37.90894], [-122.49728, 37.90932], [-122.49841, 37.90937], [-122.49929, 37.9087], [-122.49958, 37.90828], [-122.49959, 37.90789], [-122.49965, 37.90787], [-122.4997, 37.90783], [-122.50075, 37.9077], [-122.50172, 37.90737], [-122.50196, 37.90737], [-122.50285, 37.90723], [-122.50336, 37.90661], [-122.50384, 37.90657], [-122.50426, 37.90627], [-122.50423, 37.90599], [-122.50406, 37.90565], [-122.50473, 37.90506], [-122.50521, 37.90539], [-122.50533, 37.90549], [-122.5054, 37.90561], [-122.50543, 37.9057], [-122.50543, 37.9058], [-122.50541, 37.90591]], [[-122.49689, 37.91227], [-122.4969, 37.91225], [-122.49681, 37.91205], [-122.49633, 37.91213], [-122.49642, 37.91236], [-122.49689, 37.91227]]]} | Open Access 1 | Ring Mountain Open Space Preserve | http://www.marincountyparks.org/depts/pk/divisions/open-space/ring-mountain | 31485 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 389.372 | Ring Mtn. OSP | 1984 |
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]);