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
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 47
MNG_AGENCY 1
- Chula Vista, City of · 47 ✖
ACCESS_TYP 1
- Open Access · 47 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
5254 | 5254 | 5253 | {"type": "Polygon", "coordinates": [[[-117.01414, 32.61769], [-117.01344, 32.61788], [-117.01304, 32.61797], [-117.01237, 32.61806], [-117.01228, 32.61774], [-117.01213, 32.6177], [-117.01211, 32.6176], [-117.01192, 32.61744], [-117.01175, 32.61716], [-117.01195, 32.6171], [-117.01211, 32.61698], [-117.01287, 32.61676], [-117.01339, 32.61675], [-117.01374, 32.61665], [-117.01414, 32.61769]]]} | Open Access 1 | Horizon Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/horizon-park | 20092 | 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.623 | Horizon Park | |
5336 | 5336 | 5335 | {"type": "Polygon", "coordinates": [[[-117.0084, 32.63716], [-117.00792, 32.63729], [-117.00765, 32.6374], [-117.0076, 32.63739], [-117.00742, 32.6373], [-117.00755, 32.6371], [-117.00765, 32.63678], [-117.00762, 32.63655], [-117.00756, 32.63639], [-117.00745, 32.63628], [-117.00732, 32.6362], [-117.00719, 32.63615], [-117.00695, 32.63611], [-117.00598, 32.63605], [-117.00575, 32.63629], [-117.00567, 32.63642], [-117.0056, 32.63623], [-117.00596, 32.63596], [-117.00608, 32.63596], [-117.00697, 32.63602], [-117.00711, 32.63598], [-117.00705, 32.63569], [-117.00718, 32.63564], [-117.00743, 32.63566], [-117.00753, 32.63555], [-117.00825, 32.63528], [-117.00825, 32.63549], [-117.00817, 32.63552], [-117.00812, 32.63558], [-117.00811, 32.63566], [-117.00816, 32.63573], [-117.00811, 32.63579], [-117.00828, 32.63638], [-117.00824, 32.63643], [-117.00823, 32.6365], [-117.00825, 32.63655], [-117.0083, 32.63659], [-117.0084, 32.63716]]]} | Open Access 1 | Independence Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/independence-park | 20189 | 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.447 | Independence Park | |
14871 | 14871 | 14870 | {"type": "Polygon", "coordinates": [[[-117.00958, 32.6349], [-117.00825, 32.63528], [-117.00753, 32.63555], [-117.00743, 32.63566], [-117.00718, 32.63564], [-117.00707, 32.63568], [-117.00713, 32.63598], [-117.00697, 32.63602], [-117.00609, 32.63596], [-117.00596, 32.63596], [-117.00561, 32.63622], [-117.0056, 32.63624], [-117.00558, 32.63622], [-117.00559, 32.63621], [-117.00528, 32.63542], [-117.00934, 32.63428], [-117.00958, 32.6349]]]} | Open Access 1 | Independence Park Open Space | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/independence-park | 20196 | 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.216 | Independence Park OS | |
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 | |
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 | |
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 | |
6413 | 6413 | 6412 | {"type": "Polygon", "coordinates": [[[-117.04485, 32.59873], [-117.0448, 32.59875], [-117.04479, 32.59888], [-117.0448, 32.59986], [-117.04462, 32.60028], [-117.04447, 32.6003], [-117.04444, 32.60062], [-117.0444, 32.60063], [-117.04429, 32.60033], [-117.04396, 32.60049], [-117.04384, 32.60049], [-117.04385, 32.59897], [-117.0435, 32.59895], [-117.04351, 32.59847], [-117.04401, 32.59847], [-117.04485, 32.59845], [-117.04485, 32.59873]]]} | Open Access 1 | Los Ninos Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/los-ninos-park | 21521 | 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.102 | Los Ninos Park | |
6497 | 6497 | 6496 | {"type": "Polygon", "coordinates": [[[-116.97121, 32.65959], [-116.97089, 32.65953], [-116.97049, 32.65954], [-116.9704, 32.65961], [-116.9704, 32.65999], [-116.97031, 32.66011], [-116.9703, 32.66018], [-116.96895, 32.66016], [-116.96896, 32.65912], [-116.96925, 32.65911], [-116.96962, 32.65902], [-116.9699, 32.65888], [-116.97034, 32.6586], [-116.97066, 32.65848], [-116.97082, 32.65844], [-116.97109, 32.65842], [-116.97114, 32.65844], [-116.9712, 32.65849], [-116.97121, 32.65959]]]} | Open Access 1 | Mackenzie Creek Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/mackenzie-creek-park | 21634 | 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.804 | Mackenzie Creek 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 | |
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 | |
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 | ||
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 | |
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 | |
15500 | 15500 | 15499 | {"type": "Polygon", "coordinates": [[[-116.93523, 32.63838], [-116.93516, 32.63844], [-116.93503, 32.63832], [-116.93494, 32.63826], [-116.93435, 32.63804], [-116.93395, 32.6378], [-116.9338, 32.63775], [-116.93358, 32.63773], [-116.93354, 32.63771], [-116.93343, 32.63764], [-116.93335, 32.63754], [-116.93327, 32.63736], [-116.93325, 32.63696], [-116.93329, 32.6364], [-116.93325, 32.63578], [-116.9332, 32.63557], [-116.93294, 32.63497], [-116.93294, 32.6349], [-116.933, 32.63484], [-116.93311, 32.63478], [-116.93319, 32.63476], [-116.93374, 32.63475], [-116.9341, 32.63467], [-116.93438, 32.63456], [-116.93444, 32.63458], [-116.93466, 32.63528], [-116.93467, 32.63535], [-116.9347, 32.63536], [-116.93489, 32.63775], [-116.93497, 32.63799], [-116.93502, 32.6381], [-116.93517, 32.63832], [-116.93523, 32.63838]]]} | Open Access 1 | Mountain Hawk Park | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/mountain-hawk-park | 22540 | 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.888 | Mtn. Hawk 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 | |
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 | |
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 | |
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 |
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]);