units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where ACCESS_TYP = 1, AGNCY_NAME = 113 and DES_TP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328 | 328 | 327 | {"type": "Polygon", "coordinates": [[[-119.29146, 34.27945], [-119.29013, 34.27946], [-119.29013, 34.27839], [-119.29145, 34.27838], [-119.29146, 34.27945]]]} | Open Access 1 | 18656 | Plaza Park | 23788 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 3.582 | Plaza Park | 0 | Local Park 2 | 4 | |
512 | 512 | 511 | {"type": "Polygon", "coordinates": [[[-119.29298, 34.27992], [-119.29265, 34.27992], [-119.29264, 34.27961], [-119.29298, 34.27961], [-119.29298, 34.27992]]]} | Open Access 1 | 1711 | California Street Mini-Park | 16728 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.257 | California Street Mini-Park | 0 | Local Park 2 | 4 | |
596 | 596 | 595 | {"type": "Polygon", "coordinates": [[[-119.23927, 34.26592], [-119.23888, 34.26618], [-119.23879, 34.26665], [-119.23808, 34.26692], [-119.23803, 34.26746], [-119.23773, 34.26775], [-119.23761, 34.268], [-119.23704, 34.26825], [-119.23703, 34.26869], [-119.23653, 34.26883], [-119.23637, 34.26939], [-119.23601, 34.26984], [-119.23512, 34.2705], [-119.23444, 34.27029], [-119.23381, 34.27064], [-119.23311, 34.26734], [-119.23398, 34.26691], [-119.23433, 34.26675], [-119.23497, 34.26652], [-119.23555, 34.26637], [-119.23675, 34.26615], [-119.23927, 34.26591], [-119.23927, 34.26592]]]} | Open Access 1 | 2031 | Camino Real Park | 16769 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 38.126 | Camino Real Park | 0 | Local Park 2 | 4 | |
1091 | 1091 | 1090 | {"type": "Polygon", "coordinates": [[[-119.17671, 34.2771], [-119.1762, 34.27741], [-119.17439, 34.27532], [-119.17438, 34.27529], [-119.17439, 34.27524], [-119.17474, 34.27494], [-119.17509, 34.27471], [-119.17648, 34.27632], [-119.17619, 34.27651], [-119.17671, 34.2771]]]} | Open Access 1 | 6500 | Chumash Park | 17246 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 6.054 | Chumash Park | 0 | Local Park 2 | 4 | |
1866 | 1866 | 1865 | {"type": "Polygon", "coordinates": [[[-119.29971, 34.28152], [-119.2996, 34.28215], [-119.2993, 34.28211], [-119.29919, 34.28195], [-119.29903, 34.28195], [-119.299, 34.28177], [-119.29904, 34.28154], [-119.29917, 34.28154], [-119.29919, 34.28146], [-119.29971, 34.28152]]]} | Open Access 1 | 14310 | Eastwood Park | 18404 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.917 | Eastwood Park | 0 | Local Park 2 | 4 | |
2036 | 2036 | 2035 | {"type": "Polygon", "coordinates": [[[-119.19348, 34.28277], [-119.19377, 34.28303], [-119.19397, 34.28324], [-119.19409, 34.28341], [-119.19409, 34.28345], [-119.19406, 34.28349], [-119.19352, 34.28372], [-119.19323, 34.28379], [-119.19143, 34.28403], [-119.19137, 34.28401], [-119.19124, 34.28332], [-119.19164, 34.28327], [-119.19174, 34.2833], [-119.19184, 34.28331], [-119.19193, 34.28328], [-119.19201, 34.28324], [-119.19264, 34.28314], [-119.19282, 34.28313], [-119.19292, 34.28309], [-119.19299, 34.28302], [-119.19348, 34.28277]]]} | Open Access 1 | 17076 | Juanamaria Park | 20513 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 5.001 | Juanamaria Park | 0 | Local Park 2 | 4 | |
2173 | 2173 | 2172 | {"type": "Polygon", "coordinates": [[[-119.22184, 34.2617], [-119.21958, 34.26203], [-119.21948, 34.26171], [-119.21934, 34.26104], [-119.22048, 34.26087], [-119.22145, 34.26121], [-119.22173, 34.26117], [-119.22184, 34.2617]]]} | Open Access 1 | 17676 | Marion Cannon Park | 21862 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 5.024 | Marion Cannon Park | 0 | Local Park 2 | 4 | |
2203 | 2203 | 2202 | {"type": "Polygon", "coordinates": [[[-119.23018, 34.29322], [-119.22765, 34.29719], [-119.22605, 34.29799], [-119.22162, 34.29234], [-119.22187, 34.29194], [-119.22332, 34.29111], [-119.2241, 34.29092], [-119.22457, 34.29065], [-119.22425, 34.28885], [-119.22478, 34.28695], [-119.22538, 34.28594], [-119.22601, 34.28494], [-119.22648, 34.2849], [-119.22778, 34.2847], [-119.22771, 34.28481], [-119.2276, 34.28491], [-119.22697, 34.28859], [-119.22753, 34.29109], [-119.22954, 34.29246], [-119.23018, 34.29322]]]} | Open Access 1 | 16487 | Arroyo Verde Park | 15634 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 129.193 | Arroyo Verde Park | 0 | Local Park 2 | 4 | |
2297 | 2297 | 2296 | {"type": "Polygon", "coordinates": [[[-119.18193, 34.28262], [-119.17992, 34.28381], [-119.17988, 34.28376], [-119.17982, 34.28376], [-119.17976, 34.28374], [-119.17908, 34.28296], [-119.18115, 34.28172], [-119.18193, 34.28262]]]} | Open Access 1 | 16915 | Hobert Park | 20017 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 7.065 | Hobert Park | 0 | Local Park 2 | 4 | |
2537 | 2537 | 2536 | {"type": "Polygon", "coordinates": [[[-119.28155, 34.28091], [-119.28137, 34.2815], [-119.28137, 34.28152], [-119.28144, 34.28152], [-119.28131, 34.282], [-119.2812, 34.28198], [-119.2812, 34.28195], [-119.27995, 34.28168], [-119.27993, 34.28171], [-119.27875, 34.28146], [-119.27908, 34.28039], [-119.28155, 34.28091]]]} | Open Access 1 | 17763 | Memorial Park | 22137 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 7.12 | Memorial Park | 0 | Local Park 2 | 4 | |
2554 | 2554 | 2553 | {"type": "Polygon", "coordinates": [[[-119.29544, 34.2807], [-119.29517, 34.28071], [-119.29517, 34.28016], [-119.29543, 34.28015], [-119.29544, 34.2807]]]} | Open Access 1 | 17815 | Downtown Mini Park | 30396 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.367 | Downtown MP | 0 | Local Park 2 | 4 | |
2571 | 2571 | 2570 | {"type": "Polygon", "coordinates": [[[-119.29881, 34.2807], [-119.29868, 34.28069], [-119.29865, 34.28065], [-119.29825, 34.28064], [-119.29823, 34.28062], [-119.29798, 34.28062], [-119.29792, 34.2807], [-119.29782, 34.2807], [-119.29782, 34.28012], [-119.29826, 34.28012], [-119.29827, 34.28], [-119.29881, 34.27999], [-119.29881, 34.2807]]]} | Open Access 1 | 17855 | Mission Park | 22306 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.499 | Mission Park | 0 | Local Park 2 | 4 | |
2579 | 2579 | 2578 | {"type": "Polygon", "coordinates": [[[-119.21107, 34.25987], [-119.20587, 34.26068], [-119.20572, 34.25995], [-119.20573, 34.25993], [-119.20576, 34.25991], [-119.20576, 34.25989], [-119.2063, 34.25985], [-119.20648, 34.25981], [-119.20662, 34.25975], [-119.20684, 34.25962], [-119.20695, 34.25952], [-119.20705, 34.2594], [-119.2071, 34.25938], [-119.20742, 34.25944], [-119.20773, 34.25943], [-119.20785, 34.25998], [-119.20801, 34.26004], [-119.21, 34.25969], [-119.21005, 34.25986], [-119.21103, 34.25971], [-119.21107, 34.25987]]]} | Open Access 1 | 17901 | Montalvo Neighborhood Park | 22383 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 6.837 | Montalvo Neighborhood Park | 0 | Local Park 2 | 4 | |
2758 | 2758 | 2757 | {"type": "Polygon", "coordinates": [[[-119.25364, 34.26594], [-119.25348, 34.2665], [-119.25342, 34.26648], [-119.25332, 34.26643], [-119.25155, 34.26523], [-119.25153, 34.26518], [-119.25194, 34.26476], [-119.25364, 34.26594]]]} | Open Access 1 | 18453 | Blanche Reynolds Park | 16156 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 3.329 | Blanche Reynolds Park | 0 | Local Park 2 | 4 | |
3652 | 3652 | 3651 | {"type": "Polygon", "coordinates": [[[-119.18157, 34.27235], [-119.18155, 34.27234], [-119.1815, 34.2721], [-119.18151, 34.27206], [-119.18156, 34.27204], [-119.18177, 34.27201], [-119.1818, 34.27202], [-119.18187, 34.27209], [-119.18172, 34.27225], [-119.18157, 34.27235]]]} | Open Access 1 | 46897 | Citrus Walk Gold Park | 30399 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.194 | Citrus Walk Gold Park | 0 | Local Park 2 | 4 | |
3658 | 3658 | 3657 | {"type": "Polygon", "coordinates": [[[-119.18436, 34.27411], [-119.18356, 34.27423], [-119.18352, 34.27406], [-119.18352, 34.27397], [-119.18357, 34.27384], [-119.18369, 34.27373], [-119.18384, 34.27368], [-119.18401, 34.27368], [-119.18416, 34.27373], [-119.18428, 34.27382], [-119.18433, 34.27393], [-119.18437, 34.2741], [-119.18436, 34.27411]]]} | Open Access 1 | 46898 | Citrus Walk Sunstone Park | 30400 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.877 | Citrus Walk Sunstone Park | 0 | Local Park 2 | 4 | |
3659 | 3659 | 3658 | {"type": "Polygon", "coordinates": [[[-119.19724, 34.26741], [-119.19685, 34.26747], [-119.19679, 34.26555], [-119.19717, 34.26554], [-119.19724, 34.26741]]]} | Open Access 1 | 46899 | Cornucopia Garden | 30401 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.855 | Cornucopia Garden | 0 | Local Park 2 | 4 | |
4026 | 4026 | 4025 | {"type": "Polygon", "coordinates": [[[-119.2976, 34.27523], [-119.29725, 34.27524], [-119.29725, 34.27573], [-119.29676, 34.27573], [-119.29675, 34.27523], [-119.29711, 34.2751], [-119.29759, 34.27487], [-119.2976, 34.27523]]]} | Open Access 1 | 46901 | Promenade Park | 30403 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.986 | Promenade Park | 0 | Local Park 2 | 4 | |
4241 | 4241 | 4240 | {"type": "Polygon", "coordinates": [[[-119.19697, 34.2736], [-119.19523, 34.27385], [-119.19373, 34.27395], [-119.19338, 34.27393], [-119.19304, 34.27389], [-119.1927, 34.27383], [-119.19221, 34.2737], [-119.19188, 34.27366], [-119.19172, 34.27365], [-119.19126, 34.27367], [-119.19095, 34.27377], [-119.19079, 34.2734], [-119.19033, 34.27312], [-119.18987, 34.27244], [-119.18962, 34.27202], [-119.18927, 34.27128], [-119.18934, 34.2712], [-119.18943, 34.27118], [-119.18938, 34.27097], [-119.18929, 34.27098], [-119.18919, 34.27092], [-119.18879, 34.26901], [-119.1888, 34.26897], [-119.18886, 34.26893], [-119.18896, 34.26892], [-119.18906, 34.26893], [-119.18931, 34.26889], [-119.18943, 34.26885], [-119.1933, 34.26829], [-119.19336, 34.2683], [-119.19341, 34.26834], [-119.19366, 34.2683], [-119.19369, 34.26825], [-119.19374, 34.26822], [-119.19593, 34.26791], [-119.19595, 34.2682], [-119.19663, 34.26878], [-119.19634, 34.26986], [-119.19682, 34.2708], [-119.19642, 34.27132], [-119.1966, 34.27197], [-119.19684, 34.27333], [-119.19697, 34.2736]]]} | Open Access 1 | 1703 | Ventura Community Park | 26850 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 96.758 | Ventura Community Park | 0 | Local Park 2 | 4 | |
5248 | 5248 | 5247 | {"type": "Polygon", "coordinates": [[[-119.2221, 34.26685], [-119.22138, 34.26692], [-119.22084, 34.26693], [-119.22068, 34.26693], [-119.22064, 34.26691], [-119.2206, 34.26686], [-119.2206, 34.26657], [-119.22058, 34.26637], [-119.22054, 34.26617], [-119.22035, 34.26566], [-119.22182, 34.26545], [-119.2221, 34.26685]]]} | Open Access 1 | 1345 | Thille Neighborhood Park | 26302 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 5.001 | Thille Neighborhood 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]);