units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1, AGNCY_NAME = 737 and MNG_AG_TYP = 18

This data as json, copyable, CSV (advanced)

DES_TP 2

MNG_AG_TYP 1

  • Commercial · 2 ✖

MNG_AGENCY 1

ACCESS_TYP 1

  • Open Access · 2 ✖
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
4238 4238 4237 {"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 47889 Mission Bay Commons 31834 1719 San Francisco - Office of Community Investment and Infrastructure, City and County of 737 City 2 City Agency 2 https://sfocii.org/ City 2 6121 MJM Management Group 721 Private 7 Commercial 18 https://missionbayparks.com/mission-bay-commons/ San Francisco 13 2.353 Mission Bay Commons   None 369  
9772 9772 9771 {"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.39481, 37.77378], [-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.39526, 37.77343], [-122.39526, 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.77171], [-122.39736, 37.77177], [-122.39722, 37.77165], [-122.3985, 37.77064], [-122.39833, 37.77], [-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 47888 Mission Creek Park 31833 1719 San Francisco - Office of Community Investment and Infrastructure, City and County of 737 City 2 City Agency 2 https://sfocii.org/ City 2 6121 MJM Management Group 721 Private 7 Commercial 18 https://missionbayparks.com/mission-creek-park/ San Francisco 13 12.578 Mission Creek Park   None 845  

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