units_with_maps

Table actions

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

116 rows where DES_TP = 2, LAYER = 4 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_TYP, COUNTY

MNG_AG_TYP 1

  • City Agency · 116 ✖

DES_TP 1

  • Local Park · 116 ✖
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
54 54 53 {"type": "Polygon", "coordinates": [[[-119.73175, 36.7591], [-119.73175, 36.75936], [-119.73077, 36.75936], [-119.72949, 36.75856], [-119.72945, 36.75845], [-119.72945, 36.75759], [-119.73145, 36.7576], [-119.73104, 36.75782], [-119.73095, 36.75784], [-119.73086, 36.75791], [-119.73087, 36.75827], [-119.73094, 36.75851], [-119.73101, 36.75863], [-119.73118, 36.75885], [-119.73131, 36.75898], [-119.73139, 36.75904], [-119.73157, 36.75909], [-119.73175, 36.7591]]]} Open Access 1 125 Carozza Park 16891 2036 Fresno Metropolitan Flood Control District 29 Special District 4 Flood District 8 http://www.fresnofloodcontrol.org/ Special District 4 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 6.025 Carozza Park 0 Local Park 2 4
65 65 64 {"type": "Polygon", "coordinates": [[[-119.79845, 36.71057], [-119.79843, 36.71219], [-119.7971, 36.71219], [-119.79701, 36.71221], [-119.79693, 36.71228], [-119.79644, 36.71228], [-119.79644, 36.71058], [-119.79845, 36.71057]]]} Open Access 1 189 Carver Park 16927 2036 Fresno Metropolitan Flood Control District 29 Special District 4 Flood District 8 http://www.fresnofloodcontrol.org/ Special District 4 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 8.052 Carver Park 0 Local Park 2 4
347 347 346 {"type": "Polygon", "coordinates": [[[-117.85051, 34.14864], [-117.85051, 34.14999], [-117.84989, 34.15], [-117.84989, 34.15052], [-117.84633, 34.15052], [-117.84629, 34.15049], [-117.84629, 34.14964], [-117.84651, 34.14929], [-117.84697, 34.14876], [-117.84774, 34.14876], [-117.84775, 34.14814], [-117.84839, 34.14815], [-117.84839, 34.14865], [-117.85051, 34.14864]]]} Restricted Access 2 953 George Manooshian Park 29754 2312 Glendora Unified School District 141 Special District 4 School District 14 http://www.glendora.k12.ca.us/ Special District 4 1120 Glendora, City of 74 City 2 City Agency 2   Los Angeles 6 18.865 George Manooshian Park 0 Local Park 2 4
944 944 943 {"type": "Polygon", "coordinates": [[[-118.31116, 33.76052], [-118.31051, 33.76273], [-118.30904, 33.76256], [-118.30904, 33.76051], [-118.31116, 33.76052]]]} Open Access 1 5973 Eastview Park 18401 2139 Sanitation Districts of Los Angeles County 290 Special District 4 Sanitation District 18 http://www.lacsd.org/ Special District 4 1265 Rancho Palos Verdes, City of 283 City 2 City Agency 2   Los Angeles 6 9.81 Eastview Park 0 Local Park 2 4
2098 2098 2097 {"type": "Polygon", "coordinates": [[[-121.89542, 37.75272], [-121.89511, 37.75373], [-121.89391, 37.75351], [-121.89423, 37.75248], [-121.89542, 37.75272]]]} Restricted Access 2 47568 Live Oak School Park 31293 2309 San Ramon Valley Unified School District 478 Special District 4 School District 14 http://www.srvusd.net/ Special District 4 1313 San Ramon, City of 68 City 2 City Agency 2   Contra Costa 12 3.116 Live Oak School Park 0 Local Park 2 4
2216 2216 2215 {"type": "Polygon", "coordinates": [[[-121.90955, 37.75216], [-121.90924, 37.75257], [-121.90894, 37.75304], [-121.90858, 37.75288], [-121.90819, 37.75274], [-121.90782, 37.75266], [-121.90741, 37.75261], [-121.90741, 37.7522], [-121.90735, 37.75209], [-121.90718, 37.752], [-121.90702, 37.75197], [-121.90676, 37.75208], [-121.9058, 37.75097], [-121.9068, 37.75041], [-121.90754, 37.75103], [-121.90769, 37.7511], [-121.90786, 37.75114], [-121.90802, 37.75114], [-121.90823, 37.75111], [-121.90845, 37.75099], [-121.90955, 37.75216]]]} Restricted Access 2 47570 Windemere Ranch School Park 31295 2309 San Ramon Valley Unified School District 478 Special District 4 School District 14 http://www.srvusd.net/ Special District 4 1313 San Ramon, City of 68 City 2 City Agency 2   Contra Costa 12 11.225 Windemere Ranch School Park 0 Local Park 2 4
2506 2506 2505 {"type": "Polygon", "coordinates": [[[-117.3015, 33.61798], [-117.3012, 33.61831], [-117.29877, 33.61679], [-117.29902, 33.61646], [-117.3015, 33.61798]]]} Open Access 1 48910 Regency-Heritage Park 33631 2437 Ortega Trail Recreation and Park District 529 Special District 4 Recreation/Parks District 4   Special District 4 1706 Wildomar, City of 522 City 2 City Agency 2 http://www.cityofwildomar.org/community/parks_trails/parks/regency-heritage_park Riverside 10 3.114 Regency-Heritage Park 0 Local Park 2 4
3237 3237 3236 {"type": "MultiPolygon", "coordinates": [[[[-115.58465, 32.79644], [-115.5824, 32.79643], [-115.58235, 32.79448], [-115.58464, 32.79447], [-115.58465, 32.79644]]], [[[-115.58623, 32.79447], [-115.58623, 32.79645], [-115.58486, 32.79644], [-115.58485, 32.79446], [-115.58623, 32.79447]]]]} Restricted Access 2 48110 Sunflower Park 32835 2422 El Centro Elementary School District 602 Special District 4 School District 14 www.ecesd.org Special District 4 1093 El Centro, City of 92 City 2 City Agency 2 http://www.cityofelcentro.org Imperial 20 18.451 Sunflower Park 2000 Local Park 2 4
3290 3290 3289 {"type": "Polygon", "coordinates": [[[-121.39236, 36.82838], [-121.39233, 36.82946], [-121.39215, 36.82958], [-121.39084, 36.82955], [-121.3909, 36.8283], [-121.39236, 36.82838]]]} Restricted Access 2 48200 Ladd Lane School Park 32765 2425 Hollister School District 561 Special District 4 School District 14 https://www.hesd.org/ Special District 4 1138 Hollister, City of 196 City 2 City Agency 2   San Benito 38 4.424 Ladd Lane School Park 0 Local Park 2 4
3545 3545 3544 {"type": "Polygon", "coordinates": [[[-118.04485, 34.04282], [-118.04349, 34.04401], [-118.04261, 34.04329], [-118.04286, 34.04329], [-118.04283, 34.04288], [-118.04383, 34.04199], [-118.0448, 34.04278], [-118.04482, 34.04281], [-118.04485, 34.04282]]]} Restricted Access 2 20607 New Temple Park 31632 2383 Valle Lindo Unified School District 658 Special District 4 School District 14 http://www.vallelindo.k12.ca.us/ Special District 4 1402 South El Monte, City of 595 City 2 City Agency 2   Los Angeles 6 5.682 New Temple Park 0 Local Park 2 4
3622 3622 3621 {"type": "Polygon", "coordinates": [[[-119.79574, 36.86151], [-119.79571, 36.86193], [-119.79566, 36.86217], [-119.79552, 36.86243], [-119.79533, 36.86264], [-119.79448, 36.86334], [-119.79445, 36.86334], [-119.79405, 36.86302], [-119.79425, 36.86289], [-119.79478, 36.86239], [-119.79531, 36.86194], [-119.79547, 36.86178], [-119.79564, 36.86155], [-119.79574, 36.86151]]]} Open Access 1 47312 Audubon Pocket Park 31019 2036 Fresno Metropolitan Flood Control District 29 Special District 4 Flood District 8 http://www.fresnofloodcontrol.org/ Special District 4 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 2.439 Audubon PP 0 Local Park 2 4
3663 3663 3662 {"type": "Polygon", "coordinates": [[[-118.35756, 33.87843], [-118.35626, 33.87843], [-118.35625, 33.87755], [-118.3565, 33.87755], [-118.35651, 33.87731], [-118.35663, 33.87731], [-118.35663, 33.87709], [-118.35756, 33.87709], [-118.35756, 33.87843]]]} Restricted Access 2 44123 William Green Park 27544 2396 Lawndale Elementary School District 670 Special District 4 School District 14 http://www.lawndale.k12.ca.us/ Special District 4 1172 Lawndale, City of 475 City 2 City Agency 2 http://www.lawndalecity.org/ASSETS/PDF/Parks/williamgreenpark.pdf Los Angeles 6 4.064 William Green Park 0 Local Park 2 4
3922 3922 3921 {"type": "Polygon", "coordinates": [[[-118.17903, 34.59426], [-118.17429, 34.59426], [-118.17423, 34.59106], [-118.17426, 34.59084], [-118.17426, 34.59041], [-118.17434, 34.59034], [-118.17507, 34.59036], [-118.17509, 34.59034], [-118.17895, 34.59035], [-118.17903, 34.59426]]]} Restricted Access 2 46141 Highland High School Park 31877 2388 Antelope Valley Union High School District 698 Special District 4 School District 14 http://www.avdistrict.org/ Special District 4 1242 Palmdale, City of 201 City 2 City Agency 2   Los Angeles 6 46.587 Highland High School Park 0 Local Park 2 4
3932 3932 3931 {"type": "Polygon", "coordinates": [[[-118.4757, 34.42905], [-118.47423, 34.42905], [-118.4742, 34.42839], [-118.47412, 34.42835], [-118.47409, 34.42733], [-118.47558, 34.42732], [-118.47558, 34.42796], [-118.47557, 34.42802], [-118.47558, 34.42841], [-118.47568, 34.42842], [-118.4757, 34.42905]]]} Restricted Access 2 46226 North Oaks Park 31633 2389 William S. Hart Union High School District 702 Special District 4 School District 14 http://www.hartdistrict.org/ Special District 4 1319 Santa Clarita, City of 322 City 2 City Agency 2 http://www.santa-clarita.com/index.aspx?page=413 Los Angeles 6 6.399 North Oaks Park 0 Local Park 2 4
3975 3975 3974 {"type": "Polygon", "coordinates": [[[-118.01891, 33.96032], [-118.01812, 33.96131], [-118.01618, 33.96022], [-118.01659, 33.95971], [-118.01891, 33.96032]]]} Restricted Access 2 46582 Ocean View Elementary School Park 31920 2370 East Whittier City School District 707 Special District 4 School District 14 http://ewcsd.org/ Special District 4 1380 Whittier, City of 287 City 2 City Agency 2   Los Angeles 6 5.333 Ocean View Elementary School Park 0 Local Park 2 4
3978 3978 3977 {"type": "Polygon", "coordinates": [[[-118.05658, 34.16669], [-118.05578, 34.16669], [-118.05577, 34.16573], [-118.05657, 34.16571], [-118.05658, 34.16669]]]} Restricted Access 2 46602 Sierra Madre Elementary School Park 31924 2360 Pasadena Unified School District 708 Special District 4 School District 14 http://www.pusd.us/pages/PasadenaUSD Special District 4 1333 Sierra Madre, City of 308 City 2 City Agency 2   Los Angeles 6 1.948 Sierra Madre Elementary School Park 0 Local Park 2 4
4031 4031 4030 {"type": "Polygon", "coordinates": [[[-122.01457, 37.93282], [-122.01322, 37.93363], [-122.01205, 37.93236], [-122.01398, 37.93158], [-122.01414, 37.93182], [-122.01456, 37.93195], [-122.01454, 37.93209], [-122.01455, 37.93222], [-122.01415, 37.93237], [-122.01457, 37.93282]]]} Restricted Access 2 44198 Valle Verde Park 26771 2317 Mount Diablo Unified School District 712 Special District 4 School District 14 http://www.mdusd.org/ Special District 4 1371 Walnut Creek, City of 174 City 2 City Agency 2   Contra Costa 12 6.862 Valle Verde Park 0 Local Park 2 4
4386 4386 4385 {"type": "Polygon", "coordinates": [[[-117.35693, 33.17681], [-117.35685, 33.17689], [-117.3562, 33.17729], [-117.35652, 33.17766], [-117.35629, 33.17779], [-117.35659, 33.17815], [-117.3568, 33.1783], [-117.3563, 33.1786], [-117.35517, 33.17726], [-117.3566, 33.1764], [-117.35693, 33.17681]]]} Restricted Access 2 45967 South Oceanside School Park 31598 2100 Oceanside Unified School District 756 Special District 4 School District 14 http://www.oside.k12.ca.us/ Special District 4 1230 Oceanside, City of 75 City 2 City Agency 2 http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#48 San Diego 4 4.254 South Oceanside School Park 0 Local Park 2 4
4425 4425 4424 {"type": "MultiPolygon", "coordinates": [[[[-118.10901, 33.88199], [-118.10866, 33.88199], [-118.10866, 33.88024], [-118.109, 33.88024], [-118.10901, 33.88199]]], [[[-118.10903, 33.88235], [-118.109, 33.88308], [-118.10866, 33.88309], [-118.10866, 33.88235], [-118.10903, 33.88235]]], [[[-118.10901, 33.8838], [-118.10866, 33.8838], [-118.10866, 33.88327], [-118.109, 33.88327], [-118.10899, 33.88344], [-118.10901, 33.8838]]], [[[-118.10904, 33.88598], [-118.10883, 33.88598], [-118.10867, 33.88576], [-118.10866, 33.88416], [-118.10901, 33.88416], [-118.10904, 33.88598]]], [[[-118.10902, 33.88748], [-118.10884, 33.88749], [-118.10874, 33.88743], [-118.10869, 33.88737], [-118.10868, 33.88706], [-118.10902, 33.88706], [-118.10902, 33.88748]]]]} Open Access 1 46310 Caruthers Park North 29601 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 1024 Bellflower, City of 443 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 Los Angeles 6 4.548 Caruthers Park North 0 Local Park 2 4
4439 4439 4438 {"type": "Polygon", "coordinates": [[[-118.03633, 34.13066], [-118.03547, 34.13067], [-118.03546, 34.13071], [-118.03229, 34.13073], [-118.03226, 34.12947], [-118.03497, 34.12908], [-118.03498, 34.12944], [-118.03598, 34.12943], [-118.03599, 34.12981], [-118.0363, 34.12981], [-118.03633, 34.13066]]]} Restricted Access 2 46490 Arcadia High School Park 31846 2315 Arcadia Unified School District 762 Special District 4 School District 14 http://site.ausd.net/ Special District 4 1009 Arcadia, City of 299 City 2 City Agency 2 http://ahs.ausd.net/ Los Angeles 6 13.815 Arcadia High School 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]);