units_with_maps

Table actions

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

115 rows where ACCESS_TYP = 1, GAP_STS = 4 and MNG_AGENCY = 56

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 115 ✖
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
146 146 145 {"type": "Polygon", "coordinates": [[[-122.24241, 37.79003], [-122.24099, 37.79152], [-122.23911, 37.7904], [-122.24053, 37.78891], [-122.24241, 37.79003]]]} Open Access 1 366 San Antonio Park 24832 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 10.619 San Antonio Park 0 Local Park 2 4
681 681 680 {"type": "Polygon", "coordinates": [[[-122.19178, 37.73593], [-122.19137, 37.73616], [-122.19116, 37.73688], [-122.19077, 37.73841], [-122.18827, 37.73776], [-122.18881, 37.73569], [-122.19025, 37.736], [-122.19031, 37.73606], [-122.19074, 37.7357], [-122.19104, 37.73566], [-122.19126, 37.73533], [-122.19178, 37.73593]]]} Open Access 1 3504 Ira Jenkins Park 20226 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 15.161 Ira Jenkins Park 0 Local Park 2 4
1556 1556 1555 {"type": "Polygon", "coordinates": [[[-122.28429, 37.8453], [-122.28401, 37.84534], [-122.28346, 37.84522], [-122.28281, 37.8452], [-122.28279, 37.84516], [-122.28227, 37.84523], [-122.28208, 37.84463], [-122.284, 37.8444], [-122.28429, 37.8453]]]} Open Access 1 13055 Golden Gate Recreation Center 19360 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 3.496 Golden Gate Rec. Ctr. 0 Local Recreation Area 3 4
1576 1576 1575 {"type": "Polygon", "coordinates": [[[-122.28067, 37.81793], [-122.28059, 37.81813], [-122.28026, 37.81805], [-122.28033, 37.81785], [-122.28067, 37.81793]]]} Open Access 1 13449 McClymonds Mini Park 22003 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 0.176 McClymonds MP 0 Local Park 2 4
1771 1771 1770 {"type": "Polygon", "coordinates": [[[-122.24362, 37.84525], [-122.24333, 37.84541], [-122.2431, 37.84557], [-122.24304, 37.84555], [-122.24291, 37.84531], [-122.24294, 37.84529], [-122.24336, 37.84527], [-122.24362, 37.84525]]]} Open Access 1 13245 Rockridge Park 24533 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 0.248 Rockridge Park 0 Local Park 2 4
1772 1772 1771 {"type": "Polygon", "coordinates": [[[-122.23771, 37.84106], [-122.23757, 37.84115], [-122.23742, 37.84121], [-122.2367, 37.84127], [-122.23653, 37.84132], [-122.2364, 37.84138], [-122.2364, 37.84135], [-122.23642, 37.84134], [-122.23663, 37.84122], [-122.23693, 37.84111], [-122.23724, 37.84105], [-122.23771, 37.84106]]]} Open Access 1 13247 Ostrander Park 23239 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 0.351 Ostrander Park 0 Local Park 2 4
1778 1778 1777 {"type": "Polygon", "coordinates": [[[-122.27921, 37.80074], [-122.2789, 37.80123], [-122.27797, 37.80087], [-122.27828, 37.80037], [-122.27921, 37.80074]]]} Open Access 1 13264 Jefferson Square 20383 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 1.376 Jefferson Square 0 Local Park 2 4
1779 1779 1778 {"type": "Polygon", "coordinates": [[[-122.27241, 37.80487], [-122.27205, 37.80548], [-122.27156, 37.80529], [-122.27141, 37.80474], [-122.27152, 37.80454], [-122.27241, 37.80487]]]} Open Access 1 13266 City Hall Plaza 17298 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 1.331 City Hall Plaza 0 Local Park 2 4
1780 1780 1779 {"type": "Polygon", "coordinates": [[[-122.29076, 37.80888], [-122.29052, 37.80959], [-122.28941, 37.8093], [-122.28911, 37.80883], [-122.28908, 37.8086], [-122.28911, 37.80855], [-122.29076, 37.80888]]]} Open Access 1 13270 Wade Johnson Park 27206 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 2.538 Wade Johnson Park 0 Local Park 2 4
1781 1781 1780 {"type": "Polygon", "coordinates": [[[-122.26913, 37.80021], [-122.26883, 37.8007], [-122.26789, 37.80033], [-122.2682, 37.79984], [-122.26913, 37.80021]]]} Open Access 1 13272 Lincoln Square 21275 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 1.384 Lincoln Square 0 Local Park 2 4
1782 1782 1781 {"type": "Polygon", "coordinates": [[[-122.2254, 37.79572], [-122.22488, 37.79726], [-122.2254, 37.79739], [-122.22534, 37.79752], [-122.22512, 37.79788], [-122.22476, 37.79824], [-122.22455, 37.79614], [-122.22445, 37.7959], [-122.22414, 37.79575], [-122.22369, 37.79573], [-122.22272, 37.79592], [-122.22233, 37.79614], [-122.22223, 37.79636], [-122.22215, 37.79767], [-122.2213, 37.79752], [-122.22212, 37.79528], [-122.22285, 37.79546], [-122.22296, 37.79513], [-122.2254, 37.79572]]]} Open Access 1 13342 Central Reservoir Park 17073 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 9.124 Central Reservoir Park 0 Local Park 2 4
1783 1783 1782 {"type": "Polygon", "coordinates": [[[-122.22948, 37.76961], [-122.22949, 37.76963], [-122.22947, 37.76968], [-122.22925, 37.76996], [-122.22923, 37.76995], [-122.22916, 37.7696], [-122.22906, 37.76933], [-122.22948, 37.76961]]]} Open Access 1 13417 Fruitvale Bridge Park 19137 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 0.269 Fruitvale Bridge Park 0 Local Park 2 4
1786 1786 1785 {"type": "MultiPolygon", "coordinates": [[[[-122.1954, 37.82229], [-122.19539, 37.82275], [-122.19527, 37.82277], [-122.19515, 37.82276], [-122.19508, 37.82279], [-122.19504, 37.82282], [-122.19503, 37.82287], [-122.19507, 37.82295], [-122.19491, 37.82308], [-122.19499, 37.82334], [-122.19473, 37.82344], [-122.19435, 37.82312], [-122.19461, 37.82274], [-122.19468, 37.82212], [-122.1954, 37.82229]]], [[[-122.19681, 37.82266], [-122.19664, 37.82301], [-122.19627, 37.82287], [-122.19606, 37.82281], [-122.19577, 37.82276], [-122.19543, 37.82274], [-122.19543, 37.82229], [-122.19653, 37.82252], [-122.19681, 37.82266]]]]} Open Access 1 13396 Beaconsfield Canyon 15914 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 3.073 Beaconsfield Canyon 0 Local Recreation Area 3 4
1788 1788 1787 {"type": "Polygon", "coordinates": [[[-122.24809, 37.82008], [-122.24766, 37.82045], [-122.2476, 37.82052], [-122.24759, 37.82057], [-122.24759, 37.82064], [-122.24762, 37.82071], [-122.24789, 37.8209], [-122.24764, 37.82114], [-122.24789, 37.82131], [-122.24701, 37.82157], [-122.24627, 37.82034], [-122.24623, 37.82029], [-122.2456, 37.81975], [-122.24606, 37.81933], [-122.24615, 37.81937], [-122.24623, 37.81953], [-122.24624, 37.81963], [-122.24631, 37.81966], [-122.24639, 37.81965], [-122.24642, 37.81961], [-122.24642, 37.81958], [-122.24638, 37.81953], [-122.24632, 37.81946], [-122.24627, 37.8194], [-122.24628, 37.81931], [-122.2466, 37.81952], [-122.24727, 37.81894], [-122.24761, 37.81918], [-122.24682, 37.81986], [-122.24699, 37.81996], [-122.2475, 37.81952], [-122.24784, 37.81976], [-122.24775, 37.81985], [-122.24809, 37.82008]]]} Open Access 1 13453 Morcom Rose Garden 22472 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 7.464 Morcom Rose Garden 0 Local Park 2 4
2039 2039 2038 {"type": "Polygon", "coordinates": [[[-122.28859, 37.81185], [-122.28813, 37.81311], [-122.28611, 37.81266], [-122.28528, 37.8123], [-122.28569, 37.81119], [-122.28859, 37.81185]]]} Open Access 1 15570 DeFremery Park 18017 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 9.428 DeFremery Park 1910 Local Park 2 4
2050 2050 2049 {"type": "Polygon", "coordinates": [[[-122.17764, 37.72612], [-122.17735, 37.72742], [-122.17733, 37.72744], [-122.17726, 37.72744], [-122.17601, 37.72728], [-122.17597, 37.72726], [-122.17595, 37.72723], [-122.1762, 37.72594], [-122.17764, 37.72612]]]} Open Access 1 15614 Sobrante Park 25587 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 4.682 Sobrante Park 0 Local Park 2 4
2458 2458 2457 {"type": "Polygon", "coordinates": [[[-122.17762, 37.76178], [-122.17531, 37.76327], [-122.17401, 37.76158], [-122.17408, 37.76156], [-122.17414, 37.76151], [-122.17415, 37.76144], [-122.17413, 37.76138], [-122.17405, 37.76132], [-122.17392, 37.76131], [-122.17367, 37.76098], [-122.17577, 37.75997], [-122.17762, 37.76178]]]} Open Access 1 17382 Arroyo Viejo Park 15635 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 16.302 Arroyo Viejo Park 0 Local Park 2 4
2479 2479 2478 {"type": "Polygon", "coordinates": [[[-122.28586, 37.80805], [-122.28546, 37.8093], [-122.28276, 37.80878], [-122.28328, 37.80749], [-122.28586, 37.80805]]]} Open Access 1 17473 Lowell Park 21557 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 8.71 Lowell Park 0 Local Park 2 4
2633 2633 2632 {"type": "Polygon", "coordinates": [[[-122.26189, 37.82383], [-122.26156, 37.82507], [-122.26052, 37.82483], [-122.25985, 37.82466], [-122.25897, 37.82438], [-122.25893, 37.82436], [-122.25891, 37.82431], [-122.25892, 37.82427], [-122.25984, 37.82279], [-122.26038, 37.82299], [-122.2614, 37.82321], [-122.2614, 37.8233], [-122.26143, 37.82338], [-122.26189, 37.82383]]]} Open Access 1 18052 Mosswood Park 22516 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 10.31 Mosswood Park 1912 Local Park 2 4
3074 3074 3073 {"type": "Polygon", "coordinates": [[[-122.21426, 37.79561], [-122.21378, 37.79679], [-122.21206, 37.79603], [-122.21209, 37.79595], [-122.21209, 37.79585], [-122.21199, 37.79538], [-122.21201, 37.79535], [-122.21252, 37.79484], [-122.21426, 37.79561]]]} Open Access 1 24940 Curt Flood Field 17862 1228 Oakland, City of 58 City 2 City Agency 2 http://www2.oaklandnet.com/Government/o/opr/index.htm City 2 1228 Oakland, City of 56 City 2 City Agency 2   Alameda 17 6.219 Curt Flood Field 0 Local Recreation Area 3 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]);