units_with_maps

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

38 rows where MNG_AG_TYP = 21

View and edit SQL

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY, YR_EST

MNG_AG_TYP

  • School District · 38

ACCESS_TYP

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
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
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 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
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
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
4949 4948 {"type": "Polygon", "coordinates": [[[-118.41083, 34.01373], [-118.40949, 34.01447], [-118.4092, 34.01411], [-118.4095, 34.01394], [-118.40926, 34.01364], [-118.40988, 34.01309], [-118.4101, 34.0127], [-118.41032, 34.01298], [-118.41025, 34.01312], [-118.41049, 34.01342], [-118.41056, 34.01339], [-118.41083, 34.01373]]]} Restricted Access 2 3031 La Ballona Playground 29387 2367 Culver City Unified School District 789 Special District 4 School District 14 http://www.ccusd.org/ Special District 4 2367 Culver City Unified School District 768 Special District 4 School District 21   Los Angeles 6 3.369 La Ballona Playground 0 Local Recreation Area 3 4
6509 6508 {"type": "Polygon", "coordinates": [[[-118.8506, 34.24115], [-118.85027, 34.24136], [-118.84991, 34.24147], [-118.84796, 34.24131], [-118.84799, 34.24055], [-118.84755, 34.24005], [-118.84838, 34.23945], [-118.84862, 34.23965], [-118.84898, 34.23985], [-118.84953, 34.2401], [-118.84993, 34.24033], [-118.85027, 34.24067], [-118.8506, 34.24115]]]} Restricted Access 2 2495 Canada Park 31606 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 9.09 Canada Park 0 Local Park 2 4
6617 6616 {"type": "Polygon", "coordinates": [[[-118.39361, 34.0222], [-118.39299, 34.02292], [-118.39286, 34.02283], [-118.39221, 34.02248], [-118.39279, 34.02174], [-118.39361, 34.0222]]]} Restricted Access 2 4230 Linwood E. Howe Playground 29386 2367 Culver City Unified School District 789 Special District 4 School District 14 http://www.ccusd.org/ Special District 4 2367 Culver City Unified School District 768 Special District 4 School District 21   Los Angeles 6 2.149 Linwood E. Howe Playground 0 Local Recreation Area 3 4
7453 7452 {"type": "Polygon", "coordinates": [[[-121.96985, 37.35893], [-121.96981, 37.35894], [-121.96977, 37.359], [-121.96974, 37.359], [-121.96972, 37.35903], [-121.96973, 37.35906], [-121.96901, 37.3589], [-121.96895, 37.35886], [-121.96892, 37.3588], [-121.96887, 37.35846], [-121.96961, 37.35847], [-121.96975, 37.3589], [-121.96985, 37.35888], [-121.96985, 37.35893]]]} Restricted Access 2 48942 Santa Clara Skate Park 33658 2440 Santa Clara Unified School District 865 Special District 4 School District 14 https://www.santaclarausd.org/ Special District 4 2440 Santa Clara Unified School District 843 Special District 4 School District 21 https://www.santaclaraca.gov/our-city/departments-g-z/parks-recreation/community-centers/skate-park Santa Clara 19 0.964 Santa Clara Skate Park 0 Local Recreation Area 3 4
9694 9693 {"type": "Polygon", "coordinates": [[[-117.9018, 34.13808], [-117.9011, 34.13804], [-117.90114, 34.13892], [-117.89971, 34.13891], [-117.89972, 34.13725], [-117.90091, 34.13731], [-117.90091, 34.13764], [-117.90178, 34.13764], [-117.9018, 34.13808]]]} Restricted Access 2 47859 Dalton Elementary School Park 31943 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 6.301 Dalton Elementary School Park 0 Local Park 2 4
9696 9695 {"type": "Polygon", "coordinates": [[[-117.99846, 33.91409], [-117.99722, 33.91503], [-117.99693, 33.91519], [-117.99664, 33.9153], [-117.99651, 33.91534], [-117.99616, 33.91537], [-117.99445, 33.91539], [-117.99442, 33.91319], [-117.99449, 33.91314], [-117.9955, 33.91313], [-117.99551, 33.91328], [-117.99564, 33.91327], [-117.99564, 33.91353], [-117.99557, 33.91354], [-117.99556, 33.91381], [-117.99565, 33.91381], [-117.99567, 33.91413], [-117.99623, 33.91412], [-117.99624, 33.91418], [-117.99629, 33.91419], [-117.99636, 33.91434], [-117.99676, 33.91415], [-117.99666, 33.91396], [-117.99716, 33.91371], [-117.99727, 33.91386], [-117.99741, 33.91379], [-117.99741, 33.91373], [-117.99758, 33.91367], [-117.99742, 33.91337], [-117.99773, 33.91325], [-117.9983, 33.91344], [-117.99833, 33.91366], [-117.99846, 33.91409]]]} Restricted Access 2 47861 Benton Middle School Park 31848 2417 Norwalk La Mirada Unified School District 919 Special District 4 School District 14 https://www.nlmusd.org/ Special District 4 2417 Norwalk La Mirada Unified School District 892 Special District 4 School District 21   Los Angeles 6 15.056 Benton Middle School Park 0 Local Park 2 4
9697 9696 {"type": "Polygon", "coordinates": [[[-118.06854, 33.96506], [-118.06786, 33.96522], [-118.06772, 33.96583], [-118.06704, 33.96582], [-118.06704, 33.96591], [-118.06669, 33.96591], [-118.06667, 33.9658], [-118.06616, 33.96578], [-118.06653, 33.96476], [-118.06654, 33.96478], [-118.06732, 33.9648], [-118.06733, 33.96478], [-118.06851, 33.96481], [-118.06854, 33.96506]]]} Restricted Access 2 47862 Aeolian Elementary School Park 31844 2376 Los Nietos School District 920 Special District 4 School District 14 http://www.losnietos.k12.ca.us/ Special District 4 2376 Los Nietos School District 893 Special District 4 School District 21   Los Angeles 6 4.508 Aeolian Elementary School Park 0 Local Park 2 4
9724 9723 {"type": "Polygon", "coordinates": [[[-118.0761, 33.96475], [-118.0759, 33.96532], [-118.07581, 33.96536], [-118.07425, 33.965], [-118.07349, 33.96488], [-118.07357, 33.96454], [-118.07358, 33.96438], [-118.07335, 33.96435], [-118.07294, 33.96434], [-118.07307, 33.96347], [-118.07313, 33.96345], [-118.07381, 33.96344], [-118.07369, 33.96395], [-118.07429, 33.96406], [-118.07422, 33.96432], [-118.0761, 33.96475]]]} Restricted Access 2 47865 Los Nietos Middle School Park 31945 2376 Los Nietos School District 920 Special District 4 School District 14 http://www.losnietos.k12.ca.us/ Special District 4 2376 Los Nietos School District 893 Special District 4 School District 21   Los Angeles 6 6.183 Los Nietos Middle School Park 0 Local Park 2 4
9725 9724 {"type": "Polygon", "coordinates": [[[-118.08198, 33.96714], [-118.08197, 33.96719], [-118.08066, 33.96992], [-118.07833, 33.96921], [-118.07945, 33.96657], [-118.07953, 33.96655], [-118.08192, 33.9671], [-118.08198, 33.96714]]]} Restricted Access 2 47866 Pioneer High School Park 31946 2372 Whittier Union High School District 922 Special District 4 School District 14 http://www.wuhsd.org/site/default.aspx?PageID=1 Special District 4 2372 Whittier Union High School District 895 Special District 4 School District 21   Los Angeles 6 18.908 Pioneer High School Park 0 Local Park 2 4
9726 9725 {"type": "Polygon", "coordinates": [[[-118.06976, 33.98789], [-118.06914, 33.98854], [-118.0683, 33.98797], [-118.06847, 33.9878], [-118.06824, 33.98766], [-118.06837, 33.98758], [-118.06832, 33.98754], [-118.06857, 33.98727], [-118.0682, 33.987], [-118.06838, 33.98685], [-118.06963, 33.98778], [-118.06963, 33.98779], [-118.06976, 33.98789]]]} Restricted Access 2 47867 West Whittier Elementary School Park 31947 2371 Whittier City School District 923 Special District 4 School District 14 http://www.whittiercity.k12.ca.us/ Special District 4 2371 Whittier City School District 896 Special District 4 School District 21   Los Angeles 6 3.134 West Whittier Elementary School Park 0 Local Park 2 4
10090 10089 {"type": "Polygon", "coordinates": [[[-118.90342, 34.17262], [-118.90341, 34.17546], [-118.90314, 34.17546], [-118.90206, 34.17546], [-118.90183, 34.17536], [-118.9019, 34.17521], [-118.90196, 34.17494], [-118.90194, 34.17465], [-118.90184, 34.17437], [-118.90164, 34.17411], [-118.90148, 34.17392], [-118.9014, 34.17386], [-118.90122, 34.17383], [-118.90108, 34.17387], [-118.89985, 34.17261], [-118.90342, 34.17262]]]} Restricted Access 2 17496 Lynn Oaks Park 31623 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 15.699 Lynn Oaks Park 0 Local Park 2 4
11438 11437 {"type": "Polygon", "coordinates": [[[-118.37889, 33.82954], [-118.37835, 33.83153], [-118.37833, 33.83156], [-118.37828, 33.83159], [-118.37822, 33.83158], [-118.37818, 33.83156], [-118.37777, 33.83105], [-118.3774, 33.83067], [-118.37715, 33.83045], [-118.37657, 33.83], [-118.37654, 33.82995], [-118.37669, 33.82938], [-118.37889, 33.82954]]]} Restricted Access 2 48132 Alta Vista Park 32655 2379 Redondo Beach Unified School District 979 Special District 4 School District 14 http://www.rbusd.org/ Special District 4 2379 Redondo Beach Unified School District 942 Special District 4 School District 21   Los Angeles 6 7.426 Alta Vista Park 0 Local Park 2 4
11457 11456 {"type": "Polygon", "coordinates": [[[-118.11356, 34.10969], [-118.11221, 34.1097], [-118.11219, 34.10843], [-118.11354, 34.10842], [-118.11356, 34.10969]]]} Restricted Access 2 48149 Coolidge School Park 32679 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 4.336 Coolidge School Park 0 Local Park 2 4
11517 11516 {"type": "Polygon", "coordinates": [[[-117.24714, 33.20982], [-117.24712, 33.21018], [-117.2451, 33.21017], [-117.2451, 33.20897], [-117.24589, 33.20902], [-117.24596, 33.20884], [-117.24679, 33.20904], [-117.24684, 33.20979], [-117.24714, 33.20982]]]} Restricted Access 2 48224 Linda Rhoades Recreation Center 32840 3385 Educational Enrichment Systems Incorporated 983 Non Profit 6 Non Profit - Other 22 http://www.educ-enrichment.org/ Non Governmental Organization 10 2426 Vista Unified School District 946 Special District 4 School District 21   San Diego 4 5.644 Linda Rhoades Rec. Ctr. 0 Local Recreation Area 3 4
11531 11530 {"type": "Polygon", "coordinates": [[[-118.20153, 34.11625], [-118.20128, 34.11709], [-118.19974, 34.11679], [-118.19924, 34.11679], [-118.19923, 34.11581], [-118.20153, 34.11625]]]} Restricted Access 2 46865 Franklin Senior High School Park 31934 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.912 Franklin Senior 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]);
Powered by Datasette · Query took 139.523ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette