units_with_maps

Table actions

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

1 row where AGNCY_NAME = 431, DES_TP = 814 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_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
9608 9608 9607 {"type": "MultiPolygon", "coordinates": [[[[-122.52079, 37.93171], [-122.52061, 37.93211], [-122.5206, 37.93211], [-122.52057, 37.93201], [-122.52054, 37.93195], [-122.52041, 37.93184], [-122.52019, 37.93177], [-122.52, 37.93177], [-122.51983, 37.93183], [-122.51972, 37.93193], [-122.51966, 37.93202], [-122.51956, 37.93234], [-122.51946, 37.93243], [-122.51866, 37.9325], [-122.51856, 37.93247], [-122.51851, 37.93239], [-122.51846, 37.93213], [-122.51848, 37.93206], [-122.51855, 37.93203], [-122.51874, 37.932], [-122.51896, 37.93191], [-122.51907, 37.93183], [-122.51914, 37.93175], [-122.51922, 37.93157], [-122.51923, 37.93143], [-122.51917, 37.93099], [-122.5192, 37.93066], [-122.51927, 37.93033], [-122.51925, 37.93019], [-122.51919, 37.93005], [-122.51911, 37.92995], [-122.51903, 37.92987], [-122.51877, 37.92972], [-122.51874, 37.92965], [-122.51875, 37.92961], [-122.51886, 37.92952], [-122.51898, 37.92939], [-122.51915, 37.92914], [-122.51925, 37.92895], [-122.51934, 37.92865], [-122.51936, 37.92863], [-122.51941, 37.92862], [-122.52015, 37.92866], [-122.52019, 37.92867], [-122.52022, 37.92871], [-122.52023, 37.92874], [-122.52011, 37.92908], [-122.51989, 37.9296], [-122.51985, 37.92971], [-122.51982, 37.92992], [-122.51984, 37.93013], [-122.51992, 37.93042], [-122.52038, 37.93129], [-122.52054, 37.9315], [-122.52079, 37.93171]]], [[[-122.52294, 37.93336], [-122.52292, 37.93325], [-122.5229, 37.93319], [-122.52286, 37.93313], [-122.5228, 37.93308], [-122.52261, 37.93301], [-122.52249, 37.933], [-122.52236, 37.93301], [-122.52218, 37.9331], [-122.52208, 37.93318], [-122.52203, 37.93326], [-122.52201, 37.93332], [-122.52201, 37.93341], [-122.52208, 37.93362], [-122.52207, 37.93367], [-122.52205, 37.93372], [-122.52198, 37.93377], [-122.52187, 37.93379], [-122.52175, 37.93378], [-122.52165, 37.93373], [-122.52161, 37.93368], [-122.52159, 37.93362], [-122.52155, 37.93312], [-122.52157, 37.93277], [-122.5216, 37.93259], [-122.52165, 37.93239], [-122.5217, 37.93231], [-122.52181, 37.93223], [-122.52193, 37.9322], [-122.52204, 37.9322], [-122.52216, 37.93223], [-122.52336, 37.9329], [-122.52351, 37.93301], [-122.52358, 37.93312], [-122.52362, 37.93333], [-122.52361, 37.93343], [-122.52353, 37.93354], [-122.52342, 37.93361], [-122.52319, 37.93365], [-122.52309, 37.93364], [-122.52298, 37.9336], [-122.52295, 37.93357], [-122.52293, 37.93352], [-122.52294, 37.93336]]]]} Open Access 1 16164 Madera Gardens Lagoons 21651 1070 Corte Madera, Town of 431 City 2 City Agency 2 http://www.ci.corte-madera.ca.us/199/Parks-Recreation City 2 1070 Corte Madera, Town of 425 City 2 City Agency 2   Marin 23 13.425 Madera Gardens Lagoons   None 814  

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