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_TYP = 7
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- County Agency - Parks · 4 ✖
MNG_AGENCY 1
- San Mateo County Parks and Recreation Dept., County of · 4 ✖
ACCESS_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
13115 | 13115 | 13114 | {"type": "MultiPolygon", "coordinates": [[[[-122.46492, 37.5095], [-122.46477, 37.50991], [-122.46465, 37.51006], [-122.4644, 37.5103], [-122.46427, 37.51052], [-122.46356, 37.51289], [-122.46303, 37.51306], [-122.46278, 37.51328], [-122.4626, 37.51366], [-122.4618, 37.51368], [-122.46108, 37.51434], [-122.46079, 37.51447], [-122.46081, 37.51456], [-122.4609, 37.51466], [-122.46094, 37.5147], [-122.46108, 37.51477], [-122.46113, 37.51484], [-122.4607, 37.51502], [-122.46019, 37.51538], [-122.45989, 37.51561], [-122.45977, 37.51576], [-122.45949, 37.51621], [-122.45938, 37.51633], [-122.45936, 37.51644], [-122.45932, 37.51651], [-122.4592, 37.51659], [-122.45913, 37.51662], [-122.45893, 37.51665], [-122.45865, 37.51662], [-122.45851, 37.51658], [-122.45819, 37.51644], [-122.45754, 37.51632], [-122.45741, 37.51627], [-122.45732, 37.51617], [-122.45724, 37.51593], [-122.45715, 37.51581], [-122.45652, 37.51534], [-122.45645, 37.51524], [-122.45631, 37.51496], [-122.45616, 37.51476], [-122.45599, 37.51461], [-122.45566, 37.5144], [-122.45553, 37.51428], [-122.45545, 37.51417], [-122.45524, 37.51376], [-122.45517, 37.51367], [-122.45499, 37.51354], [-122.45449, 37.51336], [-122.45655, 37.51304], [-122.45569, 37.51077], [-122.45212, 37.51129], [-122.4521, 37.51154], [-122.45311, 37.5122], [-122.45338, 37.51227], [-122.45353, 37.51233], [-122.45368, 37.51246], [-122.4537, 37.51254], [-122.45366, 37.51277], [-122.45368, 37.51292], [-122.45376, 37.51307], [-122.45389, 37.5132], [-122.45407, 37.5133], [-122.45491, 37.5136], [-122.45507, 37.5137], [-122.45515, 37.51379], [-122.45537, 37.51421], [-122.45545, 37.51433], [-122.4556, 37.51446], [-122.4559, 37.51466], [-122.45607, 37.51481], [-122.45621, 37.51499], [-122.45635, 37.51527], [-122.45645, 37.51539], [-122.45707, 37.51585], [-122.45714, 37.51596], [-122.45722, 37.5162], [-122.45732, 37.51631], [-122.4574, 37.51636], [-122.4575, 37.5164], [-122.45816, 37.51652], [-122.45851, 37.51667], [-122.44941, 37.51586], [-122.44972, 37.51408], [-122.44817, 37.50926], [-122.44817, 37.50916], [-122.44842, 37.50822], [-122.44898, 37.50781], [-122.44921, 37.50707], [-122.44974, 37.50607], [-122.44982, 37.5057], [-122.45031, 37.50411], [-122.45095, 37.50276], [-122.45228, 37.50148], [-122.45505, 37.4988], [-122.45574, 37.4992], [-122.4557, 37.49923], [-122.4557, 37.49925], [-122.45732, 37.50056], [-122.45789, 37.50012], [-122.45814, 37.50032], [-122.45817, 37.50039], [-122.45823, 37.5005], [-122.4584, 37.50063], [-122.45903, 37.50088], [-122.45932, 37.50103], [-122.45988, 37.50137], [-122.46063, 37.50166], [-122.46103, 37.50188], [-122.46263, 37.50178], [-122.46268, 37.50232], [-122.46272, 37.50252], [-122.4628, 37.50278], [-122.46292, 37.50305], [-122.46308, 37.5033], [-122.46329, 37.50356], [-122.46351, 37.50375], [-122.46378, 37.50394], [-122.4636, 37.50414], [-122.46355, 37.50428], [-122.46333, 37.50453], [-122.4634, 37.5049], [-122.46365, 37.50504], [-122.46365, 37.50525], [-122.46265, 37.5064], [-122.46316, 37.5067], [-122.46321, 37.50707], [-122.46324, 37.50715], [-122.46317, 37.50728], [-122.46322, 37.50734], [-122.46314, 37.50737], [-122.46315, 37.50743], [-122.46332, 37.50737], [-122.46354, 37.50798], [-122.46395, 37.50818], [-122.46389, 37.50889], [-122.46434, 37.50938], [-122.46492, 37.5095]]], [[[-122.4645, 37.51484], [-122.46327, 37.51708], [-122.45906, 37.51671], [-122.45915, 37.5167], [-122.45924, 37.51667], [-122.45939, 37.51657], [-122.45945, 37.51648], [-122.45948, 37.51635], [-122.45957, 37.51626], [-122.45986, 37.5158], [-122.45998, 37.51566], [-122.46043, 37.51532], [-122.46076, 37.51509], [-122.46104, 37.51497], [-122.46115, 37.51508], [-122.46137, 37.51517], [-122.46141, 37.51521], [-122.4622, 37.51575], [-122.46222, 37.51563], [-122.46227, 37.51557], [-122.46254, 37.51549], [-122.46262, 37.51544], [-122.4627, 37.51536], [-122.46285, 37.51539], [-122.46298, 37.51535], [-122.46306, 37.51527], [-122.46308, 37.51512], [-122.46313, 37.51505], [-122.46358, 37.51482], [-122.46377, 37.51468], [-122.46388, 37.51466], [-122.46409, 37.51465], [-122.4645, 37.51484]]]]} | Open Access 1 | Quarry Park | http://parks.smcgov.org/quarry-park | 30391 | 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 | 504.238 | Quarry Park | |
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 | |
15572 | 15572 | 15571 | {"type": "Polygon", "coordinates": [[[-122.44907, 37.70164], [-122.44695, 37.70279], [-122.44598, 37.70227], [-122.44575, 37.70217], [-122.44551, 37.70208], [-122.44361, 37.70161], [-122.44327, 37.70156], [-122.44284, 37.70156], [-122.44274, 37.70138], [-122.44262, 37.70126], [-122.4419, 37.7008], [-122.44066, 37.70092], [-122.44064, 37.70094], [-122.44124, 37.70273], [-122.44096, 37.7037], [-122.4397, 37.7037], [-122.43851, 37.70406], [-122.438, 37.704], [-122.43697, 37.70439], [-122.4362, 37.7043], [-122.43532, 37.7044], [-122.43459, 37.70436], [-122.43413, 37.70446], [-122.43398, 37.70467], [-122.43383, 37.70462], [-122.4336, 37.70461], [-122.43349, 37.70458], [-122.43338, 37.70453], [-122.4332, 37.70439], [-122.43302, 37.70432], [-122.43276, 37.70429], [-122.43247, 37.7043], [-122.43192, 37.70404], [-122.43162, 37.70431], [-122.43171, 37.70461], [-122.43152, 37.70478], [-122.43141, 37.70481], [-122.43142, 37.70482], [-122.43148, 37.70482], [-122.43136, 37.70488], [-122.43118, 37.7049], [-122.43072, 37.70478], [-122.43052, 37.70476], [-122.43031, 37.70475], [-122.42995, 37.7048], [-122.42937, 37.70497], [-122.42917, 37.70497], [-122.429, 37.70494], [-122.42897, 37.70491], [-122.42902, 37.70474], [-122.42902, 37.70462], [-122.42888, 37.70403], [-122.42876, 37.70374], [-122.4285, 37.70331], [-122.42839, 37.70321], [-122.42792, 37.70287], [-122.4272, 37.70349], [-122.42551, 37.70158], [-122.42569, 37.70113], [-122.42477, 37.70005], [-122.42376, 37.70022], [-122.42353, 37.70032], [-122.42283, 37.70025], [-122.42269, 37.70022], [-122.42217, 37.69846], [-122.42341, 37.69681], [-122.42366, 37.69657], [-122.42396, 37.69637], [-122.42431, 37.69623], [-122.42468, 37.69614], [-122.42508, 37.69612], [-122.42534, 37.69614], [-122.42565, 37.69621], [-122.42589, 37.69629], [-122.42612, 37.6964], [-122.42887, 37.69833], [-122.42919, 37.69852], [-122.42949, 37.69862], [-122.42987, 37.6987], [-122.43026, 37.69871], [-122.43065, 37.69866], [-122.43095, 37.69857], [-122.43124, 37.69843], [-122.43149, 37.69826], [-122.4317, 37.69806], [-122.4318, 37.69793], [-122.43191, 37.69774], [-122.43243, 37.69655], [-122.43257, 37.69637], [-122.43274, 37.6962], [-122.43299, 37.69604], [-122.43333, 37.69591], [-122.4337, 37.69584], [-122.43408, 37.69585], [-122.43429, 37.69589], [-122.4345, 37.69595], [-122.43627, 37.69661], [-122.43688, 37.69687], [-122.43746, 37.69717], [-122.43981, 37.69866], [-122.44012, 37.69883], [-122.44045, 37.69896], [-122.44753, 37.70159], [-122.44784, 37.70167], [-122.44816, 37.70169], [-122.44855, 37.70167], [-122.44893, 37.70159], [-122.44907, 37.70164]]]} | Open Access 1 | San Bruno Mountain State Park | http://www.parks.ca.gov/?page_id=518 | 30691 | 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 | 297.871 | San Bruno Mtn. SP | 1980 |
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]);