units_with_maps

Table actions

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

5 rows where ACCESS_TYP = 2, COUNTY = 4 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_TYP, YR_EST

MNG_AG_TYP 1

  • Non Profit - Land Trust · 5 ✖

ACCESS_TYP 1

  • Restricted Access · 5 ✖
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
1578 1578 1577 {"type": "Polygon", "coordinates": [[[-117.18285, 33.40983], [-117.18281, 33.41292], [-117.17805, 33.4133], [-117.17813, 33.40996], [-117.18285, 33.40983]]]} Restricted Access 2 47760 Rainbow Preserve 31565 7024 Land to Sea Conservancy 388 Non Profit 6 Non Profit - Conservation 12 http://www.landtosea.org/index.html Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 38.788 Rainbow Preserve 0 Private Conservation 16 2
4216 4216 4215 {"type": "Polygon", "coordinates": [[[-117.39755, 33.44539], [-117.38308, 33.44537], [-117.36359, 33.44529], [-117.36342, 33.43052], [-117.38823, 33.43027], [-117.389, 33.43025], [-117.38944, 33.43083], [-117.39484, 33.43788], [-117.39755, 33.44539]]]} Restricted Access 2 47758 Margarita Peak Preserve 31564 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 1165.479 Margarita Peak Preserve 0 Private Conservation 16 2
6251 6251 6250 {"type": "MultiPolygon", "coordinates": [[[[-116.68093, 32.60085], [-116.68055, 32.60089], [-116.68054, 32.60089], [-116.68054, 32.60089], [-116.68093, 32.60085]]], [[[-116.68153, 32.60102], [-116.68153, 32.60106], [-116.68151, 32.60109], [-116.68151, 32.60109], [-116.68151, 32.6011], [-116.6815, 32.60111], [-116.68153, 32.60102], [-116.68152, 32.60097], [-116.68149, 32.60092], [-116.68139, 32.60088], [-116.68144, 32.60089], [-116.68147, 32.6009], [-116.68149, 32.60092], [-116.68152, 32.60097], [-116.68153, 32.60102]]], [[[-116.68378, 32.60165], [-116.68372, 32.60158], [-116.68369, 32.60157], [-116.68364, 32.60157], [-116.68358, 32.60161], [-116.68362, 32.60158], [-116.68364, 32.60157], [-116.68366, 32.60157], [-116.68369, 32.60157], [-116.68372, 32.60158], [-116.68375, 32.60159], [-116.68378, 32.60165]]], [[[-116.68386, 32.60207], [-116.68385, 32.60192], [-116.68383, 32.60185], [-116.68384, 32.60189], [-116.68386, 32.60194], [-116.68386, 32.60207]]], [[[-116.68386, 32.60209], [-116.68386, 32.60209], [-116.68386, 32.60211], [-116.68386, 32.60209]]], [[[-116.68202, 32.6024], [-116.68181, 32.60235], [-116.68154, 32.60236], [-116.68179, 32.60235], [-116.68182, 32.60236], [-116.68187, 32.60236], [-116.68202, 32.6024]]], [[[-116.68384, 32.60247], [-116.68384, 32.60249], [-116.68383, 32.60251], [-116.68383, 32.60251], [-116.68384, 32.60247]]], [[[-116.68435, 32.60337], [-116.68425, 32.60331], [-116.68408, 32.60322], [-116.68422, 32.60329], [-116.68432, 32.60334], [-116.68435, 32.60337]]], [[[-116.68439, 32.6034], [-116.68438, 32.60339], [-116.68438, 32.60339], [-116.68439, 32.6034]]], [[[-116.68669, 32.60192], [-116.68659, 32.60417], [-116.68563, 32.60407], [-116.68538, 32.604], [-116.68518, 32.60389], [-116.68441, 32.60326], [-116.68397, 32.60303], [-116.68394, 32.60299], [-116.68386, 32.60281], [-116.68385, 32.60276], [-116.68397, 32.60248], [-116.68399, 32.60197], [-116.6839, 32.6016], [-116.68386, 32.60154], [-116.68378, 32.60148], [-116.68364, 32.60146], [-116.68352, 32.6015], [-116.68325, 32.60182], [-116.68272, 32.60218], [-116.68265, 32.6022], [-116.6821, 32.6023], [-116.6818, 32.60224], [-116.68147, 32.60225], [-116.6814, 32.60224], [-116.68107, 32.60191], [-116.68104, 32.60186], [-116.68103, 32.60179], [-116.68104, 32.60174], [-116.68116, 32.60151], [-116.6816, 32.60118], [-116.68166, 32.60108], [-116.68166, 32.60098], [-116.68249, 32.60098], [-116.6825, 32.60053], [-116.68293, 32.60077], [-116.68338, 32.60096], [-116.68669, 32.60192]]]]} Restricted Access 2 1326 Conservation Fund 17596 3087 The Conservation Fund - California 675 Non Profit 6 Non Profit - Land Trust 10 http://www.conservationfund.org/ Non Governmental Organization 10 3087 The Conservation Fund - California 665 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 23.197 Conservation Fund 0 Private Conservation 16 2
6769 6769 6768 {"type": "MultiPolygon", "coordinates": [[[[-116.87056, 32.73716], [-116.86583, 32.73711], [-116.86553, 32.73354], [-116.87, 32.73358], [-116.87056, 32.73716]]], [[[-116.86613, 32.74077], [-116.86448, 32.74076], [-116.86425, 32.74118], [-116.86327, 32.74076], [-116.86447, 32.74076], [-116.86509, 32.73962], [-116.86605, 32.74], [-116.86613, 32.74077]]], [[[-116.86623, 32.74204], [-116.86596, 32.74191], [-116.86619, 32.74151], [-116.86623, 32.74204], [-116.86623, 32.74204]]], [[[-116.86641, 32.74443], [-116.86663, 32.75147], [-116.85716, 32.75147], [-116.85758, 32.7585], [-116.8533, 32.7585], [-116.85303, 32.75147], [-116.85255, 32.75145], [-116.84475, 32.75143], [-116.84406, 32.74438], [-116.84852, 32.74441], [-116.84849, 32.74083], [-116.85084, 32.74079], [-116.85271, 32.74079], [-116.85277, 32.74444], [-116.85672, 32.74447], [-116.86175, 32.74445], [-116.86166, 32.74238], [-116.86163, 32.74219], [-116.86156, 32.74075], [-116.8624, 32.74076], [-116.86172, 32.74196], [-116.86343, 32.7427], [-116.86309, 32.74335], [-116.86309, 32.74337], [-116.86397, 32.74372], [-116.86497, 32.74376], [-116.86514, 32.74342], [-116.86572, 32.74366], [-116.86628, 32.74265], [-116.86641, 32.74443]]]]} Restricted Access 2 5224 McGinty Mountain Preserve 30607 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   San Diego 4 577.956 McGinty Mtn. Preserve 0 Private Conservation 16 2
15529 15529 15528 {"type": "MultiPolygon", "coordinates": [[[[-116.37339, 33.20669], [-116.37126, 33.20669], [-116.3712, 33.20314], [-116.369, 33.20315], [-116.36895, 33.19964], [-116.37329, 33.19965], [-116.37339, 33.20669]]], [[[-116.36684, 33.20585], [-116.36473, 33.20589], [-116.36486, 33.21146], [-116.36444, 33.2114], [-116.364, 33.21137], [-116.36273, 33.21136], [-116.36269, 33.21043], [-116.36051, 33.21041], [-116.36039, 33.20494], [-116.3647, 33.20498], [-116.36682, 33.20495], [-116.36684, 33.20585]]]]} Restricted Access 2 49075 Unnamed site - Anza-Borrego Foundation 33775 3004 Anza-Borrego Foundation 836 Non Profit 6 Non Profit - Land Trust 10 http://www.theabf.org/ Non Governmental Organization 10 3004 Anza-Borrego Foundation 822 Non Profit 6 Non Profit - Land Trust 10 https://theabf.org/ San Diego 4 128.692   2019 Private Other or Unknown 399 4

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