units_with_maps

Table actions

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

94 rows where AGNCY_TYP = 14, DES_TP = 2 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_URL, COUNTY, YR_EST

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 94 ✖

DES_TP 1

  • Local Park · 94 ✖
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
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
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
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
4998 4998 4997 {"type": "Polygon", "coordinates": [[[-121.31861, 38.90558], [-121.31687, 38.90557], [-121.31691, 38.90427], [-121.31861, 38.90427], [-121.31861, 38.90558]]]} Open Access 1 48685 Foskett Regional Park 33425 2433 Western Placer School District 791 Special District 4 School District 14 http://www.wpusd.org/ Special District 4 1175 Lincoln, City of 597 City 2 City Agency 2 http://www.lincolnca.gov/city-hall/departments-divisions/parks-recreation/parks Placer 35 5.355 Foskett RP 0 Local Park 2 4
5465 5465 5464 {"type": "Polygon", "coordinates": [[[-118.33727, 33.9101], [-118.33699, 33.91011], [-118.33698, 33.91027], [-118.3365, 33.91027], [-118.3365, 33.90959], [-118.33727, 33.90959], [-118.33727, 33.9101]]]} Restricted Access 2 6273 Zela Davis Elementary School Park 31892 2044 Hawthorne School District 808 Special District 4 School District 14 http://www.hawthorne.k12.ca.us/ Special District 4 1130 Hawthorne, City of 295 City 2 City Agency 2   Los Angeles 6 1.201 Zela Davis Elementary School Park 0 Local Park 2 4
5604 5604 5603 {"type": "Polygon", "coordinates": [[[-118.04327, 34.16534], [-118.04239, 34.16534], [-118.04238, 34.16395], [-118.04326, 34.16394], [-118.04327, 34.16534]]]} Restricted Access 2 46603 Sierra Madre Middle School Park 31925 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 3.117 Sierra Madre Middle School Park 0 Local Park 2 4
5721 5721 5720 {"type": "Polygon", "coordinates": [[[-118.03804, 33.95602], [-118.03719, 33.95686], [-118.03667, 33.9565], [-118.03649, 33.95641], [-118.03662, 33.95617], [-118.03671, 33.9562], [-118.03678, 33.95608], [-118.03691, 33.95609], [-118.03698, 33.95594], [-118.03709, 33.95597], [-118.03726, 33.95566], [-118.03687, 33.95551], [-118.03656, 33.95547], [-118.03544, 33.95494], [-118.03587, 33.95451], [-118.03804, 33.95602]]]} Restricted Access 2 46576 Laurel Elementary School Park 31914 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 4.34 Laurel Elementary School Park 0 Local Park 2 4
5722 5722 5721 {"type": "Polygon", "coordinates": [[[-118.00903, 33.93231], [-118.00901, 33.93505], [-118.00717, 33.93505], [-118.00718, 33.93474], [-118.00684, 33.93474], [-118.00684, 33.93436], [-118.00787, 33.93437], [-118.00787, 33.93381], [-118.00782, 33.9337], [-118.00791, 33.93347], [-118.00798, 33.93313], [-118.00801, 33.93308], [-118.00808, 33.93307], [-118.00826, 33.93307], [-118.00832, 33.93305], [-118.00837, 33.93301], [-118.00852, 33.93231], [-118.00903, 33.93231]]]} Restricted Access 2 46577 Hillview Middle School Park 31915 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 8.349 Hillview 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]);