331 rows where qSpecies_id = 166 sorted by Supervisor Districts

View and edit SQL

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)
4456 132139 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 99 Moulton St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002898.54088 2119398.05033 37.7996262865921 -122.434089249929 (37.7996262865921, -122.434089249929) 13 9 1 57 17
38520 18883 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2323 Sacramento St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/26/2009 12:00:00 AM 3 2X2   6003550.92493 2115900.91625 37.7900610577251 -122.431581959853 (37.7900610577251, -122.431581959853) 13 9 1 29490 27
50359 65836 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2226 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/1990 12:00:00 AM 5   Permit Number 28826 6000059.65641 2120598.32121 37.8027603843422 -122.443999077409 (37.8027603843422, -122.443999077409) 13 9 1 57 17
54896 132159 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2712 Steiner St 3 Sidewalk: Property side : Yard Tree Private 2     16 Width 4ft   6002156.11084 2117482.383 37.7943242003589 -122.436521134556 (37.7943242003589, -122.436521134556) 13 9 1 29490 27
90723 112348 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 50 Perine Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6002110.93793 2115571.44216 37.7890746830929 -122.436540595874 (37.7890746830929, -122.436540595874) 13 6 1 29490 27
91008 132141 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2200 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6000126.69281 2120608.21837 37.8027913830869 -122.443767809531 (37.8027913830869, -122.443767809531) 13 9 1 57 17
91888 65834 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2222 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/1990 12:00:00 AM 6   Permit Number 28824 6000082.60671 2120602.00378 37.8027718048421 -122.443919922685 (37.8027718048421, -122.443919922685) 13 9 1 57 17
119634 132158 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2712 Steiner St 2 Sidewalk: Property side : Yard Tree Private 2     18 Width 4ft   6002157.9755 2117472.75324 37.7942978654946 -122.436513993051 (37.7942978654946, -122.436513993051) 13 9 1 29490 27
161668 132157 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2712 Steiner St 1 Sidewalk: Property side : Yard Tree Private 2     17 Width 4ft   6002161.41755 2117456.24016 37.7942527204522 -122.436500900709 (37.7942527204522, -122.436500900709) 13 9 1 29490 27
173399 62425 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2190 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/1990 12:00:00 AM 7   Permit Number 28803 6000367.76926 2120295.99012 37.8019478351817 -122.442911129744 (37.8019478351817, -122.442911129744) 13 9 1 57 17
177383 66146 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1870 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/1990 12:00:00 AM 7   Permit Number 29213 6000296.96947 2121326.31343 37.8047727901033 -122.443230173234 (37.8047727901033, -122.443230173234) 13 9 1 57 17
182666 132140 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 3500 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000293.03913 2120313.27667 37.8019910386216 -122.443170972674 (37.8019910386216, -122.443170972674) 13 9 1 57 17
22720 101293 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1573 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6006029.58816 2118260.54244 37.7966801777065 -122.42317377447 (37.7966801777065, -122.42317377447) 13 9 10 28858 32
28563 33284 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1517 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2008 12:00:00 AM 7 3x3 Permit Number 51277 6008395.56604 2117667.22147 37.7951843002637 -122.414944915675 (37.7951843002637, -122.414944915675) 5 1 10 28858 21
64894 33283 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1517 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/13/1996 12:00:00 AM 3   Permit Number 37446 6008392.97125 2117690.44353 37.7952479165022 -122.414955538493 (37.7952479165022, -122.414955538493) 5 1 10 28858 21
90470 23459 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 2290X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4 Permit Number 769634 6005952.25741 2118257.88317 37.7966685117079 -122.423441167528 (37.7966685117079, -122.423441167528) 13 9 10 28858 32
127932 96614 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1224 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2011 12:00:00 AM 1 3x3 Permit Number 767286 6008998.07345 2117142.60049 37.7937776571604 -122.412823030064 (37.7937776571604, -122.412823030064) 3 1 10 28857 21
151116 96615 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1224 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2011 12:00:00 AM 1 3x3 Permit Number 767286 6008996.31071 2117161.4041 37.7938291883275 -122.412830459354 (37.7938291883275, -122.412830459354) 3 1 10 28857 21
176973 101292 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1573 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6006005.37071 2118256.53367 37.7966678039418 -122.423257287321 (37.7966678039418, -122.423257287321) 13 9 10 28858 32
6484 17950 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2475 Pine St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6002060.75972 2114997.16684 37.7874950188452 -122.436673082148 (37.7874950188452, -122.436673082148) 13 6 11 29490 27
11822 142331 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 406 Lyon St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6000213.6336 2110347.5597 37.7746232471577 -122.442729755961 (37.7746232471577, -122.442729755961) 15 5 11 29492 16
16787 105348 Undocumented 4 Photinia fraseri :: Photinia: Chinese photinia 166 651X Ivy St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6004248.77005 2110989.99433 37.7766164199227 -122.428817225763 (37.7766164199227, -122.428817225763) 7 9 11 28852 10
27509 12287 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 820 Laguna St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/18/2014 02:37:00 PM 3 4X4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411) 7 9 11 28852 41
30324 132146 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6004850.84177 2111084.51569 37.7769100106119 -122.426741215961 (37.7769100106119, -122.426741215961) 7 9 11 28852 10
31105 138407 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2445 PINE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6002075.8939 2115001.0109 37.7875064337018 -122.436620996287 (37.7875064337018, -122.436620996287) 13 6 11 29490 27
31621 140028 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 850 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6004878.2522 2111874.4798 37.7790806079305 -122.426702663449 (37.7790806079305, -122.426702663449) 7 9 11 28852 41
33598 140011 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 820 LAGUNA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6004901.0094 2111721.5902 37.7786620972536 -122.426613046979 (37.7786620972536, -122.426613046979) 7 9 11 28852 41
40792 141418 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 500 Ivy St 15 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005151 2111194 37.7772275935342 -122.425710670776 (37.7772275935342, -122.425710670776) 7 9 11 28852 10
41587 138963 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 645 IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6004237.2429 2110976.1269 37.7765776909409 -122.428856112669 (37.7765776909409, -122.428856112669) 7 9 11 28852 10
42356 105346 Undocumented 4 Photinia fraseri :: Photinia: Chinese photinia 166 651X Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6004248.77005 2110989.99433 37.7766164199227 -122.428817225763 (37.7766164199227, -122.428817225763) 7 9 11 28852 10
54796 141417 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 530 IVY ST 10 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6004625.1496 2111052.9361 37.776810538049 -122.427519703953 (37.776810538049, -122.427519703953) 7 9 11 28852 10
59505 141419 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 500 Ivy St 16 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005151 2111194 37.7772275935342 -122.425710670776 (37.7772275935342, -122.425710670776) 7 9 11 28852 10
62100 17949 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2475 Pine St 2 Sidewalk: Curb side : Cutout Tree DPW 1     4 3x3   6002044.53862 2114995.39484 37.7874892315411 -122.436729076891 (37.7874892315411, -122.436729076891) 13 6 11 29490 27
62193 141406 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 500 IVY ST 3 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1995 12:00:00 AM 6 Width 0ft Permit Number 34950 6004860.5862 2111087.89 37.7769198265662 -122.426707747337 (37.7769198265662, -122.426707747337) 7 9 11 28852 10
64393 132142 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 525 Ivy St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6004877.96842 2111064.00554 37.7768552284082 -122.426645915672 (37.7768552284082, -122.426645915672) 7 9 11 28852 10
69418 139015 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2569 SUTTER ST 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000259.188 2114052.0744 37.7847974932802 -122.442838245979 (37.7847974932802, -122.442838245979) 15 6 11 29490 13
74422 139017 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2569 SUTTER ST 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000294.6805 2114054.8581 37.7848071599694 -122.442715653875 (37.7848071599694, -122.442715653875) 15 6 11 29490 13
74929 138930 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 666 IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004176.0708 2110989.9993 37.7766123186068 -122.429068714009 (37.7766123186068, -122.429068714009) 7 9 11 28852 10
77974 139825 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 900 Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6004831 2112025 37.7794912277556 -122.426876850808 (37.7794912277556, -122.426876850808) 7 9 11 28852 41
78794 140010 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 820 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004913.6029 2111647.1443 37.7784583990483 -122.426564178697 (37.7784583990483, -122.426564178697) 7 9 11 28852 41
79361 132152 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 10 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6004681.57966 2111062.06426 37.7768387933051 -122.427325145748 (37.7768387933051, -122.427325145748) 7 9 11 28852 10
92940 132150 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6004720.2552 2111067.25332 37.7768552284141 -122.427191725035 (37.7768552284141, -122.427191725035) 7 9 11 28852 10
94633 132153 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 11 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6004662.5128 2111060.462 37.776833315546 -122.427390989626 (37.776833315546, -122.427390989626) 7 9 11 28852 10
95142 234458 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 478 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5998572.14145 2106426.12515 37.7637622712248 -122.448125561761 (37.7637622712248, -122.448125561761) 15 5 11 29492 9
104964 138961 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 659 IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004210.501 2110971.7814 37.7765642456394 -122.428948310762 (37.7765642456394, -122.428948310762) 7 9 11 28852 10
110491 12292 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 830 Laguna St 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/11/1997 12:00:00 AM 3 4X4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411) 7 9 11 28852 41
113105 234438 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 786 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5998023.26528 2107589.70092 37.7669257633449 -122.450107819521 (37.7669257633449, -122.450107819521) 15 5 11 29492 9
118488 141413 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 530 IVY ST 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004701.4857 2111062.9803 37.7768424342938 -122.427256349988 (37.7768424342938, -122.427256349988) 7 9 11 28852 10
119305 139020 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2557 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000390.0231 2114072.2564 37.7848603658988 -122.442387050125 (37.7848603658988, -122.442387050125) 15 6 11 29490 13
119345 210965 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1405 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5993935.40946 2105897.25233 37.7620439725694 -122.464124072887 (37.7620439725694, -122.464124072887) 1 5 11 56 12
122172 141408 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 500 Ivy St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6005151 2111194 37.7772275935342 -122.425710670776 (37.7772275935342, -122.425710670776) 7 9 11 28852 10
126637 247498 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 348 Scott St 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 0ft   6002258.2648 2109741.2734 37.7730748820821 -122.43561359709 (37.7730748820821, -122.43561359709) 15 5 11 29492 9
127960 132149 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 7 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6004753.38188 2111070.56139 37.7768661848602 -122.427077365453 (37.7768661848602, -122.427077365453) 7 9 11 28852 10
130841 141412 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 500 Ivy St 9 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6005151 2111194 37.7772275935342 -122.425710670776 (37.7772275935342, -122.425710670776) 7 9 11 28852 10
131223 132154 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 12 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6004644.42691 2111057.84188 37.7768250984387 -122.427453367493 (37.7768250984387, -122.427453367493) 7 9 11 28852 10
132030 247382 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 363 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6002200.4098 2109794.4105 37.7732174971181 -122.43581752718 (37.7732174971181, -122.43581752718) 15 5 11 29492 9
132277 132147 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6004824.24441 2111082.07039 37.7769017926211 -122.4268330502 (37.7769017926211, -122.4268330502) 7 9 11 28852 10
136418 56794 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 1303 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/30/1974 12:00:00 AM   3x3 Permit Number 14019 6000327.28850998 2109204.10022929 37.7714900745599 -122.4422544996 (37.7714900745599, -122.4422544996) 15 5 11 29492 9
138735 139021 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2557 SUTTER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000404.6376 2114075.0402 37.7848688424651 -122.442336688766 (37.7848688424651, -122.442336688766) 15 6 11 29490 13
140541 132155 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 13 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6004627.84301 2111055.1905 37.7768168804195 -122.427510547282 (37.7768168804195, -122.427510547282) 7 9 11 28852 10
145153 139013 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2569 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000229.2629 2114047.2029 37.7847824113212 -122.442941426751 (37.7847824113212, -122.442941426751) 15 6 11 29490 13
147680 132151 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6004697.15203 2111064.23767 37.7768456416404 -122.427271431055 (37.7768456416404, -122.427271431055) 7 9 11 28852 10
150588 141414 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 500 Ivy St 11 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6005151 2111194 37.7772275935342 -122.425710670776 (37.7772275935342, -122.425710670776) 7 9 11 28852 10
150752 140013 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 840 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004880.8164 2111850.7611 37.7790156271835 -122.426692103329 (37.7790156271835, -122.426692103329) 7 9 11 28852 41
153119 132143 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 525 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6004895.04277 2111066.14782 37.7768620758709 -122.426587002881 (37.7768620758709, -122.426587002881) 7 9 11 28852 10
153357 132148 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6004787.54086 2111075.34441 37.7768812494174 -122.426959539871 (37.7768812494174, -122.426959539871) 7 9 11 28852 10
158776 254564 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 890X Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/15/2002 12:00:00 AM   3X3   6004895.58164 2111744.14099 37.7787237093276 -122.426633429967 (37.7787237093276, -122.426633429967) 7 9 11 28852 41
167137 141405 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 500 IVY ST 2 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1995 12:00:00 AM 3 Width 0ft Permit Number 34950 6004899.5578 2111091.1041 37.7769308549567 -122.426573161514 (37.7769308549567, -122.426573161514) 7 9 11 28852 10
169284 141415 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 530 IVY ST 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6004662.5142 2111058.1591 37.7768269924265 -122.427390820691 (37.7768269924265, -122.427390820691) 7 9 11 28852 10
173257 132144 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 525 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6004910.26431 2111067.91228 37.7768677811601 -122.426534472605 (37.7768677811601, -122.426534472605) 7 9 11 28852 10
174713 17948 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2475 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6002031.27574 2114994.27895 37.787485413843 -122.436774883786 (37.787485413843, -122.436774883786) 13 6 11 29490 27
175266 14739 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 890X Laguna St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/15/2002 12:00:00 AM 3 4X4   6004895.58164 2111744.14099 37.7787237093276 -122.426633429967 (37.7787237093276, -122.426633429967) 7 9 11 28852 41
178215 132145 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 540 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6004877.00023 2111089.96239 37.7769264448274 -122.426651113773 (37.7769264448274, -122.426651113773) 7 9 11 28852 10
180312 141410 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 500 Ivy St 7 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005151 2111194 37.7772275935342 -122.425710670776 (37.7772275935342, -122.425710670776) 7 9 11 28852 10
181481 139023 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2511 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6000454.7447 2114081.9995 37.7848908066545 -122.442163834685 (37.7848908066545, -122.442163834685) 15 6 11 29490 13
182342 139016 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2569 SUTTER ST 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000276.5862 2114052.7703 37.7848003959002 -122.442778104076 (37.7848003959002, -122.442778104076) 15 6 11 29490 13
185669 141416 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 500 Ivy St 13 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6005151 2111194 37.7772275935342 -122.425710670776 (37.7772275935342, -122.425710670776) 7 9 11 28852 10
194223 14733 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 912X Laguna St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6004848.1679 2112085.98552 37.7796596496687 -122.426821804086 (37.7796596496687, -122.426821804086) 7 9 11 28852 41
44501 123786 Undocumented 4 Photinia fraseri :: Photinia: Chinese photinia 166 1250 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   5994756.19271 2112157.05976 37.7792790287593 -122.461739219761 (37.7792790287593, -122.461739219761) 11 6 2 54 11
84578 140233 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1 SHRADER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5997236.5638 2110458.2831 37.7747571011004 -122.453035971219 (37.7747571011004, -122.453035971219) 15 5 2 29492 16
91663 140232 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2217 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5997153.7791 2110495.4596 37.7748544334109 -122.453325023475 (37.7748544334109, -122.453325023475) 15 5 2 29492 16
138170 89380 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1250X Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/06/2008 12:00:00 AM 3 3x3   5994772.91396 2112159.37755 37.7792863553313 -122.461681542526 (37.7792863553313, -122.461681542526) 11 6 2 54 11
20308 103199 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1601X 28th Ave 19 Sidewalk: Property side : Cutout Tree Rec/Park 5   03/26/2013 12:00:00 AM   3x4 Permit Number 770085 5987489 2103696 37.7556262873159 -122.486257815902 (37.7556262873159, -122.486257815902) 1 8 3 56 35
31596 43052 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 2000 41st Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42904 5983558.17532527 2101519.50178416 37.7494203390776 -122.499690770945 (37.7494203390776, -122.499690770945) 1 8 3 29491 35
34971 103197 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1601X 28th Ave 15 Sidewalk: Property side : Cutout Tree Rec/Park 5   03/26/2013 12:00:00 AM   3x4 Permit Number 770085 5987489 2103696 37.7556262873159 -122.486257815902 (37.7556262873159, -122.486257815902) 1 8 3 56 35
40938 21369 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2592X Sunset Blvd 31 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5985018.1742183 2097562.094386 37.7386399329486 -122.494350460592 (37.7386399329486, -122.494350460592) 1 8 3 29491 35
44827 103231 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1600X 29th Ave 22 Sidewalk: Property side : Cutout Tree Rec/Park 5   03/26/2013 12:00:00 AM   3x4 Permit Number 770085 5987489 2103696 37.7556262873159 -122.486257815902 (37.7556262873159, -122.486257815902) 1 8 3 56 35
60944 103228 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1600X 29th Ave 16 Sidewalk: Property side : Cutout Tree Rec/Park 5       3x4   5987489 2103696 37.7556262873159 -122.486257815902 (37.7556262873159, -122.486257815902) 1 8 3 56 35
62317 43051 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 2000 41st Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42904 5983558.17532527 2101519.50178416 37.7494203390776 -122.499690770945 (37.7494203390776, -122.499690770945) 1 8 3 29491 35
66706 43053 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 2000 41st Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42904 5983558.17532527 2101519.50178416 37.7494203390776 -122.499690770945 (37.7494203390776, -122.499690770945) 1 8 3 29491 35
68153 103229 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1600X 29th Ave 18 Sidewalk: Property side : Cutout Tree Rec/Park 5   03/26/2013 12:00:00 AM   3x4 Permit Number 770085 5987489 2103696 37.7556262873159 -122.486257815902 (37.7556262873159, -122.486257815902) 1 8 3 56 35
76407 87294 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 2087 28th Ave   Front Yard : Yard Tree Private 2   03/20/2008 12:00:00 AM     Permit Number 50307 5987541.6 2101099.3 37.7484995140672 -122.485885323793 (37.7484995140672, -122.485885323793) 1 8 3 29491 35
78037 103221 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1600X 29th Ave 6 Sidewalk: Property side : Cutout Tree Rec/Park 5   03/26/2013 12:00:00 AM 11 3x4 Permit Number 770085 5987489 2103696 37.7556262873159 -122.486257815902 (37.7556262873159, -122.486257815902) 1 8 3 56 35
79059 182437 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1551 20th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5989914.2293 2104805.4779 37.7588136721701 -122.477951808318 (37.7588136721701, -122.477951808318) 1 8 3 56 35
83945 103226 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1600X 29th Ave 12 Sidewalk: Property side : Cutout Tree Rec/Park 5       3x4   5987489 2103696 37.7556262873159 -122.486257815902 (37.7556262873159, -122.486257815902) 1 8 3 56 35
93010 186335 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1801 Sunset Blvd 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984801.9017 2102876.5819 37.7532194095825 -122.495490075013 (37.7532194095825, -122.495490075013) 1 8 3 56 35
102948 43054 Permitted Site 7 Photinia fraseri :: Photinia: Chinese photinia 166 2000 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42904 5983558.17532527 2101519.50178416 37.7494203390776 -122.499690770945 (37.7494203390776, -122.499690770945) 1 8 3 29491 35
106424 182203 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1659 21st Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5989632.7475 2104072.0115 37.7567834283184 -122.478871646143 (37.7567834283184, -122.478871646143) 1 8 3 56 35
114145 183496 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 2546 22nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5989574.0258 2098014.7611 37.7401484030768 -122.478631764598 (37.7401484030768, -122.478631764598) 1 8 3 29491 35
116119 103194 DPW Maintained 1 Photinia fraseri :: Photinia: Chinese photinia 166 1601X 28th Ave 13 Sidewalk: Property side : Cutout Tree Rec/Park 5       3x4   5987489 2103696 37.7556262873159 -122.486257815902 (37.7556262873159, -122.486257815902) 1 8 3 56 35

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);