units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, MNG_AGENCY = 138 and PARK_URL = "http://www.santaanarivertrail.org/home.html"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8037 | 8037 | 8036 | {"type": "Polygon", "coordinates": [[[-117.958, 33.63182], [-117.95451, 33.6433], [-117.95349, 33.6469], [-117.95241, 33.65046], [-117.95155, 33.65368], [-117.95038, 33.65777], [-117.95028, 33.65793], [-117.94621, 33.67223], [-117.94617, 33.67255], [-117.94536, 33.67535], [-117.94493, 33.67669], [-117.94386, 33.67968], [-117.94311, 33.68154], [-117.94229, 33.68339], [-117.94154, 33.68494], [-117.94051, 33.68687], [-117.93973, 33.68823], [-117.93913, 33.68922], [-117.93869, 33.68993], [-117.93683, 33.69276], [-117.93581, 33.69429], [-117.93582, 33.69431], [-117.9359, 33.69431], [-117.93313, 33.69845], [-117.92833, 33.70568], [-117.92833, 33.70579], [-117.92731, 33.70727], [-117.92712, 33.70753], [-117.92709, 33.70753], [-117.92639, 33.70861], [-117.92207, 33.7151], [-117.92123, 33.7164], [-117.9211, 33.71664], [-117.92059, 33.71741], [-117.92048, 33.71762], [-117.91981, 33.71877], [-117.91981, 33.71881], [-117.91892, 33.72044], [-117.91825, 33.72178], [-117.91786, 33.72259], [-117.91691, 33.72472], [-117.9162, 33.72648], [-117.91584, 33.72746], [-117.91541, 33.72869], [-117.9144, 33.73232], [-117.91384, 33.73467], [-117.91357, 33.736], [-117.91301, 33.7392], [-117.9128, 33.7403], [-117.91221, 33.74282], [-117.912, 33.74358], [-117.91151, 33.74504], [-117.91144, 33.74517], [-117.91113, 33.74593], [-117.91067, 33.74698], [-117.91005, 33.74823], [-117.90945, 33.74933], [-117.90864, 33.75065], [-117.90789, 33.75177], [-117.90656, 33.75354], [-117.90503, 33.7554], [-117.90226, 33.75865], [-117.90214, 33.75866], [-117.90165, 33.75931], [-117.90048, 33.76105], [-117.90013, 33.76123], [-117.89983, 33.76149], [-117.8997, 33.76164], [-117.89951, 33.76195], [-117.89925, 33.76227], [-117.89894, 33.76261], [-117.89884, 33.76282], [-117.89882, 33.76292], [-117.89863, 33.76327], [-117.89646, 33.76588], [-117.89573, 33.76715], [-117.89556, 33.76716], [-117.8953, 33.7676], [-117.89523, 33.76768], [-117.89431, 33.76867], [-117.89313, 33.76987], [-117.89313, 33.76982], [-117.89312, 33.76982], [-117.89224, 33.77081], [-117.89223, 33.77069], [-117.89222, 33.77069], [-117.8914, 33.77167], [-117.89145, 33.77171], [-117.89009, 33.77404], [-117.88867, 33.77668], [-117.88803, 33.77812], [-117.88599, 33.78204], [-117.88592, 33.78204], [-117.88584, 33.78222], [-117.88555, 33.78272], [-117.88519, 33.78316], [-117.88483, 33.78355], [-117.88466, 33.78368], [-117.88428, 33.78403], [-117.88403, 33.78432], [-117.88373, 33.78477], [-117.88355, 33.78502], [-117.88344, 33.78523], [-117.88341, 33.78534], [-117.88339, 33.78774], [-117.88332, 33.78801], [-117.88249, 33.78996], [-117.88222, 33.79073], [-117.88217, 33.79077], [-117.88156, 33.79234], [-117.88115, 33.79342], [-117.88108, 33.79364], [-117.88107, 33.79376], [-117.88017, 33.796], [-117.87966, 33.79747], [-117.87885, 33.79943], [-117.87873, 33.79956], [-117.87848, 33.79969], [-117.87832, 33.79983], [-117.87795, 33.8005], [-117.87788, 33.80068], [-117.87787, 33.80083], [-117.87788, 33.80096], [-117.87719, 33.80256], [-117.8771, 33.80253], [-117.87701, 33.80268], [-117.87626, 33.80429], [-117.87602, 33.80496], [-117.8759, 33.80535], [-117.87573, 33.80574], [-117.87572, 33.80589], [-117.87535, 33.80653], [-117.87444, 33.80847], [-117.87429, 33.80875], [-117.8742, 33.80882], [-117.87353, 33.81006], [-117.87348, 33.8102], [-117.8732, 33.81072], [-117.87312, 33.81083], [-117.87285, 33.81134], [-117.87278, 33.8116], [-117.87279, 33.81229], [-117.87293, 33.81232], [-117.87362, 33.81232], [-117.87287, 33.81453], [-117.87287, 33.81476], [-117.8729, 33.81518], [-117.87284, 33.81544], [-117.87218, 33.81733], [-117.87207, 33.81755], [-117.87062, 33.82121], [-117.8693, 33.82654], [-117.86844, 33.82875], [-117.86712, 33.83254], [-117.86698, 33.83272], [-117.8659, 33.83586], [-117.86586, 33.8363], [-117.86475, 33.83966], [-117.85966, 33.84293], [-117.85664, 33.84459], [-117.85525, 33.84529], [-117.85407, 33.84582], [-117.85245, 33.8465], [-117.85157, 33.84683], [-117.85077, 33.84711], [-117.85073, 33.84712], [-117.85072, 33.84711], [-117.84188, 33.85001], [-117.84213, 33.84913], [-117.83795, 33.84947], [-117.83756, 33.84952], [-117.83642, 33.84975], [-117.83521, 33.84992], [-117.83521, 33.84994], [-117.83648, 33.8509], [-117.837, 33.85139], [-117.83744, 33.85174], [-117.83743, 33.85184], [-117.83625, 33.85184], [-117.83619, 33.85403], [-117.83603, 33.85403], [-117.83587, 33.85476], [-117.83571, 33.85494], [-117.8354, 33.85511], [-117.83462, 33.85522], [-117.83431, 33.8553], [-117.83387, 33.85545], [-117.83341, 33.85564], [-117.83293, 33.8559], [-117.83224, 33.85645], [-117.83107, 33.85766], [-117.83084, 33.85782], [-117.83056, 33.85794], [-117.83026, 33.85798], [-117.82863, 33.85771], [-117.82849, 33.85826], [-117.82606, 33.85828], [-117.82584, 33.85775], [-117.82324, 33.85776], [-117.82323, 33.85812], [-117.81836, 33.85814], [-117.81835, 33.85815], [-117.81843, 33.85872], [-117.81842, 33.85909], [-117.81826, 33.85909], [-117.8131, 33.85798], [-117.81309, 33.85799], [-117.81309, 33.85805], [-117.81049, 33.8581], [-117.80027, 33.85684], [-117.79073, 33.85799], [-117.79025, 33.85801], [-117.78569, 33.85882], [-117.78515, 33.85893], [-117.78442, 33.8591], [-117.78324, 33.8594], [-117.7823, 33.8597], [-117.7813, 33.86007], [-117.7808, 33.86029], [-117.77812, 33.86158], [-117.77135, 33.86488], [-117.77053, 33.86526], [-117.76967, 33.8657], [-117.76882, 33.8661], [-117.76672, 33.86711], [-117.76628, 33.86734], [-117.76518, 33.86786], [-117.76248, 33.86919], [-117.7611, 33.86982], [-117.75927, 33.87055], [-117.75884, 33.8707], [-117.75782, 33.87105], [-117.75634, 33.87152], [-117.75548, 33.87183], [-117.754, 33.87242], [-117.75219, 33.87321], [-117.75135, 33.87366], [-117.74981, 33.87456], [-117.74964, 33.87468], [-117.74945, 33.87509], [-117.74893, 33.87504], [-117.74868, 33.87569], [-117.74794, 33.87438], [-117.7482, 33.8742], [-117.75061, 33.87276], [-117.75204, 33.87204], [-117.75307, 33.87158], [-117.75429, 33.87107], [-117.75511, 33.87076], [-117.75663, 33.87024], [-117.75847, 33.86967], [-117.76192, 33.86821], [-117.7804, 33.85924], [-117.78223, 33.85854], [-117.78352, 33.85813], [-117.78471, 33.85783], [-117.78572, 33.85763], [-117.78959, 33.85695], [-117.79028, 33.85663], [-117.79138, 33.85661], [-117.79232, 33.85645], [-117.79927, 33.85518], [-117.80152, 33.85486], [-117.80247, 33.85482], [-117.80299, 33.85479], [-117.80328, 33.85476], [-117.80518, 33.85489], [-117.80578, 33.8549], [-117.80615, 33.85488], [-117.80617, 33.85508], [-117.80682, 33.85519], [-117.80926, 33.85575], [-117.80974, 33.85582], [-117.81047, 33.85585], [-117.81182, 33.8558], [-117.81264, 33.8557], [-117.81338, 33.85557], [-117.81435, 33.85536], [-117.81694, 33.85459], [-117.82124, 33.85329], [-117.82318, 33.85261], [-117.82455, 33.85186], [-117.82491, 33.85164], [-117.82755, 33.84997], [-117.83017, 33.84902], [-117.83129, 33.84869], [-117.83416, 33.84798], [-117.83482, 33.84768], [-117.83531, 33.84751], [-117.83579, 33.84743], [-117.83748, 33.8471], [-117.84525, 33.84543], [-117.84527, 33.84551], [-117.84667, 33.84524], [-117.84746, 33.84498], [-117.8486, 33.84465], [-117.84926, 33.84444], [-117.84979, 33.84426], [-117.85089, 33.84386], [-117.85218, 33.84332], [-117.85277, 33.84304], [-117.8546, 33.84208], [-117.85458, 33.84205], [-117.85551, 33.84162], [-117.85923, 33.83895], [-117.8604, 33.83772], [-117.86154, 33.83667], [-117.86217, 33.83533], [-117.86224, 33.83534], [-117.8624, 33.83504], [-117.86241, 33.83432], [-117.86296, 33.83333], [-117.86323, 33.83269], [-117.86342, 33.83216], [-117.86489, 33.82779], [-117.86556, 33.82681], [-117.86569, 33.82649], [-117.86851, 33.81806], [-117.86901, 33.81649], [-117.86929, 33.81567], [-117.86928, 33.81565], [-117.86909, 33.81565], [-117.86999, 33.8131], [-117.87073, 33.81167], [-117.87193, 33.80902], [-117.87199, 33.80901], [-117.87328, 33.80622], [-117.87376, 33.80588], [-117.87375, 33.80537], [-117.87444, 33.80386], [-117.87475, 33.80322], [-117.87552, 33.80169], [-117.87705, 33.79857], [-117.87738, 33.7987], [-117.87827, 33.79681], [-117.87841, 33.7959], [-117.87847, 33.79562], [-117.87875, 33.79468], [-117.87921, 33.79372], [-117.87974, 33.79249], [-117.88021, 33.79112], [-117.88037, 33.791], [-117.88049, 33.79012], [-117.88101, 33.78921], [-117.88131, 33.78873], [-117.8814, 33.78798], [-117.88147, 33.7876], [-117.88148, 33.78698], [-117.88153, 33.78697], [-117.88153, 33.78535], [-117.88158, 33.785], [-117.88167, 33.78469], [-117.88181, 33.78432], [-117.882, 33.784], [-117.88252, 33.78336], [-117.88326, 33.78273], [-117.8835, 33.78247], [-117.88398, 33.78186], [-117.88418, 33.78153], [-117.88418, 33.78049], [-117.8848, 33.78049], [-117.88525, 33.77965], [-117.88579, 33.77854], [-117.8858, 33.77839], [-117.88577, 33.77823], [-117.88713, 33.7756], [-117.88773, 33.77368], [-117.88785, 33.7734], [-117.88846, 33.77289], [-117.88872, 33.77255], [-117.88913, 33.77192], [-117.88929, 33.77151], [-117.88949, 33.77138], [-117.88992, 33.77058], [-117.89017, 33.76993], [-117.88992, 33.76948], [-117.89174, 33.76706], [-117.89302, 33.76519], [-117.8934, 33.76471], [-117.89368, 33.76486], [-117.89696, 33.76234], [-117.89709, 33.7624], [-117.89712, 33.76238], [-117.89742, 33.76251], [-117.89762, 33.76229], [-117.89831, 33.76168], [-117.89893, 33.76094], [-117.89856, 33.76071], [-117.89917, 33.76041], [-117.90267, 33.75622], [-117.90302, 33.75571], [-117.90343, 33.7552], [-117.90422, 33.75428], [-117.90433, 33.75428], [-117.90537, 33.75302], [-117.90613, 33.75205], [-117.90664, 33.75135], [-117.90764, 33.74986], [-117.90818, 33.74898], [-117.9086, 33.74824], [-117.90961, 33.74622], [-117.91009, 33.74511], [-117.91065, 33.74354], [-117.91082, 33.74298], [-117.91099, 33.7424], [-117.91118, 33.74162], [-117.9116, 33.73961], [-117.91215, 33.73649], [-117.91254, 33.73448], [-117.91271, 33.73374], [-117.91305, 33.73238], [-117.91336, 33.73125], [-117.91473, 33.72725], [-117.91502, 33.72724], [-117.91646, 33.72299], [-117.91662, 33.72263], [-117.91756, 33.7207], [-117.91863, 33.7187], [-117.91987, 33.7165], [-117.92103, 33.71469], [-117.9249, 33.70884], [-117.92944, 33.70202], [-117.92959, 33.70177], [-117.93155, 33.69882], [-117.93667, 33.69119], [-117.93666, 33.69117], [-117.93609, 33.69093], [-117.93639, 33.69044], [-117.93695, 33.6896], [-117.9379, 33.68807], [-117.93844, 33.68712], [-117.93935, 33.68548], [-117.9404, 33.68342], [-117.94098, 33.68218], [-117.94175, 33.68041], [-117.94247, 33.67853], [-117.943, 33.67701], [-117.94336, 33.67592], [-117.94375, 33.67459], [-117.94453, 33.67186], [-117.94455, 33.67167], [-117.94451, 33.67145], [-117.94451, 33.67131], [-117.9444, 33.67119], [-117.94442, 33.67113], [-117.94454, 33.67108], [-117.94526, 33.66852], [-117.94686, 33.66245], [-117.94829, 33.65775], [-117.94828, 33.65774], [-117.94797, 33.65774], [-117.94895, 33.65432], [-117.9495, 33.65229], [-117.95, 33.65228], [-117.95044, 33.65129], [-117.95032, 33.65063], [-117.95069, 33.65025], [-117.95264, 33.64375], [-117.95257, 33.6435], [-117.95271, 33.64349], [-117.95276, 33.64333], [-117.95288, 33.64311], [-117.95634, 33.63093], [-117.95649, 33.63099], [-117.95655, 33.63092], [-117.958, 33.63182]]]} | Open Access 1 | 11403 | Santa Ana River Trail | 29296 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.santaanarivertrail.org/home.html | Orange 3 | 1909.063 | Santa Ana River Trail | 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]);