trees

294 rows where qCaretaker_id = 2 and qSpecies_id = 63

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 194 ✖
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)
73422 234509 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1101 San Jose Ave 9 Front Yard : Yard Tree Private 2     25     6004750.38207 2096347.45133 37.7364398161369 -122.426039387727 (37.7364398161369, -122.426039387727) 2 7 5 28859 2
74337 211057 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 447 Lawton St 2 Sidewalk: Curb side : Pot Tree Private 2     9 Width 3ft   5992810.26786 2104540.37946 37.7582534434534 -122.467916772063 (37.7582534434534, -122.467916772063) 1 8 4 56 12
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
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
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
78578 185360 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 85 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985022.2207 2096895.7045 37.7368104416486 -122.494287364038 (37.7368104416486, -122.494287364038) 1 8 3 29491 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
79197 187345 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2200 Sunset Blvd 30 Sidewalk: Property side : Yard Tree Private 2     29 Width 0ft   5985074.9529 2099709.2267 37.7445387020266 -122.494312372955 (37.7445387020266, -122.494312372955) 1 8 3 29491 35
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
79719 194464 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 6 Sidewalk: Curb side : Yard Tree Private 2     16     6012478.49596 2101876.43729 37.7520549795584 -122.399707966672 (37.7520549795584, -122.399707966672) 10 3 8 28856 29
80305 111179 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 400 NORTH POINT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 9x6   6008572 2121805 37.806555520543 -122.414627380808 (37.806555520543, -122.414627380808) 3 1 10 308 23
81035 194456 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 22nd St 12 Front Yard : Yard Tree Private 2     2     6013384.43791 2103815.09856 37.7574285843868 -122.396710957944 (37.7574285843868, -122.396710957944) 10 3 8 28856 29
82734 201750 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 491 Jamestown Ave 2 Sidewalk: Property side : Yard Tree Private 2     34 Width 8ft   6015853.10494 2087012.76113 37.7114298417752 -122.3870013933 (37.7114298417752, -122.3870013933) 10 3 8 58 1
84080 201783 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 31 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015549.05195 2087952.54872 37.7139934770858 -122.388117830599 (37.7139934770858, -122.388117830599) 10 3 8 58 1
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
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
86298 186102 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 48 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984817.1679 2101703.0611 37.7499981380626 -122.495350742926 (37.7499981380626, -122.495350742926) 1 8 3 29491 35
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
87306 201794 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 42 Sidewalk: Property side : Yard Tree Private 2     17 Width 8ft   6015439.96848 2088181.18977 37.7146152368657 -122.388510817234 (37.7146152368657, -122.388510817234) 10 3 8 58 1
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
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
90634 201790 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 38 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   6015475.6761 2088115.28204 37.7144362457024 -122.388382798743 (37.7144362457024, -122.388382798743) 10 3 8 58 1
92020 110148 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 90 WOODLAND AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     38 4x9   5997155.9 2105983.7 37.7624664223167 -122.452991942132 (37.7624664223167, -122.452991942132) 15 5 11 29492 12
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
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
93032 186593 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 64 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984773.0801 2104494.2844 37.7576594849516 -122.495709060541 (37.7576594849516, -122.495709060541) 1 8 3 56 35
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
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
95767 185659 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 40 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5985060.0587 2100566.7616 37.7468923883135 -122.494427074117 (37.7468923883135, -122.494427074117) 1 8 3 29491 35
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
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
97073 194469 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 981 Le Conte Ave 1 Sidewalk: Curb side : Yard Tree Private 2     29     6013175.32991 2089516.24763 37.7181552814285 -122.396431907321 (37.7181552814285, -122.396431907321) 10 3 8 58 1
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
98798 211059 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2088 15th Ave 5 Sidewalk: Curb side : Pot Tree Private 2     16 Width 6ft   5991648.13538 2101268.04551 37.74920129221 -122.471697426622 (37.74920129221, -122.471697426622) 1 8 4 29491 12
99356 211061 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2088 15th Ave 7 Sidewalk: Curb side : Pot Tree Private 2     9 Width 6ft   5991650.04455 2101251.74063 37.7491566336932 -122.47168963669 (37.7491566336932, -122.47168963669) 1 8 4 29491 12
99536 201777 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 25 Sidewalk: Property side : Yard Tree Private 2     17 Width 8ft   6015601.56547 2087780.3718 37.7135236217889 -122.387924315354 (37.7135236217889, -122.387924315354) 10 3 8 58 1
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
101713 185705 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2101 Sunset Blvd 38 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984891.1634 2100474.9689 37.7466304646766 -122.495004322509 (37.7466304646766, -122.495004322509) 1 8 3 29491 35
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
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
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
102199 186902 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2700 Sunset Blvd 51 Sidewalk: Property side : Yard Tree Private 2     17 Width 0ft   5985182.8419 2096662.3766 37.7361791837873 -122.493714845671 (37.7361791837873, -122.493714845671) 1 8 3 29491 35
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
103634 186594 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984719.4834 2104488.841 37.7576414000341 -122.495894015518 (37.7576414000341, -122.495894015518) 1 8 3 56 35
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
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
104488 234502 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3502 24th St 1 Front Yard : Yard Tree Private 2     27     6006115.28896 2102029.42996 37.7521182909488 -122.421723779538 (37.7521182909488, -122.421723779538) 2 4 5 28859 19
105788 218299 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1 Ardenwood Way 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 8ft   5991311.90242 2096390.21304 37.7357885567818 -122.472504543874 (37.7357885567818, -122.472504543874) 1 8 4 29491 40
105900 234504 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100 San Jose Ave 5 Front Yard : Yard Tree Private 2     16     6004845.11812 2096728.13188 37.7374904329363 -122.425738932323 (37.7374904329363, -122.425738932323) 2 7 5 63 7
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
106214 201767 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 15 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015642.29299 2087514.93769 37.7127970469199 -122.387765036445 (37.7127970469199, -122.387765036445) 10 3 8 58 1
106418 201754 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 2 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015794.33118 2087216.37677 37.7119856767735 -122.387218726159 (37.7119856767735, -122.387218726159) 10 3 8 58 1
106470 186343 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984811.8118 2102790.6052 37.7529839215525 -122.495449463877 (37.7529839215525, -122.495449463877) 1 8 3 56 35
107661 201748 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 17 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6015601.73852 2087319.33199 37.7122577046069 -122.387891566548 (37.7122577046069, -122.387891566548) 10 3 8 58 1
108098 132177 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1048 Union St 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6007888.26555 2119276.18895 37.7995736051877 -122.416814304957 (37.7995736051877, -122.416814304957) 5 1 1 308 32
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
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
109871 185295 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984962.8666 2097355.3585 37.7380690548117 -122.494526449097 (37.7380690548117, -122.494526449097) 1 8 3 29491 35
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
110823 201753 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 1 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015806.16056 2087204.98759 37.7119550593549 -122.387177046177 (37.7119550593549, -122.387177046177) 10 3 8 58 1
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
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
113722 201749 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 491 Jamestown Ave 1 Sidewalk: Property side : Yard Tree Private 2     26 Width 8ft   6015821.03447 2087045.57383 37.7115181633057 -122.387114525336 (37.7115181633057, -122.387114525336) 10 3 8 58 1
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
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
117514 132181 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 4 Sidewalk: Property side : Yard Tree Private 2     21     6007227.55341 2121889.28804 37.8067113282286 -122.419286081687 (37.8067113282286, -122.419286081687) 5 1 1 28858 32
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
118830 211056 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 17th Ave 2 Sidewalk: Property side : Yard Tree Private 2     20     5990908.64637 2104472.93122 37.7579582535812 -122.474488420401 (37.7579582535812, -122.474488420401) 1 8 4 56 12
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
119227 234505 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100 San Jose Ave 7 Front Yard : Yard Tree Private 2     16     6004841.55243 2096717.56088 37.7374612058616 -122.425750508406 (37.7374612058616, -122.425750508406) 2 7 5 63 7
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
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
120570 187096 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2600 Sunset Blvd 32 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985160.1655 2097173.7115 37.7375818461267 -122.493830916284 (37.7375818461267, -122.493830916284) 1 8 3 29491 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
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
121598 186348 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984789.3132 2102727.1271 37.7528083107787 -122.495522585708 (37.7528083107787, -122.495522585708) 1 8 3 56 35
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
124322 201782 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 30 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015559.74323 2087927.45907 37.713925178088 -122.388079127353 (37.713925178088, -122.388079127353) 10 3 8 58 1
125583 184742 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5984665.3886 2106227.5165 37.7624121488276 -122.496209373012 (37.7624121488276, -122.496209373012) 1 8 3 56 35
126322 186253 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1701 Sunset Blvd 64 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984779.1353 2103090.988 37.7538067764424 -122.495584617514 (37.7538067764424, -122.495584617514) 1 8 3 56 35
126413 211063 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 333 Pacheco St 1 Sidewalk: Curb side : Yard Tree Private 2     23 Width 4ft   5994231.86901 2100876.38212 37.7482750327754 -122.462734494413 (37.7482750327754, -122.462734494413) 1 8 4 29491 40
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
128353 194455 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 22nd St 11 Front Yard : Yard Tree Private 2     8     6013406.26386 2103790.51305 37.757362292666 -122.396633751156 (37.757362292666, -122.396633751156) 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
128546 185363 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2601 Sunset Blvd 88 Sidewalk: Property side : Yard Tree Private 2     43 Width 0ft   5984980.3483 2096870.9998 37.7367401586853 -122.494430312609 (37.7367401586853, -122.494430312609) 1 8 3 29491 35
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
131381 194466 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 8 Sidewalk: Curb side : Yard Tree Private 2     25     6012435.9357 2101881.1338 37.7520655025415 -122.399855477046 (37.7520655025415, -122.399855477046) 10 3 8 28856 29
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
132354 194460 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 1 Sidewalk: Curb side : Yard Tree Private 2     24     6012680.82829 2101890.2153 37.7521040879384 -122.399009233909 (37.7521040879384, -122.399009233909) 10 3 8 28856 29
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
132708 201780 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 28 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6015582.72471 2087849.79956 37.7137132132682 -122.387994278123 (37.7137132132682, -122.387994278123) 10 3 8 58 1
133127 194437 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1021 Minnesota St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6015301.57899 2103740.56291 37.7573304413508 -122.390075457711 (37.7573304413508, -122.390075457711) 10 3 8 28856 29
133258 201758 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 6 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6015742.62341 2087279.17788 37.7121552529428 -122.387401822747 (37.7121552529428, -122.387401822747) 10 3 8 58 1
133522 201785 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 33 Sidewalk: Property side : Yard Tree Private 2     17 Width 8ft   6015530.91454 2087992.79913 37.7141029920284 -122.388183328214 (37.7141029920284, -122.388183328214) 10 3 8 58 1
133881 194454 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Rhode Island St 7 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   6012013.85217 2102295.56099 37.753179889343 -122.40134423455 (37.753179889343, -122.40134423455) 10 3 8 28856 29
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
136927 211081 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90 Melrose Ave 7 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   5999513.42858 2095531.79881 37.7339028547188 -122.444087092249 (37.7339028547188, -122.444087092249) 9 7 4 63 40
137520 194468 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Quint St 5 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   6012422.70585 2095229.76642 37.7338015236278 -122.399434316464 (37.7338015236278, -122.399434316464) 10 3 8 58 1
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

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