units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 2, DES_TP = 2 and MNG_AGENCY = 147

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Vacaville, City of · 4 ✖

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
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

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