units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, MNG_AGENCY = 1102 and MNG_AG_LEV = 7

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • JC Resorts · 1 ✖

DES_TP 1

ACCESS_TYP 1

  • Restricted Access · 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
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  

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