units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where AGNCY_ID = 1075, DES_TP = 2 and MNG_AGENCY = 18
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 15
MNG_AGENCY 1
- Culver City, City of · 15 ✖
DES_TP 1
- Local Park · 15 ✖
ACCESS_TYP 1
- Open Access 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27 | 27 | 26 | {"type": "Polygon", "coordinates": [[[-118.40012, 33.99275], [-118.39867, 33.9928], [-118.39865, 33.99222], [-118.39914, 33.99221], [-118.39922, 33.99218], [-118.39931, 33.99211], [-118.40012, 33.99275]]]} | Open Access 1 | 78 | El Marino Park | 18512 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 1.645 | El Marino Park | 0 | Local Park 2 | 4 | |
231 | 231 | 230 | {"type": "Polygon", "coordinates": [[[-118.3823, 33.98709], [-118.38228, 33.98732], [-118.38226, 33.98736], [-118.38222, 33.98737], [-118.38191, 33.98738], [-118.3823, 33.98709]]]} | Open Access 1 | 625 | Fox Hills Parkette | 19032 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 0.13 | Fox Hills Parkette | 0 | Local Park 2 | 4 | |
622 | 622 | 621 | {"type": "Polygon", "coordinates": [[[-118.39394, 34.02602], [-118.39269, 34.02673], [-118.39263, 34.02675], [-118.39255, 34.02674], [-118.39248, 34.02667], [-118.39247, 34.02664], [-118.39249, 34.02659], [-118.39268, 34.02633], [-118.39279, 34.02626], [-118.39295, 34.0262], [-118.39349, 34.02548], [-118.39357, 34.02549], [-118.39394, 34.02602]]]} | Open Access 1 | 2357 | Ivy Substation and Media Park | 20288 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 1.705 | Ivy Substation and Media Park | 0 | Local Park 2 | 4 | |
793 | 793 | 792 | {"type": "Polygon", "coordinates": [[[-118.43173, 33.99148], [-118.43157, 33.99155], [-118.43154, 33.99132], [-118.43173, 33.99148], [-118.43173, 33.99148]]]} | Open Access 1 | 5165 | Maxella Parkette | 21967 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 0.051 | Maxella Parkette | 0 | Local Park 2 | 4 | |
830 | 830 | 829 | {"type": "Polygon", "coordinates": [[[-118.39299, 33.99651], [-118.39213, 33.99654], [-118.3921, 33.99525], [-118.39251, 33.99525], [-118.39294, 33.99528], [-118.39299, 33.99651]]]} | Open Access 1 | 5384 | Blanco Park | 16157 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 2.753 | Blanco Park | 0 | Local Park 2 | 4 | |
1020 | 1020 | 1019 | {"type": "Polygon", "coordinates": [[[-118.37895, 34.01528], [-118.37887, 34.01538], [-118.37881, 34.01547], [-118.37878, 34.01557], [-118.37872, 34.01567], [-118.37858, 34.01578], [-118.37843, 34.01583], [-118.3783, 34.0159], [-118.37822, 34.01601], [-118.37817, 34.01616], [-118.37811, 34.01614], [-118.37807, 34.01619], [-118.37802, 34.0162], [-118.37782, 34.01617], [-118.3778, 34.01615], [-118.37779, 34.0156], [-118.37775, 34.01551], [-118.37764, 34.01538], [-118.37761, 34.0153], [-118.37895, 34.01528]]]} | Open Access 1 | 6305 | Blair Hills Park | 16149 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 1.799 | Blair Hills Park | 0 | Local Park 2 | 4 | |
4859 | 4859 | 4858 | {"type": "Polygon", "coordinates": [[[-118.41301, 34.01032], [-118.4126, 34.01055], [-118.41233, 34.01022], [-118.41191, 34.01044], [-118.41172, 34.01021], [-118.41173, 34.01017], [-118.41184, 34.01011], [-118.41255, 34.00972], [-118.41301, 34.01032]]]} | Open Access 1 | 14689 | Tellefson Park | 26225 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 1.311 | Tellefson Park | 0 | Local Park 2 | 4 | |
5978 | 5978 | 5977 | {"type": "Polygon", "coordinates": [[[-118.3875, 33.98305], [-118.3873, 33.98371], [-118.38674, 33.98418], [-118.38415, 33.98435], [-118.38415, 33.98429], [-118.38422, 33.98402], [-118.38431, 33.98384], [-118.38452, 33.9836], [-118.38478, 33.98341], [-118.38535, 33.98313], [-118.38565, 33.98293], [-118.38592, 33.98269], [-118.38623, 33.98231], [-118.38628, 33.98228], [-118.38634, 33.98228], [-118.38654, 33.98238], [-118.38721, 33.98288], [-118.3875, 33.98305]]]} | Open Access 1 | 617 | Fox Hills Park | 19031 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 9.991 | Fox Hills Park | 0 | Local Park 2 | 4 | |
6616 | 6616 | 6615 | {"type": "Polygon", "coordinates": [[[-118.39936, 34.00155], [-118.39907, 34.00194], [-118.39892, 34.00221], [-118.39872, 34.00263], [-118.39862, 34.00292], [-118.39849, 34.00343], [-118.39842, 34.0041], [-118.39844, 34.00449], [-118.3984, 34.0045], [-118.3977, 34.00376], [-118.39769, 34.00367], [-118.39884, 34.00135], [-118.39888, 34.00134], [-118.39917, 34.00145], [-118.39934, 34.00152], [-118.39936, 34.00155]]]} | Open Access 1 | 4206 | Lindberg Park | 21286 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 4.159 | Lindberg Park | 0 | Local Park 2 | 4 | |
6925 | 6925 | 6924 | {"type": "Polygon", "coordinates": [[[-118.40385, 34.01188], [-118.40381, 34.01194], [-118.40348, 34.01233], [-118.40257, 34.01348], [-118.4025, 34.01355], [-118.40247, 34.01355], [-118.40106, 34.0121], [-118.40102, 34.01202], [-118.40208, 34.01063], [-118.40218, 34.01051], [-118.40221, 34.0105], [-118.40366, 34.01169], [-118.40385, 34.01185], [-118.40385, 34.01188]]]} | Open Access 1 | 5819 | Veterans Park | 27041 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 11.254 | Veterans Park | 0 | Local Park 2 | 4 | |
7166 | 7166 | 7165 | {"type": "Polygon", "coordinates": [[[-118.38826, 34.01488], [-118.38815, 34.01579], [-118.38811, 34.01601], [-118.38802, 34.01632], [-118.38796, 34.01647], [-118.38786, 34.01666], [-118.38759, 34.01712], [-118.38731, 34.01696], [-118.38718, 34.01718], [-118.38695, 34.01749], [-118.38661, 34.01788], [-118.38688, 34.01805], [-118.38682, 34.01812], [-118.38294, 34.01592], [-118.38515, 34.0127], [-118.38826, 34.01488]], [[-118.38706, 34.01508], [-118.3866, 34.01486], [-118.38633, 34.01498], [-118.3865, 34.01562], [-118.38669, 34.01559], [-118.38678, 34.01594], [-118.38698, 34.0159], [-118.38706, 34.01508]]]} | Open Access 1 | 6303 | Culver City Park | 17852 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 38.609 | Culver City Park | 0 | Local Park 2 | 4 | |
8778 | 8778 | 8777 | {"type": "Polygon", "coordinates": [[[-118.39856, 34.01384], [-118.39855, 34.01393], [-118.39851, 34.01407], [-118.39844, 34.01424], [-118.3983, 34.01446], [-118.39826, 34.01449], [-118.39823, 34.01449], [-118.39819, 34.01447], [-118.39721, 34.01345], [-118.3972, 34.01341], [-118.39722, 34.01338], [-118.39772, 34.01304], [-118.39778, 34.01304], [-118.39781, 34.01305], [-118.39856, 34.01384]]]} | Open Access 1 | 14280 | Carlson Park | 16862 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 2.467 | Carlson Park | 0 | Local Park 2 | 4 | |
8915 | 8915 | 8914 | {"type": "Polygon", "coordinates": [[[-118.37871, 34.02733], [-118.37829, 34.02744], [-118.37825, 34.02772], [-118.37843, 34.02766], [-118.37852, 34.0279], [-118.37814, 34.028], [-118.37811, 34.02797], [-118.37806, 34.02795], [-118.37798, 34.02796], [-118.3779, 34.028], [-118.37788, 34.02806], [-118.3779, 34.02811], [-118.37806, 34.02824], [-118.37808, 34.02827], [-118.37732, 34.02848], [-118.37731, 34.02844], [-118.37736, 34.02832], [-118.37736, 34.02829], [-118.37728, 34.02819], [-118.37721, 34.02819], [-118.37711, 34.02824], [-118.37709, 34.02828], [-118.37716, 34.02852], [-118.37678, 34.02862], [-118.37673, 34.0285], [-118.37636, 34.0286], [-118.37622, 34.0286], [-118.37683, 34.0271], [-118.377, 34.02698], [-118.37836, 34.02711], [-118.37836, 34.02715], [-118.37866, 34.02717], [-118.37871, 34.02733]]]} | Open Access 1 | 14626 | Syd Kronenthal Park | 26145 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 6.113 | Syd Kronenthal Park | 0 | Local Park 2 | 4 | |
10292 | 10292 | 10291 | {"type": "Polygon", "coordinates": [[[-118.4003, 34.00867], [-118.40016, 34.00886], [-118.40012, 34.00886], [-118.39968, 34.0085], [-118.39968, 34.00847], [-118.39981, 34.00828], [-118.39986, 34.00827], [-118.40029, 34.00862], [-118.4003, 34.00867]]]} | Open Access 1 | 18129 | Coombs Parkette | 17622 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 0.463 | Coombs Parkette | 0 | Local Park 2 | 4 | |
10377 | 10377 | 10376 | {"type": "Polygon", "coordinates": [[[-118.43474, 33.9934], [-118.43448, 33.99361], [-118.43467, 33.99376], [-118.43342, 33.99388], [-118.43325, 33.99261], [-118.43348, 33.99279], [-118.43372, 33.99257], [-118.43474, 33.9934]]]} | Open Access 1 | 18319 | Culver West Alexander Park | 32520 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 3.112 | Culver West Alexander 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]);