units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
22 rows where MNG_AGENCY = 174
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16017 | 16017 | 16016 | {"type": "MultiPolygon", "coordinates": [[[[-122.00329, 37.93123], [-122.00215, 37.9326], [-122.00182, 37.93338], [-122.00122, 37.9336], [-122.00119, 37.93382], [-121.99991, 37.93472], [-121.99962, 37.93475], [-121.99918, 37.93498], [-121.99914, 37.93544], [-121.99823, 37.9363], [-121.99795, 37.93655], [-121.99759, 37.93655], [-121.99689, 37.93735], [-121.99674, 37.93857], [-121.99669, 37.93882], [-121.99664, 37.93927], [-121.99666, 37.93972], [-121.99624, 37.94088], [-121.99628, 37.94132], [-121.99674, 37.94172], [-121.99682, 37.94213], [-121.9967, 37.94254], [-121.98194, 37.93191], [-121.98162, 37.93214], [-121.98166, 37.93179], [-121.98204, 37.93123], [-121.98168, 37.93075], [-121.98367, 37.92978], [-121.98391, 37.92871], [-121.98478, 37.92882], [-121.98512, 37.92832], [-121.98512, 37.92776], [-121.98478, 37.92716], [-121.98427, 37.92584], [-121.98285, 37.92476], [-121.98061, 37.92386], [-121.98062, 37.92235], [-121.98273, 37.92081], [-121.98377, 37.92007], [-121.9839, 37.91967], [-121.98403, 37.91944], [-121.98514, 37.9189], [-121.98524, 37.9185], [-121.98506, 37.91809], [-121.98502, 37.91785], [-121.98483, 37.91753], [-121.98324, 37.9164], [-121.98241, 37.9156], [-121.98281, 37.91512], [-121.98337, 37.91456], [-121.98397, 37.91378], [-121.98426, 37.9136], [-121.98531, 37.91333], [-121.98677, 37.9138], [-121.98785, 37.9134], [-121.98863, 37.91298], [-121.99022, 37.91261], [-121.99115, 37.91237], [-121.99232, 37.913], [-121.99263, 37.91326], [-121.99277, 37.91326], [-121.99292, 37.9136], [-121.99383, 37.91337], [-121.99434, 37.91319], [-121.99451, 37.91319], [-121.99436, 37.9133], [-121.99448, 37.91338], [-121.99438, 37.91345], [-121.99427, 37.91342], [-121.99415, 37.91342], [-121.99395, 37.91347], [-121.99376, 37.91358], [-121.99358, 37.91384], [-121.99343, 37.91415], [-121.99317, 37.9141], [-121.99301, 37.91413], [-121.99293, 37.91418], [-121.99277, 37.91432], [-121.99271, 37.9144], [-121.99252, 37.91478], [-121.99241, 37.91489], [-121.99209, 37.91503], [-121.99192, 37.91506], [-121.99162, 37.91508], [-121.99149, 37.91507], [-121.99153, 37.91464], [-121.99116, 37.91454], [-121.99125, 37.9144], [-121.99097, 37.91429], [-121.99064, 37.91402], [-121.99078, 37.91383], [-121.99033, 37.91361], [-121.99034, 37.91377], [-121.9903, 37.91394], [-121.99019, 37.91403], [-121.99007, 37.91418], [-121.99014, 37.91426], [-121.9904, 37.91432], [-121.9909, 37.91454], [-121.99117, 37.91463], [-121.99145, 37.91471], [-121.99141, 37.91505], [-121.99122, 37.91505], [-121.99105, 37.91511], [-121.99093, 37.91512], [-121.99118, 37.91476], [-121.99112, 37.9147], [-121.99066, 37.91468], [-121.9902, 37.9147], [-121.99008, 37.91476], [-121.98947, 37.91533], [-121.98917, 37.91568], [-121.98897, 37.91583], [-121.98892, 37.91586], [-121.9888, 37.91587], [-121.98887, 37.9156], [-121.98888, 37.91508], [-121.98882, 37.91503], [-121.98812, 37.91507], [-121.988, 37.9151], [-121.98776, 37.91525], [-121.98768, 37.91532], [-121.9873, 37.91575], [-121.987, 37.916], [-121.98676, 37.91598], [-121.9866, 37.91602], [-121.98645, 37.91621], [-121.9862, 37.91682], [-121.98607, 37.9168], [-121.986, 37.91671], [-121.98594, 37.91567], [-121.98598, 37.91558], [-121.98599, 37.91552], [-121.98598, 37.91547], [-121.98595, 37.91541], [-121.98587, 37.91537], [-121.98564, 37.9153], [-121.98527, 37.91548], [-121.98497, 37.91546], [-121.98484, 37.91539], [-121.98477, 37.91543], [-121.985, 37.91576], [-121.98515, 37.91587], [-121.98579, 37.91592], [-121.98595, 37.91682], [-121.98597, 37.91683], [-121.98596, 37.91699], [-121.98613, 37.91714], [-121.98623, 37.91726], [-121.98657, 37.91732], [-121.98672, 37.91738], [-121.987, 37.91757], [-121.98708, 37.91791], [-121.98742, 37.91822], [-121.98783, 37.91853], [-121.98797, 37.91867], [-121.98837, 37.91926], [-121.98874, 37.91956], [-121.9891, 37.9197], [-121.98918, 37.9196], [-121.98928, 37.91937], [-121.98936, 37.9194], [-121.98921, 37.91974], [-121.98947, 37.91984], [-121.98972, 37.92001], [-121.98993, 37.9201], [-121.98986, 37.92049], [-121.98988, 37.9207], [-121.99037, 37.92069], [-121.99047, 37.92056], [-121.9905, 37.92057], [-121.99045, 37.9207], [-121.99066, 37.92095], [-121.99072, 37.92108], [-121.99079, 37.92107], [-121.99095, 37.92089], [-121.99136, 37.92059], [-121.99209, 37.92052], [-121.99258, 37.92023], [-121.99294, 37.9201], [-121.99295, 37.91991], [-121.99272, 37.91921], [-121.99304, 37.91918], [-121.99341, 37.91934], [-121.99384, 37.91949], [-121.99428, 37.91958], [-121.99476, 37.91959], [-121.99522, 37.91953], [-121.99592, 37.91935], [-121.99626, 37.91949], [-121.99644, 37.9198], [-121.99665, 37.92006], [-121.99695, 37.92025], [-121.99733, 37.92025], [-121.99759, 37.92028], [-121.99776, 37.92022], [-121.998, 37.92002], [-121.99821, 37.92045], [-121.99832, 37.92043], [-121.99833, 37.92045], [-121.99942, 37.92264], [-121.99637, 37.9236], [-121.99457, 37.92375], [-121.99374, 37.92453], [-121.99599, 37.92776], [-121.99763, 37.92761], [-121.99905, 37.92943], [-122.0022, 37.9292], [-122.00329, 37.93123]], [[-122.00112, 37.93153], [-122.00099, 37.93137], [-121.99912, 37.93223], [-121.99982, 37.93317], [-122.00168, 37.93232], [-122.00112, 37.93153]]], [[[-122.01004, 37.94034], [-122.00198, 37.94634], [-121.99704, 37.94279], [-121.99719, 37.94248], [-121.99728, 37.94212], [-121.99733, 37.94168], [-121.99734, 37.9415], [-121.99731, 37.94105], [-121.99724, 37.94051], [-121.99733, 37.93995], [-121.99717, 37.93929], [-121.99735, 37.93813], [-121.99932, 37.93601], [-122.00081, 37.93503], [-122.00173, 37.93412], [-122.00212, 37.93399], [-122.00249, 37.93369], [-122.00248, 37.93336], [-122.00295, 37.93265], [-122.00321, 37.93213], [-122.00358, 37.93177], [-122.00396, 37.93249], [-122.00402, 37.93305], [-122.00443, 37.93382], [-122.00438, 37.9345], [-122.00491, 37.93487], [-122.00548, 37.93579], [-122.0055, 37.9363], [-122.00728, 37.93716], [-122.0077, 37.93754], [-122.008, 37.93796], [-122.00802, 37.93803], [-122.00801, 37.93811], [-122.00764, 37.93896], [-122.00757, 37.93967], [-122.00888, 37.93987], [-122.00992, 37.94017], [-122.01004, 37.94034]]]]} | Open Access 1 | 1942 | Lime Ridge Open Space | 14664 | 1371 | Walnut Creek, City of 178 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | http://www.walnut-creek.org/citygov/depts/ps/openspace/limeridge.asp | Contra Costa 12 | 981.228 | Lime Ridge OS | 0 | Local Recreation Area 3 | 4 |
16121 | 16121 | 16120 | {"type": "MultiPolygon", "coordinates": [[[[-122.08396, 37.90417], [-122.08306, 37.90454], [-122.08276, 37.90457], [-122.08208, 37.90442], [-122.08195, 37.90475], [-122.08152, 37.90465], [-122.08067, 37.90461], [-122.08068, 37.90321], [-122.07622, 37.90326], [-122.07598, 37.90148], [-122.07495, 37.9014], [-122.07493, 37.90156], [-122.07428, 37.90114], [-122.07444, 37.90093], [-122.07397, 37.90064], [-122.07389, 37.90055], [-122.07468, 37.89993], [-122.07489, 37.89998], [-122.07482, 37.9004], [-122.07567, 37.9006], [-122.07497, 37.90124], [-122.07497, 37.90126], [-122.07596, 37.90134], [-122.07629, 37.90082], [-122.07821, 37.90136], [-122.08168, 37.90319], [-122.08322, 37.90316], [-122.08372, 37.90316], [-122.08379, 37.90337], [-122.08396, 37.90417]]], [[[-122.09885, 37.91022], [-122.09879, 37.91031], [-122.09813, 37.91072], [-122.09776, 37.91138], [-122.09822, 37.9121], [-122.09762, 37.91221], [-122.09646, 37.91191], [-122.09704, 37.91129], [-122.09697, 37.91107], [-122.097, 37.91096], [-122.09696, 37.91084], [-122.09687, 37.91078], [-122.09678, 37.91053], [-122.0959, 37.91019], [-122.09514, 37.91019], [-122.09484, 37.91056], [-122.09479, 37.91081], [-122.09469, 37.91093], [-122.09468, 37.91144], [-122.09435, 37.91123], [-122.09376, 37.91099], [-122.09372, 37.91087], [-122.09328, 37.91059], [-122.09302, 37.91085], [-122.09296, 37.91153], [-122.09325, 37.91172], [-122.09347, 37.91194], [-122.09421, 37.91242], [-122.09431, 37.91274], [-122.09532, 37.91332], [-122.09563, 37.91322], [-122.09607, 37.91391], [-122.09608, 37.91444], [-122.09653, 37.9147], [-122.09605, 37.91518], [-122.09598, 37.91529], [-122.09595, 37.91539], [-122.09558, 37.91539], [-122.09556, 37.91581], [-122.09602, 37.91584], [-122.09609, 37.91605], [-122.09609, 37.91637], [-122.09613, 37.91654], [-122.09621, 37.9167], [-122.09634, 37.91685], [-122.0965, 37.91696], [-122.0967, 37.91706], [-122.09671, 37.91737], [-122.09546, 37.91731], [-122.09277, 37.91729], [-122.09202, 37.9173], [-122.09232, 37.91688], [-122.09242, 37.9162], [-122.09221, 37.91583], [-122.09186, 37.91585], [-122.09129, 37.91565], [-122.09122, 37.91533], [-122.0901, 37.91546], [-122.09002, 37.91557], [-122.08963, 37.91569], [-122.08935, 37.91545], [-122.08923, 37.9152], [-122.08889, 37.91494], [-122.08973, 37.91428], [-122.09039, 37.91344], [-122.08933, 37.9129], [-122.08768, 37.9131], [-122.0847, 37.91239], [-122.08414, 37.91225], [-122.08383, 37.91158], [-122.08286, 37.91134], [-122.08121, 37.91196], [-122.08028, 37.91275], [-122.07987, 37.91206], [-122.07959, 37.91138], [-122.07975, 37.91128], [-122.07989, 37.91111], [-122.07983, 37.91108], [-122.07963, 37.91091], [-122.07947, 37.9105], [-122.07976, 37.9104], [-122.08274, 37.91049], [-122.08284, 37.91045], [-122.08473, 37.91052], [-122.08461, 37.91062], [-122.08456, 37.91076], [-122.08456, 37.91086], [-122.08463, 37.9111], [-122.08465, 37.91133], [-122.08586, 37.91135], [-122.0861, 37.91092], [-122.08612, 37.91058], [-122.08788, 37.91065], [-122.08991, 37.91017], [-122.0987, 37.91016], [-122.09877, 37.9102], [-122.09885, 37.91022]]], [[[-122.0867, 37.9151], [-122.08588, 37.91574], [-122.0838, 37.91717], [-122.08275, 37.91665], [-122.08225, 37.91657], [-122.08182, 37.91635], [-122.0816, 37.91633], [-122.08148, 37.91643], [-122.08077, 37.9164], [-122.08077, 37.91636], [-122.08089, 37.91628], [-122.08092, 37.9163], [-122.08137, 37.91629], [-122.08171, 37.91599], [-122.08186, 37.9161], [-122.08214, 37.91617], [-122.08355, 37.91565], [-122.08535, 37.91504], [-122.08573, 37.91503], [-122.08603, 37.91473], [-122.08652, 37.91476], [-122.0867, 37.9151]]]]} | Open Access 1 | 15920 | Acalanes Ridge Open Space | 15245 | 1371 | Walnut Creek, City of 178 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | Contra Costa 12 | 178.835 | Acalanes Ridge OS | 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]);