units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, DES_TP = 3, MNG_AGENCY = 174 and YR_EST = 2000
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY 1
- Walnut Creek, City of · 2 ✖
DES_TP 1
- Local Recreation Area · 2 ✖
ACCESS_TYP 1
- Open Access · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6205 | 6205 | 6204 | {"type": "Polygon", "coordinates": [[[-122.04485, 37.87597], [-122.04472, 37.87736], [-122.04387, 37.87733], [-122.04101, 37.87676], [-122.04099, 37.87593], [-122.04031, 37.87511], [-122.03931, 37.87563], [-122.03914, 37.87627], [-122.03425, 37.87555], [-122.03426, 37.86945], [-122.03267, 37.86947], [-122.03165, 37.8692], [-122.03108, 37.8697], [-122.03024, 37.86962], [-122.02981, 37.86905], [-122.03238, 37.86704], [-122.03531, 37.86692], [-122.036, 37.86506], [-122.03714, 37.86599], [-122.03803, 37.86832], [-122.0388, 37.86827], [-122.04027, 37.87005], [-122.04246, 37.87304], [-122.04417, 37.87519], [-122.04485, 37.87597]]]} | Open Access 1 | 1250 | Sugarloaf Recreation Area | 25946 | 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 | 184.864 | Sugarloaf Rec. Area | 2000 | Local Recreation Area 3 | 4 | |
15983 | 15983 | 15982 | {"type": "Polygon", "coordinates": [[[-122.04704, 37.90031], [-122.04439, 37.90084], [-122.04401, 37.90062], [-122.04279, 37.90015], [-122.04225, 37.90071], [-122.04092, 37.89995], [-122.04078, 37.90009], [-122.04011, 37.89962], [-122.03885, 37.90096], [-122.03872, 37.90096], [-122.03864, 37.90084], [-122.03851, 37.90082], [-122.03847, 37.90071], [-122.03837, 37.90076], [-122.03771, 37.90074], [-122.0376, 37.90038], [-122.0373, 37.90052], [-122.0373, 37.90039], [-122.03678, 37.90022], [-122.03675, 37.90034], [-122.03652, 37.90009], [-122.03614, 37.90024], [-122.03554, 37.89975], [-122.03564, 37.89966], [-122.03564, 37.89964], [-122.03527, 37.89957], [-122.03516, 37.89946], [-122.03529, 37.89927], [-122.03483, 37.89932], [-122.03438, 37.89889], [-122.03412, 37.89857], [-122.03386, 37.89876], [-122.03363, 37.89904], [-122.03309, 37.89903], [-122.03298, 37.89839], [-122.03256, 37.89826], [-122.03243, 37.89849], [-122.03233, 37.89858], [-122.03221, 37.89864], [-122.03206, 37.89867], [-122.0319, 37.89867], [-122.03177, 37.89863], [-122.03163, 37.89856], [-122.03158, 37.89854], [-122.03152, 37.89857], [-122.03136, 37.89872], [-122.03124, 37.89886], [-122.03117, 37.89901], [-122.03097, 37.89987], [-122.03093, 37.89997], [-122.03087, 37.90008], [-122.03226, 37.90119], [-122.03203, 37.90145], [-122.03204, 37.90146], [-122.03221, 37.90155], [-122.03246, 37.90126], [-122.03332, 37.90151], [-122.03346, 37.90426], [-122.02664, 37.90248], [-122.02662, 37.90256], [-122.02634, 37.90502], [-122.02609, 37.90487], [-122.02599, 37.90464], [-122.0255, 37.90442], [-122.0252, 37.90426], [-122.02483, 37.90418], [-122.02382, 37.90386], [-122.02362, 37.90412], [-122.023, 37.90415], [-122.02291, 37.90404], [-122.0231, 37.90387], [-122.0231, 37.90386], [-122.02276, 37.9038], [-122.022, 37.90357], [-122.02103, 37.90346], [-122.02, 37.9039], [-122.01935, 37.90443], [-122.01944, 37.90509], [-122.0193, 37.90557], [-122.01913, 37.9059], [-122.01634, 37.90511], [-122.01708, 37.90336], [-122.01707, 37.90335], [-122.00881, 37.90183], [-122.00868, 37.90229], [-122.0072, 37.90201], [-122.0072, 37.90196], [-122.00381, 37.90134], [-122.00542, 37.89941], [-122.00353, 37.89968], [-122.00416, 37.89666], [-122.00354, 37.89485], [-122.00247, 37.89153], [-121.99981, 37.88434], [-122.01488, 37.88053], [-122.01029, 37.87187], [-122.0154, 37.87274], [-122.01487, 37.87325], [-122.01366, 37.87323], [-122.0132, 37.87377], [-122.0138, 37.87426], [-122.0144, 37.8741], [-122.01453, 37.87396], [-122.01467, 37.87388], [-122.0157, 37.87401], [-122.01562, 37.87431], [-122.01543, 37.87454], [-122.01478, 37.87498], [-122.01419, 37.87578], [-122.0142, 37.87579], [-122.01454, 37.876], [-122.01536, 37.87535], [-122.01615, 37.87546], [-122.01628, 37.87536], [-122.0162, 37.87481], [-122.01605, 37.87472], [-122.01624, 37.87436], [-122.01674, 37.87415], [-122.0173, 37.87408], [-122.01843, 37.87446], [-122.01948, 37.8754], [-122.01968, 37.87547], [-122.02022, 37.87554], [-122.02051, 37.87581], [-122.02087, 37.87701], [-122.02304, 37.87768], [-122.02327, 37.87813], [-122.01502, 37.88078], [-122.01795, 37.8863], [-122.01788, 37.88645], [-122.01755, 37.88785], [-122.01636, 37.88771], [-122.01473, 37.88726], [-122.01381, 37.88723], [-122.01376, 37.88791], [-122.02023, 37.89056], [-122.02028, 37.89063], [-122.02065, 37.89021], [-122.0213, 37.89012], [-122.02436, 37.89057], [-122.02589, 37.89149], [-122.02568, 37.89171], [-122.02588, 37.89183], [-122.0261, 37.89162], [-122.02655, 37.89189], [-122.02883, 37.8921], [-122.02934, 37.8923], [-122.03022, 37.89302], [-122.03089, 37.89309], [-122.03148, 37.89336], [-122.03345, 37.89467], [-122.03681, 37.89619], [-122.04199, 37.89973], [-122.04208, 37.89975], [-122.04224, 37.89983], [-122.04241, 37.89994], [-122.04292, 37.90012], [-122.04311, 37.89981], [-122.04326, 37.89983], [-122.04345, 37.89985], [-122.04377, 37.8998], [-122.04392, 37.89976], [-122.04407, 37.89969], [-122.0443, 37.89952], [-122.04465, 37.89984], [-122.04477, 37.8998], [-122.04524, 37.90051], [-122.04545, 37.9004], [-122.04546, 37.90021], [-122.04623, 37.90014], [-122.04645, 37.90001], [-122.04638, 37.89981], [-122.04682, 37.89969], [-122.04704, 37.90031]], [[-122.0263, 37.89222], [-122.02629, 37.8922], [-122.02603, 37.89205], [-122.02583, 37.89227], [-122.0261, 37.89243], [-122.0263, 37.89222]], [[-122.02932, 37.90175], [-122.02932, 37.90177], [-122.03057, 37.9026], [-122.03106, 37.90214], [-122.02981, 37.9013], [-122.02932, 37.90175]]]} | Open Access 1 | 741 | Shell Ridge Open Space | 14668 | 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/shellridge.asp | Contra Costa 12 | 1364.266 | Shell Ridge OS | 2000 | 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]);