superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where MNG_AGENCY = 93 sorted by PARK_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1885 | 1885 | 1884 | {"type": "Polygon", "coordinates": [[[-119.18413, 34.17692], [-119.18411, 34.17862], [-119.18144, 34.1786], [-119.18145, 34.17747], [-119.18182, 34.17747], [-119.18211, 34.17741], [-119.18227, 34.17734], [-119.18292, 34.17703], [-119.18321, 34.17694], [-119.18344, 34.17692], [-119.18413, 34.17692]]]} | Open Access 1 | Beck Park | 15944 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 9.875 | Beck Park | ||
2096 | 2096 | 2095 | {"type": "Polygon", "coordinates": [[[-119.22351, 34.17558], [-119.22227, 34.17558], [-119.22149, 34.17566], [-119.22149, 34.17534], [-119.22151, 34.17512], [-119.22164, 34.17456], [-119.22167, 34.17425], [-119.22171, 34.17119], [-119.22176, 34.17115], [-119.22222, 34.17116], [-119.22246, 34.17121], [-119.22257, 34.17117], [-119.2226, 34.17113], [-119.22262, 34.17108], [-119.22274, 34.17108], [-119.22272, 34.17242], [-119.22318, 34.17284], [-119.22316, 34.1749], [-119.22351, 34.17558]]]} | Open Access 1 | Boat Launch Ramp and Park | 16204 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 15.688 | Boat Launch Ramp and Park | ||
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 | ||
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 |
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 | ||
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 | ||
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 | ||
3130 | 3130 | 3129 | {"type": "Polygon", "coordinates": [[[-119.18902, 34.19248], [-119.18903, 34.19378], [-119.18901, 34.194], [-119.18896, 34.19418], [-119.18888, 34.19434], [-119.18853, 34.19485], [-119.18851, 34.19481], [-119.18795, 34.19481], [-119.18793, 34.1951], [-119.18681, 34.19509], [-119.18673, 34.19498], [-119.18628, 34.19497], [-119.18629, 34.1925], [-119.18841, 34.19255], [-119.18843, 34.19247], [-119.18902, 34.19248]]]} | Open Access 1 | Community Center Park East | 17563 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 16.518 | Community Ctr. Park East | ||
3133 | 3133 | 3132 | {"type": "Polygon", "coordinates": [[[-119.19081, 34.19266], [-119.19078, 34.19509], [-119.19, 34.19507], [-119.18932, 34.19501], [-119.18887, 34.19499], [-119.18882, 34.19497], [-119.1888, 34.19493], [-119.18881, 34.1949], [-119.18913, 34.19441], [-119.18921, 34.19424], [-119.18927, 34.19404], [-119.1893, 34.19384], [-119.18929, 34.19263], [-119.18931, 34.19259], [-119.18935, 34.19257], [-119.18942, 34.19256], [-119.19001, 34.19264], [-119.19081, 34.19266]]]} | Open Access 1 | Community Center Park West | 17564 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 9.868 | Community Ctr. Park West | ||
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 | ||
3744 | 3744 | 3743 | {"type": "Polygon", "coordinates": [[[-119.18881, 34.18649], [-119.18852, 34.18658], [-119.18817, 34.18662], [-119.18634, 34.1866], [-119.18629, 34.18469], [-119.18755, 34.1847], [-119.18781, 34.18466], [-119.188, 34.18462], [-119.18812, 34.18463], [-119.18819, 34.18461], [-119.18871, 34.18471], [-119.18869, 34.18626], [-119.18881, 34.18649]]]} | Open Access 1 | Durley Park | 18316 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 11.676 | Durley 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 | ||
3815 | 3815 | 3814 | {"type": "Polygon", "coordinates": [[[-119.18691, 34.21204], [-119.18689, 34.21441], [-119.18637, 34.21442], [-119.18635, 34.21572], [-119.18508, 34.2157], [-119.18506, 34.21567], [-119.1851, 34.21203], [-119.18691, 34.21204]]]} | Open Access 1 | Eastwood Memorial Park | 18402 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 15.119 | Eastwood Memorial Park | ||
4410 | 4410 | 4409 | {"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 | Fremont Park | 19100 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 25.244 | Fremont 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 | ||
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 | ||
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 | ||
6662 | 6662 | 6661 | {"type": "Polygon", "coordinates": [[[-119.20604, 34.1862], [-119.20604, 34.18647], [-119.20603, 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.18571], [-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 | Marina West Park | 21844 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 17.052 | Marina West Park | ||
7742 | 7742 | 7741 | {"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 | Orchard Park | 23192 | 1237 | Oxnard, City of 93 | City 2 | City Agency 2 | https://www.oxnard.org/ | City 2 | 10.437 | Orchard 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]);