units_with_maps

Table actions

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

2 rows where AGNCY_LEV = 4, COUNTY = 26 and MNG_AG_TYP = 6

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Open Space District · 2 ✖

DES_TP 1

ACCESS_TYP 1

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
189 189 188 {"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 520 Sandy Beach Park 25025 2187 Solano Tri-City and County Cooperative Planning Group 74 Special District 4 Open Space District 6   Special District 4 2187 Solano Tri-City and County Cooperative Planning Group 72 Special District 4 Open Space District 6   Solano 26 36.239 Sandy Beach Park 0 Local Park 2 4
10018 10018 10017 {"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.03367, 38.49607], [-122.03339, 38.49582], [-122.03212, 38.49502], [-122.03074, 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.49029], [-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.49738], [-122.03708, 38.49793], [-122.03765, 38.49876]]]} Open Access 1 17260 Lake Solano County Park 20965 2187 Solano Tri-City and County Cooperative Planning Group 74 Special District 4 Open Space District 6   Special District 4 2187 Solano Tri-City and County Cooperative Planning Group 72 Special District 4 Open Space District 6   Solano 26 90.663 Lake Solano County Park 2000 Local Park 2 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]);