units_with_maps

Table actions

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

2 rows where LABEL_NAME = "Flood Control" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 2 ✖

MNG_AGENCY 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
3050 3050 3049 {"type": "MultiPolygon", "coordinates": [[[[-121.24452, 38.72086], [-121.24452, 38.72174], [-121.24392, 38.72198], [-121.24348, 38.72211], [-121.243, 38.72216], [-121.24087, 38.72215], [-121.24088, 38.72187], [-121.24142, 38.72131], [-121.24229, 38.72048], [-121.2424, 38.72035], [-121.24247, 38.72024], [-121.24255, 38.72001], [-121.24256, 38.71981], [-121.24243, 38.71901], [-121.24317, 38.71934], [-121.24452, 38.72086]]], [[[-121.24324, 38.72673], [-121.24287, 38.72694], [-121.24263, 38.72659], [-121.24242, 38.72641], [-121.24196, 38.72561], [-121.24212, 38.7254], [-121.24228, 38.7254], [-121.24235, 38.72544], [-121.24262, 38.72546], [-121.24261, 38.72582], [-121.24268, 38.72605], [-121.24282, 38.72626], [-121.24324, 38.72673]]], [[[-121.24705, 38.72776], [-121.24669, 38.72806], [-121.24614, 38.7276], [-121.24538, 38.7271], [-121.24461, 38.72713], [-121.24464, 38.72905], [-121.24408, 38.72926], [-121.24395, 38.72917], [-121.24386, 38.72913], [-121.24372, 38.7291], [-121.24358, 38.7291], [-121.24358, 38.72874], [-121.24324, 38.72824], [-121.24342, 38.72813], [-121.24353, 38.72797], [-121.24366, 38.72722], [-121.24366, 38.72705], [-121.24361, 38.7269], [-121.24353, 38.7268], [-121.2429, 38.72609], [-121.24281, 38.72588], [-121.2428, 38.7257], [-121.24283, 38.72526], [-121.24329, 38.72527], [-121.24334, 38.72506], [-121.2433, 38.72484], [-121.24337, 38.72448], [-121.24365, 38.72414], [-121.24385, 38.72389], [-121.24388, 38.72355], [-121.24381, 38.72292], [-121.24399, 38.72224], [-121.24462, 38.72224], [-121.24462, 38.72236], [-121.24444, 38.72249], [-121.24437, 38.72277], [-121.24432, 38.72287], [-121.2443, 38.72308], [-121.24453, 38.72352], [-121.24447, 38.72389], [-121.24432, 38.7242], [-121.24392, 38.72447], [-121.2439, 38.72451], [-121.24388, 38.72482], [-121.24387, 38.72589], [-121.24392, 38.72603], [-121.24398, 38.72612], [-121.2441, 38.72622], [-121.24423, 38.72622], [-121.24505, 38.72665], [-121.2456, 38.72668], [-121.2461, 38.72696], [-121.24705, 38.72776]]], [[[-121.24936, 38.72958], [-121.24879, 38.72974], [-121.24869, 38.72944], [-121.2471, 38.72837], [-121.24684, 38.72817], [-121.24721, 38.72788], [-121.24746, 38.72807], [-121.24913, 38.72919], [-121.24936, 38.72958]]]]} Open Access 1 20932 Flood Control 18952 1285 Roseville, City of 540 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 1285 Roseville, City of 533 City 2 City Agency 2   Placer 35 37.251 Flood Control 0 Local Other or Unknown 14 4
10918 10918 10917 {"type": "Polygon", "coordinates": [[[-121.28931, 38.73527], [-121.28926, 38.73535], [-121.28919, 38.73532], [-121.28927, 38.73501], [-121.28923, 38.73477], [-121.28889, 38.73486], [-121.28886, 38.73484], [-121.2892, 38.73473], [-121.28893, 38.73434], [-121.28848, 38.73416], [-121.28827, 38.73404], [-121.28811, 38.73391], [-121.28768, 38.73376], [-121.28769, 38.73373], [-121.28697, 38.73301], [-121.28696, 38.73287], [-121.28596, 38.73286], [-121.28595, 38.73305], [-121.28563, 38.73306], [-121.28482, 38.73357], [-121.2845, 38.73363], [-121.28378, 38.73346], [-121.28357, 38.73328], [-121.28339, 38.73323], [-121.28305, 38.73259], [-121.2832, 38.73219], [-121.2832, 38.73179], [-121.28349, 38.73159], [-121.28366, 38.73137], [-121.28382, 38.73123], [-121.28412, 38.73154], [-121.28378, 38.73159], [-121.28366, 38.73184], [-121.28366, 38.73285], [-121.28421, 38.7332], [-121.28441, 38.73322], [-121.28474, 38.73313], [-121.28474, 38.73306], [-121.28486, 38.73306], [-121.28508, 38.73292], [-121.28537, 38.73268], [-121.28574, 38.73246], [-121.28582, 38.73234], [-121.28596, 38.73234], [-121.28597, 38.73238], [-121.2864, 38.73239], [-121.28691, 38.73245], [-121.28733, 38.73266], [-121.28753, 38.73284], [-121.2878, 38.73301], [-121.28786, 38.73307], [-121.28825, 38.7333], [-121.28826, 38.73334], [-121.28844, 38.73337], [-121.28862, 38.73345], [-121.28884, 38.73347], [-121.28928, 38.73373], [-121.28931, 38.73527]]]} Open Access 1 20924 Flood Control 18952 1285 Roseville, City of 540 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 1285 Roseville, City of 533 City 2 City Agency 2   Placer 35 10.315 Flood Control 0 Local Other or Unknown 14 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]);