units_with_maps

Table actions

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

13 rows where ACCESS_TYP = 3, GAP_STS = 2 and MNG_AGENCY = 622

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Save Mount Diablo · 13 ✖

DES_TP 1

ACCESS_TYP 1

  • No Public Access · 13 ✖
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
3384 3384 3383 {"type": "Polygon", "coordinates": [[[-121.85546, 37.89221], [-121.85527, 37.89228], [-121.85529, 37.89252], [-121.85529, 37.89268], [-121.85503, 37.89298], [-121.85481, 37.89305], [-121.85461, 37.89329], [-121.85368, 37.89311], [-121.854, 37.8926], [-121.85521, 37.89211], [-121.85544, 37.89196], [-121.85546, 37.89221]]]} No Public Access 3 35032 Marsh Creek IV 21890 3073 Save Mount Diablo 633 Non Profit 6 Non Profit - Land Trust 10 http://www.savemountdiablo.org/ Non Governmental Organization 10 3073 Save Mount Diablo 622 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 2.68 Marsh Creek IV 0 Private Conservation 16 2
11294 11294 11293 {"type": "Polygon", "coordinates": [[[-121.87723, 37.87595], [-121.87713, 37.87967], [-121.87325, 37.87969], [-121.87295, 37.88075], [-121.87209, 37.88094], [-121.87066, 37.88088], [-121.86824, 37.88066], [-121.86793, 37.88054], [-121.86793, 37.87974], [-121.87, 37.87935], [-121.87009, 37.87846], [-121.87102, 37.8772], [-121.87126, 37.87727], [-121.87139, 37.87722], [-121.87132, 37.87708], [-121.87108, 37.87686], [-121.8716, 37.87614], [-121.87316, 37.87533], [-121.87293, 37.87476], [-121.87379, 37.87476], [-121.87376, 37.87595], [-121.87723, 37.87595]]]} No Public Access 3 21976 Wright Property 27760 3073 Save Mount Diablo 633 Non Profit 6 Non Profit - Land Trust 10 http://www.savemountdiablo.org/ Non Governmental Organization 10 3073 Save Mount Diablo 622 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 76.208 Wright Property 0 Private Conservation 16 2
13081 13081 13080 {"type": "Polygon", "coordinates": [[[-121.89845, 37.98368], [-121.89706, 37.98369], [-121.89694, 37.97873], [-121.89856, 37.98308], [-121.89858, 37.98316], [-121.89857, 37.98321], [-121.89845, 37.98368]]]} No Public Access 3 35001 Black Diamond Mines 16132 3073 Save Mount Diablo 633 Non Profit 6 Non Profit - Land Trust 10 http://www.savemountdiablo.org/ Non Governmental Organization 10 3073 Save Mount Diablo 622 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 10.101 Black Diamond Mines 0 Private Conservation 16 2
13082 13082 13081 {"type": "Polygon", "coordinates": [[[-121.87719, 37.88184], [-121.87714, 37.88524], [-121.87705, 37.88526], [-121.87698, 37.88529], [-121.87676, 37.88548], [-121.87245, 37.88546], [-121.87246, 37.88183], [-121.87719, 37.88184]]]} No Public Access 3 35003 Oak Hill Lane 22978 3073 Save Mount Diablo 633 Non Profit 6 Non Profit - Land Trust 10 http://www.savemountdiablo.org/ Non Governmental Organization 10 3073 Save Mount Diablo 622 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 41.248 Oak Hill Lane 0 Private Conservation 16 2
13087 13087 13086 {"type": "Polygon", "coordinates": [[[-121.75471, 37.90136], [-121.75464, 37.90146], [-121.75417, 37.90192], [-121.75141, 37.90095], [-121.75176, 37.90033], [-121.75471, 37.90136]]]} No Public Access 3 35029 Dry Creek 18280 3073 Save Mount Diablo 633 Non Profit 6 Non Profit - Land Trust 10 http://www.savemountdiablo.org/ Non Governmental Organization 10 3073 Save Mount Diablo 622 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 5.18 Dry Creek 0 Private Conservation 16 2
13109 13109 13108 {"type": "Polygon", "coordinates": [[[-121.89523, 37.88546], [-121.88592, 37.88547], [-121.88592, 37.88922], [-121.8806, 37.88925], [-121.88062, 37.88182], [-121.89522, 37.88178], [-121.89523, 37.88546]]]} No Public Access 3 35027 Viera-North Peak 27093 3073 Save Mount Diablo 633 Non Profit 6 Non Profit - Land Trust 10 http://www.savemountdiablo.org/ Non Governmental Organization 10 3073 Save Mount Diablo 622 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 177.666 Viera-North Peak 0 Private Conservation 16 2
13110 13110 13109 {"type": "Polygon", "coordinates": [[[-121.8042, 37.88903], [-121.80069, 37.8909], [-121.80036, 37.89094], [-121.80014, 37.89101], [-121.8, 37.89107], [-121.79998, 37.8907], [-121.80077, 37.88981], [-121.80077, 37.88901], [-121.8042, 37.88903]]]} No Public Access 3 35028 Marsh Creek I 21888 3073 Save Mount Diablo 633 Non Profit 6 Non Profit - Land Trust 10 http://www.savemountdiablo.org/ Non Governmental Organization 10 3073 Save Mount Diablo 622 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 8.954 Marsh Creek I 0 Private Conservation 16 2
13111 13111 13110 {"type": "Polygon", "coordinates": [[[-121.98061, 37.92304], [-121.98058, 37.92697], [-121.97292, 37.9269], [-121.97296, 37.92378], [-121.96975, 37.92348], [-121.96978, 37.91733], [-121.97977, 37.91719], [-121.97977, 37.91848], [-121.97966, 37.91849], [-121.97964, 37.92304], [-121.98061, 37.92304]]]} No Public Access 3 35030 Mangini Ranch 21744 3073 Save Mount Diablo 633 Non Profit 6 Non Profit - Land Trust 10 http://www.savemountdiablo.org/ Non Governmental Organization 10 3073 Save Mount Diablo 622 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 214.66 Mangini Ranch 0 Private Conservation 16 2
13112 13112 13111 {"type": "Polygon", "coordinates": [[[-121.91432, 37.90869], [-121.91431, 37.9107], [-121.90951, 37.9107], [-121.90946, 37.90876], [-121.91432, 37.90869]]]} No Public Access 3 35031 Young Canyon 27788 3073 Save Mount Diablo 633 Non Profit 6 Non Profit - Land Trust 10 http://www.savemountdiablo.org/ Non Governmental Organization 10 3073 Save Mount Diablo 622 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 23.027 Young Canyon 0 Private Conservation 16 2
13113 13113 13112 {"type": "Polygon", "coordinates": [[[-121.85767, 37.89517], [-121.85471, 37.8952], [-121.85439, 37.89624], [-121.85282, 37.89622], [-121.85368, 37.89336], [-121.85582, 37.89378], [-121.85658, 37.89398], [-121.85678, 37.89405], [-121.85694, 37.89415], [-121.85707, 37.89427], [-121.85767, 37.89517]]]} No Public Access 3 35033 Marsh Creek II 21889 3073 Save Mount Diablo 633 Non Profit 6 Non Profit - Land Trust 10 http://www.savemountdiablo.org/ Non Governmental Organization 10 3073 Save Mount Diablo 622 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 17.944 Marsh Creek II 0 Private Conservation 16 2
14570 14570 14569 {"type": "Polygon", "coordinates": [[[-121.92075, 37.92393], [-121.9207, 37.92397], [-121.92039, 37.9238], [-121.9203, 37.92414], [-121.92003, 37.92424], [-121.91984, 37.92395], [-121.91964, 37.92376], [-121.91951, 37.92367], [-121.91935, 37.92359], [-121.91901, 37.9235], [-121.919, 37.92085], [-121.91954, 37.92244], [-121.91992, 37.92282], [-121.92054, 37.92333], [-121.92036, 37.92371], [-121.92075, 37.92393]]]} No Public Access 3 44714 Lot 25 28140 3073 Save Mount Diablo 633 Non Profit 6 Non Profit - Land Trust 10 http://www.savemountdiablo.org/ Non Governmental Organization 10 3073 Save Mount Diablo 622 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 5.01 Lot 25 0 Private Conservation 16 2
14823 14823 14822 {"type": "Polygon", "coordinates": [[[-121.84979, 37.89157], [-121.84949, 37.89142], [-121.84917, 37.89133], [-121.84874, 37.89126], [-121.84852, 37.89119], [-121.84832, 37.8911], [-121.84814, 37.891], [-121.84797, 37.89088], [-121.84777, 37.8907], [-121.84768, 37.89056], [-121.84976, 37.88891], [-121.84979, 37.89157]]]} No Public Access 3 45287 Marsh Creek V 21891 3073 Save Mount Diablo 633 Non Profit 6 Non Profit - Land Trust 10 http://www.savemountdiablo.org/ Non Governmental Organization 10 3073 Save Mount Diablo 622 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 7.354 Marsh Creek V 0 Private Conservation 16 2
14824 14824 14823 {"type": "Polygon", "coordinates": [[[-121.85413, 37.89196], [-121.8541, 37.89216], [-121.85391, 37.89258], [-121.85359, 37.89309], [-121.85291, 37.89291], [-121.853, 37.89278], [-121.85296, 37.89026], [-121.85326, 37.89012], [-121.85368, 37.89116], [-121.85406, 37.89177], [-121.85413, 37.89196]]]} No Public Access 3 45288 Marsh Creek VI 21892 3073 Save Mount Diablo 633 Non Profit 6 Non Profit - Land Trust 10 http://www.savemountdiablo.org/ Non Governmental Organization 10 3073 Save Mount Diablo 622 Non Profit 6 Non Profit - Land Trust 10   Contra Costa 12 5.462 Marsh Creek VI 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]);