units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where DES_TP = 2 and LABEL_NAME = "Friendship Park"
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, COUNTY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1030 | 1030 | 1029 | {"type": "Polygon", "coordinates": [[[-118.04152, 33.87135], [-118.04149, 33.87145], [-118.04152, 33.87159], [-118.04153, 33.87191], [-118.04149, 33.87195], [-118.04002, 33.87196], [-118.03998, 33.87195], [-118.03997, 33.87192], [-118.04, 33.87181], [-118.03999, 33.87176], [-118.03996, 33.87172], [-118.0399, 33.87171], [-118.03989, 33.87119], [-118.04023, 33.87119], [-118.04045, 33.87115], [-118.04068, 33.87106], [-118.04094, 33.87089], [-118.04112, 33.87082], [-118.04125, 33.8708], [-118.04146, 33.8708], [-118.0415, 33.87082], [-118.04152, 33.87135]]]} | Restricted Access 2 | 5646 | Friendship Park | 19120 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 3.848 | Friendship Park | 0 | Local Park 2 | 4 | |
1031 | 1031 | 1030 | {"type": "Polygon", "coordinates": [[[-117.89901, 33.74171], [-117.89886, 33.74172], [-117.89885, 33.74179], [-117.89876, 33.74179], [-117.89875, 33.74163], [-117.89901, 33.74163], [-117.89901, 33.74171]]]} | Open Access 1 | 5649 | Friendship Park | 19122 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 0.074 | Friendship Park | 0 | Local Park 2 | 4 | |
5325 | 5325 | 5324 | {"type": "Polygon", "coordinates": [[[-117.8802, 34.00888], [-117.88009, 34.00991], [-117.88008, 34.00995], [-117.88003, 34.00997], [-117.87975, 34.00996], [-117.87953, 34.00998], [-117.87929, 34.01004], [-117.87907, 34.01012], [-117.87899, 34.01001], [-117.87871, 34.00984], [-117.87831, 34.00968], [-117.87783, 34.00952], [-117.87805, 34.00904], [-117.87812, 34.00872], [-117.8802, 34.00888]]]} | Open Access 1 | 5647 | Friendship Park | 19124 | 1374 | West Covina, City of 318 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 1374 | West Covina, City of 315 | City 2 | City Agency 2 | Los Angeles 6 | 5.991 | Friendship Park | 0 | Local Park 2 | 4 | |
5566 | 5566 | 5565 | {"type": "Polygon", "coordinates": [[[-122.21003, 37.47408], [-122.20952, 37.47417], [-122.20935, 37.47434], [-122.20898, 37.4741], [-122.20983, 37.47394], [-122.21003, 37.47408]]]} | Open Access 1 | 46891 | Friendship Park | 30388 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 0.407 | Friendship Park | 0 | Local Park 2 | 4 | |
7679 | 7679 | 7678 | {"type": "Polygon", "coordinates": [[[-117.0842, 32.64107], [-117.08447, 32.64177], [-117.08447, 32.64181], [-117.08445, 32.64184], [-117.08276, 32.64232], [-117.08271, 32.64232], [-117.08267, 32.6423], [-117.08239, 32.64157], [-117.0842, 32.64107]]]} | Open Access 1 | 7610 | Friendship Park | 19121 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/friendship-park | San Diego 4 | 3.934 | Friendship Park | 0 | Local Park 2 | 4 |
11139 | 11139 | 11138 | {"type": "Polygon", "coordinates": [[[-121.58265, 39.11602], [-121.58167, 39.1177], [-121.58002, 39.11657], [-121.57852, 39.11789], [-121.57766, 39.11729], [-121.57912, 39.11598], [-121.57827, 39.11537], [-121.57975, 39.11405], [-121.58149, 39.11528], [-121.58265, 39.11602]]]} | Open Access 1 | 21433 | Friendship Park | 19119 | 333 | Yuba, County of 551 | County 3 | County Agency 3 | http://www.co.yuba.ca.us/departments/community%20development/public%20works/parks/default.aspx | County 3 | 333 | Yuba, County of 544 | County 3 | County Agency 3 | Yuba 25 | 22.272 | Friendship Park | 0 | Local Park 2 | 4 | |
11288 | 11288 | 11287 | {"type": "Polygon", "coordinates": [[[-118.09039, 33.9493], [-118.09045, 33.94931], [-118.0905, 33.94934], [-118.09052, 33.94937], [-118.09053, 33.94942], [-118.0903, 33.94984], [-118.0901, 33.94975], [-118.09031, 33.94939], [-118.09032, 33.94934], [-118.09039, 33.9493]]]} | Open Access 1 | 48045 | Friendship Park | 32538 | 1321 | Santa Fe Springs, City of 211 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/default.asp | City 2 | 1321 | Santa Fe Springs, City of 207 | City 2 | City Agency 2 | Los Angeles 6 | 0.277 | Friendship Park | 0 | Local Park 2 | 4 | |
14241 | 14241 | 14240 | {"type": "Polygon", "coordinates": [[[-117.90149, 33.74169], [-117.90036, 33.7417], [-117.90037, 33.74], [-117.90142, 33.73999], [-117.90142, 33.7407], [-117.90149, 33.74074], [-117.90149, 33.74169]]]} | Restricted Access 2 | 44131 | Friendship Park | 19123 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 4.747 | Friendship Park | 0 | Local Park 2 | 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]);