units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, MNG_AGENCY = 87 and YR_EST = 1990
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- East Bay Regional Park District · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16296 | 16296 | 16295 | {"type": "MultiPolygon", "coordinates": [[[[-121.95106, 37.80222], [-121.94955, 37.80374], [-121.94685, 37.8028], [-121.94647, 37.8025], [-121.94503, 37.80219], [-121.9446, 37.80132], [-121.94506, 37.79975], [-121.9445, 37.79663], [-121.94449, 37.79662], [-121.9433, 37.79753], [-121.94244, 37.79656], [-121.94127, 37.7963], [-121.94034, 37.79587], [-121.94046, 37.79496], [-121.93913, 37.79507], [-121.93819, 37.79492], [-121.93764, 37.795], [-121.93713, 37.7958], [-121.93648, 37.79654], [-121.93557, 37.79737], [-121.93505, 37.7972], [-121.9363, 37.79615], [-121.93665, 37.79504], [-121.93596, 37.79475], [-121.93621, 37.79436], [-121.9362, 37.79435], [-121.93545, 37.79417], [-121.93526, 37.79447], [-121.93483, 37.79429], [-121.93399, 37.79526], [-121.93307, 37.79577], [-121.93274, 37.79629], [-121.93202, 37.79618], [-121.93226, 37.79547], [-121.93203, 37.79519], [-121.93263, 37.79487], [-121.93227, 37.79448], [-121.93169, 37.79479], [-121.93141, 37.79446], [-121.93047, 37.79485], [-121.93054, 37.7953], [-121.93032, 37.79551], [-121.92918, 37.79557], [-121.92902, 37.79523], [-121.92961, 37.79479], [-121.93011, 37.79474], [-121.93041, 37.79424], [-121.93056, 37.79345], [-121.93051, 37.79275], [-121.93069, 37.7924], [-121.93278, 37.79238], [-121.93284, 37.7889], [-121.94194, 37.78879], [-121.94195, 37.79106], [-121.94648, 37.79314], [-121.94645, 37.7951], [-121.95102, 37.79501], [-121.95103, 37.79879], [-121.95106, 37.80222]]], [[[-121.95111, 37.81978], [-121.95083, 37.81981], [-121.95026, 37.81958], [-121.94917, 37.81955], [-121.94888, 37.81937], [-121.94832, 37.81846], [-121.94799, 37.81765], [-121.94788, 37.8172], [-121.94745, 37.81682], [-121.94754, 37.81677], [-121.94754, 37.81675], [-121.94582, 37.81558], [-121.94328, 37.81472], [-121.94166, 37.81514], [-121.94083, 37.81606], [-121.9398, 37.81644], [-121.9397, 37.81667], [-121.93666, 37.81602], [-121.93554, 37.81608], [-121.93464, 37.81592], [-121.93366, 37.81642], [-121.93305, 37.81648], [-121.93307, 37.81697], [-121.93287, 37.8171], [-121.93286, 37.81693], [-121.93212, 37.81671], [-121.93192, 37.81637], [-121.932, 37.81597], [-121.9323, 37.81487], [-121.9309, 37.81208], [-121.93056, 37.81199], [-121.92988, 37.81117], [-121.93037, 37.81092], [-121.93054, 37.81023], [-121.93083, 37.8099], [-121.9311, 37.80945], [-121.93134, 37.80923], [-121.93123, 37.80909], [-121.93121, 37.80876], [-121.93064, 37.80841], [-121.93062, 37.80791], [-121.93047, 37.80733], [-121.93068, 37.80712], [-121.93069, 37.8068], [-121.93015, 37.80588], [-121.93037, 37.80581], [-121.93056, 37.80606], [-121.93071, 37.80615], [-121.93152, 37.80629], [-121.93199, 37.80652], [-121.93212, 37.80676], [-121.93236, 37.80697], [-121.93268, 37.80714], [-121.93307, 37.80761], [-121.93311, 37.80788], [-121.93382, 37.80813], [-121.93587, 37.80772], [-121.93673, 37.80739], [-121.93691, 37.80749], [-121.93713, 37.808], [-121.93753, 37.80823], [-121.93839, 37.80843], [-121.9392, 37.80811], [-121.94033, 37.80732], [-121.94172, 37.80585], [-121.94172, 37.80697], [-121.94193, 37.80707], [-121.94217, 37.80728], [-121.94224, 37.80766], [-121.94253, 37.80796], [-121.94237, 37.80843], [-121.9424, 37.80867], [-121.94263, 37.80906], [-121.94292, 37.80901], [-121.94322, 37.80938], [-121.94435, 37.80988], [-121.94503, 37.81028], [-121.94544, 37.81016], [-121.9456, 37.80968], [-121.94587, 37.80913], [-121.94675, 37.80979], [-121.94685, 37.81006], [-121.947, 37.81011], [-121.94734, 37.81028], [-121.9483, 37.8106], [-121.94917, 37.81102], [-121.94927, 37.81153], [-121.94918, 37.81186], [-121.94905, 37.81201], [-121.94902, 37.81264], [-121.95111, 37.81218], [-121.95111, 37.81978]]]]} | Open Access 1 | 1371 | Sycamore Valley Open Space Regional Preserve | 33755 | 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/sycamore | Contra Costa 12 | 695.859 | Sycamore Valley OS RPr | 1990 | Local Conservation Area 4 | 2 |
16378 | 16378 | 16377 | {"type": "MultiPolygon", "coordinates": [[[[-121.91383, 37.63008], [-121.91366, 37.63042], [-121.9137, 37.63075], [-121.91379, 37.63098], [-121.91354, 37.63112], [-121.91333, 37.63143], [-121.91313, 37.63158], [-121.91304, 37.63163], [-121.91294, 37.63159], [-121.91284, 37.63159], [-121.91266, 37.63155], [-121.91251, 37.63183], [-121.91276, 37.63193], [-121.91279, 37.63249], [-121.90568, 37.63243], [-121.90561, 37.62965], [-121.90531, 37.62963], [-121.90463, 37.6289], [-121.90392, 37.62843], [-121.90318, 37.62834], [-121.90243, 37.62743], [-121.90203, 37.62725], [-121.90183, 37.62663], [-121.9018, 37.62627], [-121.90135, 37.62547], [-121.89168, 37.62759], [-121.88994, 37.62573], [-121.88976, 37.62267], [-121.88866, 37.62193], [-121.88474, 37.62325], [-121.88297, 37.6233], [-121.88309, 37.62218], [-121.88323, 37.61949], [-121.88308, 37.61864], [-121.88301, 37.6184], [-121.88241, 37.61696], [-121.88235, 37.61678], [-121.88231, 37.61651], [-121.8823, 37.61598], [-121.88224, 37.61568], [-121.88213, 37.61542], [-121.88085, 37.61318], [-121.88074, 37.61302], [-121.88059, 37.61285], [-121.88042, 37.61269], [-121.87958, 37.61211], [-121.87947, 37.61199], [-121.87937, 37.61186], [-121.8793, 37.61172], [-121.87926, 37.61157], [-121.87926, 37.61133], [-121.87922, 37.6111], [-121.87869, 37.60977], [-121.88339, 37.61082], [-121.88733, 37.61082], [-121.88803, 37.61151], [-121.88841, 37.61133], [-121.8879, 37.61081], [-121.88788, 37.61034], [-121.88723, 37.61044], [-121.88713, 37.61021], [-121.88682, 37.60978], [-121.88658, 37.60954], [-121.88612, 37.60925], [-121.88595, 37.60906], [-121.88577, 37.60931], [-121.88579, 37.60899], [-121.88598, 37.60855], [-121.88595, 37.60807], [-121.88498, 37.60717], [-121.88427, 37.60686], [-121.88352, 37.60614], [-121.88346, 37.60451], [-121.88265, 37.60411], [-121.88146, 37.60322], [-121.88146, 37.60279], [-121.88149, 37.60252], [-121.88206, 37.6025], [-121.88227, 37.60227], [-121.88271, 37.60213], [-121.88277, 37.60227], [-121.88295, 37.60239], [-121.88297, 37.60278], [-121.88361, 37.60309], [-121.88385, 37.60307], [-121.88423, 37.60286], [-121.88443, 37.60243], [-121.88552, 37.60242], [-121.88618, 37.60099], [-121.88623, 37.60001], [-121.88638, 37.6], [-121.88646, 37.59975], [-121.8866, 37.59937], [-121.88674, 37.59851], [-121.88674, 37.59797], [-121.88731, 37.59796], [-121.88727, 37.59707], [-121.88865, 37.59703], [-121.88868, 37.59693], [-121.88856, 37.5966], [-121.88822, 37.59613], [-121.88793, 37.59588], [-121.88788, 37.59574], [-121.88796, 37.59559], [-121.88811, 37.59515], [-121.88789, 37.59484], [-121.88825, 37.59466], [-121.88817, 37.59478], [-121.88818, 37.59497], [-121.88825, 37.59506], [-121.88828, 37.59514], [-121.88826, 37.59524], [-121.88821, 37.59531], [-121.88823, 37.59554], [-121.88871, 37.59575], [-121.88909, 37.59615], [-121.88917, 37.59643], [-121.88939, 37.59669], [-121.8895, 37.59691], [-121.88947, 37.59702], [-121.88963, 37.5974], [-121.8896, 37.59752], [-121.88945, 37.59762], [-121.88938, 37.59778], [-121.8891, 37.59801], [-121.88904, 37.59841], [-121.88906, 37.59873], [-121.88886, 37.59925], [-121.88894, 37.59987], [-121.88893, 37.60001], [-121.88805, 37.60002], [-121.88792, 37.60026], [-121.88801, 37.60143], [-121.88782, 37.60154], [-121.88733, 37.60196], [-121.88706, 37.60259], [-121.88683, 37.60285], [-121.88684, 37.60337], [-121.88686, 37.60338], [-121.88817, 37.60337], [-121.88849, 37.60335], [-121.88878, 37.60322], [-121.88878, 37.60342], [-121.88871, 37.60346], [-121.88863, 37.6036], [-121.88865, 37.60375], [-121.88836, 37.60404], [-121.88817, 37.60457], [-121.88822, 37.60521], [-121.88832, 37.60538], [-121.88908, 37.6055], [-121.88925, 37.60557], [-121.88939, 37.60572], [-121.88972, 37.60599], [-121.88978, 37.60623], [-121.88986, 37.60631], [-121.89064, 37.60636], [-121.89078, 37.60648], [-121.8909, 37.60719], [-121.89086, 37.60736], [-121.89216, 37.60711], [-121.89232, 37.60728], [-121.89235, 37.60792], [-121.89266, 37.60846], [-121.89328, 37.60924], [-121.89355, 37.60971], [-121.89431, 37.61067], [-121.89597, 37.61317], [-121.89641, 37.61386], [-121.89658, 37.61425], [-121.8966, 37.61462], [-121.89654, 37.61531], [-121.89615, 37.61549], [-121.89617, 37.61556], [-121.89609, 37.6157], [-121.89608, 37.61582], [-121.89597, 37.61594], [-121.89618, 37.61619], [-121.89704, 37.61665], [-121.89817, 37.61714], [-121.89928, 37.61778], [-121.89952, 37.61808], [-121.89981, 37.6185], [-121.90054, 37.61926], [-121.90163, 37.62097], [-121.90187, 37.62142], [-121.90232, 37.62188], [-121.90326, 37.62261], [-121.905, 37.6241], [-121.9073, 37.62567], [-121.90947, 37.62619], [-121.90914, 37.62464], [-121.90956, 37.6251], [-121.90991, 37.62545], [-121.91017, 37.62588], [-121.91053, 37.62605], [-121.91069, 37.62626], [-121.91091, 37.62666], [-121.91116, 37.62731], [-121.91155, 37.62782], [-121.91169, 37.62812], [-121.91197, 37.62848], [-121.91253, 37.62878], [-121.91301, 37.62889], [-121.91329, 37.62917], [-121.91342, 37.62947], [-121.91378, 37.63008], [-121.91383, 37.63008]], [[-121.89071, 37.61004], [-121.89071, 37.61003], [-121.89034, 37.60956], [-121.8897, 37.60988], [-121.88914, 37.60917], [-121.88834, 37.6093], [-121.88865, 37.61092], [-121.88968, 37.61078], [-121.89014, 37.61051], [-121.89002, 37.61034], [-121.89036, 37.61016], [-121.89071, 37.61004]], [[-121.88862, 37.59581], [-121.88822, 37.59564], [-121.88804, 37.59572], [-121.8882, 37.59595], [-121.8885, 37.59629], [-121.88889, 37.59612], [-121.88862, 37.59581]]], [[[-121.98818, 37.66549], [-121.98777, 37.66571], [-121.98777, 37.67304], [-121.97868, 37.67325], [-121.97868, 37.67619], [-121.96889, 37.67627], [-121.96896, 37.68033], [-121.95945, 37.68039], [-121.95945, 37.6798], [-121.95944, 37.67979], [-121.95128, 37.68015], [-121.95002, 37.6729], [-121.93614, 37.673], [-121.93598, 37.66196], [-121.93179, 37.66198], [-121.93177, 37.66107], [-121.92747, 37.66105], [-121.92748, 37.65743], [-121.92498, 37.65741], [-121.92486, 37.65726], [-121.92434, 37.65676], [-121.92422, 37.65662], [-121.92357, 37.65532], [-121.92352, 37.65517], [-121.92349, 37.655], [-121.92343, 37.65423], [-121.92338, 37.65406], [-121.92329, 37.65388], [-121.92749, 37.65387], [-121.92749, 37.65025], [-121.91472, 37.65025], [-121.91478, 37.64353], [-121.91483, 37.63603], [-121.92155, 37.63602], [-121.931, 37.63583], [-121.93119, 37.642], [-121.94045, 37.64189], [-121.94046, 37.64188], [-121.94035, 37.63646], [-121.94946, 37.63636], [-121.9501, 37.63465], [-121.95125, 37.63447], [-121.95208, 37.63445], [-121.95248, 37.63458], [-121.9531, 37.63553], [-121.95432, 37.63554], [-121.95438, 37.63567], [-121.9545, 37.63583], [-121.95463, 37.63593], [-121.95484, 37.63603], [-121.95492, 37.63605], [-121.95623, 37.63613], [-121.94947, 37.63636], [-121.94964, 37.64359], [-121.9405, 37.6437], [-121.94049, 37.65094], [-121.94982, 37.65085], [-121.9498, 37.65305], [-121.95038, 37.65531], [-121.95271, 37.65649], [-121.9549, 37.65835], [-121.95545, 37.65983], [-121.95777, 37.65947], [-121.95923, 37.66043], [-121.96318, 37.66293], [-121.96736, 37.66484], [-121.9672, 37.6657], [-121.96866, 37.66571], [-121.98818, 37.66549]], [[-121.93349, 37.6583], [-121.9332, 37.65804], [-121.93176, 37.65904], [-121.93176, 37.65947], [-121.93296, 37.66056], [-121.93464, 37.65938], [-121.93349, 37.6583]], [[-121.94493, 37.63821], [-121.94275, 37.63824], [-121.94278, 37.64006], [-121.94497, 37.64004], [-121.94493, 37.63821]]]]} | Open Access 1 | 18778 | Pleasanton Ridge Regional Park | 3301 | 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/pleasanton | Alameda 17 | 4114.243 | Pleasanton Ridge RP | 1990 | 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]);