units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 2, DES_TP = 3 and MNG_AGENCY = 102

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Coronado, City of · 2 ✖

DES_TP 1

  • Local Recreation Area · 2 ✖

ACCESS_TYP 1

  • Restricted Access · 2 ✖
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
3419 3419 3418 {"type": "Polygon", "coordinates": [[[-117.18086, 32.69355], [-117.18013, 32.69481], [-117.17921, 32.69442], [-117.17996, 32.69317], [-117.18086, 32.69355]], [[-117.18043, 32.6934], [-117.18043, 32.69338], [-117.18037, 32.69337], [-117.17965, 32.69459], [-117.17972, 32.69461], [-117.18043, 32.6934]]]} Restricted Access 2 25118 Cutler Field 31610 1069 Coronado, City of 105 City 2 City Agency 2 http://www.coronado.ca.us/category/subcategory-rec.php City 2 1069 Coronado, City of 102 City 2 City Agency 2   San Diego 4 3.436 Cutler Field 0 Local Recreation Area 3 4
15675 15675 15674 {"type": "Polygon", "coordinates": [[[-117.17324, 32.68306], [-117.17312, 32.6832], [-117.17308, 32.6833], [-117.17296, 32.68347], [-117.17281, 32.68359], [-117.17262, 32.68371], [-117.17251, 32.68387], [-117.17263, 32.68421], [-117.17237, 32.68428], [-117.1722, 32.68427], [-117.17191, 32.6842], [-117.17173, 32.68409], [-117.17158, 32.68394], [-117.1714, 32.68369], [-117.17111, 32.68314], [-117.17032, 32.68188], [-117.16997, 32.68153], [-117.16967, 32.68141], [-117.1694, 32.68136], [-117.16905, 32.68137], [-117.16876, 32.68144], [-117.16857, 32.68156], [-117.16831, 32.68174], [-117.16815, 32.68194], [-117.16809, 32.68217], [-117.16806, 32.6824], [-117.16807, 32.68265], [-117.16806, 32.68299], [-117.16799, 32.68333], [-117.16781, 32.68386], [-117.16782, 32.68414], [-117.16818, 32.68551], [-117.16848, 32.68627], [-117.16921, 32.68776], [-117.1693, 32.68813], [-117.16936, 32.68869], [-117.16947, 32.69001], [-117.16944, 32.69032], [-117.16939, 32.69055], [-117.16924, 32.69095], [-117.16902, 32.69135], [-117.16873, 32.69133], [-117.16859, 32.69128], [-117.1684, 32.69116], [-117.16821, 32.691], [-117.16791, 32.6907], [-117.16765, 32.69047], [-117.167, 32.69001], [-117.16625, 32.68951], [-117.1654, 32.68896], [-117.16433, 32.68832], [-117.16413, 32.6882], [-117.16395, 32.68818], [-117.16375, 32.68809], [-117.16367, 32.68794], [-117.16367, 32.6876], [-117.16362, 32.68675], [-117.16365, 32.68636], [-117.1637, 32.68595], [-117.1638, 32.6856], [-117.16383, 32.68543], [-117.16376, 32.68536], [-117.16377, 32.68528], [-117.16404, 32.68465], [-117.16416, 32.68445], [-117.16432, 32.68424], [-117.16452, 32.68409], [-117.165, 32.68395], [-117.16516, 32.68388], [-117.16524, 32.68378], [-117.16527, 32.68364], [-117.16527, 32.68334], [-117.16531, 32.68286], [-117.16541, 32.68243], [-117.16567, 32.68145], [-117.16584, 32.68066], [-117.1659, 32.68018], [-117.16628, 32.67969], [-117.16647, 32.67956], [-117.16716, 32.67928], [-117.16734, 32.67918], [-117.16765, 32.67893], [-117.16783, 32.67893], [-117.16818, 32.67905], [-117.16837, 32.67918], [-117.16868, 32.67933], [-117.169, 32.67943], [-117.16948, 32.67961], [-117.16996, 32.67982], [-117.17018, 32.67994], [-117.17036, 32.6801], [-117.17057, 32.68033], [-117.17074, 32.6806], [-117.17086, 32.68087], [-117.1709, 32.68106], [-117.17098, 32.68124], [-117.17131, 32.68156], [-117.17157, 32.68191], [-117.17185, 32.68218], [-117.17212, 32.68235], [-117.17244, 32.68242], [-117.17277, 32.68264], [-117.17314, 32.68283], [-117.17323, 32.68294], [-117.17324, 32.68306]]]} Restricted Access 2 12284 Coronado Golf Course 33031 1069 Coronado, City of 105 City 2 City Agency 2 http://www.coronado.ca.us/category/subcategory-rec.php City 2 1069 Coronado, City of 102 City 2 City Agency 2 http://www.golfcoronado.com/ San Diego 4 126.258 Coronado GC 0 Local Recreation Area 3 4

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