Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1703 | 1703 | 29682 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006057.50051 | 2117137.8264200003 | 37.7935990572132 | -122.422997353566 | (37.7935990572132, -122.422997353566) | ||||
| 1730 | 1730 | 26216 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 847 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X6 | 6005539.1347199995 | 2098169.79344 | 37.741488104692 | -122.42344184796002 | (37.741488104692, -122.42344184796) | |||
| 1739 | 1739 | 26215 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 851 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X6 | 6005528.08782 | 2098148.15105 | 37.7414280560726 | -122.423478506131 | (37.7414280560726, -122.423478506131) | |||
| 1768 | 1768 | 251696 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 98 11th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 1780 | 1780 | 7055 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1380 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6000908.235 | 2110033.3424 | 37.773800058267604 | -122.440304458977 | (37.7738000582676, -122.440304458977) | |||
| 1788 | 1788 | 108703 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2436 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772910 | 6001246.11089 | 2119029.77225 | 37.798521172675294 | -122.439780826226 | (37.7985211726753, -122.439780826226) |
| 1796 | 1796 | 29783 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2000X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 6006016.33701 | 2117432.70817 | 37.794406405577 | -122.423160753176 | (37.794406405577, -122.423160753176) | |||
| 1801 | 1801 | 251699 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1230 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2017 12:00:00 AM | 3 | 4x3 | Permit Number 778360 | 6005943.79297 | 2120373.7363400003 | 37.8024776288704 | -122.423620966152 | (37.8024776288704, -122.423620966152) |
| 1809 | 1809 | 172747 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1230 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2017 12:00:00 AM | 3 | 4x3 | Permit Number 778360 | 6006022.78943 | 2120387.12776 | 37.802518857014704 | -122.423348551388 | (37.8025188570147, -122.423348551388) |
| 1812 | 1812 | 172746 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1230 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2017 12:00:00 AM | 3 | 4x3 | Permit Number 778360 | 6006038.86692 | 2120389.38612 | 37.8025259652646 | -122.423293075825 | (37.8025259652646, -122.423293075825) |
| 1829 | 1829 | 9893 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1700 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6005337.6793 | 2115599.8801599997 | 37.7893355988943 | -122.425378500212 | (37.7893355988943, -122.425378500212) | |||
| 1905 | 1905 | 251810 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 3 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 1912 | 1912 | 251809 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 2 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 1921 | 1921 | 251811 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 4 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 1963 | 1963 | 140354 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1314 ELLIS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6004320.8279 | 2113281.1051 | 37.7829113213724 | -122.42873132198099 | (37.7829113213724, -122.428731321981) | |||
| 2057 | 2057 | 202415 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779903 | 6014884.877230001 | 2114997.01321 | 37.7882150346369 | -122.39230385636002 | (37.7882150346369, -122.39230385636) | |
| 2063 | 2063 | 24316 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2004 12:00:00 AM | 3 | 3X3 | 6006540.648630001 | 2112546.28984 | 37.7810190813924 | -122.420999461083 | (37.7810190813924, -122.420999461083) | ||
| 2082 | 2082 | 192574 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 218 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2013 12:00:00 AM | 4 | Width 2ft | 6009240.4524300005 | 2110671.27988 | 37.776022564117206 | -122.411526952315 | (37.7760225641172, -122.411526952315) | ||
| 2085 | 2085 | 252880 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001313.0 | 2088154.0 | 37.7137475882422 | -122.43733732943001 | (37.7137475882422, -122.43733732943) | ||||
| 2093 | 2093 | 177161 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007505.03845 | 2087315.4239400001 | 37.711795103221604 | -122.41587597032499 | (37.7117951032216, -122.415875970325) | |||
| 2156 | 2156 | 252915 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1924 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/2012 12:00:00 AM | 3x3 | 6007321.0 | 2118975.0 | 37.79871469295279 | -122.418755881393 | (37.7987146929528, -122.418755881393) | |||
| 2183 | 2183 | 29147 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 345 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008932.73484 | 2113804.5252400003 | 37.7846084447553 | -122.412812999913 | (37.7846084447553, -122.412812999913) | ||
| 2192 | 2192 | 29102 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 790 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 8 | 3x3 | 6007142.79367 | 2113673.3298400003 | 37.7841475835815 | -122.41899629946501 | (37.7841475835815, -122.418996299465) | ||
| 2206 | 2206 | 252954 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5998847.0 | 2112431.0 | 37.7802658347108 | -122.44760720084999 | (37.7802658347108, -122.44760720085) | ||||
| 2208 | 2208 | 252955 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5998847.0 | 2112431.0 | 37.7802658347108 | -122.44760720084999 | (37.7802658347108, -122.44760720085) | ||||
| 2210 | 2210 | 10530 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 101 Harbor Rd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/2004 12:00:00 AM | 3 | 3X4 | 6018595.5303624 | 2094415.3270740001 | 37.7319073553399 | -122.378036267473 | (37.7319073553399, -122.378036267473) | ||
| 2213 | 2213 | 10541 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 101 Harbor Rd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/2004 12:00:00 AM | 3 | 3X4 | 6018503.755834901 | 2094548.6734852002 | 37.732268440528 | -122.37836280912799 | (37.732268440528, -122.378362809128) | ||
| 2280 | 2280 | 7050 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1342 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/2015 07:17:00 AM | 3 | 3X3 | 6000990.1707 | 2110044.7638 | 37.773836083303706 | -122.440021850073 | (37.7738360833037, -122.440021850073) | ||
| 2312 | 2312 | 253038 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778941 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | |||
| 2318 | 2318 | 253034 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
| 2325 | 2325 | 47569 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 6 | 3x4 | Permit Number 778941 | 6014634.6306 | 2115001.8072 | 37.788214299095294 | -122.39317000993499 | (37.7882142990953, -122.393170009935) | |
| 2328 | 2328 | 253035 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
| 2338 | 2338 | 253037 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
| 2339 | 2339 | 253036 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
| 2341 | 2341 | 138904 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 743 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004092.4052 | 2110770.0131 | 37.7760035542999 | -122.429342446805 | (37.7760035542999, -122.429342446805) | |||
| 2345 | 2345 | 138905 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 739 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004125.2186 | 2110775.3704 | 37.776020121780206 | -122.42922931872499 | (37.7760201217802, -122.429229318725) | |||
| 2362 | 2362 | 201584 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020732.46705 | 2093049.56763 | 37.7282747723482 | -122.370553943333 | (37.7282747723482, -122.370553943333) | |
| 2367 | 2367 | 253057 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.729475822337605 | -122.36946777993099 | (37.7294758223376, -122.369467779931) | |
| 2372 | 2372 | 201583 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020706.31037 | 2093011.12913 | 37.7281677917075 | -122.370641712658 | (37.7281677917075, -122.370641712658) | |
| 2374 | 2374 | 201588 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021025.00287 | 2093440.1386 | 37.7293632596022 | -122.369569599359 | (37.7293632596022, -122.369569599359) | |
| 2376 | 2376 | 201595 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020802.701169999 | 2093144.94147 | 37.7285405058214 | -122.370317728275 | (37.7285405058214, -122.370317728275) | |
| 2377 | 2377 | 201594 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020788.86166 | 2093125.8535099998 | 37.7284873343211 | -122.370364253806 | (37.7284873343211, -122.370364253806) | |
| 2386 | 2386 | 201590 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.729475822337605 | -122.36946777993099 | (37.7294758223376, -122.369467779931) | |
| 2389 | 2389 | 201587 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021008.9496 | 2093419.1731599998 | 37.729304811746104 | -122.36962364951799 | (37.7293048117461, -122.369623649518) | |
| 2392 | 2392 | 253051 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2393 | 2393 | 201592 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020757.80811 | 2093085.24603 | 37.7283741294404 | -122.370468802689 | (37.7283741294404, -122.370468802689) | |
| 2397 | 2397 | 253052 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2403 | 2403 | 201586 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020998.06283 | 2093403.93478 | 37.729262372745794 | -122.36966023392799 | (37.7292623727458, -122.369660233928) | |
| 2412 | 2412 | 201597 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020830.52372 | 2093183.4296400002 | 37.728647714022 | -122.37022420239201 | (37.728647714022, -122.370224202392) | |
| 2413 | 2413 | 253048 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2414 | 2414 | 253049 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2415 | 2415 | 201596 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020816.91369 | 2093164.12057 | 37.7285939480275 | -122.370269919443 | (37.7285939480275, -122.370269919443) | |
| 2422 | 2422 | 201585 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020918.10936 | 2093291.5638700002 | 37.728949436562 | -122.36992888032302 | (37.728949436562, -122.369928880323) | |
| 2425 | 2425 | 7814 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 700X Franklin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2015 12:00:00 AM | 4 | 4X4 | 6006210.87703 | 2112746.5205200003 | 37.7815502713788 | -122.422154535912 | (37.7815502713788, -122.422154535912) | ||
| 2437 | 2437 | 201591 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020744.06411 | 2093067.1780599998 | 37.7283237638216 | -122.37051506831001 | (37.7283237638216, -122.37051506831) | |
| 2447 | 2447 | 201593 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020771.25022 | 2093102.78815 | 37.72842303458621 | -122.370423544329 | (37.7284230345862, -122.370423544329) | |
| 2448 | 2448 | 253050 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2455 | 2455 | 201589 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021039.89306 | 2093459.94557 | 37.729418462686894 | -122.369519490027 | (37.7294184626869, -122.369519490027) | |
| 2464 | 2464 | 253053 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2514 | 2514 | 246848 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 10 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001221.8841699995 | 2109765.97896 | 37.773083798207296 | -122.439200331843 | (37.7730837982073, -122.439200331843) | |||
| 2519 | 2519 | 246843 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 5 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001198.912769999 | 2109877.26909 | 37.7733880658265 | -122.439287771129 | (37.7733880658265, -122.439287771129) | |||
| 2530 | 2530 | 116163 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1900 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777879 | 6004429.67016 | 2118081.86477 | 37.7960991562926 | -122.428697109201 | (37.7960991562926, -122.428697109201) | |
| 2532 | 2532 | 246847 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 9 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001212.96216 | 2109784.10249 | 37.773133053181404 | -122.43923249339198 | (37.7731330531814, -122.439232493392) | |||
| 2533 | 2533 | 246849 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 11 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001216.8657599995 | 2109748.1446700003 | 37.7730345441487 | -122.439216412614 | (37.7730345441487, -122.439216412614) | |||
| 2535 | 2535 | 246841 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 3 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001195.01805 | 2109899.62825 | 37.7734492368388 | -122.439302846449 | (37.7734492368388, -122.439302846449) | |||
| 2543 | 2543 | 141333 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1205 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1992 12:00:00 AM | 14 | Width 0ft | 6002078.0816 | 2110492.0692 | 37.7751261444639 | -122.43629061453998 | (37.7751261444639, -122.43629061454) | ||
| 2546 | 2546 | 246846 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 8 | : 4 | Tree 1 | DPW for City Agency 10 | 14 | Width 3ft | 6001207.38463 | 2109809.38993 | 37.773202168766105 | -122.43925359959101 | (37.7732021687661, -122.439253599591) | |||
| 2552 | 2552 | 246840 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 2 | : 4 | Tree 1 | DPW for City Agency 10 | 19 | Width 3ft | 6001188.51269 | 2109936.2184200003 | 37.7735493340682 | -122.43932797261999 | (37.7735493340682, -122.43932797262) | |||
| 2553 | 2553 | 246842 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 4 | : 4 | Tree 1 | DPW for City Agency 10 | 15 | Width 4ft | 6001208.43411 | 2109888.06605 | 37.7734182533891 | -122.439255609578 | (37.7734182533891, -122.439255609578) | |||
| 2554 | 2554 | 246844 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 6 | : 4 | Tree 1 | DPW for City Agency 10 | 17 | Width 3ft | 6001203.63374 | 2109838.69012 | 37.773282406297895 | -122.439268674924 | (37.7732824062979, -122.439268674924) | |||
| 2615 | 2615 | 253153 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2030 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2017 12:00:00 AM | Permit Number 779475 | 6015677.29531 | 2106131.10604 | 37.763915191309295 | -122.38894296750799 | (37.7639151913093, -122.388942967508) | |||
| 2677 | 2677 | 23213 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 602X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006690.71989 | 2112642.67217 | 37.7812921821228 | -122.42048713258998 | (37.7812921821228, -122.42048713259) | ||
| 2688 | 2688 | 1096 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2310 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/1990 12:00:00 AM | 19 | 3X3 | 5999487.90061 | 2089338.3878900001 | 37.71689572423529 | -122.443730556927 | (37.7168957242353, -122.443730556927) | ||
| 2695 | 2695 | 13149 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1840 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/2014 12:00:00 AM | 3 | 7x5 | 6003547.2086 | 2119700.6621 | 37.800493972655296 | -122.431866244519 | (37.8004939726553, -122.431866244519) | ||
| 2747 | 2747 | 177162 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 780274 | 6007512.10716 | 2087312.1903 | 37.711786621718296 | -122.415851310014 | (37.7117866217183, -122.415851310014) | ||
| 2758 | 2758 | 177160 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 780274 | 6007458.52227 | 2087256.96391 | 37.7116319689192 | -122.416032606129 | (37.7116319689192, -122.416032606129) | ||
| 2781 | 2781 | 6959 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 653 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2017 12:00:00 AM | 3 | 3X3 | Permit Number 774555 | 6004285.9375 | 2110448.2406 | 37.775131000756396 | -122.428650025136 | (37.7751310007564, -122.428650025136) | |
| 2782 | 2782 | 29111 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 677 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 6 | 3x3 | 6007649.20664 | 2113690.31388 | 37.7842227210524 | -122.417245491187 | (37.7842227210524, -122.417245491187) | ||
| 2791 | 2791 | 4708 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 968 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/04/2017 05:46:00 AM | 3 | 5x5 | 6008638.9666 | 2120605.8680000002 | 37.803266767654 | -122.41431073174401 | (37.803266767654, -122.414310731744) | ||
| 2801 | 2801 | 142460 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 536 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6004827.4421 | 2110579.0189 | 37.775520717053205 | -122.426786154864 | (37.7755207170532, -122.426786154864) | |||
| 2871 | 2871 | 16699 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900 Noriega St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/10/2017 12:00:00 AM | 3 | 8 | 5991131.39821 | 2103159.65216 | 37.7543652389679 | -122.473622260865 | (37.7543652389679, -122.473622260865) | ||
| 2948 | 2948 | 7081 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1766X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2016 07:37:00 AM | 3 | 3x3 | 5998953.6759 | 2109754.0736 | 37.7729217790125 | -122.447045463978 | (37.7729217790125, -122.447045463978) | ||
| 2954 | 2954 | 137579 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1095 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 18 | Width 0ft | 6002363.4281 | 2112169.1125 | 37.7797470942537 | -122.435423531353 | (37.7797470942537, -122.435423531353) | ||
| 2956 | 2956 | 248424 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997237.9413 | 2108083.6374 | 37.768237016007 | -122.452859770858 | (37.768237016007, -122.452859770858) | |||
| 2961 | 2961 | 137577 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1095 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 17 | Width 0ft | 6002355.8984 | 2112213.5374 | 37.7798686462193 | -122.435452758685 | (37.7798686462193, -122.435452758685) | ||
| 2966 | 2966 | 137576 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1095 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 0ft | 6002354.5808 | 2112241.3971 | 37.7799450671147 | -122.435459310364 | (37.7799450671147, -122.435459310364) | |||
| 2973 | 2973 | 248423 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997213.1093 | 2108080.0035 | 37.7682256152375 | -122.45294539950399 | (37.7682256152375, -122.452945399504) | |||
| 2989 | 2989 | 6093 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2010 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/29/2012 12:00:00 AM | 3 | 3X3 | 6000747.9276 | 2112435.0864 | 37.7803855097501 | -122.441031325867 | (37.7803855097501, -122.441031325867) | ||
| 2998 | 2998 | 137578 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1095 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6002358.9103 | 2112196.2192 | 37.7798212658547 | -122.435441099997 | (37.7798212658547, -122.435441099997) | |||
| 3008 | 3008 | 248421 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997149.818 | 2108070.0101 | 37.7681945486983 | -122.453163595144 | (37.7681945486983, -122.453163595144) | |||
| 3020 | 3020 | 248422 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997181.0094 | 2108075.4611 | 37.768211303376496 | -122.45305610134199 | (37.7682113033765, -122.453056101342) | |||
| 3023 | 3023 | 253281 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 5997149.818 | 2108070.0101 | 37.7681945486983 | -122.453163595144 | (37.7681945486983, -122.453163595144) | ||||
| 3104 | 3104 | 23477 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2400X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | 9 | 6005826.46835 | 2118791.49543 | 37.7981265753418 | -122.423914390454 | (37.7981265753418, -122.423914390454) | |||
| 3117 | 3117 | 38667 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | Permit Number 40586 | ||||||||
| 3287 | 3287 | 253411 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3292 | 3292 | 253409 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3295 | 3295 | 253410 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3296 | 3296 | 192598 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 104 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 775218 | 6008374.8011300005 | 2110658.1789 | 37.77593799816621 | -122.41452055078301 | (37.7759379981662, -122.414520550783) | |
| 3299 | 3299 | 192595 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | Width 4ft | Permit Number 770747 | 6008285.14461 | 2110684.68439 | 37.776005738696604 | -122.414832573262 | (37.7760057386966, -122.414832573262) | |
| 3300 | 3300 | 192597 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 104 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 775218 | 6008360.61035 | 2110669.96624 | 37.775969566167795 | -122.414570474841 | (37.7759695661678, -122.414570474841) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");