units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACRES = "81.96"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10157 | 10157 | 10156 | {"type": "MultiPolygon", "coordinates": [[[[-122.54648, 37.89106], [-122.54618, 37.89142], [-122.54618, 37.89165], [-122.54609, 37.89175], [-122.54565, 37.89185], [-122.54495, 37.89111], [-122.54448, 37.8912], [-122.54455, 37.89153], [-122.54446, 37.89171], [-122.5439, 37.89175], [-122.5438, 37.89191], [-122.54389, 37.89226], [-122.54355, 37.89243], [-122.54351, 37.89269], [-122.54333, 37.89276], [-122.54311, 37.89264], [-122.54269, 37.89199], [-122.54267, 37.89152], [-122.5425, 37.8914], [-122.54198, 37.89142], [-122.54168, 37.89097], [-122.54129, 37.89086], [-122.54102, 37.89066], [-122.54161, 37.8908], [-122.5423, 37.89117], [-122.54284, 37.89107], [-122.5431, 37.89116], [-122.54331, 37.89142], [-122.5435, 37.89132], [-122.54394, 37.89127], [-122.54405, 37.89102], [-122.54425, 37.89077], [-122.54439, 37.89078], [-122.5446, 37.89076], [-122.54473, 37.89065], [-122.54519, 37.89069], [-122.5453, 37.89097], [-122.54556, 37.8912], [-122.54579, 37.89122], [-122.54595, 37.8911], [-122.54612, 37.89094], [-122.54624, 37.89063], [-122.54648, 37.89106]]], [[[-122.54349, 37.89539], [-122.54347, 37.89544], [-122.54346, 37.8954], [-122.54342, 37.89537], [-122.54349, 37.89539]]], [[[-122.54457, 37.89843], [-122.54454, 37.89852], [-122.54431, 37.89838], [-122.54396, 37.89836], [-122.54356, 37.89846], [-122.54353, 37.89851], [-122.54355, 37.89842], [-122.54381, 37.89829], [-122.54457, 37.89843]]], [[[-122.54524, 37.89662], [-122.54495, 37.89745], [-122.54455, 37.89707], [-122.54435, 37.89702], [-122.54455, 37.89647], [-122.54524, 37.89662]]], [[[-122.54886, 37.89818], [-122.54873, 37.89861], [-122.54853, 37.89862], [-122.54843, 37.89906], [-122.5482, 37.89916], [-122.54795, 37.89936], [-122.54773, 37.89922], [-122.5474, 37.89896], [-122.54714, 37.89886], [-122.54689, 37.89881], [-122.54666, 37.89882], [-122.54653, 37.89896], [-122.54657, 37.89941], [-122.54639, 37.89953], [-122.54624, 37.89948], [-122.54591, 37.8992], [-122.54565, 37.89921], [-122.54538, 37.89944], [-122.54523, 37.89949], [-122.54515, 37.89933], [-122.54511, 37.89908], [-122.54469, 37.8986], [-122.5446, 37.89855], [-122.54466, 37.89839], [-122.54604, 37.89863], [-122.54592, 37.89747], [-122.54605, 37.89743], [-122.54708, 37.89761], [-122.5475, 37.89775], [-122.5477, 37.89797], [-122.54783, 37.89836], [-122.54789, 37.89848], [-122.54856, 37.89819], [-122.54886, 37.89818]]], [[[-122.54617, 37.89952], [-122.54602, 37.89949], [-122.54586, 37.89991], [-122.54581, 37.89991], [-122.54573, 37.89993], [-122.54569, 37.8996], [-122.54554, 37.89959], [-122.54573, 37.89935], [-122.54589, 37.89928], [-122.54617, 37.89952]]], [[[-122.54724, 37.89957], [-122.54664, 37.89979], [-122.54665, 37.90002], [-122.54632, 37.89998], [-122.54645, 37.8996], [-122.54666, 37.89944], [-122.54662, 37.89898], [-122.54671, 37.89889], [-122.54681, 37.89888], [-122.54724, 37.89957]]], [[[-122.54791, 37.89944], [-122.54788, 37.8996], [-122.54748, 37.89974], [-122.54693, 37.89888], [-122.54709, 37.89892], [-122.54735, 37.89902], [-122.54766, 37.89928], [-122.54791, 37.89944]]], [[[-122.55628, 37.89625], [-122.55471, 37.89762], [-122.55462, 37.8974], [-122.55422, 37.89739], [-122.55357, 37.89742], [-122.55338, 37.89741], [-122.55306, 37.89727], [-122.55313, 37.8972], [-122.55348, 37.89708], [-122.55367, 37.89698], [-122.55368, 37.89655], [-122.55342, 37.89656], [-122.55329, 37.89638], [-122.55304, 37.89633], [-122.55285, 37.89635], [-122.55261, 37.89646], [-122.55254, 37.89651], [-122.55212, 37.89669], [-122.55196, 37.89673], [-122.55188, 37.8967], [-122.55185, 37.89666], [-122.55184, 37.89627], [-122.55157, 37.89626], [-122.55128, 37.89632], [-122.55111, 37.89629], [-122.5507, 37.89627], [-122.54961, 37.89592], [-122.5494, 37.89581], [-122.54876, 37.89554], [-122.54859, 37.89556], [-122.54899, 37.89481], [-122.54856, 37.89484], [-122.54742, 37.89457], [-122.54802, 37.89432], [-122.54816, 37.89418], [-122.54938, 37.89473], [-122.54941, 37.89469], [-122.5482, 37.89413], [-122.54791, 37.89404], [-122.54751, 37.89405], [-122.54751, 37.8938], [-122.54714, 37.89384], [-122.547, 37.89375], [-122.54794, 37.89274], [-122.54796, 37.89283], [-122.54827, 37.89301], [-122.54836, 37.89302], [-122.54885, 37.89285], [-122.54905, 37.89295], [-122.54897, 37.89307], [-122.54915, 37.89334], [-122.54938, 37.89338], [-122.54957, 37.8933], [-122.54985, 37.89289], [-122.54998, 37.89286], [-122.54999, 37.89309], [-122.55015, 37.89336], [-122.5509, 37.8935], [-122.55104, 37.8941], [-122.55124, 37.89419], [-122.55145, 37.89419], [-122.55139, 37.89437], [-122.55149, 37.89467], [-122.55174, 37.89487], [-122.55224, 37.89483], [-122.55258, 37.89489], [-122.55287, 37.89478], [-122.55326, 37.89496], [-122.55393, 37.89466], [-122.55397, 37.89487], [-122.55486, 37.89503], [-122.55513, 37.89512], [-122.55542, 37.8951], [-122.55504, 37.89552], [-122.55628, 37.89625]]], [[[-122.55177, 37.90116], [-122.55169, 37.90118], [-122.55116, 37.90116], [-122.55096, 37.90103], [-122.55124, 37.90077], [-122.55123, 37.90076], [-122.55089, 37.90052], [-122.55077, 37.90062], [-122.55056, 37.9005], [-122.55061, 37.90031], [-122.54989, 37.9003], [-122.54957, 37.90021], [-122.54964, 37.90004], [-122.54973, 37.90005], [-122.55003, 37.89991], [-122.55026, 37.89988], [-122.55062, 37.89999], [-122.55093, 37.90014], [-122.55116, 37.90014], [-122.5513, 37.90022], [-122.55143, 37.90042], [-122.55163, 37.90061], [-122.55164, 37.90082], [-122.55174, 37.90097], [-122.55177, 37.90116]]], [[[-122.55073, 37.89974], [-122.55068, 37.89992], [-122.55029, 37.8998], [-122.55013, 37.89978], [-122.54999, 37.89977], [-122.55001, 37.89968], [-122.55073, 37.89974]]], [[[-122.55211, 37.90037], [-122.55194, 37.90111], [-122.55185, 37.90114], [-122.55183, 37.90095], [-122.55174, 37.9008], [-122.55172, 37.90057], [-122.55151, 37.90036], [-122.55136, 37.90015], [-122.55119, 37.90005], [-122.55097, 37.90006], [-122.55072, 37.89994], [-122.55078, 37.89972], [-122.55146, 37.89979], [-122.55211, 37.90037]]], [[[-122.55471, 37.89789], [-122.55463, 37.89801], [-122.5547, 37.89819], [-122.5541, 37.89864], [-122.55366, 37.89845], [-122.55327, 37.89841], [-122.55298, 37.89828], [-122.5523, 37.89814], [-122.55261, 37.89778], [-122.552, 37.89761], [-122.55216, 37.89714], [-122.55147, 37.89726], [-122.55148, 37.89714], [-122.55218, 37.89682], [-122.55265, 37.89663], [-122.55276, 37.89656], [-122.55292, 37.89648], [-122.55305, 37.89647], [-122.55319, 37.89649], [-122.55334, 37.89671], [-122.55352, 37.89671], [-122.55352, 37.8969], [-122.55337, 37.89697], [-122.553, 37.89711], [-122.55281, 37.89732], [-122.55332, 37.89754], [-122.55353, 37.89756], [-122.55449, 37.89752], [-122.55456, 37.89768], [-122.55471, 37.89781], [-122.55471, 37.89789]]], [[[-122.55391, 37.89871], [-122.55384, 37.8989], [-122.55361, 37.89895], [-122.55343, 37.89904], [-122.55323, 37.89906], [-122.55325, 37.89882], [-122.55254, 37.89868], [-122.55236, 37.8993], [-122.55221, 37.8995], [-122.55216, 37.8995], [-122.55203, 37.89922], [-122.55182, 37.89909], [-122.55213, 37.89825], [-122.55289, 37.8984], [-122.55326, 37.89854], [-122.55361, 37.89857], [-122.55391, 37.89871]]], [[[-122.55707, 37.90244], [-122.5568, 37.90254], [-122.55659, 37.90249], [-122.55613, 37.90211], [-122.55553, 37.90156], [-122.55633, 37.90085], [-122.55658, 37.90099], [-122.5569, 37.90172], [-122.55707, 37.90244]]]]} | No Public Access 3 | 17705 | Homestead Valley | 20064 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 81.96 | Homestead Valley | None 883 | |||
16059 | 16059 | 16058 | {"type": "MultiPolygon", "coordinates": [[[[-118.35868, 34.10722], [-118.35756, 34.10974], [-118.35507, 34.11185], [-118.35506, 34.10834], [-118.35528, 34.10832], [-118.35553, 34.1089], [-118.35563, 34.10905], [-118.35554, 34.10924], [-118.35559, 34.10931], [-118.35562, 34.10949], [-118.35568, 34.10962], [-118.35569, 34.10979], [-118.35644, 34.10981], [-118.35662, 34.10947], [-118.3567, 34.10905], [-118.35659, 34.10871], [-118.35669, 34.10825], [-118.35652, 34.10795], [-118.3563, 34.10786], [-118.35639, 34.10772], [-118.35649, 34.1076], [-118.35651, 34.10749], [-118.35647, 34.10739], [-118.35631, 34.10726], [-118.35624, 34.1071], [-118.35625, 34.10706], [-118.35635, 34.10692], [-118.35639, 34.1067], [-118.35652, 34.10657], [-118.35656, 34.1065], [-118.35666, 34.10621], [-118.35668, 34.10608], [-118.35665, 34.10581], [-118.35666, 34.10575], [-118.3567, 34.10572], [-118.35675, 34.10571], [-118.35688, 34.10575], [-118.35699, 34.10575], [-118.35706, 34.10573], [-118.35722, 34.10562], [-118.35722, 34.10532], [-118.35758, 34.10544], [-118.35778, 34.10544], [-118.35802, 34.10533], [-118.35804, 34.10534], [-118.35804, 34.10538], [-118.35813, 34.10544], [-118.35822, 34.10534], [-118.35866, 34.10534], [-118.35832, 34.10571], [-118.35835, 34.10581], [-118.35847, 34.1058], [-118.35868, 34.10722]]], [[[-118.36078, 34.10817], [-118.36067, 34.10855], [-118.36034, 34.10989], [-118.36028, 34.11005], [-118.36028, 34.11012], [-118.36033, 34.11021], [-118.3604, 34.1105], [-118.36025, 34.11077], [-118.36022, 34.11086], [-118.36023, 34.11096], [-118.36032, 34.11117], [-118.36041, 34.11128], [-118.36048, 34.1114], [-118.3606, 34.1115], [-118.36068, 34.11161], [-118.36071, 34.11173], [-118.36069, 34.11192], [-118.36069, 34.11201], [-118.36061, 34.11203], [-118.36065, 34.11215], [-118.3603, 34.11226], [-118.36037, 34.11237], [-118.36033, 34.11267], [-118.36019, 34.11288], [-118.36029, 34.11303], [-118.36023, 34.11347], [-118.36018, 34.1135], [-118.35984, 34.11351], [-118.35968, 34.11359], [-118.35956, 34.11361], [-118.35954, 34.11354], [-118.35941, 34.11354], [-118.35931, 34.11346], [-118.35919, 34.11342], [-118.35866, 34.11346], [-118.35868, 34.11352], [-118.3588, 34.11351], [-118.35884, 34.11354], [-118.35884, 34.11356], [-118.3588, 34.11368], [-118.3588, 34.11377], [-118.35888, 34.114], [-118.35893, 34.11408], [-118.35905, 34.11417], [-118.35962, 34.11445], [-118.35968, 34.11453], [-118.3597, 34.11459], [-118.35967, 34.11469], [-118.35959, 34.11477], [-118.35932, 34.11493], [-118.35889, 34.1151], [-118.35883, 34.11516], [-118.3588, 34.11524], [-118.35881, 34.11536], [-118.35895, 34.11559], [-118.35904, 34.11568], [-118.35917, 34.11573], [-118.35979, 34.11578], [-118.35983, 34.11582], [-118.35991, 34.11597], [-118.35986, 34.11632], [-118.35982, 34.11636], [-118.35957, 34.11654], [-118.35949, 34.11665], [-118.35948, 34.11677], [-118.35953, 34.11697], [-118.35951, 34.11707], [-118.35947, 34.11712], [-118.35935, 34.1172], [-118.35919, 34.11722], [-118.35889, 34.11711], [-118.35898, 34.11702], [-118.35911, 34.11705], [-118.35925, 34.11701], [-118.35918, 34.11665], [-118.35903, 34.11659], [-118.35911, 34.11644], [-118.35906, 34.11632], [-118.35872, 34.11625], [-118.35829, 34.116], [-118.3583, 34.11598], [-118.35791, 34.11536], [-118.35789, 34.11464], [-118.35744, 34.11457], [-118.35731, 34.11457], [-118.35725, 34.11474], [-118.35685, 34.11467], [-118.35674, 34.11462], [-118.35666, 34.11455], [-118.35649, 34.11433], [-118.35646, 34.11427], [-118.35646, 34.11421], [-118.35654, 34.11379], [-118.35658, 34.11371], [-118.35685, 34.11331], [-118.35694, 34.11303], [-118.35699, 34.11292], [-118.3572, 34.11271], [-118.35731, 34.11263], [-118.35745, 34.11258], [-118.35793, 34.11249], [-118.35791, 34.11242], [-118.35779, 34.11244], [-118.35802, 34.11234], [-118.35808, 34.11228], [-118.35808, 34.11221], [-118.358, 34.11184], [-118.35801, 34.11181], [-118.35809, 34.11181], [-118.35827, 34.11092], [-118.35813, 34.11026], [-118.35791, 34.11023], [-118.35726, 34.1108], [-118.35727, 34.112], [-118.35648, 34.11247], [-118.35508, 34.11246], [-118.35508, 34.11224], [-118.35784, 34.10989], [-118.3587, 34.10797], [-118.35881, 34.10797], [-118.3589, 34.10799], [-118.35897, 34.10804], [-118.35908, 34.10816], [-118.3591, 34.10827], [-118.35901, 34.10862], [-118.35902, 34.10867], [-118.35905, 34.10871], [-118.35968, 34.1082], [-118.35974, 34.10809], [-118.35981, 34.10811], [-118.35983, 34.10806], [-118.36029, 34.10792], [-118.3606, 34.10801], [-118.36078, 34.10817]]], [[[-118.36008, 34.10715], [-118.3595, 34.10714], [-118.35912, 34.10745], [-118.35899, 34.10734], [-118.35903, 34.10726], [-118.35889, 34.10634], [-118.35903, 34.10633], [-118.35906, 34.10648], [-118.35912, 34.10661], [-118.3594, 34.10688], [-118.35974, 34.10704], [-118.36008, 34.10715]]]]} | Open Access 1 | 6883 | Trebek Open Space | 29901 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 81.96 | Trebek OS | 0 | Local Recreation Area 3 | 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]);