units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where AGNCY_NAME = 683 and MNG_AGENCY = 674
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3776 | 3776 | 3775 | {"type": "Polygon", "coordinates": [[[-122.63891, 41.72279], [-122.63868, 41.72414], [-122.6381, 41.72593], [-122.63764, 41.72582], [-122.63728, 41.72581], [-122.6358, 41.72545], [-122.63636, 41.72418], [-122.63739, 41.72439], [-122.63746, 41.72265], [-122.63891, 41.72279]]]} | Open Access 1 | 25377 | Yreka Creek Greenway | 27796 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 12.69 | Yreka Creek Greenway | 0 | Local Recreation Area 3 | 4 | |
3815 | 3815 | 3814 | {"type": "Polygon", "coordinates": [[[-122.64695, 41.7206], [-122.64692, 41.721], [-122.64672, 41.72116], [-122.64671, 41.72118], [-122.64664, 41.72119], [-122.64635, 41.72104], [-122.64633, 41.721], [-122.64635, 41.7209], [-122.64635, 41.72058], [-122.64695, 41.7206]]]} | Open Access 1 | 25378 | Lewis Park | 21194 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 0.701 | Lewis Park | 0 | Local Park 2 | 4 | |
3816 | 3816 | 3815 | {"type": "Polygon", "coordinates": [[[-122.64386, 41.73274], [-122.64364, 41.73323], [-122.64065, 41.73257], [-122.64096, 41.73184], [-122.64135, 41.73194], [-122.6415, 41.73169], [-122.64242, 41.73188], [-122.64237, 41.73202], [-122.64237, 41.73208], [-122.6431, 41.73226], [-122.64354, 41.73235], [-122.64343, 41.73264], [-122.64386, 41.73274]]]} | Open Access 1 | 25379 | Minor Street Park | 22270 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 5.961 | Minor Street Park | 0 | Local Park 2 | 4 | |
12182 | 12182 | 12181 | {"type": "Polygon", "coordinates": [[[-122.67033, 41.7177], [-122.669, 41.71758], [-122.6675, 41.71747], [-122.66511, 41.71704], [-122.66445, 41.71686], [-122.66212, 41.71618], [-122.66211, 41.71612], [-122.66153, 41.71591], [-122.66181, 41.7148], [-122.66215, 41.71416], [-122.66259, 41.71415], [-122.66287, 41.71363], [-122.66286, 41.71362], [-122.66237, 41.71363], [-122.66175, 41.71478], [-122.66161, 41.71545], [-122.66091, 41.71531], [-122.66032, 41.71464], [-122.65873, 41.71444], [-122.65854, 41.71422], [-122.65765, 41.71388], [-122.65718, 41.71373], [-122.65628, 41.71374], [-122.65604, 41.71364], [-122.6545, 41.71367], [-122.65313, 41.71331], [-122.65245, 41.71294], [-122.65182, 41.71277], [-122.65179, 41.7128], [-122.65147, 41.71274], [-122.65119, 41.71272], [-122.65094, 41.71274], [-122.65055, 41.71272], [-122.65015, 41.71265], [-122.64982, 41.71253], [-122.64931, 41.71222], [-122.64907, 41.71211], [-122.64893, 41.71207], [-122.64891, 41.71181], [-122.64947, 41.71184], [-122.64949, 41.71164], [-122.64943, 41.71082], [-122.6487, 41.71075], [-122.64876, 41.71034], [-122.64892, 41.70956], [-122.64788, 41.70949], [-122.64794, 41.70886], [-122.64886, 41.70858], [-122.64894, 41.70748], [-122.64914, 41.70634], [-122.64921, 41.70628], [-122.64927, 41.70414], [-122.65099, 41.70441], [-122.65101, 41.70624], [-122.66063, 41.70612], [-122.66064, 41.70657], [-122.67029, 41.70645], [-122.67026, 41.71293], [-122.66874, 41.71236], [-122.66797, 41.71307], [-122.66532, 41.71226], [-122.66495, 41.71315], [-122.67014, 41.71506], [-122.67028, 41.71479], [-122.67031, 41.71622], [-122.67033, 41.7177]], [[-122.66566, 41.7166], [-122.66565, 41.71659], [-122.66496, 41.71651], [-122.66479, 41.71688], [-122.66547, 41.71703], [-122.6655, 41.71698], [-122.66639, 41.71715], [-122.66651, 41.71683], [-122.66563, 41.71667], [-122.66566, 41.7166]]]} | Open Access 1 | 25372 | Greenhorn Park | 15039 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities/parks | Siskiyou 28 | 412.875 | Greenhorn Park | 0 | Local Park 2 | 4 |
12183 | 12183 | 12182 | {"type": "Polygon", "coordinates": [[[-122.64772, 41.73622], [-122.64765, 41.73647], [-122.64755, 41.73667], [-122.6472, 41.73695], [-122.64713, 41.73697], [-122.64669, 41.73674], [-122.64629, 41.73624], [-122.64625, 41.73611], [-122.6463, 41.73598], [-122.64633, 41.73597], [-122.64733, 41.73618], [-122.64752, 41.73619], [-122.64767, 41.73617], [-122.64772, 41.73622]]]} | Open Access 1 | 25373 | Discovery Park | 18167 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 1.977 | Discovery Park | 0 | Local Park 2 | 4 | |
12184 | 12184 | 12183 | {"type": "Polygon", "coordinates": [[[-122.6412, 41.73827], [-122.64065, 41.73942], [-122.63912, 41.73911], [-122.63935, 41.73893], [-122.63974, 41.73792], [-122.64018, 41.73801], [-122.64067, 41.73821], [-122.6407, 41.73814], [-122.6412, 41.73827]]]} | Open Access 1 | 25374 | Ringe Park and Pool | 24374 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 4.228 | Ringe Park and Pool | 0 | Local Recreation Area 3 | 4 | |
12185 | 12185 | 12184 | {"type": "Polygon", "coordinates": [[[-122.64616, 41.72621], [-122.64539, 41.72606], [-122.64498, 41.72512], [-122.64494, 41.72487], [-122.64553, 41.72473], [-122.64616, 41.72621]]]} | Open Access 1 | 25376 | Shasta Avenue Park | 25366 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 2.157 | Shasta Avenue Park | 0 | Local Park 2 | 4 | |
12609 | 12609 | 12608 | {"type": "Polygon", "coordinates": [[[-122.63702, 41.7377], [-122.63672, 41.73857], [-122.63616, 41.73845], [-122.63646, 41.73758], [-122.63702, 41.7377]]]} | Open Access 1 | 29648 | Newton Sports Complex | 22741 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 1.198 | Newton Sports Complex | 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]);