8,659 rows where qSpecies_id = 11 sorted by PlantDate

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)
10695 258140 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300 Beale St 14 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 3x3   6014765.94263 2115143.61778 37.7886109721909 -122.39272561329 (37.7886109721909, -122.39272561329) 6 2 9 28855 6
10746 130121 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 711 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2     31 Width 4ft   6006217.81711 2112104.31895 37.7797873339463 -122.422084889732 (37.7797873339463, -122.422084889732) 7 9 11 28852 10
10853 14629 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 580 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2     40 4X4   6006423.31397 2112182.40692 37.7800133326755 -122.42137953166 (37.7800133326755, -122.42137953166) 7 9 11 28852 41
10916 108180 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 835 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
10969 228599 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2128 Harrison St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008713.06185 2105976.62248 37.7631025330823 -122.413019323281 (37.7631025330823, -122.413019323281) 8 4 7 28859 19
11081 17829 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1955 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6004588.8583705 2115348.8927865 37.7886041154805 -122.427951442059 (37.7886041154805, -122.427951442059) 13 9 11 28858 27
11097 16603 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 85 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6002870.97589 2107811.22943 37.7678102375823 -122.433356210721 (37.7678102375823, -122.433356210721) 15 5 5 28862 3
11303 201004 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 901 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6015442.04514 2102505.24964 37.7539463230786 -122.389503397179 (37.7539463230786, -122.389503397179) 10 3 8 28856 29
11331 80222 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1032 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6010303.37801 2111828.67661 37.7792600686485 -122.407931631844 (37.7792600686485, -122.407931631844) 14 2 9 28853 34
11356 208342 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3600 19th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5990572.11827 2092496.71048 37.7250551346827 -122.474778147818 (37.7250551346827, -122.474778147818) 9 8 4 64 40
11376 200398 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1001x Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6011323 2110932 37.776855034552 -122.404341187165 (37.776855034552, -122.404341187165) 14 2 9 28853 34
11379 75978 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 500 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6007956.14824 2114165.55971 37.7855448944115 -122.416217249547 (37.7855448944115, -122.416217249547) 13 10 9 28858 36
11423 250609 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2201 Golden Gate Ave 34 Sidewalk: Property side : Yard Tree Private 2     5     5998802.7301 2111413.83913 37.7774704438335 -122.447687106294 (37.7774704438335, -122.447687106294) 15 6 2 29492 16
11437 192684 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1 Westbrook Ct 9 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017502.05989 2095577.15005 37.7350371705351 -122.38189744662 (37.7350371705351, -122.38189744662) 10 3 8 58 1
11499 201065 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1521 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6013096.76712 2105645.47776 37.7624383891432 -122.397834234559 (37.7624383891432, -122.397834234559) 10 3 8 28856 29
11510 470 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2490 Bryant St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6009704.8170941 2102845.113501 37.7545597392567 -122.409368154592 (37.7545597392567, -122.409368154592) 2 4 7 28859 19
11600 260651 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3751 Sacramento St 2 Front Yard : Cutout Tree Private 2       Width 3ft   5996933 2115011 37.7872402598449 -122.454414995547 (37.7872402598449, -122.454414995547) 11 6 1 54 31
11703 202393 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 101 Harrison St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6015702.17512 2115143.19393 37.7886617620833 -122.389486331656 (37.7886617620833, -122.389486331656) 6 2 9 28855 6
11815 192587 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1360 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008090.62264 2110584.41429 37.7757194889955 -122.415498377362 (37.7757194889955, -122.415498377362) 8 2 9 28853 34
11830 80810 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1400 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6015596.09754 2102496.67483 37.7539313187876 -122.388970044334 (37.7539313187876, -122.388970044334) 10 3 8 28856 29
11837 72084 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 262 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5988392.79943 2114246.03166 37.7846463939543 -122.48390578898 (37.7846463939543, -122.48390578898) 11 6 2 55 26
12078 249366 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 775 Post St 1 : Tree Private 2     11 Width 3ft   6008444.56493 2114842.41912 37.7874308375006 -122.414575379762 (37.7874308375006, -122.414575379762) 5 1 10 28858 36
12085 9686 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Gough St 4 Sidewalk: Curb side : Cutout Tree DPW 1     2 3x3   6005996.09112 2110833.49174 37.7762854431535 -122.422761599875 (37.7762854431535, -122.422761599875) 7 9 11 28852 10
12177 228104 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 291 Whitney St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6004325 2096691 37.7373590721786 -122.427534581259 (37.7373590721786, -122.427534581259) 2 7 5 63 7
12200 130313 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009225.50566 2121536.68624 37.8058554919917 -122.412346817477 (37.8058554919917, -122.412346817477) 3 1 10 308 23
12221 261589 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 299x 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006795 2107850 37.7681385292637 -122.41978620049 (37.7681385292637, -122.41978620049) 8 4 7 28853 19
12271 228569 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 508 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x6   6006139.40955 2106596.9487 37.7646609934284 -122.421964799655 (37.7646609934284, -122.421964799655) 8 4 5 28859 19
12295 108536 Section 143 10 Lophostemon confertus :: Brisbane Box 11 1036X Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009831.24398 2112235.16984 37.7803497589148 -122.409593644194 (37.7803497589148, -122.409593644194) 14 2 9 28853 34
12297 200435 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1661 Tennessee St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6015708.18731 2101467.74933 37.7511123182895 -122.388510593283 (37.7511123182895, -122.388510593283) 10 3 8 28856 1
12380 83478 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6015481.04355 2105634.6159 37.762541056634 -122.38958707191 (37.762541056634, -122.38958707191) 10 3 8 28856 29
12446 191567 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1610 Innes Ave 6 : Tree Private 2     5 Width 3ft   6015249.67467 2097458.39036 37.7400780324848 -122.389816171494 (37.7400780324848, -122.389816171494) 10 3 8 58 1
12452 130093 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 70 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6008660.01542 2112613.42872 37.7813226682591 -122.413672244582 (37.7813226682591, -122.413672244582) 7 10 9 28852 36
12520 228662 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     16 Width 3ft   6001863.4982 2104671.44362 37.7591319452903 -122.436616182999 (37.7591319452903, -122.436616182999) 2 4 5 28862 3
12531 229086 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 291 Putnam St 10 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6009099.73023 2096255.04832 37.7364309533249 -122.410995274037 (37.7364309533249, -122.410995274037) 10 7 7 28859 2
12635 74018 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 400 Locust St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5997681.3026 2115023.11514 37.7873164113684 -122.451826915892 (37.7873164113684, -122.451826915892) 11 6 1 54 31
12710 130149 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 355 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006347.46727 2111403.63239 37.7778707302976 -122.421586593341 (37.7778707302976, -122.421586593341) 7 9 11 28852 10
12748 75994 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 500 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6007959.81163 2114150.16473 37.7855028295219 -122.416203484529 (37.7855028295219, -122.416203484529) 13 10 9 28858 36
12763 202571 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 728 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6012197.01829 2110136.24558 37.7747188771942 -122.401261742457 (37.7747188771942, -122.401261742457) 14 2 9 28853 34
12774 255134 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 12 Sidewalk: Property side : Yard Tree DPW 1                              
12776 138397 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2445 PINE ST 15 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6002370.6113 2115041.6133 37.7876346612226 -122.435604240753 (37.7876346612226, -122.435604240753) 13 6 11 29490 27
12790 191613 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 202 Jessie St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6011974.62779 2114590.53506 37.7869369127497 -122.402344296849 (37.7869369127497, -122.402344296849) 12 2 9 28855 6
12831 177192 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2039 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6012440.20315 2088384.59608 37.715007056206 -122.398893561283 (37.715007056206, -122.398893561283) 10 3 8 309 1
12833 228133 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 127 Downey St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5998876.15346 2107427.17954 37.7665282890742 -122.447146129895 (37.7665282890742, -122.447146129895) 15 5 11 29492 9
12862 192569 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1252 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6008605.90777 2111078.72326 37.7771056940974 -122.413750843528 (37.7771056940974, -122.413750843528) 8 2 9 28853 34
12898 246897 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 550 Frederick St 4 : Tree Private 2     10 Width 3ft   5996851.54862 2107390.70797 37.7663122602365 -122.454146203593 (37.7663122602365, -122.454146203593) 15 5 11 29492 8
12965 87494 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2101X 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6015776.11419 2105772.8424 37.7629369535127 -122.388576170051 (37.7629369535127, -122.388576170051) 10 3 8 28856 29
13019 130300 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 815 Battery St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6012386.58963 2118971.9326 37.798990178098 -122.401226993538 (37.798990178098, -122.401226993538) 3 1 10 28860 6
13134 76293 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 753 Davis St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6013060.18531 2119122.80042 37.7994419813198 -122.398906706701 (37.7994419813198, -122.398906706701) 3 1 10 28860 6
13148 202819 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 560 Mission Bay Blvd North 13 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6014749.23519 2108723.69225 37.770982378473 -122.392334217477 (37.770982378473, -122.392334217477) 14 3 9 310 20
13163 255351 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 700 Brotherhood Way 32 Sidewalk: Curb side : Cutout Tree Private 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
13170 71778 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1035 Sutter St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6007638.65798 2115077.87772 37.7880320397014 -122.417380352623 (37.7880320397014, -122.417380352623) 13 1 10 28858 21
13320 130154 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 155 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6006852.76549 2111067.6012 37.7769765487554 -122.419814736462 (37.7769765487554, -122.419814736462) 7 9 11 28852 10
13325 259319 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1746 20th Ave 1 Front Yard : Yard Tree Private 2       3x3   5990028 2103516 37.7552797120334 -122.477464095722 (37.7552797120334, -122.477464095722) 1 8 3 56 35
13372 249467 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1000x Van Ness Ave 1 Median : Cutout Tree DPW 1     8 Width 3ft   6006503.72956 2113992.67034 37.7849884074321 -122.421229920427 (37.7849884074321, -122.421229920427) 13 9 11 28858 36
13402 19893 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 STAIRWAY33 25 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
13410 228994 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3111 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008923.64516 2100963.47499 37.7493493826769 -122.411936703211 (37.7493493826769, -122.411936703211) 2 4 7 28859 19
13480 26768 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1661 Pine St 15 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6006153.01253 2115563.98266 37.7892830640976 -122.42255498602 (37.7892830640976, -122.42255498602) 13 9 1 28858 41
13511 19889 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 STAIRWAY33 21 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
13562 73666 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 725 Ellis St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6007366.22469 2113649.85624 37.7840957097951 -122.418221641431 (37.7840957097951, -122.418221641431) 7 9 9 28858 36
13845 202404 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 427 Beale St 5 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6015261.80888 2114694.17939 37.7874044451078 -122.390978551515 (37.7874044451078, -122.390978551515) 6 2 9 28855 6
13858 229156 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3225 26th St 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008275.18244 2100928.13091 37.7492159331679 -122.414176608688 (37.7492159331679, -122.414176608688) 2 4 7 28859 19
14013 200426 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2833 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6015966.04609 2102385.20565 37.7536457471676 -122.387682886976 (37.7536457471676, -122.387682886976) 10 3 8 28856 29
14054 15140 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 780X Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6011508.1688 2113852.28114 37.7848837916732 -122.403906177321 (37.7848837916732, -122.403906177321) 12 2 9 28853 6
14092 23172 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 214 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006926.9126711 2111261.9734357 37.7775144249112 -122.419572031751 (37.7775144249112, -122.419572031751) 7 9 9 28852 36
14097 192524 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1036 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 5ft   6009831 2112235 37.7803492789029 -122.409594476247 (37.7803492789029, -122.409594476247) 14 2 9 28853 34
14188 172200 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 399 Naples St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6003544.90457 2091306.45225 37.7225301603163 -122.429847773766 (37.7225301603163, -122.429847773766) 9 7 6 28861 5
14215 70147 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2927 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5989529.51616 2111917.79074 37.7783198039619 -122.479802747413 (37.7783198039619, -122.479802747413) 11 6 2 55 26
14254 215913 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 45 San Benito Way 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 8ft   5992854.98914 2096471.13815 37.7360999515525 -122.467175416836 (37.7360999515525, -122.467175416836) 1 8 4 59 40
14287 4591 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     2 3x2   6011425.16703 2118064.77563 37.796445660597 -122.404489964152 (37.796445660597, -122.404489964152) 3 1 10 308 4
14329 208448 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 79 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   5994592.56957 2093111.81863 37.7269762295662 -122.46092454135 (37.7269762295662, -122.46092454135) 9 8 4 28861 40
14402 208305 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 600x Bosworth St 6 Median : Yard Tree DPW 1     1 Width 10ft   6002233.89157 2095386.08451 37.7336575763338 -122.434671221913 (37.7336575763338, -122.434671221913) 9 7 5 63 40
14409 177162 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 221 Hahn St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft Permit Number 780274 6007512.10716 2087312.1903 37.7117866217183 -122.415851310014 (37.7117866217183, -122.415851310014) 9 7 8 309 39
14416 75854 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 539 Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6013512.94688 2112177.08416 37.7803958844882 -122.396852757649 (37.7803958844882, -122.396852757649) 6 2 9 28856 34
14451 229092 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 701 Cortland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6007932 2097222 37.739020439369 -122.415101044746 (37.739020439369, -122.415101044746) 2 7 7 28859 2
14466 187649 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 890x Clipper Ter 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999832 2100719 37.7481638439189 -122.443358156196 (37.7481638439189, -122.443358156196) 2 4 5 63 22
14511 208454 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 314 Dorado Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5994351.80863 2093010.71485 37.7266847664821 -122.461749513755 (37.7266847664821, -122.461749513755) 9 8 4 28861 40
14617 200375 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 648 Hawthorne St 6 : Tree Private 2     18 Width 3ft   6013613.27103 2113399.30472 37.7837574055205 -122.396591388586 (37.7837574055205, -122.396591388586) 6 2 9 28856 6
14651 260677 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 601x McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006263 2112118 37.7798274470499 -122.421929554146 (37.7798274470499, -122.421929554146) 7 9 11 28852 10
14670 192696 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1 Westbrook Ct 21 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6017316.48432 2095599.65377 37.7350887115602 -122.382540619262 (37.7350887115602, -122.382540619262) 10 3 8 58 1
14702 19896 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 STAIRWAY33 28 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
14720 75940 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 539 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6013473.22084 2112140.331 37.7802927574459 -122.396987611901 (37.7802927574459, -122.396987611901) 6 2 9 28856 34
14723 256851 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1777 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6001446 2091921 37.7240984859228 -122.437147179411 (37.7240984859228, -122.437147179411) 9 7 6 28861 25
14753 259380 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198X Eddy St 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
14772 208283 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 950x Portola Dr 26 Median : Cutout Tree DPW 1     6 Width 3ft   5995702.36182 2098208.09954 37.7410331736343 -122.457456584654 (37.7410331736343, -122.457456584654) 9 7 4 59 40
14775 19897 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 STAIRWAY33 29 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
14780 262330 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 4 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
14799 202712 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 540 Mission Bay Blvd North 13 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6015184.7586 2108742.08475 37.7710570545607 -122.390829002375 (37.7710570545607, -122.390829002375) 14 3 9 310 20
14829 76313 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Townsend St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6015835.10862 2112662.38098 37.7818573808501 -122.388853134261 (37.7818573808501, -122.388853134261) 6 2 9 28856 6
14837 173721 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 922 Carolina St 2 Median : Cutout Tree DPW 1     10 3x3   6012422 2103621 37.7568420188621 -122.400025841962 (37.7568420188621, -122.400025841962) 10 3 8 28856 29
14864 70065 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 370 Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6014415.94114 2112258.25542 37.7806689825201 -122.393734537439 (37.7806689825201, -122.393734537439) 6 2 9 28856 6
14875 130179 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 Fell St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6006655.87102 2110834.54234 37.7763255313215 -122.420479309383 (37.7763255313215, -122.420479309383) 7 9 11 28852 10
14925 201057 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 751 19th St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6015304.81738 2105302.86151 37.7616203577189 -122.390173401083 (37.7616203577189, -122.390173401083) 10 3 8 28856 29
14945 228138 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 266 Rivoli St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5997642.73778 2105913.08582 37.7623004214351 -122.451303064403 (37.7623004214351, -122.451303064403) 15 5 11 29492 9
14956 75839 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 101 Henry Adams St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6011422.77778 2107820.32569 37.7683166647229 -122.403777018493 (37.7683166647229, -122.403777018493) 8 2 8 28853 20
14967 108631 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 501 ELLIS ST 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6008465.6 2113811.6 37.7846016393538 -122.4144296353 (37.7846016393538, -122.4144296353) 7 10 9 28852 36
15004 82837 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 604 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6004044.4214 2110838.57135 37.7761890816952 -122.429513325784 (37.7761890816952, -122.429513325784) 7 9 11 28852 10
15034 140327 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1435 LAGUNA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6004568.4782 2113773.262 37.7842766747196 -122.427909635375 (37.7842766747196, -122.427909635375) 13 9 11 29490 41
15084 130382 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1301 Sansome St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6011871.65245 2120205.75024 37.8023492008037 -122.403095691236 (37.8023492008037, -122.403095691236) 3 1 10 308 23
15136 228554 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 786 Valencia St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006236 2105017 37.760328272277 -122.421518501011 (37.760328272277, -122.421518501011) 2 4 5 28859 19
15175 228185 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1190 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006350.04834 2102712.73442 37.7540077233873 -122.420960454787 (37.7540077233873, -122.420960454787) 2 4 5 28859 19

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