units_with_maps

Table actions

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

1 row where COUNTY = 14, MNG_AGENCY = 991 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 1 ✖

MNG_AGENCY 1

  • California Rangeland Trust · 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
12523 12523 12522 {"type": "MultiPolygon", "coordinates": [[[[-120.62587, 35.95355], [-120.61343, 35.95358], [-120.61365, 35.96403], [-120.60943, 35.96405], [-120.60936, 35.96059], [-120.60516, 35.9606], [-120.60502, 35.95011], [-120.60095, 35.95012], [-120.60099, 35.95362], [-120.59679, 35.95363], [-120.59698, 35.93941], [-120.60079, 35.9394], [-120.60075, 35.9358], [-120.60639, 35.93581], [-120.60639, 35.92859], [-120.61621, 35.92861], [-120.61644, 35.93583], [-120.62104, 35.93584], [-120.62113, 35.9394], [-120.62555, 35.93945], [-120.62587, 35.95355]]], [[[-120.69833, 35.90039], [-120.69742, 35.90191], [-120.69722, 35.90218], [-120.69702, 35.90239], [-120.69632, 35.90299], [-120.69609, 35.90316], [-120.69576, 35.90333], [-120.69503, 35.90358], [-120.69471, 35.90374], [-120.6944, 35.90395], [-120.69383, 35.90446], [-120.69357, 35.90464], [-120.69323, 35.90483], [-120.69286, 35.90497], [-120.69271, 35.90506], [-120.69255, 35.90518], [-120.69236, 35.90537], [-120.69143, 35.90667], [-120.69105, 35.90728], [-120.69077, 35.90762], [-120.68696, 35.90759], [-120.68699, 35.91081], [-120.68666, 35.91126], [-120.68635, 35.91171], [-120.68607, 35.91217], [-120.68577, 35.9127], [-120.68571, 35.91283], [-120.68568, 35.91297], [-120.68567, 35.91339], [-120.68562, 35.91353], [-120.68555, 35.91367], [-120.68545, 35.9138], [-120.68536, 35.91388], [-120.68458, 35.91442], [-120.68434, 35.91461], [-120.68412, 35.91486], [-120.68402, 35.915], [-120.68392, 35.91519], [-120.6836, 35.91613], [-120.6833, 35.91708], [-120.68326, 35.91729], [-120.68326, 35.9175], [-120.6833, 35.91802], [-120.68331, 35.91835], [-120.68331, 35.91844], [-120.68326, 35.91853], [-120.67819, 35.9164], [-120.67822, 35.91825], [-120.67737, 35.92185], [-120.67738, 35.92186], [-120.67792, 35.92187], [-120.65201, 35.93276], [-120.65199, 35.93613], [-120.64758, 35.93609], [-120.64761, 35.93787], [-120.64313, 35.93605], [-120.63429, 35.93597], [-120.63436, 35.93953], [-120.62995, 35.93949], [-120.62545, 35.93586], [-120.62506, 35.92142], [-120.62489, 35.91427], [-120.62928, 35.9143], [-120.62921, 35.91071], [-120.62481, 35.91066], [-120.62472, 35.9071], [-120.6203, 35.90706], [-120.6111, 35.90701], [-120.61109, 35.90336], [-120.61564, 35.9034], [-120.61557, 35.89975], [-120.62011, 35.89969], [-120.62012, 35.89968], [-120.62002, 35.89609], [-120.61549, 35.89615], [-120.61544, 35.889], [-120.61092, 35.889], [-120.61097, 35.88184], [-120.61519, 35.88184], [-120.61516, 35.87462], [-120.61956, 35.87464], [-120.61956, 35.87102], [-120.62405, 35.87104], [-120.62402, 35.86737], [-120.62849, 35.86739], [-120.62852, 35.87106], [-120.6375, 35.8711], [-120.63749, 35.84954], [-120.66198, 35.84961], [-120.66198, 35.84976], [-120.66237, 35.84993], [-120.66248, 35.8501], [-120.66255, 35.8503], [-120.66258, 35.85058], [-120.66261, 35.85075], [-120.66275, 35.85113], [-120.66291, 35.85144], [-120.66311, 35.85169], [-120.66358, 35.85245], [-120.66399, 35.85302], [-120.66413, 35.8532], [-120.66436, 35.85344], [-120.66447, 35.85349], [-120.66439, 35.86394], [-120.66439, 35.8676], [-120.67758, 35.86769], [-120.67755, 35.87872], [-120.68206, 35.87874], [-120.68207, 35.87964], [-120.68176, 35.87987], [-120.68153, 35.88014], [-120.68142, 35.88032], [-120.68104, 35.88117], [-120.68093, 35.88135], [-120.68078, 35.88155], [-120.68063, 35.88171], [-120.68043, 35.88189], [-120.68021, 35.88205], [-120.67991, 35.88222], [-120.67978, 35.88232], [-120.67967, 35.88245], [-120.6796, 35.88256], [-120.67954, 35.88268], [-120.67951, 35.88278], [-120.67949, 35.883], [-120.67946, 35.88309], [-120.67939, 35.88318], [-120.67927, 35.88328], [-120.67835, 35.88368], [-120.67818, 35.88373], [-120.67775, 35.88377], [-120.67752, 35.88383], [-120.67652, 35.88424], [-120.67601, 35.88449], [-120.67573, 35.88458], [-120.6754, 35.88464], [-120.6752, 35.88466], [-120.675, 35.88463], [-120.67479, 35.88455], [-120.67463, 35.88447], [-120.67444, 35.8843], [-120.67412, 35.8838], [-120.67407, 35.88374], [-120.67401, 35.88371], [-120.67389, 35.8837], [-120.67362, 35.88376], [-120.67347, 35.88383], [-120.67337, 35.88393], [-120.67329, 35.88408], [-120.67318, 35.88466], [-120.67327, 35.8894], [-120.67553, 35.88942], [-120.6755, 35.88583], [-120.6777, 35.88585], [-120.67779, 35.893], [-120.68667, 35.89306], [-120.68664, 35.8895], [-120.68888, 35.88951], [-120.68879, 35.88234], [-120.69107, 35.88235], [-120.69124, 35.89674], [-120.69565, 35.89676], [-120.6957, 35.90038], [-120.69833, 35.90039]]]]} No Public Access 3 29015 Deer Valley Ranch 18003 3012 California Rangeland Trust 1030 Non Profit 6 Non Profit - Land Trust 10 http://www.rangelandtrust.org/ Non Governmental Organization 10 3012 California Rangeland Trust 991 Non Profit 6 Non Profit - Land Trust 10   Monterey 14 12787.096 Deer Valley Ranch 0 Private Conservation 16 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]);