trees
3,965 rows where qSpecies_id = 70 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33936 | 186603 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 74 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984731.2077 | 2104430.2197 | 37.7574811288953 | -122.495849144448 | (37.7574811288953, -122.495849144448) | 1 | 8 | 3 | 56 | 35 | |||
166048 | 186609 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 80 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984732.0451 | 2104419.3328 | 37.7574512855375 | -122.495845445346 | (37.7574512855375, -122.495845445346) | 1 | 8 | 3 | 56 | 35 | |||
122288 | 186537 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 8 | unknown : Yard | Tree | Private 2 | 14 | Width 0ft | 5984743.3507 | 2104891.2345 | 37.7587476583889 | -122.495841156765 | (37.7587476583889, -122.495841156765) | 1 | 8 | 3 | 56 | 35 | |||
119830 | 186608 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 79 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984734.9762 | 2104426.0324 | 37.7574698524378 | -122.495835802783 | (37.7574698524378, -122.495835802783) | 1 | 8 | 3 | 56 | 35 | |||
96224 | 186541 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 12 | unknown : Yard | Tree | Private 2 | 7 | Width 0ft | 5984745.863 | 2104876.5792 | 37.7587075661518 | -122.495831387136 | (37.7587075661518, -122.495831387136) | 1 | 8 | 3 | 56 | 35 | |||
99469 | 186539 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 10 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984748.3754 | 2104879.0915 | 37.7587146113666 | -122.49582288356 | (37.7587146113666, -122.49582288356) | 1 | 8 | 3 | 56 | 35 | |||
174482 | 186612 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 83 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984740.0009 | 2104413.4707 | 37.7574356557736 | -122.49581749901 | (37.7574356557736, -122.49581749901) | 1 | 8 | 3 | 56 | 35 | |||
40525 | 186606 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 77 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984755.9124 | 2104439.8503 | 37.7575090186635 | -122.495764417358 | (37.7575090186635, -122.495764417358) | 1 | 8 | 3 | 56 | 35 | |||
107805 | 186613 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 84 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984762.1933 | 2104405.0962 | 37.7574139613926 | -122.495740132277 | (37.7574139613926, -122.495740132277) | 1 | 8 | 3 | 56 | 35 | |||
93721 | 20611 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1403X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 5984795.0202245 | 2105623.5542948 | 37.7607614301436 | -122.495716480052 | (37.7607614301436, -122.495716480052) | 1 | 8 | 3 | 56 | 35 | ||||
111008 | 186598 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984775.1737 | 2104452.8307 | 37.7575457872194 | -122.495698762477 | (37.7575457872194, -122.495698762477) | 1 | 8 | 3 | 56 | 35 | |||
42290 | 186524 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 0ft | 5984779.5703 | 2104623.8794 | 37.7580156968567 | -122.495696174096 | (37.7580156968567, -122.495696174096) | 1 | 8 | 3 | 56 | 35 | |||
105641 | 186614 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 85 | Sidewalk: Property side : Yard | Tree | Private 2 | 57 | Width 0ft | 5984775.1737 | 2104397.9779 | 37.7573951766754 | -122.495694716519 | (37.7573951766754, -122.495694716519) | 1 | 8 | 3 | 56 | 35 | |||
20381 | 186821 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 105 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984828.6477 | 2106722.4547 | 37.7637806720109 | -122.495681237536 | (37.7637806720109, -122.495681237536) | 1 | 8 | 3 | 56 | 35 | |||
28878 | 256354 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 120 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 0ft | 5984828.6477 | 2106722.4547 | 37.7637806720109 | -122.495681237536 | (37.7637806720109, -122.495681237536) | 1 | 8 | 3 | 56 | 35 | ||||
70337 | 256353 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 119 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 0ft | 5984828.6477 | 2106722.4547 | 37.7637806720109 | -122.495681237536 | (37.7637806720109, -122.495681237536) | 1 | 8 | 3 | 56 | 35 | ||||
74460 | 184341 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Sunset Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 0ft | 5984820.4722 | 2106002.1759 | 37.7618025096536 | -122.495656382261 | (37.7618025096536, -122.495656382261) | 1 | 8 | 3 | 56 | 35 | |||
83227 | 186802 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 80 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984846.4625 | 2106932.8738 | 37.7643594669603 | -122.495635143928 | (37.7643594669603, -122.495635143928) | 1 | 8 | 3 | 56 | 35 | |||
24387 | 186825 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 100 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984841.1725 | 2106636.9913 | 37.7635467469683 | -122.4956316146 | (37.7635467469683, -122.4956316146) | 1 | 8 | 3 | 56 | 35 | |||
13033 | 20683 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1505X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984801 | 2104643 | 37.7580694516324 | -122.495623472482 | (37.7580694516324, -122.495623472482) | 1 | 8 | 3 | 56 | 35 | |||
9883 | 262003 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1503X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 5984810 | 2104956 | 37.7589293895364 | -122.495615433308 | (37.7589293895364, -122.495615433308) | 1 | 8 | 3 | 56 | 35 | ||||
152369 | 118277 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5940 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5984912.75175 | 2109761.00867 | 37.772128606737 | -122.495614486107 | (37.772128606737, -122.495614486107) | 11 | 6 | 2 | 55 | 26 | |||
167611 | 186790 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984851.9007 | 2106879.5275 | 37.7642133114728 | -122.495612399957 | (37.7642133114728, -122.495612399957) | 1 | 8 | 3 | 56 | 35 | |||
92676 | 186788 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984852.1597 | 2106871.2408 | 37.7641905736904 | -122.495610892905 | (37.7641905736904, -122.495610892905) | 1 | 8 | 3 | 56 | 35 | |||
155504 | 20681 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1503X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984815.4830729 | 2104956.7094961 | 37.7589316586961 | -122.49559652289 | (37.7589316586961, -122.49559652289) | 1 | 8 | 3 | 56 | 35 | |||
49502 | 186787 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984857.5979 | 2106862.436 | 37.7641667166364 | -122.495591434544 | (37.7641667166364, -122.495591434544) | 1 | 8 | 3 | 56 | 35 | |||
63377 | 186795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984860.9644 | 2106903.0931 | 37.7642785467413 | -122.495582789943 | (37.7642785467413, -122.495582789943) | 1 | 8 | 3 | 56 | 35 | |||
81805 | 186794 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984862.0002 | 2106886.7785 | 37.7642338120894 | -122.495578004049 | (37.7642338120894, -122.495578004049) | 1 | 8 | 3 | 56 | 35 | |||
85536 | 186746 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984859.6573 | 2106664.9352 | 37.7636245555119 | -122.495569743679 | (37.7636245555119, -122.495569743679) | 1 | 8 | 3 | 56 | 35 | |||
187193 | 186789 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 63 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984864.8488 | 2106874.8662 | 37.7642012710686 | -122.495567273023 | (37.7642012710686, -122.495567273023) | 1 | 8 | 3 | 56 | 35 | |||
72468 | 118276 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5934 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5984926.42088 | 2109761.1061 | 37.7721296746889 | -122.495567211351 | (37.7721296746889, -122.495567211351) | 11 | 6 | 2 | 55 | 26 | |||
138067 | 186744 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984860.6275 | 2106655.7179 | 37.7635993042063 | -122.495565708229 | (37.7635993042063, -122.495565708229) | 1 | 8 | 3 | 56 | 35 | |||
54412 | 186710 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984849.6082 | 2106100.3016 | 37.7620736415169 | -122.49556285166 | (37.7620736415169, -122.49556285166) | 1 | 8 | 3 | 56 | 35 | |||
194113 | 181562 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984861.0859 | 2106095.0617 | 37.7620599263149 | -122.495522768827 | (37.7620599263149, -122.495522768827) | 1 | 8 | 3 | 56 | 35 | |||
191135 | 181560 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984861.3745 | 2106086.3243 | 37.7620359527601 | -122.49552112623 | (37.7620359527601, -122.49552112623) | 1 | 8 | 3 | 56 | 35 | |||
115543 | 186714 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984862.1463 | 2106121.4837 | 37.7621325358214 | -122.495521050211 | (37.7621325358214, -122.495521050211) | 1 | 8 | 3 | 56 | 35 | |||
166412 | 186712 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984862.5222 | 2106113.9651 | 37.7621119138624 | -122.495519195577 | (37.7621119138624, -122.495519195577) | 1 | 8 | 3 | 56 | 35 | |||
134633 | 181558 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984865.8302 | 2106073.5142 | 37.762001040719 | -122.495504771076 | (37.762001040719, -122.495504771076) | 1 | 8 | 3 | 56 | 35 | |||
187509 | 181561 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984871.9567 | 2106086.8812 | 37.7620381014978 | -122.49548456812 | (37.7620381014978, -122.49548456812) | 1 | 8 | 3 | 56 | 35 | |||
165800 | 181565 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984872.5636 | 2106101.5491 | 37.7620784109817 | -122.495483550979 | (37.7620784109817, -122.495483550979) | 1 | 8 | 3 | 56 | 35 | |||
108565 | 181563 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5984874.1846 | 2106092.4508 | 37.7620535245146 | -122.495477273587 | (37.7620535245146, -122.495477273587) | 1 | 8 | 3 | 56 | 35 | |||
172507 | 181501 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984882.2605 | 2105466.1502 | 37.7603343510083 | -122.495403150426 | (37.7603343510083, -122.495403150426) | 1 | 8 | 3 | 56 | 35 | |||
3500 | 186187 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1701 Sunset Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 0ft | 5984844.928 | 2103185.6655 | 37.7540705871913 | -122.495364076569 | (37.7540705871913, -122.495364076569) | 1 | 8 | 3 | 56 | 35 | |||
134009 | 181500 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984893.9566 | 2105458.3528 | 37.7603136263541 | -122.495362124611 | (37.7603136263541, -122.495362124611) | 1 | 8 | 3 | 56 | 35 | |||
56916 | 186372 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5984837.3524 | 2102531.5146 | 37.7522740255983 | -122.495342034865 | (37.7522740255983, -122.495342034865) | 1 | 8 | 3 | 56 | 35 | |||
33261 | 186326 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 37th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 0ft | 5984848.6398 | 2102773.7313 | 37.7529397468326 | -122.495320863188 | (37.7529397468326, -122.495320863188) | 1 | 8 | 3 | 56 | 35 | |||
114862 | 186329 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 37th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 0ft | 5984856.9428 | 2102508.5696 | 37.7522121719589 | -122.495272597217 | (37.7522121719589, -122.495272597217) | 1 | 8 | 3 | 56 | 35 | |||
141492 | 181681 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1312 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5984943.9136 | 2106255.5412 | 37.7625054078197 | -122.495248139145 | (37.7625054078197, -122.495248139145) | 1 | 8 | 3 | 56 | 35 | |||
68848 | 181393 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984912.5728 | 2104566.45 | 37.7578657995745 | -122.495231966638 | (37.7578657995745, -122.495231966638) | 1 | 8 | 3 | 56 | 35 | |||
20901 | 181396 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984914.2437 | 2104590.3992 | 37.757931655251 | -122.495227954147 | (37.757931655251, -122.495227954147) | 1 | 8 | 3 | 56 | 35 | |||
153820 | 185996 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 0ft | 5984845.7236 | 2100974.1524 | 37.7479984261704 | -122.495198251611 | (37.7479984261704, -122.495198251611) | 1 | 8 | 3 | 29491 | 35 | |||
22707 | 184072 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984928.5463 | 2103997.684 | 37.7563050611127 | -122.495134783659 | (37.7563050611127, -122.495134783659) | 1 | 8 | 3 | 56 | 35 | |||
132130 | 184075 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600 Sunset Blvd | 76 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984932.9377 | 2104018.8187 | 37.7563633482366 | -122.495121155332 | (37.7563633482366, -122.495121155332) | 1 | 8 | 3 | 56 | 35 | |||
64234 | 186054 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1901 Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 5984883.1421 | 2101650.8712 | 37.7498587015448 | -122.495118756032 | (37.7498587015448, -122.495118756032) | 1 | 8 | 3 | 29491 | 35 | |||
67175 | 20843 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1803X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984917.6591811 | 2102927.8209446 | 37.7533668754054 | -122.495093546212 | (37.7533668754054, -122.495093546212) | 1 | 8 | 3 | 56 | 35 | |||
170615 | 20846 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1803X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 10 | 5984917.6591811 | 2102927.8209446 | 37.7533668754054 | -122.495093546212 | (37.7533668754054, -122.495093546212) | 1 | 8 | 3 | 56 | 35 | |||
144398 | 185717 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2101 Sunset Blvd | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984895.0862 | 2100394.2234 | 37.7464089891691 | -122.494984805259 | (37.7464089891691, -122.494984805259) | 1 | 8 | 3 | 29491 | 35 | |||
106180 | 185720 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2101 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 0ft | 5984894.4324 | 2100359.2446 | 37.7463129086346 | -122.494984487249 | (37.7463129086346, -122.494984487249) | 1 | 8 | 3 | 29491 | 35 | |||
38640 | 20923 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1903X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984941.4072484 | 2102249.5254402 | 37.7515058528251 | -122.494961411572 | (37.7515058528251, -122.494961411572) | 1 | 8 | 3 | 29491 | 35 | |||
59275 | 185661 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2101 Sunset Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 5984918.7868 | 2100743.1942 | 37.7473685553138 | -122.494928578961 | (37.7473685553138, -122.494928578961) | 1 | 8 | 3 | 29491 | 35 | |||
188661 | 113700 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3315 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5985186.78495 | 2113160.2672 | 37.78147803947 | -122.494917278462 | (37.78147803947, -122.494917278462) | 11 | 6 | 2 | 55 | 26 | |||
22316 | 185668 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2101 Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 0ft | 5984929.7381 | 2100287.489 | 37.7461179540332 | -122.494857116456 | (37.7461179540332, -122.494857116456) | 1 | 8 | 3 | 29491 | 35 | |||
87591 | 21092 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984939.7729333 | 2100224.5013029 | 37.7459455943524 | -122.494817774566 | (37.7459455943524, -122.494817774566) | 1 | 8 | 3 | 29491 | 35 | |||
145752 | 21090 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984939.7729333 | 2100224.5013029 | 37.7459455943524 | -122.494817774566 | (37.7459455943524, -122.494817774566) | 1 | 8 | 3 | 29491 | 35 | |||
70171 | 21015 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2005X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984974.2355899 | 2101546.5171136 | 37.7495775063784 | -122.494796062289 | (37.7495775063784, -122.494796062289) | 1 | 8 | 3 | 29491 | 35 | |||
40809 | 21052 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2103X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5984987.6230273 | 2100889.8482373 | 37.7477752566644 | -122.494701361992 | (37.7477752566644, -122.494701361992) | 1 | 8 | 3 | 29491 | 35 | ||||
120194 | 21058 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2103X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 10 | 5984987.6230273 | 2100889.8482373 | 37.7477752566644 | -122.494701361992 | (37.7477752566644, -122.494701361992) | 1 | 8 | 3 | 29491 | 35 | |||
120374 | 187196 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2301 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984952.6117 | 2099047.6172 | 37.7427149412723 | -122.494686630601 | (37.7427149412723, -122.494686630601) | 1 | 8 | 3 | 29491 | 35 | |||
31394 | 21123 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2203X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5985013.3358538 | 2100217.4790898 | 37.745930619038 | -122.494562890162 | (37.745930619038, -122.494562890162) | 1 | 8 | 3 | 29491 | 35 | |||
20221 | 187212 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2401 Sunset Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 0ft | 5984988.5085 | 2098705.0047 | 37.741776320928 | -122.494537260078 | (37.741776320928, -122.494537260078) | 1 | 8 | 3 | 29491 | 35 | |||
79386 | 21282 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2492X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | 1 | 8 | 3 | 29491 | 35 | |||
49691 | 187311 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Sunset Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 0ft | 5985029.7981 | 2099790.3768 | 37.744758875599 | -122.494474487801 | (37.744758875599, -122.494474487801) | 1 | 8 | 3 | 29491 | 35 | |||
41950 | 187309 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Sunset Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5985032.6323 | 2099705.3521 | 37.7445255867006 | -122.494458421341 | (37.7445255867006, -122.494458421341) | 1 | 8 | 3 | 29491 | 35 | |||
21150 | 187379 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985060.734 | 2100052.5124 | 37.7454804393236 | -122.494386838151 | (37.7454804393236, -122.494386838151) | 1 | 8 | 3 | 29491 | 35 | |||
128901 | 256427 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3001 Sunset Blvd | 15 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
130062 | 256429 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3001 Sunset Blvd | 17 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
162729 | 187378 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985080.0311 | 2100042.6945 | 37.7454546113395 | -122.494319389248 | (37.7454546113395, -122.494319389248) | 1 | 8 | 3 | 29491 | 35 | |||
60101 | 21258 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2403X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10 | 5985057.6849308 | 2098850.8710983 | 37.7421808791716 | -122.494308823721 | (37.7421808791716, -122.494308823721) | 1 | 8 | 3 | 29491 | 35 | |||
175665 | 21256 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2403X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5985057.6849308 | 2098850.8710983 | 37.7421808791716 | -122.494308823721 | (37.7421808791716, -122.494308823721) | 1 | 8 | 3 | 29491 | 35 | |||
50850 | 184998 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2701 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985034.7824 | 2096514.6659 | 37.735764946565 | -122.494215856511 | (37.735764946565, -122.494215856511) | 1 | 8 | 3 | 29491 | 35 | |||
76076 | 185010 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2701 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 0ft | 5985035.2011 | 2096476.1433 | 37.735659198289 | -122.494211570428 | (37.735659198289, -122.494211570428) | 1 | 8 | 3 | 29491 | 35 | |||
127855 | 185005 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2701 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985036.876 | 2096499.1731 | 37.7357225299847 | -122.494207476657 | (37.7357225299847, -122.494207476657) | 1 | 8 | 3 | 29491 | 35 | |||
50964 | 185006 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2701 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985037.2948 | 2096494.1484 | 37.7357087580069 | -122.494205658486 | (37.7357087580069, -122.494205658486) | 1 | 8 | 3 | 29491 | 35 | |||
120652 | 185012 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2701 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985038.9697 | 2096467.7688 | 37.7356364246768 | -122.494197924056 | (37.7356364246768, -122.494197924056) | 1 | 8 | 3 | 29491 | 35 | |||
180239 | 185008 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2701 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985039.8071 | 2096490.3799 | 37.7356985577254 | -122.494196694943 | (37.7356985577254, -122.494196694943) | 1 | 8 | 3 | 29491 | 35 | |||
27431 | 185014 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2701 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985039.8071 | 2096458.9756 | 37.7356123298987 | -122.494194380975 | (37.7356123298987, -122.494194380975) | 1 | 8 | 3 | 29491 | 35 | |||
94565 | 745 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2201X 36th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6 | 5985120.8379 | 2099719.0966 | 37.7445684872167 | -122.494154441515 | (37.7445684872167, -122.494154441515) | 1 | 8 | 3 | 29491 | 35 | |||
56647 | 21481 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2792X Sunset Blvd | 4 | Median : Cutout | Tree | DPW 1 | 10 | 60 | 5985060.3629888 | 2096294.4798015 | 37.7351618711636 | -122.49411119238 | (37.7351618711636, -122.49411119238) | 1 | 8 | 3 | 29491 | 35 | |||
86638 | 21482 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2792X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5985060.3629888 | 2096294.4798015 | 37.7351618711636 | -122.49411119238 | (37.7351618711636, -122.49411119238) | 1 | 8 | 3 | 29491 | 35 | |||
184984 | 21502 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5985062.864215 | 2096221.8871717 | 37.7349626975104 | -122.494097196305 | (37.7349626975104, -122.494097196305) | 1 | 8 | 3 | 29491 | 35 | |||
144308 | 748 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2301X 36th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6 | 5985137.3758 | 2099321.1031 | 37.7434766724968 | -122.494067930541 | (37.7434766724968, -122.494067930541) | 1 | 8 | 3 | 29491 | 35 | |||
114161 | 185460 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2400 Sunset Blvd | 10 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985122.4012 | 2098351.0376 | 37.7408122581003 | -122.494048228448 | (37.7408122581003, -122.494048228448) | 1 | 8 | 3 | 29491 | 35 | |||
144406 | 185486 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2400 Sunset Blvd | 39 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985131.6978 | 2098522.3598 | 37.7412832067047 | -122.494028708144 | (37.7412832067047, -122.494028708144) | 1 | 8 | 3 | 29491 | 35 | |||
166894 | 185483 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2400 Sunset Blvd | 36 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985132.3618 | 2098506.4228 | 37.7412394868472 | -122.494025238023 | (37.7412394868472, -122.494025238023) | 1 | 8 | 3 | 29491 | 35 | |||
162386 | 185167 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2500 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985126.7175 | 2097707.2515 | 37.7390448470195 | -122.493985870015 | (37.7390448470195, -122.493985870015) | 1 | 8 | 3 | 29491 | 35 | |||
73646 | 185188 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2500 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5985136.014 | 2097861.9726 | 37.7394702135829 | -122.493965126981 | (37.7394702135829, -122.493965126981) | 1 | 8 | 3 | 29491 | 35 | |||
25156 | 185173 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2500 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985147.9667 | 2097768.3431 | 37.7392138314574 | -122.493916902067 | (37.7392138314574, -122.493916902067) | 1 | 8 | 3 | 29491 | 35 | |||
67289 | 187116 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2600 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985139.0056 | 2097294.5581 | 37.7379124205271 | -122.493912978366 | (37.7379124205271, -122.493912978366) | 1 | 8 | 3 | 29491 | 35 | |||
143721 | 185170 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2500 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985158.5914 | 2097729.8288 | 37.7391087031592 | -122.493877329625 | (37.7391087031592, -122.493877329625) | 1 | 8 | 3 | 29491 | 35 | |||
122016 | 185199 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2500 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985167.8879 | 2097938.3372 | 37.7396817551847 | -122.493860548712 | (37.7396817551847, -122.493860548712) | 1 | 8 | 3 | 29491 | 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) );