units_with_maps

Table actions

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

24 rows where COUNTY = 3, MNG_AGENCY = 149 and YR_EST = 0

This data as json, copyable, CSV (advanced)

Suggested facets: map, ACRES

MNG_AG_TYP 1

MNG_AGENCY 1

  • Westminster, City of · 24 ✖

DES_TP 1

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
376 376 375 {"type": "Polygon", "coordinates": [[[-118.01093, 33.77007], [-118.01083, 33.77015], [-118.01069, 33.77031], [-118.01061, 33.77047], [-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 1108 Goldenwest Park 19378 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 1.77 Goldenwest Park 0 Local Park 2 4
1119 1119 1118 {"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 7118 Bolsa Chica Park 16246 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 4.623 Bolsa Chica Park 0 Local Park 2 4
1359 1359 1358 {"type": "Polygon", "coordinates": [[[-117.98493, 33.73923], [-117.98486, 33.73923], [-117.98483, 33.73916], [-117.98475, 33.73912], [-117.98469, 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 7937 Park West Park 23441 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 5.013 Park West Park 0 Local Park 2 4
3392 3392 3391 {"type": "Polygon", "coordinates": [[[-117.97892, 33.75922], [-117.97849, 33.75922], [-117.97848, 33.75856], [-117.97873, 33.75856], [-117.97873, 33.75838], [-117.97892, 33.75838], [-117.97892, 33.75922]]]} Open Access 1 24627 Blakey Park 16154 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 0.823 Blakey Park 0 Local Park 2 4
5353 5353 5352 {"type": "Polygon", "coordinates": [[[-117.99946, 33.76634], [-117.99897, 33.76634], [-117.99892, 33.76292], [-117.99942, 33.76295], [-117.99946, 33.76634]]]} Open Access 1 24628 Frank G. Fry Park 33129 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 4.263 Frank G. Fry Park 0 Local Park 2 4
5355 5355 5354 {"type": "Polygon", "coordinates": [[[-117.76603, 33.89034], [-117.76555, 33.89036], [-117.76559, 33.89099], [-117.76508, 33.89098], [-117.76459, 33.89093], [-117.7651, 33.88981], [-117.76432, 33.88951], [-117.76449, 33.8892], [-117.76455, 33.88903], [-117.7646, 33.88859], [-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.88849], [-117.76528, 33.88861], [-117.76553, 33.8887], [-117.76599, 33.88867], [-117.76603, 33.89034]]]} Open Access 1 24629 Arroyo Park 15621 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 8.695 Arroyo Park 0 Local Park 2 4
5367 5367 5366 {"type": "Polygon", "coordinates": [[[-117.98542, 33.76027], [-117.98532, 33.76028], [-117.98534, 33.76166], [-117.9837, 33.76167], [-117.98369, 33.76028], [-117.98492, 33.76027], [-117.98493, 33.76004], [-117.98542, 33.76004], [-117.98542, 33.76027]]]} Open Access 1 5689 Liberty Park 21213 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 6.085 Liberty Park 0 Local Park 2 4
5446 5446 5445 {"type": "Polygon", "coordinates": [[[-118.0157, 33.75577], [-118.01563, 33.7558], [-118.01536, 33.7558], [-118.01535, 33.75541], [-118.01243, 33.75543], [-118.01244, 33.75415], [-118.01342, 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 11958 Buckingham Park 16474 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 10.007 Buckingham Park 0 Local Park 2 4
5850 5850 5849 {"type": "Polygon", "coordinates": [[[-117.96021, 33.73828], [-117.95756, 33.7383], [-117.95755, 33.7378], [-117.9591, 33.73779], [-117.95911, 33.73774], [-117.96021, 33.73773], [-117.96021, 33.73828]]]} Open Access 1 184 Elden F Gillespie Park 18549 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 3.525 Elden F Gillespie Park 0 Local Park 2 4
6476 6476 6475 {"type": "Polygon", "coordinates": [[[-118.02439, 33.76206], [-118.02432, 33.76212], [-118.02366, 33.76157], [-118.02356, 33.7615], [-118.02338, 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 2087 Indian Village Park 20212 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 1.81 Indian Village Park 0 Local Park 2 4
6567 6567 6566 {"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 3565 Land Park 21001 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 3.453 Land Park 0 Local Park 2 4
6887 6887 6886 {"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 5625 College Park 17512 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 3.925 College Park 0 Local Park 2 4
6931 6931 6930 {"type": "Polygon", "coordinates": [[[-117.97222, 33.75408], [-117.97204, 33.75409], [-117.97208, 33.75394], [-117.97207, 33.75393], [-117.9702, 33.75394], [-117.97018, 33.75223], [-117.97209, 33.75222], [-117.97218, 33.75229], [-117.9722, 33.75392], [-117.97222, 33.75393], [-117.97222, 33.75408]]]} Open Access 1 5827 Westminster Park 27407 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 8.735 Westminster Park 0 Local Park 2 4
8185 8185 8184 {"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 12611 Sigler Park 25473 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 5.986 Sigler Park 0 Local Park 2 4
10657 10657 10656 {"type": "Polygon", "coordinates": [[[-117.96085, 33.73497], [-117.9595, 33.73555], [-117.95934, 33.73531], [-117.95943, 33.73526], [-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 19009 Cloverdale Park 17443 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 2.022 Cloverdale Park 0 Local Park 2 4
10665 10665 10664 {"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.73392], [-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 19007 Russel C. Paris Park 24737 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 12.074 Russel C. Paris Park 0 Local Park 2 4
10669 10669 10668 {"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.96783, 33.74011], [-117.96784, 33.74006], [-117.96817, 33.74006]]]} Open Access 1 19010 Coronet Park 17651 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 1.909 Coronet Park 0 Local Park 2 4
10670 10670 10669 {"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 19012 Newcastle Park 22720 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 2.116 Newcastle Park 0 Local Park 2 4
10671 10671 10670 {"type": "Polygon", "coordinates": [[[-117.95312, 33.74927], [-117.95338, 33.74966], [-117.95344, 33.74985], [-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]]]} Open Access 1 19013 Bowling Green Park 16310 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 3.177 Bowling Green Park 0 Local Park 2 4
12704 12704 12703 {"type": "Polygon", "coordinates": [[[-118.02439, 33.76206], [-118.02432, 33.76212], [-118.02366, 33.76157], [-118.02356, 33.7615], [-118.02338, 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 30234 Virginia Boos Park 27156 1378 Westminster, City of 153 City 2 City Agency 2 http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp City 2 1378 Westminster, City of 149 City 2 City Agency 2   Orange 3 1.81 Virginia Boos 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]);