superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
69 rows where MNG_AGENCY = 117
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2144 | 2144 | 2143 | {"type": "Polygon", "coordinates": [[[-116.99759, 32.65572], [-116.99525, 32.65807], [-116.99418, 32.65763], [-116.99362, 32.65738], [-116.99358, 32.65732], [-116.99387, 32.65684], [-116.99422, 32.65698], [-116.99435, 32.65678], [-116.9947, 32.65639], [-116.99492, 32.65576], [-116.99759, 32.65572]]]} | Open Access 1 | Bonita Long Canyon Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/bonita-long-canyon-park | 16260 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 12.069 | Bonita Long Canyon Park | |
2222 | 2222 | 2221 | {"type": "Polygon", "coordinates": [[[-116.98456, 32.63845], [-116.98455, 32.63849], [-116.98452, 32.63851], [-116.98444, 32.63854], [-116.98433, 32.63855], [-116.98428, 32.63857], [-116.98425, 32.63864], [-116.98427, 32.63871], [-116.9842, 32.63876], [-116.9841, 32.63879], [-116.984, 32.63879], [-116.98397, 32.63872], [-116.98392, 32.63869], [-116.98387, 32.63869], [-116.98381, 32.6387], [-116.98374, 32.63876], [-116.98358, 32.63881], [-116.98353, 32.63879], [-116.98341, 32.63835], [-116.9834, 32.63819], [-116.98335, 32.6381], [-116.98378, 32.63786], [-116.98375, 32.63775], [-116.9838, 32.63774], [-116.9841, 32.63775], [-116.98413, 32.63785], [-116.98426, 32.638], [-116.98456, 32.63845]]]} | Open Access 1 | Breezewood Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/breezewood-park | 16347 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 2.131 | Breezewood Park | |
2929 | 2929 | 2928 | {"type": "Polygon", "coordinates": [[[-116.96955, 32.64393], [-116.96933, 32.64428], [-116.96888, 32.64511], [-116.96881, 32.64532], [-116.96877, 32.64554], [-116.96841, 32.64548], [-116.96795, 32.64527], [-116.96729, 32.64523], [-116.96689, 32.64515], [-116.96615, 32.64484], [-116.96612, 32.64481], [-116.96613, 32.64477], [-116.96629, 32.64451], [-116.96642, 32.64427], [-116.96659, 32.64384], [-116.96666, 32.64352], [-116.9667, 32.64326], [-116.96671, 32.64276], [-116.96805, 32.64268], [-116.96812, 32.64341], [-116.9682, 32.64359], [-116.96836, 32.64376], [-116.96857, 32.64389], [-116.96881, 32.64396], [-116.96898, 32.64397], [-116.96955, 32.64393]]]} | Open Access 1 | Chula Vista Community Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/chula-vista-community-park | 17240 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 14.298 | Chula Vista Community Park | |
2930 | 2930 | 2929 | {"type": "Polygon", "coordinates": [[[-117.06918, 32.64875], [-117.06908, 32.64878], [-117.06907, 32.6488], [-117.06875, 32.64877], [-117.06877, 32.64865], [-117.06873, 32.64853], [-117.06906, 32.64844], [-117.06918, 32.64875]]]} | Open Access 1 | Chula Vista Open Space | 17242 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 0.292 | Chula Vista OS | ||
3151 | 3151 | 3150 | {"type": "Polygon", "coordinates": [[[-117.05544, 32.59945], [-117.05505, 32.59946], [-117.05504, 32.59979], [-117.05461, 32.59966], [-117.05462, 32.59923], [-117.05469, 32.59919], [-117.05504, 32.59919], [-117.05505, 32.59938], [-117.05544, 32.59939], [-117.05544, 32.59945]]]} | Open Access 1 | Connoley Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/connoley-park | 17592 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 0.672 | Connoley Park | |
3227 | 3227 | 3226 | {"type": "Polygon", "coordinates": [[[-116.98312, 32.63302], [-116.98199, 32.63347], [-116.98174, 32.63286], [-116.98096, 32.63275], [-116.98126, 32.63152], [-116.98161, 32.63162], [-116.98244, 32.63175], [-116.9825, 32.63181], [-116.98267, 32.63184], [-116.98275, 32.63179], [-116.98298, 32.63183], [-116.98284, 32.63252], [-116.98312, 32.63302]]]} | Open Access 1 | Cottonwood Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/cottonwood-park | 17688 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 6.726 | Cottonwood Park | |
3366 | 3366 | 3365 | {"type": "Polygon", "coordinates": [[[-117.03519, 32.61371], [-117.03432, 32.61396], [-117.03398, 32.61417], [-117.03397, 32.61419], [-117.03366, 32.61425], [-117.03363, 32.61401], [-117.03365, 32.61375], [-117.03368, 32.61363], [-117.03396, 32.61295], [-117.03424, 32.61301], [-117.03431, 32.61284], [-117.03436, 32.61267], [-117.03438, 32.61247], [-117.03436, 32.61198], [-117.0344, 32.61182], [-117.03447, 32.61169], [-117.03467, 32.61177], [-117.03472, 32.61192], [-117.03453, 32.612], [-117.03519, 32.61371]]]} | Open Access 1 | Flair Slopes Open Space | 18937 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 4.507 | Flair Slopes OS | ||
3626 | 3626 | 3625 | {"type": "Polygon", "coordinates": [[[-117.01065, 32.64444], [-117.00899, 32.64428], [-117.00849, 32.6448], [-117.00797, 32.64428], [-117.00791, 32.6445], [-117.00773, 32.6447], [-117.00742, 32.64471], [-117.00714, 32.64442], [-117.00691, 32.64445], [-117.00663, 32.64485], [-117.0069, 32.64532], [-117.00664, 32.64565], [-117.00643, 32.64533], [-117.00618, 32.64516], [-117.00598, 32.64509], [-117.00571, 32.64508], [-117.00451, 32.64528], [-117.00403, 32.6438], [-117.00436, 32.64382], [-117.00459, 32.64382], [-117.00483, 32.64379], [-117.00506, 32.64373], [-117.00537, 32.6436], [-117.00652, 32.64301], [-117.00663, 32.64313], [-117.00682, 32.64326], [-117.00703, 32.64336], [-117.00722, 32.6434], [-117.0105, 32.64368], [-117.01055, 32.6437], [-117.01056, 32.64374], [-117.01065, 32.64444]]]} | Open Access 1 | Discovery Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/discovery-park | 18165 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 20.574 | Discovery Park | |
3813 | 3813 | 3812 | {"type": "Polygon", "coordinates": [[[-116.9381, 32.62076], [-116.93597, 32.62079], [-116.93592, 32.62047], [-116.93582, 32.62022], [-116.93569, 32.61999], [-116.93473, 32.61881], [-116.93465, 32.61869], [-116.93448, 32.61839], [-116.93433, 32.61801], [-116.93424, 32.61761], [-116.93424, 32.61751], [-116.93365, 32.61192], [-116.93446, 32.61192], [-116.9381, 32.62076]]]} | Open Access 1 | EastLake III Park | 18395 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 43.84 | EastLake III Park | ||
4084 | 4084 | 4083 | {"type": "Polygon", "coordinates": [[[-117.09191, 32.64933], [-117.09061, 32.64971], [-117.09036, 32.64976], [-117.08898, 32.65016], [-117.08813, 32.65038], [-117.0881, 32.65037], [-117.08805, 32.65033], [-117.08745, 32.64879], [-117.0903, 32.64799], [-117.09007, 32.64737], [-117.08995, 32.64732], [-117.08993, 32.64727], [-117.09051, 32.64712], [-117.09055, 32.64718], [-117.09103, 32.64705], [-117.09191, 32.64933]]]} | Open Access 1 | Eucalyptus Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/eucalyptus-park | 18741 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 19.684 | Eucalyptus Park | |
4116 | 4116 | 4115 | {"type": "Polygon", "coordinates": [[[-117.02598, 32.64134], [-117.02555, 32.64146], [-117.02542, 32.64136], [-117.02506, 32.64128], [-117.02482, 32.6413], [-117.02465, 32.64135], [-117.02435, 32.64151], [-117.024, 32.64158], [-117.0237, 32.64159], [-117.02338, 32.64155], [-117.02304, 32.64148], [-117.02367, 32.64097], [-117.02389, 32.64083], [-117.02416, 32.64067], [-117.02445, 32.64054], [-117.02476, 32.64043], [-117.02582, 32.64013], [-117.02586, 32.64032], [-117.02571, 32.64037], [-117.02558, 32.64047], [-117.02553, 32.64053], [-117.02549, 32.64062], [-117.02549, 32.64077], [-117.02552, 32.64086], [-117.0256, 32.641], [-117.02565, 32.64126], [-117.02597, 32.64127], [-117.02598, 32.64134]]]} | Open Access 1 | Explorer Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/explorer-park | 18775 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 5.229 | Explorer Park | |
4427 | 4427 | 4426 | {"type": "Polygon", "coordinates": [[[-117.08447, 32.64181], [-117.08444, 32.64184], [-117.08276, 32.64232], [-117.08271, 32.64232], [-117.08267, 32.6423], [-117.08239, 32.64157], [-117.0842, 32.64107], [-117.08447, 32.64177], [-117.08447, 32.64181]]]} | Open Access 1 | Friendship Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/friendship-park | 19121 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 3.934 | Friendship Park | |
4740 | 4740 | 4739 | {"type": "Polygon", "coordinates": [[[-117.03555, 32.62065], [-117.03358, 32.62121], [-117.03124, 32.61519], [-117.03171, 32.61515], [-117.03228, 32.61506], [-117.03312, 32.61489], [-117.03353, 32.61486], [-117.0336, 32.6149], [-117.03378, 32.61597], [-117.03386, 32.61638], [-117.03555, 32.62065]]]} | Open Access 1 | Greg Rogers Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/greg-rogers-park | 19498 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 33.477 | Greg Rogers Park | |
4894 | 4894 | 4893 | {"type": "Polygon", "coordinates": [[[-117.08528, 32.60725], [-117.08416, 32.60756], [-117.08352, 32.60593], [-117.08464, 32.60562], [-117.08528, 32.60725]]]} | Open Access 1 | Harborside Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/harborside-park | 19668 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 5.202 | Harborside Park | |
4903 | 4903 | 4902 | {"type": "Polygon", "coordinates": [[[-117.09107, 32.61913], [-117.09075, 32.61922], [-117.09068, 32.61905], [-117.091, 32.61896], [-117.09107, 32.61913]]]} | Open Access 1 | Lancerlot Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/lancerlot-park | 21000 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 0.155 | Lancerlot Park | |
4944 | 4944 | 4943 | {"type": "Polygon", "coordinates": [[[-116.99159, 32.62877], [-116.99156, 32.63051], [-116.99151, 32.63053], [-116.99042, 32.63052], [-116.99007, 32.63055], [-116.99003, 32.63055], [-116.99, 32.63052], [-116.98997, 32.63018], [-116.98997, 32.6297], [-116.98999, 32.6293], [-116.99003, 32.62916], [-116.99003, 32.62908], [-116.99, 32.62902], [-116.98989, 32.62895], [-116.98992, 32.62891], [-116.98993, 32.62876], [-116.99053, 32.62875], [-116.99159, 32.62877]]]} | Open Access 1 | Harvest Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/harvest-park | 19721 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 7.302 | Harvest Park | |
5056 | 5056 | 5055 | {"type": "Polygon", "coordinates": [[[-116.99884, 32.62363], [-116.99893, 32.62395], [-116.99896, 32.6242], [-116.99893, 32.62444], [-116.99889, 32.62456], [-116.99877, 32.62483], [-116.99857, 32.62508], [-116.9983, 32.62529], [-116.99806, 32.62543], [-116.99773, 32.62553], [-116.99742, 32.62558], [-116.99707, 32.62557], [-116.99674, 32.6255], [-116.9964, 32.62536], [-116.99622, 32.62524], [-116.99603, 32.62508], [-116.99588, 32.62491], [-116.99578, 32.62474], [-116.9963, 32.62462], [-116.99639, 32.62463], [-116.99639, 32.62456], [-116.99649, 32.62453], [-116.99644, 32.62432], [-116.9964, 32.62432], [-116.99636, 32.62419], [-116.99579, 32.62431], [-116.99574, 32.62435], [-116.99572, 32.62443], [-116.99567, 32.62443], [-116.99563, 32.62432], [-116.99567, 32.62426], [-116.99612, 32.62416], [-116.99878, 32.6236], [-116.99884, 32.62363]]]} | Open Access 1 | Heritage Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/heritage-park | 19845 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 10.749 | Heritage Park | |
5175 | 5175 | 5174 | {"type": "Polygon", "coordinates": [[[-117.06542, 32.62775], [-117.06488, 32.62791], [-117.06482, 32.62795], [-117.06501, 32.62845], [-117.06436, 32.62864], [-117.06443, 32.62886], [-117.06357, 32.62911], [-117.06366, 32.62937], [-117.06326, 32.62949], [-117.06296, 32.62877], [-117.06171, 32.62913], [-117.06156, 32.62888], [-117.06072, 32.62796], [-117.06059, 32.62772], [-117.06095, 32.6276], [-117.0611, 32.62792], [-117.06196, 32.62767], [-117.06208, 32.62794], [-117.06237, 32.62787], [-117.06262, 32.62845], [-117.06539, 32.62767], [-117.06542, 32.62775]]]} | Open Access 1 | Hilltop Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/hilltop-park | 19986 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 9.438 | Hilltop Park | |
5202 | 5202 | 5201 | {"type": "Polygon", "coordinates": [[[-117.05536, 32.59782], [-117.05532, 32.59786], [-117.05497, 32.59788], [-117.05497, 32.59767], [-117.05534, 32.59767], [-117.05536, 32.59782]]]} | Open Access 1 | Holiday Estates II Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/holiday-estates-ii-park | 20028 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 0.194 | Holiday Estates II Park | |
5254 | 5254 | 5253 | {"type": "Polygon", "coordinates": [[[-117.01414, 32.61769], [-117.01344, 32.61788], [-117.01304, 32.61797], [-117.01237, 32.61806], [-117.01228, 32.61774], [-117.01213, 32.6177], [-117.01211, 32.6176], [-117.01192, 32.61744], [-117.01175, 32.61716], [-117.01195, 32.6171], [-117.01211, 32.61698], [-117.01287, 32.61676], [-117.01339, 32.61675], [-117.01374, 32.61665], [-117.01414, 32.61769]]]} | Open Access 1 | Horizon Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/horizon-park | 20092 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 5.623 | Horizon Park |
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]);