trees

2,306 rows where qSpecies_id = 15 sorted by qSiteInfo descending

✎ View and edit SQL

This data as json, CSV (advanced)

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)
4407 185467 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 19 unknown : Yard Tree Private 2     3 Width 0ft   5985112.4406 2098402.8327 37.7409538906719 -122.494086484448 (37.7409538906719, -122.494086484448) 1 8 3 29491 35
9254 87113 Permitted Site 7 Pinus radiata :: Monterey Pine 15 470 West Portal Ave 4 unknown : Yard Tree Private 2   01/03/2008 12:00:00 AM     Permit Number 50062 5991694 2096460 37.7360022829337 -122.471188578306 (37.7360022829337, -122.471188578306) 1 8 4 29491 40
21921 185481 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 34 unknown : Yard Tree Private 2     26 Width 0ft   5985135.018 2098495.7982 37.7412104699771 -122.494015271118 (37.7412104699771, -122.494015271118) 1 8 3 29491 35
23834 107210 Undocumented 4 Pinus radiata :: Monterey Pine 15 603 PERALTA AVE 1 unknown : Yard Tree Private 2     30     6009839.9 2098688.7 37.7431547125392 -122.408607810015 (37.7431547125392, -122.408607810015) 10 7 7 28859 2
26178 181359 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 31 unknown : Yard Tree Private 2     22 Width 0ft   5985110.4485 2098473.2209 37.741147041149 -122.494098558838 (37.741147041149, -122.494098558838) 1 8 3 29491 35
30476 185415 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2300 Sunset Blvd 31 unknown : Yard Tree Private 2     16 Width 0ft   5985091.6384 2099216.8819 37.743187832897 -122.494218396427 (37.743187832897, -122.494218396427) 1 8 3 29491 35
38006 186548 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunset Blvd 19 unknown : Yard Tree Private 2     11 Width 0ft   5984713.0979 2104804.2446 37.7585070365446 -122.49593936599 (37.7585070365446, -122.49593936599) 1 8 3 56 35
38575 185464 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 16 unknown : Yard Tree Private 2     46 Width 0ft   5985103.8081 2098378.9273 37.7408877477521 -122.494114570537 (37.7408877477521, -122.494114570537) 1 8 3 29491 35
41505 185426 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2300 Sunset Blvd 42 unknown : Yard Tree Private 2     8 Width 0ft   5985086.6398 2099317.3541 37.7434634098799 -122.494243084048 (37.7434634098799, -122.494243084048) 1 8 3 29491 35
48827 185468 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 20 unknown : Yard Tree Private 2     6 Width 0ft   5985131.0337 2098396.1923 37.7409367458634 -122.494021708019 (37.7409367458634, -122.494021708019) 1 8 3 29491 35
50432 185406 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2300 Sunset Blvd 21 unknown : Yard Tree Private 2     15 Width 0ft   5985111.1331 2099102.9134 37.7428760469646 -122.494142591708 (37.7428760469646, -122.494142591708) 1 8 3 29491 35
54336 186575 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunset Blvd 46 unknown : Yard Tree Private 2     30 Width 0ft   5984766.4852 2104638.2207 37.7580543077882 -122.495742485113 (37.7580543077882, -122.495742485113) 1 8 3 56 35
62440 186536 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunset Blvd 7 unknown : Yard Tree Private 2     23 Width 0ft   5984741.2571 2104889.1409 37.7587417873337 -122.495848242848 (37.7587417873337, -122.495848242848) 1 8 3 56 35
65466 186576 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunset Blvd 47 unknown : Yard Tree Private 2     1 Width 0ft   5984768.5788 2104614.3534 37.7579888974289 -122.495733484153 (37.7579888974289, -122.495733484153) 1 8 3 56 35
67096 185405 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2300 Sunset Blvd 20 unknown : Yard Tree Private 2     23 Width 0ft   5985107.634 2099090.4168 37.7428415299236 -122.494153769583 (37.7428415299236, -122.494153769583) 1 8 3 29491 35
68762 87112 Permitted Site 7 Pinus radiata :: Monterey Pine 15 470 West Portal Ave 3 unknown : Yard Tree Private 2   01/03/2008 12:00:00 AM     Permit Number 50062 5991694 2096460 37.7360022829337 -122.471188578306 (37.7360022829337, -122.471188578306) 1 8 4 29491 40
75714 114950 Property Tree 8 Pinus radiata :: Monterey Pine 15 1X WOODACRE DR 2 unknown : Yard Tree DPW 1       30x100   5991187 2095315 37.7328290635508 -122.472857998502 (37.7328290635508, -122.472857998502) 1 8 4 64 40
78404 185480 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 33 unknown : Yard Tree Private 2     16 Width 0ft   5985125.7214 2098482.5174 37.7411734605092 -122.494046436406 (37.7411734605092, -122.494046436406) 1 8 3 29491 35
80134 185495 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 48 unknown : Yard Tree Private 2     8 Width 0ft   5985112.4406 2098617.3174 37.7415428078832 -122.494102288748 (37.7415428078832, -122.494102288748) 1 8 3 29491 35
84797 186549 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunset Blvd 20 unknown : Yard Tree Private 2     12 Width 0ft   5984751.8298 2104797.3357 37.7584903350171 -122.495804906083 (37.7584903350171, -122.495804906083) 1 8 3 56 35
87926 185461 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 11 unknown : Yard Tree Private 2     4 Width 0ft   5985111.1125 2098351.0376 37.7408115975576 -122.494087259969 (37.7408115975576, -122.494087259969) 1 8 3 29491 35
94199 185473 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 25 unknown : Yard Tree Private 2     12 Width 0ft   5985104.4721 2098432.7145 37.7410354717752 -122.494116238038 (37.7410354717752, -122.494116238038) 1 8 3 29491 35
105057 186572 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunset Blvd 43 unknown : Yard Tree Private 2     1 Width 0ft   5984761.0418 2104653.2947 37.7580953780168 -122.495762422342 (37.7580953780168, -122.495762422342) 1 8 3 56 35
110315 185498 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 52 unknown : Yard Tree Private 2     33 Width 0ft   5985102.48 2098665.7923 37.7416753240459 -122.494140300571 (37.7416753240459, -122.494140300571) 1 8 3 29491 35
113568 105140 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 125X ESMERALDA AVE 1 unknown : Yard Tree DPW 1     12     6007213 2098808 37.7433348108676 -122.417699407763 (37.7433348108676, -122.417699407763) 2 7 7 28859 2
113701 181357 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 12 unknown : Yard Tree Private 2     25 Width 0ft   5985137.6741 2098360.3342 37.7408386777143 -122.49399610624 (37.7408386777143, -122.49399610624) 1 8 3 29491 35
128515 105137 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 175X ESMERALDA AVE 3 unknown : Yard Tree DPW 1     18     6007213 2098808 37.7433348108676 -122.417699407763 (37.7433348108676, -122.417699407763) 2 7 7 28859 2
131325 185463 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 15 unknown : Yard Tree Private 2     4 Width 0ft   5985112.4406 2098384.9036 37.7409046621901 -122.494085163354 (37.7409046621901, -122.494085163354) 1 8 3 29491 35
133884 114949 Property Tree 8 Pinus radiata :: Monterey Pine 15 1X WOODACRE DR 1 unknown : Yard Tree DPW 1     30 30x100   5991187 2095315 37.7328290635508 -122.472857998502 (37.7328290635508, -122.472857998502) 1 8 4 64 40
135310 87111 Permitted Site 7 Pinus radiata :: Monterey Pine 15 470 West Portal Ave 2 unknown : Yard Tree Private 2   01/03/2008 12:00:00 AM     Permit Number 50062 5991694 2096460 37.7360022829337 -122.471188578306 (37.7360022829337, -122.471188578306) 1 8 4 29491 40
146584 186557 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunset Blvd 28 unknown : Yard Tree Private 2     36 Width 0ft   5984754.7609 2104747.5076 37.758353692586 -122.495791093621 (37.758353692586, -122.495791093621) 1 8 3 56 35
147972 186538 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunset Blvd 9 unknown : Yard Tree Private 2     29 Width 0ft   5984747.9566 2104882.4413 37.7587237844572 -122.495824579043 (37.7587237844572, -122.495824579043) 1 8 3 56 35
149611 185479 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 32 unknown : Yard Tree Private 2     17 Width 0ft   5985115.7608 2098477.2051 37.7411582915345 -122.494080484656 (37.7411582915345, -122.494080484656) 1 8 3 29491 35
150581 186546 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunset Blvd 17 unknown : Yard Tree Private 2     3 Width 0ft   5984749.2128 2104853.9681 37.7586456785511 -122.495818134238 (37.7586456785511, -122.495818134238) 1 8 3 56 35
154588 181358 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 14 unknown : Yard Tree Private 2     11 Width 0ft   5985132.3618 2098384.2396 37.7409040046765 -122.49401623531 (37.7409040046765, -122.49401623531) 1 8 3 29491 35
155725 186547 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunset Blvd 18 unknown : Yard Tree Private 2     49 Width 0ft   5984724.5081 2104844.7562 37.7586189383832 -122.495902893491 (37.7586189383832, -122.495902893491) 1 8 3 56 35
158175 185491 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 44 unknown : Yard Tree Private 2     11 Width 0ft   5985120.4091 2098579.4672 37.7414393477039 -122.494071947824 (37.7414393477039, -122.494071947824) 1 8 3 29491 35
158491 185475 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 27 unknown : Yard Tree Private 2     7 Width 0ft   5985123.7293 2098442.675 37.7410639474436 -122.494050388555 (37.7410639474436, -122.494050388555) 1 8 3 29491 35
158883 181352 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2300 Sunset Blvd 13 unknown : Yard Tree Private 2     25 Width 0ft   5985091.6384 2099018.9366 37.7426443285892 -122.494203809651 (37.7426443285892, -122.494203809651) 1 8 3 29491 35
168147 107817 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 501X BROTHERHOOD WAY   unknown : Yard Tree DPW 1           5991892 2087849 37.7123700531512 -122.469877266524 (37.7123700531512, -122.469877266524) 9 8 4 64 24
172129 105139 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 175X ESMERALDA AVE 4 unknown : Yard Tree DPW 1     25     6007213 2098808 37.7433348108676 -122.417699407763 (37.7433348108676, -122.417699407763) 2 7 7 28859 2
176590 87115 Permitted Site 7 Pinus radiata :: Monterey Pine 15 470 West Portal Ave 6 unknown : Yard Tree Private 2   01/03/2008 12:00:00 AM     Permit Number 50062 5991694 2096460 37.7360022829337 -122.471188578306 (37.7360022829337, -122.471188578306) 1 8 4 29491 40
178417 185459 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 9 unknown : Yard Tree Private 2     28 Width 0ft   5985114.4327 2098335.7647 37.7407698565631 -122.494074654765 (37.7407698565631, -122.494074654765) 1 8 3 29491 35
183512 87114 Permitted Site 7 Pinus radiata :: Monterey Pine 15 470 West Portal Ave 5 unknown : Yard Tree Private 2   01/03/2008 12:00:00 AM     Permit Number 50062 5991694 2096460 37.7360022829337 -122.471188578306 (37.7360022829337, -122.471188578306) 1 8 4 29491 40
186602 105138 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 175X ESMERALDA AVE 4 unknown : Yard Tree DPW 1     25     6007213 2098808 37.7433348108676 -122.417699407763 (37.7433348108676, -122.417699407763) 2 7 7 28859 2
189065 181353 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2300 Sunset Blvd 15 unknown : Yard Tree Private 2     34 Width 0ft   5985103.1353 2099041.4304 37.7427067632535 -122.49416571483 (37.7427067632535, -122.49416571483) 1 8 3 29491 35
193681 185412 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2300 Sunset Blvd 28 unknown : Yard Tree Private 2     47 Width 0ft   5985078.1422 2099185.3906 37.7431005765205 -122.494262741341 (37.7431005765205, -122.494262741341) 1 8 3 29491 35
194125 185477 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 29 unknown : Yard Tree Private 2     38 Width 0ft   5985132.3618 2098455.9558 37.7411009180553 -122.494021519499 (37.7411009180553, -122.494021519499) 1 8 3 29491 35
34 262408 Property Tree 8 Pinus radiata :: Monterey Pine 15 66X Edgehill Way 1 Unaccepted Street : Yard Tree Private 2       3x3   5994840 2098758 37.7424934921887 -122.46047813267 (37.7424934921887, -122.46047813267) 1 8 4 59 40
159 117627 Undocumented 4 Pinus radiata :: Monterey Pine 15 890x VERMONT ST 4 Unaccepted Street : Yard Tree Private 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
844 254210 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 300x Esmeralda Ave 20 Unaccepted Street : Yard Tree DPW 1                              
5279 258778 Undocumented 4 Pinus radiata :: Monterey Pine 15 701X Ortega Way 1 Unaccepted Street : Yard Tree Private 2       10x10   5991876 2102480 37.7525421857889 -122.470997752755 (37.7525421857889, -122.470997752755) 1 8 4 29491 12
12659 122532 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1900X Castro St 1 Unaccepted Street : Yard Tree Private 2                              
12948 258070 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1X Selma Way 1 Unaccepted Street : Yard Tree Private 2       6x10   5992537 2103375 37.7550378314458 -122.468777042949 (37.7550378314458, -122.468777042949) 1 8 4 56 12
19314 114270 Undocumented 4 Pinus radiata :: Monterey Pine 15 27x ESMERALDA AVE 2 Unaccepted Street : Yard Tree Private 2       3x3   6006799 2098981 37.743786524331 -122.41914318493 (37.743786524331, -122.41914318493) 2 7 7 28859 2
24524 107157 Undocumented 4 Pinus radiata :: Monterey Pine 15 301X Esmeralda Ave 1 Unaccepted Street : Yard Tree Private 2     28     6007313 2098782 37.7432690474632 -122.417351790512 (37.7432690474632, -122.417351790512) 2 7 7 28859 2
28400 99274 Undocumented 4 Pinus radiata :: Monterey Pine 15 16 Joy St 1 Unaccepted Street : Yard Tree Private 2       3x3 Permit Number 768828 6010347.9 2098933.4 37.7438550437031 -122.406868515265 (37.7438550437031, -122.406868515265) 2 7 7 28859 2
29224 116662 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 199x Esmeralda Ave 15 Unaccepted Street : Yard Tree DPW 1           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452) 2 7 7 28859 2
33354 173755 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1X Emil Ln 1 Unaccepted Street : Yard Tree Private 2       3x3   5996276 2095955 37.7348796446223 -122.455310374086 (37.7348796446223, -122.455310374086) 9 7 4 59 40
50881 255163 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1599X Shotwell St 1 Unaccepted Street : Yard Tree DPW 1       3x3   6008036 2099273 37.744657875903 -122.414886580728 (37.744657875903, -122.414886580728) 2 7 7 28859 2
51208 255164 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1599X Shotwell St 2 Unaccepted Street : Yard Tree DPW 1       3x3   6008036 2099273 37.744657875903 -122.414886580728 (37.744657875903, -122.414886580728) 2 7 7 28859 2
51304 255705 Significant Tree 6 Pinus radiata :: Monterey Pine 15 200X Blairwood Ln 1 Unaccepted Street : Yard Tree Private 2       10x10   5995660 2102951 37.7540535603115 -122.457946200633 (37.7540535603115, -122.457946200633) 1 5 4 63 12
61216 116672 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100 Esmeralda Ave 9 Unaccepted Street : Yard Tree DPW 1           6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
67245 117626 Undocumented 4 Pinus radiata :: Monterey Pine 15 890x VERMONT ST 3 Unaccepted Street : Yard Tree Private 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
71480 112615 Undocumented 4 Pinus radiata :: Monterey Pine 15 1798x 22ND ST 2 Unaccepted Street : Yard Tree Private 2   05/02/2016 12:00:00 AM 3     6012787 2103832 37.7574417223043 -122.398778335858 (37.7574417223043, -122.398778335858) 10 3 8 28856 29
84538 256609 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1X Gatun Aly 1 Unaccepted Street : Yard Tree DPW 1       10x10   5998560 2096991 37.7378550371804 -122.447488368884 (37.7378550371804, -122.447488368884) 9 7 4 59 40
85873 97535 Permitted Site 7 Pinus radiata :: Monterey Pine 15 300 Winfield St 1 Unaccepted Street : Yard Tree Private 2           6006649.9 2098038.3 37.7411896837785 -122.419591868256 (37.7411896837785, -122.419591868256) 2 7 7 28859 2
87825 251409 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 95x Andover St 1 Unaccepted Street : Yard Tree Private 2       3x3   6007642 2098274 37.7418926973203 -122.416178220561 (37.7418926973203, -122.416178220561) 2 7 7 28859 2
89775 116666 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100x Esmeralda Ave 2 Unaccepted Street : Yard Tree DPW 1           6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
98353 109309 Undocumented 4 Pinus radiata :: Monterey Pine 15 349x MAYFLOWER ST 1 Unaccepted Street : Yard Tree Private 2           6009941 2098430 37.7424500403346 -122.408239989358 (37.7424500403346, -122.408239989358) 10 7 7 28859 2
99208 112729 Undocumented 4 Pinus radiata :: Monterey Pine 15 444 Franconia St 2 Unaccepted Street : Yard Tree Private 2     24     6009949.70212209 2098546.33795552 37.7427699663381 -122.408218103257 (37.7427699663381, -122.408218103257) 10 7 7 28859 2
104230 116661 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 199x Esmeralda Ave 14 Unaccepted Street : Yard Tree DPW 1           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452) 2 7 7 28859 2
107501 258345 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 590X Quintara St 1 Unaccepted Street : Yard Tree Private 2       10x10   5991699 2101183 37.7489707220162 -122.471515341363 (37.7489707220162, -122.471515341363) 1 8 4 29491 12
115258 97537 Permitted Site 7 Pinus radiata :: Monterey Pine 15 300 Winfield St 3 Unaccepted Street : Yard Tree Private 2           6006649.9 2098038.3 37.7411896837785 -122.419591868256 (37.7411896837785, -122.419591868256) 2 7 7 28859 2
117021 116658 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 199x Esmeralda Ave 12 Unaccepted Street : Yard Tree DPW 1           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452) 2 7 7 28859 2
119278 116656 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 199x Esmeralda Ave 10 Unaccepted Street : Yard Tree DPW 1           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452) 2 7 7 28859 2
122782 255708 Significant Tree 6 Pinus radiata :: Monterey Pine 15 200X Blairwood Ln 2 Unaccepted Street : Yard Tree Private 2       10x10   5995660 2102951 37.7540535603115 -122.457946200633 (37.7540535603115, -122.457946200633) 1 5 4 63 12
125905 102521 Undocumented 4 Pinus radiata :: Monterey Pine 15 1X 31st St 1 Unaccepted Street : Yard Tree Private 2           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233) 9 7 4 59 40
130332 102729 Undocumented 4 Pinus radiata :: Monterey Pine 15 49X Esmeralda Ave 1 Unaccepted Street : Yard Tree Private 2     24     6006840.1 2099056.7 37.7439966940099 -122.419006438675 (37.7439966940099, -122.419006438675) 2 7 7 28859 2
136498 116665 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100x Esmeralda Ave 1 Unaccepted Street : Yard Tree DPW 1     25     6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
165174 112379 Undocumented 4 Pinus radiata :: Monterey Pine 15 25x ESMERALDA AVE 1 Unaccepted Street : Yard Tree Private 2     20 3x3   6006716 2099027 37.7439081554699 -122.419433442615 (37.7439081554699, -122.419433442615) 2 7 7 28859 2
177814 173756 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1X Emil Ln 2 Unaccepted Street : Yard Tree Private 2       3x3   5996276 2095955 37.7348796446223 -122.455310374086 (37.7348796446223, -122.455310374086) 9 7 4 59 40
180287 116659 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 199x Esmeralda Ave 12 Unaccepted Street : Yard Tree DPW 1           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452) 2 7 7 28859 2
180982 113477 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 100x Esmeralda Ave 10 Unaccepted Street : Yard Tree DPW 1     24     6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
186015 97536 Permitted Site 7 Pinus radiata :: Monterey Pine 15 300 Winfield St 2 Unaccepted Street : Yard Tree Private 2         Permit Number 768224 6006649.9 2098038.3 37.7411896837785 -122.419591868256 (37.7411896837785, -122.419591868256) 2 7 7 28859 2
192530 114586 Undocumented 4 Pinus radiata :: Monterey Pine 15 155x BRONTE ST 1 Unaccepted Street : Yard Tree Private 2     15 3x3 Permit Number 777226 6009330 2096609 37.7374157381662 -122.410224113722 (37.7374157381662, -122.410224113722) 10 7 7 28859 2
192771 116657 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 199x Esmeralda Ave 11 Unaccepted Street : Yard Tree DPW 1           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452) 2 7 7 28859 2
193436 105653 Undocumented 4 Pinus radiata :: Monterey Pine 15 150 BRONTE ST 3 Unaccepted Street : Yard Tree Private 2     16   Permit Number 770978 6009287.5 2096640.3 37.737499298819 -122.410373266073 (37.737499298819, -122.410373266073) 10 7 7 28859 2
6239 261665 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 401X Greenwich St 1 Unaccepted Street : Cutout Tree DPW 1                              
6814 259576 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 300 Public Park 2 Unaccepted Street : Cutout Tree Private 2       4x4   5994278 2098760 37.7424666368704 -122.462421492412 (37.7424666368704, -122.462421492412) 1 8 4 59 40
69278 111914 Undocumented 4 Pinus radiata :: Monterey Pine 15 60 LOWER TER 1 Unaccepted Street : Cutout Tree Private 2     28 3x3   6000264 2106046 37.7628151124003 -122.442246670025 (37.7628151124003, -122.442246670025) 15 5 5 28862 3
104363 114768 Undocumented 4 Pinus radiata :: Monterey Pine 15 155X Bronte St 1 Unaccepted Street : Cutout Tree Private 2     12     6009330.8 2096609.5 37.737417155901 -122.410221383029 (37.737417155901, -122.410221383029) 10 7 7 28859 2
104452 110629 Undocumented 4 Pinus radiata :: Monterey Pine 15 1000X MANDALAY LN 1 Unaccepted Street : Cutout Tree Private 2           5991616 2101838 37.7507643799851 -122.471850083311 (37.7507643799851, -122.471850083311) 1 8 4 29491 12
116312 121792 Undocumented 4 Pinus radiata :: Monterey Pine 15 2556 Broderick St 1 Unaccepted Street : Cutout Tree Private 2       3x3   6000243 2117343 37.7938325936105 -122.443130684772 (37.7938325936105, -122.443130684772) 13 9 1 57 27
180807 116778 Undocumented 4 Pinus radiata :: Monterey Pine 15 398x GAVEN ST 1 Unaccepted Street : Cutout Tree Private 2     30 3x3   6008462 2094745 37.7322489055387 -122.413093441799 (37.7322489055387, -122.413093441799) 9 3 7 309 28
256 254254 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
515 262251 Undocumented 4 Pinus radiata :: Monterey Pine 15 4210 Ocean Ave 4 Sidewalk: Property side : Yard Tree Private 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
567 181420 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1500 Sunset Blvd 53 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984891.1718 2104759.369 37.7583942485176 -122.495320206303 (37.7583942485176, -122.495320206303) 1 8 3 56 35
748 259270 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 8 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
1038 259268 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 6 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14

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