units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
73 rows where MNG_AGENCY = 288 sorted by MNG_AG_LEV
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
7033 | 7033 | 7032 | {"type": "Polygon", "coordinates": [[[-118.3448, 33.82554], [-118.3448, 33.82767], [-118.34478, 33.828], [-118.34478, 33.82911], [-118.34473, 33.82916], [-118.3444, 33.82916], [-118.3439, 33.82912], [-118.34363, 33.82907], [-118.34337, 33.829], [-118.34312, 33.82892], [-118.34283, 33.82878], [-118.34251, 33.8286], [-118.34055, 33.82731], [-118.34005, 33.82708], [-118.34004, 33.82705], [-118.34003, 33.82566], [-118.34, 33.82542], [-118.33991, 33.82492], [-118.33989, 33.82465], [-118.33991, 33.82444], [-118.33994, 33.82441], [-118.34001, 33.8244], [-118.34081, 33.82457], [-118.34161, 33.8247], [-118.34336, 33.82506], [-118.34421, 33.82514], [-118.34421, 33.82554], [-118.3448, 33.82554]]]} | Open Access 1 | 6005 | Madrona Marsh Preserve | 29331 | 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 | 42.371 | Madrona Marsh Preserve | 0 | Local Conservation Area 4 | 2 | |
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 | |
7038 | 7038 | 7037 | {"type": "Polygon", "coordinates": [[[-118.37514, 33.85038], [-118.37394, 33.85055], [-118.37358, 33.8487], [-118.37437, 33.84871], [-118.37488, 33.84878], [-118.37492, 33.84881], [-118.37489, 33.84902], [-118.37489, 33.84913], [-118.37514, 33.85038]]]} | Open Access 1 | 6010 | Sunnyglen Park | 26006 | 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.483 | Sunnyglen Park | 0 | Local Park 2 | 4 | |
7039 | 7039 | 7038 | {"type": "Polygon", "coordinates": [[[-118.34715, 33.84786], [-118.3454, 33.84786], [-118.34539, 33.84679], [-118.34501, 33.84679], [-118.34499, 33.8467], [-118.34496, 33.84641], [-118.34497, 33.84505], [-118.34606, 33.84505], [-118.34606, 33.84678], [-118.34714, 33.84678], [-118.34715, 33.84786]]]} | Open Access 1 | 6011 | Delthorne Park | 18078 | 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 | 9.587 | Delthorne Park | 0 | Local Park 2 | 4 | |
7040 | 7040 | 7039 | {"type": "Polygon", "coordinates": [[[-118.33331, 33.83428], [-118.33231, 33.83429], [-118.3323, 33.83292], [-118.33329, 33.83291], [-118.33331, 33.83428]]]} | Open Access 1 | 6014 | Greenwood Park | 19489 | 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.437 | Greenwood Park | 0 | Local Park 2 | 4 | |
7041 | 7041 | 7040 | {"type": "Polygon", "coordinates": [[[-118.32837, 33.82753], [-118.3224, 33.82758], [-118.3212, 33.82649], [-118.32165, 33.82648], [-118.32164, 33.82567], [-118.32082, 33.82567], [-118.32011, 33.82549], [-118.31996, 33.82532], [-118.31991, 33.82531], [-118.31954, 33.82496], [-118.31917, 33.82465], [-118.31917, 33.82463], [-118.31928, 33.82473], [-118.31967, 33.82494], [-118.31984, 33.825], [-118.32017, 33.82509], [-118.32045, 33.82512], [-118.32835, 33.82506], [-118.32837, 33.82753]]]} | Open Access 1 | 6015 | Charles H. Wilson Park | 17139 | 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 | 44.163 | Charles H. Wilson Park | 0 | Local Park 2 | 4 | |
7042 | 7042 | 7041 | {"type": "Polygon", "coordinates": [[[-118.31867, 33.82175], [-118.31822, 33.82302], [-118.31708, 33.82273], [-118.31541, 33.82122], [-118.31549, 33.82097], [-118.31867, 33.82175]]]} | Open Access 1 | 6016 | Torrance Park | 26468 | 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 | 8.192 | Torrance Park | 0 | Local Park 2 | 4 | |
7045 | 7045 | 7044 | {"type": "Polygon", "coordinates": [[[-118.31349, 33.86923], [-118.31348, 33.86924], [-118.31348, 33.8706], [-118.31239, 33.8706], [-118.3124, 33.86962], [-118.31224, 33.86961], [-118.31223, 33.86931], [-118.31239, 33.8693], [-118.3124, 33.86778], [-118.31349, 33.86779], [-118.31349, 33.86923]]]} | Open Access 1 | 6021 | Guenser Park | 19562 | 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.929 | Guenser Park | 0 | Local Park 2 | 4 | |
7046 | 7046 | 7045 | {"type": "MultiPolygon", "coordinates": [[[[-118.3466, 33.8613], [-118.34388, 33.8613], [-118.34388, 33.85839], [-118.3466, 33.85839], [-118.3466, 33.8613]]], [[[-118.35089, 33.85921], [-118.35089, 33.85978], [-118.35065, 33.85979], [-118.35065, 33.86184], [-118.34815, 33.86185], [-118.34814, 33.86193], [-118.34726, 33.86193], [-118.34726, 33.85838], [-118.34769, 33.85838], [-118.3477, 33.85844], [-118.34814, 33.85844], [-118.34814, 33.85921], [-118.35089, 33.85921]], [[-118.34908, 33.86044], [-118.34907, 33.86058], [-118.34919, 33.86057], [-118.34919, 33.86044], [-118.34908, 33.86044]], [[-118.34995, 33.85985], [-118.34996, 33.85955], [-118.34962, 33.85956], [-118.34962, 33.85985], [-118.34995, 33.85985]]]]} | Open Access 1 | 6022 | 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 | 44.851 | Columbia Park | 0 | Local Park 2 | 4 | |
7047 | 7047 | 7046 | {"type": "Polygon", "coordinates": [[[-118.31564, 33.86189], [-118.31348, 33.86189], [-118.31348, 33.86097], [-118.31564, 33.86182], [-118.31564, 33.86189]]]} | Open Access 1 | 6023 | La Carretera Park | 20746 | 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 | 2.718 | La Carretera Park | 0 | Local Park 2 | 4 | |
7049 | 7049 | 7048 | {"type": "Polygon", "coordinates": [[[-118.32204, 33.87195], [-118.32201, 33.87198], [-118.32196, 33.87198], [-118.32167, 33.87193], [-118.32153, 33.87187], [-118.32076, 33.87146], [-118.32061, 33.87139], [-118.32046, 33.87136], [-118.32045, 33.871], [-118.32204, 33.871], [-118.32204, 33.87195]]]} | Open Access 1 | 6031 | Descanso Park | 18110 | 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 | 2.84 | Descanso Park | 0 | Local Park 2 | 4 | |
7050 | 7050 | 7049 | {"type": "Polygon", "coordinates": [[[-118.33735, 33.8727], [-118.33529, 33.8727], [-118.33524, 33.87266], [-118.33523, 33.87243], [-118.33565, 33.87242], [-118.33573, 33.87236], [-118.33573, 33.87174], [-118.33523, 33.87173], [-118.33524, 33.87142], [-118.33646, 33.87142], [-118.33648, 33.87123], [-118.33735, 33.87123], [-118.33735, 33.8727]]]} | Open Access 1 | 6032 | McMaster Park | 22057 | 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.47 | McMaster Park | 0 | Local Park 2 | 4 | |
7051 | 7051 | 7050 | {"type": "Polygon", "coordinates": [[[-118.3448, 33.87548], [-118.3447, 33.8756], [-118.34443, 33.87557], [-118.34446, 33.87536], [-118.3445, 33.87534], [-118.34463, 33.87538], [-118.3448, 33.87548]]]} | Open Access 1 | 6033 | Osage Park | 23231 | 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.164 | Osage 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]);