units_with_maps

Table actions

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

128 rows where AGNCY_LEV = 4, AGNCY_TYP = 14 and DES_TP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_URL

ACCESS_TYP 2

DES_TP 1

  • Local Park · 128 ✖
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
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
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
2245 2245 2244 {"type": "Polygon", "coordinates": [[[-118.84354, 34.17707], [-118.84327, 34.17764], [-118.84313, 34.17791], [-118.84297, 34.17808], [-118.84271, 34.178], [-118.84174, 34.17697], [-118.84123, 34.17723], [-118.84141, 34.17751], [-118.84091, 34.17775], [-118.84047, 34.17714], [-118.84173, 34.17649], [-118.84228, 34.17687], [-118.84243, 34.17692], [-118.84354, 34.17707]]]} Restricted Access 2 18017 Beyer Park 31603 2026 Conejo Valley Unified School District 501 Special District 4 School District 14 http://www.conejo.k12.ca.us/ Special District 4 2026 Conejo Valley Unified School District 493 Special District 4 School District 21   Ventura 8 5.138 Beyer 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
3314 3314 3313 {"type": "Polygon", "coordinates": [[[-118.64407, 34.17777], [-118.64325, 34.17777], [-118.64319, 34.17773], [-118.64316, 34.17565], [-118.6432, 34.1756], [-118.64385, 34.17559], [-118.64406, 34.17557], [-118.64407, 34.17777]]]} Restricted Access 2 46863 Hale Middle School Park 31933 2361 Los Angeles Unified School District 616 Special District 4 School District 14 http://home.lausd.net/ Special District 4 2361 Los Angeles Unified School District 605 Special District 4 School District 21   Los Angeles 6 4.875 Hale Middle School Park 0 Local Park 2 4
3315 3315 3314 {"type": "Polygon", "coordinates": [[[-118.64398, 34.17228], [-118.64364, 34.17254], [-118.64342, 34.17277], [-118.64336, 34.17279], [-118.64174, 34.17195], [-118.64141, 34.17184], [-118.64117, 34.17179], [-118.64091, 34.17176], [-118.64087, 34.17171], [-118.64087, 34.17063], [-118.64304, 34.17156], [-118.64323, 34.17156], [-118.64367, 34.17194], [-118.64398, 34.17228]]]} Restricted Access 2 46867 El Camino Real High School Park 31936 2361 Los Angeles Unified School District 616 Special District 4 School District 14 http://home.lausd.net/ Special District 4 2361 Los Angeles Unified School District 605 Special District 4 School District 21   Los Angeles 6 7.345 El Camino Real High 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
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
3963 3963 3962 {"type": "Polygon", "coordinates": [[[-118.10299, 34.1077], [-118.1021, 34.1077], [-118.10206, 34.10769], [-118.10203, 34.1063], [-118.10278, 34.10629], [-118.10278, 34.10728], [-118.10298, 34.10729], [-118.10299, 34.1077]]]} Restricted Access 2 46471 Washington School Park 32680 2393 San Gabriel Unified School District 706 Special District 4 School District 14 http://www.sgusd.k12.ca.us/ Special District 4 2393 San Gabriel Unified School District 693 Special District 4 School District 21   Los Angeles 6 2.827 Washington School 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
4236 4236 4235 {"type": "Polygon", "coordinates": [[[-117.89955, 34.13086], [-117.89865, 34.13086], [-117.89864, 34.13131], [-117.89633, 34.1313], [-117.89633, 34.13075], [-117.89641, 34.13075], [-117.8965, 34.13064], [-117.89807, 34.12999], [-117.89819, 34.12996], [-117.89829, 34.1299], [-117.89904, 34.1299], [-117.89906, 34.13045], [-117.89953, 34.13046], [-117.89955, 34.13086]]]} Restricted Access 2 47860 Charles Lee Elementary School Park 31944 2365 Azusa Unified School District 736 Special District 4 School District 14 https://ausd-ca.schoolloop.com/ Special District 4 2365 Azusa Unified School District 720 Special District 4 School District 21   Los Angeles 6 7.662 Charles Lee Elementary School 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
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
4830 4830 4829 {"type": "Polygon", "coordinates": [[[-118.01607, 33.95413], [-118.01537, 33.95498], [-118.01511, 33.95485], [-118.01456, 33.95558], [-118.01606, 33.9564], [-118.01525, 33.95741], [-118.01384, 33.95663], [-118.01356, 33.9561], [-118.0145, 33.95494], [-118.0145, 33.95492], [-118.01435, 33.95484], [-118.01524, 33.9537], [-118.01607, 33.95413]]]} Restricted Access 2 46570 East Whittier Middle School Park 31913 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 10.453 East Whittier Middle 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]);