superunits_with_maps

Table actions

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

3 rows where ACCESS_TYP = 2, MNG_AG_LEV = 4 and MNG_AG_TYP = 17

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Community Services District · 3 ✖

ACCESS_TYP 1

  • Restricted Access · 3 ✖
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
10976 10976 10975 {"type": "Polygon", "coordinates": [[[-120.11431, 39.3076], [-120.11095, 39.30758], [-120.11095, 39.30942], [-120.11204, 39.30942], [-120.11192, 39.31386], [-120.10961, 39.3139], [-120.10962, 39.32423], [-120.10845, 39.32431], [-120.10846, 39.32715], [-120.11194, 39.32719], [-120.11203, 39.33019], [-120.08116, 39.33018], [-120.08102, 39.32357], [-120.08615, 39.32375], [-120.0861, 39.31577], [-120.09573, 39.31569], [-120.09559, 39.30119], [-120.1082, 39.30121], [-120.10955, 39.3018], [-120.11073, 39.30196], [-120.1143, 39.30215], [-120.11431, 39.3076]]]} Restricted Access 2 Waddle Ranch   27205 2329 Truckee Tahoe Airport District 651 Special District 4 Community Services District 17 http://www.truckeetahoeairport.com/ Special District 4 1461.57 Waddle Ranch  
13807 13807 13806 {"type": "Polygon", "coordinates": [[[-124.08423, 40.91223], [-124.08337, 40.91339], [-124.08297, 40.91427], [-124.08271, 40.9151], [-124.08267, 40.91537], [-124.08199, 40.91665], [-124.07922, 40.91579], [-124.07921, 40.91543], [-124.07916, 40.91219], [-124.08423, 40.91223]]]} Restricted Access 2 Riverfront Park   31322 2238 McKinleyville Community Services District 613 Special District 4 Community Services District 17 http://mckinleyvillecsd.com/ Special District 4 36.388 Riverfront Park  
14596 14596 14595 {"type": "Polygon", "coordinates": [[[-123.38922, 39.4385], [-123.38888, 39.43888], [-123.38872, 39.43884], [-123.38836, 39.43885], [-123.38793, 39.43897], [-123.38765, 39.43907], [-123.38741, 39.43928], [-123.3873, 39.43956], [-123.38734, 39.43987], [-123.38754, 39.44014], [-123.38769, 39.44026], [-123.38802, 39.44001], [-123.38807, 39.44006], [-123.38775, 39.44032], [-123.38797, 39.44061], [-123.38759, 39.44097], [-123.38761, 39.44128], [-123.388, 39.44131], [-123.38802, 39.44139], [-123.38765, 39.44141], [-123.38764, 39.44142], [-123.38805, 39.44196], [-123.38808, 39.44209], [-123.38806, 39.44218], [-123.38809, 39.44229], [-123.38805, 39.44246], [-123.38806, 39.44262], [-123.38813, 39.44281], [-123.38816, 39.443], [-123.38838, 39.4434], [-123.38842, 39.44351], [-123.38827, 39.44357], [-123.38819, 39.44362], [-123.38805, 39.44375], [-123.38801, 39.44384], [-123.38798, 39.44392], [-123.38797, 39.44401], [-123.38799, 39.44409], [-123.38807, 39.44428], [-123.38809, 39.44438], [-123.38809, 39.44442], [-123.38806, 39.44446], [-123.38801, 39.44448], [-123.38793, 39.44447], [-123.38781, 39.44443], [-123.3876, 39.4443], [-123.38732, 39.44418], [-123.387, 39.44412], [-123.38674, 39.44413], [-123.38657, 39.44407], [-123.38611, 39.44381], [-123.38579, 39.44378], [-123.3855, 39.44386], [-123.38525, 39.44339], [-123.38602, 39.44231], [-123.38594, 39.44214], [-123.38582, 39.44212], [-123.38557, 39.4422], [-123.38542, 39.44243], [-123.38505, 39.44211], [-123.38493, 39.44192], [-123.38475, 39.44172], [-123.38457, 39.4416], [-123.38464, 39.44139], [-123.38474, 39.44121], [-123.38494, 39.44057], [-123.38515, 39.44025], [-123.38521, 39.44002], [-123.38521, 39.4397], [-123.38511, 39.43937], [-123.38498, 39.43905], [-123.3848, 39.43878], [-123.38465, 39.43848], [-123.3844, 39.43812], [-123.38446, 39.43793], [-123.38447, 39.43772], [-123.3842, 39.43699], [-123.38417, 39.43681], [-123.38423, 39.43652], [-123.3843, 39.43642], [-123.38476, 39.43627], [-123.38491, 39.43654], [-123.38532, 39.43638], [-123.38541, 39.43641], [-123.38569, 39.43623], [-123.38586, 39.43656], [-123.3856, 39.43665], [-123.38568, 39.43687], [-123.38579, 39.43705], [-123.38617, 39.43738], [-123.38637, 39.4375], [-123.3867, 39.43775], [-123.38694, 39.43788], [-123.38732, 39.43814], [-123.3875, 39.43829], [-123.38772, 39.43839], [-123.38824, 39.43852], [-123.38922, 39.4385]]]} Restricted Access 2 Brooktrails Disc Golf Course   33223 2208 Brooktrails Community Services District 418 Special District 4 Community Services District 17 http://www.btcsd.org/ Special District 4 47.226 Brooktrails Disc GC  

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