units_with_maps

Table actions

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

117 rows where ACCESS_TYP = 2, AGNCY_TYP = 14 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_URL

MNG_AG_TYP 1

  • City Agency · 117 ✖

ACCESS_TYP 1

  • Restricted Access · 117 ✖
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
2099 2099 2098 {"type": "Polygon", "coordinates": [[[-121.94503, 37.73765], [-121.94369, 37.73818], [-121.94322, 37.73744], [-121.94227, 37.7378], [-121.94234, 37.73798], [-121.94192, 37.73811], [-121.94168, 37.73772], [-121.94145, 37.73739], [-121.94426, 37.7363], [-121.9444, 37.73653], [-121.94433, 37.7366], [-121.94433, 37.73668], [-121.94438, 37.73674], [-121.94449, 37.73676], [-121.94503, 37.73765]]]} Restricted Access 2 47569 Pine Valley Middle School Parks and Community Gym 31294 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 8.075 Pine Valley Middle School Parks and Community Gym 0 Local Recreation Area 3 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
2890 2890 2889 {"type": "Polygon", "coordinates": [[[-121.39678, 36.84126], [-121.39678, 36.84159], [-121.39616, 36.84157], [-121.39614, 36.84183], [-121.39515, 36.8418], [-121.39507, 36.842], [-121.39507, 36.84215], [-121.39527, 36.84217], [-121.39527, 36.84247], [-121.39543, 36.84248], [-121.39542, 36.84336], [-121.39404, 36.84334], [-121.39252, 36.84106], [-121.39624, 36.84113], [-121.39633, 36.8412], [-121.39644, 36.84126], [-121.39678, 36.84126]]]} Restricted Access 2 18924 Rancho San Justo Sports Complex 32730 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 13.179 Rancho San Justo Sports Complex 0 Local Recreation Area 3 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
4165 4165 4164 {"type": "Polygon", "coordinates": [[[-121.94848, 37.74904], [-121.94621, 37.74996], [-121.94536, 37.74865], [-121.94551, 37.7483], [-121.94569, 37.74815], [-121.94589, 37.7481], [-121.94621, 37.74811], [-121.94644, 37.7482], [-121.9468, 37.74876], [-121.94796, 37.74823], [-121.94848, 37.74904]]]} Restricted Access 2 47573 California High School Tennis Courts and Track 31298 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 7.772 California High School Tennis Courts and Track   None 360  
4166 4166 4165 {"type": "Polygon", "coordinates": [[[-121.07771, 39.22081], [-121.07676, 39.22153], [-121.07673, 39.22149], [-121.07655, 39.22152], [-121.07648, 39.22148], [-121.07549, 39.22233], [-121.07527, 39.22221], [-121.07499, 39.22212], [-121.07443, 39.22199], [-121.07444, 39.22102], [-121.07552, 39.22103], [-121.07557, 39.22092], [-121.07556, 39.22075], [-121.07569, 39.22072], [-121.07668, 39.22003], [-121.07771, 39.22081]]]} Restricted Access 2 48291 Margaret G Scotten School Ballfields 32866 2429 Grass Valley School District 728 Special District 4 School District 14 www.gvsd.us Special District 4 1673 Grass Valley, City of 712 City 2 City Agency 2   Nevada 30 8.566 Margaret G Scotten School Ballfields 2018 None 361  
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
4411 4411 4410 {"type": "Polygon", "coordinates": [[[-118.35352, 34.18058], [-118.3535, 34.18106], [-118.35346, 34.18107], [-118.35306, 34.18107], [-118.35307, 34.18057], [-118.35352, 34.18058]]]} Restricted Access 2 46266 Maple Street Playground 31626 2391 Burbank Unified School District 759 Special District 4 School District 14 http://www.burbankusd.org/ Special District 4 1038 Burbank, City of 135 City 2 City Agency 2 http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/maple-street-playground Los Angeles 6 0.55 Maple Street Playground 0 Local Recreation Area 3 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]);