units_with_maps

Table actions

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

2 rows where LAYER = 2, MNG_AGENCY = 1103 and MNG_AG_TYP = 18

This data as json, copyable, CSV (advanced)

DES_TP 2

MNG_AG_TYP 1

  • Commercial · 2 ✖

MNG_AGENCY 1

  • American Golf · 2 ✖

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
15661 15661 15660 {"type": "Polygon", "coordinates": [[[-117.0607, 33.0691], [-117.06056, 33.0691], [-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.05011, 33.07055], [-117.05001, 33.07054], [-117.04992, 33.07055], [-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.0506, 33.07004], [-117.0516, 33.07009], [-117.05241, 33.06989], [-117.05259, 33.07037], [-117.0535, 33.07117], [-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.05688, 33.06907], [-117.05753, 33.06844], [-117.05702, 33.06809], [-117.05754, 33.06758], [-117.05804, 33.06727], [-117.05897, 33.06796], [-117.05895, 33.06799], [-117.05978, 33.06862], [-117.0607, 33.0691]]]} Restricted Access 2 4951 The Vineyard at Escondido Golf Course 31472 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 6098 American Golf 1103 Private 7 Commercial 18 http://www.vineyardatescondido.com/?doubleclick=false San Diego 4 105.386 The Vineyard at Escondido GC   None 1367  
17053 17053 17052 {"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.20198, 34.15931], [-118.20187, 34.15946], [-118.20181, 34.15961], [-118.20163, 34.16029], [-118.20152, 34.16049], [-118.20134, 34.16069], [-118.20113, 34.16084], [-118.20035, 34.16128], [-118.19998, 34.16144], [-118.19952, 34.16158], [-118.19932, 34.16163], [-118.19902, 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.15979], [-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.19761, 34.15832], [-118.19787, 34.15792], [-118.19805, 34.15789], [-118.1985, 34.1582], [-118.19855, 34.15817], [-118.19866, 34.15816], [-118.199, 34.15799], [-118.1992, 34.15792], [-118.19932, 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.20281, 34.15819], [-118.20278, 34.1576], [-118.20345, 34.15779], [-118.20361, 34.15821], [-118.20366, 34.15888], [-118.20384, 34.15885], [-118.20385, 34.15912]]]} Restricted Access 2 6955 Scholl Canyon Golf Course & Tennis Center 29385 1119 Glendale, City of 103 City 2 City Agency 2 http://www.glendaleca.gov/government/city-departments/community-services-parks City 2 6098 American Golf 1103 Private 7 Commercial 18 http://www.schollcanyongc.com/ Los Angeles 6 60.199 Scholl Canyon GC & Tennis Ctr.   None 1427  

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