units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where LAYER = 12, MNG_AG_TYP = 1 and YR_EST = 1910
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10598 | 10598 | 10597 | {"type": "Polygon", "coordinates": [[[-122.48467, 37.78753], [-122.48415, 37.78756], [-122.48414, 37.78777], [-122.48395, 37.78803], [-122.48393, 37.78831], [-122.48371, 37.78878], [-122.48382, 37.78928], [-122.48288, 37.79043], [-122.4822, 37.79248], [-122.48179, 37.79459], [-122.48155, 37.79679], [-122.48119, 37.79836], [-122.48076, 37.79958], [-122.47987, 37.80125], [-122.47822, 37.80549], [-122.47863, 37.80601], [-122.47865, 37.80609], [-122.47863, 37.80612], [-122.47866, 37.80617], [-122.47863, 37.80635], [-122.47862, 37.80647], [-122.47858, 37.80664], [-122.47853, 37.80707], [-122.47852, 37.80725], [-122.47849, 37.80731], [-122.4785, 37.80755], [-122.47848, 37.80783], [-122.47841, 37.80809], [-122.47806, 37.80828], [-122.4779, 37.80845], [-122.47789, 37.80853], [-122.47792, 37.80867], [-122.47796, 37.80925], [-122.47792, 37.80978], [-122.47796, 37.81011], [-122.47793, 37.81032], [-122.47798, 37.81054], [-122.47769, 37.81063], [-122.47774, 37.81094], [-122.47728, 37.81102], [-122.47728, 37.81089], [-122.47717, 37.81077], [-122.47736, 37.81066], [-122.47747, 37.81071], [-122.47751, 37.8107], [-122.47755, 37.81062], [-122.47754, 37.81059], [-122.47743, 37.81055], [-122.4774, 37.8102], [-122.47734, 37.81018], [-122.4772, 37.81025], [-122.47717, 37.81021], [-122.47709, 37.80952], [-122.47704, 37.80951], [-122.47699, 37.8091], [-122.47691, 37.80894], [-122.47677, 37.80871], [-122.47665, 37.80856], [-122.47647, 37.80835], [-122.4763, 37.8082], [-122.47562, 37.80865], [-122.47509, 37.80815], [-122.47492, 37.80818], [-122.47476, 37.80817], [-122.47375, 37.80785], [-122.47342, 37.80768], [-122.47307, 37.80738], [-122.47264, 37.80709], [-122.47262, 37.80701], [-122.47236, 37.80701], [-122.47214, 37.80695], [-122.47201, 37.80689], [-122.47145, 37.80655], [-122.47107, 37.80638], [-122.46998, 37.80603], [-122.46986, 37.80603], [-122.46882, 37.80621], [-122.46842, 37.80498], [-122.46824, 37.8047], [-122.46774, 37.80397], [-122.46744, 37.8037], [-122.46719, 37.80359], [-122.46122, 37.80286], [-122.46079, 37.80291], [-122.46046, 37.80307], [-122.46003, 37.80338], [-122.45977, 37.80352], [-122.44846, 37.80496], [-122.4484, 37.80459], [-122.44859, 37.80454], [-122.44882, 37.80444], [-122.44913, 37.80427], [-122.44942, 37.80403], [-122.44964, 37.80375], [-122.44977, 37.80349], [-122.44983, 37.80328], [-122.44986, 37.80305], [-122.44984, 37.80279], [-122.44977, 37.80253], [-122.44964, 37.80227], [-122.44944, 37.80202], [-122.4492, 37.80181], [-122.44889, 37.80161], [-122.44858, 37.80149], [-122.44827, 37.8014], [-122.44789, 37.80136], [-122.44691, 37.79501], [-122.44714, 37.795], [-122.44712, 37.79425], [-122.4468, 37.79424], [-122.44647, 37.79214], [-122.45194, 37.79104], [-122.4521, 37.79218], [-122.45287, 37.79205], [-122.4534, 37.79222], [-122.45597, 37.79153], [-122.45569, 37.7903], [-122.471, 37.78723], [-122.47101, 37.78765], [-122.47455, 37.78695], [-122.47454, 37.78679], [-122.47651, 37.78686], [-122.47675, 37.78685], [-122.47679, 37.7869], [-122.47713, 37.78701], [-122.47728, 37.78703], [-122.47746, 37.78701], [-122.47773, 37.78689], [-122.47796, 37.78685], [-122.47817, 37.78686], [-122.47854, 37.78697], [-122.47871, 37.787], [-122.479, 37.78699], [-122.47935, 37.78701], [-122.47967, 37.78697], [-122.47986, 37.78696], [-122.48004, 37.787], [-122.48023, 37.78706], [-122.4804, 37.78709], [-122.48057, 37.78708], [-122.48076, 37.78702], [-122.48089, 37.78702], [-122.48108, 37.78705], [-122.48118, 37.7871], [-122.48133, 37.78719], [-122.48148, 37.78723], [-122.4816, 37.78721], [-122.48217, 37.78724], [-122.48221, 37.78724], [-122.48237, 37.78709], [-122.48406, 37.78728], [-122.48431, 37.78735], [-122.48464, 37.78738], [-122.48467, 37.78753]]]} | Open Access 1 | 18880 | Presidio | 14267 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/prsf/index.htm | San Francisco 13 | 1314.067 | Presidio | 1910 | National Recreation Area 54 | 3 |
13148 | 13148 | 13147 | {"type": "Polygon", "coordinates": [[[-122.48598, 37.7908], [-122.48574, 37.79102], [-122.48541, 37.79147], [-122.48528, 37.79171], [-122.485, 37.79195], [-122.48475, 37.79221], [-122.48454, 37.79252], [-122.48436, 37.79274], [-122.48407, 37.7933], [-122.48386, 37.79365], [-122.48359, 37.79404], [-122.4833, 37.79466], [-122.48352, 37.79473], [-122.48309, 37.79561], [-122.483, 37.7959], [-122.48285, 37.79618], [-122.48267, 37.79681], [-122.48218, 37.79783], [-122.48217, 37.798], [-122.48214, 37.79813], [-122.48209, 37.79823], [-122.48213, 37.79833], [-122.48208, 37.79847], [-122.48204, 37.79851], [-122.48196, 37.79853], [-122.48187, 37.79854], [-122.48183, 37.79857], [-122.48193, 37.79877], [-122.4819, 37.79878], [-122.48179, 37.79869], [-122.48176, 37.79879], [-122.48174, 37.79881], [-122.48173, 37.79885], [-122.4817, 37.79886], [-122.48155, 37.79876], [-122.48155, 37.79879], [-122.48167, 37.79889], [-122.48168, 37.79893], [-122.48162, 37.79895], [-122.48156, 37.79903], [-122.48151, 37.79921], [-122.48138, 37.79937], [-122.48139, 37.79945], [-122.48131, 37.79952], [-122.4812, 37.79956], [-122.4811, 37.79962], [-122.48107, 37.7997], [-122.48106, 37.79982], [-122.48099, 37.79994], [-122.48097, 37.80033], [-122.48076, 37.80044], [-122.48065, 37.80065], [-122.48059, 37.80073], [-122.48038, 37.80109], [-122.4803, 37.80129], [-122.4802, 37.80142], [-122.48018, 37.80156], [-122.48007, 37.80184], [-122.48003, 37.80206], [-122.48004, 37.80223], [-122.4799, 37.8029], [-122.47961, 37.80343], [-122.4795, 37.80357], [-122.47936, 37.80386], [-122.47917, 37.80433], [-122.47915, 37.80448], [-122.47906, 37.80469], [-122.47895, 37.80488], [-122.47881, 37.80529], [-122.47873, 37.80549], [-122.47872, 37.80568], [-122.47869, 37.80596], [-122.47863, 37.80601], [-122.47822, 37.80549], [-122.47987, 37.80125], [-122.48076, 37.79958], [-122.48119, 37.79836], [-122.48155, 37.79679], [-122.48179, 37.79459], [-122.4822, 37.79248], [-122.48288, 37.79043], [-122.48382, 37.78928], [-122.48408, 37.7894], [-122.48426, 37.78941], [-122.48457, 37.78953], [-122.48472, 37.78956], [-122.48481, 37.78967], [-122.48486, 37.78979], [-122.48488, 37.78979], [-122.48489, 37.78973], [-122.485, 37.78985], [-122.48497, 37.78995], [-122.485, 37.79001], [-122.48496, 37.7901], [-122.48495, 37.7902], [-122.48505, 37.79037], [-122.4854, 37.79045], [-122.48598, 37.7908]]]} | Open Access 1 | 35095 | Baker Beach | 14193 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/prsf/planyourvisit/baker-beach.htm | San Francisco 13 | 48.266 | Baker Beach | 1910 | National Recreation Area 54 | 3 |
13152 | 13152 | 13151 | {"type": "Polygon", "coordinates": [[[-122.47154, 37.80864], [-122.47141, 37.80883], [-122.47093, 37.80872], [-122.4706, 37.8086], [-122.47003, 37.80943], [-122.46999, 37.80945], [-122.46992, 37.80943], [-122.4694, 37.8092], [-122.46939, 37.80917], [-122.46945, 37.80907], [-122.46951, 37.80905], [-122.47005, 37.80928], [-122.47053, 37.80858], [-122.47042, 37.80845], [-122.47023, 37.80835], [-122.47001, 37.8082], [-122.46982, 37.8081], [-122.46959, 37.80795], [-122.4693, 37.80773], [-122.46923, 37.80757], [-122.46911, 37.80737], [-122.46887, 37.80707], [-122.46879, 37.807], [-122.46864, 37.80692], [-122.46831, 37.80682], [-122.46815, 37.80698], [-122.46804, 37.80691], [-122.4682, 37.80675], [-122.46816, 37.8067], [-122.46777, 37.80645], [-122.4672, 37.80601], [-122.467, 37.80591], [-122.46668, 37.8058], [-122.46647, 37.80599], [-122.46606, 37.80642], [-122.46589, 37.80631], [-122.46595, 37.80624], [-122.46605, 37.8063], [-122.46607, 37.80629], [-122.46613, 37.80632], [-122.46664, 37.8058], [-122.46664, 37.80579], [-122.46608, 37.80558], [-122.4659, 37.80557], [-122.46565, 37.80549], [-122.46546, 37.80539], [-122.46423, 37.805], [-122.46399, 37.80494], [-122.46358, 37.80488], [-122.46327, 37.80489], [-122.46295, 37.80492], [-122.46243, 37.80501], [-122.46221, 37.80502], [-122.46203, 37.80496], [-122.4619, 37.80493], [-122.4616, 37.80496], [-122.46101, 37.80509], [-122.45977, 37.80525], [-122.45912, 37.8054], [-122.45834, 37.80549], [-122.45804, 37.80556], [-122.45764, 37.80569], [-122.45736, 37.80576], [-122.45671, 37.80585], [-122.45629, 37.80592], [-122.45567, 37.80608], [-122.45448, 37.80647], [-122.45435, 37.80648], [-122.45431, 37.80646], [-122.45429, 37.80638], [-122.45409, 37.80636], [-122.45382, 37.80629], [-122.4533, 37.80626], [-122.45244, 37.80627], [-122.45165, 37.80635], [-122.45046, 37.80665], [-122.44991, 37.80672], [-122.44972, 37.80672], [-122.44963, 37.80673], [-122.44948, 37.8068], [-122.4493, 37.80684], [-122.44905, 37.80682], [-122.44901, 37.80678], [-122.44889, 37.80673], [-122.44873, 37.8067], [-122.44846, 37.80496], [-122.45977, 37.80352], [-122.46003, 37.80338], [-122.46046, 37.80307], [-122.46079, 37.80291], [-122.46122, 37.80286], [-122.46719, 37.80359], [-122.46744, 37.8037], [-122.46774, 37.80396], [-122.46824, 37.8047], [-122.46842, 37.80498], [-122.46882, 37.8062], [-122.46986, 37.80603], [-122.46987, 37.80615], [-122.4699, 37.80627], [-122.46997, 37.80641], [-122.47004, 37.80651], [-122.47019, 37.80666], [-122.47056, 37.80692], [-122.47076, 37.80711], [-122.47086, 37.80724], [-122.47093, 37.80743], [-122.47099, 37.80764], [-122.47107, 37.80803], [-122.47118, 37.80827], [-122.47106, 37.80841], [-122.47154, 37.80864]]]} | Open Access 1 | 35097 | Crissy Field | 14207 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/goga/planyourvisit/crissy-field-access.htm | San Francisco 13 | 105.424 | Crissy Field | 1910 | National Recreation Area 54 | 3 |
15721 | 15721 | 15720 | {"type": "Polygon", "coordinates": [[[-122.47755, 37.81063], [-122.47751, 37.81069], [-122.47747, 37.81071], [-122.47736, 37.81067], [-122.47718, 37.81076], [-122.47728, 37.81089], [-122.47728, 37.81105], [-122.47708, 37.81103], [-122.47691, 37.811], [-122.47659, 37.81089], [-122.47656, 37.81089], [-122.47647, 37.81084], [-122.4764, 37.81076], [-122.47624, 37.81042], [-122.47619, 37.81024], [-122.47615, 37.80986], [-122.47605, 37.80964], [-122.47597, 37.80957], [-122.47579, 37.80949], [-122.47554, 37.80939], [-122.47495, 37.80926], [-122.4748, 37.80918], [-122.47406, 37.80911], [-122.47325, 37.8091], [-122.47225, 37.80897], [-122.47181, 37.80887], [-122.47158, 37.80886], [-122.47141, 37.80883], [-122.47154, 37.80864], [-122.47105, 37.80841], [-122.47118, 37.80827], [-122.47107, 37.80803], [-122.47099, 37.80764], [-122.47093, 37.80743], [-122.47086, 37.80724], [-122.47076, 37.80711], [-122.47056, 37.80692], [-122.47019, 37.80666], [-122.47004, 37.80651], [-122.46997, 37.80641], [-122.4699, 37.80627], [-122.46987, 37.80615], [-122.46986, 37.80603], [-122.46998, 37.80603], [-122.47122, 37.80644], [-122.47145, 37.80655], [-122.47201, 37.80689], [-122.47216, 37.80696], [-122.47239, 37.80701], [-122.47263, 37.80701], [-122.47264, 37.8071], [-122.47307, 37.80738], [-122.47343, 37.80768], [-122.47375, 37.80785], [-122.47476, 37.80817], [-122.47492, 37.80818], [-122.47509, 37.80815], [-122.47562, 37.80865], [-122.4763, 37.8082], [-122.47647, 37.80835], [-122.47665, 37.80856], [-122.47677, 37.80871], [-122.47691, 37.80894], [-122.47699, 37.8091], [-122.47704, 37.80951], [-122.47709, 37.80951], [-122.47717, 37.81021], [-122.47721, 37.81025], [-122.47734, 37.81018], [-122.4774, 37.8102], [-122.47743, 37.81055], [-122.47754, 37.81059], [-122.47755, 37.81063]]]} | Open Access 1 | 35093 | Fort Point National Historic Site | 14216 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/fopo/index.htm | San Francisco 13 | 25.881 | Fort Point NHS | 1910 | Historic or Cultural Area 350 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);