units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

26 rows where AGNCY_NAME = 180 and DES_TP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: MNG_AG_ID, MNG_AG_LEV, PARK_URL, YR_EST

DES_TP 1

  • Local Park · 26 ✖

ACCESS_TYP 1

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
480 480 479 {"type": "Polygon", "coordinates": [[[-122.25181, 37.74294], [-122.25094, 37.74333], [-122.2502, 37.74331], [-122.2502, 37.74256], [-122.25026, 37.74211], [-122.25158, 37.74235], [-122.25161, 37.74252], [-122.25168, 37.74271], [-122.25181, 37.74294]]]} Open Access 1 1631 Tillman Park 26365 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 3.586 Tillman Park 0 Local Park 2 4
1754 1754 1753 {"type": "Polygon", "coordinates": [[[-122.26219, 37.76826], [-122.26215, 37.76912], [-122.26062, 37.76844], [-122.26111, 37.76773], [-122.26212, 37.76817], [-122.26217, 37.76821], [-122.26219, 37.76826]]]} Open Access 1 13146 Franklin Park 19060 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 2.958 Franklin Park 0 Local Park 2 4
1964 1964 1963 {"type": "Polygon", "coordinates": [[[-122.23324, 37.73433], [-122.23167, 37.73513], [-122.2312, 37.73448], [-122.23129, 37.73391], [-122.23247, 37.73335], [-122.23324, 37.73433]]]} Open Access 1 15110 Godfrey Park 19352 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 4.982 Godfrey Park 0 Local Park 2 4
1965 1965 1964 {"type": "Polygon", "coordinates": [[[-122.23947, 37.7313], [-122.23907, 37.73176], [-122.2378, 37.73113], [-122.23824, 37.73064], [-122.23947, 37.7313]]]} Open Access 1 15113 Doc Harrington Park 18177 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 2.094 Doc Harrington Park 0 Local Park 2 4
1968 1968 1967 {"type": "Polygon", "coordinates": [[[-122.24109, 37.75354], [-122.2401, 37.75443], [-122.23818, 37.75321], [-122.2392, 37.7522], [-122.24109, 37.75354]]]} Open Access 1 15123 Krusi Park 20727 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 7.492 Krusi Park 2000 Local Park 2 4
1969 1969 1968 {"type": "Polygon", "coordinates": [[[-122.23152, 37.75852], [-122.2309, 37.75909], [-122.22784, 37.75697], [-122.22846, 37.75639], [-122.23152, 37.75852]]]} Open Access 1 15126 Lincoln Park 21260 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 7.412 Lincoln Park 0 Local Park 2 4
3429 3429 3428 {"type": "Polygon", "coordinates": [[[-122.28869, 37.78989], [-122.28434, 37.79], [-122.28434, 37.78999], [-122.2844, 37.78926], [-122.28472, 37.78911], [-122.28521, 37.78928], [-122.28707, 37.78929], [-122.28729, 37.78923], [-122.28753, 37.78908], [-122.28867, 37.78906], [-122.28869, 37.78989]]]} Open Access 1 48739 Estuary Park 33465 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 https://www.alamedaca.gov/Departments/Recreation-Parks/Estuary-Park Alameda 17 7.72 Estuary Park 2017 Local Park 2 4
4101 4101 4100 {"type": "Polygon", "coordinates": [[[-122.2971, 37.78993], [-122.29707, 37.79023], [-122.29505, 37.79057], [-122.29505, 37.78997], [-122.29569, 37.79], [-122.29571, 37.78985], [-122.2971, 37.78993]]]} Open Access 1 47052 Main Street Dog Park 30702 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 2.363 Main Street Dog Park 0 Local Park 2 4
4104 4104 4103 {"type": "Polygon", "coordinates": [[[-122.28814, 37.78267], [-122.28814, 37.78306], [-122.28666, 37.78304], [-122.28669, 37.78184], [-122.28791, 37.78185], [-122.28808, 37.78232], [-122.28799, 37.78241], [-122.28798, 37.78247], [-122.28798, 37.78253], [-122.28804, 37.78262], [-122.28814, 37.78267]]]} Open Access 1 47045 Bayport Park 30695 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 4.003 Bayport 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
8421 8421 8420 {"type": "Polygon", "coordinates": [[[-122.27505, 37.77022], [-122.27504, 37.7714], [-122.27278, 37.77133], [-122.27288, 37.76913], [-122.27286, 37.76884], [-122.2728, 37.76866], [-122.27259, 37.76834], [-122.27239, 37.7681], [-122.27215, 37.7679], [-122.27199, 37.76774], [-122.27475, 37.76891], [-122.27478, 37.76995], [-122.27505, 37.77022]]]} Open Access 1 13144 Washington Park 27272 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 14.726 Washington Park 0 Local Park 2 4
8450 8450 8449 {"type": "Polygon", "coordinates": [[[-122.29151, 37.78681], [-122.29141, 37.78693], [-122.29105, 37.78704], [-122.29094, 37.78269], [-122.29085, 37.78011], [-122.29097, 37.78014], [-122.29109, 37.7802], [-122.29115, 37.78028], [-122.29119, 37.78039], [-122.29123, 37.78128], [-122.29125, 37.78243], [-122.29129, 37.78618], [-122.29132, 37.78619], [-122.29151, 37.78681]]]} Open Access 1 13132 Linear Park 21304 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 5.152 Linear Park 0 Local Park 2 4
8451 8451 8450 {"type": "Polygon", "coordinates": [[[-122.27644, 37.78387], [-122.27625, 37.78369], [-122.27553, 37.78258], [-122.27515, 37.78152], [-122.27638, 37.78152], [-122.27644, 37.78387]]]} Open Access 1 13134 Neptune Park 22700 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 4.14 Neptune Park 0 Local Park 2 4
8452 8452 8451 {"type": "MultiPolygon", "coordinates": [[[[-122.27092, 37.78439], [-122.27092, 37.7846], [-122.26927, 37.78477], [-122.26925, 37.78493], [-122.26898, 37.78493], [-122.26885, 37.78501], [-122.26867, 37.78488], [-122.26868, 37.78426], [-122.26831, 37.78386], [-122.26821, 37.78334], [-122.26766, 37.78307], [-122.26688, 37.783], [-122.26625, 37.78305], [-122.266, 37.78318], [-122.26564, 37.78359], [-122.2653, 37.78363], [-122.26562, 37.78327], [-122.26573, 37.78305], [-122.26594, 37.78303], [-122.26602, 37.78292], [-122.26605, 37.78276], [-122.26639, 37.78276], [-122.26649, 37.7828], [-122.26668, 37.78278], [-122.26681, 37.78268], [-122.2671, 37.78272], [-122.26737, 37.78267], [-122.26756, 37.78268], [-122.26788, 37.78266], [-122.26808, 37.78282], [-122.26839, 37.78289], [-122.26853, 37.78299], [-122.26849, 37.78316], [-122.26854, 37.7835], [-122.2689, 37.78375], [-122.2689, 37.784], [-122.26911, 37.78425], [-122.26908, 37.78438], [-122.26921, 37.78454], [-122.26959, 37.78456], [-122.27007, 37.78448], [-122.27027, 37.78453], [-122.27056, 37.7845], [-122.27064, 37.78452], [-122.27084, 37.78446], [-122.27092, 37.78439]]], [[[-122.27219, 37.78578], [-122.27203, 37.78587], [-122.27168, 37.78588], [-122.2715, 37.7859], [-122.27143, 37.78624], [-122.27106, 37.7869], [-122.27031, 37.78663], [-122.27053, 37.78625], [-122.27055, 37.78618], [-122.27135, 37.78609], [-122.27135, 37.78569], [-122.27155, 37.78568], [-122.2719, 37.78549], [-122.27219, 37.78578]]]]} Open Access 1 13136 Marina Park 21831 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 7.15 Marina Park 0 Local Park 2 4
8453 8453 8452 {"type": "Polygon", "coordinates": [[[-122.26313, 37.77627], [-122.26312, 37.77674], [-122.26073, 37.77666], [-122.2608, 37.77581], [-122.262, 37.77586], [-122.262, 37.7762], [-122.26313, 37.77627]]]} Open Access 1 13138 Littlejohn Park 33376 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 3.857 Littlejohn Park 0 Local Park 2 4
8454 8454 8453 {"type": "Polygon", "coordinates": [[[-122.287, 37.7782], [-122.28699, 37.77847], [-122.28675, 37.77847], [-122.28674, 37.7786], [-122.28575, 37.77857], [-122.28574, 37.7772], [-122.28621, 37.77721], [-122.28626, 37.77727], [-122.28635, 37.7773], [-122.28646, 37.77727], [-122.28684, 37.77723], [-122.2868, 37.77818], [-122.287, 37.7782]]]} Open Access 1 13140 Woodstock Park 27748 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 3.617 Woodstock Park 0 Local Park 2 4
8455 8455 8454 {"type": "Polygon", "coordinates": [[[-122.28152, 37.77443], [-122.2815, 37.77517], [-122.28088, 37.77516], [-122.28091, 37.77442], [-122.28152, 37.77443]]]} Open Access 1 13142 Longfellow Park 21454 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 1.103 Longfellow Park 0 Local Park 2 4
8456 8456 8455 {"type": "Polygon", "coordinates": [[[-122.26261, 37.76176], [-122.26199, 37.76281], [-122.26192, 37.76283], [-122.26118, 37.76257], [-122.26093, 37.7625], [-122.26025, 37.76236], [-122.26118, 37.76156], [-122.26115, 37.76134], [-122.25991, 37.76085], [-122.26068, 37.75956], [-122.26227, 37.76016], [-122.26227, 37.76021], [-122.26193, 37.76086], [-122.26158, 37.76145], [-122.26192, 37.76159], [-122.26207, 37.76151], [-122.26216, 37.76151], [-122.26238, 37.76157], [-122.26248, 37.76155], [-122.26256, 37.76159], [-122.26254, 37.76167], [-122.26261, 37.76176]]]} Open Access 1 13148 Rittler Park 24403 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 10.967 Rittler Park 0 Local Park 2 4
9117 9117 9116 {"type": "Polygon", "coordinates": [[[-122.24546, 37.75964], [-122.24348, 37.76197], [-122.24301, 37.76171], [-122.24489, 37.75945], [-122.24502, 37.75937], [-122.24519, 37.75934], [-122.24534, 37.75941], [-122.24542, 37.75951], [-122.24546, 37.75964]]]} Open Access 1 15116 Jackson Park 20319 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 4.117 Jackson Park 0 Local Park 2 4
9124 9124 9123 {"type": "Polygon", "coordinates": [[[-122.23778, 37.75118], [-122.23718, 37.75114], [-122.23698, 37.75109], [-122.23672, 37.75097], [-122.23649, 37.75078], [-122.23634, 37.75049], [-122.23631, 37.75027], [-122.23635, 37.74995], [-122.23643, 37.75001], [-122.23642, 37.75024], [-122.23778, 37.75118]]]} Open Access 1 15128 Towata Park 26482 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 1.271 Towata Park 0 Local Park 2 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);