units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, DES_TP = 3 and YR_EST = 2000
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1902 | 1902 | 1901 | {"type": "Polygon", "coordinates": [[[-122.4742, 37.72523], [-122.47387, 37.72523], [-122.4735, 37.72527], [-122.47349, 37.72487], [-122.47322, 37.72486], [-122.47322, 37.7248], [-122.47411, 37.72426], [-122.47414, 37.72425], [-122.47416, 37.72427], [-122.47426, 37.72486], [-122.4742, 37.72523]]]} | Open Access 1 | 16307 | Junipero Serra Playground | 20533 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.545 | Junipero Serra Playground | 2000 | Local Recreation Area 3 | 4 | |
6205 | 6205 | 6204 | {"type": "Polygon", "coordinates": [[[-122.04485, 37.87597], [-122.04472, 37.87736], [-122.04387, 37.87733], [-122.04101, 37.87676], [-122.04099, 37.87593], [-122.04031, 37.87511], [-122.03931, 37.87563], [-122.03914, 37.87627], [-122.03425, 37.87555], [-122.03426, 37.86945], [-122.03267, 37.86947], [-122.03165, 37.8692], [-122.03108, 37.8697], [-122.03024, 37.86962], [-122.02981, 37.86905], [-122.03238, 37.86704], [-122.03531, 37.86692], [-122.036, 37.86506], [-122.03714, 37.86599], [-122.03803, 37.86832], [-122.0388, 37.86827], [-122.04027, 37.87005], [-122.04246, 37.87304], [-122.04417, 37.87519], [-122.04485, 37.87597]]]} | Open Access 1 | 1250 | Sugarloaf Recreation Area | 25946 | 1371 | Walnut Creek, City of 178 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | Contra Costa 12 | 184.864 | Sugarloaf Rec. Area | 2000 | Local Recreation Area 3 | 4 | |
7391 | 7391 | 7390 | {"type": "Polygon", "coordinates": [[[-122.58663, 38.10653], [-122.58616, 38.10726], [-122.58423, 38.10642], [-122.58469, 38.10574], [-122.58663, 38.10653]]]} | Open Access 1 | 6798 | L U Sutton Recreation Area | 20738 | 2071 | Marin Municipal Water District 254 | Special District 4 | Water District 13 | http://www.marinwater.org/ | Special District 4 | 2071 | Marin Municipal Water District 250 | Special District 4 | Water District 13 | Marin 23 | 4.202 | L U Sutton Rec. Area | 2000 | Local Recreation Area 3 | 4 | |
15983 | 15983 | 15982 | {"type": "Polygon", "coordinates": [[[-122.04704, 37.90031], [-122.04439, 37.90084], [-122.04401, 37.90062], [-122.04279, 37.90015], [-122.04225, 37.90071], [-122.04092, 37.89995], [-122.04078, 37.90009], [-122.04011, 37.89962], [-122.03885, 37.90096], [-122.03872, 37.90096], [-122.03864, 37.90084], [-122.03851, 37.90082], [-122.03847, 37.90071], [-122.03837, 37.90076], [-122.03771, 37.90074], [-122.0376, 37.90038], [-122.0373, 37.90052], [-122.0373, 37.90039], [-122.03678, 37.90022], [-122.03675, 37.90034], [-122.03652, 37.90009], [-122.03614, 37.90024], [-122.03554, 37.89975], [-122.03564, 37.89966], [-122.03564, 37.89964], [-122.03527, 37.89957], [-122.03516, 37.89946], [-122.03529, 37.89927], [-122.03483, 37.89932], [-122.03438, 37.89889], [-122.03412, 37.89857], [-122.03386, 37.89876], [-122.03363, 37.89904], [-122.03309, 37.89903], [-122.03298, 37.89839], [-122.03256, 37.89826], [-122.03243, 37.89849], [-122.03233, 37.89858], [-122.03221, 37.89864], [-122.03206, 37.89867], [-122.0319, 37.89867], [-122.03177, 37.89863], [-122.03163, 37.89856], [-122.03158, 37.89854], [-122.03152, 37.89857], [-122.03136, 37.89872], [-122.03124, 37.89886], [-122.03117, 37.89901], [-122.03097, 37.89987], [-122.03093, 37.89997], [-122.03087, 37.90008], [-122.03226, 37.90119], [-122.03203, 37.90145], [-122.03204, 37.90146], [-122.03221, 37.90155], [-122.03246, 37.90126], [-122.03332, 37.90151], [-122.03346, 37.90426], [-122.02664, 37.90248], [-122.02662, 37.90256], [-122.02634, 37.90502], [-122.02609, 37.90487], [-122.02599, 37.90464], [-122.0255, 37.90442], [-122.0252, 37.90426], [-122.02483, 37.90418], [-122.02382, 37.90386], [-122.02362, 37.90412], [-122.023, 37.90415], [-122.02291, 37.90404], [-122.0231, 37.90387], [-122.0231, 37.90386], [-122.02276, 37.9038], [-122.022, 37.90357], [-122.02103, 37.90346], [-122.02, 37.9039], [-122.01935, 37.90443], [-122.01944, 37.90509], [-122.0193, 37.90557], [-122.01913, 37.9059], [-122.01634, 37.90511], [-122.01708, 37.90336], [-122.01707, 37.90335], [-122.00881, 37.90183], [-122.00868, 37.90229], [-122.0072, 37.90201], [-122.0072, 37.90196], [-122.00381, 37.90134], [-122.00542, 37.89941], [-122.00353, 37.89968], [-122.00416, 37.89666], [-122.00354, 37.89485], [-122.00247, 37.89153], [-121.99981, 37.88434], [-122.01488, 37.88053], [-122.01029, 37.87187], [-122.0154, 37.87274], [-122.01487, 37.87325], [-122.01366, 37.87323], [-122.0132, 37.87377], [-122.0138, 37.87426], [-122.0144, 37.8741], [-122.01453, 37.87396], [-122.01467, 37.87388], [-122.0157, 37.87401], [-122.01562, 37.87431], [-122.01543, 37.87454], [-122.01478, 37.87498], [-122.01419, 37.87578], [-122.0142, 37.87579], [-122.01454, 37.876], [-122.01536, 37.87535], [-122.01615, 37.87546], [-122.01628, 37.87536], [-122.0162, 37.87481], [-122.01605, 37.87472], [-122.01624, 37.87436], [-122.01674, 37.87415], [-122.0173, 37.87408], [-122.01843, 37.87446], [-122.01948, 37.8754], [-122.01968, 37.87547], [-122.02022, 37.87554], [-122.02051, 37.87581], [-122.02087, 37.87701], [-122.02304, 37.87768], [-122.02327, 37.87813], [-122.01502, 37.88078], [-122.01795, 37.8863], [-122.01788, 37.88645], [-122.01755, 37.88785], [-122.01636, 37.88771], [-122.01473, 37.88726], [-122.01381, 37.88723], [-122.01376, 37.88791], [-122.02023, 37.89056], [-122.02028, 37.89063], [-122.02065, 37.89021], [-122.0213, 37.89012], [-122.02436, 37.89057], [-122.02589, 37.89149], [-122.02568, 37.89171], [-122.02588, 37.89183], [-122.0261, 37.89162], [-122.02655, 37.89189], [-122.02883, 37.8921], [-122.02934, 37.8923], [-122.03022, 37.89302], [-122.03089, 37.89309], [-122.03148, 37.89336], [-122.03345, 37.89467], [-122.03681, 37.89619], [-122.04199, 37.89973], [-122.04208, 37.89975], [-122.04224, 37.89983], [-122.04241, 37.89994], [-122.04292, 37.90012], [-122.04311, 37.89981], [-122.04326, 37.89983], [-122.04345, 37.89985], [-122.04377, 37.8998], [-122.04392, 37.89976], [-122.04407, 37.89969], [-122.0443, 37.89952], [-122.04465, 37.89984], [-122.04477, 37.8998], [-122.04524, 37.90051], [-122.04545, 37.9004], [-122.04546, 37.90021], [-122.04623, 37.90014], [-122.04645, 37.90001], [-122.04638, 37.89981], [-122.04682, 37.89969], [-122.04704, 37.90031]], [[-122.0263, 37.89222], [-122.02629, 37.8922], [-122.02603, 37.89205], [-122.02583, 37.89227], [-122.0261, 37.89243], [-122.0263, 37.89222]], [[-122.02932, 37.90175], [-122.02932, 37.90177], [-122.03057, 37.9026], [-122.03106, 37.90214], [-122.02981, 37.9013], [-122.02932, 37.90175]]]} | Open Access 1 | 741 | Shell Ridge Open Space | 14668 | 1371 | Walnut Creek, City of 178 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | http://www.walnut-creek.org/citygov/depts/ps/openspace/shellridge.asp | Contra Costa 12 | 1364.266 | Shell Ridge OS | 2000 | Local Recreation Area 3 | 4 |
16804 | 16804 | 16803 | {"type": "Polygon", "coordinates": [[[-122.33445, 37.58791], [-122.33305, 37.58779], [-122.32861, 37.58893], [-122.32724, 37.58938], [-122.32601, 37.58986], [-122.32518, 37.59024], [-122.32415, 37.59081], [-122.32273, 37.59144], [-122.32189, 37.59167], [-122.32131, 37.59187], [-122.32117, 37.5919], [-122.32114, 37.59198], [-122.3211, 37.59201], [-122.32105, 37.59201], [-122.32098, 37.59197], [-122.32093, 37.59191], [-122.32087, 37.59181], [-122.32079, 37.59176], [-122.3207, 37.59174], [-122.32055, 37.59179], [-122.32048, 37.59177], [-122.32044, 37.59171], [-122.32042, 37.59158], [-122.32035, 37.5915], [-122.32003, 37.5914], [-122.31982, 37.59138], [-122.31941, 37.59142], [-122.31911, 37.59139], [-122.31883, 37.59142], [-122.31855, 37.59136], [-122.31836, 37.59134], [-122.31626, 37.59144], [-122.31586, 37.5915], [-122.31548, 37.59162], [-122.31517, 37.59178], [-122.315, 37.59189], [-122.31472, 37.59223], [-122.31465, 37.59225], [-122.31459, 37.59221], [-122.31459, 37.59217], [-122.31485, 37.59184], [-122.31491, 37.59172], [-122.31504, 37.59162], [-122.31515, 37.59148], [-122.31523, 37.59133], [-122.31527, 37.59115], [-122.31532, 37.59111], [-122.31549, 37.59111], [-122.31567, 37.59108], [-122.31575, 37.5911], [-122.31632, 37.59118], [-122.31651, 37.59118], [-122.31696, 37.59115], [-122.31737, 37.59118], [-122.31815, 37.59116], [-122.31823, 37.59112], [-122.31829, 37.59105], [-122.31813, 37.58693], [-122.31812, 37.58688], [-122.31804, 37.58683], [-122.31744, 37.58675], [-122.31729, 37.5868], [-122.31723, 37.58685], [-122.31719, 37.58692], [-122.31737, 37.59031], [-122.31736, 37.59037], [-122.3173, 37.59043], [-122.31722, 37.59047], [-122.31713, 37.59048], [-122.31706, 37.59046], [-122.31699, 37.59042], [-122.31696, 37.59037], [-122.31694, 37.59032], [-122.31678, 37.5869], [-122.31672, 37.58682], [-122.31662, 37.58679], [-122.31575, 37.58681], [-122.31561, 37.58684], [-122.31548, 37.58692], [-122.3154, 37.58702], [-122.31537, 37.58712], [-122.31536, 37.58785], [-122.31541, 37.58808], [-122.31535, 37.58825], [-122.31535, 37.58834], [-122.31543, 37.58854], [-122.31541, 37.58894], [-122.31548, 37.58935], [-122.31549, 37.58982], [-122.31545, 37.59003], [-122.31533, 37.59027], [-122.31535, 37.59035], [-122.31541, 37.59042], [-122.31543, 37.59046], [-122.31538, 37.59063], [-122.31535, 37.59066], [-122.31531, 37.59068], [-122.31525, 37.59067], [-122.3152, 37.59064], [-122.31516, 37.59057], [-122.31517, 37.59045], [-122.31514, 37.59041], [-122.31481, 37.59036], [-122.31418, 37.59036], [-122.31411, 37.59033], [-122.31404, 37.59028], [-122.314, 37.59022], [-122.31399, 37.59016], [-122.31392, 37.5884], [-122.31399, 37.58785], [-122.31404, 37.58773], [-122.31413, 37.58764], [-122.31423, 37.58757], [-122.3144, 37.58749], [-122.31452, 37.58738], [-122.31455, 37.58732], [-122.31477, 37.58666], [-122.31488, 37.58655], [-122.31504, 37.58646], [-122.31508, 37.58638], [-122.31506, 37.58632], [-122.31502, 37.58629], [-122.31491, 37.58626], [-122.31468, 37.58631], [-122.3145, 37.58642], [-122.31442, 37.58652], [-122.31438, 37.58662], [-122.31418, 37.58727], [-122.31409, 37.58735], [-122.31397, 37.5874], [-122.31394, 37.58738], [-122.31393, 37.58735], [-122.31395, 37.58677], [-122.31395, 37.58632], [-122.31397, 37.58617], [-122.31407, 37.58596], [-122.31414, 37.58587], [-122.31426, 37.58577], [-122.31444, 37.58566], [-122.31483, 37.58551], [-122.31508, 37.58538], [-122.31531, 37.58521], [-122.31548, 37.58504], [-122.31563, 37.58484], [-122.31576, 37.58456], [-122.31594, 37.58425], [-122.31597, 37.58409], [-122.31596, 37.584], [-122.31594, 37.58391], [-122.31598, 37.58396], [-122.3173, 37.58505], [-122.31733, 37.58504], [-122.31748, 37.58517], [-122.31758, 37.5851], [-122.31775, 37.58567], [-122.31788, 37.58596], [-122.31797, 37.58626], [-122.31795, 37.58638], [-122.31856, 37.58615], [-122.31931, 37.58631], [-122.3202, 37.58694], [-122.32072, 37.58807], [-122.32097, 37.58825], [-122.32144, 37.58826], [-122.32144, 37.58824], [-122.32141, 37.58816], [-122.32238, 37.58802], [-122.32249, 37.58799], [-122.32265, 37.58791], [-122.32295, 37.58766], [-122.32309, 37.58759], [-122.32324, 37.58755], [-122.32343, 37.58752], [-122.32421, 37.5875], [-122.32434, 37.58747], [-122.32445, 37.58743], [-122.32776, 37.58515], [-122.32782, 37.58508], [-122.32785, 37.58503], [-122.32787, 37.5849], [-122.32808, 37.58501], [-122.3281, 37.58513], [-122.32815, 37.58529], [-122.32824, 37.58544], [-122.32834, 37.58556], [-122.32851, 37.5857], [-122.32877, 37.58584], [-122.32874, 37.5859], [-122.32895, 37.58599], [-122.33027, 37.58639], [-122.33176, 37.58668], [-122.33237, 37.58684], [-122.33424, 37.58706], [-122.33445, 37.58791]]]} | Open Access 1 | 14075 | Coyote Point Recreation Area | 30386 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 155.347 | Coyote Point Rec. Area | 2000 | Local Recreation Area 3 | 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]);