units_with_maps

Table actions

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

1 row where COUNTY = 23, DES_TP = 809 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
9599 9599 9598 {"type": "Polygon", "coordinates": [[[-122.54086, 37.96428], [-122.54084, 37.96441], [-122.54076, 37.9645], [-122.54063, 37.96455], [-122.54049, 37.96454], [-122.54041, 37.96451], [-122.54035, 37.96445], [-122.54023, 37.96419], [-122.54019, 37.96415], [-122.53958, 37.96402], [-122.53946, 37.96397], [-122.53933, 37.96386], [-122.53929, 37.96384], [-122.53924, 37.96385], [-122.53899, 37.96396], [-122.53888, 37.96396], [-122.53877, 37.96393], [-122.53866, 37.96385], [-122.53857, 37.96357], [-122.53852, 37.96356], [-122.5384, 37.96381], [-122.53814, 37.96417], [-122.53823, 37.96426], [-122.53824, 37.96431], [-122.53823, 37.96436], [-122.53817, 37.96442], [-122.53816, 37.96447], [-122.53795, 37.96446], [-122.53791, 37.96475], [-122.53739, 37.96471], [-122.53737, 37.96483], [-122.53569, 37.96466], [-122.53572, 37.96437], [-122.53483, 37.9643], [-122.53485, 37.96415], [-122.53481, 37.96414], [-122.53476, 37.9638], [-122.53479, 37.96365], [-122.5348, 37.96354], [-122.53441, 37.9635], [-122.5344, 37.96353], [-122.53421, 37.96351], [-122.53355, 37.96379], [-122.53354, 37.96377], [-122.53401, 37.96356], [-122.53385, 37.96338], [-122.53347, 37.9636], [-122.53321, 37.96313], [-122.53324, 37.96284], [-122.53359, 37.96264], [-122.53441, 37.9625], [-122.53436, 37.96174], [-122.53464, 37.96135], [-122.53567, 37.96184], [-122.53606, 37.96235], [-122.53575, 37.96253], [-122.53575, 37.96254], [-122.53643, 37.96294], [-122.53768, 37.9629], [-122.538, 37.96324], [-122.53865, 37.96335], [-122.53894, 37.96353], [-122.53925, 37.96358], [-122.53927, 37.9636], [-122.53944, 37.96334], [-122.53955, 37.96345], [-122.53936, 37.96371], [-122.5395, 37.96382], [-122.5396, 37.96387], [-122.54019, 37.96399], [-122.54026, 37.96402], [-122.54035, 37.9641], [-122.54045, 37.96434], [-122.5405, 37.96438], [-122.54058, 37.96439], [-122.54065, 37.96436], [-122.5407, 37.9642], [-122.54086, 37.96428]]]} Open Access 1 16144 San Rafael Lands 001 24972 1312 San Rafael, City of 352 City 2 City Agency 2 http://www.cityofsanrafael.org/comsvcs-home/ City 2 1312 San Rafael, City of 349 City 2 City Agency 2   Marin 23 23.459 San Rafael Lands 001   None 809  

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