home / trees

Street_Tree_List

Data source: data.sfgov.org

7,099 rows where qSpecies = 38

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
157 100153 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 590 08th Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10   Permit Number 780398 5993481.43699 2111479.23814 37.7773444498569 -122.46609982361299 (37.7773444498569, -122.466099823613) 11 6 2 54 11
198 100197 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 81 05th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/18/2012 12:00:00 AM 21   Permit Number 769099 5994240.47669 2115083.18474 37.7872836759267 -122.46373572008301 (37.7872836759267, -122.463735720083) 11 6 1 54 11
199 100198 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 81 05th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/18/2012 12:00:00 AM 22   Permit Number 769099 5994239.2285400005 2115068.80691 37.7872441264014 -122.463738994433 (37.7872441264014, -122.463738994433) 11 6 1 54 11
274 100282 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 1539 11th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4x5   5992715.6 2104979.5 37.7594536864517 -122.46827611701201 (37.7594536864517, -122.468276117012) 1 8 4 56 12
277 100287 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 3755X Buchanan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.43370739694299 (37.804591683504, -122.433707396943) 13 9 1 57 17
278 100288 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 3755X Buchanan St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.43370739694299 (37.804591683504, -122.433707396943) 13 9 1 57 17
279 100289 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 3755X Buchanan St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.43370739694299 (37.804591683504, -122.433707396943) 13 9 1 57 17
280 100290 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 3755X Buchanan St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.43370739694299 (37.804591683504, -122.433707396943) 13 9 1 57 17
281 100291 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 3755X Buchanan St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.43370739694299 (37.804591683504, -122.433707396943) 13 9 1 57 17
283 100293 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 3725 Buchanan St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6003057.0 2121128.0 37.8043852677309 -122.433664630457 (37.8043852677309, -122.433664630457) 13 9 1 57 17
285 100295 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 3725 Buchanan St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6003057.0 2121128.0 37.8043852677309 -122.433664630457 (37.8043852677309, -122.433664630457) 13 9 1 57 17
287 100297 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 3725 Buchanan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6003062.0 2121090.0 37.8042812134182 -122.43364461008001 (37.8042812134182, -122.43364461008) 13 9 1 57 17
289 100299 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 3725 Buchanan St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6003062.0 2121090.0 37.8042812134182 -122.43364461008001 (37.8042812134182, -122.43364461008) 13 9 1 57 17
295 100303 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 3727 Buchanan St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/15/2012 12:00:00 AM 1 3x3 Permit Number 769497 6003057.098680001 2121106.7570599997 37.804326945799 -122.43366276982 (37.804326945799, -122.43366276982) 13 9 1 57 17
303 100311 Permitted Site 2 Pittosporum undulatum :: Victorian Box 38 200X Cherry St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013423.0 2117972.0 37.796302366794 -122.397570474592 (37.796302366794, -122.397570474592) 3 1 10 28860 6
304 100312 Permitted Site 2 Pittosporum undulatum :: Victorian Box 38 200X Cherry St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6013423.0 2117972.0 37.796302366794 -122.397570474592 (37.796302366794, -122.397570474592) 3 1 10 28860 6
346 100362 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 1135 Green St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6007580.7402 2118831.84205 37.798336237888996 -122.41784694159401 (37.798336237889, -122.417846941594) 5 1 10 28858 32
516 100569 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 1529 Shrader St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20 3x3   5997859.0 2105434.0 37.760997353012705 -122.450520558131 (37.7609973530127, -122.450520558131) 15 5 11 29492 12
518 100570 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 1529 Shrader St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3x3   5997859.0 2105434.0 37.760997353012705 -122.450520558131 (37.7609973530127, -122.450520558131) 15 5 11 29492 12
743 100833 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 270 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20 3x3   6014276.02029 2105889.6123200003 37.763174331346896 -122.393772690277 (37.7631743313469, -122.393772690277) 14 3 8 28856 29
780 100881 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 529 Vermont St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6011246.0 2105894.0 37.7630175324873 -122.40425288278601 (37.7630175324873, -122.404252882786) 8 3 8 28856 29
833 100970 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 450X Chestnut St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW 3   9   Permit Number 37341 6009657.9659 2120896.9693 37.804123246932896 -122.41080500812201 (37.8041232469329, -122.410805008122) 3 1 10 308 23
835 100972 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 450X Chestnut St 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW 3 03/24/2016 07:43:00 AM 3   Permit Number 37341 6009614.0 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823) 3 1 10 308 23
836 100973 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 450X Chestnut St 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW 3   0   Permit Number 37341 6009614.0 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823) 3 1 10 308 23
837 100974 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 450X Chestnut St 6 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW 3   15   Permit Number 37341 6009596.2838 2120888.8532 37.8040975034287 -122.41101789076099 (37.8040975034287, -122.411017890761) 3 1 10 308 23
838 100975 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 450X Chestnut St 7 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW 3   11   Permit Number 37341 6009580.8633 2120886.4184 37.8040899533369 -122.411071082632 (37.8040899533369, -122.411071082632) 3 1 10 308 23
920 101066 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2440 Mariposa St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/26/2012 12:00:00 AM 10 3x3   6010155.3118900005 2105992.20615 37.76322617816 -122.408032143664 (37.76322617816, -122.408032143664) 8 4 8 28859 19
921 101067 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2440 Mariposa St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6010139.7451599995 2105990.58984 37.7632208685593 -122.40808587006599 (37.7632208685593, -122.408085870066) 8 4 8 28859 19
922 101068 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2440 Mariposa St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6010127.79625 2105991.8003700003 37.763223523364395 -122.408127282943 (37.7632235233644, -122.408127282943) 8 4 8 28859 19
923 101069 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 475 Hampshire St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6010094.6332 2106088.12711 37.76348615778821 -122.40824877776501 (37.7634861577882, -122.408248777765) 8 4 8 28859 19
1021 101172 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 445 Irving St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994418.0 2106645.0 37.7641248955045 -122.46250923178101 (37.7641248955045, -122.462509231781) 1 5 11 56 12
1022 101173 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 445 Irving St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994418.0 2106645.0 37.7641248955045 -122.46250923178101 (37.7641248955045, -122.462509231781) 1 5 11 56 12
1023 101174 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 445 Irving St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994418.0 2106645.0 37.7641248955045 -122.46250923178101 (37.7641248955045, -122.462509231781) 1 5 11 56 12
1027 101178 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 400 Irving St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994553.0 2106706.0 37.7643001590155 -122.462046733301 (37.7643001590155, -122.462046733301) 11 5 11 56 12
1030 101180 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 432 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994386.3 2106769.0 37.7644635416108 -122.462627867612 (37.7644635416108, -122.462627867612) 11 5 11 56 12
1034 101184 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 357 Irving St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994691.0 2106655.0 37.7641680705078 -122.46156573588199 (37.7641680705078, -122.461565735882) 15 5 11 56 12
1035 101185 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 357 Irving St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994691.0 2106655.0 37.7641680705078 -122.46156573588199 (37.7641680705078, -122.461565735882) 15 5 11 56 12
1039 101189 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 300 Irving St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994863.0 2106716.0 37.764345459457004 -122.460975263176 (37.764345459457, -122.460975263176) 15 5 11 56 12
1041 101190 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 300 Irving St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994863.0 2106716.0 37.764345459457004 -122.460975263176 (37.764345459457, -122.460975263176) 15 5 11 56 12
1043 101192 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 332 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994763.0 2106713.0 37.7643314674813 -122.461320915213 (37.7643314674813, -122.461320915213) 15 5 11 56 12
1050 101199 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 502 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5994231.2 2106687.3 37.7642302811549 -122.463158383346 (37.7642302811549, -122.463158383346) 11 5 11 56 12
1053 101200 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 502 Irving St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5994231.2 2106687.3 37.7642302811549 -122.463158383346 (37.7642302811549, -122.463158383346) 11 5 11 56 12
1054 101201 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 502 Irving St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5994231.2 2106687.3 37.7642302811549 -122.463158383346 (37.7642302811549, -122.463158383346) 11 5 11 56 12
1227 101399 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 2101X Steiner St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6002392.4 2115430.1 37.7887025838749 -122.435556659004 (37.7887025838749, -122.435556659004) 13 9 1 29490 27
1230 101400 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 2101X Steiner St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6002392.4 2115430.1 37.7887025838749 -122.435556659004 (37.7887025838749, -122.435556659004) 13 9 1 29490 27
1231 101401 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 2101X Steiner St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6002392.4 2115430.1 37.7887025838749 -122.435556659004 (37.7887025838749, -122.435556659004) 13 9 1 29490 27
1232 101402 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 2101X Steiner St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6002392.4 2115430.1 37.7887025838749 -122.435556659004 (37.7887025838749, -122.435556659004) 13 9 1 29490 27
1233 101403 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 2101X Steiner St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6002392.4 2115430.1 37.7887025838749 -122.435556659004 (37.7887025838749, -122.435556659004) 13 9 1 29490 27
1234 101404 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 428 Missouri St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 6x9   6013479.18569 2105074.56282 37.7608920714195 -122.396471560235 (37.7608920714195, -122.396471560235) 10 3 8 28856 29
1324 10151 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 970 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     26 2x2   6005670.87032 2103329.80739 37.7556637547844 -122.423353081294 (37.7556637547844, -122.423353081294) 2 4 5 28859 19
1420 101606 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 585X Mission Rock St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/02/2012 12:00:00 AM   5x5 Permit Number 769133 6015120.3 2109375.5 37.7727926961448 -122.391096249158 (37.7727926961448, -122.391096249158) 14 3 9 310 20
1421 101607 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 585X Mission Rock St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/02/2012 12:00:00 AM   5x5 Permit Number 769133 6015120.3 2109375.5 37.7727926961448 -122.391096249158 (37.7727926961448, -122.391096249158) 14 3 9 310 20
1422 101608 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 585X Mission Rock St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/02/2012 12:00:00 AM   5x5 Permit Number 769133 6015120.3 2109375.5 37.7727926961448 -122.391096249158 (37.7727926961448, -122.391096249158) 14 3 9 310 20
1423 101609 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 585X Mission Rock St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/02/2012 12:00:00 AM   5x5 Permit Number 769133 6015120.3 2109375.5 37.7727926961448 -122.391096249158 (37.7727926961448, -122.391096249158) 14 3 9 310 20
1429 101617 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 896X Hyde St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6007773.9 2115454.2 37.7890729368167 -122.416939111253 (37.7890729368167, -122.416939111253) 13 1 10 28858 21
1430 101618 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 896X Hyde St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6007773.9 2115454.2 37.7890729368167 -122.416939111253 (37.7890729368167, -122.416939111253) 13 1 10 28858 21
1431 101619 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 896X Hyde St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/01/2013 12:00:00 AM 7 3x3 Permit Number 771029 6007773.9 2115454.2 37.7890729368167 -122.416939111253 (37.7890729368167, -122.416939111253) 13 1 10 28858 21
1452 10164 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 1015 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/13/1990 12:00:00 AM 12 2x2   6005761.80004 2102937.9632900003 37.754592973400605 -122.42301076784099 (37.7545929734006, -122.423010767841) 2 4 5 28859 19
1500 101696 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 624 Rhode Island St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 6x6   6011774.67909 2105447.26434 37.7618204235996 -122.402392938477 (37.7618204235996, -122.402392938477) 10 3 8 28856 29
1510 101706 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 987 Rutland St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6009634.1980099995 2086638.2413700002 37.710055168691 -122.40846923845899 (37.710055168691, -122.408469238459) 9 7 8 309 39
1511 101707 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2451 Buchanan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/13/2012 12:00:00 AM 3   Permit Number 769502 6003650.584369999 2116854.2593799997 37.79268434326529 -122.431305226762 (37.7926843432653, -122.431305226762) 13 9 1 29490 27
1624 101875 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 118 09th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   5993057.30115 2114691.2801599996 37.786139364174 -122.467800707222 (37.786139364174, -122.467800707222) 11 6 2 54 11
1723 102002 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 115X Douglass St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6001082.7 2105694.4 37.761896331291105 -122.439389876376 (37.7618963312911, -122.439389876376) 15 5 5 28862 3
1725 102004 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 115X Douglass St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6001082.7 2105694.4 37.761896331291105 -122.439389876376 (37.7618963312911, -122.439389876376) 15 5 5 28862 3
1737 102016 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 4321 21st St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6001067.0 2103296.0 37.755310015899894 -122.43927226044501 (37.7553100158999, -122.439272260445) 2 4 5 28862 22
1791 102070 Permitted Site 2 Pittosporum undulatum :: Victorian Box 38 50X Coleridge St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 52614 6006867.4 2099433.7 37.745033388538204 -122.41893877466299 (37.7450333885382, -122.418938774663) 2 7 7 28859 2
1862 102150 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 3950 24th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6003489.0 2101879.0 37.7515567967702 -122.430795145475 (37.7515567967702, -122.430795145475) 2 4 5 28862 22
1863 102151 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 3950 24th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6003489.0 2101879.0 37.7515567967702 -122.430795145475 (37.7515567967702, -122.430795145475) 2 4 5 28862 22
2067 102358 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 3551 Scott St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/16/2013 12:00:00 AM 4 3x3 Permit Number 769877 6000705.04573 2120562.7593099996 37.8026995353058 -122.441763154152 (37.8026995353058, -122.441763154152) 13 9 1 57 17
2068 102359 Permitted Site 2 Pittosporum undulatum :: Victorian Box 38 399 Steiner St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3 Permit Number 24435 6003200.0 2109625.0 37.772809067914 -122.432347712361 (37.772809067914, -122.432347712361) 15 9 11 29492 9
2070 102360 Permitted Site 2 Pittosporum undulatum :: Victorian Box 38 399 Steiner St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 11/08/2008 12:00:00 AM 3 3x3 Permit 769887 6003188.9 2109566.9 37.7726489102167 -122.43238195811001 (37.7726489102167, -122.43238195811) 15 5 11 29492 9
2170 102460 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 559 Shotwell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6007888.0 2104678.0 37.7594904656222 -122.415780983244 (37.7594904656222, -122.415780983244) 2 4 7 28859 19
2194 102485 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 1501X Page St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5999365.6 2109075.3 37.771081565200795 -122.445571755181 (37.7710815652008, -122.445571755181) 15 5 11 29492 9
2246 102541 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 499 Illinois St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/15/2016 12:00:00 AM 3 5x5   6015655.0 2107201.0 37.766851652402 -122.38909478836099 (37.766851652402, -122.389094788361) 14 3 9 310 29
2247 102542 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 499 Illinois St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/15/2016 12:00:00 AM 3 5x5   6015655.0 2107201.0 37.766851652402 -122.38909478836099 (37.766851652402, -122.389094788361) 14 3 9 310 29
2248 102543 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 499 Illinois St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/15/2016 12:00:00 AM 3 5x5   6015655.0 2107201.0 37.766851652402 -122.38909478836099 (37.766851652402, -122.389094788361) 14 3 9 310 29
2249 102544 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 499 Illinois St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/15/2016 12:00:00 AM 3 5x5   6015655.0 2107201.0 37.766851652402 -122.38909478836099 (37.766851652402, -122.389094788361) 14 3 9 310 29
2250 102545 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 409 Illinois St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/15/2016 12:00:00 AM 3 5x5   6016159.9 2106964.2 37.766229426257 -122.387331885576 (37.766229426257, -122.387331885576) 14 3 9 310 20
2251 102546 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 409 Illinois St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/15/2016 12:00:00 AM 3 5x5   6016159.9 2106964.2 37.766229426257 -122.387331885576 (37.766229426257, -122.387331885576) 14 3 9 310 20
2335 102635 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2176 Mission St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 DPW 3 02/08/2013 12:00:00 AM 3 5x5 Permit Number 769974 6006850.0 2105688.0 37.7622052831774 -122.41944256138001 (37.7622052831774, -122.41944256138) 8 4 7 28859 19
2336 102636 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2176 Mission St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 DPW 3 02/08/2013 12:00:00 AM 3 5x5 Permit Number 769974 6006850.0 2105688.0 37.7622052831774 -122.41944256138001 (37.7622052831774, -122.41944256138) 8 4 7 28859 19
2381 102687 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2155 Scott St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 4x4   6001348.89021 2115903.63348 37.7899434614624 -122.43920099642901 (37.7899434614624, -122.439200996429) 13 6 1 29490 27
2382 102688 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2151 Scott St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3x3   6001355.00146 2115873.66297 37.7898615179477 -122.439177703113 (37.7898615179477, -122.439177703113) 13 6 1 29490 27
2383 102689 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2145 Scott St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3x3   6001361.0184 2115839.1531599998 37.789767105317395 -122.43915441067399 (37.7897671053174, -122.439154410674) 13 6 1 29490 27
2385 102690 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2121 Scott St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     19 3x3   6001369.63978 2115762.6346400003 37.789557495824106 -122.43911909516501 (37.7895574958241, -122.439119095165) 13 6 1 29490 27
2387 102692 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2105 Scott St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     24 3x3   6001375.56268 2115723.58488 37.789450612297294 -122.43909580275199 (37.7894506122973, -122.439095802752) 13 6 1 29490 27
2388 102693 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2101 Scott St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     19 6x6   6001381.172669999 2115690.38087 37.789359761877705 -122.439074012167 (37.7893597618777, -122.439074012167) 13 6 1 29490 27
2389 102694 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2799 Clay St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     24 4x4   6001416.78196 2115941.58593 37.7900515321059 -122.43896881846202 (37.7900515321059, -122.438968818462) 13 6 1 29490 27
2434 102749 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 2490X Union St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 5x6   6001093.5 2118310.7 37.7965381017858 -122.440257311894 (37.7965381017858, -122.440257311894) 13 9 1 57 17
2436 102750 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 2490X Union St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 5x6   6001093.5 2118310.7 37.7965381017858 -122.440257311894 (37.7965381017858, -122.440257311894) 13 9 1 57 17
2437 102751 Undocumented 3 Pittosporum undulatum :: Victorian Box 38 2490X Union St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 5x6   6001093.5 2118310.7 37.7965381017858 -122.440257311894 (37.7965381017858, -122.440257311894) 13 9 1 57 17
2440 102754 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 61 Jordan Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   5996176.049819999 2114116.9293299997 37.7847419411696 -122.456969171875 (37.7847419411696, -122.456969171875) 11 6 1 54 31
2456 102769 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 1400 Filbert St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6006151.87056 2119366.39832 37.7997234781035 -122.422829281062 (37.7997234781035, -122.422829281062) 13 9 1 28858 32
2457 102770 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 1400 Filbert St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 4x4   6006139.52673 2119365.14566 37.799719342134296 -122.42287190623699 (37.7997193421343, -122.422871906237) 13 9 1 28858 32
2466 102779 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2465 Union St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 6x5 Permit Number 45808 6001234.03142 2118289.1219 37.7964868540423 -122.439769495671 (37.7964868540423, -122.439769495671) 13 9 1 57 17
2468 102780 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2485 Union St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   6001115.851840001 2118272.0778900003 37.79643332818 -122.44017719881901 (37.79643332818, -122.440177198819) 13 9 1 57 17
2469 102781 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2485 Union St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6001132.88073 2118273.93173 37.7964393878108 -122.44011840835199 (37.7964393878108, -122.440118408352) 13 9 1 57 17
2471 102783 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2485 Union St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 5x6   6001184.7789199995 2118282.97063 37.7964671606955 -122.43993947832399 (37.7964671606955, -122.439939478324) 13 9 1 57 17
2472 102784 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2485 Union St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 5x6   6001199.77345 2118284.68294 37.7964727158009 -122.439887716968 (37.7964727158009, -122.439887716968) 13 9 1 57 17
2510 102823 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 3295 Clay St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3 Permit Number 48877 5999143.78747 2115622.70016 37.7890463679361 -122.446810205247 (37.7890463679361, -122.446810205247) 13 6 1 29490 31

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 161.71ms · Data source: data.sfgov.org