units_with_maps

Table actions

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

1 row where COUNTY = 13, DES_TP = 486 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 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
6008 6008 6007 {"type": "Polygon", "coordinates": [[[-122.50745, 37.73032], [-122.5071, 37.73036], [-122.50732, 37.73155], [-122.50744, 37.73229], [-122.50743, 37.73279], [-122.50736, 37.73318], [-122.50715, 37.73403], [-122.50703, 37.7347], [-122.50704, 37.73498], [-122.50708, 37.73521], [-122.50703, 37.73523], [-122.50707, 37.73557], [-122.50664, 37.73558], [-122.5066, 37.73547], [-122.50653, 37.73539], [-122.50643, 37.73533], [-122.50628, 37.73529], [-122.50264, 37.73529], [-122.50207, 37.73524], [-122.50147, 37.73513], [-122.50101, 37.735], [-122.50063, 37.73486], [-122.50018, 37.73464], [-122.4993, 37.73417], [-122.49883, 37.73398], [-122.49856, 37.7339], [-122.49871, 37.73357], [-122.49863, 37.73354], [-122.49843, 37.73352], [-122.4957, 37.73364], [-122.49598, 37.73359], [-122.49621, 37.73354], [-122.4966, 37.7334], [-122.49693, 37.73322], [-122.49728, 37.73296], [-122.49764, 37.73261], [-122.49783, 37.73236], [-122.49793, 37.73217], [-122.49798, 37.732], [-122.49802, 37.73182], [-122.49803, 37.73164], [-122.49821, 37.73172], [-122.49842, 37.73176], [-122.49862, 37.73174], [-122.49892, 37.73175], [-122.49921, 37.7317], [-122.49936, 37.73166], [-122.50244, 37.73044], [-122.50267, 37.73042], [-122.50296, 37.73046], [-122.50294, 37.73026], [-122.50272, 37.73005], [-122.50255, 37.72988], [-122.50239, 37.72965], [-122.50227, 37.72945], [-122.50216, 37.72921], [-122.5021, 37.72904], [-122.50205, 37.72882], [-122.50203, 37.72861], [-122.50203, 37.7283], [-122.50207, 37.72807], [-122.50273, 37.72648], [-122.50721, 37.72649], [-122.50734, 37.72869], [-122.50745, 37.73032]], [[-122.50303, 37.72841], [-122.50406, 37.72865], [-122.50462, 37.72724], [-122.50277, 37.72696], [-122.50238, 37.728], [-122.5023, 37.72831], [-122.50228, 37.72851], [-122.50229, 37.72874], [-122.50232, 37.72897], [-122.50238, 37.72919], [-122.50294, 37.72922], [-122.50303, 37.72841]]]} Open Access 1 678 SF Zoological Gardens 25332 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 134.384 SF Zoological Gardens   None 486  

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