units_with_maps

Table actions

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

1,405 rows where COUNTY = 6, DES_TP = 2 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: DES_TP

MNG_AG_TYP 1

  • City Agency · 1,405 ✖
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
8 8 7 {"type": "Polygon", "coordinates": [[[-117.70487, 34.09777], [-117.70457, 34.09776], [-117.7046, 34.09775], [-117.70462, 34.09772], [-117.70461, 34.09748], [-117.70381, 34.09747], [-117.7042, 34.09652], [-117.7048, 34.09652], [-117.70482, 34.09772], [-117.70483, 34.09775], [-117.70487, 34.09777]]]} Open Access 1 30 El Barrio Park 18477 1057 Claremont, City of 6 City 2 City Agency 2 http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 City 2 1057 Claremont, City of 6 City 2 City Agency 2   Los Angeles 6 2.099 El Barrio Park 0 Local Park 2 4
17 17 16 {"type": "Polygon", "coordinates": [[[-118.12258, 34.69275], [-118.12251, 34.69275], [-118.1225, 34.69267], [-118.1217, 34.69267], [-118.12164, 34.69261], [-118.12164, 34.69054], [-118.12169, 34.69048], [-118.12257, 34.69049], [-118.12258, 34.69275]]]} Open Access 1 56 El Dorado Park 18505 1169 Lancaster, City of 11 City 2 City Agency 2 http://www.cityoflancasterca.org/index.aspx?page=23 City 2 1169 Lancaster, City of 11 City 2 City Agency 2   Los Angeles 6 5.137 El Dorado Park 0 Local Park 2 4
27 27 26 {"type": "Polygon", "coordinates": [[[-118.40012, 33.99275], [-118.39867, 33.9928], [-118.39865, 33.99222], [-118.39914, 33.99221], [-118.39922, 33.99218], [-118.39931, 33.99211], [-118.40012, 33.99275]]]} Open Access 1 78 El Marino Park 18512 1075 Culver City, City of 18 City 2 City Agency 2 http://www.culvercity.org/Home/Government/PRCS City 2 1075 Culver City, City of 18 City 2 City Agency 2   Los Angeles 6 1.645 El Marino Park 0 Local Park 2 4
44 44 43 {"type": "Polygon", "coordinates": [[[-118.35044, 34.13077], [-118.35003, 34.13136], [-118.34933, 34.1306], [-118.3496, 34.13019], [-118.35044, 34.13077]]]} Open Access 1 99 El Paseo Cahuenga Park 18526 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 1.546 El Paseo Cahuenga Park 0 Local Park 2 4
66 66 65 {"type": "Polygon", "coordinates": [[[-118.24767, 33.99122], [-118.24568, 33.99122], [-118.24567, 33.98955], [-118.24762, 33.98955], [-118.24767, 33.99122]]]} Open Access 1 190 Augustus Hawkins Natural Park 15707 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 8.369 Augustus Hawkins Natural Park 0 Local Park 2 4
95 95 94 {"type": "Polygon", "coordinates": [[[-118.50316, 34.16163], [-118.50227, 34.16163], [-118.50228, 34.15971], [-118.50316, 34.15991], [-118.50316, 34.16163]]]} Open Access 1 302 Encino Park 18668 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 4.067 Encino Park 0 Local Park 2 4
127 127 126 {"type": "MultiPolygon", "coordinates": [[[[-118.41914, 34.18293], [-118.4191, 34.18296], [-118.41829, 34.18296], [-118.41826, 34.18294], [-118.41825, 34.1818], [-118.41911, 34.18181], [-118.41914, 34.18184], [-118.41914, 34.18293]]], [[[-118.42023, 34.18293], [-118.42019, 34.18296], [-118.41938, 34.18296], [-118.41935, 34.18294], [-118.41934, 34.18184], [-118.42023, 34.18184], [-118.42023, 34.18293]]]]} Open Access 1 335 Valley Glen Community Park 26789 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 5.115 Valley Glen Community Park 0 Local Park 2 4
156 156 155 {"type": "Polygon", "coordinates": [[[-118.27409, 34.2411], [-118.27374, 34.24114], [-118.2736, 34.24083], [-118.27329, 34.24038], [-118.2733, 34.24033], [-118.27334, 34.24031], [-118.27398, 34.2402], [-118.27404, 34.24086], [-118.27409, 34.2411]]]} Open Access 1 494 Fehlhaber-Houk Park 28620 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2 http://www.laparks.org/dos/parks/facility/fehlhaberHoukPk.htm Los Angeles 6 1.175 Fehlhaber-Houk Park 0 Local Park 2 4
159 159 158 {"type": "Polygon", "coordinates": [[[-118.24886, 34.06967], [-118.24887, 34.07033], [-118.24883, 34.07039], [-118.24876, 34.07043], [-118.24868, 34.07045], [-118.2486, 34.07043], [-118.24854, 34.0704], [-118.2485, 34.07035], [-118.24848, 34.07029], [-118.24848, 34.07024], [-118.24877, 34.06965], [-118.24882, 34.06963], [-118.24886, 34.06967]]]} Open Access 1 405 Everett Park 18763 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 0.521 Everett Park 0 Local Park 2 4
191 191 190 {"type": "Polygon", "coordinates": [[[-117.86272, 34.13676], [-117.86272, 34.1379], [-117.86159, 34.13789], [-117.86159, 34.13768], [-117.8614, 34.13767], [-117.86139, 34.13846], [-117.8604, 34.13846], [-117.86039, 34.13911], [-117.85941, 34.13911], [-117.85942, 34.137], [-117.8616, 34.13699], [-117.86272, 34.13676]]]} Open Access 1 526 Finkbiner Park 18903 1120 Glendora, City of 76 City 2 City Agency 2 http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services City 2 1120 Glendora, City of 74 City 2 City Agency 2   Los Angeles 6 12.166 Finkbiner Park 0 Local Park 2 4
202 202 201 {"type": "Polygon", "coordinates": [[[-118.13925, 33.95299], [-118.13784, 33.95493], [-118.13573, 33.95379], [-118.13714, 33.95185], [-118.13925, 33.95299]]]} Open Access 1 779 Furman Park 19152 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 14.404 Furman Park 0 Local Park 2 4
207 207 206 {"type": "Polygon", "coordinates": [[[-118.19702, 33.98473], [-118.19697, 33.98506], [-118.19606, 33.98497], [-118.19611, 33.98464], [-118.19702, 33.98473]]]} Open Access 1 652 Freedom Park 19085 1142 Huntington Park, City of 85 City 2 City Agency 2 http://www.hpca.gov/index.aspx?nid=14 City 2 1142 Huntington Park, City of 83 City 2 City Agency 2   Los Angeles 6 0.791 Freedom Park 0 Local Park 2 4
231 231 230 {"type": "Polygon", "coordinates": [[[-118.3823, 33.98709], [-118.38228, 33.98732], [-118.38226, 33.98736], [-118.38222, 33.98737], [-118.38191, 33.98738], [-118.3823, 33.98709]]]} Open Access 1 625 Fox Hills Parkette 19032 1075 Culver City, City of 18 City 2 City Agency 2 http://www.culvercity.org/Home/Government/PRCS City 2 1075 Culver City, City of 18 City 2 City Agency 2   Los Angeles 6 0.13 Fox Hills Parkette 0 Local Park 2 4
250 250 249 {"type": "Polygon", "coordinates": [[[-118.26941, 34.15733], [-118.26731, 34.15813], [-118.26727, 34.15765], [-118.26685, 34.15765], [-118.26684, 34.15655], [-118.2686, 34.15653], [-118.26939, 34.15648], [-118.2694, 34.15651], [-118.26941, 34.15733]]]} Open Access 1 680 Fremont Park 19098 1119 Glendale, City of 103 City 2 City Agency 2 http://www.glendaleca.gov/government/city-departments/community-services-parks City 2 1119 Glendale, City of 100 City 2 City Agency 2   Los Angeles 6 7.714 Fremont Park 0 Local Park 2 4
310 310 309 {"type": "Polygon", "coordinates": [[[-117.7344, 34.06396], [-117.73343, 34.06398], [-117.73339, 34.06293], [-117.7344, 34.06291], [-117.7344, 34.06396]]]} Open Access 1 839 Garfield Park 19215 1258 Pomona, City of 128 City 2 City Agency 2 http://ci.pomona.ca.us/index.php/visitors/park-directory City 2 1258 Pomona, City of 125 City 2 City Agency 2   Los Angeles 6 2.655 Garfield Park 0 Local Park 2 4
319 319 318 {"type": "Polygon", "coordinates": [[[-118.18189, 34.12005], [-118.18189, 34.12005], [-118.17889, 34.12008], [-118.1804, 34.11888], [-118.18088, 34.11808], [-118.18153, 34.11815], [-118.18189, 34.12005]]]} Open Access 1 855 Garvanza Park 19226 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 8.274 Garvanza Park 0 Local Park 2 4
324 324 323 {"type": "Polygon", "coordinates": [[[-118.09816, 34.06798], [-118.09728, 34.06798], [-118.09727, 34.06805], [-118.09506, 34.06807], [-118.09504, 34.06635], [-118.09805, 34.06632], [-118.09806, 34.06711], [-118.09726, 34.06711], [-118.09726, 34.06738], [-118.09815, 34.06738], [-118.09816, 34.06798]]]} Open Access 1 863 Garvey Park 19227 1284 Rosemead, City of 130 City 2 City Agency 2 http://www.cityofrosemead.org/index.aspx?page=74 City 2 1284 Rosemead, City of 127 City 2 City Agency 2   Los Angeles 6 12.61 Garvey Park 0 Local Park 2 4
327 327 326 {"type": "Polygon", "coordinates": [[[-118.11643, 34.05357], [-118.11612, 34.05357], [-118.11571, 34.05344], [-118.11533, 34.05395], [-118.11472, 34.05395], [-118.11472, 34.05415], [-118.1132, 34.05415], [-118.11324, 34.05404], [-118.11325, 34.0539], [-118.11322, 34.05366], [-118.11315, 34.05352], [-118.11294, 34.05326], [-118.11289, 34.05308], [-118.11289, 34.05142], [-118.11424, 34.05142], [-118.11452, 34.0518], [-118.11562, 34.05217], [-118.11642, 34.0526], [-118.11643, 34.05357]]]} Open Access 1 870 Garvey Ranch Park 19228 1213 Monterey Park, City of 133 City 2 City Agency 2 http://www.ci.monterey-park.ca.us/ City 2 1213 Monterey Park, City of 130 City 2 City Agency 2   Los Angeles 6 18.252 Garvey Ranch Park 0 Local Park 2 4
331 331 330 {"type": "Polygon", "coordinates": [[[-118.36901, 34.03598], [-118.36855, 34.03714], [-118.36689, 34.03694], [-118.36745, 34.03546], [-118.36901, 34.03598]]]} Open Access 1 908 Genesee Avenue Park 19255 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 5.852 Genesee Avenue Park 0 Local Park 2 4
341 341 340 {"type": "Polygon", "coordinates": [[[-118.32171, 34.1722], [-118.32168, 34.17224], [-118.31863, 34.17327], [-118.3181, 34.1722], [-118.32051, 34.1699], [-118.32055, 34.16989], [-118.3206, 34.16992], [-118.32171, 34.1722]]]} Open Access 1 934 George Izay Park 19267 1038 Burbank, City of 138 City 2 City Agency 2 http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities City 2 1038 Burbank, City of 135 City 2 City Agency 2   Los Angeles 6 15.711 George Izay 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]);