units_with_maps

Table actions

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

5 rows where ACCESS_TYP = 2, MNG_AGENCY = 147 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 5 ✖

MNG_AGENCY 1

  • Vacaville, City of · 5 ✖

ACCESS_TYP 1

  • Restricted Access · 5 ✖
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
3546 3546 3545 {"type": "Polygon", "coordinates": [[[-121.94776, 38.35645], [-121.94605, 38.35706], [-121.94576, 38.3565], [-121.94534, 38.35665], [-121.94491, 38.35597], [-121.94666, 38.35525], [-121.94676, 38.35524], [-121.94734, 38.35568], [-121.94757, 38.3557], [-121.94774, 38.35584], [-121.94776, 38.35645]]]} Restricted Access 2 28309 Cooper School Park 31609 1364 Vacaville, City of 151 City 2 City Agency 2 http://www.cityofvacaville.com/index.aspx?page=374 City 2 1364 Vacaville, City of 147 City 2 City Agency 2   Solano 26 7.337 Cooper School Park 0 Local Park 2 4
12476 12476 12475 {"type": "Polygon", "coordinates": [[[-122.00372, 38.35245], [-122.00296, 38.35252], [-122.00294, 38.3523], [-122.00275, 38.35231], [-122.00272, 38.35216], [-122.00244, 38.35216], [-122.00227, 38.35204], [-122.00224, 38.35177], [-122.00199, 38.35177], [-122.00197, 38.35154], [-122.00179, 38.35153], [-122.00176, 38.35144], [-122.00151, 38.35143], [-122.00148, 38.35103], [-122.0019, 38.35074], [-122.00199, 38.35076], [-122.00224, 38.35092], [-122.00243, 38.35107], [-122.00248, 38.35121], [-122.00263, 38.35141], [-122.00357, 38.35193], [-122.00365, 38.352], [-122.00372, 38.35245]]]} Restricted Access 2 28306 Alamo School Park 31601 1364 Vacaville, City of 151 City 2 City Agency 2 http://www.cityofvacaville.com/index.aspx?page=374 City 2 1364 Vacaville, City of 147 City 2 City Agency 2   Solano 26 4.025 Alamo School Park 0 Local Park 2 4
12494 12494 12493 {"type": "Polygon", "coordinates": [[[-121.95197, 38.33224], [-121.9516, 38.33235], [-121.95152, 38.33221], [-121.95135, 38.33224], [-121.95129, 38.33217], [-121.95113, 38.33221], [-121.95058, 38.3326], [-121.95066, 38.33278], [-121.95007, 38.33302], [-121.95032, 38.33339], [-121.94992, 38.33336], [-121.94998, 38.33173], [-121.9501, 38.33154], [-121.95021, 38.33142], [-121.95046, 38.33125], [-121.95048, 38.33103], [-121.95196, 38.331], [-121.95197, 38.33224]]]} Restricted Access 2 28307 Cambridge School Park 31605 1364 Vacaville, City of 151 City 2 City Agency 2 http://www.cityofvacaville.com/index.aspx?page=374 City 2 1364 Vacaville, City of 147 City 2 City Agency 2   Solano 26 6.902 Cambridge School Park 0 Local Park 2 4
12497 12497 12496 {"type": "Polygon", "coordinates": [[[-122.0039, 38.3646], [-122.00387, 38.36624], [-122.00154, 38.3662], [-122.00153, 38.36566], [-122.00163, 38.36566], [-122.00165, 38.36592], [-122.00216, 38.36593], [-122.00217, 38.36567], [-122.00267, 38.36566], [-122.00267, 38.36535], [-122.00318, 38.36535], [-122.00318, 38.36517], [-122.00274, 38.36462], [-122.00284, 38.36458], [-122.0039, 38.3646]]]} Restricted Access 2 28311 Hemlock School Park 31596 1364 Vacaville, City of 151 City 2 City Agency 2 http://www.cityofvacaville.com/index.aspx?page=374 City 2 1364 Vacaville, City of 147 City 2 City Agency 2   Solano 26 5.323 Hemlock School Park 0 Local Park 2 4
12858 12858 12857 {"type": "Polygon", "coordinates": [[[-122.03267, 38.31034], [-122.03263, 38.31122], [-122.03261, 38.31135], [-122.03212, 38.3133], [-122.02898, 38.31232], [-122.02885, 38.31231], [-122.02696, 38.31291], [-122.0254, 38.31237], [-122.02458, 38.31092], [-122.02115, 38.30989], [-122.0203, 38.30958], [-122.01987, 38.30887], [-122.01952, 38.30865], [-122.01898, 38.3085], [-122.01805, 38.30781], [-122.01789, 38.30725], [-122.0191, 38.30705], [-122.02055, 38.30706], [-122.02129, 38.30724], [-122.02334, 38.30805], [-122.02476, 38.30814], [-122.02476, 38.30826], [-122.02483, 38.30887], [-122.0281, 38.30887], [-122.02811, 38.30884], [-122.02937, 38.30929], [-122.02941, 38.30957], [-122.02961, 38.30975], [-122.02986, 38.30979], [-122.03025, 38.30968], [-122.0305, 38.30968], [-122.03063, 38.31002], [-122.03106, 38.31005], [-122.03113, 38.30985], [-122.03152, 38.31008], [-122.03182, 38.31012], [-122.03188, 38.3105], [-122.03204, 38.31066], [-122.03224, 38.31115], [-122.03235, 38.31105], [-122.03267, 38.31034]]]} Restricted Access 2 22288 Lagoon Valley Gateway Open Space 30789 1364 Vacaville, City of 151 City 2 City Agency 2 http://www.cityofvacaville.com/index.aspx?page=374 City 2 1364 Vacaville, City of 147 City 2 City Agency 2   Solano 26 96.658 Lagoon Valley Gateway OS 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]);