units_with_maps

Table actions

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

2 rows where LAYER = 2, MNG_AG_TYP = 14 and YR_EST = 0

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Port/Harbor 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
4142 4142 4141 {"type": "MultiPolygon", "coordinates": [[[[-117.09958, 32.61991], [-117.09934, 32.62003], [-117.09922, 32.62012], [-117.09913, 32.62021], [-117.09904, 32.62033], [-117.09865, 32.62097], [-117.09833, 32.6209], [-117.09808, 32.62086], [-117.09777, 32.62086], [-117.09743, 32.62088], [-117.09725, 32.62091], [-117.09534, 32.62143], [-117.09523, 32.62115], [-117.09736, 32.62055], [-117.09738, 32.62037], [-117.09771, 32.62036], [-117.09957, 32.61984], [-117.09958, 32.61991]]], [[[-117.10451, 32.62192], [-117.10429, 32.62215], [-117.10402, 32.62226], [-117.10363, 32.62235], [-117.10342, 32.62233], [-117.10315, 32.62218], [-117.10301, 32.62193], [-117.10293, 32.62169], [-117.10295, 32.62156], [-117.10304, 32.6215], [-117.10324, 32.62143], [-117.10323, 32.62102], [-117.10295, 32.62088], [-117.10267, 32.62019], [-117.10271, 32.62001], [-117.10253, 32.61958], [-117.10263, 32.6195], [-117.10258, 32.61947], [-117.10254, 32.61939], [-117.10248, 32.61934], [-117.10239, 32.61931], [-117.10229, 32.61931], [-117.10148, 32.61952], [-117.10104, 32.61954], [-117.10069, 32.6196], [-117.10052, 32.61958], [-117.10331, 32.61879], [-117.10433, 32.62109], [-117.10451, 32.62156], [-117.10451, 32.62192]]]]} Open Access 1 47479 Chula Vista Bayfront Park 31201 1056 Chula Vista, City of 120 City 2 City Agency 2 http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp City 2 2133 San Diego Unified Port District 182 Special District 4 Port/Harbor District 14 https://www.portofsandiego.org/chula-vista-bayfront-park.html San Diego 4 16.026 Chula Vista Bayfront Park 0 Local Park 2 4
6071 6071 6070 {"type": "Polygon", "coordinates": [[[-117.17247, 32.69894], [-117.17197, 32.69981], [-117.17153, 32.69964], [-117.17205, 32.69877], [-117.17247, 32.69894]]]} Open Access 1 809 Centennial Park 33718 1069 Coronado, City of 105 City 2 City Agency 2 http://www.coronado.ca.us/category/subcategory-rec.php City 2 2133 San Diego Unified Port District 182 Special District 4 Port/Harbor District 14 https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3814369 San Diego 4 1.186 Centennial 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]);