units_with_maps

Table actions

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

8 rows where COUNTY = 48 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, LABEL_NAME

DES_TP 4

ACCESS_TYP 2

MNG_AG_TYP 1

  • Non Profit - Land Trust · 8 ✖
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
2239 2239 2238 {"type": "Polygon", "coordinates": [[[-119.81102, 36.87326], [-119.80959, 36.87329], [-119.8096, 36.87351], [-119.81007, 36.87379], [-119.81022, 36.87384], [-119.81101, 36.87381], [-119.81092, 36.88017], [-119.80915, 36.88029], [-119.80178, 36.8809], [-119.79911, 36.88089], [-119.80337, 36.87899], [-119.80477, 36.87934], [-119.80542, 36.8792], [-119.8063, 36.87931], [-119.8063, 36.8783], [-119.80622, 36.87802], [-119.80565, 36.87825], [-119.80549, 36.8785], [-119.80516, 36.87785], [-119.79392, 36.8778], [-119.79337, 36.87782], [-119.79334, 36.87681], [-119.79332, 36.8768], [-119.7933, 36.87682], [-119.79325, 36.87549], [-119.79577, 36.8744], [-119.80082, 36.87025], [-119.80215, 36.86845], [-119.80261, 36.86797], [-119.80445, 36.86616], [-119.80599, 36.86497], [-119.80929, 36.86355], [-119.80935, 36.86353], [-119.81041, 36.86422], [-119.81111, 36.86607], [-119.81102, 36.87326]]]} Unknown Access 4 16693 Van Buren Unit 26820 2345 Tehachapi-Cummings County Water District 499 Special District 4 Water District 13 http://tccwd.com/ Special District 4 3069 San Joaquin River Parkway and Conservation Trust 491 Non Profit 6 Non Profit - Land Trust 10   Madera 48 433.198 Van Buren Unit   None 186  
3494 3494 3493 {"type": "Polygon", "coordinates": [[[-119.92013, 36.84814], [-119.9201, 36.84889], [-119.91933, 36.84892], [-119.91621, 36.84954], [-119.91557, 36.84957], [-119.91467, 36.84879], [-119.91115, 36.8488], [-119.91115, 36.85122], [-119.91068, 36.85129], [-119.91054, 36.85133], [-119.90847, 36.8513], [-119.90649, 36.85002], [-119.90733, 36.84921], [-119.90775, 36.84888], [-119.90795, 36.84855], [-119.90816, 36.84837], [-119.90879, 36.848], [-119.90911, 36.84784], [-119.90954, 36.8475], [-119.90997, 36.84724], [-119.91042, 36.84702], [-119.91072, 36.84679], [-119.91172, 36.8464], [-119.91209, 36.84619], [-119.91244, 36.84606], [-119.91285, 36.84585], [-119.91314, 36.84576], [-119.91372, 36.84572], [-119.91435, 36.84574], [-119.91473, 36.84573], [-119.91559, 36.84561], [-119.91563, 36.84814], [-119.92013, 36.84814]]]} Unknown Access 4 25925 Schneider Property 25187 3069 San Joaquin River Parkway and Conservation Trust 649 Non Profit 6 Non Profit - Land Trust 10 http://www.riverparkway.org Non Governmental Organization 10 3069 San Joaquin River Parkway and Conservation Trust 491 Non Profit 6 Non Profit - Land Trust 10   Madera 48 77.528 Schneider Property 0 Private Conservation 16 2
12279 12279 12278 {"type": "Polygon", "coordinates": [[[-119.74413, 36.95238], [-119.73643, 36.95242], [-119.73532, 36.95037], [-119.73417, 36.94855], [-119.73385, 36.94778], [-119.73382, 36.94705], [-119.73448, 36.94596], [-119.73557, 36.94502], [-119.73691, 36.94458], [-119.738, 36.94429], [-119.73914, 36.94436], [-119.7401, 36.94453], [-119.74133, 36.94424], [-119.74239, 36.94352], [-119.7435, 36.94216], [-119.74386, 36.94241], [-119.74413, 36.95238]]]} Unknown Access 4 25928 Ledger Island 21130 2345 Tehachapi-Cummings County Water District 499 Special District 4 Water District 13 http://tccwd.com/ Special District 4 3069 San Joaquin River Parkway and Conservation Trust 491 Non Profit 6 Non Profit - Land Trust 10   Madera 48 184.827 Ledger Island   None 1072  
12283 12283 12282 {"type": "Polygon", "coordinates": [[[-119.73125, 36.98478], [-119.73073, 36.98528], [-119.72986, 36.98556], [-119.72892, 36.9862], [-119.72812, 36.98615], [-119.72732, 36.98671], [-119.72713, 36.98843], [-119.72603, 36.98868], [-119.72487, 36.99101], [-119.72383, 36.99097], [-119.72294, 36.99154], [-119.72257, 36.99189], [-119.72123, 36.99292], [-119.72037, 36.99324], [-119.71923, 36.99432], [-119.71902, 36.99486], [-119.71869, 36.99531], [-119.71453, 36.9918], [-119.71485, 36.99148], [-119.71495, 36.99127], [-119.71539, 36.99089], [-119.71615, 36.99035], [-119.71649, 36.99027], [-119.71675, 36.99029], [-119.71709, 36.99018], [-119.71734, 36.99008], [-119.71707, 36.99034], [-119.71691, 36.99053], [-119.71644, 36.99085], [-119.71607, 36.99103], [-119.716, 36.9911], [-119.71601, 36.99112], [-119.7161, 36.99111], [-119.71634, 36.99099], [-119.71667, 36.99078], [-119.71696, 36.99057], [-119.71716, 36.9904], [-119.71734, 36.99018], [-119.71756, 36.99005], [-119.71786, 36.98983], [-119.71812, 36.98976], [-119.71841, 36.98965], [-119.71879, 36.98943], [-119.71938, 36.98901], [-119.72004, 36.9887], [-119.72093, 36.98816], [-119.72121, 36.98794], [-119.72144, 36.98772], [-119.72232, 36.98703], [-119.72335, 36.98634], [-119.72393, 36.98604], [-119.72431, 36.98577], [-119.7243, 36.98575], [-119.72418, 36.98575], [-119.72431, 36.98567], [-119.72443, 36.98546], [-119.72464, 36.98524], [-119.72514, 36.98512], [-119.7254, 36.98495], [-119.72531, 36.98452], [-119.72543, 36.98436], [-119.72601, 36.98431], [-119.72649, 36.98424], [-119.7268, 36.98407], [-119.72708, 36.98388], [-119.72723, 36.98375], [-119.7277, 36.98344], [-119.72824, 36.98301], [-119.72864, 36.98276], [-119.72918, 36.98246], [-119.73125, 36.98478]], [[-119.72523, 36.9884], [-119.72525, 36.98842], [-119.72562, 36.98816], [-119.72578, 36.98798], [-119.72553, 36.98814], [-119.72523, 36.9884]]]} Unknown Access 4 25931 River Vista 24429 3069 San Joaquin River Parkway and Conservation Trust 649 Non Profit 6 Non Profit - Land Trust 10 http://www.riverparkway.org Non Governmental Organization 10 3069 San Joaquin River Parkway and Conservation Trust 491 Non Profit 6 Non Profit - Land Trust 10   Madera 48 160.718 River Vista 0 Private Conservation 16 2
12430 12430 12429 {"type": "Polygon", "coordinates": [[[-119.71821, 36.9953], [-119.71722, 36.99589], [-119.71659, 36.99671], [-119.71588, 36.99675], [-119.7158, 36.99679], [-119.71468, 36.99589], [-119.71464, 36.99589], [-119.71464, 36.99591], [-119.71575, 36.9968], [-119.71547, 36.9969], [-119.71513, 36.99758], [-119.71582, 36.99857], [-119.71483, 36.99866], [-119.71447, 36.99918], [-119.71168, 37.00082], [-119.71099, 37.00163], [-119.70974, 37.00139], [-119.70892, 37.00087], [-119.70902, 36.99762], [-119.71017, 36.99591], [-119.71021, 36.9959], [-119.71069, 36.99548], [-119.71091, 36.99527], [-119.71103, 36.99513], [-119.7143, 36.99202], [-119.71821, 36.9953]]]} Unknown Access 4 27038 Wagner 27208 3069 San Joaquin River Parkway and Conservation Trust 649 Non Profit 6 Non Profit - Land Trust 10 http://www.riverparkway.org Non Governmental Organization 10 3069 San Joaquin River Parkway and Conservation Trust 491 Non Profit 6 Non Profit - Land Trust 10   Madera 48 110.701 Wagner 0 Private Conservation 16 2
12680 12680 12679 {"type": "Polygon", "coordinates": [[[-119.91557, 36.85121], [-119.91115, 36.85122], [-119.91114, 36.8488], [-119.91467, 36.84879], [-119.91557, 36.84957], [-119.91557, 36.85121]]]} Open Access 1 29652 Schneider Property 25186 3069 San Joaquin River Parkway and Conservation Trust 649 Non Profit 6 Non Profit - Land Trust 10 http://www.riverparkway.org Non Governmental Organization 10 3069 San Joaquin River Parkway and Conservation Trust 491 Non Profit 6 Non Profit - Land Trust 10   Madera 48 25.334 Schneider Property 0 Private Conservation 16 2
14374 14374 14373 {"type": "Polygon", "coordinates": [[[-119.66327, 37.0625], [-119.66314, 37.06353], [-119.66138, 37.0647], [-119.65862, 37.06474], [-119.65876, 37.07194], [-119.64975, 37.0721], [-119.64984, 37.07601], [-119.64542, 37.07604], [-119.64531, 37.07218], [-119.64087, 37.07225], [-119.64076, 37.0686], [-119.64049, 37.053], [-119.64067, 37.05309], [-119.64084, 37.05329], [-119.64091, 37.05368], [-119.64137, 37.05397], [-119.64155, 37.05409], [-119.64166, 37.05429], [-119.64168, 37.05442], [-119.64189, 37.05453], [-119.64209, 37.05451], [-119.64242, 37.05471], [-119.64319, 37.05515], [-119.64338, 37.05528], [-119.64368, 37.05533], [-119.64414, 37.05549], [-119.64445, 37.05564], [-119.64456, 37.05593], [-119.64467, 37.05587], [-119.64518, 37.05592], [-119.64575, 37.05609], [-119.64606, 37.05627], [-119.64647, 37.0567], [-119.64632, 37.05755], [-119.64625, 37.0577], [-119.64649, 37.05762], [-119.64746, 37.05767], [-119.64828, 37.05787], [-119.64877, 37.05812], [-119.64917, 37.05849], [-119.64981, 37.059], [-119.64991, 37.05929], [-119.64999, 37.05943], [-119.64993, 37.05955], [-119.65011, 37.0597], [-119.65024, 37.05986], [-119.65022, 37.06019], [-119.65016, 37.06064], [-119.65058, 37.06084], [-119.6507, 37.06075], [-119.65074, 37.06087], [-119.65113, 37.06158], [-119.65127, 37.06211], [-119.65114, 37.0625], [-119.65108, 37.063], [-119.65074, 37.06296], [-119.65049, 37.063], [-119.65052, 37.06319], [-119.65116, 37.06333], [-119.65152, 37.06315], [-119.65151, 37.06273], [-119.65166, 37.06234], [-119.65174, 37.06197], [-119.65093, 37.06041], [-119.65092, 37.06034], [-119.65094, 37.06009], [-119.65099, 37.05981], [-119.6508, 37.05948], [-119.65095, 37.05925], [-119.65064, 37.05925], [-119.65048, 37.05896], [-119.65048, 37.05875], [-119.65036, 37.05826], [-119.65003, 37.05815], [-119.64985, 37.05791], [-119.64996, 37.05748], [-119.64973, 37.05721], [-119.64972, 37.05698], [-119.64952, 37.05698], [-119.64932, 37.05686], [-119.64903, 37.05672], [-119.64899, 37.05653], [-119.64873, 37.05661], [-119.64832, 37.05646], [-119.64797, 37.05623], [-119.6478, 37.05604], [-119.64751, 37.05606], [-119.64684, 37.05557], [-119.64648, 37.05521], [-119.64632, 37.05497], [-119.64616, 37.05498], [-119.64605, 37.05492], [-119.64586, 37.05475], [-119.64566, 37.05477], [-119.64545, 37.05476], [-119.64466, 37.05454], [-119.6443, 37.05433], [-119.64417, 37.05419], [-119.64383, 37.0541], [-119.64187, 37.05206], [-119.64172, 37.05176], [-119.64163, 37.05133], [-119.64169, 37.05115], [-119.64213, 37.05093], [-119.64393, 37.05058], [-119.64468, 37.05119], [-119.64492, 37.05133], [-119.64411, 37.052], [-119.64408, 37.05209], [-119.64449, 37.05224], [-119.64459, 37.05232], [-119.64473, 37.05273], [-119.64537, 37.05225], [-119.64593, 37.05232], [-119.64594, 37.05245], [-119.64589, 37.05279], [-119.64632, 37.05262], [-119.64668, 37.05269], [-119.64683, 37.0533], [-119.64729, 37.05316], [-119.64884, 37.05419], [-119.64893, 37.0543], [-119.649, 37.05436], [-119.64916, 37.05442], [-119.64937, 37.05445], [-119.64961, 37.05443], [-119.64984, 37.05438], [-119.64999, 37.05439], [-119.65031, 37.05447], [-119.6505, 37.05446], [-119.65089, 37.05442], [-119.65109, 37.05444], [-119.65197, 37.05508], [-119.65199, 37.06247], [-119.6541, 37.06247], [-119.65525, 37.06358], [-119.65853, 37.06243], [-119.66327, 37.0625]]]} Open Access 1 44460 Austin and Mary Ewell Fine Gold Creek Preserve 29215 3077 Sierra Foothill Conservancy 323 Non Profit 6 Non Profit - Land Trust 10 http://www.sierrafoothill.org/ Non Governmental Organization 10 3077 Sierra Foothill Conservancy 320 Non Profit 6 Non Profit - Land Trust 10 http://awww.sierrafoothill.org/index.php/land/preserves/austin-mary-ewell-preserve Madera 48 703.543 Austin and Mary Ewell Fine Gold Creek Preserve 0 Private Conservation 16 2
14744 14744 14743 {"type": "Polygon", "coordinates": [[[-119.83687, 36.85657], [-119.83636, 36.85653], [-119.83406, 36.8556], [-119.83382, 36.85617], [-119.83164, 36.85548], [-119.82956, 36.85467], [-119.82958, 36.85894], [-119.82911, 36.85877], [-119.82676, 36.85836], [-119.82546, 36.85798], [-119.82482, 36.85787], [-119.82444, 36.85787], [-119.82146, 36.85849], [-119.82124, 36.85821], [-119.82014, 36.85846], [-119.82014, 36.85839], [-119.82013, 36.85838], [-119.81682, 36.85918], [-119.8161, 36.85969], [-119.81549, 36.85966], [-119.81521, 36.85915], [-119.8137, 36.85798], [-119.8133, 36.85721], [-119.8141, 36.85621], [-119.81385, 36.85511], [-119.81452, 36.85355], [-119.81774, 36.85268], [-119.81816, 36.85175], [-119.81874, 36.85089], [-119.81827, 36.85053], [-119.81819, 36.84968], [-119.82062, 36.84889], [-119.82609, 36.8502], [-119.82888, 36.85138], [-119.82982, 36.85209], [-119.83077, 36.85256], [-119.83253, 36.85338], [-119.8334, 36.85372], [-119.83687, 36.85657]]]} Open Access 1 45120 Sycamore Island 26131 233 San Joaquin River Conservancy 827 State 5 State Agency 5 http://sjrc.ca.gov/ Other State 5 3069 San Joaquin River Parkway and Conservation Trust 491 Non Profit 6 Non Profit - Land Trust 10   Madera 48 328.657 Sycamore Island   None 1264  

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]);