units_with_maps

Table actions

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

1 row where DES_TP = 4, MNG_AG_TYP = 3 and PARK_URL = "http://www.sdparks.org/content/sdparks/en/park-pages/LosPenasquitos.html"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency · 1 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Conservation Area · 1 ✖

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
14608 14608 14607 {"type": "MultiPolygon", "coordinates": [[[[-117.14468, 32.93894], [-117.14052, 32.93899], [-117.14057, 32.93988], [-117.13978, 32.93993], [-117.13697, 32.94021], [-117.13424, 32.94028], [-117.13399, 32.94024], [-117.13382, 32.94026], [-117.13366, 32.94039], [-117.13345, 32.94061], [-117.13322, 32.94079], [-117.13311, 32.94085], [-117.13284, 32.94094], [-117.13257, 32.94096], [-117.13182, 32.9409], [-117.131, 32.9409], [-117.13065, 32.94087], [-117.13032, 32.94074], [-117.13004, 32.94058], [-117.12976, 32.9405], [-117.12959, 32.94047], [-117.12929, 32.94047], [-117.12927, 32.94039], [-117.12922, 32.94039], [-117.12887, 32.93931], [-117.12873, 32.93902], [-117.12858, 32.93879], [-117.12808, 32.93813], [-117.12695, 32.93676], [-117.12904, 32.93619], [-117.12976, 32.93634], [-117.13003, 32.93637], [-117.13116, 32.93622], [-117.13225, 32.93618], [-117.13369, 32.93583], [-117.13409, 32.93549], [-117.13406, 32.93501], [-117.13567, 32.93494], [-117.13568, 32.93482], [-117.13675, 32.93478], [-117.13631, 32.93532], [-117.13604, 32.9357], [-117.13604, 32.93572], [-117.13916, 32.93565], [-117.13942, 32.93485], [-117.14136, 32.93576], [-117.14268, 32.93569], [-117.14408, 32.93456], [-117.14434, 32.93456], [-117.14467, 32.93605], [-117.14468, 32.93894]]], [[[-117.16982, 32.94862], [-117.16683, 32.94859], [-117.16682, 32.94854], [-117.16512, 32.94853], [-117.1651, 32.94814], [-117.1651, 32.94682], [-117.16714, 32.94686], [-117.16715, 32.94642], [-117.16771, 32.94614], [-117.16748, 32.94568], [-117.16713, 32.94559], [-117.16713, 32.94514], [-117.16961, 32.94511], [-117.16982, 32.94862]]], [[[-117.20536, 32.90698], [-117.20535, 32.90716], [-117.20503, 32.90727], [-117.20468, 32.90741], [-117.20434, 32.90758], [-117.20409, 32.90773], [-117.20365, 32.90805], [-117.20281, 32.9088], [-117.20259, 32.90878], [-117.20241, 32.90878], [-117.20204, 32.90881], [-117.20188, 32.90885], [-117.2017, 32.90891], [-117.20152, 32.90899], [-117.20141, 32.90907], [-117.20137, 32.90907], [-117.20022, 32.9076], [-117.20351, 32.90659], [-117.20536, 32.90698]]], [[[-117.21151, 32.90728], [-117.21058, 32.90768], [-117.20851, 32.90765], [-117.20853, 32.90715], [-117.20941, 32.90736], [-117.2101, 32.90743], [-117.21034, 32.90744], [-117.21078, 32.90741], [-117.21102, 32.90738], [-117.21151, 32.90728]]], [[[-117.21354, 32.90559], [-117.21337, 32.90582], [-117.21319, 32.90601], [-117.21282, 32.90632], [-117.21267, 32.90643], [-117.21224, 32.9067], [-117.21204, 32.90679], [-117.21184, 32.90688], [-117.21139, 32.90702], [-117.2109, 32.90712], [-117.21041, 32.90716], [-117.21014, 32.90717], [-117.20989, 32.90715], [-117.20934, 32.90707], [-117.20855, 32.90687], [-117.2086, 32.90558], [-117.21354, 32.90559]]], [[[-117.21547, 32.9056], [-117.2135, 32.90694], [-117.21235, 32.90695], [-117.21262, 32.90681], [-117.21289, 32.90664], [-117.21336, 32.90626], [-117.21351, 32.90611], [-117.21364, 32.90594], [-117.21378, 32.90576], [-117.21389, 32.90559], [-117.21547, 32.9056]]]]} Open Access 1 44831 Los Penasquitos Canyon Preserve 21528 319 San Diego, County of 104 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/ County 3 319 San Diego, County of 101 County 3 County Agency 3 http://www.sdparks.org/content/sdparks/en/park-pages/LosPenasquitos.html San Diego 4 255.079 Los Penasquitos Canyon Preserve 0 Local Conservation Area 4 2

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