units_with_maps

Table actions

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

2 rows where ACCESS_TYP = 2, COUNTY = 2 and DES_TP = 16

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Private Conservation · 2 ✖

ACCESS_TYP 1

  • Restricted Access · 2 ✖
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
10342 10342 10341 {"type": "Polygon", "coordinates": [[[-120.57202, 37.62727], [-120.57198, 37.62916], [-120.56928, 37.6295], [-120.56863, 37.63018], [-120.56928, 37.63226], [-120.56871, 37.633], [-120.56806, 37.63368], [-120.56624, 37.63436], [-120.56413, 37.63468], [-120.56335, 37.63476], [-120.56189, 37.63452], [-120.56149, 37.63442], [-120.56023, 37.63381], [-120.55943, 37.63315], [-120.5586, 37.63254], [-120.55856, 37.63213], [-120.55757, 37.6314], [-120.55568, 37.63142], [-120.55362, 37.63294], [-120.54986, 37.63346], [-120.5458, 37.6323], [-120.54181, 37.632], [-120.5384, 37.63133], [-120.53578, 37.6313], [-120.53577, 37.62815], [-120.53664, 37.62825], [-120.53986, 37.62737], [-120.54071, 37.62764], [-120.54226, 37.62771], [-120.54354, 37.62769], [-120.54359, 37.62723], [-120.54357, 37.62637], [-120.54507, 37.62495], [-120.54887, 37.62484], [-120.54891, 37.62363], [-120.56284, 37.62365], [-120.56284, 37.62717], [-120.57202, 37.62727]]]} Restricted Access 2 18243 Bobcat Flat 16214 3026 Friends of the Tuolumne 948 Non Profit 6 Non Profit - Conservation 12 http://www.friendsofthetuolumne.org Non Governmental Organization 10 3026 Friends of the Tuolumne 920 Non Profit 6 Non Profit - Conservation 12   Stanislaus 2 601.538 Bobcat Flat 0 Private Conservation 16 2
14355 14355 14354 {"type": "Polygon", "coordinates": [[[-121.17744, 37.60579], [-121.17736, 37.60597], [-121.17728, 37.60603], [-121.17707, 37.60609], [-121.17683, 37.60609], [-121.17638, 37.60601], [-121.17508, 37.60553], [-121.17465, 37.60545], [-121.17401, 37.60516], [-121.17283, 37.60475], [-121.17251, 37.60448], [-121.17234, 37.6044], [-121.17206, 37.60435], [-121.17177, 37.60439], [-121.17086, 37.60473], [-121.17049, 37.6049], [-121.17019, 37.60519], [-121.16969, 37.60581], [-121.1695, 37.60618], [-121.16863, 37.60742], [-121.16844, 37.6078], [-121.16796, 37.60817], [-121.16769, 37.60844], [-121.16758, 37.60865], [-121.16732, 37.60892], [-121.16726, 37.60907], [-121.16728, 37.60932], [-121.1673, 37.60955], [-121.16742, 37.60995], [-121.16742, 37.61022], [-121.16763, 37.61074], [-121.16786, 37.61118], [-121.1679, 37.61136], [-121.16788, 37.61154], [-121.16771, 37.61217], [-121.16759, 37.61235], [-121.16688, 37.61303], [-121.16643, 37.61334], [-121.16539, 37.61363], [-121.16516, 37.61373], [-121.16448, 37.61394], [-121.16402, 37.61399], [-121.16278, 37.61398], [-121.1619, 37.61413], [-121.16134, 37.61416], [-121.16111, 37.61414], [-121.16066, 37.61425], [-121.15967, 37.61467], [-121.15928, 37.61479], [-121.15911, 37.61486], [-121.15837, 37.61491], [-121.15756, 37.61477], [-121.15682, 37.61452], [-121.15635, 37.61428], [-121.15595, 37.61386], [-121.15585, 37.61372], [-121.15568, 37.61321], [-121.15546, 37.61282], [-121.15547, 37.61239], [-121.15558, 37.61194], [-121.15581, 37.6115], [-121.15604, 37.61123], [-121.15614, 37.61105], [-121.15635, 37.61048], [-121.15635, 37.61003], [-121.15628, 37.6096], [-121.15597, 37.60913], [-121.15557, 37.60884], [-121.15536, 37.60874], [-121.15464, 37.60861], [-121.15396, 37.60852], [-121.15295, 37.60827], [-121.15273, 37.60819], [-121.15192, 37.608], [-121.15154, 37.60787], [-121.15092, 37.60758], [-121.15053, 37.60732], [-121.15018, 37.60695], [-121.14939, 37.60647], [-121.14898, 37.60628], [-121.14848, 37.60623], [-121.14793, 37.60619], [-121.14748, 37.60626], [-121.1461, 37.60659], [-121.14503, 37.60678], [-121.14455, 37.60704], [-121.14432, 37.60712], [-121.14397, 37.60717], [-121.14341, 37.60717], [-121.14319, 37.60704], [-121.14287, 37.60673], [-121.14288, 37.60613], [-121.1427, 37.6056], [-121.14267, 37.6047], [-121.14276, 37.60462], [-121.14265, 37.60447], [-121.14223, 37.60327], [-121.14179, 37.60253], [-121.14155, 37.60185], [-121.14132, 37.60157], [-121.14117, 37.60149], [-121.14161, 37.60116], [-121.14239, 37.60117], [-121.14285, 37.60069], [-121.14466, 37.60018], [-121.14498, 37.59964], [-121.14542, 37.59926], [-121.14584, 37.59841], [-121.14576, 37.59774], [-121.14606, 37.59758], [-121.14585, 37.597], [-121.14515, 37.59634], [-121.14305, 37.59483], [-121.1465, 37.59484], [-121.1467, 37.59413], [-121.14689, 37.59386], [-121.14728, 37.5919], [-121.1472, 37.5908], [-121.1471, 37.58988], [-121.14712, 37.58915], [-121.14673, 37.58759], [-121.17067, 37.58736], [-121.17111, 37.58795], [-121.17124, 37.5883], [-121.1713, 37.58952], [-121.17113, 37.59029], [-121.17109, 37.59083], [-121.17103, 37.59088], [-121.17117, 37.59159], [-121.17141, 37.59209], [-121.17147, 37.59236], [-121.17164, 37.59278], [-121.17214, 37.5932], [-121.17245, 37.59326], [-121.1729, 37.59326], [-121.17347, 37.59336], [-121.17421, 37.59337], [-121.17562, 37.59347], [-121.17577, 37.59351], [-121.17612, 37.59381], [-121.17626, 37.59399], [-121.17636, 37.59417], [-121.17641, 37.59435], [-121.17641, 37.59444], [-121.17627, 37.59513], [-121.17565, 37.59593], [-121.17544, 37.59606], [-121.17464, 37.59642], [-121.17385, 37.59664], [-121.17304, 37.59675], [-121.17214, 37.59681], [-121.17191, 37.59686], [-121.17131, 37.59692], [-121.17056, 37.59717], [-121.17016, 37.59742], [-121.17, 37.59761], [-121.16988, 37.59779], [-121.16976, 37.59812], [-121.16975, 37.59851], [-121.16983, 37.59886], [-121.17021, 37.59941], [-121.1704, 37.59958], [-121.17061, 37.59971], [-121.17139, 37.60008], [-121.17162, 37.60015], [-121.17224, 37.60024], [-121.1725, 37.60025], [-121.17309, 37.6001], [-121.17366, 37.60001], [-121.1739, 37.59991], [-121.17469, 37.59949], [-121.17526, 37.59914], [-121.17637, 37.5983], [-121.17671, 37.59814], [-121.17688, 37.59809], [-121.17726, 37.59809], [-121.17781, 37.59825], [-121.17798, 37.59833], [-121.17849, 37.59868], [-121.17862, 37.59885], [-121.17887, 37.59931], [-121.17888, 37.59949], [-121.17886, 37.59958], [-121.17875, 37.59975], [-121.17855, 37.59991], [-121.17805, 37.60022], [-121.17728, 37.60091], [-121.1769, 37.60131], [-121.17668, 37.60147], [-121.17653, 37.60163], [-121.17608, 37.60243], [-121.17604, 37.60261], [-121.17607, 37.60298], [-121.17602, 37.60302], [-121.17608, 37.6031], [-121.17598, 37.60346], [-121.17623, 37.60417], [-121.17632, 37.60435], [-121.17687, 37.60511], [-121.17725, 37.60551], [-121.17739, 37.60555], [-121.17736, 37.60561], [-121.17744, 37.60579]]]} Restricted Access 2 44406 Dos Rios Ranch 18230 3205 River Partners 1110 Non Profit 6 Non Profit - Conservation 12 http://riverpartners.org/ Non Governmental Organization 10 3205 River Partners 1064 Non Profit 6 Non Profit - Conservation 12   Stanislaus 2 1563.144 Dos Rios 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]);