superunits_with_maps

Table actions

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

22 rows where ACCESS_TYP = 1, MNG_AGENCY = 191 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 22 ✖

MNG_AGENCY 1

  • Cupertino, City of · 22 ✖

ACCESS_TYP 1

  • Open Access · 22 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
2052 2052 2051 {"type": "Polygon", "coordinates": [[[-122.06315, 37.31718], [-122.06316, 37.31721], [-122.06316, 37.31766], [-122.06301, 37.3181], [-122.06273, 37.31835], [-122.06256, 37.31854], [-122.06247, 37.31892], [-122.06259, 37.31931], [-122.06205, 37.31959], [-122.06149, 37.31998], [-122.06043, 37.3185], [-122.06007, 37.31768], [-122.06076, 37.31761], [-122.06105, 37.31766], [-122.06116, 37.31765], [-122.06133, 37.31757], [-122.06137, 37.31752], [-122.06134, 37.31739], [-122.06119, 37.31725], [-122.06106, 37.3173], [-122.06081, 37.31701], [-122.06067, 37.31682], [-122.06017, 37.31646], [-122.06012, 37.31645], [-122.06011, 37.31628], [-122.06002, 37.31605], [-122.06019, 37.31559], [-122.0613, 37.31559], [-122.06158, 37.31557], [-122.06153, 37.31567], [-122.06151, 37.31577], [-122.06153, 37.31586], [-122.06159, 37.31601], [-122.0616, 37.31614], [-122.06157, 37.31624], [-122.06146, 37.31645], [-122.06145, 37.31655], [-122.06147, 37.31662], [-122.06151, 37.31668], [-122.06158, 37.31673], [-122.06208, 37.31694], [-122.06265, 37.31707], [-122.06292, 37.31716], [-122.0631, 37.31716], [-122.06315, 37.31718]]]} Open Access 1 Blackberry Farm   16139 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 18.003 Blackberry Farm 1990
2496 2496 2495 {"type": "Polygon", "coordinates": [[[-122.032, 37.32214], [-122.032, 37.3226], [-122.03199, 37.32268], [-122.03153, 37.32232], [-122.03175, 37.32214], [-122.032, 37.32214]]]} Open Access 1 Cali Mill Plaza   16683 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 0.366 Cali Mill Plaza 1997
2616 2616 2615 {"type": "Polygon", "coordinates": [[[-122.01681, 37.31623], [-122.0168, 37.31644], [-122.0164, 37.31668], [-122.01606, 37.31675], [-122.01577, 37.31726], [-122.01557, 37.31775], [-122.01363, 37.31777], [-122.01363, 37.31733], [-122.0137, 37.31731], [-122.01369, 37.31704], [-122.01379, 37.31702], [-122.01383, 37.31624], [-122.01498, 37.31627], [-122.01507, 37.31468], [-122.01624, 37.31472], [-122.0162, 37.31475], [-122.01625, 37.31503], [-122.01613, 37.31535], [-122.01612, 37.316], [-122.01639, 37.31618], [-122.01681, 37.31623]]]} Open Access 1 Creekside Park   17772 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 12.981 Creekside Park 1990
5161 5161 5160 {"type": "Polygon", "coordinates": [[[-122.06357, 37.30829], [-122.06332, 37.30863], [-122.06196, 37.30869], [-122.06081, 37.30885], [-122.06014, 37.30802], [-122.06014, 37.30757], [-122.06021, 37.30723], [-122.06026, 37.30678], [-122.06084, 37.30684], [-122.06187, 37.30748], [-122.06274, 37.30747], [-122.06338, 37.3078], [-122.06357, 37.30829]]]} Open Access 1 Linda Vista Park   21283 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 11.011 Linda Vista Park 1969
5246 5246 5245 {"type": "Polygon", "coordinates": [[[-122.03907, 37.29653], [-122.03687, 37.29654], [-122.03687, 37.29618], [-122.0371, 37.29616], [-122.03794, 37.29597], [-122.0383, 37.29595], [-122.03839, 37.29591], [-122.03842, 37.29588], [-122.03843, 37.29582], [-122.0384, 37.29574], [-122.03841, 37.29455], [-122.03906, 37.29459], [-122.03907, 37.29653]]]} Open Access 1 Hoover Park   20079 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 4.99 Hoover Park 1979
5599 5599 5598 {"type": "Polygon", "coordinates": [[[-122.04137, 37.31037], [-122.04129, 37.31038], [-122.04129, 37.31122], [-122.03919, 37.31123], [-122.03919, 37.31085], [-122.03921, 37.31077], [-122.03918, 37.31072], [-122.03913, 37.31068], [-122.03906, 37.31067], [-122.03899, 37.31068], [-122.03784, 37.31068], [-122.03781, 37.31067], [-122.03778, 37.31063], [-122.03777, 37.31009], [-122.03775, 37.31003], [-122.03771, 37.30999], [-122.0378, 37.30992], [-122.0378, 37.30965], [-122.03987, 37.30964], [-122.03995, 37.30971], [-122.03996, 37.30979], [-122.04004, 37.30986], [-122.04012, 37.30981], [-122.0408, 37.30979], [-122.04132, 37.3099], [-122.04137, 37.30995], [-122.04137, 37.31037]]]} Open Access 1 Jollyman Park   20485 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 11.115 Jollyman Park 1979
6799 6799 6798 {"type": "Polygon", "coordinates": [[[-122.06507, 37.31451], [-122.06468, 37.31447], [-122.06458, 37.31473], [-122.06457, 37.31479], [-122.06453, 37.31481], [-122.06442, 37.31483], [-122.06442, 37.31515], [-122.06431, 37.31515], [-122.0643, 37.31518], [-122.06399, 37.31518], [-122.06364, 37.31557], [-122.06362, 37.3156], [-122.06364, 37.31577], [-122.0634, 37.31566], [-122.06327, 37.31562], [-122.06277, 37.31562], [-122.06254, 37.31558], [-122.06236, 37.31551], [-122.06234, 37.31535], [-122.06217, 37.31527], [-122.0619, 37.31506], [-122.06179, 37.31479], [-122.06128, 37.31465], [-122.06149, 37.31457], [-122.0613, 37.31345], [-122.06164, 37.31332], [-122.06201, 37.31325], [-122.06226, 37.31318], [-122.06315, 37.31282], [-122.06344, 37.31279], [-122.06363, 37.31282], [-122.06374, 37.31286], [-122.06426, 37.31311], [-122.0648, 37.31329], [-122.06492, 37.31335], [-122.06502, 37.31344], [-122.06509, 37.31354], [-122.06513, 37.31365], [-122.06515, 37.31389], [-122.06514, 37.31418], [-122.06507, 37.31451]]]} Open Access 1 McClellan Ranch Park   22000 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 18.979 McClellan Ranch Park 1972
6915 6915 6914 {"type": "Polygon", "coordinates": [[[-122.04596, 37.32656], [-122.04581, 37.32656], [-122.04571, 37.32659], [-122.04442, 37.32659], [-122.04425, 37.32656], [-122.04382, 37.32642], [-122.04356, 37.32637], [-122.04169, 37.32636], [-122.04165, 37.32633], [-122.04163, 37.32629], [-122.04163, 37.32543], [-122.04167, 37.32537], [-122.04175, 37.32532], [-122.04219, 37.32527], [-122.04425, 37.32525], [-122.04425, 37.32305], [-122.04594, 37.32304], [-122.04596, 37.32656]]]} Open Access 1 Memorial Park   22126 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 21.702 Memorial Park 1966
7114 7114 7113 {"type": "Polygon", "coordinates": [[[-122.07103, 37.31902], [-122.0687, 37.31902], [-122.0687, 37.31792], [-122.07102, 37.31791], [-122.07103, 37.31902]]]} Open Access 1 Monta Vista Park   22378 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 6.266 Monta Vista Park 1966
8313 8313 8312 {"type": "Polygon", "coordinates": [[[-122.02142, 37.32647], [-122.01973, 37.32648], [-122.01971, 37.32556], [-122.02141, 37.32556], [-122.02142, 37.32647]]]} Open Access 1 Portal Park   23898 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 3.774 Portal Park 1966
9763 9763 9762 {"type": "Polygon", "coordinates": [[[-122.06043, 37.33209], [-122.05937, 37.33183], [-122.05946, 37.33169], [-122.05946, 37.33167], [-122.05864, 37.33146], [-122.05874, 37.33122], [-122.0587, 37.33113], [-122.05875, 37.3311], [-122.05878, 37.33104], [-122.05877, 37.33099], [-122.05873, 37.33095], [-122.05861, 37.33093], [-122.05868, 37.33077], [-122.06014, 37.33189], [-122.06043, 37.33209]]]} Open Access 1 Somerset Square Park   25603 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 1.476 Somerset Square Park 1971
10331 10331 10330 {"type": "Polygon", "coordinates": [[[-122.03834, 37.30227], [-122.0383, 37.3023], [-122.03825, 37.30232], [-122.03688, 37.30232], [-122.03681, 37.3023], [-122.03678, 37.30224], [-122.03678, 37.30135], [-122.03696, 37.30135], [-122.03698, 37.30148], [-122.03701, 37.30151], [-122.03707, 37.30153], [-122.03714, 37.30152], [-122.03719, 37.30147], [-122.03724, 37.30145], [-122.03794, 37.30145], [-122.0383, 37.30149], [-122.03834, 37.30151], [-122.03835, 37.30155], [-122.03835, 37.30223], [-122.03834, 37.30227]]]} Open Access 1 Three Oaks Park   26332 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 3.297 Three Oaks Park 1979
10662 10662 10661 {"type": "Polygon", "coordinates": [[[-122.06352, 37.32686], [-122.06229, 37.32675], [-122.06204, 37.32512], [-122.06134, 37.32413], [-122.06138, 37.3239], [-122.06348, 37.32565], [-122.06352, 37.32686]]]} Open Access 1 Varian Park   26837 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 6.473 Varian Park 1966
11304 11304 11303 {"type": "Polygon", "coordinates": [[[-122.02204, 37.31857], [-122.02204, 37.31871], [-122.02193, 37.31872], [-122.02188, 37.31876], [-122.02186, 37.31879], [-122.02187, 37.31884], [-122.02191, 37.31892], [-122.02191, 37.31979], [-122.02189, 37.31981], [-122.02178, 37.3198], [-122.02146, 37.31969], [-122.02119, 37.31965], [-122.02101, 37.31966], [-122.02062, 37.31972], [-122.02055, 37.31966], [-122.02026, 37.31966], [-122.02024, 37.31975], [-122.01989, 37.31974], [-122.01988, 37.3197], [-122.01985, 37.31967], [-122.01976, 37.31964], [-122.01962, 37.31968], [-122.0186, 37.31968], [-122.01922, 37.31816], [-122.02042, 37.31832], [-122.02043, 37.31836], [-122.02204, 37.31857]]]} Open Access 1 Wilson Park   27609 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 9.937 Wilson Park 1966
12316 12316 12315 {"type": "Polygon", "coordinates": [[[-122.03079, 37.31841], [-122.03076, 37.31847], [-122.03068, 37.3185], [-122.0299, 37.31849], [-122.02985, 37.31847], [-122.02982, 37.31844], [-122.0298, 37.31836], [-122.02984, 37.31829], [-122.02991, 37.31826], [-122.03071, 37.31826], [-122.03076, 37.31829], [-122.03078, 37.31833], [-122.03079, 37.31841]]]} Open Access 1 Sandra James Park http://www.cupertino.org/ 30838 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 0.535 Sandra James Park  
12999 12999 12998 {"type": "Polygon", "coordinates": [[[-122.08884, 37.33641], [-122.08847, 37.33664], [-122.0884, 37.33667], [-122.0882, 37.33644], [-122.08828, 37.33642], [-122.08864, 37.33622], [-122.08884, 37.33641]]]} Open Access 1 Little Rancho Park http://www.cupertino.org/ 30843 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 0.339 Little Rancho Park  
13442 13442 13441 {"type": "Polygon", "coordinates": [[[-122.03733, 37.33727], [-122.03733, 37.33744], [-122.03694, 37.33744], [-122.03689, 37.33742], [-122.03689, 37.33658], [-122.03728, 37.33658], [-122.03728, 37.33725], [-122.03733, 37.33727]]]} Open Access 1 Franco Park http://www.cupertino.org/ 30834 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 0.836 Franco Park  
13443 13443 13442 {"type": "Polygon", "coordinates": [[[-122.07929, 37.32838], [-122.07873, 37.32863], [-122.07851, 37.32832], [-122.07907, 37.32807], [-122.07929, 37.32838]]]} Open Access 1 Canyon Oak Park http://www.cupertino.org/ 30835 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 0.555 Canyon Oak Park  
13444 13444 13443 {"type": "Polygon", "coordinates": [[[-122.06192, 37.32255], [-122.06187, 37.3226], [-122.06186, 37.32269], [-122.06179, 37.3227], [-122.06168, 37.3228], [-122.06157, 37.32277], [-122.06144, 37.32279], [-122.06116, 37.32257], [-122.06078, 37.32239], [-122.06039, 37.32208], [-122.06036, 37.32175], [-122.06041, 37.32112], [-122.06053, 37.32091], [-122.06094, 37.32047], [-122.06101, 37.32033], [-122.06123, 37.32015], [-122.06129, 37.32037], [-122.06127, 37.32086], [-122.06128, 37.32108], [-122.06139, 37.3217], [-122.06147, 37.32172], [-122.06165, 37.32241], [-122.06172, 37.32256], [-122.06177, 37.32259], [-122.06192, 37.32255]]]} Open Access 1 Stocklmeir Ranch http://www.cupertino.org/ 30836 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 4.904 Stocklmeir Ranch  
13445 13445 13444 {"type": "Polygon", "coordinates": [[[-122.05109, 37.3278], [-122.05067, 37.32805], [-122.05066, 37.32751], [-122.05061, 37.32715], [-122.05071, 37.32712], [-122.05109, 37.3278]]]} Open Access 1 Mary Avenue Dog Park http://www.cupertino.org/ 30837 1076 Cupertino, City of 191 City 2 City Agency 2 http://www.cupertino.org/index.aspx?page=591 City 2 0.54 Mary Avenue Dog Park  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);