superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 2, LAYER = 3 and MNG_AGENCY = 8

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Luis Obispo, County of · 2 ✖

ACCESS_TYP 1

  • Restricted Access · 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
7711 7711 7710 {"type": "Polygon", "coordinates": [[[-120.74154, 35.3331], [-120.73974, 35.33628], [-120.73643, 35.3387], [-120.73575, 35.33844], [-120.73517, 35.33868], [-120.73284, 35.3378], [-120.72967, 35.33978], [-120.72435, 35.34033], [-120.72421, 35.34083], [-120.72439, 35.34154], [-120.72495, 35.34214], [-120.72174, 35.3459], [-120.71513, 35.35322], [-120.71224, 35.35091], [-120.72459, 35.32556], [-120.72558, 35.3253], [-120.72633, 35.32599], [-120.72988, 35.32905], [-120.73035, 35.3294], [-120.73084, 35.32971], [-120.73136, 35.33], [-120.73191, 35.33026], [-120.73247, 35.33048], [-120.73305, 35.33067], [-120.73498, 35.33122], [-120.7373, 35.33191], [-120.73941, 35.33243], [-120.74154, 35.3331]]]} Restricted Access 2 El Chorro Regional Park and Dairy Creek Golf Course   33039 323 San Luis Obispo, County of 8 County 3 County Agency 3 http://www.slocountyparks.com/ County 3 684.14 El Chorro RP and Dairy Creek GC  
15345 15345 15344 {"type": "MultiPolygon", "coordinates": [[[[-120.6486, 35.47827], [-120.64691, 35.47993], [-120.64474, 35.48211], [-120.64314, 35.47842], [-120.64254, 35.47751], [-120.64174, 35.47671], [-120.64078, 35.47603], [-120.6397, 35.47552], [-120.63961, 35.47559], [-120.63571, 35.47391], [-120.63519, 35.47363], [-120.63473, 35.47327], [-120.63438, 35.47285], [-120.63412, 35.47237], [-120.64037, 35.46871], [-120.6405, 35.46878], [-120.64087, 35.4689], [-120.6417, 35.46914], [-120.64319, 35.46938], [-120.64348, 35.4694], [-120.64491, 35.46934], [-120.64506, 35.46931], [-120.64513, 35.47088], [-120.64566, 35.47188], [-120.64588, 35.47364], [-120.6459, 35.47365], [-120.647, 35.47288], [-120.64704, 35.47299], [-120.64715, 35.47313], [-120.64723, 35.47319], [-120.64742, 35.47326], [-120.64749, 35.47332], [-120.64761, 35.47347], [-120.64684, 35.47375], [-120.64621, 35.47385], [-120.64521, 35.47416], [-120.64492, 35.47415], [-120.64491, 35.47417], [-120.64525, 35.47453], [-120.6486, 35.47827]]], [[[-120.64709, 35.47263], [-120.64603, 35.47336], [-120.64582, 35.47184], [-120.64531, 35.47085], [-120.64525, 35.46978], [-120.64704, 35.46978], [-120.64709, 35.47263]]], [[[-120.64864, 35.47105], [-120.64865, 35.47288], [-120.64863, 35.47292], [-120.64856, 35.47299], [-120.64843, 35.47307], [-120.64824, 35.47314], [-120.64786, 35.47317], [-120.64769, 35.4732], [-120.6475, 35.47317], [-120.64741, 35.47312], [-120.64725, 35.473], [-120.6472, 35.47292], [-120.64718, 35.47285], [-120.64718, 35.47278], [-120.6472, 35.47274], [-120.64727, 35.47267], [-120.64718, 35.47257], [-120.64713, 35.47259], [-120.64711, 35.47107], [-120.64864, 35.47105]]]]} Restricted Access 2 Chalk Mountain Golf Course   33050 323 San Luis Obispo, County of 8 County 3 County Agency 3 http://www.slocountyparks.com/ County 3 227.708 Chalk Mtn. 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]);