units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 1, COUNTY = 48 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 3 ✖
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
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]);