superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where MNG_AGENCY = 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5164 | 5164 | 5163 | {"type": "Polygon", "coordinates": [[[-118.39936, 34.00155], [-118.39907, 34.00194], [-118.39892, 34.00221], [-118.39872, 34.00263], [-118.39862, 34.00291], [-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 | Lindberg Park | 21286 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 4.159 | Lindberg Park | ||
5427 | 5427 | 5426 | {"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 | 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 | 1.705 | Ivy Substation and Media Park | ||
6770 | 6770 | 6769 | {"type": "Polygon", "coordinates": [[[-118.43173, 33.99148], [-118.43157, 33.99155], [-118.43154, 33.99132], [-118.43154, 33.99132], [-118.43173, 33.99148]]]} | Open Access 1 | Maxella Parkette | 21967 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 0.051 | Maxella Parkette | ||
10193 | 10193 | 10192 | {"type": "Polygon", "coordinates": [[[-118.37871, 34.02733], [-118.37829, 34.02745], [-118.37825, 34.02771], [-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.02833], [-118.37736, 34.02829], [-118.37728, 34.02819], [-118.37721, 34.02819], [-118.37712, 34.02824], [-118.37709, 34.02828], [-118.37716, 34.02852], [-118.37678, 34.02862], [-118.37673, 34.02851], [-118.37636, 34.0286], [-118.37622, 34.0286], [-118.37683, 34.0271], [-118.377, 34.02698], [-118.37836, 34.02711], [-118.37837, 34.02715], [-118.37866, 34.02717], [-118.37871, 34.02733]]]} | Open Access 1 | Syd Kronenthal Park | 26145 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 6.12 | Syd Kronenthal Park | ||
10255 | 10255 | 10254 | {"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 | Tellefson Park | 26225 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1.314 | Tellefson Park | ||
10823 | 10823 | 10822 | {"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 | Veterans Park | 27041 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 11.253 | Veterans Park | ||
13102 | 13102 | 13101 | {"type": "MultiPolygon", "coordinates": [[[[-118.38534, 34.02767], [-118.38533, 34.02775], [-118.38316, 34.02755], [-118.38313, 34.02751], [-118.38309, 34.0275], [-118.38298, 34.02753], [-118.38198, 34.02744], [-118.38194, 34.02739], [-118.38189, 34.02736], [-118.38182, 34.02738], [-118.38178, 34.02742], [-118.38094, 34.02734], [-118.38089, 34.02732], [-118.38082, 34.02733], [-118.38001, 34.02726], [-118.3797, 34.02726], [-118.37929, 34.02722], [-118.37927, 34.02723], [-118.37835, 34.02715], [-118.37834, 34.0271], [-118.37702, 34.02698], [-118.37683, 34.02711], [-118.37688, 34.02697], [-118.37693, 34.02696], [-118.37696, 34.02687], [-118.37985, 34.02713], [-118.38058, 34.02722], [-118.38187, 34.02732], [-118.38261, 34.02742], [-118.38439, 34.0276], [-118.38534, 34.02767]]], [[[-118.37843, 34.02209], [-118.37823, 34.02223], [-118.37792, 34.02253], [-118.37772, 34.02278], [-118.37754, 34.0231], [-118.37743, 34.02339], [-118.37735, 34.02373], [-118.37719, 34.02459], [-118.37694, 34.02617], [-118.37689, 34.02614], [-118.37706, 34.02505], [-118.37732, 34.02354], [-118.37746, 34.02312], [-118.37759, 34.02288], [-118.37777, 34.02264], [-118.37802, 34.02234], [-118.37831, 34.02207], [-118.37843, 34.02209]]], [[[-118.3894, 34.01753], [-118.38804, 34.01937], [-118.38793, 34.0195], [-118.3877, 34.01973], [-118.38746, 34.01993], [-118.38719, 34.02011], [-118.38689, 34.02028], [-118.38682, 34.02025], [-118.38618, 34.02045], [-118.38437, 34.02073], [-118.38192, 34.02117], [-118.38012, 34.02145], [-118.37941, 34.02159], [-118.37886, 34.02181], [-118.3786, 34.02198], [-118.37848, 34.02196], [-118.37891, 34.02172], [-118.37924, 34.02159], [-118.37958, 34.02149], [-118.37995, 34.02141], [-118.38256, 34.021], [-118.38282, 34.02093], [-118.38381, 34.02079], [-118.38605, 34.02043], [-118.38691, 34.02013], [-118.38744, 34.0198], [-118.38767, 34.0196], [-118.38797, 34.01929], [-118.38927, 34.01747], [-118.3894, 34.01753]]], [[[-118.39626, 34.00748], [-118.39489, 34.00786], [-118.39486, 34.00782], [-118.39472, 34.00783], [-118.39468, 34.00785], [-118.39467, 34.00787], [-118.39449, 34.00792], [-118.39447, 34.00791], [-118.3943, 34.00795], [-118.39392, 34.00807], [-118.39372, 34.00814], [-118.39342, 34.00828], [-118.39314, 34.00844], [-118.39311, 34.00842], [-118.39299, 34.00851], [-118.39296, 34.00854], [-118.39297, 34.00856], [-118.39284, 34.00866], [-118.39281, 34.00865], [-118.39262, 34.00883], [-118.39236, 34.00915], [-118.39222, 34.00938], [-118.39211, 34.00962], [-118.39203, 34.00987], [-118.39197, 34.01026], [-118.39197, 34.0111], [-118.392, 34.01112], [-118.39205, 34.01123], [-118.392, 34.01128], [-118.392, 34.01136], [-118.39205, 34.01142], [-118.39213, 34.01256], [-118.39142, 34.01421], [-118.39072, 34.01513], [-118.39064, 34.01526], [-118.39061, 34.01536], [-118.3904, 34.01569], [-118.39004, 34.01619], [-118.39001, 34.01631], [-118.38976, 34.01679], [-118.38968, 34.01708], [-118.38946, 34.01743], [-118.3893, 34.01735], [-118.39002, 34.01615], [-118.39057, 34.01534], [-118.39061, 34.01523], [-118.39138, 34.01422], [-118.39175, 34.01334], [-118.39194, 34.01259], [-118.39199, 34.01209], [-118.392, 34.01137], [-118.39195, 34.01131], [-118.39197, 34.01112], [-118.39192, 34.01109], [-118.39192, 34.01039], [-118.39193, 34.01012], [-118.39198, 34.00986], [-118.39206, 34.00961], [-118.39218, 34.00936], [-118.39232, 34.00912], [-118.3925, 34.0089], [-118.3928, 34.00861], [-118.3931, 34.00838], [-118.39338, 34.00823], [-118.39386, 34.00805], [-118.39481, 34.00775], [-118.39482, 34.00772], [-118.39611, 34.00728], [-118.39626, 34.00748]]], [[[-118.40046, 34.0022], [-118.39956, 34.00495], [-118.39937, 34.00545], [-118.39916, 34.00583], [-118.39902, 34.00601], [-118.39899, 34.00601], [-118.39878, 34.00623], [-118.39844, 34.00653], [-118.39818, 34.0067], [-118.3979, 34.00686], [-118.39739, 34.00708], [-118.39641, 34.00737], [-118.39631, 34.00723], [-118.39746, 34.00699], [-118.39765, 34.00694], [-118.398, 34.00676], [-118.39838, 34.0065], [-118.39877, 34.00616], [-118.399, 34.00588], [-118.39842, 34.00569], [-118.39833, 34.0057], [-118.39795, 34.00605], [-118.39791, 34.00603], [-118.39823, 34.0057], [-118.39835, 34.00556], [-118.39848, 34.00532], [-118.39858, 34.00535], [-118.39846, 34.00565], [-118.39904, 34.00584], [-118.39907, 34.00582], [-118.39922, 34.00559], [-118.3999, 34.00373], [-118.40042, 34.00218], [-118.40046, 34.0022]]], [[[-118.40141, 34.00002], [-118.40121, 34.00039], [-118.40123, 34.00041], [-118.40094, 34.00091], [-118.40074, 34.00142], [-118.40068, 34.00143], [-118.4012, 33.99986], [-118.40126, 33.99987], [-118.40108, 34.00051], [-118.4011, 34.0005], [-118.40138, 34.0], [-118.40141, 34.00002]]], [[[-118.40502, 33.99457], [-118.40495, 33.99462], [-118.40476, 33.9948], [-118.4045, 33.99491], [-118.40491, 33.99456], [-118.405, 33.99449], [-118.40502, 33.99457]]]]} | Open Access 1 | Ballona Creek Trail and Bike Path | 30331 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 9.988 | Ballona Creek Trail and Bike Path | ||
13925 | 13925 | 13924 | {"type": "Polygon", "coordinates": [[[-118.43474, 33.9934], [-118.43449, 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 | 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 | 3.116 | Culver West Alexander Park | ||
13926 | 13926 | 13925 | {"type": "Polygon", "coordinates": [[[-118.40536, 34.01002], [-118.40401, 34.0117], [-118.40396, 34.0117], [-118.40377, 34.01155], [-118.40515, 34.00984], [-118.40535, 34.00997], [-118.40536, 34.01002]]]} | Open Access 1 | Vets Park Paddle Tennis | 32521 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1.573 | Vets Park Paddle Tennis | ||
15529 | 15529 | 15528 | {"type": "Polygon", "coordinates": [[[-118.38675, 34.02788], [-118.38656, 34.028], [-118.38649, 34.028], [-118.38626, 34.02783], [-118.38675, 34.02788]]]} | Open Access 1 | National Mini Park | 22660 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 0.101 | Nat. MP |
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]);