superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where ACCESS_TYP = 1 and MNG_AGENCY = 117 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 67
MNG_AGENCY 1
- Chula Vista, City of · 67 ✖
ACCESS_TYP 1
- Open Access · 67 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
12809 | 12809 | 12808 | {"type": "Polygon", "coordinates": [[[-116.95706, 32.62336], [-116.95593, 32.62451], [-116.95588, 32.62454], [-116.95576, 32.62466], [-116.95572, 32.62467], [-116.95553, 32.62485], [-116.95383, 32.62365], [-116.95409, 32.62346], [-116.95447, 32.62325], [-116.95472, 32.62316], [-116.95526, 32.62301], [-116.95546, 32.62293], [-116.95571, 32.62279], [-116.956, 32.62255], [-116.95605, 32.62255], [-116.95706, 32.62336]]]} | Open Access 1 | Windingwalk Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/windingwalk-park | 30014 | 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.465 | Windingwalk Park | |
12808 | 12808 | 12807 | {"type": "Polygon", "coordinates": [[[-116.94696, 32.64451], [-116.94683, 32.64507], [-116.94532, 32.6448], [-116.94361, 32.64447], [-116.94368, 32.64431], [-116.9445, 32.64347], [-116.9444, 32.64336], [-116.9443, 32.64316], [-116.94422, 32.64265], [-116.94422, 32.64245], [-116.94427, 32.64229], [-116.94438, 32.64209], [-116.94447, 32.64181], [-116.94452, 32.64147], [-116.94451, 32.64114], [-116.94442, 32.64077], [-116.94406, 32.63992], [-116.94397, 32.6396], [-116.94393, 32.63936], [-116.94391, 32.6391], [-116.94394, 32.63863], [-116.94407, 32.63868], [-116.94415, 32.63879], [-116.94424, 32.63914], [-116.94431, 32.63926], [-116.94439, 32.63935], [-116.94443, 32.63977], [-116.94516, 32.63984], [-116.94517, 32.63983], [-116.94512, 32.63956], [-116.94534, 32.6395], [-116.94554, 32.63937], [-116.94571, 32.63952], [-116.9456, 32.63963], [-116.94551, 32.63977], [-116.94546, 32.63991], [-116.94544, 32.64006], [-116.94571, 32.64228], [-116.94575, 32.64243], [-116.94584, 32.64261], [-116.94595, 32.64279], [-116.94606, 32.64292], [-116.94634, 32.64314], [-116.94627, 32.64329], [-116.94627, 32.64343], [-116.94654, 32.64418], [-116.94654, 32.64432], [-116.94651, 32.64443], [-116.94696, 32.64451]]]} | Open Access 1 | Salt Creek Community Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/salt-creek-community-park | 30013 | 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 | 23.305 | Salt Creek Community Park | |
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 | |
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 | |
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 | |
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 | |
10973 | 10973 | 10972 | {"type": "Polygon", "coordinates": [[[-117.00743, 32.63089], [-117.00669, 32.6311], [-117.00637, 32.63123], [-117.00606, 32.63143], [-117.0059, 32.63161], [-117.00583, 32.6317], [-117.00545, 32.63071], [-117.00541, 32.63052], [-117.00534, 32.63034], [-117.00491, 32.62925], [-117.00515, 32.629], [-117.00521, 32.62888], [-117.00528, 32.62852], [-117.00532, 32.6284], [-117.00544, 32.62833], [-117.00585, 32.62817], [-117.00641, 32.62961], [-117.00689, 32.6295], [-117.00743, 32.63089]]]} | Open Access 1 | Voyager Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/voyager-park | 27199 | 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.254 | Voyager Park | |
10804 | 10804 | 10803 | {"type": "Polygon", "coordinates": [[[-117.02396, 32.61584], [-117.02393, 32.61586], [-117.02373, 32.61589], [-117.02343, 32.61597], [-117.02309, 32.61611], [-117.02279, 32.6162], [-117.02238, 32.61624], [-117.02184, 32.61624], [-117.02154, 32.6163], [-117.02121, 32.61641], [-117.02072, 32.61552], [-117.02075, 32.61546], [-117.02211, 32.61492], [-117.02254, 32.61476], [-117.02317, 32.6146], [-117.0237, 32.61451], [-117.02378, 32.61456], [-117.02394, 32.61552], [-117.02391, 32.61576], [-117.02396, 32.61584]]]} | Open Access 1 | Veteran's Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/veterans-park | 27017 | 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.03 | Veteran's Park | |
10606 | 10606 | 10605 | {"type": "Polygon", "coordinates": [[[-117.0323, 32.60267], [-117.03116, 32.60268], [-117.03013, 32.60265], [-117.0295, 32.60265], [-117.02945, 32.60216], [-117.0295, 32.6021], [-117.02953, 32.60209], [-117.03161, 32.60208], [-117.03185, 32.60206], [-117.0323, 32.60199], [-117.0323, 32.60267]]]} | Open Access 1 | Valle Lindo Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/valle-lindo-park | 26769 | 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.326 | Valle Lindo Park | |
10555 | 10555 | 10554 | {"type": "MultiPolygon", "coordinates": [[[[-117.03411, 32.63221], [-117.03379, 32.63231], [-117.03398, 32.63277], [-117.03397, 32.6329], [-117.03338, 32.63399], [-117.03212, 32.63339], [-117.03198, 32.63322], [-117.0318, 32.63315], [-117.0316, 32.63312], [-117.03139, 32.63304], [-117.03144, 32.63297], [-117.03154, 32.63299], [-117.03187, 32.63297], [-117.03186, 32.63281], [-117.03181, 32.63265], [-117.03178, 32.63198], [-117.0315, 32.63198], [-117.03143, 32.63206], [-117.03139, 32.63202], [-117.03143, 32.63196], [-117.03376, 32.6313], [-117.03389, 32.63162], [-117.03401, 32.63167], [-117.03398, 32.63175], [-117.03398, 32.63185], [-117.03411, 32.63221]]], [[[-117.03368, 32.63514], [-117.03287, 32.63536], [-117.0321, 32.63482], [-117.03214, 32.63476], [-117.03243, 32.6349], [-117.03266, 32.63458], [-117.03359, 32.63505], [-117.03368, 32.63514]]]]} | Open Access 1 | Undeveloped Park | 26653 | 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.652 | Undeveloped 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 | |
10269 | 10269 | 10268 | {"type": "Polygon", "coordinates": [[[-117.04426, 32.64745], [-117.04126, 32.64829], [-117.04087, 32.6479], [-117.04109, 32.64801], [-117.04149, 32.64804], [-117.04168, 32.64802], [-117.04187, 32.64797], [-117.04216, 32.64784], [-117.04234, 32.64759], [-117.04234, 32.64733], [-117.04224, 32.64697], [-117.04209, 32.64662], [-117.04208, 32.64648], [-117.04212, 32.64631], [-117.0422, 32.64616], [-117.04234, 32.64598], [-117.04237, 32.64575], [-117.042, 32.64573], [-117.042, 32.64561], [-117.0419, 32.64522], [-117.04186, 32.64503], [-117.04186, 32.64478], [-117.0419, 32.64458], [-117.04196, 32.64438], [-117.04205, 32.64421], [-117.0421, 32.6442], [-117.0425, 32.64428], [-117.04313, 32.64433], [-117.04387, 32.64442], [-117.04426, 32.64745]]]} | Open Access 1 | Terra Nova Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/terra-nova-park | 26255 | 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 | 17.919 | Terra Nova Park | |
10137 | 10137 | 10136 | {"type": "Polygon", "coordinates": [[[-116.96371, 32.63329], [-116.9623, 32.6344], [-116.96036, 32.63265], [-116.96174, 32.63156], [-116.96371, 32.63329]]]} | Open Access 1 | Sunset View Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/sunset-view-park | 26067 | 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.764 | Sunset View Park | |
10100 | 10100 | 10099 | {"type": "Polygon", "coordinates": [[[-117.02459, 32.62856], [-117.0244, 32.62875], [-117.02427, 32.62927], [-117.02415, 32.62927], [-117.02405, 32.62933], [-117.02387, 32.62961], [-117.02311, 32.63052], [-117.02283, 32.63038], [-117.0225, 32.6303], [-117.02212, 32.63028], [-117.02177, 32.63031], [-117.02402, 32.62808], [-117.02442, 32.62836], [-117.02459, 32.62856]]]} | Open Access 1 | Sunridge Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/sunridge-park | 26018 | 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.811 | Sunridge 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 | |
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 |
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]);