units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "605.784", DES_TP = 4 and MNG_AG_TYP = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8096 | 8096 | 8095 | {"type": "MultiPolygon", "coordinates": [[[[-117.1101, 33.63438], [-117.10578, 33.63443], [-117.10578, 33.63085], [-117.11002, 33.63089], [-117.1101, 33.63438]]], [[[-117.14335, 33.6307], [-117.14334, 33.63428], [-117.13682, 33.63432], [-117.12331, 33.63432], [-117.12328, 33.62709], [-117.12774, 33.62709], [-117.12773, 33.6253], [-117.13201, 33.62537], [-117.13196, 33.62358], [-117.13678, 33.62359], [-117.1368, 33.62711], [-117.14106, 33.62711], [-117.14101, 33.63071], [-117.14335, 33.6307]], [[-117.1368, 33.62892], [-117.13679, 33.62712], [-117.1323, 33.6271], [-117.13244, 33.6307], [-117.1368, 33.6307], [-117.1368, 33.62892]]], [[[-117.17557, 33.6052], [-117.17555, 33.60545], [-117.17549, 33.60567], [-117.17542, 33.60583], [-117.17531, 33.60603], [-117.17514, 33.60627], [-117.17498, 33.60645], [-117.17482, 33.60656], [-117.17474, 33.60687], [-117.17478, 33.60688], [-117.17458, 33.6074], [-117.17448, 33.60762], [-117.17443, 33.60768], [-117.17426, 33.60784], [-117.17285, 33.60876], [-117.17273, 33.60885], [-117.17261, 33.609], [-117.17252, 33.60922], [-117.17248, 33.60964], [-117.17239, 33.6123], [-117.17157, 33.61232], [-117.17175, 33.60688], [-117.17185, 33.6052], [-117.17557, 33.6052]]], [[[-117.18499, 33.60556], [-117.18491, 33.6057], [-117.18461, 33.60563], [-117.18433, 33.60581], [-117.1842, 33.60612], [-117.18415, 33.60618], [-117.1841, 33.60639], [-117.18399, 33.60653], [-117.18375, 33.60674], [-117.18341, 33.60694], [-117.18334, 33.607], [-117.18326, 33.60709], [-117.18322, 33.60716], [-117.1832, 33.60726], [-117.1832, 33.60735], [-117.18311, 33.60735], [-117.18293, 33.60756], [-117.18287, 33.60758], [-117.18277, 33.60769], [-117.18272, 33.60771], [-117.18263, 33.60781], [-117.18257, 33.60783], [-117.18247, 33.60795], [-117.18241, 33.60796], [-117.1823, 33.60809], [-117.18226, 33.60811], [-117.18214, 33.60825], [-117.18211, 33.60827], [-117.18203, 33.6084], [-117.18232, 33.60857], [-117.1823, 33.60861], [-117.18196, 33.60846], [-117.18187, 33.60863], [-117.18179, 33.60881], [-117.18174, 33.60898], [-117.18169, 33.60936], [-117.18143, 33.6094], [-117.18119, 33.60947], [-117.18086, 33.60962], [-117.18057, 33.60978], [-117.1803, 33.60997], [-117.18006, 33.61018], [-117.17985, 33.61042], [-117.17969, 33.61063], [-117.17936, 33.61055], [-117.17798, 33.61052], [-117.1778, 33.61044], [-117.17762, 33.61044], [-117.17755, 33.6107], [-117.17747, 33.61075], [-117.17745, 33.61081], [-117.17729, 33.61104], [-117.17719, 33.61116], [-117.17722, 33.61136], [-117.17717, 33.61148], [-117.17717, 33.61174], [-117.17713, 33.61181], [-117.17714, 33.61187], [-117.17717, 33.61191], [-117.17715, 33.61194], [-117.17715, 33.61229], [-117.17257, 33.6123], [-117.17267, 33.60987], [-117.17271, 33.60933], [-117.17278, 33.60911], [-117.17287, 33.60896], [-117.17297, 33.60887], [-117.17444, 33.6079], [-117.17454, 33.60782], [-117.17464, 33.60769], [-117.17483, 33.60732], [-117.17499, 33.60688], [-117.17561, 33.60688], [-117.1758, 33.60509], [-117.18041, 33.60509], [-117.18041, 33.605], [-117.17934, 33.605], [-117.17929, 33.60497], [-117.17935, 33.60327], [-117.1819, 33.60327], [-117.18203, 33.60324], [-117.18251, 33.60323], [-117.18251, 33.60473], [-117.18361, 33.60473], [-117.18362, 33.60509], [-117.18493, 33.6051], [-117.18493, 33.60539], [-117.18499, 33.60556]], [[-117.17609, 33.61172], [-117.17615, 33.61117], [-117.17517, 33.61118], [-117.17512, 33.61172], [-117.17609, 33.61172]]], [[[-117.17919, 33.60327], [-117.17913, 33.60499], [-117.17906, 33.60501], [-117.17582, 33.60501], [-117.17578, 33.60497], [-117.1758, 33.60455], [-117.17581, 33.6034], [-117.17586, 33.60335], [-117.17663, 33.60335], [-117.17677, 33.60337], [-117.1769, 33.60343], [-117.17699, 33.60345], [-117.17706, 33.60343], [-117.17711, 33.60339], [-117.17714, 33.60333], [-117.17713, 33.60327], [-117.17919, 33.60327]]]]} | Unknown Access 4 | 12134 | Triple Creeks Conservation Area | 26546 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 605.784 | Triple Creeks Conservation Area | 0 | Local Conservation Area 4 | 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]);