units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, DES_TP = 3 and PARK_URL = "http://www.sandiego.gov/water/recreation/reservoirs/elcapitan.shtml"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Recreation Area · 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
14599 14599 14598 {"type": "Polygon", "coordinates": [[[-116.82378, 32.88431], [-116.82378, 32.88489], [-116.82371, 32.88787], [-116.81079, 32.88793], [-116.81078, 32.88438], [-116.80658, 32.88434], [-116.80259, 32.88433], [-116.80253, 32.88611], [-116.79824, 32.88612], [-116.79819, 32.88806], [-116.79407, 32.88811], [-116.79412, 32.89172], [-116.78983, 32.89179], [-116.78987, 32.8947], [-116.78741, 32.89479], [-116.78531, 32.89483], [-116.78509, 32.90677], [-116.78592, 32.91744], [-116.7837, 32.9175], [-116.784, 32.92114], [-116.78386, 32.9282], [-116.78192, 32.92819], [-116.78182, 32.93195], [-116.77992, 32.93194], [-116.77986, 32.93542], [-116.77984, 32.93544], [-116.77857, 32.93544], [-116.77736, 32.93546], [-116.77722, 32.94281], [-116.77324, 32.94286], [-116.77329, 32.9502], [-116.77122, 32.95017], [-116.77091, 32.95166], [-116.77082, 32.95224], [-116.77055, 32.95358], [-116.76843, 32.95364], [-116.76779, 32.95696], [-116.76562, 32.95707], [-116.76438, 32.96334], [-116.75388, 32.96342], [-116.75393, 32.9671], [-116.7494, 32.96711], [-116.74941, 32.97075], [-116.7382, 32.97066], [-116.73814, 32.96705], [-116.74485, 32.96708], [-116.74482, 32.96342], [-116.74512, 32.96188], [-116.74551, 32.96004], [-116.75024, 32.96006], [-116.75098, 32.95663], [-116.7514, 32.95665], [-116.7553, 32.95664], [-116.75672, 32.94992], [-116.75715, 32.94991], [-116.75852, 32.94995], [-116.75877, 32.94994], [-116.75882, 32.94633], [-116.75674, 32.94644], [-116.75676, 32.94303], [-116.76506, 32.94257], [-116.76504, 32.93951], [-116.76914, 32.93931], [-116.7691, 32.93567], [-116.76692, 32.93577], [-116.76699, 32.92771], [-116.77323, 32.92776], [-116.77327, 32.92111], [-116.77321, 32.92069], [-116.77249, 32.91387], [-116.77683, 32.91396], [-116.77611, 32.90681], [-116.77624, 32.90238], [-116.77224, 32.90247], [-116.77244, 32.89524], [-116.76171, 32.89511], [-116.76163, 32.88822], [-116.76381, 32.88824], [-116.76382, 32.88977], [-116.76818, 32.88986], [-116.76821, 32.88985], [-116.7682, 32.88828], [-116.77238, 32.88832], [-116.78345, 32.88822], [-116.78362, 32.88455], [-116.78583, 32.88451], [-116.78613, 32.87714], [-116.78812, 32.87713], [-116.78823, 32.87351], [-116.78627, 32.87354], [-116.7859, 32.87031], [-116.79405, 32.87017], [-116.79361, 32.86645], [-116.79343, 32.85863], [-116.79834, 32.85869], [-116.79825, 32.85517], [-116.80246, 32.85521], [-116.80231, 32.8591], [-116.80234, 32.86122], [-116.80265, 32.87358], [-116.80265, 32.87364], [-116.79855, 32.87362], [-116.79845, 32.87727], [-116.8067, 32.87741], [-116.80665, 32.88079], [-116.81512, 32.88089], [-116.81507, 32.8841], [-116.81508, 32.88435], [-116.82378, 32.88431]], [[-116.75538, 32.9625], [-116.75464, 32.96306], [-116.75455, 32.96311], [-116.75449, 32.96311], [-116.75403, 32.96305], [-116.75379, 32.96304], [-116.75353, 32.96304], [-116.75318, 32.9631], [-116.75299, 32.96307], [-116.75289, 32.96301], [-116.75237, 32.9626], [-116.75224, 32.96255], [-116.75192, 32.96246], [-116.75171, 32.96246], [-116.7513, 32.96256], [-116.75108, 32.96256], [-116.75076, 32.9625], [-116.75062, 32.9625], [-116.75017, 32.96262], [-116.75007, 32.96262], [-116.74931, 32.96238], [-116.74926, 32.96247], [-116.74978, 32.96265], [-116.75004, 32.96272], [-116.75016, 32.96273], [-116.75028, 32.96271], [-116.75066, 32.96261], [-116.75076, 32.96261], [-116.75108, 32.96267], [-116.75124, 32.96268], [-116.75172, 32.96257], [-116.7519, 32.96257], [-116.75218, 32.96265], [-116.75235, 32.96272], [-116.75282, 32.9631], [-116.75298, 32.96318], [-116.75318, 32.96321], [-116.75376, 32.96314], [-116.75401, 32.96315], [-116.75449, 32.96322], [-116.7546, 32.96321], [-116.75473, 32.96315], [-116.75555, 32.96253], [-116.75647, 32.96203], [-116.7572, 32.96147], [-116.75728, 32.96144], [-116.75737, 32.96141], [-116.75796, 32.9614], [-116.75816, 32.96138], [-116.76004, 32.96066], [-116.76028, 32.96059], [-116.76049, 32.96055], [-116.76064, 32.96054], [-116.76077, 32.96055], [-116.76109, 32.96062], [-116.7611, 32.96061], [-116.76106, 32.9605], [-116.76077, 32.96043], [-116.76047, 32.96044], [-116.76017, 32.96051], [-116.75978, 32.96063], [-116.75825, 32.96123], [-116.75812, 32.96127], [-116.7579, 32.9613], [-116.75734, 32.9613], [-116.7572, 32.96134], [-116.75687, 32.96157], [-116.75638, 32.96196], [-116.75562, 32.96235], [-116.75538, 32.9625]]]} Restricted Access 2 44814 El Capitan Reservoir 31465 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/water/recreation/reservoirs/elcapitan.shtml San Diego 4 4164.597 El Capitan Reservoir 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]);