superunits_with_maps

Table actions

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

3 rows where ACCESS_TYP = 2 and MNG_AGENCY = 402

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Quail Hill Community Association · 3 ✖

ACCESS_TYP 1

  • Restricted Access · 3 ✖
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
2679 2679 2678 {"type": "Polygon", "coordinates": [[[-117.7745, 33.6464], [-117.77409, 33.64642], [-117.77402, 33.64586], [-117.77398, 33.64527], [-117.77395, 33.64518], [-117.77384, 33.64503], [-117.77389, 33.6449], [-117.77386, 33.64479], [-117.77383, 33.64478], [-117.77388, 33.64474], [-117.77385, 33.64453], [-117.77371, 33.64448], [-117.77371, 33.64441], [-117.77368, 33.64437], [-117.77378, 33.6443], [-117.77374, 33.64398], [-117.77357, 33.64362], [-117.77347, 33.64359], [-117.77345, 33.64351], [-117.77342, 33.64347], [-117.77348, 33.64339], [-117.77344, 33.64323], [-117.77344, 33.64295], [-117.77347, 33.64291], [-117.77331, 33.64267], [-117.77328, 33.64258], [-117.77321, 33.64254], [-117.77326, 33.64242], [-117.77312, 33.6422], [-117.7735, 33.64203], [-117.77358, 33.64201], [-117.77377, 33.64198], [-117.77402, 33.64202], [-117.77425, 33.6421], [-117.77441, 33.64219], [-117.77446, 33.64223], [-117.77445, 33.64226], [-117.77431, 33.64238], [-117.77417, 33.64252], [-117.77408, 33.64265], [-117.77401, 33.64278], [-117.77397, 33.64291], [-117.77394, 33.64317], [-117.77396, 33.6433], [-117.77399, 33.6434], [-117.77447, 33.64453], [-117.77457, 33.6449], [-117.7746, 33.64528], [-117.7746, 33.64546], [-117.7745, 33.6464]]]} Restricted Access 2 Cascade Park   16939 6019 Quail Hill Community Association 402 Private 7 Home Owners Association 15 http://www.quailhillhoa.org/ Private 14 7.141 Cascade Park  
10303 10303 10302 {"type": "Polygon", "coordinates": [[[-117.78053, 33.65114], [-117.78053, 33.65118], [-117.78037, 33.6515], [-117.78018, 33.65183], [-117.78015, 33.65185], [-117.77904, 33.65142], [-117.77904, 33.65138], [-117.77909, 33.6513], [-117.77941, 33.65074], [-117.77943, 33.65072], [-117.78053, 33.65114]]]} Restricted Access 2 The Commons   26279 6019 Quail Hill Community Association 402 Private 7 Home Owners Association 15 http://www.quailhillhoa.org/ Private 14 2.466 The Commons  
10642 10642 10641 {"type": "Polygon", "coordinates": [[[-117.77074, 33.64293], [-117.77069, 33.64363], [-117.77064, 33.64366], [-117.77029, 33.64361], [-117.76995, 33.64358], [-117.76969, 33.64352], [-117.76952, 33.64344], [-117.76934, 33.6433], [-117.76928, 33.64323], [-117.76922, 33.64313], [-117.76924, 33.64307], [-117.7694, 33.64301], [-117.76944, 33.64307], [-117.7695, 33.64306], [-117.76951, 33.64304], [-117.7695, 33.643], [-117.76969, 33.64291], [-117.76988, 33.64273], [-117.76992, 33.64272], [-117.77034, 33.64285], [-117.77072, 33.64291], [-117.77074, 33.64293]]]} Restricted Access 2 Valley View Park   26809 6019 Quail Hill Community Association 402 Private 7 Home Owners Association 15 http://www.quailhillhoa.org/ Private 14 2.457 Valley View 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]);