units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where AGNCY_TYP = 14, COUNTY = 6 and DES_TP = 3
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
4949 | 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 | |
6617 | 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 | |
10780 | 10780 | 10779 | {"type": "Polygon", "coordinates": [[[-117.76612, 34.10899], [-117.7652, 34.11126], [-117.76228, 34.1103], [-117.76223, 34.11016], [-117.76212, 34.10995], [-117.76202, 34.1098], [-117.7623, 34.10965], [-117.76255, 34.10947], [-117.76279, 34.10925], [-117.76296, 34.10904], [-117.76318, 34.10868], [-117.7637, 34.10752], [-117.76409, 34.10765], [-117.76407, 34.10773], [-117.76441, 34.10784], [-117.76461, 34.10794], [-117.76462, 34.10793], [-117.76466, 34.10782], [-117.76493, 34.10789], [-117.76612, 34.10899]]]} | Restricted Access 2 | 20550 | La Verne Sports Park | 31619 | 2398 | Bonita Unified School District 956 | Special District 4 | School District 14 | http://do.bonita.k12.ca.us/ | Special District 4 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 22.089 | La Verne Sports Park | 0 | Local Recreation Area 3 | 4 | |
10843 | 10843 | 10842 | {"type": "Polygon", "coordinates": [[[-118.41941, 33.92466], [-118.4187, 33.92467], [-118.4187, 33.92444], [-118.41841, 33.92444], [-118.41841, 33.92366], [-118.41941, 33.92366], [-118.41941, 33.92466]]]} | Restricted Access 2 | 20624 | Richmond Street Field | 31642 | 2378 | El Segundo Unified School District 958 | Special District 4 | School District 14 | http://www.elsegundousd.net/ | Special District 4 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 2.392 | Richmond Street Field | 0 | Local Recreation Area 3 | 4 | |
10863 | 10863 | 10862 | {"type": "Polygon", "coordinates": [[[-118.82414, 34.0228], [-118.82415, 34.02343], [-118.8242, 34.02514], [-118.82383, 34.02594], [-118.82355, 34.02636], [-118.82309, 34.02697], [-118.8214, 34.02658], [-118.82087, 34.0264], [-118.82069, 34.02541], [-118.82061, 34.02514], [-118.82048, 34.02484], [-118.82045, 34.02472], [-118.82044, 34.02459], [-118.82046, 34.02446], [-118.82054, 34.02429], [-118.82093, 34.02387], [-118.82105, 34.02371], [-118.82121, 34.02343], [-118.82192, 34.02391], [-118.82243, 34.02344], [-118.8217, 34.02273], [-118.82181, 34.0226], [-118.82192, 34.0225], [-118.82258, 34.02203], [-118.82271, 34.02189], [-118.82412, 34.02284], [-118.82414, 34.02283], [-118.82414, 34.0228]]]} | Restricted Access 2 | 20661 | Malibu Equestrian Park | 32834 | 2423 | Santa Monica-Malibu Unified School District 960 | Special District 4 | School District 14 | www.smmusd.org | Special District 4 | 1193 | Malibu, City of 928 | City 2 | City Agency 2 | Los Angeles 6 | 32.463 | Malibu Equestrian Park | 0 | Local Recreation Area 3 | 4 | |
11431 | 11431 | 11430 | {"type": "Polygon", "coordinates": [[[-118.34535, 33.89046], [-118.34465, 33.89053], [-118.34471, 33.89095], [-118.34436, 33.89096], [-118.34432, 33.88985], [-118.34484, 33.88984], [-118.34485, 33.88999], [-118.34528, 33.88995], [-118.34535, 33.89046]]]} | Restricted Access 2 | 48114 | Bollinger Gymnasium | 32629 | 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/bollinger.pdf | Los Angeles 6 | 1.856 | Bollinger Gymnasium | 0 | Local Recreation Area 3 | 4 |
11436 | 11436 | 11435 | {"type": "Polygon", "coordinates": [[[-117.97437, 34.13762], [-117.97437, 34.13876], [-117.97364, 34.13876], [-117.97363, 34.13856], [-117.9732, 34.13856], [-117.97319, 34.13882], [-117.97203, 34.13883], [-117.97202, 34.13765], [-117.97437, 34.13762]]]} | Open Access 1 | 48129 | Montgomery Fields | 32649 | 2316 | Duarte Unified School District 978 | Special District 4 | School District 14 | http://www.duarte.k12.ca.us/ | Special District 4 | 1089 | Duarte, City of 325 | City 2 | City Agency 2 | Los Angeles 6 | 6.662 | Montgomery Fields | 0 | Local Recreation Area 3 | 4 | |
13941 | 13941 | 13940 | {"type": "Polygon", "coordinates": [[[-118.08587, 34.09653], [-118.08587, 34.09696], [-118.08546, 34.09696], [-118.08547, 34.09653], [-118.08587, 34.09653]]]} | Restricted Access 2 | 46473 | Roosevelt Elementary Tennis Courts | 29746 | 2393 | San Gabriel Unified School District 706 | Special District 4 | School District 14 | http://www.sgusd.k12.ca.us/ | Special District 4 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | Los Angeles 6 | 0.443 | Roosevelt Elementary Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
15053 | 15053 | 15052 | {"type": "Polygon", "coordinates": [[[-118.25787, 34.06135], [-118.25775, 34.06152], [-118.25763, 34.06147], [-118.2576, 34.06151], [-118.2575, 34.0615], [-118.25741, 34.06151], [-118.25733, 34.06154], [-118.25725, 34.06163], [-118.2563, 34.06121], [-118.25665, 34.06065], [-118.25715, 34.06088], [-118.25714, 34.0609], [-118.25728, 34.06101], [-118.25751, 34.06111], [-118.25748, 34.06117], [-118.25787, 34.06135]]]} | Restricted Access 2 | 45729 | Vista Hermosa Soccer Field | 32839 | 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 | http://www.laparks.org/dos/parks/facility/vistaHermosaPk.htm | Los Angeles 6 | 1.889 | Vista Hermosa Soccer Field | 0 | Local Recreation Area 3 | 4 |
15164 | 15164 | 15163 | {"type": "Polygon", "coordinates": [[[-118.19697, 33.98506], [-118.19692, 33.98539], [-118.196, 33.9853], [-118.19606, 33.98497], [-118.19697, 33.98506]]]} | Restricted Access 2 | 46015 | Freedom Park Athletic Field | 29338 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 1142 | Huntington Park, City of 83 | City 2 | City Agency 2 | Los Angeles 6 | 0.778 | Freedom Park Athletic Field | 0 | Local Recreation Area 3 | 4 | |
15306 | 15306 | 15305 | {"type": "Polygon", "coordinates": [[[-118.10197, 34.08439], [-118.10118, 34.08439], [-118.10117, 34.08387], [-118.10143, 34.08387], [-118.10145, 34.08376], [-118.10172, 34.08376], [-118.1019, 34.08387], [-118.10197, 34.08398], [-118.10197, 34.08439]]]} | Restricted Access 2 | 46475 | McKinley Baseball Field | 29748 | 2393 | San Gabriel Unified School District 706 | Special District 4 | School District 14 | http://www.sgusd.k12.ca.us/ | Special District 4 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | Los Angeles 6 | 1.141 | McKinley Baseball Field | 0 | Local Recreation Area 3 | 4 | |
15330 | 15330 | 15329 | {"type": "Polygon", "coordinates": [[[-118.2036, 34.20436], [-118.2036, 34.20462], [-118.20323, 34.20462], [-118.20323, 34.20436], [-118.2036, 34.20436]]]} | Restricted Access 2 | 46505 | Skate Park | 31585 | 2395 | La Canada Unified School District 1154 | Special District 4 | School District 14 | http://lcusd.net/site/default.aspx?PageID=1 | Special District 4 | 1154 | La Canada Flintridge, City of 330 | City 2 | City Agency 2 | http://www.lcf.ca.gov/parks/skate | Los Angeles 6 | 0.246 | Skate Park | 0 | Local Recreation Area 3 | 4 |
15358 | 15358 | 15357 | {"type": "Polygon", "coordinates": [[[-118.08395, 34.01292], [-118.0835, 34.01349], [-118.08385, 34.01371], [-118.08368, 34.0139], [-118.08365, 34.01392], [-118.08362, 34.01391], [-118.08245, 34.01323], [-118.08312, 34.01244], [-118.08395, 34.01292]]]} | Restricted Access 2 | 46547 | Pio Pico Playground | 31638 | 2369 | El Rancho Unified School District 1156 | Special District 4 | School District 14 | http://www.erusd.org/ | Special District 4 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 2.817 | Pio Pico Playground | 0 | Local Recreation Area 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);