units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where DES_TP = 3, GAP_STS = 4 and MNG_AGENCY = 110
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2171 | 2171 | 2170 | {"type": "Polygon", "coordinates": [[[-119.16005, 34.28166], [-119.15737, 34.28294], [-119.15581, 34.28113], [-119.15703, 34.28038], [-119.15823, 34.27967], [-119.15829, 34.27965], [-119.15835, 34.27968], [-119.16005, 34.28166]]]} | Open Access 1 | 16247 | Fritz Huntsinger Youth Complex | 19129 | 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 | 18.356 | Fritz Huntsinger Youth Complex | 0 | Local Recreation Area 3 | 4 | |
6399 | 6399 | 6398 | {"type": "Polygon", "coordinates": [[[-119.30632, 34.28842], [-119.30581, 34.28848], [-119.30579, 34.28839], [-119.30544, 34.28832], [-119.30545, 34.28825], [-119.30517, 34.28819], [-119.30526, 34.28788], [-119.30528, 34.28788], [-119.30548, 34.28723], [-119.3048, 34.28708], [-119.30488, 34.28682], [-119.30484, 34.2868], [-119.30508, 34.286], [-119.30511, 34.28599], [-119.30523, 34.28552], [-119.30545, 34.28556], [-119.30573, 34.28597], [-119.30591, 34.28634], [-119.30599, 34.2866], [-119.30604, 34.28684], [-119.30632, 34.28842]]]} | Open Access 1 | 1843 | Westpark Community Center | 27416 | 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.235 | Westpark Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
12697 | 12697 | 12696 | {"type": "Polygon", "coordinates": [[[-119.3071, 34.35257], [-119.30691, 34.35257], [-119.30648, 34.35228], [-119.30602, 34.35205], [-119.30155, 34.35021], [-119.30154, 34.35021], [-119.30083, 34.34992], [-119.30066, 34.3498], [-119.29909, 34.34911], [-119.29885, 34.34897], [-119.29864, 34.34879], [-119.29784, 34.34799], [-119.29773, 34.34779], [-119.29759, 34.34744], [-119.29751, 34.34708], [-119.29744, 34.34658], [-119.29745, 34.34656], [-119.29611, 34.33726], [-119.29563, 34.33453], [-119.29569, 34.33437], [-119.2958, 34.33422], [-119.29592, 34.334], [-119.29596, 34.33391], [-119.29601, 34.33366], [-119.29603, 34.33348], [-119.29598, 34.33327], [-119.29599, 34.3331], [-119.2961, 34.33261], [-119.29621, 34.33237], [-119.29628, 34.33213], [-119.29636, 34.33168], [-119.29638, 34.33123], [-119.29633, 34.33083], [-119.29619, 34.33034], [-119.29613, 34.3302], [-119.29608, 34.33016], [-119.29599, 34.33013], [-119.29554, 34.33004], [-119.29508, 34.33003], [-119.29496, 34.32997], [-119.29468, 34.3297], [-119.29393, 34.32596], [-119.29383, 34.32561], [-119.29367, 34.32528], [-119.29342, 34.32493], [-119.29301, 34.32452], [-119.29234, 34.32395], [-119.29214, 34.32375], [-119.29185, 34.3234], [-119.29161, 34.323], [-119.29148, 34.32268], [-119.2914, 34.32241], [-119.29088, 34.32008], [-119.29082, 34.31959], [-119.29082, 34.31932], [-119.29084, 34.31904], [-119.29144, 34.31425], [-119.29153, 34.31381], [-119.29162, 34.31359], [-119.29172, 34.31337], [-119.29194, 34.31304], [-119.2922, 34.31275], [-119.29375, 34.31136], [-119.29404, 34.31106], [-119.2943, 34.3107], [-119.29503, 34.3095], [-119.29567, 34.30956], [-119.29604, 34.30957], [-119.29713, 34.30959], [-119.29716, 34.30955], [-119.29767, 34.3085], [-119.29789, 34.30798], [-119.2979, 34.30792], [-119.29788, 34.30787], [-119.2977, 34.30776], [-119.29764, 34.30763], [-119.29759, 34.30761], [-119.29779, 34.30742], [-119.29797, 34.30722], [-119.29833, 34.30667], [-119.29857, 34.30618], [-119.29874, 34.30575], [-119.2994, 34.30362], [-119.29946, 34.30327], [-119.29947, 34.30265], [-119.2995, 34.30241], [-119.29956, 34.30214], [-119.29968, 34.30183], [-119.30018, 34.30095], [-119.30034, 34.30064], [-119.30043, 34.30065], [-119.3006, 34.30052], [-119.30097, 34.30059], [-119.30125, 34.3005], [-119.30161, 34.29993], [-119.30201, 34.29942], [-119.30237, 34.29903], [-119.3026, 34.29863], [-119.30282, 34.2983], [-119.3036, 34.29666], [-119.30396, 34.29581], [-119.3041, 34.29555], [-119.30431, 34.29522], [-119.305, 34.29373], [-119.30535, 34.29286], [-119.3057, 34.29213], [-119.30574, 34.29201], [-119.30575, 34.29186], [-119.30561, 34.29197], [-119.30543, 34.29193], [-119.30578, 34.2916], [-119.30602, 34.29132], [-119.30622, 34.29101], [-119.30638, 34.29066], [-119.30645, 34.29042], [-119.30651, 34.29014], [-119.30652, 34.28989], [-119.30651, 34.28958], [-119.30604, 34.28684], [-119.30593, 34.28639], [-119.3058, 34.28609], [-119.30564, 34.28582], [-119.30446, 34.28426], [-119.30448, 34.28415], [-119.30421, 34.28376], [-119.30406, 34.28342], [-119.30401, 34.2834], [-119.3038, 34.28338], [-119.30379, 34.28336], [-119.30381, 34.28335], [-119.30402, 34.28337], [-119.30408, 34.2834], [-119.30424, 34.28375], [-119.30431, 34.28386], [-119.30452, 34.28415], [-119.30457, 34.28415], [-119.30563, 34.28554], [-119.30588, 34.28591], [-119.30604, 34.28624], [-119.30612, 34.28647], [-119.30618, 34.28673], [-119.30667, 34.28957], [-119.30669, 34.2898], [-119.30667, 34.29014], [-119.30662, 34.29043], [-119.30657, 34.2906], [-119.3065, 34.2908], [-119.30634, 34.29111], [-119.30621, 34.29132], [-119.30606, 34.29152], [-119.30541, 34.29292], [-119.30527, 34.29332], [-119.30426, 34.2955], [-119.30408, 34.29584], [-119.30402, 34.29584], [-119.30361, 34.29681], [-119.30321, 34.29763], [-119.30285, 34.29831], [-119.30263, 34.29864], [-119.3024, 34.29904], [-119.30204, 34.29943], [-119.30164, 34.29995], [-119.30127, 34.30052], [-119.30097, 34.30062], [-119.30061, 34.30055], [-119.30046, 34.30066], [-119.3003, 34.301], [-119.2998, 34.30187], [-119.29969, 34.30216], [-119.29963, 34.30243], [-119.29961, 34.30266], [-119.29959, 34.30327], [-119.29953, 34.30364], [-119.29884, 34.30586], [-119.2987, 34.30622], [-119.29846, 34.30669], [-119.29817, 34.30714], [-119.29781, 34.30764], [-119.29782, 34.30765], [-119.29809, 34.30771], [-119.29776, 34.30857], [-119.29756, 34.30902], [-119.29724, 34.30968], [-119.29581, 34.30966], [-119.29513, 34.3096], [-119.29442, 34.31075], [-119.29415, 34.31112], [-119.29394, 34.31135], [-119.2923, 34.31282], [-119.29205, 34.3131], [-119.29184, 34.31342], [-119.29174, 34.31363], [-119.29166, 34.31384], [-119.29157, 34.31426], [-119.29097, 34.31905], [-119.29095, 34.31932], [-119.29095, 34.31959], [-119.29101, 34.32006], [-119.29151, 34.32233], [-119.2916, 34.32265], [-119.29173, 34.32295], [-119.29199, 34.32339], [-119.29221, 34.32366], [-119.29237, 34.32382], [-119.29311, 34.32444], [-119.29353, 34.32487], [-119.29376, 34.32519], [-119.29395, 34.32558], [-119.29406, 34.32594], [-119.29481, 34.32971], [-119.29503, 34.32991], [-119.29511, 34.32995], [-119.29556, 34.32996], [-119.29602, 34.33005], [-119.29615, 34.3301], [-119.29622, 34.33016], [-119.29629, 34.33031], [-119.29643, 34.33082], [-119.29648, 34.33123], [-119.29646, 34.33168], [-119.29638, 34.33215], [-119.2963, 34.33239], [-119.29619, 34.33264], [-119.29609, 34.33311], [-119.29608, 34.33326], [-119.29613, 34.33348], [-119.29611, 34.33367], [-119.29605, 34.33393], [-119.29601, 34.33403], [-119.29575, 34.33447], [-119.29625, 34.33725], [-119.29757, 34.34647], [-119.29759, 34.34648], [-119.29771, 34.34726], [-119.29779, 34.3475], [-119.29789, 34.34774], [-119.29801, 34.34797], [-119.29813, 34.34814], [-119.29844, 34.34851], [-119.29883, 34.34884], [-119.29926, 34.34911], [-119.29957, 34.34925], [-119.30161, 34.35009], [-119.30162, 34.35011], [-119.30602, 34.35193], [-119.30658, 34.35221], [-119.30684, 34.35238], [-119.3071, 34.35257]]]} | Open Access 1 | 46900 | Ventura River Trail | 30402 | 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 | 25.175 | Ventura River Trail | 0 | Local Recreation Area 3 | 4 | |
15653 | 15653 | 15652 | {"type": "Polygon", "coordinates": [[[-119.21269, 34.24313], [-119.20754, 34.24185], [-119.2021, 34.23827], [-119.20809, 34.23733], [-119.21234, 34.23694], [-119.21269, 34.24313]]]} | Restricted Access 2 | 300 | San Buenaventura Golf Course | 32987 | 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 | 97.146 | San Buenaventura GC | 0 | Local Recreation Area 3 | 4 | |
15696 | 15696 | 15695 | {"type": "Polygon", "coordinates": [[[-119.25659, 34.24231], [-119.25428, 34.24229], [-119.25451, 34.244], [-119.25412, 34.24391], [-119.25352, 34.24372], [-119.2535, 34.2436], [-119.25333, 34.24354], [-119.25321, 34.24362], [-119.25217, 34.24328], [-119.25168, 34.24317], [-119.25117, 34.24308], [-119.25049, 34.24303], [-119.2489, 34.24299], [-119.24827, 34.24302], [-119.24768, 34.2431], [-119.24767, 34.24276], [-119.24749, 34.24276], [-119.24709, 34.24323], [-119.24437, 34.24382], [-119.2436, 34.24393], [-119.24348, 34.24318], [-119.24343, 34.24302], [-119.24322, 34.24276], [-119.24288, 34.24238], [-119.2422, 34.24282], [-119.24183, 34.24303], [-119.24184, 34.24356], [-119.24141, 34.24358], [-119.24116, 34.24321], [-119.24087, 34.23673], [-119.24288, 34.23684], [-119.25623, 34.23634], [-119.25629, 34.23783], [-119.25642, 34.23784], [-119.25659, 34.24231]]]} | Restricted Access 2 | 18293 | Olivas Links Golf Course | 33063 | 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 | 254.598 | Olivas Links GC | 0 | Local Recreation Area 3 | 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]);