superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where LABEL_NAME = "Coyote Hills RP", MNG_AGENCY = 87 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- Recreation/Parks District · 2 ✖
MNG_AGENCY 1
- East Bay Regional Park District · 2 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
405 | 405 | 404 | {"type": "MultiPolygon", "coordinates": [[[[-122.09979, 37.55914], [-122.09954, 37.56103], [-122.09943, 37.56156], [-122.09917, 37.56197], [-122.09914, 37.56199], [-122.09917, 37.56202], [-122.0982, 37.56288], [-122.09749, 37.56263], [-122.09709, 37.56325], [-122.09686, 37.5631], [-122.09443, 37.56225], [-122.09395, 37.56175], [-122.09286, 37.56166], [-122.09105, 37.56122], [-122.08365, 37.56045], [-122.08118, 37.56021], [-122.08073, 37.5602], [-122.08051, 37.56022], [-122.07748, 37.56068], [-122.07516, 37.56105], [-122.07007, 37.56242], [-122.06949, 37.5626], [-122.06934, 37.56266], [-122.06894, 37.56289], [-122.06814, 37.56344], [-122.06737, 37.56407], [-122.06688, 37.56454], [-122.06659, 37.56443], [-122.06788, 37.56323], [-122.06862, 37.56265], [-122.06953, 37.56222], [-122.07517, 37.56075], [-122.07583, 37.56062], [-122.07322, 37.55534], [-122.07653, 37.55411], [-122.07653, 37.55409], [-122.076, 37.55363], [-122.0771, 37.55271], [-122.07468, 37.55005], [-122.07621, 37.54817], [-122.07735, 37.54654], [-122.07773, 37.5458], [-122.07593, 37.5433], [-122.07612, 37.54324], [-122.07693, 37.54292], [-122.07848, 37.54234], [-122.07902, 37.54213], [-122.07925, 37.54244], [-122.08035, 37.54202], [-122.08104, 37.5423], [-122.08275, 37.54172], [-122.08494, 37.54296], [-122.08652, 37.54235], [-122.08489, 37.53991], [-122.08404, 37.54022], [-122.0835, 37.53929], [-122.08263, 37.53955], [-122.08114, 37.53901], [-122.07999, 37.5371], [-122.07906, 37.53705], [-122.07857, 37.53633], [-122.07826, 37.53625], [-122.07765, 37.5364], [-122.07697, 37.53618], [-122.07674, 37.53548], [-122.07628, 37.53516], [-122.07651, 37.53504], [-122.07702, 37.5354], [-122.07716, 37.53593], [-122.07776, 37.53616], [-122.07842, 37.53601], [-122.07895, 37.53621], [-122.0793, 37.53674], [-122.07999, 37.53678], [-122.08077, 37.53655], [-122.08117, 37.53621], [-122.08128, 37.53616], [-122.08175, 37.53612], [-122.08213, 37.53628], [-122.08307, 37.53652], [-122.08381, 37.53687], [-122.08408, 37.53708], [-122.08474, 37.53722], [-122.08521, 37.5369], [-122.08526, 37.53672], [-122.08555, 37.53662], [-122.08593, 37.53719], [-122.08633, 37.53758], [-122.08645, 37.53782], [-122.08623, 37.53827], [-122.08598, 37.53867], [-122.08635, 37.53948], [-122.08771, 37.53946], [-122.08816, 37.53966], [-122.08771, 37.54104], [-122.08808, 37.5438], [-122.09014, 37.5446], [-122.09104, 37.54586], [-122.09118, 37.54638], [-122.09255, 37.54639], [-122.09792, 37.55067], [-122.09751, 37.5511], [-122.09757, 37.55386], [-122.09753, 37.5548], [-122.0979, 37.55558], [-122.09873, 37.55783], [-122.09979, 37.55914]]], [[[-122.0725, 37.56454], [-122.0703, 37.56499], [-122.06925, 37.56565], [-122.06922, 37.56574], [-122.06925, 37.56581], [-122.06966, 37.56612], [-122.06983, 37.56616], [-122.06993, 37.56613], [-122.07002, 37.56607], [-122.07008, 37.56607], [-122.07022, 37.5661], [-122.07033, 37.56617], [-122.07041, 37.56626], [-122.07044, 37.56637], [-122.07043, 37.56648], [-122.07037, 37.56658], [-122.07024, 37.5666], [-122.06971, 37.56631], [-122.06873, 37.5656], [-122.06893, 37.56537], [-122.06885, 37.5653], [-122.06915, 37.56501], [-122.06942, 37.56479], [-122.0697, 37.56459], [-122.06993, 37.56445], [-122.07049, 37.56416], [-122.07091, 37.56398], [-122.07136, 37.56384], [-122.07152, 37.5638], [-122.07224, 37.56369], [-122.0725, 37.56454]]]]} | Open Access 1 | Coyote Hills Regional Park | http://www.ebparks.org/parks/coyote_hills | 3244 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 987.239 | Coyote Hills RP | 1968 |
12211 | 12211 | 12210 | {"type": "Polygon", "coordinates": [[[-122.07774, 37.5458], [-122.07735, 37.54654], [-122.0762, 37.54817], [-122.07469, 37.55005], [-122.07711, 37.55271], [-122.07601, 37.55363], [-122.07655, 37.5541], [-122.07322, 37.55534], [-122.07585, 37.56063], [-122.07517, 37.56075], [-122.06953, 37.56222], [-122.06862, 37.56265], [-122.06839, 37.56283], [-122.06718, 37.56025], [-122.06716, 37.56025], [-122.06692, 37.56051], [-122.06577, 37.55957], [-122.066, 37.55925], [-122.06615, 37.55898], [-122.06757, 37.55587], [-122.06763, 37.55584], [-122.06774, 37.55585], [-122.06776, 37.55566], [-122.06769, 37.55561], [-122.06913, 37.55247], [-122.06935, 37.55191], [-122.06953, 37.55138], [-122.06988, 37.55125], [-122.06981, 37.5511], [-122.06958, 37.55117], [-122.06964, 37.55096], [-122.06974, 37.55042], [-122.06981, 37.54983], [-122.07001, 37.54742], [-122.07003, 37.54695], [-122.07001, 37.54648], [-122.06997, 37.54601], [-122.06991, 37.54563], [-122.07593, 37.5433], [-122.07774, 37.5458]]]} | No Public Access 3 | Coyote Hills Regional Park | 30628 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 297.62 | Coyote Hills RP | 1968 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);