superunits_with_maps

Table actions

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

5 rows where ACCESS_TYP = 2, MNG_AG_ID = 1364 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 5 ✖

MNG_AGENCY 1

ACCESS_TYP 1

  • Restricted Access · 5 ✖
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
13409 13409 13408 {"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.02484, 38.30887], [-122.02809, 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.03236, 38.31105], [-122.03267, 38.31034]]]} Restricted Access 2 Lagoon Valley Gateway Open Space   30789 1364 Vacaville, City of 147 City 2 City Agency 2 http://www.cityofvacaville.com/index.aspx?page=374 City 2 96.678 Lagoon Valley Gateway OS  
13993 13993 13992 {"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.00215, 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 Hemlock School Park   31596 1364 Vacaville, City of 147 City 2 City Agency 2 http://www.cityofvacaville.com/index.aspx?page=374 City 2 5.333 Hemlock School Park  
14144 14144 14143 {"type": "Polygon", "coordinates": [[[-122.00372, 38.35245], [-122.00296, 38.35252], [-122.00294, 38.35231], [-122.00275, 38.35231], [-122.00272, 38.35216], [-122.00244, 38.35216], [-122.00227, 38.35204], [-122.00224, 38.35178], [-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 Alamo School Park   31601 1364 Vacaville, City of 147 City 2 City Agency 2 http://www.cityofvacaville.com/index.aspx?page=374 City 2 4.031 Alamo School Park  
14147 14147 14146 {"type": "Polygon", "coordinates": [[[-121.95197, 38.33224], [-121.9516, 38.33235], [-121.95152, 38.33221], [-121.95135, 38.33224], [-121.95128, 38.33217], [-121.95113, 38.33221], [-121.95058, 38.3326], [-121.95066, 38.33278], [-121.95008, 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 Cambridge School Park   31605 1364 Vacaville, City of 147 City 2 City Agency 2 http://www.cityofvacaville.com/index.aspx?page=374 City 2 6.91 Cambridge School Park  
14150 14150 14149 {"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 Cooper School Park   31609 1364 Vacaville, City of 147 City 2 City Agency 2 http://www.cityofvacaville.com/index.aspx?page=374 City 2 7.339 Cooper School 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]);