superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
69 rows where MNG_AGENCY = 117 sorted by map descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
6912 | 6912 | 6911 | {"type": "Polygon", "coordinates": [[[-117.08258, 32.63861], [-117.08125, 32.63898], [-117.08121, 32.63891], [-117.07936, 32.63942], [-117.07909, 32.63876], [-117.08144, 32.6381], [-117.08147, 32.63821], [-117.08142, 32.63826], [-117.08141, 32.63831], [-117.08142, 32.63834], [-117.08146, 32.63839], [-117.08153, 32.6384], [-117.08172, 32.63836], [-117.08173, 32.63841], [-117.08179, 32.63844], [-117.08197, 32.63839], [-117.08203, 32.63852], [-117.08249, 32.63839], [-117.08258, 32.63861]]]} | Open Access 1 | Memorial Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/memorial-park | 22123 | 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.259 | Memorial 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 | |
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 | |
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 | ||
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 | |
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 | |
7793 | 7793 | 7792 | {"type": "Polygon", "coordinates": [[[-117.05811, 32.59706], [-117.0581, 32.59788], [-117.05601, 32.59787], [-117.05601, 32.59706], [-117.05811, 32.59706]]]} | Open Access 1 | Otay Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/otay-park | 23245 | 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.398 | Otay Park | |
9173 | 9173 | 9172 | {"type": "Polygon", "coordinates": [[[-117.05556, 32.60243], [-117.0517, 32.60351], [-117.0517, 32.60349], [-117.05163, 32.60309], [-117.05161, 32.60259], [-117.05521, 32.60157], [-117.05556, 32.60243]]]} | Open Access 1 | San Diego Gas & Electric Park West | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/sdg-e-park | 24855 | 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.163 | San Diego Gas & Electric Park West | |
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 | |
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 | |
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 | |
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 | |
9172 | 9172 | 9171 | {"type": "Polygon", "coordinates": [[[-117.05141, 32.60343], [-117.04613, 32.60495], [-117.04584, 32.60422], [-117.05134, 32.60267], [-117.05136, 32.60308], [-117.05141, 32.60343]]]} | Open Access 1 | San Diego Gas & Electric Park East | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/sdg-e-park | 24854 | 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 | 11.081 | San Diego Gas & Electric Park East | |
6330 | 6330 | 6329 | {"type": "Polygon", "coordinates": [[[-117.04933, 32.60323], [-117.04733, 32.6038], [-117.04724, 32.60358], [-117.04778, 32.60325], [-117.04812, 32.60225], [-117.04893, 32.60207], [-117.04893, 32.60115], [-117.04932, 32.60115], [-117.04933, 32.60323]]]} | Open Access 1 | Loma Verde Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/loma-verde-park | 21408 | 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.085 | Loma Verde Park | |
8705 | 8705 | 8704 | {"type": "Polygon", "coordinates": [[[-117.04833, 32.60032], [-117.04833, 32.60221], [-117.04812, 32.60226], [-117.04778, 32.60325], [-117.04725, 32.60358], [-117.04733, 32.6038], [-117.04584, 32.60421], [-117.04555, 32.60345], [-117.04662, 32.60266], [-117.04703, 32.6022], [-117.04704, 32.60041], [-117.04833, 32.60032]]]} | Open Access 1 | Rienstra Sports Complex | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/rienstra-sports-complex | 24363 | 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 | 13.489 | Rienstra Sports Complex |
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]);