units_with_maps

Table actions

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

6 rows where COUNTY = 4, DES_TP = 65 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB

ACCESS_TYP 2

MNG_AG_TYP 1

  • Non Profit - Land Trust · 6 ✖

DES_TP 1

  • Private Recreation or Education · 6 ✖
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
1523 1523 1522 {"type": "Polygon", "coordinates": [[[-116.78494, 33.12411], [-116.78019, 33.12414], [-116.7802, 33.12031], [-116.7849, 33.12029], [-116.78494, 33.12411]]]} Open Access 1 12843 Corral Mountain Open Space 17655 3066 San Dieguito River Valley Land Conservancy 378 Non Profit 6 Non Profit - Land Trust 10 http://www.sdrvc.org/ Non Governmental Organization 10 3066 San Dieguito River Valley Land Conservancy 373 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 46.202 Corral Mtn. OS 0 Private Recreation or Education 65 4
3140 3140 3139 {"type": "MultiPolygon", "coordinates": [[[[-116.60256, 33.11613], [-116.59824, 33.115], [-116.59824, 33.11394], [-116.60131, 33.11356], [-116.60184, 33.11283], [-116.60185, 33.1129], [-116.6019, 33.11298], [-116.60231, 33.11337], [-116.6024, 33.11349], [-116.60246, 33.1136], [-116.60259, 33.11401], [-116.60286, 33.1151], [-116.60287, 33.11531], [-116.60283, 33.11554], [-116.60272, 33.11583], [-116.60256, 33.11613]]], [[[-116.60241, 33.11223], [-116.60228, 33.11229], [-116.6022, 33.11232], [-116.60227, 33.11223], [-116.60241, 33.11223]]]]} No Public Access 3 25800 San Dieguito River Park 24870 3066 San Dieguito River Valley Land Conservancy 378 Non Profit 6 Non Profit - Land Trust 10 http://www.sdrvc.org/ Non Governmental Organization 10 3066 San Dieguito River Valley Land Conservancy 373 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 22.717 San Dieguito River Park 0 Private Recreation or Education 65 4
7965 7965 7964 {"type": "Polygon", "coordinates": [[[-116.7891, 33.13878], [-116.78022, 33.1388], [-116.78022, 33.13504], [-116.78472, 33.13503], [-116.78478, 33.13134], [-116.78494, 33.12411], [-116.78899, 33.12409], [-116.78892, 33.13124], [-116.78904, 33.13125], [-116.7891, 33.13878]]]} No Public Access 3 47728 Corral Mountain Open Space 31528 3066 San Dieguito River Valley Land Conservancy 378 Non Profit 6 Non Profit - Land Trust 10 http://www.sdrvc.org/ Non Governmental Organization 10 3066 San Dieguito River Valley Land Conservancy 373 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 201.771 Corral Mtn. OS 0 Private Recreation or Education 65 4
8330 8330 8329 {"type": "Polygon", "coordinates": [[[-117.09055, 33.05824], [-117.08987, 33.06472], [-117.0888, 33.0652], [-117.08779, 33.06623], [-117.08762, 33.06754], [-117.08752, 33.06778], [-117.08632, 33.06777], [-117.08589, 33.06832], [-117.08581, 33.06924], [-117.08613, 33.07024], [-117.08537, 33.07057], [-117.08523, 33.07125], [-117.08374, 33.07112], [-117.08344, 33.0707], [-117.08373, 33.0701], [-117.08329, 33.06941], [-117.08281, 33.06838], [-117.08267, 33.06775], [-117.08203, 33.06715], [-117.08234, 33.06662], [-117.08253, 33.06494], [-117.08257, 33.06486], [-117.0825, 33.06439], [-117.08259, 33.06429], [-117.08265, 33.06402], [-117.08265, 33.06372], [-117.08256, 33.06359], [-117.08246, 33.06348], [-117.0824, 33.06321], [-117.08242, 33.06312], [-117.08251, 33.06298], [-117.08256, 33.06263], [-117.08304, 33.06214], [-117.08335, 33.0619], [-117.08367, 33.0615], [-117.08376, 33.06128], [-117.08385, 33.06118], [-117.08378, 33.06105], [-117.08379, 33.06096], [-117.08386, 33.06082], [-117.08427, 33.06051], [-117.08432, 33.06043], [-117.08444, 33.06032], [-117.08499, 33.05989], [-117.0857, 33.05861], [-117.08713, 33.058], [-117.08766, 33.05785], [-117.08761, 33.0577], [-117.0876, 33.05758], [-117.08766, 33.05738], [-117.08773, 33.05731], [-117.08795, 33.05728], [-117.08817, 33.05732], [-117.0884, 33.05745], [-117.08853, 33.05762], [-117.08965, 33.0578], [-117.08988, 33.05787], [-117.09024, 33.05791], [-117.09039, 33.058], [-117.09055, 33.05824]], [[-117.08681, 33.06677], [-117.0869, 33.06677], [-117.087, 33.06674], [-117.08714, 33.06664], [-117.08713, 33.0657], [-117.08615, 33.0657], [-117.08616, 33.06666], [-117.08668, 33.06676], [-117.08681, 33.06677]]]} Open Access 1 12833 Bernardo Mountain Open Space 10792 3066 San Dieguito River Valley Land Conservancy 378 Non Profit 6 Non Profit - Land Trust 10 http://www.sdrvc.org/ Non Governmental Organization 10 3066 San Dieguito River Valley Land Conservancy 373 Non Profit 6 Non Profit - Land Trust 10 http://sdrvc.org/accomplishments/bernardo-mountain/171 San Diego 4 175.923 Bernardo Mtn. OS 0 Private Recreation or Education 65 4
8339 8339 8338 {"type": "Polygon", "coordinates": [[[-116.53359, 33.16797], [-116.53794, 33.16809], [-116.53811, 33.17231], [-116.53815, 33.17515], [-116.54258, 33.17521], [-116.54272, 33.17873], [-116.53401, 33.17867], [-116.53373, 33.17153], [-116.52949, 33.17168], [-116.52931, 33.16798], [-116.53359, 33.16797]]]} No Public Access 3 12844 San Dieguito River Park 24870 3066 San Dieguito River Valley Land Conservancy 378 Non Profit 6 Non Profit - Land Trust 10 http://www.sdrvc.org/ Non Governmental Organization 10 3066 San Dieguito River Valley Land Conservancy 373 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 197.03 San Dieguito River Park 0 Private Recreation or Education 65 4
9295 9295 9294 {"type": "MultiPolygon", "coordinates": [[[[-116.76305, 32.81484], [-116.76098, 32.81517], [-116.76081, 32.816], [-116.76163, 32.81736], [-116.75943, 32.8183], [-116.75928, 32.81555], [-116.75915, 32.81554], [-116.75928, 32.81413], [-116.76033, 32.81398], [-116.76305, 32.81484]]], [[[-116.76499, 32.81594], [-116.76499, 32.81594], [-116.76252, 32.81698], [-116.76247, 32.81632], [-116.76306, 32.8158], [-116.76331, 32.8148], [-116.76497, 32.81453], [-116.76497, 32.81518], [-116.76499, 32.81594]]], [[[-116.77229, 32.82298], [-116.77205, 32.83021], [-116.76845, 32.83018], [-116.76843, 32.8299], [-116.7678, 32.8299], [-116.7678, 32.83018], [-116.76362, 32.83016], [-116.76347, 32.82769], [-116.76577, 32.8277], [-116.76578, 32.82769], [-116.76276, 32.81729], [-116.76665, 32.81623], [-116.76675, 32.81623], [-116.7668, 32.81625], [-116.76686, 32.81632], [-116.76711, 32.81956], [-116.76748, 32.81956], [-116.76773, 32.82294], [-116.77229, 32.82298]]]]} Open Access 1 15488 Wright's Field 399 3007 Back Country Land Trust 152 Non Profit 6 Non Profit - Land Trust 10 http://www.bclt.org/ Non Governmental Organization 10 3007 Back Country Land Trust 148 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 231.124 Wright's Field 0 Private Recreation or Education 65 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]);