superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
69 rows where MNG_AGENCY = 117 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 49 ✖
MNG_AGENCY 1
- Chula Vista, City of · 49 ✖
ACCESS_TYP 1
- Open Access 49
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
9350 | 9350 | 9349 | {"type": "Polygon", "coordinates": [[[-116.97804, 32.62544], [-116.97777, 32.62555], [-116.97738, 32.6258], [-116.97707, 32.62606], [-116.97682, 32.62638], [-116.97538, 32.6258], [-116.97617, 32.62439], [-116.97788, 32.62506], [-116.97804, 32.62544]]]} | Open Access 1 | Santa Venetia Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/santa-venetia-park | 25141 | 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.52 | Santa Venetia Park | |
9305 | 9305 | 9304 | {"type": "Polygon", "coordinates": [[[-116.98565, 32.62985], [-116.98564, 32.63009], [-116.98312, 32.62978], [-116.98319, 32.62957], [-116.98333, 32.62933], [-116.98343, 32.62921], [-116.98365, 32.62905], [-116.9839, 32.62894], [-116.98407, 32.62889], [-116.98424, 32.62886], [-116.98453, 32.62886], [-116.9847, 32.62889], [-116.98494, 32.62896], [-116.98516, 32.62908], [-116.98535, 32.62923], [-116.98548, 32.62939], [-116.98558, 32.62956], [-116.98563, 32.62972], [-116.98565, 32.62985]]]} | Open Access 1 | Santa Cora Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/santa-cora-park | 25062 | 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.524 | Santa Cora 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 | |
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 | |
8905 | 8905 | 8904 | {"type": "Polygon", "coordinates": [[[-117.03927, 32.66514], [-117.03788, 32.66541], [-117.03761, 32.66544], [-117.03706, 32.66544], [-117.03685, 32.66542], [-117.03619, 32.66532], [-117.03574, 32.66531], [-117.0355, 32.66533], [-117.03539, 32.6648], [-117.03476, 32.66488], [-117.03475, 32.66489], [-117.03486, 32.66546], [-117.03398, 32.66562], [-117.03256, 32.66604], [-117.03202, 32.66619], [-117.03076, 32.66647], [-117.02975, 32.66671], [-117.02899, 32.66692], [-117.02868, 32.66703], [-117.02554, 32.66791], [-117.0266, 32.66668], [-117.02643, 32.66623], [-117.02836, 32.66501], [-117.02924, 32.66452], [-117.02939, 32.66483], [-117.02944, 32.6649], [-117.03072, 32.66419], [-117.03096, 32.66411], [-117.03123, 32.66409], [-117.03148, 32.66413], [-117.03167, 32.6642], [-117.03253, 32.66473], [-117.03265, 32.66475], [-117.03278, 32.66474], [-117.03288, 32.66472], [-117.03302, 32.66462], [-117.03373, 32.66363], [-117.03441, 32.66339], [-117.03442, 32.66331], [-117.03511, 32.66317], [-117.0386, 32.66336], [-117.03927, 32.66514]]]} | Open Access 1 | Rohr Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/rohr-park | 24567 | 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 | 63.701 | Rohr Park | |
8866 | 8866 | 8865 | {"type": "Polygon", "coordinates": [[[-116.9908, 32.64681], [-116.98927, 32.64722], [-116.98905, 32.6473], [-116.98879, 32.64742], [-116.98862, 32.64691], [-116.98903, 32.64643], [-116.98927, 32.64631], [-116.9897, 32.64618], [-116.98984, 32.64604], [-116.98955, 32.6457], [-116.98986, 32.64544], [-116.99066, 32.64643], [-116.9908, 32.64681]]]} | Open Access 1 | Tiffany Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/tiffany-park | 26359 | 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.039 | Tiffany 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 | |
8570 | 8570 | 8569 | {"type": "Polygon", "coordinates": [[[-117.00449, 32.64521], [-117.00273, 32.6457], [-117.00255, 32.64544], [-117.00162, 32.6439], [-117.00177, 32.64382], [-117.00189, 32.64408], [-117.00367, 32.64395], [-117.00404, 32.64384], [-117.00449, 32.64521]]]} | Open Access 1 | RDR SPA I Phase 2 Park | 24210 | 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 | 8.406 | RDR SPA I Phase 2 Park | ||
8514 | 8514 | 8513 | {"type": "Polygon", "coordinates": [[[-117.0056, 32.63624], [-117.00513, 32.63582], [-117.00502, 32.63576], [-117.0046, 32.63569], [-117.00423, 32.63587], [-117.00342, 32.63602], [-117.00316, 32.63618], [-117.00295, 32.63637], [-117.0028, 32.63655], [-117.00278, 32.63652], [-117.00292, 32.63635], [-117.00312, 32.63616], [-117.0034, 32.63599], [-117.00399, 32.63586], [-117.00393, 32.63562], [-117.00387, 32.63559], [-117.00389, 32.63551], [-117.00387, 32.63546], [-117.00383, 32.63543], [-117.00383, 32.63532], [-117.00342, 32.63483], [-117.0034, 32.63476], [-117.00332, 32.6347], [-117.00288, 32.6342], [-117.00288, 32.63414], [-117.00285, 32.63409], [-117.00265, 32.63385], [-117.0024, 32.63364], [-117.00258, 32.63353], [-117.0029, 32.63337], [-117.00317, 32.63336], [-117.00324, 32.63329], [-117.00326, 32.63322], [-117.00374, 32.63319], [-117.00374, 32.63389], [-117.00368, 32.63423], [-117.00397, 32.63498], [-117.00412, 32.63516], [-117.00417, 32.63515], [-117.0042, 32.6352], [-117.00418, 32.63523], [-117.00447, 32.63557], [-117.00525, 32.63536], [-117.0056, 32.63624]]]} | Open Access 1 | Rancho Del Rey South | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/rancho-del-rey-park | 24141 | 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.741 | Rancho Del Rey South | |
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 | |
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 | ||
7998 | 7998 | 7997 | {"type": "Polygon", "coordinates": [[[-117.03474, 32.63], [-117.03459, 32.63008], [-117.03448, 32.62997], [-117.03436, 32.62992], [-117.03425, 32.62989], [-117.03406, 32.62989], [-117.03389, 32.62994], [-117.03373, 32.63006], [-117.03367, 32.63016], [-117.03358, 32.63073], [-117.03358, 32.63107], [-117.0336, 32.63108], [-117.03363, 32.63106], [-117.03367, 32.63132], [-117.03143, 32.63196], [-117.03171, 32.63163], [-117.03216, 32.63166], [-117.03246, 32.63147], [-117.03225, 32.63087], [-117.03189, 32.63017], [-117.0322, 32.63005], [-117.03248, 32.62989], [-117.03286, 32.62959], [-117.03343, 32.62906], [-117.03353, 32.62906], [-117.03362, 32.62913], [-117.03367, 32.62921], [-117.03392, 32.62949], [-117.03408, 32.62962], [-117.03431, 32.62971], [-117.03464, 32.62973], [-117.03474, 32.63]]]} | Open Access 1 | Paseo Del Rey Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/paseo-del-rey-park | 23495 | 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 | 8.743 | Paseo Del Rey 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 | |
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 | |
7242 | 7242 | 7241 | {"type": "Polygon", "coordinates": [[[-116.97558, 32.66955], [-116.97554, 32.6696], [-116.97555, 32.67026], [-116.97546, 32.67048], [-116.97515, 32.67091], [-116.97508, 32.67127], [-116.97489, 32.67174], [-116.9747, 32.67184], [-116.97443, 32.67203], [-116.97343, 32.67241], [-116.9733, 32.67243], [-116.97329, 32.67245], [-116.97212, 32.67241], [-116.97215, 32.67198], [-116.9722, 32.67193], [-116.97222, 32.67187], [-116.97223, 32.67169], [-116.97226, 32.67158], [-116.97278, 32.67033], [-116.97292, 32.6701], [-116.97307, 32.66992], [-116.97381, 32.66915], [-116.97395, 32.66899], [-116.97403, 32.66897], [-116.97463, 32.66921], [-116.97556, 32.66946], [-116.97558, 32.66955]]]} | Open Access 1 | Mount San Miguel Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/mount-san-miguel-park | 22531 | 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.04 | Mount San Miguel Park | |
7163 | 7163 | 7162 | {"type": "Polygon", "coordinates": [[[-116.95475, 32.66121], [-116.95387, 32.66104], [-116.95344, 32.66099], [-116.95293, 32.66097], [-116.95228, 32.66103], [-116.95193, 32.6611], [-116.95151, 32.66121], [-116.9509, 32.66144], [-116.95084, 32.66145], [-116.95075, 32.66128], [-116.9507, 32.66107], [-116.9507, 32.6608], [-116.95077, 32.66038], [-116.95077, 32.66013], [-116.95074, 32.65995], [-116.95064, 32.65966], [-116.95036, 32.65919], [-116.95029, 32.65903], [-116.95026, 32.65887], [-116.95027, 32.6581], [-116.95022, 32.65787], [-116.95012, 32.65766], [-116.94984, 32.65726], [-116.95132, 32.65647], [-116.95124, 32.65628], [-116.9513, 32.65628], [-116.95192, 32.65766], [-116.95197, 32.65793], [-116.95201, 32.65804], [-116.95214, 32.65824], [-116.95257, 32.6586], [-116.95262, 32.6587], [-116.95255, 32.65883], [-116.95254, 32.65889], [-116.95255, 32.65898], [-116.95258, 32.65903], [-116.95273, 32.65916], [-116.95282, 32.65927], [-116.95286, 32.65936], [-116.95291, 32.65939], [-116.95312, 32.65945], [-116.95318, 32.6595], [-116.95345, 32.65985], [-116.95347, 32.65992], [-116.95354, 32.66002], [-116.95376, 32.66021], [-116.95397, 32.66048], [-116.95468, 32.66079], [-116.95475, 32.66084], [-116.95475, 32.66121]]]} | Open Access 1 | Montevalle Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/montevalle-park | 22434 | 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 | 27.377 | Montevalle 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 | ||
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 | |
6690 | 6690 | 6689 | {"type": "Polygon", "coordinates": [[[-117.02906, 32.64765], [-117.02832, 32.64831], [-117.02811, 32.64847], [-117.02788, 32.64862], [-117.02762, 32.64875], [-117.02735, 32.64885], [-117.02707, 32.64894], [-117.02674, 32.64902], [-117.02678, 32.64886], [-117.02654, 32.64817], [-117.02689, 32.64808], [-117.02734, 32.64789], [-117.02738, 32.64789], [-117.02755, 32.64776], [-117.02759, 32.64776], [-117.02776, 32.64762], [-117.0278, 32.64762], [-117.02797, 32.64749], [-117.02812, 32.64752], [-117.02815, 32.64756], [-117.02836, 32.64762], [-117.02839, 32.64764], [-117.02869, 32.64767], [-117.02872, 32.64769], [-117.02896, 32.64763], [-117.02904, 32.64763], [-117.02906, 32.64765]]]} | Open Access 1 | Marisol Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/marisol-park | 21868 | 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.662 | Marisol 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]);