units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 2, AGNCY_TYP = 19 and MNG_AG_TYP = 17

This data as json, copyable, CSV (advanced)

Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_WEB, LABEL_NAME

MNG_AG_TYP 1

  • Community Services District · 4 ✖

ACCESS_TYP 1

  • Restricted Access · 4 ✖
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
3586 3586 3585 {"type": "Polygon", "coordinates": [[[-120.11203, 39.33019], [-120.08116, 39.33018], [-120.08102, 39.32357], [-120.08615, 39.32375], [-120.08611, 39.31645], [-120.10961, 39.31639], [-120.10962, 39.32423], [-120.10845, 39.3243], [-120.10845, 39.32716], [-120.11194, 39.32719], [-120.11203, 39.33019]]]} Restricted Access 2 37007 Waddle Ranch 27205 2329 Truckee Tahoe Airport District 663 Special District 4 Community Services District 19 http://www.truckeetahoeairport.com/ Special District 4 2329 Truckee Tahoe Airport District 651 Special District 4 Community Services District 17   Nevada 30 851.88 Waddle Ranch 0 Local Other or Unknown 14 4
7381 7381 7380 {"type": "Polygon", "coordinates": [[[-124.07921, 40.91543], [-124.07916, 40.91219], [-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]]]} Restricted Access 2 47595 Riverfront Park 31322 2238 McKinleyville Community Services District 624 Special District 4 Community Services District 19 http://mckinleyvillecsd.com/ Special District 4 2238 McKinleyville Community Services District 613 Special District 4 Community Services District 17   Humboldt 45 36.389 Riverfront Park 0 Local Park 2 4
14007 14007 14006 {"type": "Polygon", "coordinates": [[[-120.11431, 39.3076], [-120.11095, 39.30757], [-120.11095, 39.30942], [-120.11204, 39.30942], [-120.11192, 39.31386], [-120.10961, 39.3139], [-120.10961, 39.31638], [-120.08611, 39.31645], [-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 37008 Waddle Ranch 27205 2329 Truckee Tahoe Airport District 663 Special District 4 Community Services District 19 http://www.truckeetahoeairport.com/ Special District 4 2329 Truckee Tahoe Airport District 651 Special District 4 Community Services District 17   Placer 35 609.442 Waddle Ranch 0 Local Other or Unknown 14 4
15682 15682 15681 {"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.3877, 39.44026], [-123.38802, 39.44001], [-123.38807, 39.44006], [-123.38775, 39.44032], [-123.38797, 39.44061], [-123.38759, 39.44096], [-123.38761, 39.44128], [-123.388, 39.44131], [-123.38802, 39.44139], [-123.38764, 39.44141], [-123.38763, 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.38818, 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.44232], [-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.38514, 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.43655], [-123.38532, 39.43638], [-123.3854, 39.43642], [-123.38569, 39.43623], [-123.38586, 39.43656], [-123.3856, 39.43664], [-123.38568, 39.43687], [-123.38579, 39.43704], [-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.38771, 39.43839], [-123.38824, 39.43852], [-123.38922, 39.4385]]]} Restricted Access 2 48511 Brooktrails Disc Golf Course 33223 2208 Brooktrails Community Services District 424 Special District 4 Community Services District 19 http://www.btcsd.org/ Special District 4 2208 Brooktrails Community Services District 418 Special District 4 Community Services District 17   Mendocino 24 47.2 Brooktrails Disc GC 0 Local Recreation Area 3 4

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