438 rows where qSpecies_id = 63 sorted by TreeID descending

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)
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
74864 99487 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 700X Miramar Ave 4 Median : Cutout Tree Private 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
142912 99486 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 700X Miramar Ave 3 Median : Cutout Tree Private 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
111527 99477 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 650X Miramar Ave 6 Median : Cutout Tree Private 2     30 15x280   5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
101918 99474 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 650X Miramar Ave 5 Median : Cutout Tree Private 2     30 15x280   5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
49979 99473 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 600X Miramar Ave 2 Median : Cutout Tree Private 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
139390 99472 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 600X Miramar Ave 5 Median : Cutout Tree Private 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
33425 99460 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 550X Miramar Ave 7 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
188497 99458 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 550X Miramar Ave 3 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
161917 99457 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 550X Miramar Ave 1 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
193394 99455 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 400X Miramar Ave 5 Median : Cutout Tree Private 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40
36279 99451 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 400X Miramar Ave 1 Median : Cutout Tree Private 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40
5956 98839 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 4 Sidewalk: Property side : Yard Tree DPW 1                              
5800 98837 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 9 Sidewalk: Property side : Yard Tree DPW 1                              
82478 98836 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 6 Sidewalk: Property side : Yard Tree DPW 1           5994967.95791 2097979.30417 37.740362747151 -122.459979297607 (37.740362747151, -122.459979297607) 9 8 4 59 40
74160 98835 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 1 Front Yard : Yard Tree DPW 1           5995262 2098056.7 37.7405921639667 -122.458968225676 (37.7405921639667, -122.458968225676) 1 7 4 59 40
120346 98601 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 301 Twin Peaks Blvd 1 Sidewalk: Property side : Cutout Tree Private 2     24 3x3   5998661.2 2104103.7 37.757390562446 -122.447650343479 (37.757390562446, -122.447650343479) 15 5 5 63 3
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
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
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
70023 97489 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 500X Miramar Ave 5 Median : Cutout Tree Private 2     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
163251 97485 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 500X Miramar Ave 1 Median : Cutout Tree Private 2     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
90211 96976 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 390X Filbert St 1 Median : Yard Tree Rec/Park 5     28     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116) 3 1 10 308 23
13082 96572 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
135340 96571 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
54868 96570 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
57870 96483 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
124067 96482 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
99609 96481 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
170438 96480 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
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
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
157105 54486 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 535 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/11/1972 12:00:00 AM 8   Permit Number 10278 5983764.83173 2112189.27219 37.7787286289905 -122.499764682948 (37.7787286289905, -122.499764682948) 11 6 2 55 26
97489 38524 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3031 Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/15/1998 12:00:00 AM 4   Permit Number 40508 6001948.5977 2118592.4425 37.7973603403586 -122.437318675826 (37.7973603403586, -122.437318675826) 13 9 1 57 17
135343 30050 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900X Junipero Serra Blvd 1 Median : Cutout Tree DPW 1     3 3X3   5991182.41456 2091161.54655 37.7214244519661 -122.472571141372 (37.7214244519661, -122.472571141372) 9 8 4 64 40
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
10043 264733 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1367 De Haro St   Median : Cutout Tree DPW 1       3x3   6012260 2102130 37.7527390251575 -122.400481372119 (37.7527390251575, -122.400481372119) 10 3 8 28856 29
5758 262529 Property Tree 8 Pinus pinea :: Italian Stone Pine 63 555 Portola Dr 8 Front Yard : Yard Tree SFUSD 4       10x10   5997546 2099815 37.7455510557903 -122.451197845188 (37.7455510557903, -122.451197845188) 2 7 5 63 7
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
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
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
15519 262098 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 10x Cuesta Ct 2 Unaccepted Street : Yard Tree DPW 1 Private     3x3   5999757 2101744 37.7509739685765 -122.443691128062 (37.7509739685765, -122.443691128062) 2 5 5 63 38
7702 262097 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 10x Cuesta Ct 1 Unaccepted Street : Yard Tree DPW 1 Private     3x3   5999757 2101744 37.7509739685765 -122.443691128062 (37.7509739685765, -122.443691128062) 2 5 5 63 38
12450 261565 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 26th St 2 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013146 2101521 37.7511162126671 -122.39737469907 (37.7511162126671, -122.39737469907) 10 3 8 28856 1
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
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
17261 261487 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 2 Median : Cutout Tree DPW 1 Private     3x3   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 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
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
99612 258091 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1500x Steiner St 1 Sidewalk: Property side : Yard Tree DPW 1       15x50   6002808 2113496 37.7834156319858 -122.433980438269 (37.7834156319858, -122.433980438269) 13 9 11 29490 41
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
184680 256643 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2X Miraloma Dr 2 Side Yard : Cutout Tree DPW 1       10x10   5994995 2097925 37.7402151966004 -122.459881864698 (37.7402151966004, -122.459881864698) 9 8 4 59 40
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
42925 256615 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1541x Montgomery St 1 Front Yard : Yard Tree DPW 1 DPW for City Agency         6011315 2120446 37.8029777664724 -122.405038917948 (37.8029777664724, -122.405038917948) 3 1 10 308 23
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
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
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
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
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
164258 253422 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2X Miraloma Dr 1 Side Yard : Cutout Tree DPW 1       10x10   5994995 2097925 37.7402151966004 -122.459881864698 (37.7402151966004, -122.459881864698) 9 8 4 59 40
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
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
3008 251503 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 15 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
68470 251502 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 14 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
22926 251501 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 13 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
184944 251500 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 12 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
115262 251499 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 11 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
177928 251498 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 10 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
9305 251160 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 1 Median : Cutout Tree DPW 1 Private     3x3   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
191676 247975 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 503 Peralta Ave 1 Side Yard : Yard Tree Private 2     21     6009813.28917 2099236.81382 37.744658223 -122.408738483811 (37.744658223, -122.408738483811) 2 7 7 28859 2
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
108195 247896 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 351 Mayflower St 1 Sidewalk: Property side : Yard Tree Private 2     29 Width 5ft   6010145.43386 2098385.46575 37.7423392041921 -122.407529975731 (37.7423392041921, -122.407529975731) 10 7 7 28859 2
97194 24742 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 50X Point Lobos Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 12x12   5982568.63637 2112600.93828 37.7797886774071 -122.503933218017 (37.7797886774071, -122.503933218017) 11 6 2 55 26
92200 247144 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500 27th St 14 Front Yard : Yard Tree Private 2     23     6003151.94767 2100099.93337 37.7466527951889 -122.431833698065 (37.7466527951889, -122.431833698065) 2 7 5 63 22
119760 247143 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500 27th St 13 Front Yard : Yard Tree Private 2     26     6003160.52798 2100099.92491 37.7466532583536 -122.431804027655 (37.7466532583536, -122.431804027655) 2 7 5 63 22
94885 247113 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 31 Front Yard : Yard Tree Private 2     5     6002717.05441 2098681.21035 37.7427326503855 -122.433236156629 (37.7427326503855, -122.433236156629) 2 7 5 63 22
145279 247112 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 30 Front Yard : Yard Tree Private 2     4     6002722.94518 2098688.33329 37.7427525424969 -122.433216296891 (37.7427525424969, -122.433216296891) 2 7 5 63 22
101832 247109 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 27 Front Yard : Yard Tree Private 2     55     6002712.35608 2098750.32101 37.7429221456486 -122.433257339272 (37.7429221456486, -122.433257339272) 2 7 5 63 22
60884 247108 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 26 Front Yard : Yard Tree Private 2     48     6002704.67605 2098786.321 37.7430205575564 -122.433286466502 (37.7430205575564, -122.433286466502) 2 7 5 63 22
88434 247104 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 22 Front Yard : Yard Tree Private 2     31     6002734.00484 2098778.85198 37.743001713153 -122.433184522069 (37.743001713153, -122.433184522069) 2 7 5 63 22
11808 247102 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 20 Front Yard : Yard Tree Private 2     35     6002745.76405 2098754.96889 37.7429368028052 -122.43314215589 (37.7429368028052, -122.43314215589) 2 7 5 63 22
92432 247072 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 8 Front Yard : Yard Tree Private 2     22     6002777.34907 2098440.51813 37.7420751857223 -122.433010482565 (37.7420751857223, -122.433010482565) 2 7 5 63 22
101920 247071 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 7 Front Yard : Yard Tree Private 2     27     6002776.8237 2098415.08611 37.7420053254986 -122.433010482544 (37.7420053254986, -122.433010482544) 2 7 5 63 22
20818 247070 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 6 Front Yard : Yard Tree Private 2     24     6002744.91385 2098422.48032 37.7420238182333 -122.433121344697 (37.7420238182333, -122.433121344697) 2 7 5 63 22
67373 247069 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 5 Front Yard : Yard Tree Private 2     25     6002737.44051 2098436.60323 37.7420621725331 -122.433148193957 (37.7420621725331, -122.433148193957) 2 7 5 63 22
128762 247016 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500 Valley St 6 Sidewalk: Property side : Yard Tree Private 2     3     6002574.36339 2099193.51243 37.7441312166966 -122.433766148707 (37.7441312166966, -122.433766148707) 2 7 5 63 22
32405 246702 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1 Bonview St 8 Sidewalk: Curb side : Yard Tree Private 2     15     6007696.68665 2099102.86041 37.7441716385189 -122.416047816374 (37.7441716385189, -122.416047816374) 2 7 7 28859 2
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
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
35868 24283 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 300X Winding Way 21 Median : Cutout Tree DPW 1     6 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117) 9 7 6 28861 5
43298 23673 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 319 Virginia Ave 2 Median : Cutout Tree DPW 1     12 12   6006936.2458165 2098250.5638735 37.741788638282 -122.418616833275 (37.741788638282, -122.418616833275) 2 7 7 28859 2
115540 23580 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3100X Van Ness Ave 3 Median : Cutout Tree DPW 1     24 9   6005507.77084 2121129.71298 37.8045287248816 -122.425183644115 (37.8045287248816, -122.425183644115) 5 1 1 28858 32
142225 23579 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3100X Van Ness Ave 2 Median : Cutout Tree DPW 1     42 3x3   6005511.92719 2121098.11811 37.8044422083102 -122.425167011149 (37.8044422083102, -122.425167011149) 5 1 1 28858 32
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
96185 234523 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90 Woodland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     32 Width 5ft   5997132.36622 2105999.93621 37.7625096541183 -122.45307450849 (37.7625096541183, -122.45307450849) 15 5 11 29492 12
110265 234522 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90 Woodland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     41 Width 5ft   5997143.66994 2105974.54542 37.7624405852729 -122.453033580335 (37.7624405852729, -122.453033580335) 15 5 11 29492 12
86352 234521 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 5300x Diamond Heights Blvd 4 Median : Yard Tree DPW 1     30     6001544.41953 2098938.98574 37.7433738490244 -122.437309239227 (37.7433738490244, -122.437309239227) 2 7 5 63 7
149206 234518 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1481 Noe St 2 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6003337.48877 2099628.14838 37.7453678996008 -122.431158447529 (37.7453678996008, -122.431158447529) 2 7 5 63 22
152878 234517 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 10x Benton Ave 1 Median : Yard Tree DPW 1     29     6004828.72428 2095028.54608 37.7328228256069 -122.425674682059 (37.7328228256069, -122.425674682059) 2 7 7 28861 2
58718 234516 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90x Peralta Ave 2 Median : Yard Tree DPW 1     15 Width 10ft   6010366.95066 2100295.32111 37.7475956480377 -122.406898611185 (37.7475956480377, -122.406898611185) 2 7 7 28859 2

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