superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
69 rows where MNG_AGENCY = 117 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
12801 | 12801 | 12800 | {"type": "Polygon", "coordinates": [[[-117.05366, 32.59768], [-117.05361, 32.59768], [-117.05329, 32.59759], [-117.05329, 32.59744], [-117.0533, 32.59742], [-117.05335, 32.59739], [-117.05366, 32.59738], [-117.05366, 32.59768]]]} | Open Access 1 | Holiday Estates I Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/holiday-estates-i-park | 30009 | 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.243 | Holiday Estates I 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 | ||
9603 | 9603 | 9602 | {"type": "Polygon", "coordinates": [[[-117.05519, 32.60397], [-117.05513, 32.60401], [-117.0551, 32.60406], [-117.05511, 32.60413], [-117.05514, 32.60418], [-117.05488, 32.60426], [-117.05479, 32.60407], [-117.05481, 32.60405], [-117.05471, 32.6038], [-117.05489, 32.60376], [-117.055, 32.60401], [-117.05519, 32.60397]]]} | Open Access 1 | Sherwood Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/sherwood-park | 25399 | 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.293 | Sherwood Park | |
7032 | 7032 | 7031 | {"type": "Polygon", "coordinates": [[[-116.98173, 32.65204], [-116.98153, 32.65223], [-116.98135, 32.65208], [-116.98086, 32.652], [-116.98086, 32.65186], [-116.9809, 32.65183], [-116.98124, 32.65183], [-116.98138, 32.65184], [-116.98156, 32.65191], [-116.98173, 32.65204]]]} | Open Access 1 | Mini Park | 22266 | 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.478 | MP | ||
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 | |
8513 | 8513 | 8512 | {"type": "Polygon", "coordinates": [[[-117.00274, 32.63678], [-117.00236, 32.63691], [-117.0021, 32.63708], [-117.00207, 32.63715], [-117.00196, 32.63715], [-117.0019, 32.63717], [-117.00187, 32.63722], [-117.00178, 32.63718], [-117.00147, 32.63726], [-117.00139, 32.63705], [-117.00171, 32.63697], [-117.00176, 32.6368], [-117.00183, 32.63678], [-117.00193, 32.63693], [-117.002, 32.63694], [-117.00263, 32.6366], [-117.00274, 32.63678]]]} | Open Access 1 | Rancho Del Rey Finger | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/rancho-del-rey-park | 24139 | 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.748 | Rancho Del Rey Finger | |
12800 | 12800 | 12799 | {"type": "Polygon", "coordinates": [[[-117.10061, 32.63666], [-117.10052, 32.6367], [-117.1004, 32.63657], [-117.10016, 32.63639], [-117.0999, 32.63627], [-117.09961, 32.63619], [-117.0994, 32.63601], [-117.09949, 32.63592], [-117.10024, 32.63571], [-117.10061, 32.63666]]]} | Open Access 1 | Bay Boulevard Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/bay-boulevard | 30005 | 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 | 1.27 | Bay Boulevard Park | |
7421 | 7421 | 7420 | {"type": "Polygon", "coordinates": [[[-117.07857, 32.64156], [-117.07788, 32.64174], [-117.07759, 32.64098], [-117.07826, 32.64079], [-117.07857, 32.64156]]]} | Open Access 1 | Norman Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/norman-park | 22798 | 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 | 1.486 | Norman Park | |
11364 | 11364 | 11363 | {"type": "Polygon", "coordinates": [[[-117.04643, 32.63539], [-117.04591, 32.63554], [-117.04554, 32.63452], [-117.04553, 32.63446], [-117.04616, 32.63447], [-117.04643, 32.63539]]]} | Open Access 1 | Gayle L. McCandliss Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/gayle-l-mccandliss-park | 30008 | 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 | 1.542 | Gayle L. McCandliss 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 | |
8054 | 8054 | 8053 | {"type": "Polygon", "coordinates": [[[-116.97799, 32.6467], [-116.97786, 32.64678], [-116.97765, 32.64685], [-116.97688, 32.64697], [-116.97686, 32.64694], [-116.97688, 32.64646], [-116.97685, 32.6463], [-116.97678, 32.6461], [-116.9764, 32.6454], [-116.97634, 32.64518], [-116.97799, 32.6467]]]} | Open Access 1 | Pedestrian Park | 23560 | 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.453 | Pedestrian Park | ||
6689 | 6689 | 6688 | {"type": "Polygon", "coordinates": [[[-117.04162, 32.61285], [-117.04073, 32.61308], [-117.03974, 32.61333], [-117.04108, 32.612], [-117.04127, 32.61196], [-117.04162, 32.61285]]]} | Open Access 1 | Palomar Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/palomar-park | 23364 | 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.641 | Palomar Park | |
107 | 107 | 106 | {"type": "Polygon", "coordinates": [[[-117.03382, 32.61286], [-117.03349, 32.6137], [-117.03347, 32.61384], [-117.03347, 32.61412], [-117.03353, 32.61451], [-117.03347, 32.61457], [-117.033, 32.61462], [-117.0322, 32.61478], [-117.03167, 32.61487], [-117.03113, 32.61491], [-117.03111, 32.61487], [-117.03317, 32.61428], [-117.03268, 32.61309], [-117.03299, 32.61322], [-117.0333, 32.61316], [-117.03363, 32.6128], [-117.03382, 32.61286]]]} | Open Access 1 | Greg Rogers Open Space | 19497 | 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.302 | Greg Rogers OS | ||
12802 | 12802 | 12801 | {"type": "Polygon", "coordinates": [[[-117.00515, 32.63973], [-117.00476, 32.63984], [-117.00456, 32.63937], [-117.00446, 32.63933], [-117.00448, 32.63928], [-117.00448, 32.63921], [-117.00445, 32.63916], [-117.00436, 32.63903], [-117.00429, 32.63883], [-117.00427, 32.63865], [-117.00424, 32.63859], [-117.00416, 32.63852], [-117.00424, 32.63842], [-117.00404, 32.63797], [-117.00397, 32.63795], [-117.00399, 32.63788], [-117.00396, 32.63782], [-117.00386, 32.63776], [-117.00377, 32.63777], [-117.00367, 32.63752], [-117.00298, 32.6374], [-117.00298, 32.63737], [-117.00399, 32.63755], [-117.00407, 32.63752], [-117.0044, 32.63734], [-117.00451, 32.63759], [-117.00455, 32.63761], [-117.00452, 32.63768], [-117.00452, 32.63776], [-117.00455, 32.63782], [-117.00465, 32.63793], [-117.00471, 32.63815], [-117.00471, 32.63828], [-117.00475, 32.63835], [-117.00482, 32.6384], [-117.00476, 32.63855], [-117.00494, 32.63895], [-117.00486, 32.63899], [-117.00483, 32.63904], [-117.00483, 32.63912], [-117.00486, 32.63917], [-117.00495, 32.6392], [-117.00515, 32.63973]]]} | Open Access 1 | Rancho del Rey Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/rancho-del-rey-park | 30012 | 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.408 | Rancho del Rey Park | |
10073 | 10073 | 10072 | {"type": "Polygon", "coordinates": [[[-117.03127, 32.62184], [-117.03031, 32.62284], [-117.02944, 32.62221], [-117.02945, 32.62215], [-117.02956, 32.62203], [-117.02963, 32.62189], [-117.02967, 32.62175], [-117.02967, 32.62166], [-117.0297, 32.62163], [-117.02991, 32.62159], [-117.03006, 32.62153], [-117.03031, 32.62175], [-117.03067, 32.6214], [-117.03127, 32.62184]]]} | Open Access 1 | Sunbow Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/sunbow-park | 25985 | 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.645 | Sunbow Park | |
13866 | 13866 | 13865 | {"type": "Polygon", "coordinates": [[[-117.06893, 32.60036], [-117.06893, 32.60105], [-117.06677, 32.60104], [-117.06677, 32.60035], [-117.06893, 32.60036]]]} | Open Access 1 | Orange Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/orange-park | 31420 | 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.795 | Orange Park | |
6032 | 6032 | 6031 | {"type": "Polygon", "coordinates": [[[-117.06959, 32.6096], [-117.06886, 32.6098], [-117.06833, 32.60844], [-117.06839, 32.60841], [-117.06829, 32.60816], [-117.06911, 32.60793], [-117.06953, 32.60903], [-117.0694, 32.6091], [-117.06959, 32.6096]]]} | Open Access 1 | Lauderbach Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/lauderbach-park | 21083 | 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.821 | Lauderbach 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 |
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]);