superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where ACCESS_TYP = 1 and MNG_AGENCY = 93 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6097 | 6097 | 6096 | {"type": "Polygon", "coordinates": [[[-119.15285, 34.1779], [-119.15284, 34.17935], [-119.1528, 34.17984], [-119.15279, 34.18011], [-119.1525, 34.18011], [-119.15239, 34.18014], [-119.1523, 34.18022], [-119.15227, 34.18028], [-119.15226, 34.18037], [-119.15222, 34.1804], [-119.15195, 34.18039], [-119.1517, 34.18034], [-119.15162, 34.18036], [-119.15157, 34.18042], [-119.15126, 34.18031], [-119.15129, 34.17789], [-119.15285, 34.1779]]]} | Open Access 1 | Lemonwood Park | 21156 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 9.413 | Lemonwood 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 | ||
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 | ||
3097 | 3097 | 3096 | {"type": "Polygon", "coordinates": [[[-119.15987, 34.17319], [-119.15982, 34.17321], [-119.15901, 34.17321], [-119.15889, 34.17311], [-119.15891, 34.17266], [-119.15866, 34.17237], [-119.1583, 34.17222], [-119.15652, 34.17235], [-119.1517, 34.1696], [-119.15172, 34.16795], [-119.15919, 34.168], [-119.15921, 34.16808], [-119.15937, 34.16808], [-119.15942, 34.16812], [-119.15975, 34.16896], [-119.15986, 34.16936], [-119.15991, 34.16971], [-119.15992, 34.17006], [-119.15989, 34.17315], [-119.15987, 34.17319]]]} | Open Access 1 | College Park | 17511 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 74.898 | College 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 | ||
2817 | 2817 | 2816 | {"type": "Polygon", "coordinates": [[[-119.1639, 34.20442], [-119.16389, 34.2052], [-119.16262, 34.2052], [-119.16261, 34.20628], [-119.15976, 34.20626], [-119.15978, 34.20439], [-119.1639, 34.20442]]]} | Open Access 1 | Del Sol Park | 18055 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 15.99 | Del Sol 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 | ||
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 | ||
382 | 382 | 381 | {"type": "Polygon", "coordinates": [[[-119.16839, 34.20259], [-119.16837, 34.20444], [-119.16645, 34.20442], [-119.16647, 34.20257], [-119.16839, 34.20259]]]} | Open Access 1 | Colonia Park | 17529 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 8.958 | Colonia 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 | ||
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 | ||
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 | ||
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 | ||
5588 | 5588 | 5587 | {"type": "Polygon", "coordinates": [[[-119.17382, 34.16206], [-119.17378, 34.16517], [-119.1697, 34.16515], [-119.16988, 34.16456], [-119.17045, 34.16208], [-119.17084, 34.16206], [-119.17114, 34.16203], [-119.17382, 34.16206]]]} | Open Access 1 | Johnson Creek Park | 20476 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 29.198 | Johnson Creek 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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);