superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17 rows where MNG_AGENCY = 743
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5296 | 5296 | 5295 | {"type": "MultiPolygon", "coordinates": [[[[-117.74601, 33.59723], [-117.74593, 33.59737], [-117.74582, 33.5975], [-117.74562, 33.59773], [-117.74558, 33.59772], [-117.74544, 33.598], [-117.74534, 33.59805], [-117.74504, 33.59797], [-117.74493, 33.59791], [-117.74488, 33.59775], [-117.74489, 33.5977], [-117.74495, 33.59761], [-117.74496, 33.59754], [-117.74475, 33.59747], [-117.74435, 33.59725], [-117.74418, 33.59724], [-117.74399, 33.59726], [-117.74396, 33.59721], [-117.74398, 33.59712], [-117.74396, 33.59703], [-117.7438, 33.59691], [-117.74378, 33.59685], [-117.74383, 33.59669], [-117.74446, 33.59687], [-117.74601, 33.59723]]], [[[-117.74709, 33.59749], [-117.74705, 33.59764], [-117.74687, 33.59768], [-117.7468, 33.59776], [-117.74678, 33.59786], [-117.7467, 33.59788], [-117.74663, 33.59799], [-117.7465, 33.59798], [-117.74646, 33.598], [-117.7464, 33.59814], [-117.74662, 33.59827], [-117.74664, 33.59832], [-117.74597, 33.59815], [-117.7459, 33.59823], [-117.74563, 33.59814], [-117.74561, 33.59806], [-117.74578, 33.59778], [-117.74602, 33.59749], [-117.74616, 33.59726], [-117.74709, 33.59749]]]]} | Open Access 1 | Hummingbird Park | 20148 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 5.299 | Hummingbird Park | ||
5327 | 5327 | 5326 | {"type": "Polygon", "coordinates": [[[-117.7243, 33.60518], [-117.72308, 33.60646], [-117.72304, 33.60603], [-117.72271, 33.60572], [-117.72281, 33.6057], [-117.72286, 33.60567], [-117.72288, 33.60562], [-117.72287, 33.60549], [-117.7229, 33.60538], [-117.72292, 33.60518], [-117.72292, 33.60451], [-117.72289, 33.60414], [-117.72285, 33.60402], [-117.72277, 33.60388], [-117.72262, 33.60374], [-117.72301, 33.60353], [-117.72322, 33.60358], [-117.72386, 33.60401], [-117.7243, 33.60518]]]} | Open Access 1 | Iglesia Park | 20174 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 6.797 | Iglesia Park | ||
7345 | 7345 | 7344 | {"type": "Polygon", "coordinates": [[[-117.73254, 33.59302], [-117.73253, 33.59307], [-117.73166, 33.59479], [-117.73144, 33.59562], [-117.73133, 33.59566], [-117.73088, 33.59553], [-117.73023, 33.59525], [-117.72966, 33.59488], [-117.72903, 33.59433], [-117.72888, 33.59414], [-117.72891, 33.59404], [-117.72909, 33.59393], [-117.72931, 33.59375], [-117.72981, 33.59331], [-117.73016, 33.59294], [-117.73055, 33.59246], [-117.73066, 33.59232], [-117.7308, 33.59208], [-117.73132, 33.59105], [-117.73173, 33.59121], [-117.73157, 33.59153], [-117.73144, 33.59197], [-117.73141, 33.59256], [-117.73145, 33.5926], [-117.73154, 33.59264], [-117.73178, 33.59269], [-117.73191, 33.59274], [-117.73212, 33.59284], [-117.73242, 33.59294], [-117.73253, 33.593], [-117.73254, 33.59302]]]} | Open Access 1 | Ridgecrest Park | 24352 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 19.318 | Ridgecrest Park | ||
7577 | 7577 | 7576 | {"type": "Polygon", "coordinates": [[[-117.73406, 33.56494], [-117.73385, 33.56509], [-117.73401, 33.56555], [-117.73298, 33.56582], [-117.73269, 33.56569], [-117.73282, 33.56524], [-117.73297, 33.56489], [-117.73314, 33.56456], [-117.73328, 33.56434], [-117.7335, 33.56441], [-117.73363, 33.56437], [-117.73371, 33.56446], [-117.73388, 33.5646], [-117.73392, 33.56466], [-117.734, 33.56481], [-117.73406, 33.56494]]]} | Open Access 1 | Oak Park | 22994 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 3.358 | Oak Park | ||
8156 | 8156 | 8155 | {"type": "Polygon", "coordinates": [[[-117.72317, 33.59407], [-117.72307, 33.59405], [-117.72296, 33.59413], [-117.72285, 33.59415], [-117.72227, 33.59407], [-117.72213, 33.59398], [-117.72206, 33.59383], [-117.72188, 33.59358], [-117.72157, 33.5933], [-117.72132, 33.5931], [-117.72099, 33.59278], [-117.7209, 33.59267], [-117.72104, 33.59261], [-117.72221, 33.5925], [-117.72227, 33.5925], [-117.72251, 33.59261], [-117.72256, 33.59265], [-117.72258, 33.59271], [-117.72287, 33.5927], [-117.7229, 33.59277], [-117.7232, 33.59315], [-117.72327, 33.59333], [-117.72328, 33.5934], [-117.72317, 33.59407]]]} | Open Access 1 | Pinewood Park | 23691 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 6.019 | Pinewood Park | ||
9562 | 9562 | 9561 | {"type": "Polygon", "coordinates": [[[-117.71148, 33.59001], [-117.71141, 33.59017], [-117.71124, 33.59039], [-117.71134, 33.59069], [-117.71128, 33.59153], [-117.71122, 33.59173], [-117.71111, 33.59185], [-117.711, 33.59195], [-117.71088, 33.59199], [-117.7105, 33.59209], [-117.71032, 33.59216], [-117.71025, 33.59217], [-117.71024, 33.59205], [-117.7101, 33.59199], [-117.70998, 33.59151], [-117.70998, 33.5914], [-117.71002, 33.59126], [-117.70998, 33.59122], [-117.70997, 33.59117], [-117.71009, 33.5904], [-117.71008, 33.59032], [-117.71005, 33.5903], [-117.70997, 33.59029], [-117.70924, 33.59029], [-117.70891, 33.59022], [-117.70863, 33.59019], [-117.70855, 33.59021], [-117.7085, 33.59026], [-117.70847, 33.58995], [-117.70848, 33.58968], [-117.7085, 33.58957], [-117.71147, 33.58958], [-117.71143, 33.58965], [-117.71148, 33.59001]]]} | Open Access 1 | Sheep Hills Park | 25379 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 10.763 | Sheep Hills Park | ||
10945 | 10945 | 10944 | {"type": "Polygon", "coordinates": [[[-117.7258, 33.60011], [-117.72572, 33.60011], [-117.72564, 33.60004], [-117.72557, 33.60001], [-117.72545, 33.60001], [-117.72537, 33.60003], [-117.72526, 33.6002], [-117.72524, 33.60039], [-117.7252, 33.60042], [-117.72497, 33.6005], [-117.72469, 33.60032], [-117.72468, 33.59997], [-117.72493, 33.59999], [-117.72564, 33.59994], [-117.72561, 33.59959], [-117.72576, 33.59958], [-117.7258, 33.60011]]]} | Open Access 1 | Vista Park | 27180 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 0.945 | Vista Park | ||
11148 | 11148 | 11147 | {"type": "Polygon", "coordinates": [[[-117.74076, 33.56857], [-117.74063, 33.5689], [-117.74063, 33.56903], [-117.74055, 33.56913], [-117.73942, 33.56911], [-117.73923, 33.5692], [-117.73914, 33.56939], [-117.73911, 33.56965], [-117.73909, 33.56964], [-117.73907, 33.56957], [-117.73913, 33.56935], [-117.73916, 33.56905], [-117.73916, 33.56877], [-117.73911, 33.5684], [-117.74006, 33.56854], [-117.74021, 33.56848], [-117.7403, 33.56852], [-117.74041, 33.5685], [-117.74047, 33.56855], [-117.74076, 33.56857]]]} | Open Access 1 | Westridge Park | 27419 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 2.51 | Westridge Park | ||
11336 | 11336 | 11335 | {"type": "Polygon", "coordinates": [[[-117.73863, 33.59499], [-117.73856, 33.59525], [-117.73854, 33.59582], [-117.7385, 33.59602], [-117.73844, 33.59615], [-117.73835, 33.59619], [-117.73717, 33.59574], [-117.73655, 33.59547], [-117.73602, 33.59528], [-117.73594, 33.59512], [-117.73585, 33.59503], [-117.73569, 33.59497], [-117.7355, 33.59494], [-117.73544, 33.59491], [-117.73539, 33.59485], [-117.7353, 33.59489], [-117.73527, 33.59487], [-117.73519, 33.59487], [-117.73512, 33.59484], [-117.73493, 33.59466], [-117.73472, 33.59454], [-117.73445, 33.59465], [-117.73232, 33.59391], [-117.73286, 33.59273], [-117.73292, 33.5927], [-117.73294, 33.59273], [-117.73288, 33.59294], [-117.73378, 33.5934], [-117.73576, 33.59412], [-117.73847, 33.59517], [-117.7386, 33.59497], [-117.73863, 33.59499]]]} | Open Access 1 | Wingspan Park | 27646 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 15.644 | Wingspan Park | ||
11375 | 11375 | 11374 | {"type": "Polygon", "coordinates": [[[-117.71947, 33.57202], [-117.71929, 33.57218], [-117.71912, 33.57243], [-117.71892, 33.57265], [-117.71881, 33.57274], [-117.7186, 33.57282], [-117.71848, 33.57289], [-117.71839, 33.57297], [-117.7183, 33.57312], [-117.71826, 33.57328], [-117.71828, 33.57356], [-117.7181, 33.57468], [-117.71795, 33.57538], [-117.71784, 33.57561], [-117.71784, 33.57569], [-117.71787, 33.57583], [-117.71789, 33.57604], [-117.71785, 33.57627], [-117.71775, 33.5765], [-117.71771, 33.57652], [-117.71759, 33.57667], [-117.71752, 33.57673], [-117.71724, 33.57692], [-117.71715, 33.577], [-117.71704, 33.57714], [-117.71697, 33.57726], [-117.71697, 33.5773], [-117.71667, 33.57712], [-117.71656, 33.57662], [-117.71631, 33.57663], [-117.71612, 33.5766], [-117.71538, 33.5763], [-117.7152, 33.57629], [-117.71472, 33.57611], [-117.71401, 33.57589], [-117.71412, 33.57566], [-117.7159, 33.57518], [-117.71691, 33.57389], [-117.71698, 33.57277], [-117.71738, 33.57249], [-117.71749, 33.57228], [-117.71812, 33.57229], [-117.7184, 33.57227], [-117.71877, 33.57222], [-117.71884, 33.57222], [-117.71883, 33.57232], [-117.71868, 33.57247], [-117.71855, 33.57254], [-117.71831, 33.57263], [-117.71808, 33.57275], [-117.7179, 33.57289], [-117.71782, 33.57301], [-117.71776, 33.57314], [-117.71774, 33.57322], [-117.7177, 33.57329], [-117.71759, 33.57338], [-117.71758, 33.57346], [-117.7176, 33.57352], [-117.71766, 33.57356], [-117.71774, 33.57357], [-117.7178, 33.57355], [-117.71787, 33.57348], [-117.7179, 33.57324], [-117.71803, 33.57298], [-117.71813, 33.57287], [-117.71831, 33.57276], [-117.71852, 33.57268], [-117.71869, 33.57259], [-117.71887, 33.57243], [-117.71905, 33.57218], [-117.71919, 33.57212], [-117.71947, 33.57202]]]} | Open Access 1 | Woodfield Park | 27707 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 22.934 | Woodfield Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);