units_with_maps

Table actions

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

9 rows where ACCESS_TYP = 2, DES_TP = 16, MNG_AGENCY = 61 and YR_EST = 0

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, COUNTY, LABEL_NAME

MNG_AG_TYP 1

MNG_AGENCY 1

  • The Nature Conservancy · 9 ✖

DES_TP 1

  • Private Conservation · 9 ✖

ACCESS_TYP 1

  • Restricted Access · 9 ✖
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
2400 2400 2399 {"type": "Polygon", "coordinates": [[[-121.59811, 36.07501], [-121.59802, 36.07863], [-121.59354, 36.07864], [-121.59363, 36.07502], [-121.59811, 36.07501]]]} Restricted Access 2 17234 Landels-Hill Big Creek Reserve 21004 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   Monterey 14 40.063 Landels-Hill Big Creek Reserve 0 Private Conservation 16 2
3003 3003 3002 {"type": "Polygon", "coordinates": [[[-116.21873, 35.80415], [-116.20983, 35.80412], [-116.20983, 35.80049], [-116.21873, 35.80053], [-116.21873, 35.80415]]]} Restricted Access 2 20739 Amargosa River Preserve 30584 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   Inyo 43 80.045 Amargosa River Preserve 0 Private Conservation 16 2
3267 3267 3266 {"type": "Polygon", "coordinates": [[[-122.02492, 39.88339], [-122.02372, 39.88384], [-121.99456, 39.88367], [-121.99427, 39.88369], [-121.98022, 39.88367], [-121.98024, 39.88034], [-121.98048, 39.87786], [-121.98164, 39.87676], [-121.98159, 39.87406], [-121.98154, 39.87314], [-121.98168, 39.87249], [-121.98185, 39.8721], [-121.98212, 39.87179], [-121.98276, 39.87127], [-121.98318, 39.8711], [-121.9835, 39.87108], [-121.98401, 39.87111], [-121.98485, 39.871], [-121.98601, 39.871], [-121.98665, 39.87103], [-121.98805, 39.87133], [-121.99027, 39.87046], [-121.9913, 39.86899], [-121.991, 39.86864], [-121.99064, 39.86814], [-121.9906, 39.86781], [-121.99132, 39.86779], [-121.99173, 39.8678], [-121.99196, 39.86777], [-121.99259, 39.86756], [-121.99306, 39.86747], [-121.9936, 39.86763], [-121.99432, 39.86776], [-121.99433, 39.86934], [-121.99453, 39.8811], [-122.00265, 39.88117], [-122.00314, 39.87832], [-122.00745, 39.87789], [-122.00753, 39.87413], [-122.01537, 39.87411], [-122.01561, 39.86889], [-122.02492, 39.88339]]]} Restricted Access 2 23102 Vina Plains Preserve 30621 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   Butte 42 891.196 Vina Plains Preserve 0 Private Conservation 16 2
4176 4176 4175 {"type": "MultiPolygon", "coordinates": [[[[-115.81338, 33.507], [-115.81269, 33.50699], [-115.81269, 33.50672], [-115.81301, 33.50684], [-115.81338, 33.507]]], [[[-115.81707, 33.50334], [-115.81705, 33.507], [-115.81411, 33.507], [-115.81316, 33.50659], [-115.81269, 33.50642], [-115.81271, 33.50334], [-115.81707, 33.50334]]]]} Restricted Access 2 44832 Dos Palmas Preserve 18227 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   Riverside 10 39.791 Dos Palmas Preserve 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
11207 11207 11206 {"type": "MultiPolygon", "coordinates": [[[[-120.23757, 40.07119], [-120.22822, 40.07098], [-120.22812, 40.05631], [-120.23282, 40.05627], [-120.23288, 40.06738], [-120.23756, 40.06745], [-120.23757, 40.07119]]], [[[-120.27152, 40.04976], [-120.27147, 40.05302], [-120.26166, 40.0529], [-120.26153, 40.05628], [-120.26095, 40.05625], [-120.26093, 40.05626], [-120.26087, 40.06405], [-120.25622, 40.06396], [-120.25647, 40.05601], [-120.2518, 40.05606], [-120.24693, 40.05614], [-120.23775, 40.05622], [-120.23829, 40.04968], [-120.23383, 40.04966], [-120.23428, 40.03222], [-120.2388, 40.03222], [-120.23883, 40.0395], [-120.2435, 40.03953], [-120.24349, 40.03589], [-120.24817, 40.03592], [-120.2482, 40.04321], [-120.24352, 40.04318], [-120.24298, 40.04967], [-120.25701, 40.04965], [-120.25729, 40.04647], [-120.26681, 40.04648], [-120.26669, 40.04972], [-120.27152, 40.04976]], [[-120.26165, 40.05289], [-120.26185, 40.04968], [-120.25702, 40.04965], [-120.25675, 40.05282], [-120.26165, 40.05289]]]]} Restricted Access 2 21524 Matley Ranch 30604 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   Plumas 57 1136.736 Matley Ranch 0 Private Conservation 16 2
11215 11215 11214 {"type": "MultiPolygon", "coordinates": [[[[-122.01116, 39.91293], [-122.01023, 39.91293], [-122.01022, 39.91295], [-122.0103, 39.91301], [-121.99335, 39.91564], [-121.9893, 39.91613], [-121.97747, 39.91469], [-121.97558, 39.91453], [-121.96278, 39.91305], [-121.96299, 39.9126], [-121.96673, 39.90589], [-121.97603, 39.89893], [-121.97867, 39.89677], [-121.98495, 39.89033], [-121.98516, 39.8904], [-121.98529, 39.89032], [-121.98608, 39.89093], [-121.99407, 39.89794], [-122.00098, 39.90406], [-122.00155, 39.9045], [-122.01116, 39.91293]]], [[[-122.02949, 39.89063], [-122.02932, 39.89831], [-122.02919, 39.91285], [-122.01225, 39.91292], [-121.98582, 39.88969], [-121.99202, 39.88394], [-121.99232, 39.88368], [-121.99427, 39.88369], [-121.99456, 39.88367], [-122.02372, 39.88384], [-122.02492, 39.88339], [-122.02949, 39.89063]]]]} Restricted Access 2 21523 Vina Plains Preserve 30621 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   Tehama 18 3710.797 Vina Plains Preserve 0 Private Conservation 16 2
12998 12998 12997 {"type": "Polygon", "coordinates": [[[-120.72157, 40.15179], [-120.72088, 40.15924], [-120.71598, 40.15917], [-120.7167, 40.15153], [-120.72157, 40.15179]]]} Restricted Access 2 31005 Taylor Lake 30617 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   Plumas 57 86.434 Taylor Lake 0 Private Conservation 16 2
13925 13925 13924 {"type": "MultiPolygon", "coordinates": [[[[-121.42884, 38.25745], [-121.42668, 38.25702], [-121.42528, 38.25894], [-121.42541, 38.26004], [-121.42473, 38.26004], [-121.42481, 38.26013], [-121.42492, 38.26134], [-121.42445, 38.26133], [-121.4244, 38.26068], [-121.4242, 38.26048], [-121.42356, 38.2608], [-121.42246, 38.26102], [-121.42229, 38.26121], [-121.42249, 38.26133], [-121.41767, 38.26132], [-121.41768, 38.26086], [-121.4176, 38.26002], [-121.41054, 38.26001], [-121.41046, 38.2696], [-121.40484, 38.26957], [-121.40485, 38.26886], [-121.40495, 38.26879], [-121.40595, 38.26827], [-121.40645, 38.26804], [-121.40687, 38.26777], [-121.40753, 38.26743], [-121.40777, 38.26728], [-121.40786, 38.26716], [-121.40863, 38.26543], [-121.40884, 38.26455], [-121.40887, 38.26428], [-121.40875, 38.26395], [-121.40855, 38.2636], [-121.4085, 38.26332], [-121.40852, 38.26314], [-121.40874, 38.26284], [-121.40882, 38.26243], [-121.40864, 38.26199], [-121.40843, 38.26173], [-121.40784, 38.2612], [-121.40789, 38.26079], [-121.40811, 38.26037], [-121.40873, 38.25947], [-121.40883, 38.25915], [-121.40879, 38.25872], [-121.40882, 38.25859], [-121.40891, 38.25851], [-121.40987, 38.25812], [-121.41021, 38.25792], [-121.41027, 38.25761], [-121.41019, 38.25731], [-121.40993, 38.25703], [-121.40961, 38.25681], [-121.40928, 38.25665], [-121.40909, 38.25652], [-121.40905, 38.25631], [-121.40906, 38.25616], [-121.40917, 38.25588], [-121.40923, 38.25559], [-121.40919, 38.25522], [-121.40912, 38.25493], [-121.40955, 38.25468], [-121.40923, 38.25439], [-121.40885, 38.2546], [-121.40871, 38.2547], [-121.40861, 38.25487], [-121.40871, 38.25527], [-121.40874, 38.25558], [-121.40869, 38.25579], [-121.40857, 38.25608], [-121.40856, 38.25633], [-121.40863, 38.25672], [-121.40899, 38.25696], [-121.40932, 38.25712], [-121.40957, 38.25729], [-121.40974, 38.25747], [-121.40977, 38.25762], [-121.40976, 38.2577], [-121.40961, 38.25779], [-121.40862, 38.2582], [-121.40836, 38.25841], [-121.4083, 38.2587], [-121.40834, 38.25912], [-121.40827, 38.25933], [-121.40766, 38.2602], [-121.40741, 38.26069], [-121.40734, 38.26132], [-121.40765, 38.26165], [-121.40805, 38.26197], [-121.4082, 38.26215], [-121.40832, 38.26246], [-121.40827, 38.26271], [-121.40805, 38.26301], [-121.408, 38.26333], [-121.40808, 38.26371], [-121.40829, 38.26408], [-121.40837, 38.26431], [-121.40835, 38.2645], [-121.40816, 38.26533], [-121.4074, 38.26702], [-121.40724, 38.26712], [-121.40659, 38.26746], [-121.40618, 38.26772], [-121.40569, 38.26794], [-121.40466, 38.26848], [-121.40446, 38.26861], [-121.40436, 38.26876], [-121.40436, 38.26929], [-121.40432, 38.26956], [-121.39215, 38.26949], [-121.39224, 38.26209], [-121.39776, 38.2621], [-121.39827, 38.26167], [-121.39866, 38.26069], [-121.39865, 38.25957], [-121.39916, 38.25819], [-121.3998, 38.25771], [-121.40069, 38.25608], [-121.40116, 38.25575], [-121.40126, 38.25502], [-121.40216, 38.2541], [-121.4041, 38.25411], [-121.40433, 38.25417], [-121.40522, 38.25423], [-121.40602, 38.25411], [-121.40637, 38.2538], [-121.40648, 38.25364], [-121.40855, 38.25364], [-121.41058, 38.25406], [-121.41059, 38.25414], [-121.42873, 38.25424], [-121.42884, 38.25745]]], [[[-121.42582, 38.27583], [-121.42168, 38.27584], [-121.4222, 38.27507], [-121.42063, 38.26884], [-121.42183, 38.26861], [-121.42579, 38.26863], [-121.42582, 38.27583]]]]} Restricted Access 2 46984 Cosumnes River Preserve 30623 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   Sacramento 41 846.751 Cosumnes River Preserve 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]);