units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where DES_TP = 4 and MNG_AGENCY = 13
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Watsonville, City of · 5 ✖
DES_TP 1
- Local Conservation Area · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
418 | 418 | 417 | {"type": "MultiPolygon", "coordinates": [[[[-121.7791, 36.92112], [-121.77861, 36.92097], [-121.77814, 36.92117], [-121.77746, 36.9222], [-121.7769, 36.92436], [-121.77687, 36.92456], [-121.77667, 36.92366], [-121.77666, 36.92365], [-121.77613, 36.92561], [-121.77599, 36.92621], [-121.77601, 36.92699], [-121.77567, 36.92723], [-121.77534, 36.92621], [-121.77526, 36.92569], [-121.7753, 36.92516], [-121.77549, 36.92432], [-121.77552, 36.9241], [-121.77553, 36.92388], [-121.776, 36.92394], [-121.77606, 36.92283], [-121.77616, 36.92252], [-121.77623, 36.9219], [-121.77645, 36.92201], [-121.77717, 36.9225], [-121.77833, 36.91963], [-121.7791, 36.92112]]], [[[-121.77899, 36.91916], [-121.77866, 36.91936], [-121.77838, 36.91931], [-121.77842, 36.91897], [-121.77824, 36.91893], [-121.77848, 36.91836], [-121.77891, 36.91869], [-121.77899, 36.91916]]]]} | Open Access 1 | 1666 | Upper Struve Slough | 28147 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 15.625 | Upper Struve Slough | 0 | Local Conservation Area 4 | 2 | |
2265 | 2265 | 2264 | {"type": "Polygon", "coordinates": [[[-121.80532, 36.92238], [-121.80509, 36.92259], [-121.80524, 36.92344], [-121.80501, 36.92403], [-121.80178, 36.92397], [-121.80168, 36.92488], [-121.80174, 36.92521], [-121.80015, 36.92537], [-121.7999, 36.92535], [-121.79967, 36.92527], [-121.79939, 36.92508], [-121.79917, 36.92485], [-121.79886, 36.92448], [-121.79865, 36.92435], [-121.79847, 36.92427], [-121.79754, 36.92367], [-121.79741, 36.92355], [-121.79735, 36.9234], [-121.79737, 36.92325], [-121.79743, 36.92324], [-121.79754, 36.92291], [-121.79743, 36.92286], [-121.79796, 36.92185], [-121.79855, 36.9219], [-121.80194, 36.92234], [-121.80196, 36.92219], [-121.80529, 36.92225], [-121.80532, 36.92238]]]} | Restricted Access 2 | 16755 | Harkins Slough | 28150 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 43.338 | Harkins Slough | 0 | Local Conservation Area 4 | 2 | |
6156 | 6156 | 6155 | {"type": "MultiPolygon", "coordinates": [[[[-121.78291, 36.91621], [-121.78256, 36.91719], [-121.78052, 36.91505], [-121.78046, 36.91505], [-121.78046, 36.91507], [-121.78205, 36.91673], [-121.7818, 36.91671], [-121.78152, 36.91672], [-121.78124, 36.91665], [-121.78115, 36.91624], [-121.78093, 36.91599], [-121.78049, 36.91589], [-121.78022, 36.9166], [-121.77992, 36.91692], [-121.78009, 36.91729], [-121.77988, 36.91746], [-121.77968, 36.91742], [-121.77949, 36.91735], [-121.77903, 36.91738], [-121.77991, 36.91507], [-121.7799, 36.91506], [-121.77903, 36.91506], [-121.77873, 36.91504], [-121.77879, 36.91477], [-121.77937, 36.91429], [-121.77963, 36.91378], [-121.77971, 36.91357], [-121.77975, 36.91322], [-121.77974, 36.9128], [-121.77975, 36.91269], [-121.77989, 36.91225], [-121.77985, 36.91009], [-121.77896, 36.91009], [-121.77856, 36.91033], [-121.77857, 36.91154], [-121.77852, 36.91173], [-121.77837, 36.91188], [-121.77817, 36.91197], [-121.77786, 36.91206], [-121.77758, 36.9122], [-121.7774, 36.91233], [-121.77715, 36.91221], [-121.77673, 36.91208], [-121.77722, 36.91156], [-121.77745, 36.91053], [-121.77591, 36.91037], [-121.77598, 36.91021], [-121.77805, 36.91048], [-121.77883, 36.90994], [-121.77934, 36.90977], [-121.7796, 36.90977], [-121.78003, 36.90997], [-121.78058, 36.90929], [-121.78185, 36.907], [-121.7823, 36.9077], [-121.78239, 36.90796], [-121.78242, 36.90824], [-121.78217, 36.90875], [-121.78208, 36.90927], [-121.7822, 36.90995], [-121.78191, 36.91045], [-121.78182, 36.91067], [-121.78188, 36.91089], [-121.78216, 36.91114], [-121.78196, 36.9113], [-121.78219, 36.91146], [-121.78236, 36.91136], [-121.78246, 36.91149], [-121.78202, 36.91206], [-121.7822, 36.91288], [-121.78242, 36.91344], [-121.78232, 36.91347], [-121.7823, 36.91365], [-121.78234, 36.9139], [-121.78209, 36.91426], [-121.78216, 36.91444], [-121.78204, 36.91461], [-121.78163, 36.91485], [-121.7812, 36.91487], [-121.7812, 36.91492], [-121.78121, 36.91493], [-121.78122, 36.91508], [-121.78205, 36.91593], [-121.78248, 36.91614], [-121.78291, 36.91621]], [[-121.78034, 36.91495], [-121.78035, 36.91493], [-121.78023, 36.91483], [-121.78019, 36.91496], [-121.78034, 36.91495]]], [[[-121.79241, 36.9166], [-121.79041, 36.91742], [-121.79014, 36.91691], [-121.7892, 36.91776], [-121.78899, 36.91741], [-121.78853, 36.91653], [-121.78866, 36.91621], [-121.78868, 36.91587], [-121.7886, 36.91553], [-121.78842, 36.91523], [-121.78815, 36.91497], [-121.78755, 36.91451], [-121.78726, 36.91412], [-121.78726, 36.91403], [-121.78733, 36.91397], [-121.78833, 36.91355], [-121.78831, 36.91349], [-121.7893, 36.91306], [-121.79027, 36.91424], [-121.7912, 36.9153], [-121.79144, 36.91551], [-121.79186, 36.91583], [-121.79198, 36.91594], [-121.79241, 36.9166]]], [[[-121.79536, 36.91187], [-121.79513, 36.91547], [-121.79465, 36.91567], [-121.79471, 36.91597], [-121.79454, 36.91611], [-121.79442, 36.91627], [-121.7944, 36.91634], [-121.79399, 36.91474], [-121.79383, 36.91475], [-121.79366, 36.91474], [-121.7935, 36.91467], [-121.79335, 36.91457], [-121.79305, 36.9141], [-121.79301, 36.91397], [-121.79295, 36.9137], [-121.79292, 36.91343], [-121.79291, 36.91315], [-121.79294, 36.91288], [-121.79309, 36.91235], [-121.79316, 36.91222], [-121.79337, 36.912], [-121.79355, 36.91177], [-121.7937, 36.91153], [-121.79374, 36.9114], [-121.79375, 36.91127], [-121.79364, 36.91115], [-121.79406, 36.91097], [-121.79536, 36.91187]]], [[[-121.79504, 36.91694], [-121.79497, 36.91818], [-121.79447, 36.91813], [-121.79454, 36.91704], [-121.79447, 36.91679], [-121.79469, 36.91689], [-121.79504, 36.91694]]]]} | Open Access 1 | 1166 | Struve Slough | 28148 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 105.317 | Struve Slough | 0 | Local Conservation Area 4 | 2 | |
9692 | 9692 | 9691 | {"type": "Polygon", "coordinates": [[[-121.82747, 36.9152], [-121.82607, 36.9168], [-121.82571, 36.91674], [-121.82537, 36.91664], [-121.82532, 36.91668], [-121.82468, 36.91634], [-121.82421, 36.91602], [-121.82368, 36.91571], [-121.82311, 36.91547], [-121.82248, 36.91531], [-121.82184, 36.91523], [-121.82145, 36.91524], [-121.82079, 36.91532], [-121.81964, 36.91555], [-121.81917, 36.91559], [-121.81862, 36.91557], [-121.81814, 36.91548], [-121.81777, 36.91537], [-121.81739, 36.91521], [-121.81705, 36.91502], [-121.81678, 36.91482], [-121.81457, 36.91299], [-121.8141, 36.91247], [-121.81373, 36.91189], [-121.81598, 36.91026], [-121.81956, 36.9132], [-121.82148, 36.91203], [-121.82242, 36.91172], [-121.82319, 36.91255], [-121.82441, 36.91278], [-121.82529, 36.91254], [-121.82747, 36.9152]]]} | Restricted Access 2 | 16377 | Gallighan Slough | 28151 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 98.834 | Gallighan Slough | 0 | Local Conservation Area 4 | 2 | |
13899 | 13899 | 13898 | {"type": "Polygon", "coordinates": [[[-121.7736, 36.90511], [-121.77056, 36.90721], [-121.77033, 36.90877], [-121.77033, 36.90885], [-121.7704, 36.90898], [-121.77059, 36.90911], [-121.77068, 36.90926], [-121.7708, 36.90935], [-121.77111, 36.90952], [-121.76947, 36.90947], [-121.76947, 36.90919], [-121.76878, 36.90923], [-121.76876, 36.90919], [-121.76916, 36.90906], [-121.76915, 36.90904], [-121.76899, 36.90903], [-121.76903, 36.90896], [-121.76906, 36.90887], [-121.76904, 36.90873], [-121.76945, 36.90828], [-121.76949, 36.90796], [-121.76968, 36.90783], [-121.76914, 36.90683], [-121.77055, 36.90589], [-121.77139, 36.90613], [-121.77341, 36.90474], [-121.7736, 36.90511]]]} | Open Access 1 | 36509 | Watsonville Slough | 28585 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 13.721 | Watsonville Slough | 0 | Local Conservation Area 4 | 2 |
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]);