units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 2, MNG_AGENCY = 87 and PARK_URL = "http://www.ebparks.org/parks/miller_knox"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 1 ✖
DES_TP 1
- Local Park · 1 ✖
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16841 | 16841 | 16840 | {"type": "MultiPolygon", "coordinates": [[[[-122.38721, 37.91001], [-122.38713, 37.91032], [-122.38701, 37.91098], [-122.38693, 37.91113], [-122.38689, 37.91118], [-122.38678, 37.9113], [-122.38394, 37.91371], [-122.38384, 37.91382], [-122.38373, 37.91398], [-122.38365, 37.9142], [-122.38373, 37.91649], [-122.3835, 37.91661], [-122.38349, 37.91712], [-122.38309, 37.91713], [-122.38315, 37.91721], [-122.38317, 37.91729], [-122.3835, 37.91726], [-122.38354, 37.91742], [-122.38363, 37.91758], [-122.38467, 37.91874], [-122.3842, 37.91906], [-122.38422, 37.91913], [-122.38446, 37.91899], [-122.38474, 37.9193], [-122.38499, 37.91913], [-122.38507, 37.91919], [-122.38568, 37.91987], [-122.38576, 37.91999], [-122.38581, 37.92017], [-122.3858, 37.92033], [-122.38544, 37.92124], [-122.3856, 37.92129], [-122.38527, 37.92214], [-122.38518, 37.92212], [-122.38505, 37.92215], [-122.38478, 37.92213], [-122.38468, 37.92191], [-122.38477, 37.92184], [-122.38426, 37.92122], [-122.38396, 37.92119], [-122.38363, 37.92112], [-122.38331, 37.92117], [-122.38315, 37.92117], [-122.3829, 37.92101], [-122.3825, 37.92088], [-122.38232, 37.92092], [-122.38189, 37.92113], [-122.3817, 37.92115], [-122.38201, 37.92065], [-122.38223, 37.92064], [-122.38237, 37.92056], [-122.38248, 37.9204], [-122.38193, 37.9202], [-122.38184, 37.92026], [-122.38179, 37.92023], [-122.38169, 37.92022], [-122.38162, 37.92028], [-122.38165, 37.92044], [-122.3815, 37.9211], [-122.38079, 37.92153], [-122.38052, 37.92201], [-122.38026, 37.9221], [-122.38034, 37.9218], [-122.38047, 37.9214], [-122.38075, 37.92075], [-122.38072, 37.92048], [-122.38043, 37.92005], [-122.38026, 37.91956], [-122.37989, 37.91915], [-122.37951, 37.91905], [-122.37945, 37.91881], [-122.37989, 37.9184], [-122.37971, 37.91783], [-122.37988, 37.91756], [-122.37981, 37.91743], [-122.37964, 37.91745], [-122.37956, 37.91719], [-122.37928, 37.91723], [-122.37916, 37.91719], [-122.3788, 37.91677], [-122.3787, 37.91654], [-122.37852, 37.91629], [-122.37813, 37.9161], [-122.37747, 37.91612], [-122.37719, 37.91603], [-122.37678, 37.91603], [-122.3759, 37.9165], [-122.37583, 37.91629], [-122.37602, 37.91606], [-122.37512, 37.91557], [-122.37505, 37.91561], [-122.37497, 37.91562], [-122.37456, 37.91553], [-122.3745, 37.91553], [-122.37441, 37.91555], [-122.37437, 37.91558], [-122.37406, 37.91609], [-122.37402, 37.91613], [-122.37395, 37.91616], [-122.37388, 37.91617], [-122.37306, 37.91739], [-122.37285, 37.91732], [-122.37264, 37.91719], [-122.3725, 37.91706], [-122.37241, 37.91692], [-122.37235, 37.91675], [-122.37234, 37.91657], [-122.37237, 37.91644], [-122.37246, 37.91614], [-122.37248, 37.916], [-122.37248, 37.91589], [-122.37318, 37.91605], [-122.37346, 37.91618], [-122.37354, 37.91614], [-122.37362, 37.91613], [-122.37379, 37.91604], [-122.37385, 37.91598], [-122.37391, 37.91587], [-122.37392, 37.91581], [-122.3737, 37.91222], [-122.37372, 37.91212], [-122.37378, 37.91204], [-122.37387, 37.91198], [-122.37398, 37.91195], [-122.3741, 37.91195], [-122.37426, 37.91201], [-122.37434, 37.91208], [-122.37508, 37.91307], [-122.37586, 37.91358], [-122.37678, 37.91355], [-122.3771, 37.91291], [-122.37724, 37.91279], [-122.37817, 37.91337], [-122.37778, 37.91411], [-122.37776, 37.91414], [-122.37812, 37.91443], [-122.37814, 37.91456], [-122.37851, 37.91466], [-122.37909, 37.91475], [-122.37948, 37.91472], [-122.37962, 37.91475], [-122.3812, 37.91464], [-122.38151, 37.91451], [-122.38243, 37.91208], [-122.38264, 37.91202], [-122.38273, 37.9118], [-122.3829, 37.91169], [-122.38301, 37.91152], [-122.38378, 37.91078], [-122.384, 37.91058], [-122.38422, 37.91043], [-122.38448, 37.91031], [-122.38477, 37.9102], [-122.38512, 37.91013], [-122.38538, 37.91], [-122.38634, 37.90989], [-122.38652, 37.91004], [-122.38678, 37.91007], [-122.38721, 37.91001]], [[-122.3845, 37.91986], [-122.38446, 37.91982], [-122.38418, 37.91997], [-122.38412, 37.91991], [-122.38396, 37.91957], [-122.38423, 37.91938], [-122.38399, 37.91887], [-122.38382, 37.91872], [-122.38369, 37.91867], [-122.38356, 37.91865], [-122.38346, 37.91865], [-122.38303, 37.91872], [-122.38294, 37.91873], [-122.38285, 37.91871], [-122.38266, 37.91896], [-122.38277, 37.91905], [-122.38256, 37.91923], [-122.38256, 37.91925], [-122.38273, 37.91933], [-122.38306, 37.91938], [-122.38321, 37.91949], [-122.38339, 37.91955], [-122.38346, 37.91956], [-122.3836, 37.91962], [-122.38367, 37.91971], [-122.38381, 37.92003], [-122.38389, 37.92015], [-122.38397, 37.92024], [-122.3841, 37.92032], [-122.38425, 37.92037], [-122.38449, 37.92018], [-122.38448, 37.92016], [-122.38435, 37.92013], [-122.3846, 37.91994], [-122.3845, 37.91986]], [[-122.38304, 37.91973], [-122.38327, 37.91994], [-122.38356, 37.91975], [-122.38353, 37.91969], [-122.38347, 37.91965], [-122.38322, 37.91959], [-122.38303, 37.91946], [-122.38292, 37.91942], [-122.38281, 37.91943], [-122.38276, 37.91971], [-122.38304, 37.91973]]], [[[-122.39571, 37.91673], [-122.38964, 37.91686], [-122.38973, 37.92265], [-122.38866, 37.92248], [-122.38786, 37.92183], [-122.38775, 37.92131], [-122.38755, 37.92108], [-122.38715, 37.92127], [-122.38698, 37.92125], [-122.38629, 37.92123], [-122.38612, 37.92119], [-122.3864, 37.92047], [-122.38649, 37.92016], [-122.38693, 37.91845], [-122.38725, 37.91708], [-122.38676, 37.91673], [-122.38598, 37.91963], [-122.3859, 37.91985], [-122.38527, 37.91913], [-122.3852, 37.919], [-122.38406, 37.91778], [-122.38399, 37.9176], [-122.38396, 37.91757], [-122.38398, 37.91754], [-122.38386, 37.91424], [-122.38393, 37.91403], [-122.3841, 37.91383], [-122.38522, 37.91284], [-122.38526, 37.91285], [-122.38695, 37.9114], [-122.38708, 37.91127], [-122.38713, 37.91119], [-122.3872, 37.91103], [-122.3875, 37.90962], [-122.38801, 37.9094], [-122.38819, 37.90853], [-122.39033, 37.90879], [-122.39058, 37.90901], [-122.39087, 37.90875], [-122.39154, 37.9081], [-122.3927, 37.90799], [-122.39283, 37.90815], [-122.39098, 37.90927], [-122.3909, 37.90922], [-122.39084, 37.90927], [-122.39306, 37.9119], [-122.39303, 37.91189], [-122.39305, 37.91192], [-122.39033, 37.91083], [-122.39058, 37.90998], [-122.39057, 37.90996], [-122.3897, 37.91061], [-122.38956, 37.91061], [-122.38913, 37.91109], [-122.38896, 37.91136], [-122.38888, 37.91151], [-122.38848, 37.91254], [-122.38826, 37.91318], [-122.3883, 37.91321], [-122.38823, 37.91348], [-122.38825, 37.91348], [-122.38834, 37.91318], [-122.39373, 37.91311], [-122.39571, 37.91673]], [[-122.39084, 37.90956], [-122.39085, 37.90955], [-122.39071, 37.90938], [-122.39069, 37.90938], [-122.39069, 37.9094], [-122.39084, 37.90956]]]]} | Open Access 1 | 17900 | Miller Knox Regional Shoreline | 3288 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/miller_knox | Contra Costa 12 | 320.048 | Miller Knox Reg. Shoreline | 1970 | 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]);