units_with_maps

Table actions

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

1 row where COUNTY = 37, DES_TP = 16 and MNG_AGENCY = 61

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • The Nature Conservancy · 1 ✖

DES_TP 1

  • Private Conservation · 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
4035 4035 4034 {"type": "MultiPolygon", "coordinates": [[[[-120.45073, 37.39026], [-120.45066, 37.39062], [-120.44978, 37.3913], [-120.44964, 37.39166], [-120.44963, 37.39177], [-120.44971, 37.39208], [-120.44969, 37.39223], [-120.4496, 37.39245], [-120.44956, 37.39249], [-120.4494, 37.3926], [-120.44928, 37.39264], [-120.44915, 37.39267], [-120.44898, 37.39267], [-120.44887, 37.39265], [-120.44876, 37.39268], [-120.44862, 37.39274], [-120.44824, 37.39296], [-120.448, 37.39319], [-120.44793, 37.39332], [-120.44785, 37.39363], [-120.44778, 37.39422], [-120.44774, 37.39433], [-120.44767, 37.3944], [-120.4474, 37.39456], [-120.44731, 37.39464], [-120.44696, 37.3948], [-120.44652, 37.39505], [-120.44617, 37.39533], [-120.44593, 37.39568], [-120.44584, 37.39585], [-120.44573, 37.39664], [-120.44563, 37.39702], [-120.44556, 37.39716], [-120.44495, 37.39765], [-120.44474, 37.39777], [-120.4445, 37.39803], [-120.44435, 37.39824], [-120.44423, 37.3985], [-120.44415, 37.39879], [-120.44408, 37.39918], [-120.44403, 37.39928], [-120.44398, 37.39935], [-120.44234, 37.39798], [-120.4421, 37.39773], [-120.44196, 37.39727], [-120.44198, 37.39709], [-120.44203, 37.39698], [-120.44233, 37.39669], [-120.44249, 37.39657], [-120.4426, 37.39646], [-120.4428, 37.39619], [-120.44307, 37.39591], [-120.44359, 37.39557], [-120.44427, 37.39497], [-120.44463, 37.39464], [-120.44476, 37.39449], [-120.44489, 37.3944], [-120.44511, 37.39429], [-120.44564, 37.39407], [-120.4466, 37.3936], [-120.44698, 37.39336], [-120.44724, 37.39322], [-120.4477, 37.39281], [-120.44791, 37.39258], [-120.44797, 37.39246], [-120.448, 37.39237], [-120.44801, 37.39201], [-120.44796, 37.39186], [-120.44785, 37.39169], [-120.44768, 37.39149], [-120.44752, 37.39136], [-120.447, 37.39108], [-120.44681, 37.39094], [-120.44634, 37.39055], [-120.44592, 37.39024], [-120.45073, 37.39026]]], [[[-120.46762, 37.39032], [-120.46751, 37.39099], [-120.46749, 37.39117], [-120.46731, 37.3917], [-120.46718, 37.39197], [-120.46704, 37.39223], [-120.46669, 37.39278], [-120.46633, 37.39323], [-120.46595, 37.39362], [-120.46577, 37.39378], [-120.46538, 37.39409], [-120.46509, 37.39427], [-120.46465, 37.39457], [-120.464, 37.3949], [-120.46375, 37.395], [-120.46352, 37.39507], [-120.4625, 37.39548], [-120.46169, 37.39578], [-120.46052, 37.39631], [-120.44882, 37.4009], [-120.44857, 37.40064], [-120.44815, 37.40044], [-120.44598, 37.40045], [-120.44514, 37.40026], [-120.4447, 37.40002], [-120.44422, 37.39959], [-120.44437, 37.3994], [-120.44441, 37.39932], [-120.44454, 37.39881], [-120.44455, 37.39869], [-120.44462, 37.39849], [-120.44476, 37.39825], [-120.44486, 37.39813], [-120.44502, 37.39798], [-120.44524, 37.39782], [-120.44548, 37.39768], [-120.44579, 37.39737], [-120.44594, 37.39718], [-120.44607, 37.39674], [-120.44613, 37.39627], [-120.4462, 37.39593], [-120.44625, 37.39581], [-120.44637, 37.39565], [-120.44649, 37.3955], [-120.44666, 37.39534], [-120.44686, 37.3952], [-120.44757, 37.39483], [-120.44799, 37.39456], [-120.44806, 37.39447], [-120.44813, 37.39434], [-120.44819, 37.39406], [-120.44823, 37.39353], [-120.44827, 37.39342], [-120.44842, 37.39323], [-120.44866, 37.39306], [-120.44879, 37.39299], [-120.44894, 37.39293], [-120.44908, 37.39291], [-120.44922, 37.39294], [-120.44948, 37.39289], [-120.44971, 37.39279], [-120.44986, 37.39267], [-120.44994, 37.39254], [-120.45005, 37.39233], [-120.45008, 37.39201], [-120.45002, 37.39184], [-120.45002, 37.3917], [-120.45008, 37.39148], [-120.45028, 37.39126], [-120.4504, 37.39119], [-120.45054, 37.39106], [-120.45096, 37.39076], [-120.45114, 37.39051], [-120.45126, 37.39026], [-120.46762, 37.39032]]], [[[-120.44838, 37.40109], [-120.44042, 37.40473], [-120.4399, 37.40493], [-120.43898, 37.40524], [-120.43183, 37.40743], [-120.42601, 37.40928], [-120.41975, 37.41149], [-120.41879, 37.41184], [-120.41804, 37.41215], [-120.41762, 37.4123], [-120.41259, 37.41351], [-120.40441, 37.41558], [-120.39843, 37.41704], [-120.39543, 37.41772], [-120.39556, 37.40447], [-120.39562, 37.39007], [-120.41363, 37.39018], [-120.41622, 37.39017], [-120.41625, 37.38497], [-120.41983, 37.38494], [-120.42338, 37.38502], [-120.42468, 37.38503], [-120.42569, 37.38521], [-120.42786, 37.38635], [-120.42788, 37.38745], [-120.43184, 37.38753], [-120.4318, 37.39016], [-120.44527, 37.39024], [-120.44646, 37.39126], [-120.44732, 37.39181], [-120.44749, 37.39206], [-120.44746, 37.39238], [-120.44684, 37.39296], [-120.44441, 37.3942], [-120.44326, 37.39526], [-120.44254, 37.39576], [-120.44201, 37.39642], [-120.44156, 37.39686], [-120.44147, 37.39705], [-120.44147, 37.39738], [-120.44163, 37.3979], [-120.44197, 37.39828], [-120.44378, 37.39978], [-120.44435, 37.40036], [-120.44487, 37.40061], [-120.44557, 37.4008], [-120.44611, 37.40086], [-120.44802, 37.40084], [-120.44819, 37.40092], [-120.44838, 37.40109]]]]} No Public Access 3 46975 Merced Grasslands 30608 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   Merced 37 3044.962 Merced Grasslands 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]);