superunits_with_maps

Table actions

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

2 rows where AGNCY_WEB = "https://www.americangolf.com/about-us", MNG_AGENCY = 1103 and MNG_AG_TYP = 18

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Commercial · 2 ✖

MNG_AGENCY 1

  • American Golf · 2 ✖

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
10865 10865 10864 {"type": "Polygon", "coordinates": [[[-118.20385, 34.15912], [-118.20364, 34.15913], [-118.20283, 34.15904], [-118.20265, 34.15903], [-118.20242, 34.15906], [-118.20215, 34.15918], [-118.20199, 34.15931], [-118.20187, 34.15946], [-118.20181, 34.15961], [-118.20163, 34.16029], [-118.20152, 34.16049], [-118.20133, 34.16069], [-118.20113, 34.16084], [-118.20035, 34.16128], [-118.19998, 34.16144], [-118.19952, 34.16158], [-118.19932, 34.16163], [-118.19903, 34.16167], [-118.19849, 34.16169], [-118.19592, 34.16158], [-118.19553, 34.16156], [-118.19518, 34.16157], [-118.19473, 34.16163], [-118.19442, 34.1617], [-118.19389, 34.16188], [-118.19365, 34.16167], [-118.19365, 34.16163], [-118.19384, 34.16147], [-118.19386, 34.16142], [-118.19384, 34.16133], [-118.19377, 34.1612], [-118.19376, 34.16113], [-118.19382, 34.16092], [-118.19381, 34.16077], [-118.19383, 34.16072], [-118.19397, 34.16063], [-118.19415, 34.16047], [-118.1942, 34.16046], [-118.19428, 34.16047], [-118.19437, 34.16057], [-118.19449, 34.16065], [-118.19459, 34.16067], [-118.19469, 34.16066], [-118.19481, 34.16059], [-118.19508, 34.16038], [-118.1952, 34.16036], [-118.19532, 34.16032], [-118.19559, 34.16013], [-118.19567, 34.16001], [-118.19576, 34.15995], [-118.19586, 34.15985], [-118.19589, 34.15978], [-118.1959, 34.1593], [-118.19593, 34.15921], [-118.19598, 34.15913], [-118.19606, 34.15906], [-118.19614, 34.15902], [-118.19629, 34.15897], [-118.1965, 34.15894], [-118.19678, 34.15894], [-118.19707, 34.15878], [-118.1976, 34.15832], [-118.19787, 34.15792], [-118.19805, 34.15789], [-118.1985, 34.15819], [-118.19855, 34.15817], [-118.19866, 34.15816], [-118.199, 34.15799], [-118.19919, 34.15792], [-118.19933, 34.15784], [-118.19949, 34.15777], [-118.19957, 34.1577], [-118.19971, 34.15763], [-118.19978, 34.1576], [-118.19992, 34.15761], [-118.20004, 34.15771], [-118.2004, 34.15772], [-118.20115, 34.15799], [-118.2028, 34.15819], [-118.20278, 34.1576], [-118.20345, 34.15779], [-118.20361, 34.15821], [-118.20366, 34.15887], [-118.20384, 34.15885], [-118.20385, 34.15912]]]} Restricted Access 2 Scholl Canyon Golf Course & Tennis Center http://www.schollcanyongc.com/ 29385 6098 American Golf 1103 Private 7 Commercial 18 https://www.americangolf.com/about-us Private 14 60.212 Scholl Canyon GC & Tennis Ctr.  
12881 12881 12880 {"type": "Polygon", "coordinates": [[[-117.0607, 33.0691], [-117.06056, 33.06911], [-117.06032, 33.06962], [-117.06013, 33.07022], [-117.05995, 33.07071], [-117.05868, 33.07381], [-117.05857, 33.07384], [-117.05197, 33.07314], [-117.05161, 33.07306], [-117.05013, 33.07263], [-117.0498, 33.07251], [-117.05015, 33.07117], [-117.0501, 33.07055], [-117.05001, 33.07054], [-117.04992, 33.07056], [-117.04996, 33.07112], [-117.04961, 33.07247], [-117.04858, 33.07215], [-117.04909, 33.07113], [-117.0494, 33.07036], [-117.04945, 33.07026], [-117.04955, 33.07011], [-117.04976, 33.0699], [-117.05022, 33.06955], [-117.05031, 33.06955], [-117.05047, 33.06965], [-117.05065, 33.06972], [-117.05062, 33.06978], [-117.05061, 33.07004], [-117.0516, 33.07009], [-117.05241, 33.06989], [-117.05259, 33.07037], [-117.0535, 33.07116], [-117.05388, 33.0709], [-117.05426, 33.07057], [-117.05466, 33.07008], [-117.05485, 33.06937], [-117.05529, 33.06938], [-117.05577, 33.06924], [-117.05643, 33.06865], [-117.05689, 33.06906], [-117.05753, 33.06844], [-117.05702, 33.06809], [-117.05754, 33.06758], [-117.05804, 33.06727], [-117.05897, 33.06796], [-117.05896, 33.068], [-117.05978, 33.06862], [-117.0607, 33.0691]]]} Restricted Access 2 The Vineyard at Escondido Golf Course http://www.vineyardatescondido.com/?doubleclick=false 31472 6098 American Golf 1103 Private 7 Commercial 18 https://www.americangolf.com/about-us Private 14 105.42 The Vineyard at Escondido GC  

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