superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where MNG_AGENCY = 93 sorted by LABEL_NAME 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11307 | 11307 | 11306 | {"type": "Polygon", "coordinates": [[[-119.18086, 34.20514], [-119.18088, 34.20519], [-119.18086, 34.20645], [-119.17917, 34.20643], [-119.17914, 34.2064], [-119.17916, 34.20512], [-119.17976, 34.20508], [-119.18046, 34.20513], [-119.18081, 34.20512], [-119.18086, 34.20514]]]} | Open Access 1 | Wilson Park | 27612 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 5.805 | Wilson Park | ||
526 | 526 | 525 | {"type": "Polygon", "coordinates": [[[-119.23388, 34.19039], [-119.23347, 34.19039], [-119.2332, 34.19036], [-119.23289, 34.19028], [-119.23262, 34.19023], [-119.23256, 34.19019], [-119.23254, 34.19014], [-119.23255, 34.18934], [-119.23292, 34.18932], [-119.2329, 34.189], [-119.23286, 34.18882], [-119.23279, 34.18865], [-119.2327, 34.18847], [-119.23193, 34.18729], [-119.23159, 34.18743], [-119.23155, 34.18726], [-119.23157, 34.18704], [-119.23155, 34.18696], [-119.2315, 34.18689], [-119.23143, 34.18684], [-119.23134, 34.18681], [-119.23121, 34.18681], [-119.23121, 34.18652], [-119.23054, 34.18651], [-119.23054, 34.18645], [-119.23108, 34.18644], [-119.23143, 34.18628], [-119.23355, 34.18954], [-119.2337, 34.18984], [-119.23388, 34.19039]]]} | Open Access 1 | Westport at Mandalay Bay | 33523 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 5.073 | Westport at Mandalay Bay | ||
11119 | 11119 | 11118 | {"type": "Polygon", "coordinates": [[[-119.16414, 34.21332], [-119.16414, 34.21355], [-119.16352, 34.21355], [-119.16212, 34.21468], [-119.16211, 34.2151], [-119.16207, 34.2151], [-119.16203, 34.21513], [-119.16172, 34.21513], [-119.16166, 34.21508], [-119.16169, 34.21329], [-119.16175, 34.21324], [-119.16409, 34.21327], [-119.16414, 34.21332]]]} | Open Access 1 | West Village Park | 27379 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 5.579 | West Village Park | ||
10920 | 10920 | 10919 | {"type": "Polygon", "coordinates": [[[-119.17418, 34.23798], [-119.17245, 34.23962], [-119.17242, 34.23968], [-119.17245, 34.23974], [-119.17224, 34.23959], [-119.17216, 34.23955], [-119.172, 34.23971], [-119.17197, 34.2397], [-119.17197, 34.23965], [-119.17193, 34.23965], [-119.1719, 34.23966], [-119.17191, 34.2397], [-119.17187, 34.23974], [-119.17185, 34.23973], [-119.1723, 34.23886], [-119.17233, 34.23885], [-119.17311, 34.23737], [-119.17317, 34.2373], [-119.1732, 34.2372], [-119.17323, 34.23726], [-119.17327, 34.23731], [-119.17418, 34.23798]]]} | Open Access 1 | Vineyards Park | 27142 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 5.33 | Vineyards Park | ||
10848 | 10848 | 10847 | {"type": "Polygon", "coordinates": [[[-119.21445, 34.18501], [-119.21443, 34.18655], [-119.21133, 34.18652], [-119.21134, 34.18536], [-119.21139, 34.18509], [-119.21145, 34.18492], [-119.21147, 34.1849], [-119.21184, 34.18496], [-119.21441, 34.18498], [-119.21445, 34.18501]]]} | Open Access 1 | Via Marina Park | 27066 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 12.285 | Via Marina Park | ||
10335 | 10335 | 10334 | {"type": "Polygon", "coordinates": [[[-119.15408, 34.2031], [-119.15408, 34.20391], [-119.15406, 34.20393], [-119.15285, 34.20393], [-119.15282, 34.20391], [-119.15283, 34.2031], [-119.15284, 34.20308], [-119.15406, 34.20308], [-119.15408, 34.2031]]]} | Open Access 1 | Thompson Park | 26316 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 2.697 | Thompson Park | ||
528 | 528 | 527 | {"type": "Polygon", "coordinates": [[[-119.17665, 34.21415], [-119.17663, 34.2154], [-119.17537, 34.21539], [-119.17539, 34.21422], [-119.17541, 34.21418], [-119.17547, 34.21416], [-119.1759, 34.21417], [-119.17605, 34.21412], [-119.17618, 34.21415], [-119.17665, 34.21415]]]} | Open Access 1 | Sport Park South | 33525 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 3.954 | Sport Park South | ||
9836 | 9836 | 9835 | {"type": "Polygon", "coordinates": [[[-119.20626, 34.19563], [-119.20624, 34.19731], [-119.19926, 34.19726], [-119.19928, 34.19606], [-119.19965, 34.19607], [-119.1997, 34.19613], [-119.19976, 34.19617], [-119.1999, 34.19621], [-119.20002, 34.1962], [-119.20163, 34.19621], [-119.20176, 34.19622], [-119.20186, 34.19621], [-119.20194, 34.19616], [-119.20239, 34.19616], [-119.20277, 34.19597], [-119.20286, 34.19601], [-119.20295, 34.19603], [-119.20308, 34.19602], [-119.20349, 34.19603], [-119.20357, 34.19602], [-119.20365, 34.19598], [-119.20369, 34.19601], [-119.20446, 34.19602], [-119.2045, 34.19598], [-119.20458, 34.19602], [-119.20466, 34.19604], [-119.20507, 34.19603], [-119.20521, 34.19604], [-119.20535, 34.196], [-119.20545, 34.19591], [-119.20548, 34.1958], [-119.20547, 34.19562], [-119.20626, 34.19563]]]} | Open Access 1 | Southwest Community Park | 25701 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 21.874 | Southwest Community Park | ||
8358 | 8358 | 8357 | {"type": "Polygon", "coordinates": [[[-119.19132, 34.23445], [-119.19129, 34.23451], [-119.19105, 34.23458], [-119.1909, 34.23466], [-119.18976, 34.23551], [-119.18969, 34.23551], [-119.18908, 34.23496], [-119.18895, 34.23481], [-119.18883, 34.23457], [-119.18879, 34.23441], [-119.18877, 34.23428], [-119.1902, 34.23397], [-119.191, 34.23372], [-119.19132, 34.23445]]]} | Open Access 1 | Southbank Park | 25685 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 6.222 | Southbank Park | ||
9822 | 9822 | 9821 | {"type": "Polygon", "coordinates": [[[-119.18242, 34.14989], [-119.18239, 34.15011], [-119.18238, 34.15027], [-119.18206, 34.1503], [-119.18207, 34.15109], [-119.18002, 34.15109], [-119.18002, 34.15097], [-119.17997, 34.15075], [-119.17956, 34.14968], [-119.17952, 34.14952], [-119.1795, 34.14934], [-119.18149, 34.14936], [-119.18238, 34.14938], [-119.18235, 34.14986], [-119.18242, 34.14989]]]} | Open Access 1 | South Winds Park | 25684 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 10.82 | South Winds Park | ||
9642 | 9642 | 9641 | {"type": "Polygon", "coordinates": [[[-119.19007, 34.2273], [-119.19003, 34.22733], [-119.18974, 34.22733], [-119.18934, 34.22729], [-119.18722, 34.22727], [-119.18719, 34.22724], [-119.1872, 34.22659], [-119.19006, 34.22661], [-119.19007, 34.2273]]]} | Open Access 1 | Sierra Linda Park | 25455 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 5.01 | Sierra Linda Park | ||
9469 | 9469 | 9468 | {"type": "Polygon", "coordinates": [[[-119.21449, 34.19396], [-119.21253, 34.19394], [-119.21254, 34.19326], [-119.2126, 34.19305], [-119.21268, 34.19293], [-119.21278, 34.19282], [-119.21347, 34.19226], [-119.21353, 34.19225], [-119.21427, 34.19287], [-119.21435, 34.19296], [-119.21442, 34.19307], [-119.21447, 34.19318], [-119.2145, 34.1933], [-119.21449, 34.19396]]]} | Open Access 1 | Seaview Park | 25272 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 6.431 | Seaview Park | ||
9324 | 9324 | 9323 | {"type": "Polygon", "coordinates": [[[-119.20186, 34.1926], [-119.20185, 34.19386], [-119.1993, 34.19384], [-119.19932, 34.1925], [-119.20141, 34.19252], [-119.20182, 34.19258], [-119.20186, 34.1926]]]} | Open Access 1 | Sea Air Park | 25228 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 8.599 | Sea Air Park | ||
8944 | 8944 | 8943 | {"type": "Polygon", "coordinates": [[[-119.15645, 34.19952], [-119.15643, 34.20025], [-119.15488, 34.20021], [-119.1549, 34.19961], [-119.15531, 34.19947], [-119.15645, 34.19952]]]} | Open Access 1 | Rose Park | 24614 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 2.826 | Rose Park | ||
8724 | 8724 | 8723 | {"type": "Polygon", "coordinates": [[[-119.17027, 34.22233], [-119.17025, 34.22401], [-119.16877, 34.224], [-119.16883, 34.2239], [-119.16884, 34.22383], [-119.16879, 34.22376], [-119.1687, 34.22372], [-119.16859, 34.22374], [-119.16849, 34.22383], [-119.16819, 34.22383], [-119.16821, 34.22232], [-119.17027, 34.22233]]]} | Open Access 1 | Rio Lindo Park | 24383 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 8.4 | Rio Lindo Park | ||
8251 | 8251 | 8250 | {"type": "Polygon", "coordinates": [[[-119.17175, 34.15737], [-119.17173, 34.15934], [-119.17167, 34.15946], [-119.1713, 34.15976], [-119.16928, 34.15808], [-119.1693, 34.15804], [-119.16995, 34.15753], [-119.17008, 34.15745], [-119.17022, 34.1574], [-119.17042, 34.15737], [-119.17175, 34.15737]]]} | Open Access 1 | Pleasant Valley Park | 23801 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 9.592 | Pleasant Valley Park | ||
7009 | 7009 | 7008 | {"type": "Polygon", "coordinates": [[[-119.18097, 34.19734], [-119.18096, 34.19804], [-119.17997, 34.19803], [-119.17997, 34.19733], [-119.18097, 34.19734]]]} | Open Access 1 | Plaza Park | 23787 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1.75 | Plaza Park | ||
6845 | 6845 | 6844 | {"type": "Polygon", "coordinates": [[[-119.22722, 34.17014], [-119.2272, 34.17019], [-119.22717, 34.17024], [-119.22711, 34.17028], [-119.22703, 34.1703], [-119.22543, 34.17028], [-119.22543, 34.16974], [-119.22697, 34.16921], [-119.22722, 34.16972], [-119.22722, 34.17014]]]} | Open Access 1 | Peninsula Park | 23580 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 3.673 | Peninsula Park | ||
7829 | 7829 | 7828 | {"type": "Polygon", "coordinates": [[[-119.18391, 34.16307], [-119.18388, 34.16515], [-119.18338, 34.16516], [-119.18325, 34.16511], [-119.18315, 34.16513], [-119.18312, 34.16516], [-119.18312, 34.16559], [-119.18135, 34.16558], [-119.18132, 34.16526], [-119.18123, 34.16495], [-119.18107, 34.16461], [-119.1808, 34.1642], [-119.18067, 34.16387], [-119.18063, 34.16355], [-119.18063, 34.16304], [-119.18389, 34.16305], [-119.18391, 34.16307]]]} | Open Access 1 | Oxnard holding 1 | 23282 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 18.195 | Oxnard holding 1 | ||
542 | 542 | 541 | {"type": "Polygon", "coordinates": [[[-119.16573, 34.21387], [-119.16566, 34.21391], [-119.16562, 34.21398], [-119.16561, 34.21418], [-119.16528, 34.21418], [-119.16527, 34.21381], [-119.16436, 34.2138], [-119.16437, 34.2133], [-119.16439, 34.21328], [-119.16571, 34.21329], [-119.1657, 34.21381], [-119.16573, 34.21387]]]} | Open Access 1 | Oxnard Historic Farm Park | 33526 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 2.111 | Oxnard Historic Farm 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]);