superunits_with_maps

Table actions

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

2 rows where MNG_AGENCY = 47 and YR_EST = 1929

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Parks and Recreation · 2 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
15215 15215 15214 {"type": "MultiPolygon", "coordinates": [[[[-123.82123, 40.13925], [-123.81466, 40.13936], [-123.81156, 40.13939], [-123.80906, 40.14122], [-123.80927, 40.13942], [-123.80891, 40.13941], [-123.80883, 40.13849], [-123.80858, 40.13733], [-123.80758, 40.13584], [-123.80675, 40.13432], [-123.80657, 40.1341], [-123.80645, 40.13238], [-123.81135, 40.1323], [-123.81124, 40.12797], [-123.81226, 40.12808], [-123.81291, 40.12754], [-123.82106, 40.12717], [-123.82074, 40.12801], [-123.82048, 40.12825], [-123.82008, 40.1285], [-123.82009, 40.12851], [-123.82109, 40.1285], [-123.82107, 40.12901], [-123.82108, 40.13566], [-123.82123, 40.13925]]], [[[-123.85492, 40.12513], [-123.85376, 40.12519], [-123.85009, 40.12519], [-123.84532, 40.12533], [-123.84534, 40.12621], [-123.84561, 40.12957], [-123.83164, 40.12877], [-123.83149, 40.12715], [-123.83249, 40.127], [-123.8338, 40.1263], [-123.83436, 40.1259], [-123.83581, 40.12477], [-123.83614, 40.12454], [-123.83614, 40.12452], [-123.83603, 40.12446], [-123.83632, 40.12417], [-123.83671, 40.12293], [-123.83665, 40.12271], [-123.83659, 40.12217], [-123.8349, 40.12204], [-123.83489, 40.12074], [-123.83563, 40.12077], [-123.83637, 40.12092], [-123.83635, 40.12052], [-123.84011, 40.1211], [-123.83998, 40.11885], [-123.83483, 40.1187], [-123.83477, 40.11851], [-123.83572, 40.11816], [-123.83572, 40.11773], [-123.83561, 40.11757], [-123.83495, 40.11696], [-123.83423, 40.11661], [-123.83362, 40.11628], [-123.8333, 40.11596], [-123.83184, 40.11551], [-123.83108, 40.11522], [-123.83092, 40.11531], [-123.8308, 40.11517], [-123.8306, 40.11502], [-123.83022, 40.1149], [-123.83067, 40.11028], [-123.82515, 40.11039], [-123.82502, 40.10649], [-123.84453, 40.10712], [-123.84865, 40.10686], [-123.84968, 40.12165], [-123.85477, 40.1215], [-123.85492, 40.12513]]], [[[-123.82948, 40.12628], [-123.82805, 40.12582], [-123.8262, 40.12562], [-123.82656, 40.12531], [-123.82727, 40.125], [-123.82786, 40.12509], [-123.82805, 40.12533], [-123.82808, 40.12542], [-123.82876, 40.12548], [-123.82935, 40.12517], [-123.82948, 40.12505], [-123.82948, 40.12628]]], [[[-123.83224, 40.11696], [-123.8313, 40.11723], [-123.83058, 40.11725], [-123.83076, 40.11713], [-123.83094, 40.11704], [-123.83187, 40.11665], [-123.83207, 40.1168], [-123.83223, 40.11688], [-123.83224, 40.11696]]], [[[-123.83477, 40.12005], [-123.83429, 40.12011], [-123.8342, 40.11991], [-123.8337, 40.11999], [-123.83354, 40.1196], [-123.83408, 40.11951], [-123.83406, 40.11931], [-123.83473, 40.11921], [-123.83477, 40.12005]]], [[[-123.8348, 40.12203], [-123.83399, 40.12189], [-123.83399, 40.12134], [-123.83435, 40.12136], [-123.83435, 40.121], [-123.83397, 40.12095], [-123.83395, 40.12067], [-123.8348, 40.12071], [-123.8348, 40.12203]]]]} Restricted Access 2 John B. Dewitt Redwoods State Natural Reserve   31547 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 1226.593 John B. Dewitt Redwoods SNR 1929
15255 15255 15254 {"type": "Polygon", "coordinates": [[[-120.11174, 38.99104], [-120.11051, 38.99106], [-120.11046, 38.99122], [-120.11015, 38.99165], [-120.1099, 38.99185], [-120.10862, 38.99249], [-120.10848, 38.99272], [-120.10831, 38.99297], [-120.10823, 38.99329], [-120.10821, 38.99379], [-120.10827, 38.99438], [-120.1079, 38.99478], [-120.10761, 38.99483], [-120.10723, 38.99496], [-120.10256, 38.99844], [-120.10197, 39.00101], [-120.09986, 39.0032], [-120.09077, 39.00298], [-120.09119, 38.9802], [-120.08402, 38.97336], [-120.08933, 38.96887], [-120.08932, 38.96886], [-120.08929, 38.96887], [-120.09332, 38.96568], [-120.0937, 38.96566], [-120.09798, 38.96568], [-120.10677, 38.96564], [-120.10703, 38.98017], [-120.11155, 38.98019], [-120.11174, 38.99104]], [[-120.10482, 38.9803], [-120.10476, 38.98018], [-120.10346, 38.9802], [-120.10354, 38.98048], [-120.10384, 38.98104], [-120.10408, 38.98141], [-120.10451, 38.98191], [-120.1049, 38.98229], [-120.10525, 38.98253], [-120.10647, 38.98327], [-120.10718, 38.98375], [-120.10767, 38.98426], [-120.10777, 38.98442], [-120.1078, 38.98459], [-120.10778, 38.98479], [-120.10754, 38.98542], [-120.10724, 38.98613], [-120.10711, 38.98683], [-120.10713, 38.98707], [-120.10711, 38.9873], [-120.10846, 38.98732], [-120.10846, 38.98721], [-120.1084, 38.98705], [-120.10838, 38.98687], [-120.10848, 38.98636], [-120.10875, 38.98573], [-120.10903, 38.98498], [-120.10908, 38.98458], [-120.109, 38.98412], [-120.10874, 38.98373], [-120.10815, 38.98311], [-120.10719, 38.98246], [-120.10615, 38.98183], [-120.10572, 38.98154], [-120.10508, 38.98089], [-120.10482, 38.9803]]]} Open Access 1 D.L. Bliss State Park http://www.parks.ca.gov/?page_id=505 14014 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 1554.885 D.L. Bliss SP 1929

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);