trees

294 rows where qCaretaker_id = 2 and qSpecies_id = 63 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

Neighborhoods (old) ✖

qCaretaker_id ✖

  • Private · 294 ✖
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)
1588 260075 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 171X Gellert Dr 1 Median : Yard Tree Private 2       3x3   5985371 2094678 37.7307416178434 -122.492918192866 (37.7307416178434, -122.492918192866) 1 8 4 64 35
1901 262254 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 4210 Ocean Ave 7 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
3910 173844 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2X Crestline Dr 1 Front Yard : Yard Tree Private 2           5999319 2101169 37.7493701671822 -122.445164434644 (37.7493701671822, -122.445164434644) 2 5 5 63 38
4567 261551 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 135 Fernwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994788 2095004 37.7321829429526 -122.460385989231 (37.7321829429526, -122.460385989231) 9 8 4 59 40
5675 261201 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 699x Benton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007339 2095419 37.7340364554683 -122.417023656077 (37.7340364554683, -122.417023656077) 2 7 7 28859 2
7002 262493 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 2 Median : Yard Tree Private 2       10x10   5995372 2097783 37.7398469739468 -122.458568082407 (37.7398469739468, -122.458568082407) 9 7 4 59 40
8023 121696 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
10229 264894 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 56 Keystone Way 1 Back Yard : Yard Tree Private 2       3x3   5994156 2093086 37.7268802074189 -122.462431871086 (37.7268802074189, -122.462431871086) 9 8 4 28861 40
10438 262492 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 1 Median : Yard Tree Private 2       10x10   5995372 2097783 37.7398469739468 -122.458568082407 (37.7398469739468, -122.458568082407) 9 7 4 59 40
16552 261549 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3101 Sunset Blvd 1 Median : Cutout Tree Private 2       3x3   5984952 2094961 37.7314941488449 -122.494387573147 (37.7314941488449, -122.494387573147) 1 8 4 64 35
19898 98265 Property Tree 8 Pinus pinea :: Italian Stone Pine 63 755 O'Farrell St   Back Yard : Yard Tree Private 2         Backyard tree; not significant 6007700 2113968.3 37.7849888609023 -122.417089467607 (37.7849888609023, -122.417089467607) 7 10 9 28858 36
22688 120924 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 7 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
24668 97534 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 203 Surrey St 1 Front Yard : Yard Tree Private 2         Permit Number 768282 6002070 2096079.6 37.7355525046422 -122.435287431957 (37.7355525046422, -122.435287431957) 2 7 5 63 7
36162 110396 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1x ARLETA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x30   6011055 2087587 37.7127397354919 -122.403625353192 (37.7127397354919, -122.403625353192) 9 7 8 309 39
36915 117645 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2901 21ST AVE 1 Back Yard : Yard Tree Private 2       3x3   5989904 2095901 37.734363711699 -122.477336418651 (37.734363711699, -122.477336418651) 1 8 4 64 35
60656 120926 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 9 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
68284 253182 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 5157 Diamond Heights Blvd 1 Front Yard : Yard Tree Private 2           6000788 2100195 37.7467795353698 -122.440014780391 (37.7467795353698, -122.440014780391) 2 4 5 63 22
77915 257969 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1998X 09th Ave 1 Sidewalk: Property side : Yard Tree Private 2       6x15   5993560 2101938 37.7511512457798 -122.465134876758 (37.7511512457798, -122.465134876758) 1 8 4 29491 12
85334 256616 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1541X Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011315 2120446 37.8029777664724 -122.405038917948 (37.8029777664724, -122.405038917948) 3 1 10 308 23
86615 253183 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 5159 Diamond Heights Blvd 1 Front Yard : Yard Tree Private 2           6000808 2099903 37.745978911495 -122.439924689335 (37.745978911495, -122.439924689335) 2 4 5 63 22
87762 117289 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 26X GLADEVIEW WAY 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997876 2101605 37.7504848455829 -122.450185761312 (37.7504848455829, -122.450185761312) 1 5 4 63 38
103781 108605 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1140x CHESTNUT ST 2 Unaccepted Street : Yard Tree Private 2           6006369.1 2120452.7 37.8027184407042 -122.422154803739 (37.8027184407042, -122.422154803739) 5 9 1 28858 32
106034 255453 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 90 Kiska Rd 1 Front Yard : Yard Tree Private 2       3x3   6018381 2093938 37.7305848832053 -122.378744818809 (37.7305848832053, -122.378744818809) 10 3 8 58 1
109715 120932 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 15 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
113341 92210 Permitted Site 7 Pinus pinea :: Italian Stone Pine 63 300x Miramar Ave 4 Median : Cutout Tree Private 2   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.7243160320082 -122.458116274775 (37.7243160320082, -122.458116274775) 9 8 4 28861 24
118486 100845 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1 Estero Ave 3 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
120938 110397 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 2200 BAY SHORE BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2       3x30   6011234 2087411 37.7122664722191 -122.40299429709 (37.7122664722191, -122.40299429709) 9 7 8 309 39
136239 120933 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 16 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
139657 256152 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 80X Peralta Ave 1 Median : Cutout Tree Private 2       3x3   6010428 2100359 37.747773912222 -122.406691992098 (37.747773912222, -122.406691992098) 2 7 7 28859 2
140522 121695 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
144307 92207 Permitted Site 7 Pinus pinea :: Italian Stone Pine 63 300X Miramar Ave 1 Median : Cutout Tree Private 2   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.7243160320082 -122.458116274775 (37.7243160320082, -122.458116274775) 9 8 4 28861 24
145282 120934 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 17 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
156900 120929 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 12 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
156992 253621 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 200x Montcalm St 1 Back Yard : Yard Tree Private 2       3x3   6010036 2099760 37.7461072494139 -122.408005278478 (37.7461072494139, -122.408005278478) 2 7 7 28859 2
160036 253982 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 438X Detroit St 1 Unaccepted Street : Yard Tree Private 2       10x10   5999326 2094622 37.7313940668699 -122.444669716777 (37.7313940668699, -122.444669716777) 9 7 4 59 40
162123 120936 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 19 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
162461 120921 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 4 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
163885 115556 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 3897 CLAY ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996199 2115222 37.7877774871206 -122.456969730492 (37.7877774871206, -122.456969730492) 11 6 1 54 31
170429 253558 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1240 Wisconsin St 1 Front Yard : Yard Tree Private 2           6012830 2101639 37.7514226163546 -122.398475746389 (37.7514226163546, -122.398475746389) 10 3 8 28856 29
179258 121697 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
193904 99774 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 4330 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       8x6   6001764 2100607 37.7479663028981 -122.436669359529 (37.7479663028981, -122.436669359529) 2 4 5 28862 22
6140 243478 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1499X Eugenia Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   6008755.36846 2097659.39973 37.7402676797185 -122.412285110476 (37.7402676797185, -122.412285110476) 10 7 7 28859 2
11326 186595 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 66 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984740.8383 2104479.6291 37.7576173573885 -122.49581948315 (37.7576173573885, -122.49581948315) 1 8 3 56 35
68325 184784 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984713.613 2105863.1758 37.7614145960538 -122.496015705201 (37.7614145960538, -122.496015705201) 1 8 3 56 35
69152 184781 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 42 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984718.1696 2105899.6288 37.7615149526664 -122.496002635394 (37.7615149526664, -122.496002635394) 1 8 3 56 35
120848 194447 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 680 De Haro St 4 Sidewalk: Property side : Yard Tree Private 2     1     6012074.20817 2105270.47212 37.761351707727 -122.401344555627 (37.761351707727, -122.401344555627) 10 3 8 28856 29
128520 246698 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1 Bonview St 4 Sidewalk: Curb side : Yard Tree Private 2     1     6007671.81678 2099058.43431 37.7440482560225 -122.416130665494 (37.7440482560225, -122.416130665494) 2 7 7 28859 2
132701 186592 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 63 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984742.0945 2104511.4521 37.757704808066 -122.495817486185 (37.757704808066, -122.495817486185) 1 8 3 56 35
142939 199653 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2700 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6014921.1055 2090874.3975 37.721981490288 -122.390492306355 (37.721981490288, -122.390492306355) 10 3 8 58 1
145433 234514 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 998 York St 10 Sidewalk: Curb side : Yard Tree Private 2     1 Width 7ft   6009944.54234 2103430.26244 37.7561798559202 -122.408580392894 (37.7561798559202, -122.408580392894) 2 4 7 28859 19
170298 211082 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 843 Detroit St 7 Sidewalk: Property side : Yard Tree Private 2     1 Width 5ft   5999417.62854 2095618.00896 37.7341341018996 -122.444424494503 (37.7341341018996, -122.444424494503) 9 7 4 59 40
170803 186254 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1701 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984796.5449 2103072.2391 37.7537563165951 -122.495523029283 (37.7537563165951, -122.495523029283) 1 8 3 56 35
21400 186097 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 43 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984866.2826 2101735.8043 37.7500909175156 -122.495183318527 (37.7500909175156, -122.495183318527) 1 8 3 29491 35
45383 186433 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1601 Sunset Blvd 21 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984738.4307 2104031.9087 37.7563879005336 -122.495794783817 (37.7563879005336, -122.495794783817) 1 8 3 56 35
56295 185638 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5985050.0993 2100407.4104 37.7464542704067 -122.494449767525 (37.7464542704067, -122.494449767525) 1 8 3 29491 35
131920 201760 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 8 Sidewalk: Property side : Yard Tree Private 2     10 Width 8ft   6015686.51796 2087358.79354 37.7123707547676 -122.387601292376 (37.7123707547676, -122.387601292376) 10 3 8 58 1
187791 201745 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 14 Sidewalk: Property side : Yard Tree Private 2     10 Width 8ft   6015574.32176 2087390.64932 37.7124520094198 -122.387991301359 (37.7124520094198, -122.387991301359) 10 3 8 58 1
191105 201771 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 19 Sidewalk: Property side : Yard Tree Private 2     10 Width 8ft   6015632.38361 2087621.49757 37.7130890909533 -122.387806717322 (37.7130890909533, -122.387806717322) 10 3 8 58 1
34962 184744 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984688.1718 2106200.1767 37.7623384159342 -122.496128558374 (37.7623384159342, -122.496128558374) 1 8 3 56 35
78908 194452 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 20th St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6011998.43391 2104639.55141 37.7596151114626 -122.401562284167 (37.7596151114626, -122.401562284167) 10 3 8 28856 29
100087 194438 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1051 18th St 1 Side Yard : Yard Tree Private 2     11     6014405.25344 2105708.40792 37.7626839643245 -122.39331303148 (37.7626839643245, -122.39331303148) 10 3 8 28856 29
103851 247910 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 399 Franconia St 1 Side Yard : Yard Tree Private 2     11     6009965.37797 2098759.56576 37.7433563212371 -122.408178935533 (37.7433563212371, -122.408178935533) 2 7 7 28859 2
126912 194445 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 25th St 15 Sidewalk: Curb side : Yard Tree Private 2     11     6014148.42594 2101954.90209 37.7523633759809 -122.393938549541 (37.7523633759809, -122.393938549541) 10 3 8 28856 1
152112 186248 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1701 Sunset Blvd 12 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984775.1177 2103139.467 37.7539396511246 -122.495602086568 (37.7539396511246, -122.495602086568) 1 8 3 56 35
157528 201756 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 8ft   6015765.33497 2087252.12963 37.7120822414633 -122.387321438639 (37.7120822414633, -122.387321438639) 10 3 8 58 1
165845 234524 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 671 Church St 22 Front Yard : Yard Tree Private 2     11 Width 3ft   6004318.84944 2105025.54229 37.7602434426069 -122.4281496397 (37.7602434426069, -122.4281496397) 2 4 5 28862 3
166606 201762 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 10 Sidewalk: Property side : Yard Tree Private 2     11 Width 8ft   6015664.25655 2087408.13431 37.712505001973 -122.387681675578 (37.712505001973, -122.387681675578) 10 3 8 58 1
23455 97490 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 500X Miramar Ave 7 Median : Cutout Tree Private 2     12 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
31995 201737 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 6 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6015529.27451 2087676.75764 37.7132351120852 -122.38816695425 (37.7132351120852, -122.38816695425) 10 3 8 58 1
48354 211060 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2088 15th Ave 6 Sidewalk: Curb side : Pot Tree Private 2     12 Width 6ft   5991645.7062 2101259.684 37.7491781931242 -122.471705217417 (37.7491781931242, -122.471705217417) 1 8 4 29491 12
79660 201757 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 5 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6015756.55363 2087265.17293 37.7121175695368 -122.38735269906 (37.7121175695368, -122.38735269906) 10 3 8 58 1
95203 141265 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 52 JORDAN AVE 2 Sidewalk: Curb side : Yard Tree Private 2     12 Width 0ft   5996227.2891 2114192.1724 37.7849514808139 -122.456797345759 (37.7849514808139, -122.456797345759) 11 6 1 54 31
114462 201769 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 17 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6015636.77799 2087561.79601 37.7129254053659 -122.387787365691 (37.7129254053659, -122.387787365691) 10 3 8 58 1
157519 187090 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2600 Sunset Blvd 26 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5985165.338 2097125.749 37.7374504565555 -122.493809499319 (37.7374504565555, -122.493809499319) 1 8 3 29491 35
160907 201746 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 15 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6015580.41623 2087372.51377 37.7124025503214 -122.387968972099 (37.7124025503214, -122.387968972099) 10 3 8 58 1
161041 234512 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300 San Jose Ave 61 Front Yard : Yard Tree Private 2     12 Width 6ft   6003219.80457 2095456.80721 37.7339076867834 -122.431267680974 (37.7339076867834, -122.431267680974) 2 7 5 63 7
167835 184087 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 Sunset Blvd 88 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5984947.9817 2104096.3091 37.7565769961358 -122.495074842554 (37.7565769961358, -122.495074842554) 1 8 3 56 35
172168 201743 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 12 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6015564.44995 2087435.02252 37.7125733027894 -122.388028516211 (37.7125733027894, -122.388028516211) 10 3 8 58 1
182292 201774 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 22 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6015625.88693 2087662.37118 37.7132009621398 -122.38783202245 (37.7132009621398, -122.38783202245) 10 3 8 58 1
184638 185176 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2500 Sunset Blvd 28 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5985156.5992 2097794.2406 37.7392854441206 -122.493888963204 (37.7392854441206, -122.493888963204) 1 8 3 29491 35
7554 201736 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 5 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015525.30693 2087693.56377 37.7132810386533 -122.38818183984 (37.7132810386533, -122.38818183984) 10 3 8 58 1
18973 233322 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 51 Prentiss St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008884.18383 2098343.89419 37.7421543791283 -122.411888074199 (37.7421543791283, -122.411888074199) 10 7 7 28859 2
25472 201732 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015480.18133 2087865.40702 37.713750386735 -122.388349797223 (37.713750386735, -122.388349797223) 10 3 8 58 1
39195 201740 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 9 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015542.0778 2087585.57887 37.7129854620959 -122.388116342205 (37.7129854620959, -122.388116342205) 10 3 8 58 1
63112 201741 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 10 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015551.73985 2087509.47398 37.7127770280164 -122.388077638997 (37.7127770280164, -122.388077638997) 10 3 8 58 1
146862 201738 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 7 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015533.66415 2087659.51426 37.7131880082953 -122.388150579386 (37.7131880082953, -122.388150579386) 10 3 8 58 1
38128 201734 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 3 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015517.44938 2087731.03371 37.71338348853 -122.388211611887 (37.71338348853, -122.388211611887) 10 3 8 58 1
48450 201773 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 21 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015629.12317 2087652.01307 37.7131727000372 -122.387820114508 (37.7131727000372, -122.387820114508) 10 3 8 58 1
50112 109625 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 312x FILBERT ST 1 Unaccepted Street : Yard Tree Private 2     14     6011362.9 2120079.8 37.801974948341 -122.40484736081 (37.801974948341, -122.40484736081) 3 1 10 308 23
57881 201744 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 13 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015567.574 2087419.0912 37.7125297315236 -122.388016607392 (37.7125297315236, -122.388016607392) 10 3 8 58 1
75335 185550 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2201 Sunset Blvd 34 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5984877.5845 2099886.0836 37.7450127509214 -122.495007861214 (37.7450127509214, -122.495007861214) 1 8 3 29491 35
85521 187012 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2501 Sunset Blvd 31 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5984974.837 2098002.6963 37.7398471711362 -122.494532769595 (37.7398471711362, -122.494532769595) 1 8 3 29491 35
96403 201768 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 16 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015641.02933 2087537.69345 37.7128594598683 -122.387770990859 (37.7128594598683, -122.387770990859) 10 3 8 58 1
96989 201781 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 29 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015573.4977 2087883.43723 37.713805064638 -122.388028516222 (37.713805064638, -122.388028516222) 10 3 8 58 1
103192 132176 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2745 Larkin St 2 Sidewalk: Property side : Yard Tree Private 2     14     6006527.83964 2120663.1294 37.8033051783476 -122.421620437537 (37.8033051783476, -122.421620437537) 5 9 1 28858 32
116998 185204 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2500 Sunset Blvd 57 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5985139.3342 2097991.4603 37.7398259462999 -122.493963187792 (37.7398259462999, -122.493963187792) 1 8 3 29491 35
119044 201747 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 16 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015587.35405 2087353.50341 37.7123507358797 -122.387943666966 (37.7123507358797, -122.387943666966) 10 3 8 58 1
122823 201764 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 12 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015653.28128 2087440.52101 37.7125933216851 -122.387721868094 (37.7125933216851, -122.387721868094) 10 3 8 58 1
156029 201763 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 11 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015661.0546 2087420.2073 37.7125379747236 -122.387693584416 (37.7125379747236, -122.387693584416) 10 3 8 58 1
163834 194471 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 84 Whitney Young Cir 4 Sidewalk: Property side : Yard Tree Private 2     14     6016756.75905 2095047.76274 37.7335423929578 -122.38443738208 (37.7335423929578, -122.38443738208) 10 3 8 58 1

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