superunits_with_maps

Table actions

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

2 rows where MNG_AGENCY = 72, MNG_AG_LEV = 4 and MNG_AG_TYP = 6

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Open Space District · 2 ✖

MNG_AGENCY 1

  • Solano Tri-City and County Cooperative Planning Group · 2 ✖

ACCESS_TYP 1

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
5952 5952 5951 {"type": "Polygon", "coordinates": [[[-122.03765, 38.49876], [-122.03721, 38.49835], [-122.03564, 38.49724], [-122.03484, 38.49684], [-122.03469, 38.4967], [-122.03412, 38.4963], [-122.03368, 38.49607], [-122.03339, 38.49582], [-122.03212, 38.49502], [-122.03075, 38.49442], [-122.03003, 38.49422], [-122.02894, 38.49368], [-122.02811, 38.4932], [-122.02771, 38.493], [-122.02722, 38.49292], [-122.02461, 38.49263], [-122.02426, 38.49248], [-122.02391, 38.49215], [-122.02324, 38.49176], [-122.02279, 38.4914], [-122.02207, 38.49109], [-122.02168, 38.49098], [-122.02141, 38.49063], [-122.02107, 38.49048], [-122.02081, 38.49028], [-122.02032, 38.48997], [-122.02062, 38.48927], [-122.02073, 38.48883], [-122.02125, 38.48913], [-122.02143, 38.48916], [-122.02174, 38.48929], [-122.02201, 38.48943], [-122.02279, 38.48968], [-122.02314, 38.48984], [-122.02384, 38.49003], [-122.02431, 38.49022], [-122.02482, 38.49053], [-122.02565, 38.49095], [-122.02623, 38.49028], [-122.02608, 38.48995], [-122.02557, 38.48914], [-122.0262, 38.4891], [-122.02719, 38.48912], [-122.0285, 38.48911], [-122.0294, 38.48918], [-122.03036, 38.48919], [-122.03016, 38.48966], [-122.03006, 38.49023], [-122.02969, 38.49069], [-122.02974, 38.49095], [-122.02965, 38.49127], [-122.03049, 38.49266], [-122.03086, 38.49287], [-122.0312, 38.49324], [-122.03198, 38.49353], [-122.03288, 38.49373], [-122.03315, 38.49382], [-122.03415, 38.49464], [-122.03447, 38.49508], [-122.03474, 38.49528], [-122.0362, 38.49588], [-122.0364, 38.49603], [-122.03667, 38.49668], [-122.03679, 38.49718], [-122.03681, 38.49739], [-122.03708, 38.49793], [-122.03765, 38.49876]]]} Open Access 1 Lake Solano County Park   20965 2187 Solano Tri-City and County Cooperative Planning Group 72 Special District 4 Open Space District 6   Special District 4 90.677 Lake Solano County Park 2000
9273 9273 9272 {"type": "Polygon", "coordinates": [[[-121.69813, 38.13724], [-121.69797, 38.13757], [-121.69794, 38.13778], [-121.698, 38.138], [-121.698, 38.13839], [-121.69766, 38.13941], [-121.69748, 38.13979], [-121.69707, 38.14119], [-121.69655, 38.14207], [-121.69614, 38.14262], [-121.69612, 38.14317], [-121.69601, 38.14374], [-121.69455, 38.14262], [-121.69398, 38.1421], [-121.69404, 38.14198], [-121.69415, 38.14179], [-121.69439, 38.14132], [-121.69453, 38.14097], [-121.69475, 38.14037], [-121.69492, 38.14001], [-121.6952, 38.13921], [-121.6953, 38.13884], [-121.69555, 38.13824], [-121.69594, 38.13708], [-121.6961, 38.13642], [-121.69719, 38.1368], [-121.69813, 38.13724]]]} Open Access 1 Sandy Beach Park   25025 2187 Solano Tri-City and County Cooperative Planning Group 72 Special District 4 Open Space District 6   Special District 4 36.239 Sandy Beach Park  

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