units_with_maps

Table actions

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

5 rows where ACCESS_TYP = 4, COUNTY = 4 and DES_TP = 14

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, LABEL_NAME

DES_TP 1

  • Local Other or Unknown · 5 ✖

ACCESS_TYP 1

  • Unknown Access · 5 ✖
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
4759 4759 4758 {"type": "Polygon", "coordinates": [[[-116.89337, 32.86769], [-116.89335, 32.87083], [-116.89269, 32.87075], [-116.89171, 32.87067], [-116.89084, 32.87071], [-116.88852, 32.8713], [-116.88757, 32.87172], [-116.88715, 32.87197], [-116.88627, 32.87239], [-116.88579, 32.87264], [-116.88517, 32.87306], [-116.88341, 32.87378], [-116.88276, 32.87409], [-116.88211, 32.8745], [-116.88159, 32.87481], [-116.88042, 32.87556], [-116.87951, 32.87611], [-116.87854, 32.87675], [-116.87777, 32.87717], [-116.87882, 32.87389], [-116.88144, 32.87294], [-116.88354, 32.87188], [-116.88375, 32.87177], [-116.88407, 32.87153], [-116.88412, 32.87153], [-116.88423, 32.87144], [-116.88619, 32.86953], [-116.88642, 32.86932], [-116.88665, 32.86914], [-116.88691, 32.86897], [-116.88719, 32.86882], [-116.88743, 32.86871], [-116.88787, 32.86854], [-116.88831, 32.86843], [-116.89254, 32.868], [-116.89295, 32.86788], [-116.89337, 32.86769]]]} Unknown Access 4 46690 Unnamed site - Helix Water District 30035 2046 Helix Water District 777 Special District 4 Water District 13 http://www.hwd.com Special District 4 2046 Helix Water District 757 Special District 4 Water District 13   San Diego 4 97.198   0 Local Other or Unknown 14 4
14716 14716 14715 {"type": "Polygon", "coordinates": [[[-116.38556, 32.97589], [-116.38485, 32.97959], [-116.38064, 32.97968], [-116.37621, 32.97986], [-116.37679, 32.97617], [-116.3768, 32.9758], [-116.38134, 32.97552], [-116.38136, 32.97593], [-116.38556, 32.97589]]]} Unknown Access 4 47814 Unnamed site - San Diego, County of 31715 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   San Diego 4 87.174   0 Local Other or Unknown 14 4
14774 14774 14773 {"type": "MultiPolygon", "coordinates": [[[[-117.3104, 33.20185], [-117.31053, 33.20215], [-117.31063, 33.20246], [-117.31076, 33.20299], [-117.31074, 33.20304], [-117.31069, 33.20307], [-117.31012, 33.2032], [-117.30901, 33.2034], [-117.308, 33.20353], [-117.30733, 33.20359], [-117.30597, 33.20366], [-117.30496, 33.20366], [-117.30145, 33.20359], [-117.30076, 33.20359], [-117.30007, 33.20361], [-117.29904, 33.20369], [-117.29686, 33.20395], [-117.29686, 33.20297], [-117.30621, 33.20241], [-117.30709, 33.20231], [-117.30775, 33.20222], [-117.31037, 33.2018], [-117.3104, 33.20185]]], [[[-117.31023, 33.20153], [-117.3077, 33.20193], [-117.30618, 33.20213], [-117.29686, 33.2027], [-117.29686, 33.20126], [-117.3063, 33.20135], [-117.31012, 33.20136], [-117.31023, 33.20153]]]]} Unknown Access 4 45152 North County Transit District Mitigation 22817 2323 North County Transit District 1046 Special District 4 Transportation Agency 32 http://www.gonctd.com/ Special District 4 2323 North County Transit District 1006 Special District 4 Transportation Agency 34   San Diego 4 69.998 North County Transit District Mitigation 0 Local Other or Unknown 14 4
14807 14807 14806 {"type": "Polygon", "coordinates": [[[-116.93609, 33.0511], [-116.92755, 33.05108], [-116.92754, 33.04241], [-116.93205, 33.04305], [-116.93259, 33.04035], [-116.92753, 33.03962], [-116.92753, 33.03643], [-116.93601, 33.03655], [-116.93601, 33.04036], [-116.93609, 33.0511]]]} Unknown Access 4 45223 Ramona Municipal Water District 24117 2116 Ramona Municipal Water District 872 Special District 4 Water District 13 http://www.rmwd.org/ Special District 4 2116 Ramona Municipal Water District 850 Special District 4 Water District 13   San Diego 4 283.724 Ramona Municipal Water District 0 Local Other or Unknown 14 4
14808 14808 14807 {"type": "Polygon", "coordinates": [[[-117.00394, 33.01294], [-117.00388, 33.01486], [-117.00029, 33.01496], [-117.00055, 33.01283], [-117.00251, 33.0123], [-117.00285, 33.01294], [-117.00394, 33.01294]]]} Unknown Access 4 45224 Ramona Municipal Water District 24117 2116 Ramona Municipal Water District 872 Special District 4 Water District 13 http://www.rmwd.org/ Special District 4 2116 Ramona Municipal Water District 850 Special District 4 Water District 13   San Diego 4 19.711 Ramona Municipal Water District 0 Local Other or Unknown 14 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]);