units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 3 sorted by COUNTY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2234 | 2234 | 2233 | {"type": "Polygon", "coordinates": [[[-122.29825, 38.2744], [-122.29823, 38.27446], [-122.29817, 38.2745], [-122.29809, 38.27452], [-122.29236, 38.27449], [-122.29235, 38.2745], [-122.29237, 38.27463], [-122.28394, 38.27458], [-122.2846, 38.27391], [-122.2848, 38.27382], [-122.28533, 38.27354], [-122.28611, 38.27308], [-122.28657, 38.27278], [-122.28722, 38.27197], [-122.28745, 38.27119], [-122.28741, 38.27072], [-122.28736, 38.27048], [-122.28684, 38.26916], [-122.28654, 38.26744], [-122.29799, 38.26741], [-122.29799, 38.26749], [-122.29805, 38.2675], [-122.29798, 38.26871], [-122.29796, 38.27054], [-122.29799, 38.27137], [-122.29805, 38.27227], [-122.29825, 38.2744]]]} | No Public Access 3 | 16671 | Ghisleta - South Wetlands | 19283 | 311 | Napa, County of 498 | County 3 | County Agency 3 | http://www.napaoutdoors.org/ | County 3 | 311 | Napa, County of 489 | County 3 | County Agency 3 | Napa 11 | 196.863 | Ghisleta - South Wetlands | 0 | Local Conservation Area 4 | 2 | |
3141 | 3141 | 3140 | {"type": "Polygon", "coordinates": [[[-122.22656, 38.37413], [-122.20765, 38.37399], [-122.20771, 38.35953], [-122.21237, 38.35957], [-122.21237, 38.36318], [-122.22173, 38.36325], [-122.22177, 38.36686], [-122.22646, 38.3669], [-122.22656, 38.37413]]]} | No Public Access 3 | 25801 | Milliken Reservoir Property | 22251 | 311 | Napa, County of 498 | County 3 | County Agency 3 | http://www.napaoutdoors.org/ | County 3 | 311 | Napa, County of 489 | County 3 | County Agency 3 | Napa 11 | 489.122 | Milliken Reservoir Property | 2000 | Local Other or Unknown 14 | 4 | |
10153 | 10153 | 10152 | {"type": "MultiPolygon", "coordinates": [[[[-122.29059, 38.19681], [-122.29041, 38.19715], [-122.29034, 38.19712], [-122.29051, 38.19678], [-122.29059, 38.19681]]], [[[-122.29191, 38.20038], [-122.29055, 38.20043], [-122.2914, 38.20204], [-122.29027, 38.20392], [-122.28486, 38.20226], [-122.28426, 38.20202], [-122.28598, 38.20205], [-122.28594, 38.20041], [-122.28621, 38.20041], [-122.28668, 38.1989], [-122.2867, 38.19724], [-122.28864, 38.19723], [-122.28862, 38.19828], [-122.28863, 38.19829], [-122.28948, 38.19828], [-122.2895, 38.19722], [-122.29003, 38.19722], [-122.29029, 38.19732], [-122.29035, 38.19736], [-122.29043, 38.19746], [-122.29124, 38.19913], [-122.29191, 38.20038]]], [[[-122.29464, 38.2057], [-122.2895, 38.2074], [-122.28904, 38.20603], [-122.28981, 38.20478], [-122.2898, 38.20476], [-122.28893, 38.20603], [-122.28875, 38.20556], [-122.28109, 38.20701], [-122.28354, 38.20197], [-122.28383, 38.20197], [-122.28443, 38.20222], [-122.28523, 38.2025], [-122.29025, 38.20409], [-122.29024, 38.20413], [-122.29464, 38.2057]]], [[[-122.27809, 38.20598], [-122.28047, 38.2056], [-122.28031, 38.20701], [-122.27844, 38.2073], [-122.26729, 38.20941], [-122.26593, 38.2095], [-122.26542, 38.20875], [-122.2652, 38.20834], [-122.27809, 38.20598]]], [[[-122.27938, 38.22578], [-122.27823, 38.22816], [-122.27804, 38.22835], [-122.27662, 38.22843], [-122.27572, 38.22842], [-122.27301, 38.22761], [-122.27312, 38.22738], [-122.27323, 38.2274], [-122.27442, 38.22463], [-122.27452, 38.22466], [-122.27493, 38.22383], [-122.27552, 38.22469], [-122.27938, 38.22578]]]]} | No Public Access 3 | 17693 | Napa Airport Clear Zone | 22628 | 311 | Napa, County of 498 | County 3 | County Agency 3 | http://www.napaoutdoors.org/ | County 3 | 311 | Napa, County of 489 | County 3 | County Agency 3 | Napa 11 | 240.442 | Napa Airport Clear Zone | 0 | None 881 | ||
4640 | 4640 | 4639 | {"type": "Polygon", "coordinates": [[[-121.76878, 36.88577], [-121.76854, 36.88632], [-121.76869, 36.88648], [-121.76648, 36.88819], [-121.76471, 36.88798], [-121.7647, 36.88784], [-121.76557, 36.88755], [-121.76873, 36.88508], [-121.76878, 36.88577]]]} | No Public Access 3 | 36489 | Unnamed site - Monterey, County of | 28701 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 10.195 | 0 | Local Other or Unknown 14 | 4 | ||
16112 | 16112 | 16111 | {"type": "Polygon", "coordinates": [[[-121.93713, 36.48166], [-121.93589, 36.48169], [-121.93565, 36.48218], [-121.93525, 36.48195], [-121.93482, 36.48164], [-121.93419, 36.48187], [-121.93391, 36.48199], [-121.93358, 36.48189], [-121.93342, 36.48203], [-121.93338, 36.48229], [-121.93301, 36.48226], [-121.93275, 36.48226], [-121.93231, 36.48216], [-121.93191, 36.48198], [-121.93176, 36.48178], [-121.93152, 36.48157], [-121.93128, 36.48133], [-121.93093, 36.48159], [-121.93042, 36.48151], [-121.92961, 36.48143], [-121.92935, 36.48143], [-121.929, 36.48119], [-121.92854, 36.48094], [-121.92841, 36.48085], [-121.9281, 36.48118], [-121.92781, 36.48121], [-121.92739, 36.48114], [-121.92715, 36.4812], [-121.92708, 36.48092], [-121.92701, 36.48085], [-121.92674, 36.48095], [-121.92636, 36.48143], [-121.92627, 36.48162], [-121.92607, 36.48167], [-121.92587, 36.48128], [-121.92554, 36.48106], [-121.92515, 36.48102], [-121.92488, 36.48087], [-121.92456, 36.48089], [-121.9244, 36.48062], [-121.92422, 36.48052], [-121.9239, 36.48052], [-121.92367, 36.48066], [-121.92325, 36.48067], [-121.92305, 36.48075], [-121.92282, 36.4806], [-121.92245, 36.48067], [-121.92225, 36.48048], [-121.92171, 36.48029], [-121.92126, 36.48027], [-121.9208, 36.48003], [-121.92055, 36.48], [-121.92003, 36.47982], [-121.91977, 36.47967], [-121.91945, 36.47943], [-121.9191, 36.47929], [-121.91882, 36.47951], [-121.91847, 36.47948], [-121.91822, 36.47935], [-121.91808, 36.47913], [-121.91787, 36.47903], [-121.91757, 36.47903], [-121.91711, 36.4787], [-121.91625, 36.4786], [-121.91605, 36.47854], [-121.92713, 36.47357], [-121.9276, 36.47357], [-121.92774, 36.47311], [-121.9288, 36.47271], [-121.93027, 36.47271], [-121.93103, 36.47268], [-121.93147, 36.47258], [-121.93188, 36.47516], [-121.93333, 36.47501], [-121.93331, 36.47464], [-121.93435, 36.47461], [-121.93547, 36.47413], [-121.93627, 36.47837], [-121.93633, 36.47859], [-121.93644, 36.47889], [-121.9369, 36.47982], [-121.93702, 36.48021], [-121.93711, 36.48089], [-121.93713, 36.48134], [-121.93713, 36.48166]]]} | No Public Access 3 | 16442 | County Open Space | 17714 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 288.367 | County OS | 0 | Local Recreation Area 3 | 4 | |
13013 | 13013 | 13012 | {"type": "MultiPolygon", "coordinates": [[[[-121.91526, 38.26143], [-121.91525, 38.26144], [-121.91516, 38.26502], [-121.90682, 38.27189], [-121.89801, 38.2782], [-121.89805, 38.27195], [-121.89805, 38.26472], [-121.87929, 38.26469], [-121.87927, 38.27171], [-121.87387, 38.27167], [-121.87397, 38.27128], [-121.87929, 38.26469], [-121.89614, 38.24998], [-121.89617, 38.24991], [-121.89819, 38.24991], [-121.89826, 38.24289], [-121.91522, 38.24301], [-121.91521, 38.25733], [-121.91525, 38.26116], [-121.91523, 38.26117], [-121.91526, 38.26143]]], [[[-121.91491, 38.27353], [-121.91447, 38.28644], [-121.90677, 38.28644], [-121.89698, 38.28637], [-121.90575, 38.28009], [-121.90633, 38.27971], [-121.91491, 38.27353]]]]} | No Public Access 3 | 31205 | Wilcox Ranch | 27494 | 344 | Solano, County of 1037 | County 3 | County Agency 3 | http://www.co.solano.ca.us/depts/rm/countypark/homepage.asp | County 3 | 344 | Solano, County of 999 | County 3 | County Agency 3 | Solano 26 | 1870.595 | Wilcox Ranch | 0 | Local Other or Unknown 14 | 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]);