trees
2,306 rows where qSpecies_id = 15 sorted by Longitude descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68258 | 118463 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 545 Point Lobos Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 5981101.15577 | 2112608.26384 | 37.7797223901441 | -122.509010330711 | (37.7797223901441, -122.509010330711) | 11 | 6 | 2 | 55 | 26 | ||||
186768 | 118464 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 501 Point Lobos Ave | 1 | Front Yard : Yard | Tree | Private 2 | 22 | 5981239.04477 | 2112631.92257 | 37.7797954778141 | -122.508535077879 | (37.7797954778141, -122.508535077879) | 11 | 6 | 2 | 55 | 26 | ||||
73033 | 118489 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 8301 Geary Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | 5981241.64042 | 2112313.06401 | 37.778920139734 | -122.508502421445 | (37.778920139734, -122.508502421445) | 11 | 6 | 2 | 55 | 26 | ||||
69696 | 184390 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2001 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5981341.9754 | 2101226.7255 | 37.748486165253 | -122.507332592891 | (37.748486165253, -122.507332592891) | 1 | 8 | 3 | 29491 | 35 | |||
47360 | 118634 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 349 Point Lobos Ave | 3 | Side Yard : Yard | Tree | Private 2 | 16 | 5981640.48035 | 2112637.49721 | 37.7798344356349 | -122.507146773829 | (37.7798344356349, -122.507146773829) | 11 | 6 | 2 | 55 | 26 | ||||
162148 | 118635 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 349 Point Lobos Ave | 1 | Side Yard : Yard | Tree | Private 2 | 29 | 5981642.90919 | 2112624.80307 | 37.7797997243333 | -122.507137429574 | (37.7797997243333, -122.507137429574) | 11 | 6 | 2 | 55 | 26 | ||||
159644 | 120526 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1439 47th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 20 | 3x3 | 5981489 | 2105275 | 37.7596102388302 | -122.50712446854 | (37.7596102388302, -122.50712446854) | 1 | 8 | 3 | 56 | 35 | |||
123806 | 256658 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 7014 Fulton St | 1 | Back Yard : Cutout | Tree | Private 2 | 5981603 | 2109659 | 37.7716541501084 | -122.507055421099 | (37.7716541501084, -122.507055421099) | 11 | 6 | 2 | 55 | 26 | |||||
66223 | 118839 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 600 46th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 5ft | 5981667.64941 | 2111553.97712 | 37.7768610093184 | -122.506972389283 | (37.7768610093184, -122.506972389283) | 11 | 6 | 2 | 55 | 26 | |||
63888 | 254137 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1619 47th Ave | 1 | Side Yard : Yard | Tree | Private 2 | 6x6 | 5981543 | 2104041 | 37.756225206981 | -122.506846181577 | (37.756225206981, -122.506846181577) | 1 | 8 | 3 | 56 | 35 | ||||
83312 | 254136 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1623 47th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x6 | Permit Number 781075 | 5981544 | 2104016 | 37.7561566229771 | -122.506840869024 | (37.7561566229771, -122.506840869024) | 1 | 8 | 3 | 56 | 35 | |||
166636 | 184503 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1963 47th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 0ft | 5981636.5852 | 2101719.8576 | 37.7498575164936 | -122.506350418514 | (37.7498575164936, -122.506350418514) | 1 | 8 | 3 | 29491 | 35 | |||
189784 | 184502 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1963 47th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 0ft | 5981638.5485 | 2101729.1831 | 37.7498832372827 | -122.506344320901 | (37.7498832372827, -122.506344320901) | 1 | 8 | 3 | 29491 | 35 | |||
36006 | 96113 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 229 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767768 | 5982054.02521 | 2112599.84865 | 37.7797554116507 | -122.505713372558 | (37.7797554116507, -122.505713372558) | 11 | 6 | 2 | 55 | 26 |
159537 | 255244 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4300 Clement St | 1 | Front Yard : Yard | Tree | Private 2 | 5982359 | 2113083 | 37.7810999474526 | -122.504694157984 | (37.7810999474526, -122.504694157984) | 11 | 6 | 2 | 55 | 26 | |||||
137926 | 55599 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 642 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1973 12:00:00 AM | 12 | Permit Number 11573 | 5982597.22053 | 2111395.81021 | 37.7764814295387 | -122.503745058688 | (37.7764814295387, -122.503745058688) | 11 | 6 | 2 | 55 | 26 | ||
166264 | 24741 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50X Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 12x12 | 5982629.22218 | 2112591.86591 | 37.7797673297653 | -122.503722956534 | (37.7797673297653, -122.503722956534) | 11 | 6 | 2 | 55 | 26 | |||
59956 | 255159 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 4150 Clement St | 1 | Front Yard : Yard | Tree | Private 2 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | |||||
156004 | 116069 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 4150X CLEMENT ST | 3 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | ||||
188554 | 116070 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 4150X CLEMENT ST | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | ||||
122036 | 255425 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2451 43rd Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x10 | 5982976 | 2098446 | 37.740947172682 | -122.501476581088 | (37.740947172682, -122.501476581088) | 1 | 8 | 3 | 29491 | 35 | ||||
3020 | 260513 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1990 41st Ave | 1 | Back Yard : Yard | Tree | Health Dept 13 | 10x10 | 5983703 | 2101544 | 37.7494961014415 | -122.499191781388 | (37.7494961014415, -122.499191781388) | 1 | 8 | 3 | 29491 | 35 | ||||
128344 | 117975 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 428 38th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 5984094.18326 | 2112936.79035 | 37.7808004176611 | -122.498680580794 | (37.7808004176611, -122.498680580794) | 11 | 6 | 2 | 55 | 26 | |||
12856 | 117976 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 428 38th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5984094.3285 | 2112929.06261 | 37.7807792080542 | -122.498679507315 | (37.7807792080542, -122.498679507315) | 11 | 6 | 2 | 55 | 26 | |||
4854 | 117978 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 428 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5984094.13719 | 2112920.10602 | 37.7807546046446 | -122.498679507303 | (37.7807546046446, -122.498679507303) | 11 | 6 | 2 | 55 | 26 | |||
24614 | 105834 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3031 QUINTARA ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5984010.9 | 2100823.5 | 37.747535864547 | -122.498073868906 | (37.747535864547, -122.498073868906) | 1 | 8 | 3 | 29491 | 35 | ||||
143128 | 118052 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 451 36th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 8ft | 5984675.38114 | 2112718.18403 | 37.7802342573005 | -122.496653827903 | (37.7802342573005, -122.496653827903) | 11 | 6 | 2 | 55 | 26 | |||
35152 | 63257 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 465 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/1987 12:00:00 AM | 38 | Permit Number 23810 | 5984679.75149 | 2112668.94882 | 37.7800993277188 | -122.496635074658 | (37.7800993277188, -122.496635074658) | 11 | 6 | 2 | 55 | 26 | ||
56707 | 184357 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1251 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 47 | Width 0ft | 5984669.1858 | 2106580.4656 | 37.7633814703665 | -122.49622228231 | (37.7633814703665, -122.49622228231) | 1 | 8 | 3 | 56 | 35 | |||
8543 | 20492 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
20532 | 20482 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 42 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
31421 | 20481 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
37487 | 20499 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
59197 | 20485 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
81798 | 20491 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
100926 | 20493 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
108106 | 20487 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
109804 | 20484 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
109835 | 20502 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
115552 | 20498 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
126801 | 20480 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
131159 | 20503 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
132460 | 20486 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
133302 | 20483 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 4 | Median : Cutout | Tree | DPW 1 | 36 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
142506 | 20490 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
152409 | 20497 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
161235 | 20500 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
172694 | 20494 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
181967 | 20489 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
116847 | 184749 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1301 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | Width 0ft | 5984701.462 | 2106108.2846 | 37.7620868844447 | -122.496075813507 | (37.7620868844447, -122.496075813507) | 1 | 8 | 3 | 56 | 35 | |||
173301 | 184799 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1301 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 0ft | 5984696.5256 | 2105796.3452 | 37.761230097104 | -122.496069871889 | (37.761230097104, -122.496069871889) | 1 | 8 | 3 | 56 | 35 | |||
87150 | 184791 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1301 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 54 | Width 0ft | 5984706.0186 | 2105846.4681 | 37.7613682765764 | -122.496040738032 | (37.7613682765764, -122.496040738032) | 1 | 8 | 3 | 56 | 35 | |||
185275 | 186658 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 15 | Median : Yard | Tree | DPW 1 | 1 | Width 0ft | 5984710.2715 | 2105562.1346 | 37.7605878254343 | -122.496005052394 | (37.7605878254343, -122.496005052394) | 1 | 8 | 3 | 56 | 35 | |||
110383 | 186678 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 0ft | 5984707.6545 | 2105414.1158 | 37.7601812539016 | -122.496003183228 | (37.7601812539016, -122.496003183228) | 1 | 8 | 3 | 56 | 35 | |||
57748 | 186706 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 63 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | Width 0ft | 5984708.3873 | 2105079.8696 | 37.7592635500683 | -122.495975990416 | (37.7592635500683, -122.495975990416) | 1 | 8 | 3 | 56 | 35 | |||
96579 | 186687 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 0ft | 5984717.8085 | 2105322.1012 | 37.7599292022277 | -122.49596127771 | (37.7599292022277, -122.49596127771) | 1 | 8 | 3 | 56 | 35 | |||
166316 | 186684 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 0ft | 5984721.0536 | 2105370.8826 | 37.7600633323903 | -122.495953653365 | (37.7600633323903, -122.495953653365) | 1 | 8 | 3 | 56 | 35 | |||
162038 | 186672 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | Width 0ft | 5984726.183 | 2105470.3294 | 37.7603366859423 | -122.49594324988 | (37.7603366859423, -122.49594324988) | 1 | 8 | 3 | 56 | 35 | |||
38006 | 186548 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 19 | unknown : Yard | Tree | Private 2 | 11 | Width 0ft | 5984713.0979 | 2104804.2446 | 37.7585070365446 | -122.49593936599 | (37.7585070365446, -122.49593936599) | 1 | 8 | 3 | 56 | 35 | |||
103319 | 186681 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984727.3345 | 2105396.9481 | 37.7601352688354 | -122.495933853961 | (37.7601352688354, -122.495933853961) | 1 | 8 | 3 | 56 | 35 | |||
112127 | 186671 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 0ft | 5984729.9515 | 2105502.4665 | 37.7604251461527 | -122.495932587405 | (37.7604251461527, -122.495932587405) | 1 | 8 | 3 | 56 | 35 | |||
145094 | 186682 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 0ft | 5984728.5907 | 2105394.4358 | 37.7601284443346 | -122.495929324092 | (37.7601284443346, -122.495929324092) | 1 | 8 | 3 | 56 | 35 | |||
90890 | 186680 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 46 | Width 0ft | 5984729.4281 | 2105398.2043 | 37.7601388406278 | -122.495926705976 | (37.7601388406278, -122.495926705976) | 1 | 8 | 3 | 56 | 35 | |||
14265 | 20575 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
25947 | 20565 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
32606 | 20583 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
33971 | 20573 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
38436 | 20578 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
63792 | 20564 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
68779 | 20569 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
89984 | 20567 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
97961 | 20581 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
105824 | 20568 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
121384 | 20579 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
138164 | 20563 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
139556 | 20572 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
178680 | 20571 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
194226 | 20570 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
177799 | 103504 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 148 Huntington Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5984515 | 2095210 | 37.7321522522788 | -122.49591670505 | (37.7321522522788, -122.49591670505) | 1 | 8 | 4 | 64 | 35 | |||||
155725 | 186547 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 18 | unknown : Yard | Tree | Private 2 | 49 | Width 0ft | 5984724.5081 | 2104844.7562 | 37.7586189383832 | -122.495902893491 | (37.7586189383832, -122.495902893491) | 1 | 8 | 3 | 56 | 35 | |||
153837 | 186703 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 54 | Width 0ft | 5984732.2545 | 2105118.3921 | 37.759370719968 | -122.495896289119 | (37.759370719968, -122.495896289119) | 1 | 8 | 3 | 56 | 35 | |||
106273 | 186689 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 37 | Width 0ft | 5984735.6043 | 2105274.9948 | 37.7598009034706 | -122.495896256556 | (37.7598009034706, -122.495896256556) | 1 | 8 | 3 | 56 | 35 | |||
82336 | 186692 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984738.9541 | 2105253.2212 | 37.75974131543 | -122.495883065191 | (37.75974131543, -122.495883065191) | 1 | 8 | 3 | 56 | 35 | |||
192948 | 20506 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1211X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
163734 | 186707 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 0ft | 5984739.3728 | 2105071.9138 | 37.7592435204145 | -122.495868242294 | (37.7592435204145, -122.495868242294) | 1 | 8 | 3 | 56 | 35 | |||
62440 | 186536 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 7 | unknown : Yard | Tree | Private 2 | 23 | Width 0ft | 5984741.2571 | 2104889.1409 | 37.7587417873337 | -122.495848242848 | (37.7587417873337, -122.495848242848) | 1 | 8 | 3 | 56 | 35 | |||
85693 | 186709 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 66 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 0ft | 5984745.2349 | 2105033.8099 | 37.7591392410492 | -122.495845157797 | (37.7591392410492, -122.495845157797) | 1 | 8 | 3 | 56 | 35 | |||
130460 | 186424 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 42 | Width 0ft | 5984725.869 | 2104113.1411 | 37.7566102064844 | -122.495844217998 | (37.7566102064844, -122.495844217998) | 1 | 8 | 3 | 56 | 35 | |||
180771 | 186619 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 90 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 0ft | 5984733.72 | 2104360.7115 | 37.7572904258336 | -122.495835328738 | (37.7572904258336, -122.495835328738) | 1 | 8 | 3 | 56 | 35 | |||
165098 | 186701 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984752.3532 | 2105150.2151 | 37.7594592741517 | -122.495829126526 | (37.7594592741517, -122.495829126526) | 1 | 8 | 3 | 56 | 35 | |||
147972 | 186538 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 9 | unknown : Yard | Tree | Private 2 | 29 | Width 0ft | 5984747.9566 | 2104882.4413 | 37.7587237844572 | -122.495824579043 | (37.7587237844572, -122.495824579043) | 1 | 8 | 3 | 56 | 35 | |||
111969 | 186426 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984731.7311 | 2104081.3181 | 37.7565231726753 | -122.495821597656 | (37.7565231726753, -122.495821597656) | 1 | 8 | 3 | 56 | 35 | |||
150581 | 186546 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 17 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5984749.2128 | 2104853.9681 | 37.7586456785511 | -122.495818134238 | (37.7586456785511, -122.495818134238) | 1 | 8 | 3 | 56 | 35 | |||
164526 | 186446 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 0ft | 5984730.8937 | 2103910.8975 | 37.7560551959469 | -122.495811922804 | (37.7560551959469, -122.495811922804) | 1 | 8 | 3 | 56 | 35 | |||
84797 | 186549 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 20 | unknown : Yard | Tree | Private 2 | 12 | Width 0ft | 5984751.8298 | 2104797.3357 | 37.7584903350171 | -122.495804906083 | (37.7584903350171, -122.495804906083) | 1 | 8 | 3 | 56 | 35 | |||
18993 | 186454 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 0ft | 5984732.5685 | 2103876.5622 | 37.7559610188182 | -122.495803598204 | (37.7559610188182, -122.495803598204) | 1 | 8 | 3 | 56 | 35 | |||
47872 | 186423 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984740.5243 | 2104115.6534 | 37.7566179628483 | -122.495793720767 | (37.7566179628483, -122.495793720767) | 1 | 8 | 3 | 56 | 35 | |||
146584 | 186557 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 28 | unknown : Yard | Tree | Private 2 | 36 | Width 0ft | 5984754.7609 | 2104747.5076 | 37.758353692586 | -122.495791093621 | (37.758353692586, -122.495791093621) | 1 | 8 | 3 | 56 | 35 | |||
103489 | 186441 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984740.1056 | 2103964.9129 | 37.7562040467419 | -122.495784049741 | (37.7562040467419, -122.495784049741) | 1 | 8 | 3 | 56 | 35 | |||
139602 | 186545 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 16 | Median : Cutout | Tree | DPW 1 | 38 | Width 0ft | 5984760.5184 | 2104856.8992 | 37.7586543886391 | -122.495779251128 | (37.7586543886391, -122.495779251128) | 1 | 8 | 3 | 56 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );