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

4 rows where MNG_AGENCY = 148

View and edit SQL

ACCESS_TYP

MNG_AGENCY

  • Back Country Land Trust · 4
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
7 6 {"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.81556], [-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.76842, 32.8299], [-116.76781, 32.8299], [-116.7678, 32.83018], [-116.76362, 32.83016], [-116.76347, 32.82769], [-116.76577, 32.8277], [-116.76578, 32.82768], [-116.76276, 32.81729], [-116.76665, 32.81623], [-116.76675, 32.81623], [-116.7668, 32.81625], [-116.76686, 32.81633], [-116.76711, 32.81955], [-116.76748, 32.81956], [-116.76773, 32.82294], [-116.77229, 32.82298]]]]} Open Access 1 Wright's Field   399 3007 Back Country Land Trust 148 Non Profit 6 Non Profit - Land Trust 10 http://www.bclt.org/ Non Governmental Organization 10 231.174 Wright's Field  
4965 4964 {"type": "Polygon", "coordinates": [[[-116.60471, 32.647], [-116.60365, 32.64701], [-116.60374, 32.65066], [-116.60273, 32.65067], [-116.60285, 32.65426], [-116.59867, 32.65421], [-116.59853, 32.65064], [-116.59431, 32.65062], [-116.594, 32.64348], [-116.60462, 32.64364], [-116.60471, 32.647]], [[-116.60259, 32.64699], [-116.6026, 32.64697], [-116.60254, 32.64525], [-116.6004, 32.64526], [-116.60046, 32.64697], [-116.60259, 32.64699]]]} Open Access 1 Hauser Mountain Wilderness Area   19739 3007 Back Country Land Trust 148 Non Profit 6 Non Profit - Land Trust 10 http://www.bclt.org/ Non Governmental Organization 10 211.412 Hauser Mtn. Wilderness Area  
6364 6363 {"type": "MultiPolygon", "coordinates": [[[[-116.56634, 32.63655], [-116.56633, 32.63969], [-116.56353, 32.63968], [-116.56358, 32.64082], [-116.56185, 32.64104], [-116.56184, 32.64021], [-116.55769, 32.64018], [-116.55772, 32.63652], [-116.56634, 32.63655]]], [[[-116.6012, 32.62905], [-116.59837, 32.62903], [-116.59317, 32.62899], [-116.59319, 32.62897], [-116.59318, 32.62895], [-116.59344, 32.62874], [-116.59351, 32.62863], [-116.59356, 32.62851], [-116.59366, 32.628], [-116.59372, 32.62789], [-116.59379, 32.6278], [-116.59502, 32.62687], [-116.59524, 32.62673], [-116.59556, 32.62659], [-116.59593, 32.62649], [-116.59665, 32.62643], [-116.59792, 32.62625], [-116.59822, 32.62623], [-116.60025, 32.62627], [-116.60052, 32.6263], [-116.60079, 32.62638], [-116.60093, 32.62639], [-116.6012, 32.62905]]]]} Unknown Access 4 Long Potrero   21450 3007 Back Country Land Trust 148 Non Profit 6 Non Profit - Land Trust 10 http://www.bclt.org/ Non Governmental Organization 10 128.139 Long Potrero  
9175 9174 {"type": "MultiPolygon", "coordinates": [[[[-116.584, 32.62899], [-116.5838, 32.62893], [-116.58043, 32.62894], [-116.58043, 32.62888], [-116.58398, 32.62886], [-116.584, 32.62899]]], [[[-116.60233, 32.63994], [-116.59384, 32.63985], [-116.59344, 32.63629], [-116.58904, 32.6363], [-116.58933, 32.63975], [-116.585, 32.63974], [-116.58464, 32.63619], [-116.58059, 32.63617], [-116.58043, 32.6291], [-116.58377, 32.62909], [-116.58401, 32.62918], [-116.58434, 32.63245], [-116.58868, 32.6325], [-116.58869, 32.63248], [-116.58834, 32.62897], [-116.59286, 32.62901], [-116.59317, 32.62899], [-116.60121, 32.62905], [-116.6016, 32.63273], [-116.60233, 32.63994]]]]} Unknown Access 4 San Diego Mountain Ranch   24856 3007 Back Country Land Trust 148 Non Profit 6 Non Profit - Land Trust 10 http://www.bclt.org/ Non Governmental Organization 10 472.038 San Diego Mtn. Ranch  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY(ACCESS_TYP) REFERENCES ACCESS_TYP(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(LAYER) REFERENCES LAYER(id)
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);