units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 2, COUNTY = 2 and DES_TP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Park · 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
7199 7199 7198 {"type": "Polygon", "coordinates": [[[-120.97533, 37.62623], [-120.97481, 37.62623], [-120.97482, 37.62608], [-120.97533, 37.62607], [-120.97533, 37.62623]]]} Restricted Access 2 34894 Legion Park 21143 1208 Modesto, City of 517 City 2 City Agency 2 http://www.modestogov.com/prnd/ City 2 1208 Modesto, City of 510 City 2 City Agency 2   Stanislaus 2 0.197 Legion Park 0 Local Park 2 4
13046 13046 13045 {"type": "Polygon", "coordinates": [[[-120.97835, 37.62482], [-120.97835, 37.6252], [-120.97609, 37.62409], [-120.9755, 37.62372], [-120.97562, 37.62339], [-120.97585, 37.62358], [-120.97681, 37.62388], [-120.97819, 37.62474], [-120.97835, 37.62482]]]} Restricted Access 2 34895 Mancini Park 21733 1208 Modesto, City of 517 City 2 City Agency 2 http://www.modestogov.com/prnd/ City 2 1208 Modesto, City of 510 City 2 City Agency 2   Stanislaus 2 3.106 Mancini Park 0 Local Park 2 4
16267 16267 16266 {"type": "MultiPolygon", "coordinates": [[[[-120.96798, 37.62431], [-120.9679, 37.62465], [-120.96772, 37.62462], [-120.9678, 37.62428], [-120.96798, 37.62431]]], [[[-120.96854, 37.6244], [-120.96834, 37.62437], [-120.96827, 37.6247], [-120.96809, 37.62467], [-120.96817, 37.62428], [-120.96853, 37.62433], [-120.96854, 37.6244]]], [[[-120.97082, 37.62484], [-120.97024, 37.62472], [-120.97023, 37.62482], [-120.96997, 37.62477], [-120.9698, 37.62476], [-120.96964, 37.62479], [-120.96944, 37.62487], [-120.96906, 37.62491], [-120.96905, 37.62476], [-120.96863, 37.62475], [-120.96864, 37.62414], [-120.9675, 37.62391], [-120.96745, 37.62417], [-120.96763, 37.6242], [-120.96754, 37.6246], [-120.96736, 37.62457], [-120.96744, 37.62418], [-120.96708, 37.62412], [-120.96672, 37.62408], [-120.96663, 37.62447], [-120.96632, 37.62442], [-120.96629, 37.6244], [-120.96626, 37.62432], [-120.96624, 37.6242], [-120.96623, 37.62277], [-120.96846, 37.62263], [-120.96924, 37.62277], [-120.97081, 37.62292], [-120.97082, 37.62484]]]]} Restricted Access 2 34896 Tuolumne River Regional Park 6748 1208 Modesto, City of 517 City 2 City Agency 2 http://www.modestogov.com/prnd/ City 2 1208 Modesto, City of 510 City 2 City Agency 2   Stanislaus 2 19.414 Tuolumne River RP 0 Local Park 2 4
16368 16368 16367 {"type": "MultiPolygon", "coordinates": [[[[-120.96864, 37.62414], [-120.96864, 37.62434], [-120.96817, 37.62428], [-120.96808, 37.62467], [-120.9679, 37.62465], [-120.96799, 37.62426], [-120.96782, 37.62423], [-120.96772, 37.62462], [-120.96754, 37.6246], [-120.96762, 37.62421], [-120.96745, 37.62418], [-120.96736, 37.62457], [-120.96663, 37.62447], [-120.96672, 37.62407], [-120.9669, 37.6241], [-120.96689, 37.62415], [-120.96706, 37.62418], [-120.96708, 37.62412], [-120.96744, 37.62417], [-120.96749, 37.62391], [-120.96864, 37.62414]]], [[[-120.96854, 37.62474], [-120.96827, 37.6247], [-120.96834, 37.62437], [-120.96854, 37.6244], [-120.96854, 37.62474]]], [[[-120.9746, 37.62611], [-120.97324, 37.62554], [-120.97195, 37.62512], [-120.97082, 37.62484], [-120.97081, 37.62292], [-120.97343, 37.62388], [-120.97378, 37.62412], [-120.97459, 37.62461], [-120.9746, 37.62611]]]]} Restricted Access 2 34897 Tuolumne River Regional Park 6748 1208 Modesto, City of 517 City 2 City Agency 2 http://www.modestogov.com/prnd/ City 2 1208 Modesto, City of 510 City 2 City Agency 2   Stanislaus 2 17.831 Tuolumne River RP 0 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]);