438 rows where qSpecies_id = 63 sorted by rowid 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)
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
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
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
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
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
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
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
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
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
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
99546 211067 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500x Miramar Ave 5 Median : Yard Tree DPW 1     39     5995372.66361 2092795.985 37.7261538831809 -122.458204939322 (37.7261538831809, -122.458204939322) 9 7 4 28861 40
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
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
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
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
97461 115155 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 245x ARLINGTON ST 4 Median : Yard Tree DPW 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
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
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
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
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
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
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
95523 194440 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 33 Median : Yard Tree DPW 1     6     6012485.2688 2103286.14111 37.7559260969364 -122.399783521388 (37.7559260969364, -122.399783521388) 10 3 8 28856 29
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
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
93601 115152 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 245x ARLINGTON ST 1 Median : Yard Tree DPW 1     30 3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
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
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
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
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
90813 111522 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 17 Front Yard : Yard Tree DPW 1     20     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
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
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
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
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
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
87097 211066 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500x Miramar Ave 2 Median : Yard Tree DPW 1     36     5995372.70371 2092704.86629 37.7259036953978 -122.458198208802 (37.7259036953978, -122.458198208802) 9 7 4 28861 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
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
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
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
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
85285 20978 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2002X Sunset Blvd 18 Sidewalk: Curb side : Cutout Tree DPW 1     12 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
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
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
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
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
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
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
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
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
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
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
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
77810 1321 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 4050X Alemany Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     75 TR   5991740.4279021 2087082.0100679 37.7102553211792 -122.470345319704 (37.7102553211792, -122.470345319704) 9 8 4 64 24
77265 20512 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1211X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 60   5984783.6901595 2107169.3790132 37.7650051676015 -122.495869700491 (37.7650051676015, -122.495869700491) 11 6 2 55 8
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
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
74662 21131 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2292X Sunset Blvd 4 Median : Cutout Tree DPW 1     0 60   5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696 (37.7442358239277, -122.49474388696) 1 8 3 29491 35
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
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
73714 132189 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 43 Median : Yard Tree DPW 1     12 Width 8ft   6011411.36798 2120233.14388 37.8023987021982 -122.404690439238 (37.8023987021982, -122.404690439238) 3 1 10 308 23
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
72242 187396 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 49 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5985054.0302 2100695.3416 37.74724508117 -122.494457396667 (37.74724508117, -122.494457396667) 1 8 3 29491 35
71037 132174 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1111 Chestnut St 1 Front Yard : Yard Tree Private 2     52     6006441.86345 2120416.15353 37.8026221972261 -122.42190040729 (37.8026221972261, -122.42190040729) 5 9 1 28858 32
70780 211076 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 700x Miramar Ave 2 Median : Yard Tree DPW 1     74     5995394.80602 2094076.5012 37.7296711442905 -122.458221033586 (37.7296711442905, -122.458221033586) 9 7 4 28861 40
70483 132187 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 40 Median : Yard Tree DPW 1     14 Width 8ft   6011421.2833 2120182.68985 37.8022607219264 -122.404652573264 (37.8022607219264, -122.404652573264) 3 1 10 308 23
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
69354 111518 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 13 Front Yard : Yard Tree DPW 1     27     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
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
68881 16368 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 1 Median : Cutout Tree DPW 1     26 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
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
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
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
67974 201788 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 36 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   6015494.63123 2088072.87111 37.7143208438162 -122.388314323455 (37.7143208438162, -122.388314323455) 10 3 8 58 1
67798 211064 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 300x Miramar Ave 3 Median : Yard Tree DPW 1     35     5995363.79151 2092232.49572 37.7246061670234 -122.458194844436 (37.7246061670234, -122.458194844436) 9 7 4 28861 40
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
67122 201776 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 24 Sidewalk: Property side : Yard Tree Private 2     17 Width 8ft   6015607.24672 2087763.10237 37.7134765179931 -122.387903474463 (37.7134765179931, -122.387903474463) 10 3 8 58 1
66936 187102 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2600 Sunset Blvd 38 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5985165.8082 2097224.4952 37.7377216147142 -122.493815148362 (37.7377216147142, -122.493815148362) 1 8 3 29491 35
66441 109838 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 200x MONTCALM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6009924 2099647 37.7457907048197 -122.408384592716 (37.7457907048197, -122.408384592716) 2 7 7 28859 2
66190 194458 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 33 Sidewalk: Property side : Yard Tree Private 2     26     6012757.94703 2101850.0059 37.7519979787223 -122.398739722368 (37.7519979787223, -122.398739722368) 10 3 8 28856 29
65583 194443 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1900 23rd St 2 Front Yard : Yard Tree Private 2     28     6012732.21441 2102858.09004 37.7547645253758 -122.398899455441 (37.7547645253758, -122.398899455441) 10 3 8 28856 29
65486 201795 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 43 Sidewalk: Property side : Yard Tree Private 2     24 Width 8ft   6015420.28917 2088209.03426 37.7146906018698 -122.388580780005 (37.7146906018698, -122.388580780005) 10 3 8 58 1
63898 185202 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2500 Sunset Blvd 55 Sidewalk: Property side : Yard Tree Private 2     20 Width 0ft   5985155.2712 2097966.8909 37.7397594177965 -122.493906274966 (37.7397594177965, -122.493906274966) 1 8 3 29491 35
63289 111517 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 12 Front Yard : Yard Tree DPW 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
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
63026 186711 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984852.6024 2106104.2938 37.762084778312 -122.495552790494 (37.762084778312, -122.495552790494) 1 8 3 56 35
62980 211065 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 400x Miramar Ave 1 Median : Yard Tree DPW 1     25     5995367.47216 2092431.62053 37.7251531275117 -122.458196526171 (37.7251531275117, -122.458196526171) 9 7 4 28861 40
62583 234511 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300 San Jose Ave 59 Front Yard : Yard Tree Private 2     5 Width 10ft   6003237.34595 2095470.24367 37.7339455743229 -122.431207993878 (37.7339455743229, -122.431207993878) 2 7 5 63 7
61393 186897 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2700 Sunset Blvd 46 Sidewalk: Property side : Yard Tree Private 2     33 Width 0ft   5985183.7588 2096592.6965 37.7359879144627 -122.493706542591 (37.7359879144627, -122.493706542591) 1 8 3 29491 35
61382 234515 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6010924.44859 2100544.92665 37.7483121900522 -122.404988378323 (37.7483121900522, -122.404988378323) 2 7 7 28859 2
61019 132188 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 42 Median : Yard Tree DPW 1     17 Width 8ft   6011420.08981 2120201.09522 37.8023111918729 -122.404657999787 (37.8023111918729, -122.404657999787) 3 1 10 308 23
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
60775 211062 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2088 15th Ave 8 Sidewalk: Curb side : Pot Tree Private 2     33 Width 6ft   5991653.15073 2101238.7756 37.7491212147934 -122.47167795089 (37.7491212147934, -122.47167795089) 1 8 4 29491 12
60691 111521 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 16 Front Yard : Yard Tree DPW 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
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
60584 115235 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 58 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2016 12:00:00 AM 3 4x6 Permit Number 777338 5989295.30249 2114868.10873 37.7864069399285 -122.480829025898 (37.7864069399285, -122.480829025898) 11 6 1 55 33
60529 211074 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 650x Miramar Ave 5 Median : Yard Tree DPW 1     30     5995392.34643 2093881.33119 37.7291351132945 -122.458215416413 (37.7291351132945, -122.458215416413) 9 7 4 28861 40
59640 211078 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 97 Ashton Ave 1 Sidewalk: Property side : Yard Tree Private 2     25 Width 8ft   5994121.91269 2090532.87853 37.7198679898921 -122.462364611346 (37.7198679898921, -122.462364611346) 9 8 6 28861 24
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)
);