units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1 and LABEL_NAME = "Pleasanton Ridge RP"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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]);