units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where AGNCY_TYP = 2, DES_TP = 2, MNG_AGENCY = 288 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 35 ✖
MNG_AGENCY 1
- Torrance, City of · 35 ✖
DES_TP 1
- Local Park · 35 ✖
ACCESS_TYP 1
- Open Access 35
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
948 | 948 | 947 | {"type": "Polygon", "coordinates": [[[-118.39238, 33.80932], [-118.39214, 33.81043], [-118.39191, 33.81038], [-118.39196, 33.81012], [-118.39199, 33.81009], [-118.39203, 33.8101], [-118.39212, 33.80992], [-118.39225, 33.80948], [-118.39233, 33.8093], [-118.39238, 33.80932]]]} | Open Access 1 | 5986 | Torrance County Beach | 26414 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.424 | Torrance County Beach | 0 | Local Park 2 | 4 | |
950 | 950 | 949 | {"type": "Polygon", "coordinates": [[[-118.37986, 33.81559], [-118.37947, 33.8157], [-118.37941, 33.81576], [-118.37708, 33.81546], [-118.37702, 33.81542], [-118.37673, 33.81482], [-118.37681, 33.81477], [-118.37702, 33.81473], [-118.37726, 33.8147], [-118.37777, 33.8147], [-118.3781, 33.81476], [-118.37848, 33.81488], [-118.37879, 33.81503], [-118.37914, 33.81529], [-118.37933, 33.81549], [-118.37968, 33.81529], [-118.37975, 33.81538], [-118.37986, 33.81559]]]} | Open Access 1 | 5989 | El Retiro Park | 18536 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 4.786 | El Retiro Park | 0 | Local Park 2 | 4 | |
951 | 951 | 950 | {"type": "Polygon", "coordinates": [[[-118.36568, 33.83592], [-118.36562, 33.83595], [-118.36377, 33.83595], [-118.3636, 33.83502], [-118.36567, 33.83503], [-118.36568, 33.83592]]]} | Open Access 1 | 6003 | Paradise Park | 23405 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 4.67 | Paradise Park | 0 | Local Park 2 | 4 | |
952 | 952 | 951 | {"type": "Polygon", "coordinates": [[[-118.3144, 33.81056], [-118.3144, 33.81122], [-118.3118, 33.81121], [-118.31181, 33.80991], [-118.31183, 33.80989], [-118.3134, 33.80989], [-118.31341, 33.81019], [-118.31394, 33.81019], [-118.31394, 33.81023], [-118.31394, 33.81048], [-118.3134, 33.81048], [-118.3134, 33.81055], [-118.3144, 33.81056]]]} | Open Access 1 | 6018 | Sur La Brea Park | 26075 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 7.422 | Sur La Brea Park | 0 | Local Park 2 | 4 | |
953 | 953 | 952 | {"type": "MultiPolygon", "coordinates": [[[[-118.31874, 33.83299], [-118.3174, 33.83403], [-118.31715, 33.83381], [-118.31849, 33.83277], [-118.31874, 33.83299]]], [[[-118.32028, 33.83181], [-118.31891, 33.83287], [-118.31866, 33.83264], [-118.32004, 33.83159], [-118.32028, 33.83181]]], [[[-118.32091, 33.83125], [-118.32091, 33.83125], [-118.32024, 33.83126], [-118.3206, 33.83097], [-118.32091, 33.83125]]], [[[-118.32096, 33.83147], [-118.32058, 33.83176], [-118.32027, 33.83147], [-118.32027, 33.83147], [-118.32096, 33.83147]]]]} | Open Access 1 | 6019 | El Prado Park | 18532 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 3.357 | El Prado Park | 0 | Local Park 2 | 4 | |
954 | 954 | 953 | {"type": "Polygon", "coordinates": [[[-118.32505, 33.84668], [-118.32406, 33.84668], [-118.32406, 33.8464], [-118.32504, 33.8464], [-118.32505, 33.84668]]]} | Open Access 1 | 6020 | Pueblo Park | 29902 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.689 | Pueblo Park | 0 | Local Park 2 | 4 | |
1934 | 1934 | 1933 | {"type": "Polygon", "coordinates": [[[-118.39088, 33.81466], [-118.39079, 33.81519], [-118.39061, 33.81519], [-118.38994, 33.81511], [-118.38992, 33.8151], [-118.38992, 33.81505], [-118.38996, 33.81502], [-118.39011, 33.81484], [-118.39026, 33.8146], [-118.39088, 33.81466]]]} | Open Access 1 | 5985 | Miramar Park | 22286 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 1.05 | Miramar Park | 0 | Local Park 2 | 4 | |
1937 | 1937 | 1936 | {"type": "Polygon", "coordinates": [[[-118.3711, 33.8099], [-118.36954, 33.8099], [-118.37004, 33.80894], [-118.37004, 33.80833], [-118.37013, 33.80831], [-118.37022, 33.80824], [-118.37028, 33.80807], [-118.3705, 33.80774], [-118.37061, 33.80762], [-118.37075, 33.8075], [-118.37089, 33.80741], [-118.37103, 33.80758], [-118.37109, 33.80758], [-118.37111, 33.80984], [-118.3711, 33.8099]]]} | Open Access 1 | 5994 | Los Arboles Park | 21503 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 6.305 | Los Arboles Park | 0 | Local Park 2 | 4 | |
1938 | 1938 | 1937 | {"type": "Polygon", "coordinates": [[[-118.3567, 33.80956], [-118.3567, 33.81116], [-118.35667, 33.81117], [-118.35664, 33.81117], [-118.35623, 33.81114], [-118.35603, 33.81109], [-118.35596, 33.81109], [-118.35585, 33.81114], [-118.35579, 33.8112], [-118.35577, 33.81125], [-118.35577, 33.81132], [-118.35583, 33.81149], [-118.3558, 33.8127], [-118.35574, 33.81272], [-118.35453, 33.81271], [-118.35451, 33.81269], [-118.35453, 33.80923], [-118.35462, 33.80922], [-118.3547, 33.80924], [-118.35501, 33.80939], [-118.35519, 33.80942], [-118.35668, 33.80954], [-118.3567, 33.80956]]]} | Open Access 1 | 5995 | Lago Seco Park | 20840 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 14.638 | Lago Seco Park | 0 | Local Park 2 | 4 | |
1939 | 1939 | 1938 | {"type": "Polygon", "coordinates": [[[-118.35435, 33.80454], [-118.35435, 33.80563], [-118.35277, 33.80551], [-118.35278, 33.80441], [-118.35435, 33.80454]]]} | Open Access 1 | 5997 | Walteria Park | 27248 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 4.411 | Walteria Park | 0 | Local Park 2 | 4 | |
1940 | 1940 | 1939 | {"type": "Polygon", "coordinates": [[[-118.34494, 33.79301], [-118.34492, 33.79305], [-118.34466, 33.79321], [-118.34429, 33.79334], [-118.3441, 33.79344], [-118.34397, 33.79361], [-118.34392, 33.79376], [-118.34393, 33.79384], [-118.34395, 33.79393], [-118.34402, 33.79406], [-118.3446, 33.79461], [-118.34474, 33.79472], [-118.34486, 33.79478], [-118.34466, 33.79513], [-118.34181, 33.794], [-118.34202, 33.79363], [-118.34212, 33.79361], [-118.34222, 33.79352], [-118.34229, 33.79333], [-118.34243, 33.79307], [-118.34273, 33.79255], [-118.34284, 33.79243], [-118.34288, 33.79237], [-118.34289, 33.79229], [-118.34284, 33.7922], [-118.343, 33.79194], [-118.34397, 33.79233], [-118.34433, 33.79251], [-118.34452, 33.79264], [-118.34474, 33.79281], [-118.34493, 33.79296], [-118.34494, 33.79301]]]} | Open Access 1 | 5999 | De Portola Park | 17975 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 12.592 | De Portola Park | 0 | Local Park 2 | 4 | |
1944 | 1944 | 1943 | {"type": "Polygon", "coordinates": [[[-118.33649, 33.81859], [-118.33616, 33.81859], [-118.33615, 33.81848], [-118.3343, 33.81811], [-118.33447, 33.81796], [-118.33452, 33.81789], [-118.33492, 33.8171], [-118.33494, 33.81708], [-118.33522, 33.81714], [-118.33555, 33.81718], [-118.3358, 33.81716], [-118.33611, 33.81713], [-118.33647, 33.81713], [-118.33649, 33.81715], [-118.33649, 33.81718], [-118.33649, 33.81859]]]} | Open Access 1 | 6000 | Hickory Park | 19897 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 5.807 | Hickory Park | 0 | Local Park 2 | 4 | |
4356 | 4356 | 4355 | {"type": "Polygon", "coordinates": [[[-118.34726, 33.86193], [-118.344, 33.86193], [-118.34399, 33.8613], [-118.3466, 33.8613], [-118.3466, 33.85844], [-118.34725, 33.85844], [-118.34726, 33.85838], [-118.34726, 33.86193]]]} | Open Access 1 | 45709 | Columbia Park | 17547 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 10.024 | Columbia Park | 0 | Local Park 2 | 4 | |
6900 | 6900 | 6899 | {"type": "Polygon", "coordinates": [[[-118.38336, 33.81195], [-118.38333, 33.81228], [-118.3833, 33.81233], [-118.38323, 33.81233], [-118.38281, 33.81199], [-118.38282, 33.81194], [-118.38286, 33.81192], [-118.38333, 33.81192], [-118.38336, 33.81195]]]} | Open Access 1 | 5988 | Riviera Park | 24471 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.372 | Riviera Park | 0 | Local Park 2 | 4 | |
6946 | 6946 | 6945 | {"type": "Polygon", "coordinates": [[[-118.35427, 33.82352], [-118.35426, 33.82376], [-118.35369, 33.82371], [-118.35368, 33.82345], [-118.35424, 33.82349], [-118.35427, 33.82352]]]} | Open Access 1 | 6004 | Discovery Park | 18166 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.395 | Discovery Park | 0 | Local Park 2 | 4 | |
7002 | 7002 | 7001 | {"type": "Polygon", "coordinates": [[[-118.33348, 33.78451], [-118.33347, 33.78464], [-118.333, 33.78463], [-118.33301, 33.78506], [-118.33137, 33.78506], [-118.33136, 33.78393], [-118.3318, 33.78349], [-118.333, 33.78404], [-118.33302, 33.78448], [-118.33348, 33.78451]]]} | Open Access 1 | 5977 | Alta Loma Park | 15416 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 5.65 | Alta Loma Park | 0 | Local Park 2 | 4 | |
7034 | 7034 | 7033 | {"type": "Polygon", "coordinates": [[[-118.35936, 33.81965], [-118.35935, 33.82005], [-118.35857, 33.81965], [-118.35904, 33.81964], [-118.35936, 33.81965]]]} | Open Access 1 | 6006 | La Paloma Park | 20781 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.411 | La Paloma Park | 0 | Local Park 2 | 4 | |
7035 | 7035 | 7034 | {"type": "Polygon", "coordinates": [[[-118.36495, 33.84316], [-118.36345, 33.84316], [-118.36344, 33.84143], [-118.36494, 33.84143], [-118.36495, 33.84316]]]} | Open Access 1 | 6007 | Victor Park | 27071 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 6.599 | Victor Park | 0 | Local Park 2 | 4 | |
7036 | 7036 | 7035 | {"type": "Polygon", "coordinates": [[[-118.36269, 33.85367], [-118.36202, 33.8541], [-118.36103, 33.85437], [-118.36055, 33.85448], [-118.36054, 33.85447], [-118.36051, 33.85428], [-118.36051, 33.85332], [-118.36126, 33.85332], [-118.36126, 33.85297], [-118.36158, 33.85299], [-118.36165, 33.85297], [-118.36168, 33.85295], [-118.36183, 33.85298], [-118.36216, 33.85288], [-118.36233, 33.85316], [-118.36261, 33.85354], [-118.36269, 33.85367]]]} | Open Access 1 | 6008 | La Romeria Park | 20805 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 5.591 | La Romeria Park | 0 | Local Park 2 | 4 | |
7037 | 7037 | 7036 | {"type": "Polygon", "coordinates": [[[-118.37364, 33.85464], [-118.37353, 33.85466], [-118.37302, 33.85512], [-118.37144, 33.85512], [-118.37143, 33.85544], [-118.37125, 33.85545], [-118.37124, 33.85512], [-118.37086, 33.85512], [-118.37055, 33.85389], [-118.36985, 33.85267], [-118.36996, 33.85242], [-118.36996, 33.85174], [-118.37048, 33.85173], [-118.37049, 33.85135], [-118.37067, 33.85135], [-118.37067, 33.85173], [-118.37209, 33.85173], [-118.37254, 33.85199], [-118.37294, 33.85219], [-118.37316, 33.85221], [-118.37364, 33.85464]]]} | Open Access 1 | 6009 | Entradero Park | 18687 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 25.683 | Entradero 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]);