superunits_with_maps

Table actions

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

2 rows where MNG_AGENCY = 721 and MNG_AG_TYP = 18

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Commercial · 2 ✖

MNG_AGENCY 1

  • MJM Management Group · 2 ✖

ACCESS_TYP 1

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
140 140 139 {"type": "MultiPolygon", "coordinates": [[[[-122.39652, 37.77142], [-122.39227, 37.77478], [-122.39203, 37.77458], [-122.39628, 37.77123], [-122.39652, 37.77142]]], [[[-122.39537, 37.77404], [-122.39525, 37.77413], [-122.3948, 37.77379], [-122.39299, 37.77522], [-122.39294, 37.77518], [-122.39286, 37.77525], [-122.39276, 37.77517], [-122.39479, 37.77357], [-122.39537, 37.77404]]], [[[-122.39716, 37.77193], [-122.39527, 37.77342], [-122.39527, 37.77344], [-122.3957, 37.77379], [-122.39558, 37.77388], [-122.39499, 37.77341], [-122.39701, 37.77181], [-122.39716, 37.77193]]], [[[-122.39942, 37.77078], [-122.39941, 37.77085], [-122.39774, 37.77216], [-122.39759, 37.77195], [-122.39745, 37.77172], [-122.39736, 37.77177], [-122.39722, 37.77165], [-122.3985, 37.77064], [-122.39833, 37.77001], [-122.39673, 37.77126], [-122.39648, 37.77107], [-122.39809, 37.7698], [-122.39821, 37.76989], [-122.39852, 37.76986], [-122.3991, 37.77033], [-122.39914, 37.77056], [-122.39942, 37.77078]]]]} Open Access 1 Mission Creek Park https://missionbayparks.com/mission-creek-park/ 31833 6121 MJM Management Group 721 Private 7 Commercial 18 https://mjmmg.com/ Private 14 12.608 Mission Creek Park  
141 141 140 {"type": "Polygon", "coordinates": [[[-122.38933, 37.7711], [-122.38673, 37.77126], [-122.38667, 37.77089], [-122.38929, 37.77073], [-122.38933, 37.7711]]]} Open Access 1 Mission Bay Commons https://missionbayparks.com/mission-bay-commons/ 31834 6121 MJM Management Group 721 Private 7 Commercial 18 https://mjmmg.com/ Private 14 2.353 Mission Bay Commons  

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