units_with_maps

Table actions

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

1 row where MNG_AGENCY = 61 and UNIT_NAME = "Tollhouse Ranch"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • The Nature Conservancy · 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
13185 13185 13184 {"type": "MultiPolygon", "coordinates": [[[[-118.59104, 35.32353], [-118.59099, 35.32371], [-118.58708, 35.32375], [-118.58667, 35.31695], [-118.5869, 35.31694], [-118.58713, 35.31713], [-118.58718, 35.31724], [-118.58729, 35.31759], [-118.58741, 35.31776], [-118.58756, 35.31802], [-118.58763, 35.31823], [-118.58772, 35.31841], [-118.5886, 35.31904], [-118.58878, 35.31913], [-118.58884, 35.31914], [-118.589, 35.31941], [-118.589, 35.31968], [-118.58897, 35.31994], [-118.58899, 35.32007], [-118.58924, 35.32049], [-118.58955, 35.32076], [-118.58963, 35.32081], [-118.59081, 35.32135], [-118.59144, 35.32182], [-118.59153, 35.32192], [-118.59157, 35.32199], [-118.59158, 35.32209], [-118.59153, 35.32247], [-118.59145, 35.32285], [-118.59134, 35.3231], [-118.59104, 35.32353]]], [[[-118.64705, 35.29674], [-118.65023, 35.29942], [-118.65264, 35.29586], [-118.65316, 35.296], [-118.65338, 35.29609], [-118.65365, 35.29621], [-118.65399, 35.29642], [-118.65448, 35.29678], [-118.65469, 35.2969], [-118.65488, 35.29699], [-118.65517, 35.29709], [-118.65547, 35.29715], [-118.65601, 35.29717], [-118.65629, 35.29715], [-118.65657, 35.29711], [-118.65714, 35.29698], [-118.6576, 35.2968], [-118.65822, 35.29648], [-118.65855, 35.29633], [-118.65902, 35.29618], [-118.65945, 35.29609], [-118.66, 35.2961], [-118.66059, 35.29615], [-118.66107, 35.29624], [-118.66173, 35.29639], [-118.66221, 35.29647], [-118.66269, 35.2965], [-118.66314, 35.29649], [-118.66369, 35.29642], [-118.66424, 35.2963], [-118.66684, 35.29545], [-118.66711, 35.29537], [-118.66745, 35.2953], [-118.66794, 35.29524], [-118.66837, 35.29534], [-118.66871, 35.29548], [-118.66901, 35.29568], [-118.66924, 35.29589], [-118.66943, 35.29615], [-118.6696, 35.29649], [-118.66968, 35.29677], [-118.66971, 35.29707], [-118.6697, 35.29733], [-118.66962, 35.29779], [-118.6696, 35.29812], [-118.66961, 35.29853], [-118.66964, 35.29877], [-118.66968, 35.29892], [-118.66983, 35.29933], [-118.67004, 35.29972], [-118.6703, 35.30009], [-118.67067, 35.30047], [-118.67158, 35.30114], [-118.6721, 35.30165], [-118.67313, 35.30215], [-118.67388, 35.3025], [-118.67456, 35.30284], [-118.67729, 35.30379], [-118.67789, 35.30419], [-118.67796, 35.30431], [-118.6781, 35.30449], [-118.67837, 35.30479], [-118.6787, 35.30506], [-118.67888, 35.30517], [-118.67909, 35.30528], [-118.67928, 35.30542], [-118.68021, 35.30639], [-118.68055, 35.30658], [-118.68086, 35.3067], [-118.68119, 35.30677], [-118.68165, 35.30682], [-118.68151, 35.31152], [-118.67772, 35.31163], [-118.6687, 35.31182], [-118.66499, 35.31185], [-118.66498, 35.31186], [-118.66925, 35.31552], [-118.6827, 35.3268], [-118.6952, 35.33745], [-118.69952, 35.34108], [-118.701, 35.3551], [-118.68389, 35.35508], [-118.64895, 35.35513], [-118.64892, 35.36236], [-118.64008, 35.36232], [-118.63998, 35.35873], [-118.63153, 35.3588], [-118.6315, 35.36242], [-118.63151, 35.36596], [-118.63148, 35.36966], [-118.61402, 35.36968], [-118.59651, 35.36976], [-118.59704, 35.36251], [-118.59782, 35.35508], [-118.59703, 35.34493], [-118.59698, 35.34154], [-118.59684, 35.33786], [-118.59636, 35.33069], [-118.59604, 35.32369], [-118.59119, 35.3237], [-118.59121, 35.32362], [-118.59152, 35.32317], [-118.59164, 35.32288], [-118.59173, 35.32249], [-118.59178, 35.32209], [-118.59176, 35.32196], [-118.59172, 35.32186], [-118.59159, 35.32171], [-118.59094, 35.32121], [-118.58974, 35.32067], [-118.5894, 35.32038], [-118.58918, 35.32003], [-118.5892, 35.31939], [-118.589, 35.31903], [-118.58896, 35.319], [-118.58887, 35.31898], [-118.58872, 35.31891], [-118.58788, 35.31831], [-118.58774, 35.31795], [-118.58758, 35.31767], [-118.58747, 35.31752], [-118.58734, 35.31711], [-118.58729, 35.31703], [-118.58718, 35.31693], [-118.5955, 35.31662], [-118.59494, 35.30959], [-118.59443, 35.30271], [-118.59419, 35.30003], [-118.5972, 35.30065], [-118.59738, 35.30067], [-118.59767, 35.30068], [-118.59938, 35.30066], [-118.6001, 35.30064], [-118.60064, 35.30055], [-118.602, 35.30024], [-118.60222, 35.30016], [-118.60239, 35.30008], [-118.60253, 35.29999], [-118.60269, 35.29986], [-118.60327, 35.29929], [-118.60347, 35.29904], [-118.60364, 35.29875], [-118.60382, 35.29854], [-118.60402, 35.29837], [-118.60426, 35.29822], [-118.60544, 35.29768], [-118.60573, 35.29757], [-118.60604, 35.29748], [-118.60642, 35.2974], [-118.60654, 35.2974], [-118.60669, 35.29741], [-118.60686, 35.29747], [-118.60749, 35.29783], [-118.60764, 35.2979], [-118.60797, 35.298], [-118.60824, 35.29804], [-118.6086, 35.29803], [-118.60907, 35.29799], [-118.60938, 35.29794], [-118.60975, 35.29785], [-118.61121, 35.2973], [-118.6149, 35.29573], [-118.61521, 35.29555], [-118.61545, 35.29536], [-118.61558, 35.29523], [-118.61577, 35.29498], [-118.61594, 35.29479], [-118.61616, 35.29459], [-118.61637, 35.29444], [-118.61664, 35.29428], [-118.61694, 35.29416], [-118.61734, 35.29402], [-118.61781, 35.2939], [-118.61803, 35.29388], [-118.61835, 35.29388], [-118.61902, 35.29395], [-118.61948, 35.29395], [-118.61969, 35.29392], [-118.61998, 35.29387], [-118.62021, 35.29379], [-118.62047, 35.29369], [-118.62115, 35.2953], [-118.62806, 35.29302], [-118.63162, 35.29188], [-118.63113, 35.29065], [-118.63242, 35.29027], [-118.63475, 35.29035], [-118.63508, 35.29051], [-118.6356, 35.29081], [-118.63733, 35.2919], [-118.63913, 35.29298], [-118.63994, 35.29344], [-118.64068, 35.29381], [-118.64102, 35.29392], [-118.64176, 35.29409], [-118.64244, 35.29404], [-118.64298, 35.29411], [-118.64423, 35.29439], [-118.64608, 35.29595], [-118.64705, 35.29674]]]]} No Public Access 3 35171 Tollhouse Ranch 30620 3091 The Nature Conservancy 63 Non Profit 6 Non Profit - Land Trust 10 http://www.nature.org/ Non Governmental Organization 10 3091 The Nature Conservancy 61 Non Profit 6 Non Profit - Land Trust 10   Kern 36 14760.375 Tollhouse 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]);