units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, COUNTY = 23 and DES_TP = 883
This data as json, copyable, CSV (advanced)
| 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 |
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]);