superunits_with_maps

Table actions

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

24 rows where MNG_AGENCY = 149

This data as json, copyable, CSV (advanced)

Suggested facets: map, ACRES

MNG_AG_TYP 1

MNG_AGENCY 1

  • Westminster, City of · 24 ✖

ACCESS_TYP 1

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
1601 1601 1600 {"type": "Polygon", "coordinates": [[[-117.76603, 33.89034], [-117.76555, 33.89037], [-117.76559, 33.89099], [-117.76508, 33.89098], [-117.76459, 33.89093], [-117.7651, 33.88982], [-117.76432, 33.88951], [-117.76449, 33.8892], [-117.76455, 33.88903], [-117.7646, 33.8886], [-117.76459, 33.88828], [-117.76455, 33.88802], [-117.76447, 33.88778], [-117.76412, 33.8871], [-117.76407, 33.88694], [-117.76405, 33.88673], [-117.76424, 33.88674], [-117.76429, 33.88698], [-117.76439, 33.8872], [-117.76453, 33.88742], [-117.76492, 33.88793], [-117.76515, 33.8885], [-117.76528, 33.88861], [-117.76553, 33.8887], [-117.76599, 33.88867], [-117.76603, 33.89034]]]} Open Access 1 Arroyo Park   15621 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 8.707 Arroyo Park  
2058 2058 2057 {"type": "Polygon", "coordinates": [[[-117.97892, 33.75922], [-117.97849, 33.75922], [-117.97848, 33.75856], [-117.97872, 33.75856], [-117.97873, 33.75838], [-117.97892, 33.75838], [-117.97892, 33.75922]]]} Open Access 1 Blakey Park   16154 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 0.824 Blakey Park  
2127 2127 2126 {"type": "Polygon", "coordinates": [[[-118.03598, 33.76355], [-118.03598, 33.76445], [-118.03394, 33.76445], [-118.03395, 33.76355], [-118.03598, 33.76355]]]} Open Access 1 Bolsa Chica Park   16246 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 4.622 Bolsa Chica Park  
2181 2181 2180 {"type": "Polygon", "coordinates": [[[-117.95344, 33.74992], [-117.95343, 33.74995], [-117.95339, 33.74996], [-117.95254, 33.74998], [-117.95229, 33.75004], [-117.952, 33.75019], [-117.95194, 33.75017], [-117.95192, 33.75005], [-117.95191, 33.74935], [-117.95195, 33.7492], [-117.95209, 33.749], [-117.95272, 33.749], [-117.95272, 33.74927], [-117.95312, 33.74927], [-117.95338, 33.74966], [-117.95344, 33.74985], [-117.95344, 33.74992]]]} Open Access 1 Bowling Green Park   16310 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 3.18 Bowling Green Park  
2327 2327 2326 {"type": "Polygon", "coordinates": [[[-118.0157, 33.75577], [-118.01563, 33.7558], [-118.01536, 33.7558], [-118.01534, 33.75541], [-118.01243, 33.75543], [-118.01244, 33.75415], [-118.01341, 33.75414], [-118.01343, 33.75402], [-118.0149, 33.754], [-118.01514, 33.75458], [-118.01555, 33.75525], [-118.0157, 33.75577]]]} Open Access 1 Buckingham Park   16474 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 10.012 Buckingham Park  
2678 2678 2677 {"type": "Polygon", "coordinates": [[[-118.02242, 33.75773], [-118.02137, 33.75769], [-118.0211, 33.75765], [-118.02093, 33.7576], [-118.02077, 33.75752], [-118.02035, 33.75721], [-118.02241, 33.75719], [-118.02242, 33.75773]]]} Open Access 1 Cascade Park   16938 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 2.179 Cascade Park  
3038 3038 3037 {"type": "Polygon", "coordinates": [[[-117.96085, 33.73497], [-117.9595, 33.73555], [-117.95934, 33.73531], [-117.95943, 33.73525], [-117.95952, 33.73515], [-117.95957, 33.73499], [-117.95957, 33.73468], [-117.95962, 33.73466], [-117.96075, 33.73465], [-117.96085, 33.73497]]]} Open Access 1 Cloverdale Park   17443 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 2.021 Cloverdale Park  
3098 3098 3097 {"type": "Polygon", "coordinates": [[[-117.99996, 33.73891], [-117.99964, 33.73891], [-117.99932, 33.73914], [-117.9991, 33.73934], [-117.99859, 33.73889], [-117.99857, 33.7375], [-117.99908, 33.7375], [-117.99908, 33.73789], [-117.99928, 33.73813], [-117.99961, 33.73829], [-117.99995, 33.73829], [-117.99996, 33.73891]]]} Open Access 1 College Park   17512 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 3.925 College Park  
3196 3196 3195 {"type": "Polygon", "coordinates": [[[-117.96817, 33.74006], [-117.96818, 33.7406], [-117.96816, 33.7407], [-117.96686, 33.74072], [-117.96685, 33.74018], [-117.96725, 33.74018], [-117.96738, 33.74023], [-117.96746, 33.74024], [-117.96755, 33.7402], [-117.96758, 33.74017], [-117.96759, 33.7401], [-117.96782, 33.74011], [-117.96784, 33.74006], [-117.96817, 33.74006]]]} Open Access 1 Coronet Park   17651 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1.909 Coronet Park  
3930 3930 3929 {"type": "Polygon", "coordinates": [[[-117.96021, 33.73828], [-117.95756, 33.7383], [-117.95755, 33.7378], [-117.95909, 33.73779], [-117.95911, 33.73774], [-117.96021, 33.73773], [-117.96021, 33.73828]]]} Open Access 1 Elden F Gillespie Park   18549 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 3.524 Elden F Gillespie Park  
4645 4645 4644 {"type": "Polygon", "coordinates": [[[-118.01093, 33.77007], [-118.01083, 33.77015], [-118.01069, 33.7703], [-118.01061, 33.77048], [-118.01056, 33.77071], [-118.01055, 33.77119], [-118.01052, 33.77121], [-118.01012, 33.77121], [-118.01011, 33.76991], [-118.01073, 33.76991], [-118.01093, 33.77007]]]} Open Access 1 Goldenwest Park   19378 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1.77 Goldenwest Park  
4904 4904 4903 {"type": "Polygon", "coordinates": [[[-117.99828, 33.74354], [-117.99677, 33.74355], [-117.99676, 33.74265], [-117.99827, 33.74264], [-117.99828, 33.74354]]]} Open Access 1 Land Park   21001 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 3.451 Land Park  
5348 5348 5347 {"type": "Polygon", "coordinates": [[[-118.02439, 33.76206], [-118.02432, 33.76212], [-118.02366, 33.76157], [-118.02356, 33.7615], [-118.02337, 33.76144], [-118.02313, 33.76143], [-118.02311, 33.76064], [-118.02425, 33.7615], [-118.02432, 33.76159], [-118.02437, 33.76169], [-118.02439, 33.76189], [-118.02439, 33.76206]]]} Open Access 1 Indian Village Park   20212 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1.81 Indian Village Park  
6152 6152 6151 {"type": "Polygon", "coordinates": [[[-117.98542, 33.76027], [-117.98532, 33.76029], [-117.98534, 33.76166], [-117.9837, 33.76167], [-117.98369, 33.76028], [-117.98491, 33.76027], [-117.98493, 33.76004], [-117.98542, 33.76004], [-117.98542, 33.76027]]]} Open Access 1 Liberty Park   21213 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 6.088 Liberty Park  
7354 7354 7353 {"type": "Polygon", "coordinates": [[[-117.95924, 33.74856], [-117.95924, 33.74929], [-117.95809, 33.74929], [-117.95808, 33.74857], [-117.95924, 33.74856]]]} Open Access 1 Newcastle Park   22720 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 2.116 Newcastle Park  
7611 7611 7610 {"type": "Polygon", "coordinates": [[[-117.97897, 33.75604], [-117.97875, 33.75605], [-117.97875, 33.75572], [-117.97897, 33.75571], [-117.97897, 33.75604]]]} Open Access 1 Oasis Park   23040 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 0.189 Oasis Park  
7956 7956 7955 {"type": "Polygon", "coordinates": [[[-117.98493, 33.73923], [-117.98486, 33.73923], [-117.98483, 33.73916], [-117.98475, 33.73912], [-117.98468, 33.73912], [-117.98453, 33.73917], [-117.98374, 33.73918], [-117.98369, 33.73915], [-117.98368, 33.73912], [-117.98367, 33.73806], [-117.98359, 33.73775], [-117.98359, 33.73768], [-117.9837, 33.7376], [-117.98491, 33.7376], [-117.98493, 33.73923]]]} Open Access 1 Park West Park   23441 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 5.013 Park West Park  
9067 9067 9066 {"type": "Polygon", "coordinates": [[[-117.98055, 33.73309], [-117.98057, 33.73437], [-117.98053, 33.73444], [-117.98051, 33.73446], [-117.97954, 33.73448], [-117.97937, 33.73446], [-117.97905, 33.73439], [-117.97882, 33.73429], [-117.9786, 33.73423], [-117.97831, 33.73419], [-117.97799, 33.73419], [-117.97799, 33.73393], [-117.9781, 33.73391], [-117.97807, 33.73309], [-117.97804, 33.73042], [-117.97867, 33.73041], [-117.97873, 33.73325], [-117.97886, 33.73328], [-117.979, 33.73329], [-117.97921, 33.73326], [-117.98005, 33.73309], [-117.98055, 33.73309]]]} Open Access 1 Russel C. Paris Park   24737 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 12.084 Russel C. Paris Park  
9338 9338 9337 {"type": "Polygon", "coordinates": [[[-118.00358, 33.75773], [-118.00072, 33.75774], [-118.00071, 33.75692], [-118.00358, 33.75691], [-118.00358, 33.75773]]]} Open Access 1 Sigler Park   25473 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 5.983 Sigler Park  
9631 9631 9630 {"type": "Polygon", "coordinates": [[[-117.9853, 33.7564], [-117.98447, 33.75641], [-117.98446, 33.75567], [-117.98529, 33.75566], [-117.9853, 33.7564]]]} Open Access 1 Sid Goldstein Freedom Park   25438 1378 Westminster, City of 149 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1.551 Sid Goldstein Freedom 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]);