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)
5686 129917 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 506 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6004089.66416 2110540.0338 37.7753719324971 -122.429335525339 (37.7753719324971, -122.429335525339) 7 9 11 28852 10
5691 228657 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 200 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001411.17707 2104612.02532 37.7589430822727 -122.438176265734 (37.7589430822727, -122.438176265734) 2 4 5 28862 3
5778 228654 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4244 19th St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001858.18826 2104709.38537 37.7592358223878 -122.436637263122 (37.7592358223878, -122.436637263122) 2 4 5 28862 3
5858 191644 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 90 03rd St 12 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6012351.37316 2113981.62151 37.7852860020951 -122.400998036035 (37.7852860020951, -122.400998036035) 12 2 9 28853 6
5871 75838 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 101 Henry Adams St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6011420.31077 2107843.20731 37.7683793546411 -122.403787161967 (37.7683793546411, -122.403787161967) 8 2 8 28853 20
5899 228878 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 317 Buchanan St 2 : Tree Private 2     10 Width 4ft   6004644.50049 2109700.89583 37.7730992602639 -122.427356425982 (37.7730992602639, -122.427356425982) 7 9 11 28852 10
5911 228080 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 890 Clipper Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5999913.84424 2100703.76258 37.7481266725268 -122.443074048252 (37.7481266725268, -122.443074048252) 2 4 5 63 22
5920 4544 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 66 Cleary Ct 7 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6004823.98553 2113713.43923 37.784126867551 -122.427021407244 (37.784126867551, -122.427021407244) 13 9 11 28858 41
5933 71780 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1080 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3   Permit Number 768726 6007445.70481 2115106.99549 37.7881011319113 -122.418050003112 (37.7881011319113, -122.418050003112) 13 1 10 28858 21
5944 130091 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 740 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6005787.47808 2112322.76962 37.780362864998 -122.423589158734 (37.780362864998, -122.423589158734) 7 9 11 28852 41
5966 229069 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 134 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5997862.26563 2106825.97053 37.7648195394167 -122.450609621445 (37.7648195394167, -122.450609621445) 15 5 11 29492 9
6105 130370 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1401 Sansome St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6011756.98576 2121020.06086 37.8045786948161 -122.403549821892 (37.8045786948161, -122.403549821892) 3 1 10 28860 6
6123 19258 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1868X Ellis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6001940.6587 2112948.30853 37.7818625502091 -122.436941871627 (37.7818625502091, -122.436941871627) 15 5 11 29490 41
6263 200452 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1000 Indiana St 7 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6014967.99048 2103722.97568 37.7572636433306 -122.391227918229 (37.7572636433306, -122.391227918229) 10 3 8 28856 29
6287 6206 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1155 Ellis St 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6005354.90901 2113296.39872 37.7830117847389 -122.425154916389 (37.7830117847389, -122.425154916389) 7 9 11 28858 41
6375 138396 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2445 PINE ST 14 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6002330.0089 2115035.313 37.7876150559957 -122.43574426598 (37.7876150559957, -122.43574426598) 13 6 11 29490 27
6384 228964 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1 Woodward St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6006487.40312 2108404.39444 37.7696434318162 -122.420889513561 (37.7696434318162, -122.420889513561) 8 4 7 28853 19
6520 73325 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 141 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6008557.19392 2112976.99217 37.7823151519537 -122.414053685727 (37.7823151519537, -122.414053685727) 7 10 9 28852 36
6648 255227 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
6653 202390 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 101 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6015657.26603 2115099.16371 37.7885383750805 -122.389638635413 (37.7885383750805, -122.389638635413) 6 2 9 28855 6
6830 260679 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 601x McAllister St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006263 2112118 37.7798274470499 -122.421929554146 (37.7798274470499, -122.421929554146) 7 9 11 28852 10
6848 177189 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2049 Bay Shore Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6012400.79335 2088277.25976 37.7147101360364 -122.399022249793 (37.7147101360364, -122.399022249793) 10 3 8 309 1
7019 258770 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 399 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
7035 3622 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 58 Sidewalk: Curb side : Cutout Tree Port 6     6 3X3   6017832.21147 2098347.65106 37.7426626399605 -122.380948529647 (37.7426626399605, -122.380948529647) 10 3 8 58 1
7044 70398 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 153 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15 3x3 Permit Number 775403 6006428.67416 2093189.72166 37.7278640951339 -122.420012793267 (37.7278640951339, -122.420012793267) 9 7 7 309 5
7086 255139 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 17 Sidewalk: Property side : Yard Tree DPW 1                              
7107 9706 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 500X Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4X4   6005904.98118 2111477.12508 37.7780475630877 -122.423122534696 (37.7780475630877, -122.423122534696) 7 9 11 28852 10
7221 75198 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 675 17th Ave 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5990644.77295 2110703.64966 37.7750508336714 -122.475856010882 (37.7750508336714, -122.475856010882) 11 6 2 55 26
7273 72083 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 258 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     5988389.53404 2114272.57287 37.7847190784909 -122.483919032846 (37.7847190784909, -122.483919032846) 11 6 2 55 26
7298 108182 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 835 Sacramento St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010686.57825 2116924.79472 37.7932742451254 -122.406965263124 (37.7932742451254, -122.406965263124) 3 1 10 28857 4
7311 255140 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 18 Sidewalk: Property side : Yard Tree DPW 1                              
7314 249340 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 839 Post St 2 : Tree Private 2     2 Width 3ft   6008138.31912 2114803.99526 37.7873081250076 -122.415632209079 (37.7873081250076, -122.415632209079) 13 1 9 28858 36
7339 130136 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 520 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6005895.11777 2111561.87287 37.7782797032844 -122.423162681334 (37.7782797032844, -122.423162681334) 7 9 11 28852 10
7434 201009 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2200 03rd St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6015701.77252 2105218.85803 37.7614117114021 -122.388794618095 (37.7614117114021, -122.388794618095) 10 3 8 28856 29
7506 24586 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 701 Cortland Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X2   6007916.4009439 2097214.6000353 37.7389992440645 -122.415154455625 (37.7389992440645, -122.415154455625) 2 7 7 28859 2
7507 228121 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1049 Stanyan St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5997257.33539 2106808.69418 37.7647374591841 -122.452700661207 (37.7647374591841, -122.452700661207) 15 5 11 29492 12
7548 6171 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1075 Ellis St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6005893.15301 2113273.27935 37.782978696051 -122.423291166859 (37.782978696051, -122.423291166859) 7 9 11 28858 41
7597 9777 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 897X Gough St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5     30 3X3   6005678.151576 2112736.5747486 37.7814929008439 -122.42399680549 (37.7814929008439, -122.42399680549) 7 9 11 28852 41
7678 171106 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1830 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 4ft   6001167.19025 2091451.63812 37.7227938721177 -122.438077374487 (37.7227938721177, -122.438077374487) 9 7 6 28861 25
7699 75956 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2650 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   14     6009924.38993 2105515.09453 37.7619032061973 -122.408797167259 (37.7619032061973, -122.408797167259) 8 4 8 28859 19
7718 129913 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 514 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6004072.23496 2110659.68324 37.7756994736965 -122.429404351323 (37.7756994736965, -122.429404351323) 7 9 11 28852 10
7773 202730 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 20 Long Bridge St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6014698.52832 2109348.18499 37.7726942811501 -122.39255330579 (37.7726942811501, -122.39255330579) 14 3 9 310 20
7805 75950 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 500 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6007955.1578 2114181.95625 37.7855898596379 -122.416221837886 (37.7855898596379, -122.416221837886) 13 10 9 28858 36
7862 202661 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 218 De Haro St 5 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6011922.25622 2107759.5157 37.7681775845587 -122.402045084306 (37.7681775845587, -122.402045084306) 8 3 8 28853 20
7893 202663 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 218 De Haro St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6011923.93808 2107731.81935 37.7681016305051 -122.402037319578 (37.7681016305051, -122.402037319578) 8 3 8 28853 20
7967 130244 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2041 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6006851.67762 2118267.24784 37.7967449477794 -122.420329629819 (37.7967449477794, -122.420329629819) 13 9 10 28858 32
7995 10225 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1399 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6005877.37579 2100867.12021 37.7489134363237 -122.422463939564 (37.7489134363237, -122.422463939564) 2 4 5 28859 19
8182 130186 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 400 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6005950.50335 2111126.42384 37.7770871914573 -122.422940125193 (37.7770871914573, -122.422940125193) 7 9 11 28852 10
8320 228169 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 998X Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6007884.41338 2097705.90914 37.7403464729105 -122.41529982502 (37.7403464729105, -122.41529982502) 2 7 7 28859 2
8336 75176 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 288 Eddy St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6009077.63424 2113593.69297 37.7840376819271 -122.412296788176 (37.7840376819271, -122.412296788176) 14 10 9 28852 36
8347 228684 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 62 Hattie St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6000604.28151 2105342.27202 37.7609022364703 -122.44101927002 (37.7609022364703, -122.44101927002) 15 4 5 28862 3
8373 16614 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 107 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 privately planted on dpw street without permit 6002879.45304 2107636.12058 37.7673299123847 -122.433314375152 (37.7673299123847, -122.433314375152) 15 5 5 28862 3
8428 228137 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 266 Rivoli St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5997698.72333 2105921.93859 37.762327934407 -122.451110070772 (37.762327934407, -122.451110070772) 15 5 11 29492 9
8457 228924 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 101 Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009156.65799 2107915.57114 37.7684513309854 -122.411622071816 (37.7684513309854, -122.411622071816) 8 4 7 28853 19
8470 14592 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1222 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 3x3   5999472.8199 2108630.0925 37.7698652586639 -122.445168866065 (37.7698652586639, -122.445168866065) 15 5 11 29492 9
8518 228930 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 320 Alabama St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6008887.03334 2106683.34034 37.7650527821801 -122.412467570328 (37.7650527821801, -122.412467570328) 8 4 7 28859 19
8523 75002 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Townsend St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6015627.97358 2112537.98479 37.7815043339974 -122.389561041014 (37.7815043339974, -122.389561041014) 6 2 9 28856 6
8669 262474 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 600X Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6010564 2086911 37.7108561363482 -122.405274840324 (37.7108561363482, -122.405274840324) 9 7 8 309 39
8857 201013 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2300 03rd St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6015729.06101 2104726.43268 37.7600611293379 -122.388665862166 (37.7600611293379, -122.388665862166) 10 3 8 28856 29
8861 208247 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 65 San Lorenzo Way 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   5993716.65368 2097514.87622 37.7390154978753 -122.464272068903 (37.7390154978753, -122.464272068903) 1 8 4 59 40
8941 202669 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 218 De Haro St 13 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6011932.32743 2107606.1916 37.7677571532853 -122.401999468915 (37.7677571532853, -122.401999468915) 8 3 8 28853 20
8998 208278 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 950x Portola Dr 20 Median : Cutout Tree DPW 1     1 Width 3ft   5995821.66146 2098283.49942 37.7412470549149 -122.457049545217 (37.7412470549149, -122.457049545217) 9 7 4 59 40
9071 235849 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1165 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008684.91022 2101773.09182 37.7515590124405 -122.412819488553 (37.7515590124405, -122.412819488553) 2 4 7 28859 19
9104 192527 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1064 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6009654 2112066 37.7798753251135 -122.410194868954 (37.7798753251135, -122.410194868954) 14 2 9 28853 34
9181 26766 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1661 Pine St 13 Sidewalk: Curb side : Cutout Tree Private 2     8 3X3   6006110.12347 2115558.4451 37.7892654396548 -122.422702983606 (37.7892654396548, -122.422702983606) 13 9 1 28858 41
9219 74232 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 400 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5997684.08326 2115006.73382 37.7872715918672 -122.451816113239 (37.7872715918672, -122.451816113239) 11 6 1 54 31
9232 228951 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 118 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 6ft   6005386.85226 2102866.95811 37.7543768447429 -122.424302388563 (37.7543768447429, -122.424302388563) 2 4 5 28859 19
9313 129991 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1020 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6005653.15394 2113299.68835 37.7830376609932 -122.42412334433 (37.7830376609932, -122.42412334433) 7 9 11 28858 41
9352 200404 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 325 09th St 3 : Tree Private 2     4 Width 3ft   6009328.24749 2109756.9252 37.7735168847176 -122.411158642161 (37.7735168847176, -122.411158642161) 8 2 9 28853 34
9379 130406 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 502 Clay St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6012089.1118 2117473.06923 37.7948580586012 -122.402150938127 (37.7948580586012, -122.402150938127) 3 1 10 28860 4
9424 101331 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 15X Kittredge Ter 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   5997920.7 2111591.6 37.7779080793099 -122.450751145765 (37.7779080793099, -122.450751145765) 15 6 2 54 16
9536 1292 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3990 Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     10 3X3   5992119.08452 2087279.95314 37.710820711192 -122.469051013205 (37.710820711192, -122.469051013205) 9 8 4 64 24
9539 202541 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 128 Townsend St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6015188.49279 2112122.3947 37.7803388396032 -122.391052389471 (37.7803388396032, -122.391052389471) 6 2 9 28856 6
9601 173361 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 900 07th St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6012636.36156 2108430.77871 37.7700605526858 -122.399622186641 (37.7700605526858, -122.399622186641) 14 3 8 28856 20
9627 228661 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     13 Width 3ft   6001838.07707 2104669.16217 37.7591242363206 -122.436703937943 (37.7591242363206, -122.436703937943) 2 4 5 28862 3
9628 27690 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 450 Guerrero St 5 Sidewalk: Curb side : Cutout Tree DPW 1     8 3X3   6005509.4056 2106243.43481 37.7636547770557 -122.424118675948 (37.7636547770557, -122.424118675948) 8 4 5 28859 19
9678 257993 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1299x Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004575 2113275 37.7829089401984 -122.427851556708 (37.7829089401984, -122.427851556708) 7 9 11 29490 41
9693 177161 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 221 Hahn St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6007505.03845 2087315.42394 37.7117951032216 -122.415875970325 (37.7117951032216, -122.415875970325) 9 7 8 309 39
9706 260678 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 601x McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006263 2112118 37.7798274470499 -122.421929554146 (37.7798274470499, -122.421929554146) 7 9 11 28852 10
9927 83681 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6009001.7145 2113646.06927 37.7841772342254 -122.412563147579 (37.7841772342254, -122.412563147579) 14 10 9 28852 36
9981 75898 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2650 18th St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6009892.14521 2105512.72299 37.761894888355 -122.408908522215 (37.761894888355, -122.408908522215) 8 4 8 28859 19
10147 6311 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1810 Ellis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6002204.0653085 2112986.0752356 37.7819812157954 -122.436033311752 (37.7819812157954, -122.436033311752) 15 5 11 29490 41
10165 228928 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 320 Alabama St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008883.79281 2106738.25967 37.7652033961404 -122.412482660939 (37.7652033961404, -122.412482660939) 8 4 7 28859 19
10176 192642 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Cashmere St 11 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6016173.52837 2096158.61444 37.7365603001134 -122.38653122684 (37.7365603001134, -122.38653122684) 10 3 8 58 1
10196 80809 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1400 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   13     6015599.17237 2102455.49099 37.7538184070991 -122.388956535612 (37.7538184070991, -122.388956535612) 10 3 8 28856 29
10214 255235 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 300X Goettingen St 10 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
10216 228168 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 107 Jarboe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6007794.48494 2097031.13992 37.7384886507323 -122.415563000831 (37.7384886507323, -122.415563000831) 2 7 7 28859 2
10223 7769 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 490X Franklin St 1 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3X3   6006335.7213615 2111871.61132 37.7791550246023 -122.421660473625 (37.7791550246023, -122.421660473625) 7 9 11 28852 10
10239 117493 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 156 DORADO TER 1 Sidewalk: Curb side : Cutout Tree Private 2       2x2   5994380 2093088 37.7268985955584 -122.461657658843 (37.7268985955584, -122.461657658843) 9 8 4 28861 40
10258 19200 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 199X Sanchez St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6003554.8234858 2107093.0395024 37.7658770346258 -122.430939601641 (37.7658770346258, -122.430939601641) 8 4 5 28862 3
10280 228713 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 811 Duboce Ave 2 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   6001884.18486 2108235.8291 37.7689200513416 -122.436799796678 (37.7689200513416, -122.436799796678) 15 5 5 29492 3
10343 11383 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1427X Innes Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     9 3X4   6016450.87108 2096464.39171 37.7374152523015 -122.385593629655 (37.7374152523015, -122.385593629655) 10 3 8 58 1
10465 75257 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 795 Geary St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6007991.6501 2114435.56963 37.7862882722428 -122.416113552304 (37.7862882722428, -122.416113552304) 13 1 9 28858 36
10513 208259 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 7 San Lorenzo Way 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft Permit Number 784463 5993794.93642 2097790.46819 37.7397767164315 -122.464021405387 (37.7397767164315, -122.464021405387) 1 8 4 59 40
10562 73885 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 350 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6014508.75776 2112348.63961 37.7809223143414 -122.393419764809 (37.7809223143414, -122.393419764809) 6 2 9 28856 6
10574 80213 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1522 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6007910.8791 2109536.30897 37.7728315356664 -122.416045915185 (37.7728315356664, -122.416045915185) 8 2 9 28853 19
10591 202779 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 77 Long Bridge St 15 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6014760.52181 2109341.40612 37.7726791104876 -122.392338387631 (37.7726791104876, -122.392338387631) 14 3 9 310 20
10636 192525 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1064 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6009654 2112066 37.7798753251135 -122.410194868954 (37.7798753251135, -122.410194868954) 14 2 9 28853 34
10648 255138 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 401X Brotherhood Way 16 Sidewalk: Property side : Yard Tree DPW 1                              
10668 259599 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1595 Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6015492 2095493 37.734694905807 -122.388841127643 (37.734694905807, -122.388841127643) 10 3 8 58 1

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