units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where MNG_AGENCY = 283
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15199 | 15199 | 15198 | {"type": "Polygon", "coordinates": [[[-118.35317, 33.72904], [-118.35277, 33.72926], [-118.35248, 33.729], [-118.35223, 33.72849], [-118.35225, 33.72804], [-118.35247, 33.728], [-118.35262, 33.72822], [-118.35265, 33.72827], [-118.35269, 33.72845], [-118.35278, 33.7286], [-118.35286, 33.72869], [-118.35294, 33.72886], [-118.35304, 33.7289], [-118.35317, 33.72904]]]} | Open Access 1 | 46076 | Rancho Palos Verdes Beach | 29416 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | http://www.rpvca.gov | Los Angeles 6 | 1.395 | Rancho Palos Verdes Beach | 0 | Local Park 2 | 4 |
15202 | 15202 | 15201 | {"type": "Polygon", "coordinates": [[[-118.36291, 33.74101], [-118.36226, 33.74149], [-118.36219, 33.74153], [-118.36209, 33.74152], [-118.36185, 33.74174], [-118.36172, 33.74183], [-118.36049, 33.74264], [-118.36037, 33.74271], [-118.36009, 33.74282], [-118.35993, 33.74286], [-118.3599, 33.74268], [-118.35989, 33.74249], [-118.36001, 33.74045], [-118.36009, 33.7404], [-118.36045, 33.74054], [-118.3608, 33.74065], [-118.36132, 33.74078], [-118.36291, 33.74101]]]} | Open Access 1 | 46082 | Gateway Park | 29425 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 9.456 | Gateway Park | 0 | Local Park 2 | 4 | |
16779 | 16779 | 16778 | {"type": "MultiPolygon", "coordinates": [[[[-118.32475, 33.74883], [-118.32465, 33.7489], [-118.32454, 33.74882], [-118.32438, 33.74875], [-118.32449, 33.74865], [-118.32454, 33.74862], [-118.32462, 33.74873], [-118.32475, 33.74883]]], [[[-118.32527, 33.75293], [-118.32507, 33.7532], [-118.32498, 33.75321], [-118.32519, 33.75293], [-118.32518, 33.7529], [-118.32492, 33.75276], [-118.32495, 33.7527], [-118.32524, 33.75286], [-118.32527, 33.75293]]]]} | Open Access 1 | 5904 | Miraleste Recreation and Parks District | 29420 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 0.225 | Miraleste Rec. and Parks District | 0 | Local Recreation Area 3 | 4 | |
16938 | 16938 | 16937 | {"type": "Polygon", "coordinates": [[[-118.40727, 33.74693], [-118.40415, 33.74728], [-118.40425, 33.74668], [-118.40424, 33.74646], [-118.40419, 33.74619], [-118.40407, 33.74593], [-118.40391, 33.74569], [-118.40382, 33.74559], [-118.40355, 33.74538], [-118.40333, 33.74525], [-118.40309, 33.74516], [-118.40271, 33.74509], [-118.40243, 33.74507], [-118.40188, 33.74509], [-118.40135, 33.74514], [-118.40094, 33.74521], [-118.40069, 33.74423], [-118.4007, 33.74281], [-118.4021, 33.74179], [-118.40213, 33.74179], [-118.40216, 33.74179], [-118.40217, 33.74181], [-118.40247, 33.7419], [-118.40249, 33.7418], [-118.40405, 33.74228], [-118.40445, 33.74237], [-118.40486, 33.74244], [-118.40537, 33.74248], [-118.40658, 33.74247], [-118.40686, 33.74249], [-118.40719, 33.74254], [-118.40784, 33.74271], [-118.40829, 33.74291], [-118.40851, 33.74307], [-118.40876, 33.74331], [-118.40896, 33.74359], [-118.40903, 33.74374], [-118.40909, 33.74393], [-118.40913, 33.74413], [-118.40913, 33.74443], [-118.40908, 33.74469], [-118.40901, 33.74488], [-118.40882, 33.7452], [-118.40754, 33.74656], [-118.40727, 33.74693]], [[-118.40698, 33.74517], [-118.40711, 33.7453], [-118.40842, 33.74444], [-118.40821, 33.74415], [-118.40751, 33.74409], [-118.4064, 33.7442], [-118.4062, 33.74433], [-118.40644, 33.7446], [-118.40645, 33.74521], [-118.40675, 33.74523], [-118.40689, 33.74518], [-118.40693, 33.74513], [-118.40698, 33.74517]]]} | Open Access 1 | 5899 | Point Vicente Park and Civic Center | 23868 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 72.776 | Point Vicente Park and Civic Ctr. | 0 | Local Recreation Area 3 | 4 | |
17048 | 17048 | 17047 | {"type": "Polygon", "coordinates": [[[-118.41338, 33.74626], [-118.41322, 33.74627], [-118.40776, 33.74687], [-118.40791, 33.7467], [-118.40907, 33.74548], [-118.40922, 33.74528], [-118.40941, 33.74493], [-118.40945, 33.74479], [-118.40949, 33.74479], [-118.41043, 33.74285], [-118.411, 33.74311], [-118.41123, 33.74353], [-118.41138, 33.74367], [-118.41169, 33.74396], [-118.41217, 33.74425], [-118.41234, 33.74446], [-118.41232, 33.74459], [-118.41269, 33.74525], [-118.41338, 33.74626]]]} | Open Access 1 | 46085 | Point Vicente Interpretive Center | 29431 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 26.518 | Point Vicente Interpretive Ctr. | 0 | Local Recreation Area 3 | 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]);