superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where ACCESS_TYP = 1 and MNG_AGENCY = 497 sorted by PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1135 | 1135 | 1134 | {"type": "Polygon", "coordinates": [[[-120.91097, 37.55865], [-120.91094, 37.56187], [-120.91083, 37.56198], [-120.91056, 37.56195], [-120.9103, 37.56185], [-120.91004, 37.5617], [-120.91003, 37.56159], [-120.91014, 37.56136], [-120.9102, 37.56113], [-120.91018, 37.56085], [-120.91011, 37.56065], [-120.90964, 37.55999], [-120.90964, 37.55861], [-120.90972, 37.55856], [-120.91088, 37.55856], [-120.91097, 37.55865]]]} | Open Access 1 | Bonita Ranch Park | 33610 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 8.734 | Bonita Ranch Park | ||
2145 | 2145 | 2144 | {"type": "Polygon", "coordinates": [[[-121.07603, 37.39301], [-121.07567, 37.39319], [-121.07512, 37.39252], [-121.07553, 37.39229], [-121.07603, 37.39291], [-121.07603, 37.39301]]]} | Open Access 1 | Bonita Park | 16261 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 0.972 | Bonita Park | ||
2236 | 2236 | 2235 | {"type": "Polygon", "coordinates": [[[-121.00441, 37.60578], [-121.00352, 37.60681], [-121.00275, 37.60737], [-121.00274, 37.6072], [-121.00281, 37.60714], [-121.00282, 37.60578], [-121.00441, 37.60578]]]} | Open Access 1 | Bret Harte Park | 16364 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 3.342 | Bret Harte Park | ||
2357 | 2357 | 2356 | {"type": "Polygon", "coordinates": [[[-121.02794, 37.62238], [-121.02735, 37.6224], [-121.02736, 37.62169], [-121.02793, 37.62169], [-121.02794, 37.62238]]]} | Open Access 1 | Burbank-Paradise Park | 16507 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 0.984 | Burbank-Paradise Park | ||
3239 | 3239 | 3238 | {"type": "Polygon", "coordinates": [[[-121.09577, 37.7178], [-121.09127, 37.71403], [-121.09126, 37.71312], [-121.09164, 37.7131], [-121.09171, 37.71306], [-121.09259, 37.71306], [-121.09263, 37.71321], [-121.09276, 37.71343], [-121.09273, 37.71358], [-121.0926, 37.71383], [-121.09238, 37.71412], [-121.09235, 37.7142], [-121.09238, 37.71433], [-121.09238, 37.71464], [-121.09247, 37.7149], [-121.09256, 37.71502], [-121.09267, 37.71512], [-121.09282, 37.71521], [-121.09314, 37.71533], [-121.09328, 37.71541], [-121.09445, 37.71639], [-121.09463, 37.7165], [-121.09475, 37.71655], [-121.09503, 37.7166], [-121.09567, 37.71659], [-121.09576, 37.71666], [-121.09577, 37.7178]]]} | Open Access 1 | Country Stone Park | 17704 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 7.832 | Country Stone Park | ||
3997 | 3997 | 3996 | {"type": "Polygon", "coordinates": [[[-120.89849, 37.63946], [-120.89787, 37.63947], [-120.89787, 37.6397], [-120.8961, 37.63972], [-120.89606, 37.63842], [-120.89783, 37.6384], [-120.89784, 37.63909], [-120.89848, 37.63909], [-120.89849, 37.63946]]]} | Open Access 1 | Empire Community Park | 18633 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 6.12 | Empire Community Park | ||
4153 | 4153 | 4152 | {"type": "Polygon", "coordinates": [[[-121.01692, 37.59738], [-121.01558, 37.59738], [-121.01558, 37.59597], [-121.01691, 37.59597], [-121.01692, 37.59738]]]} | Open Access 1 | Fairview Park | 18814 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 4.544 | Fairview Park | ||
4959 | 4959 | 4958 | {"type": "Polygon", "coordinates": [[[-120.90829, 37.55597], [-120.90828, 37.55697], [-120.9071, 37.55696], [-120.90712, 37.55515], [-120.9071, 37.55494], [-120.90829, 37.55597]]]} | Open Access 1 | Hatch Park | 19734 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 4.28 | Hatch Park | ||
5892 | 5892 | 5891 | {"type": "Polygon", "coordinates": [[[-121.15351, 37.55867], [-121.15342, 37.55922], [-121.15241, 37.56063], [-121.15219, 37.56101], [-121.15202, 37.5623], [-121.1514, 37.5623], [-121.15138, 37.56245], [-121.14394, 37.56241], [-121.14336, 37.56245], [-121.14285, 37.56254], [-121.14237, 37.56267], [-121.14183, 37.56287], [-121.14132, 37.56312], [-121.14093, 37.56337], [-121.14068, 37.56356], [-121.1404, 37.56381], [-121.14046, 37.56367], [-121.14049, 37.56248], [-121.1406, 37.56247], [-121.14057, 37.56017], [-121.14123, 37.55998], [-121.14173, 37.55982], [-121.14235, 37.55968], [-121.14386, 37.55973], [-121.14432, 37.55991], [-121.14472, 37.56012], [-121.14584, 37.56094], [-121.14669, 37.56121], [-121.14749, 37.56121], [-121.14815, 37.56099], [-121.149, 37.56018], [-121.1492, 37.55977], [-121.14922, 37.55949], [-121.14945, 37.55901], [-121.14945, 37.55862], [-121.14951, 37.55826], [-121.14955, 37.5578], [-121.14935, 37.55734], [-121.14924, 37.55716], [-121.14886, 37.55678], [-121.14853, 37.55647], [-121.14821, 37.55604], [-121.14823, 37.55597], [-121.14841, 37.55571], [-121.1485, 37.55563], [-121.14863, 37.55557], [-121.14895, 37.55548], [-121.14925, 37.55545], [-121.14933, 37.55547], [-121.14985, 37.55587], [-121.15133, 37.5566], [-121.15251, 37.55738], [-121.15313, 37.55807], [-121.15351, 37.55867]]]} | Open Access 1 | Laird Park | 20874 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 99.027 | Laird Park | ||
6115 | 6115 | 6114 | {"type": "Polygon", "coordinates": [[[-121.17809, 37.56485], [-121.1776, 37.56498], [-121.17742, 37.5646], [-121.17791, 37.56446], [-121.17809, 37.56485]]]} | Open Access 1 | Leroy F. Fitzsimmons Memorial Park | 21176 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 0.518 | Leroy F. Fitzsimmons Memorial Park | ||
7110 | 7110 | 7109 | {"type": "Polygon", "coordinates": [[[-120.97809, 37.63478], [-120.97809, 37.63538], [-120.97657, 37.63538], [-120.97657, 37.63478], [-120.97809, 37.63478]]]} | Open Access 1 | Mono Park | 22372 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 2.215 | Mono Park | ||
7291 | 7291 | 7290 | {"type": "Polygon", "coordinates": [[[-121.0839, 37.69637], [-121.08383, 37.69708], [-121.08133, 37.6971], [-121.08137, 37.69646], [-121.08147, 37.69639], [-121.08182, 37.69638], [-121.08201, 37.69641], [-121.08222, 37.69641], [-121.08239, 37.69638], [-121.0839, 37.69637]]]} | Open Access 1 | Murphy Park | 22607 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 4.294 | Murphy Park | ||
7747 | 7747 | 7746 | {"type": "Polygon", "coordinates": [[[-120.97098, 37.6315], [-120.97077, 37.63151], [-120.97078, 37.63178], [-120.9708, 37.63181], [-120.97081, 37.63206], [-120.97021, 37.63174], [-120.96996, 37.63163], [-120.96969, 37.63155], [-120.96869, 37.63136], [-120.96877, 37.63111], [-120.97097, 37.63111], [-120.97098, 37.6315]]]} | Open Access 1 | Oregon Drive Park | 23200 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 2.735 | Oregon Drive Park | ||
8780 | 8780 | 8779 | {"type": "Polygon", "coordinates": [[[-121.03961, 37.61249], [-121.03853, 37.61234], [-121.03855, 37.61167], [-121.03939, 37.61135], [-121.03959, 37.61164], [-121.03961, 37.61249]]]} | Open Access 1 | Riverdale Park | 24439 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 2.32 | Riverdale Park | ||
9116 | 9116 | 9115 | {"type": "Polygon", "coordinates": [[[-121.08623, 37.70481], [-121.08544, 37.70542], [-121.08476, 37.70485], [-121.08556, 37.70424], [-121.08623, 37.70481]]]} | Open Access 1 | Salida Park | 24796 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 2.087 | Salida Park | ||
9488 | 9488 | 9487 | {"type": "Polygon", "coordinates": [[[-121.08929, 37.72089], [-121.08834, 37.7209], [-121.08797, 37.72089], [-121.08741, 37.7209], [-121.08698, 37.7209], [-121.08694, 37.71936], [-121.08702, 37.71929], [-121.08794, 37.71927], [-121.08802, 37.71925], [-121.08809, 37.71921], [-121.08847, 37.71918], [-121.08925, 37.71918], [-121.08929, 37.72089]]]} | Open Access 1 | Segesta Park | 25287 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 9.318 | Segesta Park | ||
9826 | 9826 | 9825 | {"type": "Polygon", "coordinates": [[[-120.79984, 37.51646], [-120.79984, 37.51725], [-120.79971, 37.51726], [-120.7997, 37.51759], [-120.79865, 37.51758], [-120.79866, 37.51646], [-120.79984, 37.51646]]]} | Open Access 1 | Sterling Ranch Park | 25835 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 3.142 | Sterling Ranch Park | ||
10553 | 10553 | 10552 | {"type": "Polygon", "coordinates": [[[-121.18041, 37.56148], [-121.17609, 37.56266], [-121.17586, 37.56246], [-121.17687, 37.56164], [-121.17721, 37.56192], [-121.18024, 37.56108], [-121.18041, 37.56148]]]} | Open Access 1 | United Community Center and Park | 26664 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 5.044 | United Community Ctr. and Park | ||
11310 | 11310 | 11309 | {"type": "Polygon", "coordinates": [[[-121.07816, 37.70258], [-121.07785, 37.70265], [-121.07749, 37.70235], [-121.0774, 37.7024], [-121.07252, 37.69817], [-121.07366, 37.69819], [-121.07367, 37.69846], [-121.07398, 37.69847], [-121.07399, 37.69876], [-121.07442, 37.69914], [-121.07506, 37.69914], [-121.07507, 37.69947], [-121.07512, 37.69965], [-121.07525, 37.69988], [-121.07643, 37.70091], [-121.07769, 37.70197], [-121.07784, 37.70211], [-121.07789, 37.70221], [-121.07797, 37.70224], [-121.07804, 37.70225], [-121.07816, 37.70258]]]} | Open Access 1 | Wincanton Park | 27616 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 8.768 | Wincanton Park | ||
15072 | 15072 | 15071 | {"type": "MultiPolygon", "coordinates": [[[[-121.35293, 37.42038], [-121.35281, 37.433], [-121.34756, 37.44017], [-121.32798, 37.44253], [-121.3315, 37.4379], [-121.33162, 37.43787], [-121.33212, 37.43803], [-121.33262, 37.43833], [-121.33274, 37.43872], [-121.33286, 37.43918], [-121.33341, 37.43929], [-121.334, 37.43934], [-121.33456, 37.43921], [-121.33527, 37.43914], [-121.3357, 37.43894], [-121.33614, 37.43849], [-121.33624, 37.438], [-121.33596, 37.4375], [-121.3359, 37.43632], [-121.33596, 37.43574], [-121.33614, 37.43519], [-121.3364, 37.43483], [-121.33662, 37.43479], [-121.33662, 37.43333], [-121.33705, 37.43295], [-121.33707, 37.43241], [-121.33696, 37.43182], [-121.33706, 37.4312], [-121.33697, 37.43063], [-121.33664, 37.43014], [-121.33655, 37.42964], [-121.33681, 37.4292], [-121.33716, 37.42907], [-121.33813, 37.43019], [-121.33993, 37.4292], [-121.33921, 37.42829], [-121.34039, 37.42719], [-121.34099, 37.42655], [-121.34163, 37.42605], [-121.34198, 37.42544], [-121.34279, 37.42408], [-121.34296, 37.42334], [-121.34308, 37.4226], [-121.34338, 37.4219], [-121.34361, 37.42127], [-121.34411, 37.42086], [-121.34483, 37.42062], [-121.34572, 37.42057], [-121.34665, 37.42056], [-121.34756, 37.42046], [-121.34842, 37.42048], [-121.34919, 37.42065], [-121.34985, 37.42098], [-121.35065, 37.42124], [-121.35151, 37.42113], [-121.35218, 37.4208], [-121.35285, 37.42046], [-121.35293, 37.42038]]], [[[-121.33605, 37.43487], [-121.33588, 37.43511], [-121.3357, 37.43571], [-121.33563, 37.43631], [-121.33569, 37.43755], [-121.33596, 37.43804], [-121.33588, 37.43839], [-121.33551, 37.43878], [-121.33519, 37.43893], [-121.33452, 37.43898], [-121.33397, 37.43912], [-121.33345, 37.43908], [-121.3331, 37.43901], [-121.33302, 37.43867], [-121.33285, 37.43821], [-121.33227, 37.43783], [-121.33167, 37.43765], [-121.33356, 37.43515], [-121.33605, 37.43487]]], [[[-121.35295, 37.41858], [-121.35294, 37.42008], [-121.35266, 37.42028], [-121.35202, 37.42062], [-121.35141, 37.42092], [-121.35068, 37.42102], [-121.34998, 37.42079], [-121.34931, 37.42045], [-121.34846, 37.42026], [-121.34755, 37.42025], [-121.34663, 37.42035], [-121.34571, 37.42036], [-121.34476, 37.4204], [-121.34395, 37.42068], [-121.34337, 37.42116], [-121.34311, 37.42184], [-121.34282, 37.42254], [-121.34269, 37.42331], [-121.34252, 37.42402], [-121.34173, 37.42534], [-121.3414, 37.42593], [-121.34078, 37.42641], [-121.34017, 37.42705], [-121.33905, 37.42811], [-121.33755, 37.4263], [-121.33567, 37.42727], [-121.33567, 37.42729], [-121.33701, 37.42888], [-121.33661, 37.42903], [-121.33628, 37.42959], [-121.33636, 37.43021], [-121.3367, 37.4307], [-121.33678, 37.43121], [-121.33668, 37.43182], [-121.33679, 37.43242], [-121.33679, 37.43286], [-121.33661, 37.43301], [-121.3366, 37.43076], [-121.33355, 37.4311], [-121.33356, 37.4208], [-121.35254, 37.41859], [-121.35295, 37.41858]]], [[[-121.40707, 37.44857], [-121.40202, 37.4486], [-121.40178, 37.44821], [-121.40106, 37.44767], [-121.40093, 37.44754], [-121.40079, 37.44744], [-121.40026, 37.44725], [-121.39987, 37.44718], [-121.39954, 37.44705], [-121.3992, 37.44694], [-121.39763, 37.44691], [-121.39697, 37.44681], [-121.39656, 37.44671], [-121.39597, 37.44638], [-121.39537, 37.44616], [-121.3948, 37.44604], [-121.39389, 37.44591], [-121.39254, 37.4459], [-121.39162, 37.44554], [-121.38969, 37.44484], [-121.38911, 37.44427], [-121.38811, 37.444], [-121.38783, 37.44381], [-121.3875, 37.44319], [-121.38731, 37.44286], [-121.38708, 37.4426], [-121.38671, 37.44235], [-121.38639, 37.44224], [-121.38606, 37.4423], [-121.38531, 37.44272], [-121.38505, 37.44275], [-121.38481, 37.44268], [-121.38415, 37.44228], [-121.38386, 37.44209], [-121.38378, 37.44207], [-121.38357, 37.44197], [-121.3834, 37.44176], [-121.38322, 37.44147], [-121.3826, 37.44089], [-121.38228, 37.44056], [-121.38213, 37.44033], [-121.38193, 37.44015], [-121.37475, 37.44064], [-121.37532, 37.4398], [-121.3753, 37.43977], [-121.36599, 37.4404], [-121.37108, 37.43261], [-121.37099, 37.41847], [-121.36185, 37.41852], [-121.36199, 37.41135], [-121.35292, 37.41137], [-121.35311, 37.40421], [-121.36204, 37.40411], [-121.36285, 37.40837], [-121.36397, 37.40841], [-121.36501, 37.40828], [-121.36528, 37.4086], [-121.36541, 37.40932], [-121.36545, 37.41012], [-121.36654, 37.41208], [-121.36643, 37.41237], [-121.36659, 37.41303], [-121.36721, 37.41417], [-121.36746, 37.41426], [-121.36788, 37.41449], [-121.36882, 37.41512], [-121.37026, 37.41518], [-121.37089, 37.41527], [-121.37111, 37.41544], [-121.37168, 37.41593], [-121.37204, 37.41651], [-121.37309, 37.41669], [-121.37361, 37.4173], [-121.37416, 37.41761], [-121.37451, 37.4179], [-121.37483, 37.41844], [-121.38892, 37.41835], [-121.39212, 37.41822], [-121.39202, 37.41827], [-121.392, 37.41835], [-121.39245, 37.41885], [-121.39341, 37.41905], [-121.39335, 37.42518], [-121.39336, 37.42889], [-121.39334, 37.43151], [-121.39457, 37.43248], [-121.39786, 37.43251], [-121.39797, 37.43605], [-121.40693, 37.43597], [-121.40707, 37.44857]]]]} | Open Access 1 | Frank Raines Regional Park | http://www.stancounty.com/ER/PARKS/off-road-park.shtm | 12793 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 2981.91 | Frank Raines RP |
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]);