units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where UNIT_NAME = "Shoreline Park"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, DES_TP
MNG_AG_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
297 | 297 | 296 | {"type": "Polygon", "coordinates": [[[-119.71194, 34.39632], [-119.71076, 34.3961], [-119.71039, 34.39606], [-119.71001, 34.39605], [-119.70963, 34.39607], [-119.70926, 34.39613], [-119.708, 34.39646], [-119.70506, 34.39741], [-119.70451, 34.39762], [-119.70425, 34.39775], [-119.704, 34.39789], [-119.70366, 34.39813], [-119.70336, 34.3984], [-119.70316, 34.39859], [-119.70284, 34.39905], [-119.70263, 34.39947], [-119.70247, 34.39937], [-119.70254, 34.39925], [-119.70255, 34.39906], [-119.70237, 34.39872], [-119.70238, 34.39865], [-119.70232, 34.39849], [-119.70223, 34.39836], [-119.70222, 34.39829], [-119.70226, 34.39829], [-119.7023, 34.39826], [-119.70267, 34.39796], [-119.70303, 34.39798], [-119.70348, 34.39764], [-119.70359, 34.39749], [-119.70367, 34.39741], [-119.70378, 34.39733], [-119.7039, 34.39728], [-119.7041, 34.39723], [-119.70522, 34.39684], [-119.70576, 34.39662], [-119.70624, 34.3965], [-119.70827, 34.39576], [-119.70851, 34.3958], [-119.70907, 34.39583], [-119.71027, 34.39574], [-119.71077, 34.39576], [-119.71113, 34.39574], [-119.71149, 34.39568], [-119.71178, 34.39567], [-119.71194, 34.39632]]]} | Open Access 1 | 801 | Shoreline Park | 25428 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 13.242 | Shoreline Park | 0 | Local Park 2 | 4 | |
6059 | 6059 | 6058 | {"type": "Polygon", "coordinates": [[[-122.26148, 37.74311], [-122.26069, 37.74367], [-122.25856, 37.7448], [-122.25621, 37.74595], [-122.25515, 37.74678], [-122.25418, 37.74742], [-122.25346, 37.74772], [-122.25264, 37.74796], [-122.25185, 37.74818], [-122.25075, 37.74817], [-122.24984, 37.74819], [-122.2492, 37.74814], [-122.24876, 37.74813], [-122.24778, 37.74804], [-122.24733, 37.74808], [-122.24693, 37.74804], [-122.24629, 37.74803], [-122.24573, 37.74811], [-122.24492, 37.74819], [-122.2445, 37.7482], [-122.24404, 37.74811], [-122.2436, 37.74816], [-122.24266, 37.7482], [-122.24131, 37.74811], [-122.24054, 37.74813], [-122.24003, 37.74807], [-122.23861, 37.74799], [-122.23805, 37.74789], [-122.23757, 37.748], [-122.23698, 37.74796], [-122.23679, 37.74772], [-122.23716, 37.74754], [-122.23773, 37.74749], [-122.23809, 37.74752], [-122.23934, 37.74773], [-122.2398, 37.74777], [-122.24022, 37.74771], [-122.24086, 37.7477], [-122.24131, 37.74762], [-122.24163, 37.74775], [-122.24232, 37.74769], [-122.24303, 37.74771], [-122.24393, 37.74777], [-122.24463, 37.74773], [-122.24561, 37.74772], [-122.24633, 37.74776], [-122.24691, 37.74777], [-122.24753, 37.74773], [-122.24808, 37.74773], [-122.24831, 37.7475], [-122.25074, 37.74746], [-122.25098, 37.74749], [-122.25287, 37.74756], [-122.25291, 37.74696], [-122.25406, 37.74654], [-122.25425, 37.74677], [-122.25467, 37.7466], [-122.25528, 37.74622], [-122.25587, 37.74577], [-122.25655, 37.74543], [-122.25961, 37.7438], [-122.2602, 37.74341], [-122.26065, 37.7429], [-122.26088, 37.7424], [-122.26095, 37.74159], [-122.26085, 37.74059], [-122.25995, 37.74009], [-122.25885, 37.73906], [-122.25827, 37.73854], [-122.25775, 37.73826], [-122.25747, 37.73723], [-122.25523, 37.7353], [-122.25458, 37.73471], [-122.25368, 37.73405], [-122.25324, 37.73355], [-122.25281, 37.73317], [-122.25241, 37.73278], [-122.25181, 37.73247], [-122.25109, 37.73221], [-122.25062, 37.73172], [-122.25032, 37.73116], [-122.2496, 37.73045], [-122.24915, 37.73009], [-122.24878, 37.72969], [-122.24812, 37.72915], [-122.24747, 37.72847], [-122.24711, 37.72817], [-122.24673, 37.72773], [-122.24627, 37.72737], [-122.24561, 37.72697], [-122.24495, 37.72661], [-122.24456, 37.72645], [-122.24485, 37.72591], [-122.24513, 37.72574], [-122.24575, 37.72624], [-122.2463, 37.72683], [-122.24663, 37.72713], [-122.24694, 37.72735], [-122.2475, 37.72768], [-122.24778, 37.72793], [-122.24827, 37.72845], [-122.24881, 37.72897], [-122.24903, 37.72924], [-122.24926, 37.72944], [-122.25013, 37.73012], [-122.25058, 37.73056], [-122.25112, 37.73114], [-122.25114, 37.73114], [-122.25125, 37.73096], [-122.25157, 37.73127], [-122.25206, 37.73184], [-122.25248, 37.73226], [-122.25319, 37.73278], [-122.25372, 37.7332], [-122.25406, 37.73358], [-122.25457, 37.73403], [-122.25515, 37.73452], [-122.25541, 37.73479], [-122.25652, 37.7356], [-122.25702, 37.73603], [-122.25726, 37.73627], [-122.25743, 37.73656], [-122.25753, 37.73687], [-122.25786, 37.73759], [-122.25835, 37.73816], [-122.25959, 37.73904], [-122.25991, 37.73956], [-122.26043, 37.73984], [-122.26095, 37.73988], [-122.26123, 37.74008], [-122.2615, 37.74054], [-122.26161, 37.74135], [-122.26156, 37.74217], [-122.26146, 37.7428], [-122.26148, 37.74311]]]} | Open Access 1 | 767 | Shoreline Park | 25426 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 62.441 | Shoreline Park | 0 | Local Park 2 | 4 | |
15008 | 15008 | 15007 | {"type": "Polygon", "coordinates": [[[-122.27695, 38.02829], [-122.27668, 38.02857], [-122.27649, 38.02878], [-122.27626, 38.02908], [-122.27607, 38.02939], [-122.27585, 38.02979], [-122.2756, 38.0303], [-122.27523, 38.03116], [-122.27496, 38.03196], [-122.2748, 38.03258], [-122.27467, 38.03333], [-122.27449, 38.03465], [-122.27349, 38.03366], [-122.2735, 38.03363], [-122.27311, 38.03323], [-122.2733, 38.03321], [-122.27336, 38.03329], [-122.27348, 38.03333], [-122.2736, 38.03329], [-122.27365, 38.0332], [-122.27405, 38.03314], [-122.27396, 38.03285], [-122.27372, 38.03242], [-122.27387, 38.03234], [-122.27397, 38.0324], [-122.2741, 38.03267], [-122.27442, 38.03272], [-122.27447, 38.03272], [-122.27468, 38.03191], [-122.27491, 38.03132], [-122.27489, 38.03115], [-122.27485, 38.03103], [-122.27408, 38.03033], [-122.27414, 38.03025], [-122.27418, 38.03014], [-122.27423, 38.0299], [-122.27427, 38.02985], [-122.27435, 38.02982], [-122.27466, 38.02984], [-122.2748, 38.02988], [-122.27483, 38.02998], [-122.27515, 38.03012], [-122.27527, 38.03009], [-122.27546, 38.02976], [-122.27557, 38.02929], [-122.27593, 38.02886], [-122.27624, 38.02837], [-122.27647, 38.02815], [-122.27645, 38.0281], [-122.27635, 38.02804], [-122.27655, 38.0279], [-122.27695, 38.02829]]]} | Open Access 1 | 45658 | Shoreline Park | 28474 | 1133 | Hercules, City of 354 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=166 | City 2 | 1133 | Hercules, City of 351 | City 2 | City Agency 2 | http://www.ci.hercules.ca.us/index.aspx?page=178#Shoreline Park | Contra Costa 12 | 10.467 | Shoreline Park | 0 | Local Park 2 | 4 |
15285 | 15285 | 15284 | {"type": "Polygon", "coordinates": [[[-118.33692, 33.72337], [-118.33569, 33.72436], [-118.33525, 33.72574], [-118.33473, 33.72543], [-118.33308, 33.72735], [-118.33239, 33.7275], [-118.33207, 33.72753], [-118.33174, 33.72754], [-118.32971, 33.72738], [-118.33303, 33.72189], [-118.334, 33.72223], [-118.33468, 33.72234], [-118.33553, 33.72255], [-118.33569, 33.72266], [-118.33607, 33.72275], [-118.33624, 33.72289], [-118.33692, 33.72337]]]} | Open Access 1 | 46413 | Shoreline Park | 29692 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 52.163 | Shoreline Park | 0 | 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]);