superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where MNG_AGENCY = 93 and MNG_AG_TYP = 2 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5380 | 5380 | 5379 | {"type": "Polygon", "coordinates": [[[-119.18952, 34.19789], [-119.18952, 34.19806], [-119.18887, 34.19807], [-119.18888, 34.19845], [-119.18803, 34.19844], [-119.18803, 34.19787], [-119.18952, 34.19789]]]} | Open Access 1 | Campus Park Dog Park | https://www.oxnard.org/dog-park-opening/ | 33011 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1.5 | Campus Park Dog Park | 2016 |
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 | ||
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 | ||
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 | ||
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 | ||
6028 | 6028 | 6027 | {"type": "Polygon", "coordinates": [[[-119.17123, 34.18035], [-119.17122, 34.18095], [-119.16934, 34.18094], [-119.16928, 34.1809], [-119.16929, 34.1804], [-119.1693, 34.18036], [-119.16934, 34.18034], [-119.17123, 34.18035]]]} | Open Access 1 | Lathrop Park | 21078 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 2.942 | Lathrop 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 | ||
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 | ||
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 | ||
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 | ||
2461 | 2461 | 2460 | {"type": "Polygon", "coordinates": [[[-119.20662, 34.21599], [-119.20634, 34.21712], [-119.2049, 34.21705], [-119.20492, 34.21565], [-119.20662, 34.21599]]]} | Open Access 1 | Cabrillo Park | 16640 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 5.093 | Cabrillo 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 | ||
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 | ||
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 | ||
4483 | 4483 | 4482 | {"type": "Polygon", "coordinates": [[[-119.17293, 34.15114], [-119.17292, 34.15229], [-119.1728, 34.15227], [-119.17243, 34.15229], [-119.17106, 34.15228], [-119.17095, 34.15224], [-119.17087, 34.15215], [-119.17086, 34.15209], [-119.17086, 34.15125], [-119.17089, 34.15119], [-119.17095, 34.15114], [-119.17101, 34.15113], [-119.17293, 34.15114]]]} | Open Access 1 | Garden City Acres Park | 19195 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 5.944 | Garden City Acres 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 | ||
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 | ||
527 | 527 | 526 | {"type": "Polygon", "coordinates": [[[-119.15315, 34.20971], [-119.15313, 34.21193], [-119.15198, 34.21192], [-119.15201, 34.2097], [-119.15315, 34.20971]]]} | Open Access 1 | East Village Park | 33524 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 6.434 | East Village Park | ||
3089 | 3089 | 3088 | {"type": "Polygon", "coordinates": [[[-119.16371, 34.16633], [-119.1637, 34.16789], [-119.16212, 34.16788], [-119.16206, 34.16785], [-119.16204, 34.16782], [-119.16205, 34.16656], [-119.16205, 34.16636], [-119.16207, 34.16633], [-119.16209, 34.16632], [-119.16371, 34.16633]]]} | Open Access 1 | College Estates Park | 17501 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 6.527 | College Estates 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 |
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]);