superunits_with_maps

Table actions

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

4 rows where MNG_AGENCY = 695, MNG_AG_LEV = 7 and MNG_AG_TYP = 15

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Home Owners Association · 4 ✖

MNG_AGENCY 1

  • Nellie Gail Ranch Owners Association · 4 ✖

ACCESS_TYP 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
1444 1444 1443 {"type": "Polygon", "coordinates": [[[-117.69963, 33.56992], [-117.69952, 33.57001], [-117.69881, 33.57008], [-117.69853, 33.57013], [-117.69811, 33.57027], [-117.69807, 33.57025], [-117.69787, 33.56999], [-117.69788, 33.56997], [-117.69802, 33.56982], [-117.69823, 33.56964], [-117.69834, 33.5695], [-117.6984, 33.56937], [-117.69959, 33.56969], [-117.69963, 33.56992]]]} Restricted Access 2 Moulton Park   32220 6042 Nellie Gail Ranch Owners Association 695 Private 7 Home Owners Association 15 http://www.nelliegailranch.org/ Private 14 2.271 Moulton Park  
12323 12323 12322 {"type": "Polygon", "coordinates": [[[-117.68781, 33.56685], [-117.68754, 33.56707], [-117.68738, 33.56716], [-117.6872, 33.5672], [-117.68701, 33.5672], [-117.68688, 33.56718], [-117.68666, 33.56708], [-117.6865, 33.56695], [-117.68625, 33.56665], [-117.68745, 33.56622], [-117.68781, 33.56685]]]} Restricted Access 2 Hidden Trail Park   32368 6042 Nellie Gail Ranch Owners Association 695 Private 7 Home Owners Association 15 http://www.nelliegailranch.org/ Private 14 2.361 Hidden Trail Park  
12325 12325 12324 {"type": "Polygon", "coordinates": [[[-117.68585, 33.58636], [-117.68536, 33.58738], [-117.68474, 33.58771], [-117.68467, 33.58757], [-117.68438, 33.58672], [-117.68425, 33.58649], [-117.6842, 33.58636], [-117.68418, 33.58624], [-117.6842, 33.58618], [-117.68423, 33.58616], [-117.68431, 33.58615], [-117.68449, 33.58609], [-117.68461, 33.58603], [-117.68472, 33.58595], [-117.68488, 33.58578], [-117.68585, 33.58636]]]} Restricted Access 2 Gallup Park   32373 6042 Nellie Gail Ranch Owners Association 695 Private 7 Home Owners Association 15 http://www.nelliegailranch.org/ Private 14 4.679 Gallup Park  
12332 12332 12331 {"type": "Polygon", "coordinates": [[[-117.6905, 33.5747], [-117.6905, 33.57489], [-117.69044, 33.57512], [-117.69032, 33.57533], [-117.69021, 33.57545], [-117.69016, 33.57546], [-117.68992, 33.57536], [-117.68966, 33.57532], [-117.68939, 33.57534], [-117.68921, 33.57538], [-117.68898, 33.5755], [-117.68879, 33.57566], [-117.68867, 33.57586], [-117.68861, 33.57608], [-117.68767, 33.57626], [-117.68719, 33.57544], [-117.68757, 33.57526], [-117.688, 33.57509], [-117.68857, 33.5749], [-117.689, 33.5748], [-117.68945, 33.57472], [-117.69006, 33.57466], [-117.69041, 33.57464], [-117.6905, 33.5747]]]} Restricted Access 2 Dapple Grey Park   32382 6042 Nellie Gail Ranch Owners Association 695 Private 7 Home Owners Association 15 http://www.nelliegailranch.org/ Private 14 6.64 Dapple Grey 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]);