units_with_maps

Table actions

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

1 row where ACRES = "21.314", MNG_AGENCY = 21 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

  • San Francisco, City and County of · 1 ✖

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
6880 6880 6879 {"type": "MultiPolygon", "coordinates": [[[[-122.44736, 37.75022], [-122.44723, 37.75056], [-122.44717, 37.75089], [-122.44689, 37.7512], [-122.44672, 37.75149], [-122.44662, 37.75147], [-122.44705, 37.75049], [-122.44687, 37.75043], [-122.44689, 37.75038], [-122.44675, 37.75021], [-122.44662, 37.75022], [-122.44534, 37.7493], [-122.44542, 37.74921], [-122.44552, 37.74932], [-122.44563, 37.74942], [-122.44674, 37.75004], [-122.44699, 37.75014], [-122.44736, 37.75022]]], [[[-122.44813, 37.74837], [-122.44807, 37.74864], [-122.44798, 37.74863], [-122.44804, 37.74853], [-122.44813, 37.74837]]], [[[-122.44996, 37.75106], [-122.44994, 37.75108], [-122.44977, 37.75112], [-122.44966, 37.75095], [-122.44996, 37.75095], [-122.44996, 37.75106]]], [[[-122.4502, 37.74979], [-122.45002, 37.75052], [-122.44997, 37.75081], [-122.44974, 37.75081], [-122.45001, 37.7503], [-122.44998, 37.74979], [-122.4502, 37.74979]]], [[[-122.45601, 37.75981], [-122.45564, 37.76031], [-122.45562, 37.7603], [-122.45519, 37.76058], [-122.45509, 37.76058], [-122.45508, 37.76067], [-122.4538, 37.76173], [-122.45355, 37.76154], [-122.45349, 37.76158], [-122.45248, 37.7614], [-122.45245, 37.76128], [-122.45205, 37.76133], [-122.45203, 37.76127], [-122.45244, 37.76121], [-122.45227, 37.76034], [-122.45201, 37.76037], [-122.45201, 37.7588], [-122.45288, 37.75881], [-122.45288, 37.75995], [-122.45309, 37.7601], [-122.45415, 37.76012], [-122.45483, 37.75976], [-122.4559, 37.75978], [-122.45601, 37.75981]]], [[[-122.45331, 37.75675], [-122.45338, 37.75678], [-122.45348, 37.7569], [-122.45353, 37.757], [-122.45357, 37.75711], [-122.45358, 37.75721], [-122.45356, 37.75733], [-122.45353, 37.75742], [-122.45347, 37.75752], [-122.45326, 37.75768], [-122.45278, 37.75797], [-122.45229, 37.75819], [-122.45206, 37.75825], [-122.45203, 37.75696], [-122.45206, 37.75696], [-122.45213, 37.75704], [-122.45223, 37.7571], [-122.45234, 37.75712], [-122.45244, 37.75712], [-122.45256, 37.75708], [-122.45317, 37.75676], [-122.45324, 37.75674], [-122.45331, 37.75675]]], [[[-122.45251, 37.75697], [-122.45245, 37.75699], [-122.45239, 37.757], [-122.45227, 37.75696], [-122.45251, 37.75697]]], [[[-122.45531, 37.75382], [-122.45511, 37.75413], [-122.45502, 37.75433], [-122.45497, 37.75454], [-122.45492, 37.75493], [-122.45486, 37.75509], [-122.45462, 37.75553], [-122.45417, 37.75615], [-122.45407, 37.75633], [-122.45399, 37.75658], [-122.45394, 37.75697], [-122.45389, 37.7571], [-122.45381, 37.75722], [-122.45377, 37.75705], [-122.45367, 37.75685], [-122.45356, 37.75673], [-122.45342, 37.75666], [-122.45326, 37.75663], [-122.45314, 37.75664], [-122.45272, 37.75685], [-122.45271, 37.75669], [-122.45302, 37.75653], [-122.45319, 37.7565], [-122.45336, 37.7565], [-122.45354, 37.75655], [-122.45369, 37.75663], [-122.45382, 37.75677], [-122.45383, 37.75677], [-122.45388, 37.75651], [-122.454, 37.75622], [-122.45445, 37.75552], [-122.45471, 37.75502], [-122.45478, 37.75478], [-122.45482, 37.75436], [-122.45491, 37.75413], [-122.45514, 37.75376], [-122.45529, 37.75379], [-122.45531, 37.75382]]], [[[-122.45565, 37.75336], [-122.45545, 37.75366], [-122.45542, 37.75366], [-122.45525, 37.75363], [-122.45547, 37.75332], [-122.45565, 37.75336]]], [[[-122.45981, 37.75986], [-122.45974, 37.76001], [-122.45953, 37.76007], [-122.45919, 37.76008], [-122.45907, 37.76011], [-122.45901, 37.7602], [-122.45901, 37.76032], [-122.45909, 37.76051], [-122.4591, 37.76063], [-122.45905, 37.76086], [-122.45899, 37.76093], [-122.45888, 37.76096], [-122.45877, 37.76095], [-122.45869, 37.7609], [-122.45865, 37.76081], [-122.45865, 37.76076], [-122.45869, 37.7607], [-122.45879, 37.76064], [-122.45892, 37.76063], [-122.45897, 37.76059], [-122.45897, 37.76055], [-122.45887, 37.76033], [-122.45887, 37.76018], [-122.45898, 37.76002], [-122.45916, 37.75997], [-122.4595, 37.75996], [-122.45963, 37.75992], [-122.45967, 37.75985], [-122.45962, 37.7597], [-122.45934, 37.75907], [-122.4595, 37.75911], [-122.45975, 37.75966], [-122.45981, 37.75986]]]]} Open Access 1 5595 Interior Green Belt 20223 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 1300 San Francisco, City and County of 21 City 2 City Agency 2   San Francisco 13 21.314 Interior Green Belt   None 560  

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