superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, ACRES = "3.306" and MNG_AGENCY = 930

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Johnson Ranch Community Association · 1 ✖

ACCESS_TYP 1

  • Restricted Access · 1 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
5191 5191 5190 {"type": "MultiPolygon", "coordinates": [[[[-121.21955, 38.73498], [-121.2194, 38.7353], [-121.21882, 38.73531], [-121.21882, 38.73514], [-121.21901, 38.73514], [-121.21914, 38.73509], [-121.21941, 38.73486], [-121.21955, 38.73498]]], [[[-121.2206, 38.73383], [-121.22027, 38.73401], [-121.22013, 38.73412], [-121.22002, 38.73428], [-121.21986, 38.73466], [-121.21978, 38.73477], [-121.21968, 38.73487], [-121.21964, 38.73488], [-121.21959, 38.73487], [-121.21943, 38.73473], [-121.21938, 38.73464], [-121.21933, 38.73452], [-121.21963, 38.73452], [-121.21963, 38.73438], [-121.21982, 38.73381], [-121.22002, 38.73385], [-121.22025, 38.73364], [-121.2205, 38.73372], [-121.2206, 38.73383]]], [[[-121.22304, 38.73648], [-121.22298, 38.73654], [-121.22293, 38.73655], [-121.22075, 38.73653], [-121.22075, 38.7364], [-121.22272, 38.73641], [-121.22292, 38.73608], [-121.22284, 38.73589], [-121.22272, 38.73569], [-121.22268, 38.73563], [-121.22259, 38.73565], [-121.22257, 38.73561], [-121.22266, 38.73558], [-121.22273, 38.7356], [-121.22283, 38.73575], [-121.22294, 38.73595], [-121.22301, 38.73616], [-121.22304, 38.73635], [-121.22304, 38.73648]]], [[[-121.2236, 38.73557], [-121.22359, 38.73642], [-121.22337, 38.73642], [-121.2233, 38.73636], [-121.22324, 38.73606], [-121.22313, 38.73577], [-121.2236, 38.73557]]]]} Restricted Access 2 HOA Park   20015 6064 Johnson Ranch Community Association 930 Private 7 Home Owners Association 15   Private 14 3.306 HOA Park  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);