superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Rancho Corral de Tierra" and MNG_AGENCY = 59
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1334 | 1334 | 1333 | {"type": "MultiPolygon", "coordinates": [[[[-122.50786, 37.5243], [-122.50314, 37.53113], [-122.50104, 37.5342], [-122.49381, 37.53336], [-122.49166, 37.5365], [-122.49161, 37.53649], [-122.48756, 37.54245], [-122.48757, 37.54247], [-122.48879, 37.54302], [-122.48324, 37.55114], [-122.48325, 37.55115], [-122.495, 37.55121], [-122.49888, 37.5512], [-122.50002, 37.5535], [-122.49885, 37.55559], [-122.49644, 37.55561], [-122.49645, 37.55965], [-122.49642, 37.56246], [-122.48432, 37.56254], [-122.48483, 37.56112], [-122.48419, 37.56097], [-122.4838, 37.56199], [-122.48156, 37.56201], [-122.48154, 37.56088], [-122.47787, 37.56101], [-122.47784, 37.55113], [-122.45303, 37.551], [-122.45254, 37.5511], [-122.45148, 37.539], [-122.46109, 37.53913], [-122.4611, 37.53912], [-122.45784, 37.53575], [-122.45595, 37.53342], [-122.45517, 37.52471], [-122.45016, 37.52426], [-122.44942, 37.51586], [-122.45878, 37.51669], [-122.4589, 37.51673], [-122.45914, 37.51674], [-122.45925, 37.51673], [-122.46911, 37.51758], [-122.47532, 37.5116], [-122.47549, 37.51168], [-122.47728, 37.51212], [-122.47748, 37.51077], [-122.48167, 37.51275], [-122.48228, 37.51181], [-122.48296, 37.5121], [-122.48308, 37.51192], [-122.48308, 37.51185], [-122.4832, 37.51166], [-122.48353, 37.51177], [-122.48391, 37.51119], [-122.48423, 37.51131], [-122.48423, 37.51135], [-122.48447, 37.51145], [-122.48478, 37.51178], [-122.48509, 37.51227], [-122.4855, 37.51318], [-122.48588, 37.5135], [-122.48591, 37.5135], [-122.48615, 37.51369], [-122.48553, 37.51419], [-122.48603, 37.51467], [-122.48573, 37.51493], [-122.48573, 37.51495], [-122.48671, 37.51567], [-122.4874, 37.5152], [-122.48806, 37.51517], [-122.4881, 37.51526], [-122.48812, 37.51542], [-122.48864, 37.51544], [-122.48866, 37.51539], [-122.48897, 37.5154], [-122.489, 37.51523], [-122.48897, 37.51489], [-122.48871, 37.5143], [-122.48893, 37.5141], [-122.48873, 37.51342], [-122.48901, 37.51291], [-122.48881, 37.51274], [-122.48805, 37.51226], [-122.48783, 37.51201], [-122.48769, 37.51177], [-122.48758, 37.51145], [-122.48753, 37.51114], [-122.48747, 37.51098], [-122.4874, 37.51092], [-122.48814, 37.51034], [-122.49277, 37.51384], [-122.49374, 37.5145], [-122.49451, 37.51496], [-122.49689, 37.51621], [-122.49885, 37.51731], [-122.50141, 37.51863], [-122.5015, 37.5187], [-122.50225, 37.51944], [-122.50324, 37.52], [-122.50459, 37.52053], [-122.50588, 37.52159], [-122.50612, 37.52223], [-122.50691, 37.52333], [-122.50786, 37.5243]], [[-122.48501, 37.53912], [-122.48612, 37.53963], [-122.48997, 37.53443], [-122.49222, 37.53319], [-122.4905, 37.53079], [-122.48519, 37.53356], [-122.48349, 37.53569], [-122.475, 37.53962], [-122.47275, 37.54267], [-122.47163, 37.54584], [-122.48261, 37.54843], [-122.48568, 37.54401], [-122.48438, 37.53994], [-122.48501, 37.53912]], [[-122.48981, 37.5202], [-122.48982, 37.52018], [-122.48966, 37.51989], [-122.48919, 37.52004], [-122.48935, 37.52034], [-122.48981, 37.5202]], [[-122.49394, 37.53028], [-122.49361, 37.53025], [-122.49359, 37.53026], [-122.49363, 37.53037], [-122.49394, 37.53037], [-122.49394, 37.53028]], [[-122.49712, 37.52515], [-122.49713, 37.52513], [-122.49702, 37.5249], [-122.49693, 37.52491], [-122.49703, 37.52516], [-122.49712, 37.52515]]], [[[-122.51324, 37.54642], [-122.51297, 37.54682], [-122.51294, 37.54683], [-122.51293, 37.54686], [-122.51256, 37.5474], [-122.51219, 37.54798], [-122.51196, 37.54847], [-122.51181, 37.54893], [-122.50883, 37.54911], [-122.50851, 37.54998], [-122.50904, 37.55116], [-122.50902, 37.55297], [-122.5087, 37.55324], [-122.50855, 37.55342], [-122.5082, 37.55362], [-122.50803, 37.5536], [-122.50779, 37.55362], [-122.5075, 37.55373], [-122.50732, 37.55395], [-122.507, 37.55403], [-122.50691, 37.55415], [-122.50662, 37.55427], [-122.5064, 37.55456], [-122.50636, 37.55483], [-122.50601, 37.55501], [-122.50596, 37.55519], [-122.50582, 37.55542], [-122.50559, 37.5557], [-122.50502, 37.55611], [-122.50469, 37.55651], [-122.50422, 37.55681], [-122.50416, 37.55752], [-122.50292, 37.55716], [-122.50186, 37.55609], [-122.50225, 37.55438], [-122.50134, 37.55284], [-122.50075, 37.55137], [-122.50083, 37.55036], [-122.50054, 37.54985], [-122.50541, 37.54435], [-122.50545, 37.54435], [-122.50631, 37.54332], [-122.50704, 37.54375], [-122.50621, 37.54471], [-122.50819, 37.54562], [-122.5094, 37.54388], [-122.50971, 37.54363], [-122.51324, 37.54642]]]]} | Open Access 1 | Rancho Corral de Tierra | http://www.nps.gov/goga/rcdt.htm | 14268 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 4174.497 | Rancho Corral de Tierra |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);