units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

43 rows where LAYER = 5, MNG_AGENCY = 128 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

Suggested facets: COUNTY, YR_EST, GAP_STS

MNG_AG_TYP 1

  • State Agency · 43 ✖

MNG_AGENCY 1

  • Other State · 43 ✖
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
325 325 324 {"type": "Polygon", "coordinates": [[[-122.0502, 36.9496], [-122.04978, 36.94953], [-122.04949, 36.94929], [-122.04942, 36.94927], [-122.04942, 36.94924], [-122.04951, 36.94925], [-122.04961, 36.94935], [-122.04967, 36.94936], [-122.04979, 36.94944], [-122.04993, 36.94948], [-122.05019, 36.9495], [-122.0502, 36.9496]]]} Open Access 1 1106 Stockton Avenue Beach 25857 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Santa Cruz 5 0.139 Stockton Avenue Beach   None 33  
1165 1165 1164 {"type": "Polygon", "coordinates": [[[-116.90615, 32.72851], [-116.90484, 32.7283], [-116.90399, 32.72803], [-116.90394, 32.72518], [-116.90608, 32.72533], [-116.90615, 32.72851]]]} Open Access 1 7381 San Diego National Wildlife Refuge 24858 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   San Diego 4 16.779 San Diego NWR 1996 National Wildlife Refuge 105 2
2266 2266 2265 {"type": "Polygon", "coordinates": [[[-121.88959, 36.95741], [-121.88855, 36.95826], [-121.88843, 36.95817], [-121.88948, 36.95731], [-121.88959, 36.95741]]]} Open Access 1 16858 Hidden Beach 19901 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Santa Cruz 5 0.488 Hidden Beach   None 188  
3108 3108 3107 {"type": "MultiPolygon", "coordinates": [[[[-121.46234, 38.2686], [-121.46231, 38.26876], [-121.46161, 38.26911], [-121.46002, 38.26922], [-121.45923, 38.26938], [-121.45839, 38.2697], [-121.45775, 38.26965], [-121.45753, 38.26953], [-121.45774, 38.2673], [-121.45781, 38.26714], [-121.4579, 38.2664], [-121.45801, 38.26606], [-121.4583, 38.26581], [-121.45862, 38.26576], [-121.45932, 38.26588], [-121.46083, 38.2659], [-121.46118, 38.26624], [-121.46112, 38.26713], [-121.46132, 38.26782], [-121.46167, 38.26823], [-121.46211, 38.2684], [-121.46234, 38.2686]]], [[[-121.68459, 38.14478], [-121.68456, 38.14487], [-121.68445, 38.14505], [-121.68418, 38.14541], [-121.68404, 38.14611], [-121.68393, 38.14638], [-121.68387, 38.14656], [-121.68386, 38.14674], [-121.68389, 38.14684], [-121.6838, 38.14733], [-121.68366, 38.14777], [-121.68363, 38.148], [-121.68355, 38.14839], [-121.68327, 38.14912], [-121.68318, 38.14929], [-121.68312, 38.1493], [-121.68345, 38.14644], [-121.68406, 38.14476], [-121.68459, 38.14478]]]]} Restricted Access 2 25288 Cosumnes River Preserve 17678 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Sacramento 41 35.364 Cosumnes River Preserve 0 State Conservation Area 8 2
3159 3159 3158 {"type": "Polygon", "coordinates": [[[-121.50125, 38.31704], [-121.50005, 38.31773], [-121.49878, 38.31973], [-121.49852, 38.31959], [-121.4985, 38.3196], [-121.49847, 38.31958], [-121.4946, 38.31753], [-121.49279, 38.31453], [-121.50082, 38.31445], [-121.50125, 38.31704]]]} No Public Access 3 21834 Stone Lakes 25871 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Sacramento 41 68.284 Stone Lakes   None 259  
3189 3189 3188 {"type": "Polygon", "coordinates": [[[-119.71275, 36.9916], [-119.71191, 36.99249], [-119.7112, 36.99207], [-119.71091, 36.99196], [-119.71085, 36.99186], [-119.71077, 36.99183], [-119.71053, 36.99176], [-119.71044, 36.99178], [-119.71062, 36.99139], [-119.71109, 36.99063], [-119.71154, 36.99058], [-119.71275, 36.9916]]]} Open Access 1 28051 Friant Cove 19113 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Fresno 9 5.884 Friant Cove   None 262  
3458 3458 3457 {"type": "Polygon", "coordinates": [[[-123.78183, 40.4786], [-123.78172, 40.47967], [-123.78083, 40.47987], [-123.78082, 40.47937], [-123.78064, 40.47893], [-123.78183, 40.4786]]]} Open Access 1 35585 Other State 43 23264 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 2.359 Other State 43   None 287  
3467 3467 3466 {"type": "Polygon", "coordinates": [[[-123.67235, 40.14486], [-123.67136, 40.14484], [-123.67139, 40.14413], [-123.67233, 40.14419], [-123.67235, 40.14486]]]} Open Access 1 35712 Other State 11 23251 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 1.562 Other State 11   None 289  
3858 3858 3857 {"type": "Polygon", "coordinates": [[[-123.83901, 40.46367], [-123.839, 40.46751], [-123.83762, 40.46759], [-123.83761, 40.46748], [-123.83745, 40.46699], [-123.83691, 40.46742], [-123.83606, 40.46793], [-123.83528, 40.46801], [-123.83421, 40.46791], [-123.83496, 40.46784], [-123.83542, 40.46767], [-123.83587, 40.46725], [-123.83707, 40.46638], [-123.83754, 40.46561], [-123.8379, 40.46507], [-123.83813, 40.46474], [-123.83856, 40.46406], [-123.83884, 40.46367], [-123.83901, 40.46367]]]} Open Access 1 35592 Other State 4 23263 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 14.851 Other State 4   None 326  
3860 3860 3859 {"type": "Polygon", "coordinates": [[[-123.84468, 40.46319], [-123.84303, 40.46319], [-123.84302, 40.4623], [-123.8433, 40.46219], [-123.84379, 40.4621], [-123.84428, 40.46233], [-123.8444, 40.46257], [-123.84445, 40.46277], [-123.84468, 40.46319]]]} Open Access 1 35598 Other State 5 23265 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 3.304 Other State 5   None 327  
3861 3861 3860 {"type": "Polygon", "coordinates": [[[-123.62865, 40.48836], [-123.62865, 40.48852], [-123.62837, 40.48861], [-123.62769, 40.48868], [-123.62714, 40.48877], [-123.62629, 40.48945], [-123.62628, 40.48822], [-123.62671, 40.48819], [-123.62692, 40.48819], [-123.62682, 40.48845], [-123.62683, 40.48846], [-123.62714, 40.48835], [-123.62753, 40.4883], [-123.62865, 40.48836]]]} Open Access 1 35607 Other State 18 23254 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 2.876 Other State 18   None 328  
3862 3862 3861 {"type": "Polygon", "coordinates": [[[-123.67237, 40.14091], [-123.67235, 40.14147], [-123.67148, 40.1415], [-123.6715, 40.14089], [-123.67237, 40.14091]]]} Open Access 1 35608 Other State 14 23252 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Humboldt 45 1.203 Other State 14   None 329  
3877 3877 3876 {"type": "Polygon", "coordinates": [[[-122.82002, 41.67891], [-122.82001, 41.68248], [-122.81502, 41.6825], [-122.815, 41.67891], [-122.82002, 41.67891]]]} Open Access 1 35687 Other State 17 23253 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Siskiyou 28 40.983 Other State 17   None 332  
3933 3933 3932 {"type": "Polygon", "coordinates": [[[-119.21361, 38.30059], [-119.21338, 38.30059], [-119.21339, 38.29848], [-119.21349, 38.29872], [-119.21356, 38.29909], [-119.21361, 38.30059]]]} Open Access 1 36234 Other State 26 23258 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Mono 32 0.864 Other State 26   None 338  
3934 3934 3933 {"type": "Polygon", "coordinates": [[[-121.0547, 39.80881], [-121.05325, 39.80955], [-121.0533, 39.8095], [-121.04991, 39.8062], [-121.05152, 39.80559], [-121.0547, 39.80881]]]} Open Access 1 36250 Other State 23 23256 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Plumas 57 16.582 Other State 23   None 339  
3967 3967 3966 {"type": "Polygon", "coordinates": [[[-122.18624, 37.13506], [-122.18623, 37.13512], [-122.18606, 37.13501], [-122.18556, 37.13484], [-122.18456, 37.13439], [-122.18391, 37.13379], [-122.18339, 37.13353], [-122.18225, 37.13281], [-122.18232, 37.13093], [-122.1818, 37.1305], [-122.18216, 37.13004], [-122.18219, 37.12981], [-122.17623, 37.13003], [-122.17622, 37.13004], [-122.17628, 37.13022], [-122.17015, 37.13295], [-122.16845, 37.13183], [-122.16708, 37.13008], [-122.16652, 37.12959], [-122.1658, 37.12917], [-122.16478, 37.12861], [-122.16458, 37.12846], [-122.1644, 37.12829], [-122.16521, 37.12841], [-122.17376, 37.12442], [-122.17542, 37.12787], [-122.17618, 37.12994], [-122.18257, 37.1297], [-122.18258, 37.12969], [-122.18248, 37.12937], [-122.18309, 37.12927], [-122.18335, 37.13025], [-122.18278, 37.13035], [-122.18261, 37.1298], [-122.18227, 37.12981], [-122.18223, 37.13005], [-122.1819, 37.13049], [-122.18236, 37.1309], [-122.18229, 37.13277], [-122.18343, 37.13349], [-122.18395, 37.13375], [-122.18461, 37.13435], [-122.18557, 37.13479], [-122.18611, 37.13497], [-122.18624, 37.13506]]]} Open Access 1 36653 Other State 38 23261 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Santa Cruz 5 130.805 Other State 38   None 342  
4306 4306 4305 {"type": "Polygon", "coordinates": [[[-121.47627, 38.28439], [-121.47627, 38.28439], [-121.47626, 38.29098], [-121.47106, 38.28433], [-121.47627, 38.28439]]]} Restricted Access 2 45350 Stone Lakes 25872 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Sacramento 41 41.206 Stone Lakes   None 380  
4543 4543 4542 {"type": "Polygon", "coordinates": [[[-121.6849, 38.55302], [-121.68487, 38.55466], [-121.67577, 38.55668], [-121.67578, 38.5529], [-121.6849, 38.55302]]]} Open Access 1 21553 Department of Forestry 18096 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Yolo 33 59.045 Department of Forestry   None 400  
4560 4560 4559 {"type": "Polygon", "coordinates": [[[-120.34826, 34.69117], [-120.34814, 34.69379], [-120.34386, 34.69377], [-120.34383, 34.69], [-120.34826, 34.69117]]]} Open Access 1 35186 Unnamed site - Other State 28654 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Santa Barbara 7 34.99   0 State Other or Unknown 104 4
4561 4561 4560 {"type": "Polygon", "coordinates": [[[-121.68777, 36.44521], [-121.68564, 36.44803], [-121.68544, 36.44783], [-121.68401, 36.44774], [-121.68569, 36.44484], [-121.68595, 36.44475], [-121.68612, 36.44467], [-121.68628, 36.44455], [-121.68641, 36.44439], [-121.68648, 36.44425], [-121.68652, 36.44411], [-121.68653, 36.44396], [-121.68651, 36.44383], [-121.68652, 36.44381], [-121.68655, 36.4438], [-121.68658, 36.44382], [-121.68665, 36.44396], [-121.68679, 36.44411], [-121.68691, 36.4442], [-121.68711, 36.44428], [-121.68715, 36.44432], [-121.68717, 36.44437], [-121.68713, 36.44456], [-121.68714, 36.4447], [-121.68719, 36.44484], [-121.68728, 36.44497], [-121.6874, 36.44507], [-121.68751, 36.44513], [-121.68777, 36.44521]]]} Open Access 1 35187 Unnamed site - Other State 28654 299 Other State 131 State 5 State Agency 5   Other State 5 299 Other State 128 State 5 State Agency 5   Monterey 14 16.412   0 State Other or Unknown 104 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);