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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | ||
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 | |
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 | |
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 | |
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 | |
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 |
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]);