units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where AGNCY_LEV = 2 and MNG_AGENCY = 308
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
- City Agency 15
MNG_AGENCY 1
- Sierra Madre, City of · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1071 | 1071 | 1070 | {"type": "Polygon", "coordinates": [[[-118.04919, 34.16993], [-118.04872, 34.16992], [-118.0487, 34.16977], [-118.04836, 34.16976], [-118.04819, 34.16989], [-118.04819, 34.16954], [-118.04912, 34.16954], [-118.04912, 34.1696], [-118.04919, 34.1697], [-118.04919, 34.16993]]]} | Open Access 1 | 6973 | Mount Wilson Trail Park | 22537 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 0.768 | Mount Wilson Trail Park | 0 | Local Park 2 | 4 | |
1072 | 1072 | 1071 | {"type": "Polygon", "coordinates": [[[-118.05819, 34.16144], [-118.05754, 34.16144], [-118.05753, 34.16175], [-118.05667, 34.16176], [-118.05667, 34.16071], [-118.05819, 34.16069], [-118.05819, 34.16144]]]} | Open Access 1 | 6974 | Memorial Park | 22135 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 3.536 | Memorial Park | 0 | Local Park 2 | 4 | |
5606 | 5606 | 5605 | {"type": "Polygon", "coordinates": [[[-118.0417, 34.16679], [-118.03847, 34.16681], [-118.03845, 34.16397], [-118.03944, 34.16382], [-118.03945, 34.16291], [-118.04029, 34.16292], [-118.0409, 34.16485], [-118.04169, 34.16473], [-118.0417, 34.16679]]]} | Open Access 1 | 46605 | Sierra Vista Open Space | 29915 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 24.104 | Sierra Vista OS | 0 | Local Recreation Area 3 | 4 | |
7465 | 7465 | 7464 | {"type": "Polygon", "coordinates": [[[-118.04186, 34.16395], [-118.04168, 34.16396], [-118.04169, 34.16473], [-118.0409, 34.16485], [-118.04029, 34.16292], [-118.03946, 34.16291], [-118.03944, 34.16382], [-118.03845, 34.16397], [-118.03844, 34.16205], [-118.04067, 34.16205], [-118.04068, 34.16203], [-118.04085, 34.16203], [-118.04085, 34.16236], [-118.04108, 34.16276], [-118.04149, 34.16309], [-118.04127, 34.1631], [-118.04128, 34.16393], [-118.04186, 34.16393], [-118.04186, 34.16395]]]} | Open Access 1 | 6976 | Sierra Vista Park | 25470 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 12.234 | Sierra Vista Park | 0 | Local Park 2 | 4 | |
8259 | 8259 | 8258 | {"type": "Polygon", "coordinates": [[[-118.04511, 34.17049], [-118.045, 34.17082], [-118.04473, 34.1707], [-118.04476, 34.17093], [-118.04474, 34.17094], [-118.04472, 34.17093], [-118.04469, 34.17075], [-118.0447, 34.17068], [-118.04452, 34.1706], [-118.04461, 34.17047], [-118.04461, 34.17039], [-118.04511, 34.17049]]]} | Open Access 1 | 12654 | Sierra Madre City Parkland | 12523 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 0.391 | Sierra Madre City Parkland | 0 | Local Park 2 | 4 | |
8260 | 8260 | 8259 | {"type": "Polygon", "coordinates": [[[-118.04662, 34.1722], [-118.04641, 34.17244], [-118.04635, 34.17261], [-118.046, 34.17273], [-118.04587, 34.17303], [-118.04592, 34.1733], [-118.04619, 34.17336], [-118.04602, 34.17349], [-118.04581, 34.1734], [-118.04566, 34.17326], [-118.04562, 34.17314], [-118.04581, 34.17255], [-118.0457, 34.17237], [-118.04581, 34.17222], [-118.04587, 34.17217], [-118.04598, 34.17215], [-118.04619, 34.1725], [-118.04655, 34.17213], [-118.04662, 34.1722]]]} | Open Access 1 | 12655 | Sierra Madre City Parkland | 12523 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 1.167 | Sierra Madre City Parkland | 0 | Local Park 2 | 4 | |
8261 | 8261 | 8260 | {"type": "Polygon", "coordinates": [[[-118.03931, 34.17511], [-118.03684, 34.17512], [-118.03682, 34.17307], [-118.038, 34.17302], [-118.03837, 34.17284], [-118.0393, 34.17416], [-118.03931, 34.17511]]]} | Open Access 1 | 12656 | Sierra Madre City Parkland | 12523 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 12.016 | Sierra Madre City Parkland | 0 | Local Park 2 | 4 | |
8262 | 8262 | 8261 | {"type": "Polygon", "coordinates": [[[-118.06537, 34.19384], [-118.0651, 34.20796], [-118.06516, 34.20852], [-118.04753, 34.20885], [-118.04752, 34.20813], [-118.04788, 34.1901], [-118.0435, 34.19008], [-118.04371, 34.17934], [-118.03933, 34.17936], [-118.03466, 34.1794], [-118.03467, 34.17571], [-118.04259, 34.17573], [-118.04262, 34.17566], [-118.04357, 34.17566], [-118.04358, 34.17564], [-118.04349, 34.17551], [-118.04397, 34.1753], [-118.04394, 34.17566], [-118.04395, 34.17573], [-118.04551, 34.17572], [-118.04579, 34.17588], [-118.04587, 34.17603], [-118.04596, 34.1761], [-118.04621, 34.17649], [-118.04592, 34.17649], [-118.04586, 34.1765], [-118.0458, 34.1765], [-118.04565, 34.17652], [-118.04549, 34.17649], [-118.04523, 34.17656], [-118.04478, 34.17683], [-118.04487, 34.17705], [-118.0451, 34.17717], [-118.04523, 34.17728], [-118.04529, 34.1775], [-118.04539, 34.17754], [-118.04565, 34.17802], [-118.04571, 34.17809], [-118.04568, 34.17816], [-118.04585, 34.17837], [-118.04564, 34.17873], [-118.04545, 34.1789], [-118.04541, 34.17902], [-118.04539, 34.17916], [-118.04541, 34.17933], [-118.04555, 34.17933], [-118.04552, 34.17916], [-118.04557, 34.17896], [-118.04575, 34.1788], [-118.046, 34.17837], [-118.04583, 34.17815], [-118.04585, 34.17808], [-118.04577, 34.17797], [-118.0455, 34.17745], [-118.04541, 34.17742], [-118.04535, 34.17722], [-118.04519, 34.17708], [-118.04498, 34.17697], [-118.04495, 34.17687], [-118.04529, 34.17665], [-118.0455, 34.17661], [-118.04565, 34.17663], [-118.0458, 34.17661], [-118.04588, 34.17662], [-118.04594, 34.1766], [-118.04636, 34.1766], [-118.04635, 34.17646], [-118.04606, 34.17604], [-118.04598, 34.17596], [-118.04589, 34.17581], [-118.04555, 34.17561], [-118.04568, 34.17536], [-118.04573, 34.17533], [-118.04588, 34.17538], [-118.04623, 34.17528], [-118.04627, 34.17523], [-118.04643, 34.17512], [-118.04646, 34.17491], [-118.04657, 34.17473], [-118.04657, 34.17462], [-118.0466, 34.17456], [-118.04672, 34.17454], [-118.04678, 34.17459], [-118.04691, 34.17464], [-118.04697, 34.17461], [-118.04719, 34.17463], [-118.04724, 34.17447], [-118.04729, 34.17445], [-118.04735, 34.17439], [-118.04763, 34.17434], [-118.04767, 34.17424], [-118.04773, 34.17423], [-118.04785, 34.17417], [-118.04796, 34.174], [-118.048, 34.17388], [-118.04765, 34.17369], [-118.04752, 34.17366], [-118.04748, 34.17362], [-118.04731, 34.17354], [-118.04713, 34.1735], [-118.04698, 34.17342], [-118.0468, 34.17336], [-118.04603, 34.17321], [-118.04599, 34.17304], [-118.04611, 34.17282], [-118.04646, 34.17269], [-118.04653, 34.1725], [-118.04673, 34.17226], [-118.04739, 34.17187], [-118.04791, 34.17162], [-118.04795, 34.17164], [-118.04806, 34.17162], [-118.0481, 34.17165], [-118.04817, 34.17161], [-118.04828, 34.1716], [-118.04843, 34.17145], [-118.04849, 34.17142], [-118.0486, 34.17141], [-118.0487, 34.17136], [-118.04875, 34.17128], [-118.04874, 34.17121], [-118.04886, 34.17112], [-118.04888, 34.1712], [-118.04888, 34.1713], [-118.04884, 34.17139], [-118.04875, 34.17147], [-118.04863, 34.17152], [-118.04851, 34.17154], [-118.04841, 34.17166], [-118.04832, 34.1717], [-118.04811, 34.17172], [-118.04803, 34.17173], [-118.04801, 34.17174], [-118.04809, 34.1757], [-118.05327, 34.17574], [-118.05364, 34.17304], [-118.05386, 34.17315], [-118.05412, 34.1732], [-118.05413, 34.1736], [-118.05444, 34.1748], [-118.05348, 34.17573], [-118.05686, 34.17576], [-118.05688, 34.17932], [-118.04809, 34.17932], [-118.04795, 34.18635], [-118.05674, 34.18624], [-118.0566, 34.19382], [-118.06537, 34.19384]]]} | Open Access 1 | 12647 | Sierra Madre City Parkland | 12523 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 1165.018 | Sierra Madre City Parkland | 0 | Local Park 2 | 4 | |
8265 | 8265 | 8264 | {"type": "MultiPolygon", "coordinates": [[[[-118.04224, 34.17415], [-118.04219, 34.17422], [-118.0421, 34.17427], [-118.04204, 34.17428], [-118.04188, 34.17391], [-118.04199, 34.17389], [-118.04202, 34.17386], [-118.04224, 34.17415]]], [[[-118.04195, 34.17431], [-118.04181, 34.17439], [-118.04163, 34.17395], [-118.04179, 34.17393], [-118.04195, 34.17431]]], [[[-118.04172, 34.1744], [-118.04169, 34.1744], [-118.04161, 34.17454], [-118.04138, 34.1746], [-118.04115, 34.17405], [-118.04156, 34.17396], [-118.04172, 34.1744]]], [[[-118.04129, 34.17463], [-118.04106, 34.1747], [-118.04098, 34.17476], [-118.04079, 34.17426], [-118.04107, 34.17407], [-118.04129, 34.17463]]], [[[-118.04225, 34.17483], [-118.04165, 34.17526], [-118.04139, 34.17463], [-118.04164, 34.17456], [-118.04172, 34.17443], [-118.04181, 34.17443], [-118.04196, 34.17434], [-118.04204, 34.17431], [-118.04225, 34.17483]]], [[[-118.04157, 34.1753], [-118.04132, 34.17543], [-118.04099, 34.1748], [-118.04108, 34.17472], [-118.0413, 34.17466], [-118.04157, 34.1753]]]]} | Open Access 1 | 12648 | Sierra Madre City Parkland | 12523 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 3.116 | Sierra Madre City Parkland | 0 | Local Park 2 | 4 | |
8266 | 8266 | 8265 | {"type": "Polygon", "coordinates": [[[-118.04069, 34.17176], [-118.04065, 34.17181], [-118.04069, 34.17236], [-118.04045, 34.17246], [-118.04042, 34.17251], [-118.04036, 34.17254], [-118.04037, 34.17214], [-118.04037, 34.17169], [-118.04053, 34.1717], [-118.04068, 34.17164], [-118.04069, 34.17176]]]} | Open Access 1 | 12649 | Sierra Madre City Parkland | 12523 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 0.583 | Sierra Madre City Parkland | 0 | Local Park 2 | 4 | |
8267 | 8267 | 8266 | {"type": "Polygon", "coordinates": [[[-118.04203, 34.17256], [-118.04202, 34.17268], [-118.04184, 34.17269], [-118.04181, 34.17267], [-118.04187, 34.17258], [-118.04201, 34.17259], [-118.04203, 34.17256]]]} | Open Access 1 | 12650 | Sierra Madre City Parkland | 12523 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 0.047 | Sierra Madre City Parkland | 0 | Local Park 2 | 4 | |
8268 | 8268 | 8267 | {"type": "MultiPolygon", "coordinates": [[[[-118.03279, 34.17636], [-118.03276, 34.17645], [-118.03266, 34.17659], [-118.03255, 34.17667], [-118.03241, 34.17674], [-118.03236, 34.17676], [-118.03224, 34.17676], [-118.03215, 34.17673], [-118.03211, 34.17669], [-118.03206, 34.17661], [-118.03206, 34.17654], [-118.03227, 34.17598], [-118.03228, 34.17587], [-118.03225, 34.17573], [-118.03218, 34.17562], [-118.03212, 34.17556], [-118.03168, 34.17521], [-118.03151, 34.17513], [-118.03128, 34.17507], [-118.03115, 34.17505], [-118.03087, 34.17508], [-118.03079, 34.17511], [-118.03014, 34.17543], [-118.03015, 34.17257], [-118.03134, 34.17259], [-118.03148, 34.17263], [-118.03157, 34.1727], [-118.03172, 34.17302], [-118.03175, 34.1732], [-118.03172, 34.17333], [-118.03142, 34.17397], [-118.03139, 34.17411], [-118.03139, 34.17423], [-118.03142, 34.17435], [-118.03145, 34.17445], [-118.03154, 34.17459], [-118.032, 34.17504], [-118.0322, 34.17528], [-118.03237, 34.17552], [-118.03275, 34.1761], [-118.03278, 34.1762], [-118.03279, 34.17636]]], [[[-118.03258, 34.17241], [-118.03206, 34.17281], [-118.03184, 34.17284], [-118.03179, 34.1727], [-118.03171, 34.17258], [-118.03162, 34.17251], [-118.03146, 34.17244], [-118.03137, 34.17243], [-118.03015, 34.17241], [-118.03014, 34.17189], [-118.03028, 34.17189], [-118.03037, 34.17193], [-118.03053, 34.17206], [-118.03075, 34.17217], [-118.03091, 34.1722], [-118.03115, 34.1722], [-118.03138, 34.17214], [-118.03204, 34.1718], [-118.03217, 34.1717], [-118.03257, 34.17231], [-118.03258, 34.17241]]]]} | Open Access 1 | 12652 | Sierra Madre City Parkland | 12523 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 14.471 | Sierra Madre City Parkland | 0 | Local Park 2 | 4 | |
8269 | 8269 | 8268 | {"type": "Polygon", "coordinates": [[[-118.04411, 34.17088], [-118.04399, 34.17096], [-118.04372, 34.171], [-118.04352, 34.1711], [-118.04345, 34.17099], [-118.04401, 34.17069], [-118.04411, 34.17088]]]} | Open Access 1 | 12653 | Sierra Madre City Parkland | 12523 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 0.284 | Sierra Madre City Parkland | 0 | Local Park 2 | 4 | |
9414 | 9414 | 9413 | {"type": "Polygon", "coordinates": [[[-118.05323, 34.16201], [-118.0531, 34.16207], [-118.05298, 34.16214], [-118.05288, 34.16224], [-118.0528, 34.16235], [-118.05282, 34.16201], [-118.05323, 34.16201]]]} | Open Access 1 | 47857 | Kersting Court | 31803 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 0.137 | Kersting Court | 0 | Local Park 2 | 4 | |
14681 | 14681 | 14680 | {"type": "Polygon", "coordinates": [[[-118.065, 34.15919], [-118.06476, 34.1592], [-118.06476, 34.15884], [-118.065, 34.15884], [-118.065, 34.15919]]]} | Open Access 1 | 44980 | Milton & Harriet Goldberg Recreation Area | 29913 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 0.217 | Milton & Harriet Goldberg Rec. Area | 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]);