units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where MNG_AGENCY = 93 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 5
MNG_AG_TYP 1
- City Agency 41
MNG_AGENCY 1
- Oxnard, City of · 41 ✖
ACCESS_TYP 1
- Open Access 41
Link | rowid | id | map | ACCESS_TYP | UNIT_ID ▼ | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
233 | 233 | 232 | {"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 | 751 | Seaview Park | 25272 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 6.433 | Seaview Park | 0 | Local Park 2 | 4 | |
2908 | 2908 | 2907 | {"type": "Polygon", "coordinates": [[[-119.20626, 34.19563], [-119.20624, 34.19731], [-119.19926, 34.19726], [-119.19928, 34.19606], [-119.19965, 34.19607], [-119.19969, 34.19613], [-119.19976, 34.19617], [-119.1999, 34.19621], [-119.20002, 34.1962], [-119.20163, 34.19621], [-119.20176, 34.19623], [-119.20186, 34.19621], [-119.20194, 34.19616], [-119.20239, 34.19616], [-119.20277, 34.19597], [-119.20285, 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.19581], [-119.20547, 34.19562], [-119.20626, 34.19563]]]} | Open Access 1 | 1013 | Southwest Community Park | 25701 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 21.874 | Southwest Community Park | 0 | Local Park 2 | 4 | |
432 | 432 | 431 | {"type": "Polygon", "coordinates": [[[-119.21445, 34.18501], [-119.21443, 34.18655], [-119.21133, 34.18652], [-119.21134, 34.18535], [-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 | 1737 | Via Marina Park | 27066 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 12.286 | Via Marina Park | 0 | Local Park 2 | 4 | |
1365 | 1365 | 1364 | {"type": "Polygon", "coordinates": [[[-119.15937, 34.16808], [-119.15942, 34.16812], [-119.15975, 34.16896], [-119.15986, 34.16936], [-119.15991, 34.16971], [-119.15992, 34.17005], [-119.15989, 34.17315], [-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.1592, 34.16808], [-119.15937, 34.16808]]]} | Open Access 1 | 8157 | College Park | 17511 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 74.897 | College Park | 0 | Local Park 2 | 4 | |
1767 | 1767 | 1766 | {"type": "Polygon", "coordinates": [[[-119.1639, 34.20442], [-119.16389, 34.2052], [-119.16262, 34.20519], [-119.16261, 34.20628], [-119.15976, 34.20626], [-119.15978, 34.20439], [-119.1639, 34.20442]]]} | Open Access 1 | 13232 | Del Sol Park | 18055 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 15.982 | Del Sol Park | 0 | Local Park 2 | 4 | |
10135 | 10135 | 10134 | {"type": "Polygon", "coordinates": [[[-119.20604, 34.1862], [-119.20604, 34.18647], [-119.20602, 34.18657], [-119.20598, 34.1867], [-119.20588, 34.18684], [-119.20375, 34.18681], [-119.20376, 34.18622], [-119.20374, 34.18615], [-119.2037, 34.18609], [-119.20363, 34.18604], [-119.20355, 34.18601], [-119.20298, 34.186], [-119.20294, 34.18599], [-119.20292, 34.18596], [-119.20295, 34.18398], [-119.20298, 34.18396], [-119.20533, 34.18398], [-119.20531, 34.18572], [-119.20564, 34.18573], [-119.20564, 34.18601], [-119.20568, 34.1861], [-119.20578, 34.18616], [-119.206, 34.18617], [-119.20604, 34.1862]]]} | Open Access 1 | 17651 | Marina West Park | 21844 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 17.048 | Marina West Park | 0 | Local Park 2 | 4 | |
9886 | 9886 | 9885 | {"type": "Polygon", "coordinates": [[[-119.23869, 34.1832], [-119.23531, 34.18445], [-119.234, 34.18203], [-119.2371, 34.18086], [-119.2381, 34.1818], [-119.23835, 34.18225], [-119.2384, 34.18251], [-119.23847, 34.18274], [-119.23856, 34.18297], [-119.23869, 34.1832]]]} | Open Access 1 | 18326 | Oxnard Beach Park | 23281 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 25.008 | Oxnard Beach Park | 0 | Local Park 2 | 4 | |
2767 | 2767 | 2766 | {"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 | 18479 | Peninsula Park | 23580 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 3.673 | Peninsula Park | 0 | Local Park 2 | 4 | |
2399 | 2399 | 2398 | {"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 | 18651 | Plaza Park | 23787 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 1.751 | Plaza Park | 0 | Local Park 2 | 4 | |
10512 | 10512 | 10511 | {"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 | 18661 | Pleasant Valley Park | 23801 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 9.593 | Pleasant Valley Park | 0 | Local Park 2 | 4 | |
10673 | 10673 | 10672 | {"type": "Polygon", "coordinates": [[[-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], [-119.18088, 34.20519], [-119.18086, 34.20645]]]} | Open Access 1 | 19018 | Wilson Park | 27612 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 5.805 | Wilson Park | 0 | Local Park 2 | 4 | |
10674 | 10674 | 10673 | {"type": "Polygon", "coordinates": [[[-119.18263, 34.22374], [-119.18262, 34.225], [-119.18055, 34.22498], [-119.18051, 34.22496], [-119.18053, 34.22305], [-119.18055, 34.22302], [-119.18262, 34.22303], [-119.18261, 34.22372], [-119.18263, 34.22374]]]} | Open Access 1 | 19019 | Orchard Park | 23192 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 10.438 | Orchard Park | 0 | Local Park 2 | 4 | |
10675 | 10675 | 10674 | {"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 | 19020 | Sierra Linda Park | 25455 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 5.01 | Sierra Linda Park | 0 | Local Park 2 | 4 | |
10676 | 10676 | 10675 | {"type": "Polygon", "coordinates": [[[-119.19215, 34.21195], [-119.19212, 34.2144], [-119.1921, 34.21443], [-119.18814, 34.21441], [-119.1881, 34.21438], [-119.18812, 34.21192], [-119.19215, 34.21195]]]} | Open Access 1 | 19021 | Fremont Park | 19100 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 25.245 | Fremont Park | 0 | Local Park 2 | 4 | |
10679 | 10679 | 10678 | {"type": "Polygon", "coordinates": [[[-119.18691, 34.21204], [-119.18689, 34.21441], [-119.18637, 34.21441], [-119.18635, 34.21572], [-119.18508, 34.2157], [-119.18506, 34.21567], [-119.1851, 34.21203], [-119.18691, 34.21204]]]} | Open Access 1 | 19022 | Eastwood Memorial Park | 18402 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 15.115 | Eastwood Memorial Park | 0 | Local Park 2 | 4 | |
10089 | 10089 | 10088 | {"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 | 19023 | Cabrillo Park | 16640 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 5.094 | Cabrillo Park | 0 | Local Park 2 | 4 | |
10680 | 10680 | 10679 | {"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 | 19024 | West Village Park | 27379 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 5.576 | West Village Park | 0 | Local Park 2 | 4 | |
10681 | 10681 | 10680 | {"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 | 19025 | Rio Lindo Park | 24383 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 8.4 | Rio Lindo Park | 0 | Local Park 2 | 4 | |
5118 | 5118 | 5117 | {"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 | 19026 | Rose Park | 24614 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 2.827 | Rose Park | 0 | Local Park 2 | 4 | |
10638 | 10638 | 10637 | {"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 | 19027 | Thompson Park | 26316 | 1237 | Oxnard, City of 95 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | Ventura 8 | 2.698 | Thompson Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);