units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 2, COUNTY = 4 and MNG_AG_TYP = 18

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER

MNG_AG_TYP 1

  • Commercial · 4 ✖

ACCESS_TYP 1

  • Restricted Access · 4 ✖
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
1118 1118 1117 {"type": "Polygon", "coordinates": [[[-117.15742, 32.70928], [-117.15639, 32.70929], [-117.15639, 32.70847], [-117.15742, 32.70847], [-117.15742, 32.70928]]]} Restricted Access 2 47585 The Park at Petco Park 31312 6117 Petco Park Owner 322 Private 7 Commercial 20 http://www.petcoparkinsider.com/park-at-the-park Private 14 6117 Petco Park Owner 319 Private 7 Commercial 18 http://www.petcoparkinsider.com/park-at-the-park San Diego 4 2.17 The Park at Petco Park 0 Private Recreation or Education 65 4
7964 7964 7963 {"type": "Polygon", "coordinates": [[[-117.2302, 32.9787], [-117.2267, 32.9787], [-117.22602, 32.97873], [-117.22534, 32.9788], [-117.22479, 32.97889], [-117.22042, 32.97969], [-117.21955, 32.97992], [-117.21887, 32.98014], [-117.21805, 32.98047], [-117.21727, 32.98086], [-117.21667, 32.98122], [-117.21597, 32.98171], [-117.21558, 32.98203], [-117.21527, 32.98229], [-117.21193, 32.98539], [-117.19708, 32.98498], [-117.19767, 32.9845], [-117.19804, 32.98428], [-117.19828, 32.98417], [-117.19854, 32.98408], [-117.1988, 32.98401], [-117.19907, 32.98397], [-117.19953, 32.98396], [-117.19998, 32.98401], [-117.20025, 32.98407], [-117.20168, 32.9845], [-117.20205, 32.98458], [-117.20243, 32.98461], [-117.20292, 32.9846], [-117.2034, 32.98452], [-117.20381, 32.9844], [-117.20424, 32.98421], [-117.20464, 32.98396], [-117.20498, 32.98366], [-117.20526, 32.98332], [-117.20547, 32.98297], [-117.20562, 32.98262], [-117.20571, 32.98225], [-117.20582, 32.98083], [-117.20589, 32.98046], [-117.20601, 32.98017], [-117.20618, 32.9799], [-117.20636, 32.97968], [-117.2066, 32.97945], [-117.20691, 32.97923], [-117.20857, 32.97828], [-117.21102, 32.97656], [-117.21139, 32.97633], [-117.21164, 32.97622], [-117.21189, 32.97613], [-117.21397, 32.97552], [-117.21428, 32.9754], [-117.21542, 32.97486], [-117.21575, 32.97475], [-117.21615, 32.97465], [-117.21644, 32.97461], [-117.21672, 32.97459], [-117.21775, 32.97456], [-117.2182, 32.97459], [-117.21854, 32.97465], [-117.21886, 32.97473], [-117.22019, 32.97526], [-117.22051, 32.97536], [-117.22083, 32.97543], [-117.22123, 32.97548], [-117.22283, 32.97555], [-117.22461, 32.97568], [-117.22508, 32.97568], [-117.22555, 32.97562], [-117.2259, 32.97554], [-117.22674, 32.97528], [-117.22711, 32.9752], [-117.22829, 32.97511], [-117.22878, 32.9751], [-117.22924, 32.97513], [-117.22961, 32.97519], [-117.23009, 32.97532], [-117.23012, 32.97534], [-117.23013, 32.97537], [-117.2302, 32.9787]]]} Restricted Access 2 47733 Fairbanks Ranch Country Club 31535 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 7021 Bay Club 860 Private 7 Commercial 18 https://www.bayclubs.com/fairbanksranch/ San Diego 4 372.882 Fairbanks Ranch Country Club   None 664  
15654 15654 15653 {"type": "MultiPolygon", "coordinates": [[[[-117.09268, 33.16118], [-117.09263, 33.16144], [-117.09239, 33.1623], [-117.09172, 33.16442], [-117.09132, 33.16557], [-117.09126, 33.16559], [-117.09122, 33.16558], [-117.09117, 33.16553], [-117.09112, 33.16552], [-117.09095, 33.1655], [-117.09109, 33.16538], [-117.09084, 33.16498], [-117.09075, 33.16478], [-117.09071, 33.16458], [-117.09071, 33.16438], [-117.09076, 33.16417], [-117.09092, 33.16373], [-117.09086, 33.16352], [-117.09003, 33.16299], [-117.08995, 33.16301], [-117.08984, 33.16316], [-117.0898, 33.16374], [-117.09023, 33.1638], [-117.09023, 33.16386], [-117.0898, 33.1638], [-117.08972, 33.1645], [-117.08977, 33.16477], [-117.08983, 33.16503], [-117.08993, 33.16525], [-117.09006, 33.1655], [-117.09025, 33.1657], [-117.09055, 33.16553], [-117.09067, 33.16561], [-117.09073, 33.16569], [-117.09088, 33.16575], [-117.09098, 33.16581], [-117.09117, 33.16582], [-117.0912, 33.16588], [-117.09069, 33.16732], [-117.09045, 33.16811], [-117.09031, 33.1682], [-117.08999, 33.16812], [-117.08956, 33.1681], [-117.08947, 33.16806], [-117.08938, 33.16805], [-117.08929, 33.16808], [-117.08918, 33.16816], [-117.08894, 33.16826], [-117.08883, 33.16821], [-117.08896, 33.16797], [-117.08906, 33.1677], [-117.08909, 33.16741], [-117.08905, 33.16713], [-117.08871, 33.16584], [-117.08859, 33.16494], [-117.0884, 33.16417], [-117.08837, 33.16359], [-117.08815, 33.16355], [-117.08817, 33.16349], [-117.08816, 33.16345], [-117.08821, 33.16335], [-117.08822, 33.16322], [-117.08826, 33.16313], [-117.08827, 33.16306], [-117.08823, 33.16297], [-117.08815, 33.1629], [-117.08795, 33.16256], [-117.08797, 33.16246], [-117.08897, 33.16188], [-117.0893, 33.16172], [-117.0897, 33.16157], [-117.08991, 33.1615], [-117.09033, 33.1614], [-117.09069, 33.16135], [-117.09263, 33.16112], [-117.09268, 33.16118]]], [[[-117.0949, 33.17091], [-117.09272, 33.17091], [-117.08993, 33.17091], [-117.09066, 33.1685], [-117.0928, 33.1691], [-117.09489, 33.16975], [-117.09493, 33.16981], [-117.09491, 33.16997], [-117.0949, 33.17091]]], [[[-117.09702, 33.17023], [-117.0954, 33.16973], [-117.0954, 33.16968], [-117.09404, 33.16924], [-117.09211, 33.16867], [-117.09084, 33.16831], [-117.09344, 33.16883], [-117.09504, 33.16905], [-117.09539, 33.16912], [-117.09576, 33.16927], [-117.09604, 33.16943], [-117.09629, 33.16963], [-117.09644, 33.16979], [-117.09662, 33.16997], [-117.09679, 33.1701], [-117.09702, 33.17023]]]]} Restricted Access 2 644 Reidy Creek Golf Course 31473 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 7017 JC Resorts 1102 Private 7 Commercial 18 https://www.jcgolf.com/san-diego-golf-courses/reidy-creek/ San Diego 4 70.314 Reidy Creek GC   None 1366  
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  

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