units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 3, COUNTY = 8 and MNG_AGENCY = 61
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10870 | 10870 | 10869 | {"type": "Polygon", "coordinates": [[[-119.18218, 34.14024], [-119.18214, 34.14291], [-119.17988, 34.14289], [-119.17936, 34.14362], [-119.17848, 34.14465], [-119.18209, 34.14469], [-119.18209, 34.14483], [-119.17928, 34.14481], [-119.17886, 34.14485], [-119.17839, 34.14495], [-119.17805, 34.14506], [-119.17773, 34.1452], [-119.17616, 34.14602], [-119.17571, 34.14629], [-119.17524, 34.14663], [-119.1753, 34.14027], [-119.17557, 34.14027], [-119.17558, 34.14025], [-119.17621, 34.1402], [-119.17663, 34.14019], [-119.17664, 34.14009], [-119.1754, 34.14008], [-119.17539, 34.14015], [-119.1753, 34.14015], [-119.17529, 34.14005], [-119.16685, 34.13998], [-119.16689, 34.13639], [-119.16899, 34.13642], [-119.16901, 34.13275], [-119.17536, 34.1328], [-119.17538, 34.13201], [-119.17635, 34.13277], [-119.17813, 34.13402], [-119.17813, 34.13438], [-119.17929, 34.13521], [-119.17923, 34.14011], [-119.1818, 34.14014], [-119.18181, 34.14021], [-119.18214, 34.14021], [-119.18215, 34.14024], [-119.18218, 34.14024]]]} | No Public Access 3 | 20685 | Ormond Beach | 23206 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | Ventura 8 | 275.728 | Ormond Beach | 2005 | Private Conservation 16 | 2 | |
13141 | 13141 | 13140 | {"type": "MultiPolygon", "coordinates": [[[[-119.19259, 34.24374], [-119.19245, 34.2441], [-119.1924, 34.24443], [-119.19243, 34.24464], [-119.19196, 34.24486], [-119.19171, 34.24532], [-119.19159, 34.2456], [-119.19161, 34.2457], [-119.1915, 34.24589], [-119.19143, 34.24624], [-119.19141, 34.24649], [-119.19095, 34.24684], [-119.19096, 34.24736], [-119.19068, 34.24795], [-119.18987, 34.24841], [-119.18929, 34.24857], [-119.18852, 34.24905], [-119.18781, 34.24916], [-119.18703, 34.24965], [-119.18668, 34.25009], [-119.18717, 34.25201], [-119.18558, 34.25499], [-119.18543, 34.25435], [-119.17761, 34.25921], [-119.1778, 34.2602], [-119.17721, 34.26052], [-119.1772, 34.26049], [-119.17714, 34.26046], [-119.17562, 34.25301], [-119.18119, 34.25016], [-119.18119, 34.25014], [-119.1796, 34.24901], [-119.1878, 34.24241], [-119.18804, 34.24212], [-119.19259, 34.24374]]], [[[-119.21193, 34.23424], [-119.21191, 34.2349], [-119.21189, 34.23699], [-119.20809, 34.23733], [-119.20476, 34.23785], [-119.20482, 34.23453], [-119.21193, 34.23424]]], [[[-119.22799, 34.2421], [-119.22673, 34.24216], [-119.22667, 34.24217], [-119.22666, 34.24219], [-119.22568, 34.24227], [-119.2253, 34.24234], [-119.22514, 34.24254], [-119.22484, 34.24285], [-119.22452, 34.24321], [-119.22426, 34.24336], [-119.22327, 34.2435], [-119.22255, 34.24347], [-119.22178, 34.24335], [-119.22113, 34.24311], [-119.22088, 34.24317], [-119.21924, 34.2431], [-119.21895, 34.24298], [-119.21893, 34.24302], [-119.21908, 34.24498], [-119.21886, 34.24493], [-119.21711, 34.24442], [-119.21684, 34.23749], [-119.21767, 34.23704], [-119.21848, 34.23704], [-119.21845, 34.23638], [-119.22479, 34.23582], [-119.22764, 34.23598], [-119.22799, 34.2421]]], [[[-119.23821, 34.24355], [-119.23753, 34.2434], [-119.23749, 34.24282], [-119.23622, 34.24253], [-119.23624, 34.24223], [-119.23549, 34.24206], [-119.23554, 34.24179], [-119.23411, 34.24176], [-119.23412, 34.2421], [-119.23326, 34.24197], [-119.23183, 34.24227], [-119.23153, 34.24236], [-119.23119, 34.23618], [-119.23783, 34.23655], [-119.23821, 34.24355]]]]} | No Public Access 3 | 46972 | Lower Santa Clara River | 30603 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | Ventura 8 | 652.001 | Lower Santa Clara River | 0 | Private Conservation 16 | 2 | |
13920 | 13920 | 13919 | {"type": "MultiPolygon", "coordinates": [[[[-118.79472, 34.39718], [-118.79472, 34.39887], [-118.79252, 34.39887], [-118.7925, 34.40081], [-118.7874, 34.40081], [-118.78765, 34.39973], [-118.78764, 34.39972], [-118.77014, 34.39965], [-118.75751, 34.4026], [-118.74418, 34.40263], [-118.74418, 34.40209], [-118.74506, 34.40224], [-118.74659, 34.4019], [-118.75455, 34.39983], [-118.76465, 34.3981], [-118.76652, 34.39806], [-118.77093, 34.39621], [-118.77242, 34.39641], [-118.78241, 34.39538], [-118.78248, 34.39511], [-118.78531, 34.39572], [-118.78651, 34.39576], [-118.78756, 34.39559], [-118.78828, 34.3952], [-118.78879, 34.39481], [-118.78825, 34.3972], [-118.79472, 34.39718]]], [[[-118.83229, 34.38975], [-118.82833, 34.38975], [-118.82343, 34.38978], [-118.82344, 34.38609], [-118.83228, 34.38612], [-118.83229, 34.38975]]], [[[-118.88503, 34.38582], [-118.88497, 34.38949], [-118.88092, 34.38878], [-118.87768, 34.3898], [-118.87721, 34.38993], [-118.877, 34.39255], [-118.87663, 34.39217], [-118.87652, 34.39216], [-118.87637, 34.39208], [-118.87613, 34.39207], [-118.87575, 34.39215], [-118.87544, 34.39216], [-118.87517, 34.39227], [-118.87478, 34.3923], [-118.87438, 34.39218], [-118.87428, 34.39216], [-118.87404, 34.39205], [-118.8739, 34.39202], [-118.87393, 34.39023], [-118.87181, 34.39052], [-118.87183, 34.38587], [-118.88503, 34.38582]]], [[[-118.96856, 34.37499], [-118.96005, 34.37505], [-118.96009, 34.37868], [-118.95572, 34.37872], [-118.95566, 34.3742], [-118.95592, 34.37399], [-118.95632, 34.37282], [-118.96398, 34.37282], [-118.95761, 34.3752], [-118.95788, 34.37571], [-118.96559, 34.37282], [-118.96853, 34.37281], [-118.96856, 34.37499]]], [[[-118.98652, 34.36756], [-118.98651, 34.37121], [-118.97357, 34.37132], [-118.97353, 34.36769], [-118.98224, 34.36762], [-118.98228, 34.36759], [-118.98652, 34.36756]]], [[[-118.99551, 34.36411], [-118.99538, 34.36751], [-118.99085, 34.36755], [-118.99097, 34.36415], [-118.99551, 34.36411]]], [[[-119.03402, 34.35098], [-119.03399, 34.35659], [-119.0339, 34.36009], [-119.02797, 34.3601], [-119.02762, 34.35977], [-119.02753, 34.35976], [-119.02512, 34.3574], [-119.02513, 34.35437], [-119.02684, 34.35431], [-119.02727, 34.35425], [-119.02772, 34.35411], [-119.02961, 34.35325], [-119.02994, 34.35304], [-119.03039, 34.35268], [-119.03054, 34.35258], [-119.03069, 34.35252], [-119.03135, 34.35234], [-119.03172, 34.35219], [-119.03402, 34.35098]]], [[[-119.04045, 34.35665], [-119.04025, 34.35665], [-119.03985, 34.35689], [-119.03967, 34.35693], [-119.0393, 34.35709], [-119.0388, 34.35748], [-119.03843, 34.35772], [-119.03833, 34.35786], [-119.03832, 34.35728], [-119.03806, 34.35726], [-119.0368, 34.35754], [-119.03579, 34.3572], [-119.03534, 34.35721], [-119.03403, 34.35684], [-119.03407, 34.35078], [-119.03646, 34.34995], [-119.03673, 34.34991], [-119.03769, 34.34987], [-119.03787, 34.34988], [-119.03808, 34.34991], [-119.03811, 34.3498], [-119.03851, 34.34956], [-119.03833, 34.35305], [-119.04045, 34.35306], [-119.04045, 34.35665]]], [[[-119.05284, 34.34975], [-119.05277, 34.3498], [-119.05188, 34.35005], [-119.0521, 34.35046], [-119.05133, 34.35074], [-119.05019, 34.34819], [-119.05115, 34.34791], [-119.05131, 34.3481], [-119.05139, 34.34805], [-119.05284, 34.34975]]], [[[-119.07207, 34.33757], [-119.06826, 34.34148], [-119.06574, 34.33867], [-119.06573, 34.33866], [-119.0653, 34.33928], [-119.06819, 34.34252], [-119.0663, 34.34368], [-119.0658, 34.34313], [-119.06546, 34.34324], [-119.06526, 34.34335], [-119.06453, 34.34363], [-119.06509, 34.34465], [-119.06087, 34.34673], [-119.05643, 34.34865], [-119.0533, 34.34964], [-119.0531, 34.34967], [-119.05161, 34.34792], [-119.05169, 34.34787], [-119.0516, 34.34777], [-119.05389, 34.34607], [-119.05402, 34.34618], [-119.05465, 34.34571], [-119.05465, 34.34569], [-119.05453, 34.34559], [-119.05616, 34.34436], [-119.05727, 34.34378], [-119.05856, 34.3436], [-119.05912, 34.34313], [-119.05912, 34.34311], [-119.05905, 34.34306], [-119.05987, 34.34232], [-119.05999, 34.34241], [-119.06075, 34.34177], [-119.06184, 34.3413], [-119.06347, 34.33994], [-119.06361, 34.34004], [-119.06332, 34.34028], [-119.06385, 34.34087], [-119.06556, 34.33846], [-119.06615, 34.33828], [-119.06817, 34.33623], [-119.06805, 34.33608], [-119.06874, 34.3354], [-119.06953, 34.33468], [-119.07207, 34.33757]]], [[[-119.1057, 34.30632], [-119.10143, 34.30908], [-119.10213, 34.31085], [-119.10231, 34.3114], [-119.1008, 34.31259], [-119.09739, 34.31469], [-119.09845, 34.31588], [-119.10184, 34.31379], [-119.09996, 34.31507], [-119.09993, 34.31532], [-119.10055, 34.31594], [-119.10136, 34.31518], [-119.10161, 34.31535], [-119.10183, 34.31513], [-119.10208, 34.31483], [-119.10238, 34.31453], [-119.10216, 34.31487], [-119.10192, 34.31517], [-119.10164, 34.31544], [-119.1007, 34.31631], [-119.10041, 34.31647], [-119.09996, 34.31666], [-119.09904, 34.3167], [-119.09696, 34.31681], [-119.09613, 34.31735], [-119.09457, 34.31809], [-119.09416, 34.31836], [-119.09416, 34.31838], [-119.09455, 34.31882], [-119.0905, 34.32131], [-119.09027, 34.32181], [-119.08994, 34.32143], [-119.08941, 34.32169], [-119.08911, 34.32187], [-119.08881, 34.32153], [-119.08628, 34.32321], [-119.08661, 34.32361], [-119.08607, 34.32393], [-119.08492, 34.3226], [-119.0811, 34.32684], [-119.07615, 34.32982], [-119.07258, 34.33193], [-119.07181, 34.33258], [-119.0707, 34.33132], [-119.07109, 34.33145], [-119.07148, 34.33147], [-119.07188, 34.33144], [-119.07223, 34.33144], [-119.07276, 34.33106], [-119.07333, 34.33079], [-119.07368, 34.33079], [-119.07387, 34.33059], [-119.07401, 34.33017], [-119.07398, 34.32998], [-119.07429, 34.33005], [-119.07492, 34.32988], [-119.07551, 34.32949], [-119.07614, 34.32918], [-119.07653, 34.32882], [-119.07684, 34.32863], [-119.07707, 34.32825], [-119.07712, 34.32799], [-119.077, 34.32768], [-119.07691, 34.32758], [-119.07708, 34.32728], [-119.07752, 34.32739], [-119.07842, 34.32698], [-119.07896, 34.32678], [-119.0795, 34.32645], [-119.07979, 34.32624], [-119.07979, 34.32623], [-119.07927, 34.32609], [-119.07932, 34.32586], [-119.08018, 34.32599], [-119.08032, 34.32585], [-119.08068, 34.32542], [-119.08097, 34.32506], [-119.08145, 34.32477], [-119.08207, 34.32432], [-119.08295, 34.32374], [-119.0832, 34.32364], [-119.08343, 34.32324], [-119.08374, 34.32324], [-119.08391, 34.32312], [-119.08413, 34.32276], [-119.08478, 34.32228], [-119.08609, 34.32142], [-119.08677, 34.32076], [-119.08387, 34.3174], [-119.08628, 34.31526], [-119.08627, 34.31525], [-119.08438, 34.31526], [-119.08437, 34.31168], [-119.08108, 34.31169], [-119.08096, 34.31151], [-119.08033, 34.31117], [-119.07995, 34.31054], [-119.08023, 34.30911], [-119.08027, 34.3088], [-119.07996, 34.30874], [-119.07996, 34.30812], [-119.07038, 34.30852], [-119.07034, 34.31212], [-119.06777, 34.31223], [-119.06789, 34.31193], [-119.06802, 34.31179], [-119.06802, 34.31169], [-119.0681, 34.31162], [-119.06819, 34.31146], [-119.06827, 34.31125], [-119.06832, 34.31118], [-119.06835, 34.311], [-119.06829, 34.31081], [-119.06829, 34.31055], [-119.06823, 34.31039], [-119.06822, 34.31023], [-119.06831, 34.30988], [-119.06833, 34.3097], [-119.0683, 34.30949], [-119.06822, 34.3093], [-119.06824, 34.30909], [-119.06829, 34.30886], [-119.06829, 34.30854], [-119.06823, 34.30837], [-119.06829, 34.30821], [-119.06853, 34.30774], [-119.06853, 34.30744], [-119.06861, 34.30716], [-119.06863, 34.30684], [-119.0686, 34.30663], [-119.06865, 34.3064], [-119.06857, 34.30619], [-119.06859, 34.30594], [-119.06853, 34.30566], [-119.06853, 34.30538], [-119.0686, 34.30497], [-119.06854, 34.30475], [-119.06854, 34.3042], [-119.06851, 34.30393], [-119.07041, 34.3031], [-119.07041, 34.3049], [-119.07998, 34.30451], [-119.08, 34.29848], [-119.08141, 34.29743], [-119.08811, 34.29733], [-119.08812, 34.2979], [-119.0888, 34.2979], [-119.08875, 34.30449], [-119.09749, 34.30448], [-119.09748, 34.30533], [-119.09698, 34.30579], [-119.0987, 34.30771], [-119.09977, 34.30587], [-119.10118, 34.30379], [-119.10299, 34.3033], [-119.1057, 34.30632]], [[-119.08552, 34.32235], [-119.08558, 34.32231], [-119.08533, 34.32207], [-119.08515, 34.3223], [-119.08517, 34.3223], [-119.08533, 34.32213], [-119.08552, 34.32235]], [[-119.08699, 34.32136], [-119.087, 34.32138], [-119.08716, 34.32127], [-119.08714, 34.32127], [-119.08699, 34.32136]]], [[[-119.08679, 34.32384], [-119.08655, 34.32415], [-119.08662, 34.32423], [-119.08648, 34.32441], [-119.08634, 34.32424], [-119.08673, 34.32375], [-119.08679, 34.32384]]]]} | No Public Access 3 | 46976 | Middle Santa Clara River | 30609 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | Ventura 8 | 2371.056 | Middle Santa Clara River | 0 | Private Conservation 16 | 2 |
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]);