trees
3,965 rows where qSpecies_id = 70 sorted by qSiteInfo 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
142717 | 200159 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1043 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 9 | Width 0ft | 6013947.408 | 2089985.5634 | 37.719486864857 | -122.393795976203 | (37.719486864857, -122.393795976203) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
185980 | 200237 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 919 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 6014571.1757 | 2089512.0366 | 37.7182212977035 | -122.39160673351 | (37.7182212977035, -122.39160673351) | 10 | 3 | 8 | 58 | 1 | |||
74264 | 89023 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2x Hollywood Ct | 1 | unknown : Cutout | Tree | DPW 1 | 6000329 | 2088600 | 37.714916215224 | -122.440770357879 | (37.714916215224, -122.440770357879) | 9 | 7 | 6 | 28861 | 5 | |||||
6698 | 261941 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Verna St | 6 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
34078 | 106506 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3975 22nd St | 2 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 773291 | 6002049 | 2102913 | 37.7543142223274 | -122.435848813122 | (37.7543142223274, -122.435848813122) | 2 | 4 | 5 | 28862 | 22 | ||||
74587 | 258628 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 95 Banks St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 6008696 | 2098147 | 37.7416031915622 | -122.412524842458 | (37.7416031915622, -122.412524842458) | 10 | 7 | 7 | 28859 | 2 | ||||
112586 | 106503 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3974 22nd St | 1 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 773286 | 6002049 | 2102947 | 37.754407578182 | -122.435851245675 | (37.754407578182, -122.435851245675) | 2 | 4 | 5 | 28862 | 22 | ||||
122902 | 253983 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 438X Detroit St | 2 | Unaccepted Street : Yard | Tree | Private 2 | 10x10 | 5999326 | 2094622 | 37.7313940668699 | -122.444669716777 | (37.7313940668699, -122.444669716777) | 9 | 7 | 4 | 59 | 40 | ||||
130598 | 106504 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3974 22nd St | 2 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 773286 | 6002049 | 2102947 | 37.754407578182 | -122.435851245675 | (37.754407578182, -122.435851245675) | 2 | 4 | 5 | 28862 | 22 | ||||
131481 | 106505 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3975 22nd St | 1 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 773291 | 6002049 | 2102913 | 37.7543142223274 | -122.435848813122 | (37.7543142223274, -122.435848813122) | 2 | 4 | 5 | 28862 | 22 | ||||
1816 | 123121 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 586 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5992562.41321 | 2111484.60446 | 37.7773061204935 | -122.469279388077 | (37.7773061204935, -122.469279388077) | 11 | 6 | 2 | 54 | 11 | |||
2088 | 203278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 618 Detroit St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5999459.31749 | 2095070.52066 | 37.7326332062613 | -122.444241033706 | (37.7326332062613, -122.444241033706) | 9 | 7 | 4 | 63 | 40 | |||
3042 | 184887 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 75 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984636.53 | 2106768.6166 | 37.7638961671737 | -122.496349110122 | (37.7638961671737, -122.496349110122) | 1 | 8 | 3 | 56 | 35 | |||
3855 | 203845 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 535 Castenada Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 5992715.17465 | 2100010.79955 | 37.7458108948644 | -122.467916186599 | (37.7458108948644, -122.467916186599) | 1 | 8 | 4 | 29491 | 40 | |||
4735 | 262469 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 35 Broadmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2x6 | 5991096 | 2093545 | 37.7279638199594 | -122.4730435743 | (37.7279638199594, -122.4730435743) | 9 | 8 | 4 | 64 | 40 | ||||
5033 | 186921 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985168.1725 | 2096748.5598 | 37.7364149616327 | -122.493771912003 | (37.7364149616327, -122.493771912003) | 1 | 8 | 3 | 29491 | 35 | |||
5486 | 203905 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5000 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 8ft | 5990628.48581 | 2093315.14661 | 37.7273056215527 | -122.474642998573 | (37.7273056215527, -122.474642998573) | 9 | 8 | 4 | 64 | 40 | |||
5793 | 125253 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 20 Reed St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6008205.34429 | 2117069.05453 | 37.7935311907562 | -122.415560743551 | (37.7935311907562, -122.415560743551) | 5 | 1 | 10 | 28858 | 21 | ||||
7206 | 264879 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 94 Stratford Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4x6 | 5990921 | 2091777 | 37.7230991995598 | -122.473519640019 | (37.7230991995598, -122.473519640019) | 9 | 8 | 4 | 64 | 40 | ||||
8318 | 98543 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
8592 | 186947 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985208.6903 | 2095991.5414 | 37.7343387611716 | -122.493576064205 | (37.7343387611716, -122.493576064205) | 1 | 8 | 3 | 29491 | 35 | |||
10158 | 203254 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 355 Hazelwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5996025.0602 | 2095489.12153 | 37.7335860541429 | -122.456144283154 | (37.7335860541429, -122.456144283154) | 9 | 7 | 4 | 59 | 40 | |||
11390 | 186929 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5985223.4885 | 2095932.3487 | 37.7341770994248 | -122.493520542824 | (37.7341770994248, -122.493520542824) | 1 | 8 | 3 | 29491 | 35 | |||
11391 | 260515 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 487 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 784711 | 5989595 | 2094714 | 37.7310865793073 | -122.478317956131 | (37.7310865793073, -122.478317956131) | 1 | 8 | 4 | 64 | 14 | |||
12649 | 157063 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1617 Plymouth Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 0 | Width 10ft | 5995578.39636 | 2094696.59169 | 37.7313843105403 | -122.457631195237 | (37.7313843105403, -122.457631195237) | 9 | 7 | 4 | 59 | 40 | |||
12733 | 102843 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
12775 | 260566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Denslowe Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 5990592.24818 | 2090826.09743 | 37.7204692135739 | -122.474586693137 | (37.7204692135739, -122.474586693137) | 9 | 8 | 4 | 64 | 40 | |||||
13685 | 261983 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2403 Keith St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | |||||
15118 | 247553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista Ave West | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6000067.12392 | 2108379.27144 | 37.7692104712049 | -122.443095172401 | (37.7692104712049, -122.443095172401) | 15 | 5 | 11 | 29492 | 9 | |||
18624 | 184510 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1975 42nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5983188.0663 | 2101709.4842 | 37.7499202536606 | -122.500984645445 | (37.7499202536606, -122.500984645445) | 1 | 8 | 3 | 29491 | 35 | |||
19477 | 203874 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Sargent St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5993391.13026 | 2089210.06391 | 37.7161937512299 | -122.464794638879 | (37.7161937512299, -122.464794638879) | 9 | 8 | 6 | 64 | 24 | |||
19486 | 186864 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985200.7204 | 2096355.2343 | 37.7353368988439 | -122.493630408308 | (37.7353368988439, -122.493630408308) | 1 | 8 | 3 | 29491 | 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 | |||
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 | |||
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 | |||
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 | |||
23323 | 203284 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 436 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 5999187.02892 | 2095000.6796 | 37.73242590082 | -122.445177379037 | (37.73242590082, -122.445177379037) | 9 | 7 | 4 | 59 | 40 | |||
23871 | 184829 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984677.5396 | 2106895.0631 | 37.7642457559536 | -122.496216602354 | (37.7642457559536, -122.496216602354) | 1 | 8 | 3 | 56 | 35 | |||
24174 | 123143 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 582 10th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 5ft | 5992871.73325 | 2111517.59924 | 37.7774145847454 | -122.468211760136 | (37.7774145847454, -122.468211760136) | 11 | 6 | 2 | 54 | 11 | |||
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 | |||
24647 | 186862 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985163.1298 | 2096349.2748 | 37.7353183364912 | -122.493759932025 | (37.7353183364912, -122.493759932025) | 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 | |||
26908 | 203269 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 61 Burnside Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6001195.67234 | 2095721.17604 | 37.7345186646045 | -122.438284639447 | (37.7345186646045, -122.438284639447) | 2 | 7 | 5 | 63 | 7 | ||||
27003 | 184514 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1975 42nd Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5983188.0663 | 2101693.9168 | 37.749877509903 | -122.500983494265 | (37.749877509903, -122.500983494265) | 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 | |||
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 | ||||
29207 | 123189 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 579 09th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5993119.32976 | 2111553.1452 | 37.7775264810981 | -122.467357835096 | (37.7775264810981, -122.467357835096) | 11 | 6 | 2 | 54 | 11 | |||
31813 | 203888 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 177 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 2ft | 5990956.3868 | 2094658.3857 | 37.7310128131833 | -122.473607398684 | (37.7310128131833, -122.473607398684) | 9 | 8 | 4 | 64 | 40 | |||
31929 | 186867 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2700 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985177.3409 | 2096363.4859 | 37.7353581877907 | -122.493711846576 | (37.7353581877907, -122.493711846576) | 1 | 8 | 3 | 29491 | 35 | |||
32030 | 184888 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 77 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984676.0208 | 2106738.9985 | 37.7638171575071 | -122.496210339991 | (37.7638171575071, -122.496210339991) | 1 | 8 | 3 | 56 | 35 | |||
32089 | 106242 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 De Haro St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Permit Number 770844 | 6012041.04445 | 2105749.16688 | 37.7626642466674 | -122.401492899679 | (37.7626642466674, -122.401492899679) | 8 | 3 | 8 | 28856 | 29 | |||
33143 | 116090 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 98x WOODWARD ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006422 | 2107919 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | 8 | 4 | 7 | 28853 | 19 | ||||
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 | |||
35217 | 184777 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984706.0186 | 2105944.056 | 37.7616362256202 | -122.496047937787 | (37.7616362256202, -122.496047937787) | 1 | 8 | 3 | 56 | 35 | |||
35600 | 184852 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984650.5796 | 2106852.1548 | 37.7641263625826 | -122.496306681732 | (37.7641263625826, -122.496306681732) | 1 | 8 | 3 | 56 | 35 | |||
35677 | 184848 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984690.0704 | 2106845.3199 | 37.7641099091262 | -122.496169592258 | (37.7641099091262, -122.496169592258) | 1 | 8 | 3 | 56 | 35 | |||
36576 | 184846 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984679.0585 | 2106853.294 | 37.764131158732 | -122.496208267019 | (37.764131158732, -122.496208267019) | 1 | 8 | 3 | 56 | 35 | |||
36729 | 123117 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 562 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 3ft | 5992559.61492 | 2111614.34874 | 37.7776622014062 | -122.469298514108 | (37.7776622014062, -122.469298514108) | 11 | 6 | 2 | 54 | 11 | |||
38717 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
39243 | 110886 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
39726 | 203249 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 380 Valdez Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5995787.98942 | 2095468.33628 | 37.7335153719345 | -122.456962397309 | (37.7335153719345, -122.456962397309) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
41350 | 203279 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 59 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 5999700.96572 | 2095477.61898 | 37.7337647863229 | -122.44343483107 | (37.7337647863229, -122.44343483107) | 9 | 7 | 4 | 63 | 40 | |||
41461 | 203906 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4996 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5990638.47075 | 2093500.44016 | 37.727814969685 | -122.47462199853 | (37.727814969685, -122.47462199853) | 9 | 8 | 4 | 64 | 40 | |||
41828 | 184862 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984672.6033 | 2106838.8646 | 37.764091161537 | -122.496229528652 | (37.764091161537, -122.496229528652) | 1 | 8 | 3 | 56 | 35 | |||
41920 | 203836 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 386 Hazelwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5995958.60933 | 2095699.73792 | 37.7341605410715 | -122.456389245893 | (37.7341605410715, -122.456389245893) | 9 | 7 | 4 | 59 | 40 | |||
41962 | 184847 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984668.0467 | 2106854.8129 | 37.7641346841684 | -122.496246465144 | (37.7641346841684, -122.496246465144) | 1 | 8 | 3 | 56 | 35 | |||
43875 | 184830 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984698.4242 | 2106894.3037 | 37.7642448941783 | -122.49614431352 | (37.7642448941783, -122.49614431352) | 1 | 8 | 3 | 56 | 35 | |||
44638 | 173859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 118 Saint Mary's Ave | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.7352888053199 | -122.42875656067 | (37.7352888053199, -122.42875656067) | 2 | 7 | 5 | 63 | 7 | ||||
44642 | 187763 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 135 Reardon Rd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6018954.68397 | 2093453.67115 | 37.7292866202724 | -122.376727902495 | (37.7292866202724, -122.376727902495) | 10 | 3 | 8 | 58 | 1 | ||||
45033 | 203285 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 436 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 5999181.66056 | 2095001.81408 | 37.7324287094117 | -122.445196020186 | (37.7324287094117, -122.445196020186) | 9 | 7 | 4 | 59 | 40 | |||
45189 | 184853 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984637.6691 | 2106845.6996 | 37.7641078821268 | -122.496350858396 | (37.7641078821268, -122.496350858396) | 1 | 8 | 3 | 56 | 35 | |||
45528 | 123191 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 571 09th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 9ft | 5993121.2243 | 2111602.66813 | 37.7776625670642 | -122.467354883235 | (37.7776625670642, -122.467354883235) | 11 | 6 | 2 | 54 | 11 | |||
45747 | 201375 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Fairfax Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 6018327.36542 | 2095666.89439 | 37.7353291318294 | -122.379050271262 | (37.7353291318294, -122.379050271262) | 10 | 3 | 8 | 58 | 1 | ||||
46787 | 186933 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985210.7082 | 2095939.4114 | 37.734195744096 | -122.493565247951 | (37.734195744096, -122.493565247951) | 1 | 8 | 3 | 29491 | 35 | |||
49117 | 186616 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 87 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984717.3898 | 2104397.9779 | 37.7573917926116 | -122.495894553165 | (37.7573917926116, -122.495894553165) | 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 | |||
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 | |||
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 | |||
51177 | 221409 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Thor Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 3ft | 6002231.18225 | 2096094.99891 | 37.735603938579 | -122.434731265154 | (37.735603938579, -122.434731265154) | 2 | 7 | 5 | 63 | 7 | |||
51410 | 187757 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6017577.45499 | 2093289.42876 | 37.7287597011768 | -122.38147773753 | (37.7287597011768, -122.38147773753) | 10 | 3 | 8 | 58 | 1 | ||||
52910 | 203779 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 788 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 10ft | 5994915.16771 | 2093240.53783 | 37.7273482188287 | -122.459818653129 | (37.7273482188287, -122.459818653129) | 9 | 7 | 4 | 28861 | 40 | |||
53303 | 184881 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 0ft | 5984647.1621 | 2106788.362 | 37.7639510053125 | -122.496313794444 | (37.7639510053125, -122.496313794444) | 1 | 8 | 3 | 56 | 35 | |||
53341 | 255638 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 220 Masonic Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999023 | 2112089 | 37.7793368479896 | -122.446973720271 | (37.7793368479896, -122.446973720271) | 15 | 5 | 1 | 54 | 16 | |||||
54313 | 184883 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984691.969 | 2106787.6025 | 37.7639515445938 | -122.496158767034 | (37.7639515445938, -122.496158767034) | 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 | |||
54617 | 203846 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 535 Castenada Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 2ft | 5992716.66984 | 2100005.43095 | 37.7457962404004 | -122.467910626074 | (37.7457962404004, -122.467910626074) | 1 | 8 | 4 | 29491 | 40 | |||
54660 | 116089 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 98x WOODWARD ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006422 | 2107919 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | 8 | 4 | 7 | 28853 | 19 | ||||
54987 | 187761 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6017511.07328 | 2093334.48306 | 37.7288797462969 | -122.381710357951 | (37.7288797462969, -122.381710357951) | 10 | 3 | 8 | 58 | 1 | ||||
56374 | 186953 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985200.1141 | 2096083.1893 | 37.7345899002243 | -122.49361246529 | (37.7345899002243, -122.49361246529) | 1 | 8 | 3 | 29491 | 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 | |||
57110 | 125268 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000 Van Ness Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 9ft | 6005626.14224 | 2120703.55494 | 37.8033652908254 | -122.42474367328 | (37.8033652908254, -122.42474367328) | 5 | 9 | 1 | 28858 | 32 | |||
57473 | 203823 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 830 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5996652.15177 | 2095040.88377 | 37.7323912769404 | -122.453943898404 | (37.7323912769404, -122.453943898404) | 9 | 7 | 4 | 59 | 40 | ||||
57615 | 188567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500 24th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6016949.54535 | 2102644.83882 | 37.7544130748234 | -122.384299775913 | (37.7544130748234, -122.384299775913) | 3 | 8 | 28856 | 29 |
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) );