units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 86, DES_TP = 698 and MNG_AG_TYP = 2
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8355 | 8355 | 8354 | {"type": "MultiPolygon", "coordinates": [[[[-117.02058, 33.16665], [-117.01805, 33.16641], [-117.01794, 33.16623], [-117.01779, 33.16609], [-117.01764, 33.16601], [-117.01734, 33.16591], [-117.01725, 33.16585], [-117.01715, 33.16574], [-117.01709, 33.16561], [-117.01701, 33.16528], [-117.01685, 33.16487], [-117.01683, 33.16462], [-117.0168, 33.16448], [-117.01674, 33.16435], [-117.01667, 33.16425], [-117.01658, 33.16416], [-117.01643, 33.16407], [-117.01628, 33.16402], [-117.01611, 33.164], [-117.01599, 33.16401], [-117.01584, 33.16405], [-117.01573, 33.1641], [-117.01562, 33.16417], [-117.0155, 33.16432], [-117.01533, 33.16465], [-117.01523, 33.16475], [-117.01514, 33.16481], [-117.01376, 33.16536], [-117.01358, 33.16545], [-117.01342, 33.16548], [-117.01281, 33.16553], [-117.0123, 33.16563], [-117.01206, 33.1657], [-117.0119, 33.16577], [-117.01177, 33.16586], [-117.01159, 33.16602], [-117.01141, 33.16611], [-117.01127, 33.16615], [-117.01059, 33.16625], [-117.01011, 33.16638], [-117.00974, 33.16654], [-117.00911, 33.16688], [-117.00845, 33.16715], [-117.0078, 33.16703], [-117.0074, 33.16693], [-117.00716, 33.16684], [-117.00688, 33.16669], [-117.00617, 33.16642], [-117.00598, 33.16639], [-117.00552, 33.16639], [-117.00536, 33.16636], [-117.00524, 33.16631], [-117.00495, 33.1661], [-117.00484, 33.16605], [-117.00468, 33.16602], [-117.00444, 33.16603], [-117.00417, 33.16612], [-117.00381, 33.1662], [-117.00368, 33.16626], [-117.00335, 33.1665], [-117.00311, 33.16663], [-117.003, 33.16665], [-117.0026, 33.16663], [-117.00246, 33.16665], [-117.00235, 33.1667], [-117.00233, 33.16444], [-117.00669, 33.16416], [-117.01268, 33.16299], [-117.01479, 33.16263], [-117.01957, 33.16279], [-117.02058, 33.16665]]], [[[-117.0181, 33.17002], [-117.01749, 33.16997], [-117.01752, 33.16978], [-117.0159, 33.16621], [-117.00749, 33.16844], [-117.00764, 33.1682], [-117.00786, 33.16793], [-117.00839, 33.1674], [-117.00861, 33.16726], [-117.00924, 33.16701], [-117.00983, 33.16668], [-117.01017, 33.16654], [-117.01064, 33.16641], [-117.01128, 33.16632], [-117.01151, 33.16625], [-117.01172, 33.16614], [-117.01199, 33.16592], [-117.01221, 33.16583], [-117.01271, 33.16571], [-117.01291, 33.16568], [-117.01348, 33.16564], [-117.01374, 33.16557], [-117.01387, 33.1655], [-117.01525, 33.16495], [-117.01538, 33.16486], [-117.01549, 33.16474], [-117.01569, 33.16438], [-117.01577, 33.16428], [-117.01596, 33.16419], [-117.01607, 33.16417], [-117.01618, 33.16417], [-117.01631, 33.1642], [-117.01642, 33.16426], [-117.01651, 33.16434], [-117.01658, 33.16444], [-117.01663, 33.16463], [-117.01664, 33.16481], [-117.01666, 33.16493], [-117.01683, 33.16534], [-117.01691, 33.16569], [-117.01699, 33.16584], [-117.01708, 33.16594], [-117.0172, 33.16603], [-117.01735, 33.16611], [-117.01757, 33.16617], [-117.01771, 33.16626], [-117.01781, 33.16637], [-117.018, 33.16673], [-117.0181, 33.17002]]], [[[-117.00051, 33.17509], [-117.00052, 33.17525], [-117.00049, 33.17543], [-117.00042, 33.17559], [-117.00034, 33.17571], [-117.00034, 33.17544], [-117.00024, 33.17534], [-117.00051, 33.17509]]], [[[-117.00669, 33.17565], [-117.0026, 33.17584], [-117.0004, 33.17594], [-117.00058, 33.1757], [-117.00069, 33.17544], [-117.00071, 33.17529], [-117.00071, 33.17517], [-117.00068, 33.17493], [-117.00284, 33.17286], [-117.00303, 33.17269], [-117.00453, 33.17118], [-117.00665, 33.16939], [-117.00669, 33.17565]]], [[[-116.99737, 33.17557], [-116.99612, 33.176], [-116.9957, 33.17599], [-116.9957, 33.17655], [-116.99461, 33.17656], [-116.99425, 33.17734], [-116.99399, 33.17734], [-116.99398, 33.17596], [-116.99386, 33.17595], [-116.99407, 33.17572], [-116.99423, 33.1756], [-116.99439, 33.1755], [-116.9947, 33.17538], [-116.99504, 33.1753], [-116.99645, 33.17526], [-116.99671, 33.17529], [-116.99696, 33.17536], [-116.99719, 33.17546], [-116.99737, 33.17557]]], [[[-116.97995, 33.16806], [-116.989, 33.16827], [-116.98907, 33.17206], [-116.99359, 33.17216], [-116.9936, 33.17215], [-116.99354, 33.16838], [-116.99528, 33.16841], [-116.99531, 33.16829], [-116.99535, 33.16808], [-116.99537, 33.16764], [-116.99533, 33.167], [-116.99535, 33.16665], [-116.99532, 33.16649], [-116.99524, 33.16629], [-116.99524, 33.16624], [-116.99526, 33.16614], [-116.9953, 33.16608], [-116.99544, 33.16617], [-116.99552, 33.16612], [-116.99568, 33.16606], [-116.99598, 33.166], [-116.99622, 33.166], [-116.99663, 33.16605], [-116.99694, 33.16614], [-116.99782, 33.16649], [-116.99804, 33.16662], [-116.99809, 33.16848], [-117.00235, 33.16858], [-117.00236, 33.16693], [-117.00248, 33.16686], [-117.00261, 33.16682], [-117.00301, 33.16685], [-117.00322, 33.16681], [-117.00347, 33.16668], [-117.00388, 33.16639], [-117.00416, 33.16633], [-117.00456, 33.16621], [-117.00468, 33.16621], [-117.00482, 33.16626], [-117.00511, 33.16647], [-117.00531, 33.16656], [-117.00547, 33.16659], [-117.00595, 33.16659], [-117.00609, 33.16661], [-117.00675, 33.16685], [-117.00707, 33.16702], [-117.00729, 33.16711], [-117.00761, 33.16719], [-117.00823, 33.1673], [-117.00757, 33.16798], [-117.00744, 33.16816], [-117.00721, 33.16852], [-117.00663, 33.16868], [-117.00665, 33.16915], [-117.00456, 33.17091], [-117.0041, 33.17135], [-117.00289, 33.17258], [-117.00269, 33.17275], [-117.0006, 33.17475], [-117.0005, 33.1746], [-117.00038, 33.17447], [-117.00014, 33.17429], [-116.99995, 33.17418], [-116.99988, 33.17427], [-117.00009, 33.17443], [-117.0003, 33.17463], [-117.0004, 33.17476], [-117.00046, 33.17489], [-117.00011, 33.17521], [-116.99991, 33.17502], [-116.99965, 33.17519], [-116.99953, 33.17526], [-116.99935, 33.17539], [-116.99915, 33.17573], [-116.99889, 33.176], [-116.9985, 33.17602], [-116.99795, 33.17584], [-116.99782, 33.17574], [-116.99764, 33.17556], [-116.99739, 33.17538], [-116.9971, 33.17523], [-116.9968, 33.17513], [-116.99659, 33.1751], [-116.9964, 33.17509], [-116.99502, 33.17514], [-116.99482, 33.17517], [-116.99457, 33.17524], [-116.99429, 33.17536], [-116.99405, 33.17551], [-116.99381, 33.17573], [-116.99352, 33.17612], [-116.99323, 33.17663], [-116.99305, 33.17704], [-116.99288, 33.17753], [-116.99278, 33.17771], [-116.99267, 33.17784], [-116.99252, 33.17797], [-116.99235, 33.17807], [-116.99214, 33.17815], [-116.99197, 33.17819], [-116.99173, 33.17821], [-116.99153, 33.17819], [-116.99134, 33.17815], [-116.99105, 33.17803], [-116.99068, 33.17777], [-116.99091, 33.17777], [-116.9909, 33.17762], [-116.99056, 33.17762], [-116.99055, 33.17769], [-116.99031, 33.17756], [-116.99006, 33.17748], [-116.98983, 33.17743], [-116.98953, 33.1774], [-116.98924, 33.17742], [-116.98481, 33.17812], [-116.98453, 33.1782], [-116.98434, 33.17828], [-116.98267, 33.1792], [-116.98233, 33.17933], [-116.98198, 33.17941], [-116.98159, 33.17945], [-116.98128, 33.17944], [-116.98045, 33.17938], [-116.98016, 33.17938], [-116.9798, 33.17943], [-116.97547, 33.18047], [-116.97495, 33.18064], [-116.97449, 33.18081], [-116.97223, 33.18185], [-116.9721, 33.18192], [-116.97179, 33.18098], [-116.97175, 33.18082], [-116.97173, 33.18067], [-116.97171, 33.17842], [-116.97168, 33.17826], [-116.97163, 33.17811], [-116.97149, 33.17789], [-116.97144, 33.17211], [-116.97138, 33.1682], [-116.97995, 33.16806]], [[-116.98024, 33.17565], [-116.98252, 33.17572], [-116.98469, 33.17575], [-116.98467, 33.1742], [-116.98462, 33.17198], [-116.98009, 33.17189], [-116.97577, 33.17201], [-116.97583, 33.17577], [-116.98024, 33.17565]], [[-116.99575, 33.1674], [-116.99574, 33.16734], [-116.9957, 33.16729], [-116.99557, 33.16724], [-116.99559, 33.16764], [-116.99564, 33.16764], [-116.9957, 33.16758], [-116.99574, 33.16748], [-116.99575, 33.1674]]], [[[-116.97193, 33.18205], [-116.97174, 33.18227], [-116.97157, 33.18261], [-116.97154, 33.18077], [-116.97159, 33.18099], [-116.97193, 33.18205]]], [[[-116.98479, 33.17976], [-116.98039, 33.17976], [-116.98052, 33.18323], [-116.9716, 33.18333], [-116.97168, 33.1829], [-116.97182, 33.18253], [-116.97198, 33.18227], [-116.97217, 33.18208], [-116.97233, 33.18199], [-116.97449, 33.181], [-116.97497, 33.18081], [-116.97549, 33.18064], [-116.97987, 33.17959], [-116.98018, 33.17955], [-116.98047, 33.17954], [-116.98135, 33.17961], [-116.9816, 33.17961], [-116.98192, 33.17959], [-116.98223, 33.17953], [-116.98247, 33.17946], [-116.98276, 33.17935], [-116.98443, 33.17843], [-116.98475, 33.17831], [-116.98479, 33.17976]]]]} | Open Access 1 | 12876 | Lake Wohlford | 3582 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/lake-wohlford.aspx | San Diego 4 | 994.039 | Lake Wohlford | 0 | None 698 |
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]);