units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1 and LABEL_NAME = "Lake Kaweah"

This data as json, copyable, CSV (advanced)

These facets timed out: ACCESS_TYP, MNG_AG_TYP

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
12318 12318 12317 {"type": "MultiPolygon", "coordinates": [[[[-118.94787, 36.38684], [-118.94656, 36.38778], [-118.94647, 36.38773], [-118.94644, 36.38753], [-118.94634, 36.38718], [-118.94616, 36.38681], [-118.94613, 36.38677], [-118.94787, 36.38684]]], [[[-118.94636, 36.38794], [-118.94592, 36.38839], [-118.94579, 36.38875], [-118.94486, 36.38983], [-118.94508, 36.38939], [-118.945, 36.38927], [-118.94471, 36.38922], [-118.94466, 36.38904], [-118.94475, 36.38875], [-118.94438, 36.38869], [-118.94421, 36.38848], [-118.9438, 36.38815], [-118.9437, 36.38797], [-118.94359, 36.38785], [-118.94338, 36.38772], [-118.94312, 36.3875], [-118.94326, 36.38734], [-118.94331, 36.38718], [-118.94335, 36.38716], [-118.94355, 36.3869], [-118.9433, 36.3866], [-118.943, 36.38392], [-118.94328, 36.38417], [-118.94332, 36.38418], [-118.94344, 36.38426], [-118.94363, 36.38428], [-118.94405, 36.38436], [-118.94395, 36.38484], [-118.94401, 36.38531], [-118.94426, 36.38571], [-118.94458, 36.38598], [-118.9449, 36.38628], [-118.94584, 36.38679], [-118.94608, 36.38712], [-118.94621, 36.38768], [-118.94636, 36.38794]]], [[[-118.96038, 36.39043], [-118.95947, 36.38983], [-118.95875, 36.38975], [-118.95908, 36.38954], [-118.95939, 36.38923], [-118.95949, 36.38894], [-118.95966, 36.38866], [-118.95966, 36.38901], [-118.95983, 36.38953], [-118.95988, 36.38956], [-118.96019, 36.38985], [-118.96025, 36.39011], [-118.96038, 36.39043]]], [[[-118.98804, 36.3953], [-118.9871, 36.39562], [-118.98703, 36.39497], [-118.98766, 36.39493], [-118.98768, 36.39511], [-118.98803, 36.39509], [-118.98804, 36.3953]]], [[[-119.01593, 36.41358], [-119.01545, 36.41376], [-119.01544, 36.41416], [-119.01356, 36.41531], [-119.01376, 36.41751], [-119.01122, 36.41853], [-119.00934, 36.41841], [-119.00934, 36.41568], [-119.00933, 36.41567], [-119.009, 36.41594], [-119.009, 36.41842], [-119.00648, 36.41852], [-119.00505, 36.42017], [-119.00284, 36.42076], [-118.99986, 36.42101], [-119.00006, 36.42172], [-119.00061, 36.42287], [-118.99985, 36.4228], [-118.99862, 36.42224], [-118.99798, 36.42274], [-118.99736, 36.42178], [-118.99661, 36.42207], [-118.99645, 36.42349], [-118.99536, 36.42351], [-118.99359, 36.42463], [-118.9941, 36.42585], [-118.99453, 36.42592], [-118.99515, 36.42669], [-118.99439, 36.42701], [-118.99348, 36.42672], [-118.99314, 36.42706], [-118.99288, 36.42711], [-118.99292, 36.42774], [-118.99257, 36.42772], [-118.99202, 36.42984], [-118.99179, 36.42972], [-118.99114, 36.43074], [-118.99026, 36.43066], [-118.99054, 36.43167], [-118.99032, 36.43167], [-118.98982, 36.43091], [-118.98968, 36.43003], [-118.98975, 36.42947], [-118.9901, 36.42862], [-118.99084, 36.42856], [-118.99069, 36.42708], [-118.99088, 36.42618], [-118.99043, 36.42586], [-118.99143, 36.42572], [-118.99113, 36.42361], [-118.99041, 36.42305], [-118.99091, 36.42293], [-118.9918, 36.42303], [-118.9923, 36.42266], [-118.99177, 36.42191], [-118.99182, 36.4219], [-118.99173, 36.41426], [-118.99137, 36.41453], [-118.9913, 36.41502], [-118.99121, 36.41506], [-118.99047, 36.41437], [-118.98961, 36.41429], [-118.99057, 36.41359], [-118.99057, 36.41358], [-118.98846, 36.41363], [-118.98845, 36.41365], [-118.98867, 36.4142], [-118.98809, 36.41499], [-118.98765, 36.4153], [-118.98756, 36.41441], [-118.98562, 36.41448], [-118.98561, 36.41449], [-118.98626, 36.41544], [-118.9858, 36.41589], [-118.98245, 36.4154], [-118.98232, 36.41617], [-118.98174, 36.41665], [-118.98094, 36.41601], [-118.98171, 36.41459], [-118.98268, 36.4139], [-118.98268, 36.41378], [-118.98249, 36.41291], [-118.98041, 36.41182], [-118.97953, 36.41371], [-118.97819, 36.41374], [-118.97819, 36.41249], [-118.97701, 36.41217], [-118.97672, 36.41121], [-118.97687, 36.40995], [-118.9755, 36.40978], [-118.97394, 36.40923], [-118.97329, 36.41062], [-118.97222, 36.41006], [-118.97158, 36.40893], [-118.97141, 36.40805], [-118.96951, 36.40802], [-118.96811, 36.40706], [-118.96533, 36.40712], [-118.96495, 36.40754], [-118.96489, 36.40713], [-118.96197, 36.40718], [-118.96131, 36.40786], [-118.96012, 36.40783], [-118.95951, 36.40723], [-118.95733, 36.40717], [-118.95609, 36.40744], [-118.95555, 36.40836], [-118.95355, 36.40952], [-118.95284, 36.40949], [-118.95214, 36.40939], [-118.9517, 36.40919], [-118.95082, 36.40975], [-118.9505, 36.41121], [-118.95061, 36.41175], [-118.9505, 36.41235], [-118.95102, 36.41278], [-118.95102, 36.41374], [-118.94941, 36.41375], [-118.94904, 36.4137], [-118.94896, 36.41391], [-118.94889, 36.41456], [-118.94895, 36.41616], [-118.94868, 36.41588], [-118.948, 36.416], [-118.94785, 36.41644], [-118.94705, 36.41557], [-118.94602, 36.41573], [-118.94532, 36.4153], [-118.94377, 36.41564], [-118.94282, 36.4151], [-118.94158, 36.41457], [-118.94119, 36.41402], [-118.94015, 36.41402], [-118.94017, 36.41458], [-118.93875, 36.4146], [-118.93885, 36.41514], [-118.93874, 36.4158], [-118.93919, 36.41649], [-118.93964, 36.41747], [-118.93958, 36.41805], [-118.93938, 36.4184], [-118.93885, 36.4186], [-118.93944, 36.41901], [-118.93874, 36.41903], [-118.93843, 36.41937], [-118.93747, 36.41937], [-118.93723, 36.41901], [-118.93585, 36.4188], [-118.93495, 36.41913], [-118.93343, 36.41902], [-118.93277, 36.41832], [-118.93214, 36.41862], [-118.93223, 36.41745], [-118.93171, 36.4173], [-118.92992, 36.41628], [-118.92773, 36.41605], [-118.92752, 36.41591], [-118.92648, 36.41687], [-118.92551, 36.41664], [-118.92513, 36.41664], [-118.92513, 36.41612], [-118.92552, 36.41622], [-118.92553, 36.41621], [-118.92548, 36.41504], [-118.92505, 36.41503], [-118.92515, 36.4149], [-118.927, 36.41492], [-118.92697, 36.41397], [-118.92637, 36.41381], [-118.92671, 36.41364], [-118.92837, 36.41372], [-118.92923, 36.41358], [-118.93059, 36.41381], [-118.93241, 36.41434], [-118.93265, 36.41467], [-118.93279, 36.41459], [-118.9328, 36.41368], [-118.9337, 36.41385], [-118.93392, 36.41368], [-118.93464, 36.41345], [-118.93503, 36.41312], [-118.9352, 36.41316], [-118.93525, 36.41311], [-118.93495, 36.41278], [-118.93468, 36.41261], [-118.93455, 36.41248], [-118.9345, 36.41217], [-118.93496, 36.41213], [-118.93539, 36.41206], [-118.93703, 36.41171], [-118.93767, 36.41202], [-118.93939, 36.41145], [-118.93939, 36.41144], [-118.9393, 36.41124], [-118.93964, 36.41117], [-118.94002, 36.4112], [-118.94278, 36.4111], [-118.94286, 36.41115], [-118.94424, 36.41121], [-118.94453, 36.41102], [-118.94459, 36.41075], [-118.94517, 36.41061], [-118.94626, 36.41002], [-118.94686, 36.40949], [-118.94767, 36.40808], [-118.94804, 36.40793], [-118.94894, 36.40701], [-118.95171, 36.40594], [-118.95288, 36.40488], [-118.95294, 36.40409], [-118.95318, 36.40371], [-118.95329, 36.40242], [-118.95315, 36.40216], [-118.95312, 36.40102], [-118.95241, 36.39987], [-118.95073, 36.39754], [-118.94951, 36.39624], [-118.94939, 36.396], [-118.94894, 36.39561], [-118.94813, 36.39527], [-118.94743, 36.39415], [-118.94661, 36.39202], [-118.94678, 36.39119], [-118.94686, 36.38929], [-118.94711, 36.38798], [-118.94806, 36.38736], [-118.94959, 36.38724], [-118.94992, 36.38741], [-118.95196, 36.38765], [-118.95275, 36.38781], [-118.95293, 36.38816], [-118.95386, 36.38828], [-118.95475, 36.38862], [-118.95513, 36.38898], [-118.95618, 36.38926], [-118.95803, 36.38996], [-118.95807, 36.39017], [-118.95831, 36.39025], [-118.95839, 36.39019], [-118.95928, 36.39082], [-118.96034, 36.39141], [-118.96074, 36.39134], [-118.9635, 36.39315], [-118.96462, 36.39414], [-118.96549, 36.39459], [-118.96587, 36.39557], [-118.96669, 36.39613], [-118.96793, 36.3962], [-118.96897, 36.39691], [-118.96911, 36.39769], [-118.97018, 36.39783], [-118.97103, 36.39839], [-118.97121, 36.39928], [-118.97155, 36.39952], [-118.97199, 36.39951], [-118.97287, 36.39918], [-118.97325, 36.39928], [-118.97462, 36.39928], [-118.97525, 36.3992], [-118.97629, 36.39901], [-118.97695, 36.39895], [-118.97856, 36.398], [-118.97933, 36.39781], [-118.98027, 36.39816], [-118.98132, 36.39823], [-118.98246, 36.39909], [-118.98319, 36.39901], [-118.98369, 36.39873], [-118.98485, 36.3984], [-118.98544, 36.39807], [-118.98666, 36.39661], [-118.98776, 36.39587], [-118.98846, 36.39578], [-118.98989, 36.39619], [-118.99053, 36.39667], [-118.99061, 36.39744], [-118.99092, 36.39811], [-118.99167, 36.39864], [-118.9921, 36.39872], [-118.99223, 36.39896], [-118.99103, 36.39901], [-118.99093, 36.39938], [-118.99054, 36.39963], [-118.9904, 36.40055], [-118.98971, 36.40114], [-118.98937, 36.40164], [-118.9894, 36.40195], [-118.98951, 36.40231], [-118.98877, 36.40348], [-118.98893, 36.40373], [-118.98937, 36.40408], [-118.98945, 36.40455], [-118.98976, 36.40503], [-118.99013, 36.40553], [-118.9902, 36.40624], [-118.9912, 36.40643], [-118.99146, 36.40672], [-118.99172, 36.4068], [-118.99353, 36.40684], [-118.99428, 36.40616], [-118.995, 36.40615], [-118.99593, 36.40538], [-118.99656, 36.40523], [-118.9981, 36.40461], [-118.99836, 36.40464], [-118.99872, 36.40431], [-118.99951, 36.40402], [-119.00002, 36.40409], [-119.00032, 36.40365], [-119.00069, 36.40361], [-119.00187, 36.4033], [-119.00279, 36.4029], [-119.00299, 36.40275], [-119.00428, 36.40275], [-119.00525, 36.40248], [-119.00555, 36.40246], [-119.0056, 36.40454], [-119.00713, 36.40472], [-119.00906, 36.40625], [-119.00906, 36.4064], [-119.00851, 36.40665], [-119.00821, 36.40665], [-119.00796, 36.40672], [-119.00814, 36.40688], [-119.0094, 36.40715], [-119.00987, 36.40775], [-119.0091, 36.40838], [-119.0091, 36.4084], [-119.01035, 36.40857], [-119.01121, 36.40925], [-119.0118, 36.40937], [-119.00908, 36.40938], [-119.00909, 36.41357], [-119.01132, 36.41358], [-119.01368, 36.41223], [-119.014, 36.41262], [-119.01399, 36.41283], [-119.0138, 36.41319], [-119.0154, 36.4134], [-119.0154, 36.41358], [-119.01593, 36.41358]]]]} Open Access 1 25961 Lake Kaweah 13565 100 United States Army Corps of Engineers 146 Federal 1 Federal Agency 1 http://www.usace.army.mil/ Other Federal 13 100 United States Army Corps of Engineers 142 Federal 1 Federal Agency 1 http://www.spk.usace.army.mil/Locations/SacramentoDistrictParks/LakeKaweah.aspx Tulare 29 2691.676 Lake Kaweah 0 Resource Management Area 82 3

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