superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AGENCY = 28 and MNG_AG_LEV = 3 sorted by YR_EST
This data as json, copyable, CSV (advanced)
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12231 | 12231 | 12230 | {"type": "Polygon", "coordinates": [[[-122.29114, 37.46925], [-122.29093, 37.46943], [-122.29082, 37.4694], [-122.29059, 37.46956], [-122.29034, 37.46969], [-122.29, 37.46982], [-122.28962, 37.46991], [-122.28961, 37.46996], [-122.28843, 37.4702], [-122.28839, 37.47015], [-122.28761, 37.47031], [-122.28736, 37.4704], [-122.28718, 37.4705], [-122.287, 37.47063], [-122.28684, 37.4708], [-122.28675, 37.47094], [-122.28651, 37.47139], [-122.2864, 37.47155], [-122.28621, 37.47174], [-122.28522, 37.47255], [-122.28502, 37.47263], [-122.2849, 37.47284], [-122.28373, 37.47382], [-122.28342, 37.47404], [-122.28314, 37.4742], [-122.28283, 37.47433], [-122.28256, 37.47443], [-122.282, 37.47456], [-122.28165, 37.47459], [-122.2813, 37.4746], [-122.28101, 37.47459], [-122.28067, 37.47455], [-122.27903, 37.47418], [-122.2785, 37.47407], [-122.27825, 37.47405], [-122.27824, 37.47375], [-122.27822, 37.47375], [-122.27815, 37.4738], [-122.27819, 37.47358], [-122.27792, 37.47318], [-122.27796, 37.47309], [-122.2779, 37.47291], [-122.27776, 37.47276], [-122.27781, 37.4727], [-122.27728, 37.47212], [-122.27699, 37.47173], [-122.27677, 37.47183], [-122.27673, 37.4716], [-122.27629, 37.47062], [-122.27588, 37.47004], [-122.2759, 37.47001], [-122.27583, 37.46984], [-122.27566, 37.46966], [-122.27567, 37.4696], [-122.27546, 37.4696], [-122.27537, 37.46949], [-122.27532, 37.46935], [-122.27536, 37.46922], [-122.27525, 37.46917], [-122.27527, 37.469], [-122.27516, 37.46888], [-122.2753, 37.46878], [-122.27523, 37.46853], [-122.27511, 37.46841], [-122.27504, 37.46805], [-122.27514, 37.4677], [-122.27484, 37.46735], [-122.27469, 37.46711], [-122.2744, 37.46702], [-122.2739, 37.46676], [-122.27328, 37.4666], [-122.27289, 37.46636], [-122.27267, 37.46628], [-122.27233, 37.46623], [-122.27205, 37.46615], [-122.27402, 37.46458], [-122.2741, 37.46454], [-122.2742, 37.46444], [-122.27494, 37.46385], [-122.27494, 37.46382], [-122.27506, 37.46371], [-122.27525, 37.46338], [-122.27533, 37.46313], [-122.27537, 37.46308], [-122.27547, 37.46301], [-122.27554, 37.4629], [-122.27562, 37.46243], [-122.27568, 37.46224], [-122.27568, 37.46197], [-122.27571, 37.46192], [-122.27578, 37.4619], [-122.27616, 37.46193], [-122.27651, 37.46191], [-122.27716, 37.46212], [-122.27951, 37.4603], [-122.2848, 37.45612], [-122.28585, 37.45684], [-122.28481, 37.45766], [-122.28482, 37.45769], [-122.28722, 37.45927], [-122.28821, 37.45848], [-122.28862, 37.45963], [-122.28844, 37.46114], [-122.28936, 37.46292], [-122.29013, 37.46541], [-122.29022, 37.46755], [-122.29114, 37.46925]]]} | Open Access 1 | Edgewood Park and Natural Preserve | http://parks.smcgov.org/edgewood-park-natural-preserve | 29213 | 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 | 475.639 | Edgewood Park and Natural Preserve | 2000 |
13114 | 13114 | 13113 | {"type": "Polygon", "coordinates": [[[-122.39077, 37.18393], [-122.39073, 37.18394], [-122.39048, 37.18419], [-122.3904, 37.18422], [-122.39031, 37.18422], [-122.3899, 37.18409], [-122.38951, 37.18398], [-122.38911, 37.18389], [-122.38871, 37.18383], [-122.38428, 37.18345], [-122.38344, 37.18335], [-122.38282, 37.18325], [-122.38249, 37.18217], [-122.38261, 37.18223], [-122.38278, 37.18226], [-122.38295, 37.18226], [-122.38312, 37.18222], [-122.38329, 37.18223], [-122.38342, 37.18233], [-122.38374, 37.18242], [-122.38392, 37.18241], [-122.38409, 37.18242], [-122.38424, 37.18249], [-122.38441, 37.18253], [-122.38451, 37.18263], [-122.38468, 37.18263], [-122.385, 37.18275], [-122.38512, 37.18285], [-122.38527, 37.18291], [-122.38539, 37.18301], [-122.38555, 37.18308], [-122.38568, 37.18317], [-122.38601, 37.18326], [-122.38619, 37.18325], [-122.38634, 37.18333], [-122.38667, 37.18331], [-122.38697, 37.18318], [-122.38714, 37.18315], [-122.38749, 37.18322], [-122.38783, 37.18321], [-122.388, 37.18317], [-122.38814, 37.1831], [-122.3883, 37.18304], [-122.38845, 37.18296], [-122.38897, 37.18297], [-122.38925, 37.18279], [-122.38941, 37.18278], [-122.38955, 37.18287], [-122.3897, 37.18293], [-122.38982, 37.18304], [-122.38999, 37.18305], [-122.39012, 37.18314], [-122.3903, 37.18314], [-122.39056, 37.18312], [-122.39077, 37.18393]]]} | Open Access 1 | Pigeon Point County Park | 30390 | 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 | 15.22 | Pigeon Point County Park | 2000 | |
15435 | 15435 | 15434 | {"type": "Polygon", "coordinates": [[[-122.33445, 37.58791], [-122.33304, 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.32004, 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.59104], [-122.31814, 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.58784], [-122.31541, 37.58808], [-122.31535, 37.58825], [-122.31535, 37.58833], [-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.31543, 37.59046], [-122.31538, 37.59063], [-122.31535, 37.59066], [-122.31531, 37.59067], [-122.31525, 37.59067], [-122.3152, 37.59064], [-122.31516, 37.59057], [-122.31517, 37.59045], [-122.31513, 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.31415, 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.58505], [-122.31563, 37.58483], [-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.58637], [-122.31856, 37.58615], [-122.31931, 37.58631], [-122.3202, 37.58694], [-122.32072, 37.58807], [-122.32097, 37.58825], [-122.32143, 37.58826], [-122.32144, 37.58824], [-122.32141, 37.58816], [-122.32238, 37.58802], [-122.32248, 37.58799], [-122.32265, 37.58791], [-122.32295, 37.58766], [-122.32309, 37.58759], [-122.32324, 37.58755], [-122.32344, 37.58752], [-122.32421, 37.5875], [-122.32434, 37.58747], [-122.32445, 37.58744], [-122.32775, 37.58515], [-122.32782, 37.58509], [-122.32785, 37.58503], [-122.32787, 37.5849], [-122.32808, 37.58501], [-122.3281, 37.58514], [-122.32815, 37.58529], [-122.32824, 37.58544], [-122.32834, 37.58556], [-122.32851, 37.5857], [-122.32877, 37.58584], [-122.32875, 37.58591], [-122.32895, 37.58599], [-122.33027, 37.58639], [-122.33176, 37.58668], [-122.33236, 37.58684], [-122.33424, 37.58706], [-122.33445, 37.58791]]]} | Open Access 1 | 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 | 155.365 | Coyote Point Rec. Area | 2000 | |
7040 | 7040 | 7039 | {"type": "MultiPolygon", "coordinates": [[[[-122.46304, 37.49846], [-122.46257, 37.4993], [-122.46263, 37.50003], [-122.45814, 37.50031], [-122.45789, 37.50012], [-122.46102, 37.49766], [-122.46304, 37.49846]]], [[[-122.46299, 37.49613], [-122.46315, 37.49627], [-122.46327, 37.49635], [-122.46384, 37.49662], [-122.46402, 37.49673], [-122.46465, 37.49723], [-122.46594, 37.49809], [-122.46709, 37.4987], [-122.46721, 37.49881], [-122.46731, 37.49897], [-122.46741, 37.4993], [-122.4674, 37.49937], [-122.46738, 37.49941], [-122.46732, 37.49945], [-122.46726, 37.49947], [-122.46719, 37.49948], [-122.46712, 37.49947], [-122.4615, 37.49729], [-122.46299, 37.49613]]], [[[-122.46738, 37.49855], [-122.46727, 37.49867], [-122.46709, 37.49854], [-122.46607, 37.49801], [-122.46476, 37.49713], [-122.46412, 37.49663], [-122.46395, 37.49653], [-122.46336, 37.49625], [-122.46321, 37.49615], [-122.4631, 37.49605], [-122.46335, 37.49585], [-122.46362, 37.49607], [-122.46376, 37.4962], [-122.46398, 37.49639], [-122.46424, 37.49655], [-122.46439, 37.49669], [-122.46455, 37.49681], [-122.46482, 37.49695], [-122.46537, 37.49727], [-122.46576, 37.49758], [-122.4661, 37.49781], [-122.46645, 37.49802], [-122.46701, 37.4983], [-122.46738, 37.49855]]]]} | Open Access 1 | Mirada Surf Park | 22282 | 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 | 36.503 | Mirada Surf Park | 2002 |
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]);