units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 4, MNG_AG_TYP = 3 and UNIT_NAME = "Tijuana River Valley Regional Park"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13224 | 13224 | 13223 | {"type": "MultiPolygon", "coordinates": [[[[-117.09269, 32.55829], [-117.09263, 32.56415], [-117.09055, 32.56414], [-117.09051, 32.56369], [-117.08947, 32.56369], [-117.08949, 32.56007], [-117.09055, 32.56006], [-117.09056, 32.55828], [-117.09269, 32.55829]]], [[[-117.10137, 32.56011], [-117.10133, 32.56544], [-117.09793, 32.56548], [-117.0971, 32.56548], [-117.09709, 32.56469], [-117.09388, 32.56469], [-117.09387, 32.56424], [-117.09282, 32.56424], [-117.09285, 32.55829], [-117.09377, 32.55829], [-117.09567, 32.559], [-117.09568, 32.55829], [-117.09604, 32.55829], [-117.09604, 32.55914], [-117.09819, 32.55915], [-117.09819, 32.55956], [-117.09926, 32.55957], [-117.09926, 32.56009], [-117.10137, 32.56011]]]]} | Open Access 1 | 45246 | Tijuana River Valley Regional Park | 13879 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 169.576 | Tijuana River Valley RP | 0 | Local Park 2 | 4 |
| 16429 | 16429 | 16428 | {"type": "MultiPolygon", "coordinates": [[[[-117.08193, 32.54359], [-117.08193, 32.54404], [-117.08176, 32.54414], [-117.08156, 32.5442], [-117.08155, 32.54359], [-117.08193, 32.54359]]], [[[-117.07141, 32.54461], [-117.07128, 32.54463], [-117.07119, 32.54462], [-117.07116, 32.54459], [-117.07116, 32.54444], [-117.07129, 32.54455], [-117.07141, 32.54461]]], [[[-117.07302, 32.54484], [-117.07156, 32.54449], [-117.07146, 32.54445], [-117.07129, 32.54433], [-117.07124, 32.54426], [-117.07116, 32.54411], [-117.07119, 32.54305], [-117.07115, 32.54289], [-117.0711, 32.54274], [-117.07131, 32.54285], [-117.07146, 32.54295], [-117.07173, 32.54316], [-117.07189, 32.54332], [-117.07205, 32.54351], [-117.07215, 32.54367], [-117.07302, 32.54484]]], [[[-117.08194, 32.5453], [-117.08157, 32.5453], [-117.08156, 32.54434], [-117.08174, 32.5443], [-117.08193, 32.54421], [-117.08194, 32.5453]]], [[[-117.10157, 32.53695], [-117.10155, 32.54306], [-117.10157, 32.54478], [-117.10121, 32.54501], [-117.10092, 32.54514], [-117.1002, 32.54563], [-117.09998, 32.54581], [-117.09956, 32.546], [-117.09935, 32.54605], [-117.09903, 32.54607], [-117.09874, 32.54603], [-117.0985, 32.54596], [-117.09686, 32.54563], [-117.09677, 32.54557], [-117.09665, 32.54552], [-117.09639, 32.54545], [-117.09605, 32.54544], [-117.0959, 32.54547], [-117.09562, 32.54548], [-117.09537, 32.54545], [-117.09509, 32.54536], [-117.09495, 32.54528], [-117.09482, 32.54519], [-117.0947, 32.5451], [-117.09458, 32.54496], [-117.09353, 32.54441], [-117.09332, 32.54436], [-117.0931, 32.54435], [-117.09292, 32.54438], [-117.09278, 32.54442], [-117.09276, 32.54356], [-117.08828, 32.54358], [-117.08812, 32.54352], [-117.08642, 32.54351], [-117.08408, 32.54353], [-117.08407, 32.54252], [-117.08272, 32.54252], [-117.08272, 32.54354], [-117.08084, 32.54355], [-117.08084, 32.54437], [-117.08016, 32.54452], [-117.08013, 32.54355], [-117.07795, 32.54357], [-117.07796, 32.54485], [-117.07627, 32.54486], [-117.07627, 32.5459], [-117.07563, 32.54584], [-117.07424, 32.54583], [-117.07411, 32.5458], [-117.07399, 32.54576], [-117.07389, 32.5457], [-117.07377, 32.5456], [-117.07228, 32.5436], [-117.07219, 32.54344], [-117.07199, 32.5432], [-117.07178, 32.54301], [-117.07153, 32.54281], [-117.07128, 32.54267], [-117.0711, 32.54258], [-117.07112, 32.54], [-117.07334, 32.53999], [-117.07946, 32.53946], [-117.08409, 32.53926], [-117.08506, 32.54025], [-117.08758, 32.54023], [-117.08759, 32.53999], [-117.08846, 32.53953], [-117.09009, 32.53933], [-117.09193, 32.53891], [-117.09453, 32.53864], [-117.09532, 32.53862], [-117.09568, 32.53891], [-117.0965, 32.53891], [-117.09718, 32.53853], [-117.09849, 32.53814], [-117.10007, 32.53686], [-117.10157, 32.53695]]], [[[-117.10585, 32.54377], [-117.10584, 32.54731], [-117.10576, 32.54732], [-117.10576, 32.54377], [-117.10585, 32.54377]]], [[[-117.1016, 32.54732], [-117.09288, 32.54732], [-117.09285, 32.54664], [-117.09285, 32.54512], [-117.09284, 32.54473], [-117.09281, 32.54459], [-117.09291, 32.54455], [-117.09314, 32.54451], [-117.09328, 32.54452], [-117.09344, 32.54456], [-117.0936, 32.54463], [-117.0937, 32.54471], [-117.09445, 32.54508], [-117.09457, 32.54521], [-117.09471, 32.54534], [-117.09486, 32.54544], [-117.09503, 32.54552], [-117.09532, 32.54561], [-117.09558, 32.54565], [-117.09582, 32.54565], [-117.09608, 32.5456], [-117.09636, 32.54561], [-117.0966, 32.54568], [-117.09678, 32.54579], [-117.09844, 32.54612], [-117.09853, 32.54616], [-117.09872, 32.5462], [-117.09893, 32.54623], [-117.09923, 32.54623], [-117.09938, 32.54621], [-117.09968, 32.54614], [-117.09987, 32.54607], [-117.10013, 32.54592], [-117.10031, 32.54577], [-117.1007, 32.54551], [-117.10099, 32.5453], [-117.1013, 32.54516], [-117.10157, 32.54498], [-117.1016, 32.54732]]], [[[-117.0885, 32.54724], [-117.08629, 32.54721], [-117.0863, 32.54538], [-117.08739, 32.54537], [-117.08736, 32.54369], [-117.08806, 32.54369], [-117.08816, 32.5437], [-117.08825, 32.54378], [-117.08837, 32.54396], [-117.08845, 32.54413], [-117.0885, 32.54724]]], [[[-117.09384, 32.55778], [-117.09383, 32.55815], [-117.09285, 32.55815], [-117.09285, 32.55777], [-117.09384, 32.55778]]], [[[-117.10606, 32.5586], [-117.10571, 32.55859], [-117.1057, 32.55838], [-117.10148, 32.55833], [-117.10149, 32.5583], [-117.10605, 32.5583], [-117.10606, 32.5586]]], [[[-117.09275, 32.55093], [-117.09268, 32.55815], [-117.08418, 32.55813], [-117.08419, 32.55448], [-117.08437, 32.55447], [-117.08438, 32.55436], [-117.08437, 32.55435], [-117.08419, 32.55436], [-117.08418, 32.55418], [-117.08419, 32.55089], [-117.09275, 32.55093]]], [[[-117.06228, 32.5546], [-117.06228, 32.55681], [-117.06223, 32.55707], [-117.06211, 32.55742], [-117.06201, 32.55751], [-117.06188, 32.55756], [-117.06118, 32.55754], [-117.06066, 32.55742], [-117.06009, 32.55724], [-117.0596, 32.55707], [-117.05707, 32.55606], [-117.05613, 32.55565], [-117.05614, 32.5551], [-117.05646, 32.55509], [-117.05644, 32.55455], [-117.05809, 32.55454], [-117.05811, 32.55279], [-117.06225, 32.55457], [-117.06228, 32.5546]]], [[[-117.10139, 32.55833], [-117.10137, 32.56011], [-117.09925, 32.56009], [-117.09927, 32.55832], [-117.10139, 32.55833]]], [[[-117.08409, 32.5564], [-117.07974, 32.5564], [-117.07974, 32.55815], [-117.07532, 32.55815], [-117.07531, 32.56004], [-117.07196, 32.56004], [-117.07211, 32.55984], [-117.07172, 32.55962], [-117.0716, 32.55962], [-117.0716, 32.55957], [-117.07158, 32.55954], [-117.07152, 32.55949], [-117.07149, 32.55949], [-117.07052, 32.55891], [-117.06727, 32.55688], [-117.06725, 32.55689], [-117.06718, 32.55682], [-117.06694, 32.5567], [-117.06676, 32.55665], [-117.06675, 32.55646], [-117.06643, 32.55659], [-117.06601, 32.55672], [-117.06533, 32.55684], [-117.0647, 32.5569], [-117.06405, 32.5569], [-117.06355, 32.55686], [-117.06302, 32.55678], [-117.06256, 32.55666], [-117.06255, 32.55664], [-117.06256, 32.55265], [-117.06254, 32.55195], [-117.06259, 32.55166], [-117.06266, 32.55143], [-117.0628, 32.55118], [-117.06505, 32.54927], [-117.06956, 32.5526], [-117.06963, 32.55256], [-117.07039, 32.5532], [-117.07057, 32.55332], [-117.07085, 32.55347], [-117.07108, 32.55356], [-117.07109, 32.55348], [-117.0711, 32.55348], [-117.0713, 32.55354], [-117.07152, 32.55356], [-117.0718, 32.55356], [-117.07193, 32.55355], [-117.07197, 32.55366], [-117.07212, 32.55364], [-117.07199, 32.55317], [-117.07187, 32.55319], [-117.07188, 32.55328], [-117.07179, 32.55329], [-117.07154, 32.55329], [-117.07135, 32.55327], [-117.07109, 32.55321], [-117.07108, 32.55314], [-117.07093, 32.55309], [-117.07074, 32.55298], [-117.06992, 32.55231], [-117.06995, 32.55225], [-117.0655, 32.54887], [-117.06764, 32.54711], [-117.06956, 32.54545], [-117.06988, 32.54523], [-117.07016, 32.54509], [-117.07046, 32.54496], [-117.07089, 32.54483], [-117.07135, 32.54476], [-117.0718, 32.54475], [-117.07227, 32.5448], [-117.07289, 32.54495], [-117.07304, 32.545], [-117.0732, 32.5451], [-117.07326, 32.54516], [-117.07364, 32.54568], [-117.07378, 32.5458], [-117.07399, 32.54591], [-117.07414, 32.54596], [-117.07427, 32.54598], [-117.07543, 32.54598], [-117.07543, 32.54677], [-117.07335, 32.54678], [-117.07273, 32.54673], [-117.07243, 32.54667], [-117.07191, 32.54654], [-117.07163, 32.54643], [-117.0711, 32.5462], [-117.07111, 32.54673], [-117.07148, 32.54689], [-117.07188, 32.54702], [-117.07247, 32.54716], [-117.07334, 32.54725], [-117.07542, 32.54723], [-117.07543, 32.54718], [-117.08085, 32.54719], [-117.08397, 32.54717], [-117.08397, 32.55408], [-117.08326, 32.55408], [-117.08325, 32.55454], [-117.08408, 32.55455], [-117.08409, 32.5564]]], [[[-117.08408, 32.55826], [-117.08407, 32.56117], [-117.07896, 32.56115], [-117.07542, 32.56117], [-117.07541, 32.55826], [-117.08408, 32.55826]]]]} | Open Access 1 | 45085 | Tijuana River Valley Regional Park | 13879 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 1321.284 | Tijuana River Valley RP | 0 | Local Park 2 | 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]);