Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155 | 155 | 251225 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Yukon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x2.5 | 6000238.0 | 2104757.0 | 37.7592743544717 | -122.442244057145 | (37.7592743544717, -122.442244057145) | ||||
| 310 | 310 | 30658 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 47 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34591 | 6007577.417719999 | 2109608.9608 | 37.7730122661246 | -122.41720454865299 | (37.7730122661246, -122.417204548653) |
| 578 | 578 | 239543 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Bennington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007186.362369999 | 2097372.9446900003 | 37.7393929694044 | -122.41768982014798 | (37.7393929694044, -122.417689820148) | |
| 581 | 581 | 240741 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007184.54991 | 2097351.72127 | 37.739334592605 | -122.41769458294901 | (37.739334592605, -122.417694582949) | |
| 603 | 603 | 239542 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Bennington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007187.05082 | 2097389.73315 | 37.739439105535105 | -122.41768862942101 | (37.7394391055351, -122.417688629421) | |
| 1083 | 1083 | 108357 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250X Pixley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/17/2014 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002140.21513 | 2118970.4470599997 | 37.7984091333207 | -122.436682703142 | (37.7984091333207, -122.436682703142) | |
| 1119 | 1119 | 38280 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 12 | Permit Number 40367 | 6013876.1493 | 2104054.9950099997 | 37.758114643000795 | -122.395027213942 | (37.7581146430008, -122.395027213942) | ||
| 1122 | 1122 | 38279 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013875.32423 | 2104028.43016 | 37.7580416558018 | -122.39502820678801 | (37.7580416558018, -122.395028206788) | ||
| 1126 | 1126 | 38276 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 3 | Permit Number 40367 | 6013924.79961 | 2103962.8321 | 37.757864288826795 | -122.394852504434 | (37.7578642888268, -122.394852504434) | ||
| 1131 | 1131 | 251458 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | 3x3 | |||||||
| 1135 | 1135 | 38277 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013910.55501 | 2103982.27082 | 37.757916871294796 | -122.394903129995 | (37.7579168712948, -122.394903129995) | ||
| 1674 | 1674 | 251651 | Significant Tree 6 | Jacaranda mimosifolia :: Jacaranda 52 | 3237 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009049.0 | 2099828.0 | 37.746238652288106 | -122.411423013741 | (37.7462386522881, -122.411423013741) | ||||
| 2633 | 2633 | 108358 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250X Pixley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/17/2014 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002123.0245900005 | 2118966.98612 | 37.798398653541796 | -122.43674193970399 | (37.7983986535418, -122.436741939704) | |
| 3172 | 3172 | 253340 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 1045 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780536 | 6004432.85841 | 2102813.20591 | 37.754175338839204 | -122.427597715268 | (37.7541753388392, -122.427597715268) | |
| 4711 | 4711 | 41645 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 146 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2001 12:00:00 AM | 3 | 3x3 | Permit Number 42118 | 5997898.0776 | 2112825.6252 | 37.7812950956289 | -122.450918408743 | (37.7812950956289, -122.450918408743) |
| 4735 | 4735 | 226781 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 466 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 7x8 | 6003584.13439 | 2105555.33075 | 37.7616565176582 | -122.430728478955 | (37.7616565176582, -122.430728478955) | |||
| 4895 | 4895 | 69228 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 537 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | 12 | 7x7 | Permit Number 33281 | 6005209.5873 | 2111278.8914 | 37.7774639950364 | -122.425514041455 | (37.7774639950364, -122.425514041455) |
| 5203 | 5203 | 46584 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2790 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2002 12:00:00 AM | Permit Number 44712 | ||||||||
| 5445 | 5445 | 71960 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1020 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1995 12:00:00 AM | 3 | 6008996.95317 | 2116013.9295900003 | 37.7906785394346 | -122.41274707603701 | (37.7906785394346, -122.412747076037) | |||
| 5530 | 5530 | 73673 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1020 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1995 12:00:00 AM | 3 | 3x3 | Permit Number 49743 | 6009009.07055 | 2116016.5507400003 | 37.790686416582396 | -122.412705335782 | (37.7906864165824, -122.412705335782) | |
| 7958 | 7958 | 108356 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250X Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/17/2014 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002158.91155 | 2118972.60439 | 37.798416119273206 | -122.436618162405 | (37.7984161192732, -122.436618162405) | |
| 9458 | 9458 | 34058 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37960 | |||||||||
| 9605 | 9605 | 17889 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2231 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2000 12:00:00 AM | 8 | 3x3 | 6003230.4792 | 2115158.6176 | 37.7880047264698 | -122.432637629177 | (37.7880047264698, -122.432637629177) | ||
| 9688 | 9688 | 35795 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 230 Lexington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 779148 | 6006467.16362039 | 2104758.98191383 | 37.75963284616879 | -122.42070069541 | (37.7596328461688, -122.42070069541) | ||
| 9759 | 9759 | 24293 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 302 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/03/2011 12:00:00 AM | 3 | 2x2 | 6006647.73618 | 2098006.46065 | 37.741102138158 | -122.41959709154101 | (37.741102138158, -122.419597091541) | ||
| 13280 | 13280 | 10220 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1366 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6005800.0848900005 | 2101007.6677599996 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | |||
| 13316 | 13316 | 94652 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 463 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779226 | 6003847.0 | 2095961.0 | 37.735327609986 | -122.429135213798 | (37.735327609986, -122.429135213798) |
| 13590 | 13590 | 122711 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 225 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6012928.83224 | 2105933.48701 | 37.763219845153706 | -122.398435273093 | (37.7632198451537, -122.398435273093) | |||
| 13609 | 13609 | 12227 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1551 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2000 12:00:00 AM | 6 | 3X3 | 6015788.0003 | 2095930.721 | 37.735913201034606 | -122.387848277235 | (37.7359132010346, -122.387848277235) | ||
| 13611 | 13611 | 27142 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1775 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011388.172669999 | 2095338.5375299999 | 37.7340424699754 | -122.40301867507401 | (37.7340424699754, -122.403018675074) | |||
| 14097 | 14097 | 27140 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1775 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011410.17472 | 2095355.19259 | 37.7340894298873 | -122.40294377776002 | (37.7340894298873, -122.40294377776) | |||
| 14166 | 14166 | 110369 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010361.75992 | 2107841.88666 | 37.7683165361048 | -122.40744851604201 | (37.7683165361048, -122.407448516042) | |||
| 14393 | 14393 | 32960 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 934 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2003 12:00:00 AM | 16 | 6x12 | Permit Number 37274 | 6015218.03519 | 2104239.88822 | 37.7586968478982 | -122.390399274809 | (37.7586968478982, -122.390399274809) |
| 14778 | 14778 | 32943 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 999X Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37261 | 6015287.47006 | 2104039.63341 | 37.7581508424957 | -122.39014514528499 | (37.7581508424957, -122.390145145285) |
| 15077 | 15077 | 110368 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010339.5627 | 2107839.67142 | 37.768309211116 | -122.407525138277 | (37.768309211116, -122.407525138277) | |||
| 15543 | 15543 | 106166 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1051 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6012226.18355 | 2103510.5202200003 | 37.7565277460814 | -122.400695290961 | (37.7565277460814, -122.400695290961) | ||||
| 15582 | 15582 | 106047 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 618- 622 Carolina St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | 6x7 | 6012364.1992 | 2105044.14437 | 37.7607464370199 | -122.40032569478599 | (37.7607464370199, -122.400325694786) | |||
| 15703 | 15703 | 108713 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1101 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773108 | 6011675.24376 | 2103231.93963 | 37.7557320816825 | -122.402581058681 | (37.7557320816825, -122.402581058681) |
| 15907 | 15907 | 88471 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1525 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51425 | 6015740.82967 | 2096670.14534 | 37.7379408970519 | -122.388062950362 | (37.7379408970519, -122.388062950362) | |
| 16487 | 16487 | 32962 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 952 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 12 | 6x12 | Permit Number 37276 | 6015219.88415 | 2104168.1362900003 | 37.7584999350397 | -122.39038786691299 | (37.7584999350397, -122.390387866913) |
| 17784 | 17784 | 18386 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 816 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/03/1997 12:00:00 AM | 12 | 3X3 | 6010411.4798 | 2104364.47697 | 37.7587711399879 | -122.407031402383 | (37.7587711399879, -122.407031402383) | ||
| 18190 | 18190 | 73083 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1999 12:00:00 AM | 3x3 | 6007158.13725384 | 2106179.72119915 | 37.7635727856768 | -122.41841169643601 | (37.7635727856768, -122.418411696436) | ||
| 18620 | 18620 | 121737 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1301 Vermont St | 12 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) | ||||
| 18647 | 18647 | 5527 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 882 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6005005.94295 | 2103241.13664 | 37.7553827355522 | -122.425646301253 | (37.7553827355522, -122.425646301253) | |||
| 18708 | 18708 | 121749 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1201x Vermont St | 12 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011405.0 | 2102539.0 | 37.753814330877205 | -122.403466904543 | (37.7538143308772, -122.403466904543) | ||||
| 19430 | 19430 | 68480 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1218 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32350 | 6010273.43286101 | 2102111.66598921 | 37.7525776974999 | -122.407350018785 | (37.7525776974999, -122.407350018785) | ||
| 19620 | 19620 | 34336 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 19790 | 19790 | 53252 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 18 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1969 12:00:00 AM | 7 | Permit Number 6139 | 6004056.10022951 | 2102948.9340362 | 37.754526698445 | -122.428910313961 | (37.754526698445, -122.428910313961) | ||
| 19800 | 19800 | 36597 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1325 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.40978500985399 | (37.7507339080729, -122.409785009854) | ||
| 19801 | 19801 | 94573 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3978 18th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53752 | 6003116.0 | 2105363.0 | 37.761101890414 | -122.432333828196 | (37.761101890414, -122.432333828196) | ||
| 20051 | 20051 | 26498 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2710 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1999 12:00:00 AM | 6 | 3x3 | 6008903.18819 | 2102577.2710700002 | 37.7537793576317 | -122.412121481544 | (37.7537793576317, -122.412121481544) | ||
| 20285 | 20285 | 10083 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 643 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2004 12:00:00 AM | 3 | 3X3 | 6005633.91176 | 2105224.85563 | 37.7608650279097 | -122.423615623972 | (37.7608650279097, -122.423615623972) | ||
| 20293 | 20293 | 91075 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 576 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2008 12:00:00 AM | 3x3 | Permit Number 51977 | 6007858.0 | 2104570.0 | 37.7591922359052 | -122.41587709061399 | (37.7591922359052, -122.415877090614) | ||
| 20491 | 20491 | 85214 | Jacaranda mimosifolia :: Jacaranda 52 | 2889 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/13/2007 12:00:00 AM | 3 | 3x3 | under 3yr maintenance agreement. ends on 4/13/2007 | 6009588.01504 | 2102148.81833 | 37.75264132339179 | -122.409722943913 | (37.7526413233918, -122.409722943913) | |
| 20507 | 20507 | 10084 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 649 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2012 12:00:00 AM | 3 | 3X3 | 6005635.92874 | 2105201.33874 | 37.7608005699125 | -122.423606976082 | (37.7608005699125, -122.423606976082) | ||
| 20704 | 20704 | 26501 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 2752 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6008910.69527 | 2102429.93481 | 37.7533752266066 | -122.41208510844801 | (37.7533752266066, -122.412085108448) | |||
| 20984 | 20984 | 52219 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 351 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | |||
| 21042 | 21042 | 2393 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 2656 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2002 12:00:00 AM | 8 | 3X3 | 6009747.5539 | 2101876.46868 | 37.7519024509371 | -122.409152011861 | (37.7519024509371, -122.409152011861) | ||
| 21333 | 21333 | 28065 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 2576 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/2001 12:00:00 AM | 12 | 3X3 | 6009719.0461099995 | 2102350.04498 | 37.753201188885605 | -122.409284012572 | (37.7532011888856, -122.409284012572) | ||
| 21627 | 21627 | 10139 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 905 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2014 12:00:00 AM | 1 | 2X2 | 6005721.36321 | 2103691.7160799997 | 37.7566603214356 | -122.42320418503999 | (37.7566603214356, -122.42320418504) | ||
| 23435 | 23435 | 226459 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3242 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007896.86765 | 2105631.29342 | 37.762108488128796 | -122.41581781745899 | (37.7621084881288, -122.415817817459) | |||
| 23575 | 23575 | 229749 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3420 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006865.442430001 | 2100893.1642400003 | 37.7490406373221 | -122.41904904288401 | (37.7490406373221, -122.419049042884) | |||
| 23785 | 23785 | 226391 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1437 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008021.55589 | 2099786.31396 | 37.746066510059705 | -122.414972850429 | (37.7460665100597, -122.414972850429) | |||
| 23793 | 23793 | 226377 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 267 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007909.30084 | 2097390.1768 | 37.739480940202 | -122.415191429754 | (37.739480940202, -122.415191429754) | |||
| 24056 | 24056 | 229874 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3570 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004568.82488 | 2103108.4476799998 | 37.7549936933086 | -122.42714853777001 | (37.7549936933086, -122.42714853777) | |||
| 24100 | 24100 | 229778 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011440.8047 | 2102625.1691799997 | 37.754052932322395 | -122.40334914446301 | (37.7540529323224, -122.403349144463) | |||
| 24122 | 24122 | 226450 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 990 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008406.2637 | 2102737.10298 | 37.7541903253409 | -122.413851270843 | (37.7541903253409, -122.413851270843) | |||
| 24167 | 24167 | 229784 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1350 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010843.40414 | 2102039.00655 | 37.752410075071204 | -122.405373833155 | (37.7524100750712, -122.405373833155) | |||
| 24273 | 24273 | 226430 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006668.67931 | 2102994.38705 | 37.75479903236629 | -122.41987853526899 | (37.7547990323663, -122.419878535269) | |||
| 24375 | 24375 | 129099 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 240 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002192.1868900005 | 2118975.47765 | 37.79842589939221 | -122.43650322546499 | (37.7984258993922, -122.436503225465) | |||
| 24377 | 24377 | 229828 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1456 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010092.99129 | 2100772.65012 | 37.748890955071396 | -122.407879605175 | (37.7488909550714, -122.407879605175) | |||
| 24394 | 24394 | 190725 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2211 Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010439.75315 | 2107847.13146 | 37.7683353022519 | -122.40717911333599 | (37.7683353022519, -122.407179113336) | |||
| 24885 | 24885 | 229758 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011460.45759 | 2102239.71319 | 37.7529956524374 | -122.40325406633801 | (37.7529956524374, -122.403254066338) | |||
| 24889 | 24889 | 229735 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1440 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009547.83815 | 2100777.83843 | 37.748874665647 | -122.409765119277 | (37.748874665647, -122.409765119277) | |||
| 25065 | 25065 | 32969 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 580 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 14 | Permit Number 37284 | 6014077.45388 | 2104409.80131 | 37.759100056248606 | -122.39435585294399 | (37.7591000562486, -122.394355852944) | |
| 25170 | 25170 | 39568 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 800 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 13 | Permit Number 40987 | 6011544.30248 | 2104593.03235 | 37.7594620297563 | -122.40312963433998 | (37.7594620297563, -122.40312963434) | |
| 25361 | 25361 | 229873 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3571 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004534.157880001 | 2103646.15858 | 37.75646816057971 | -122.427306727641 | (37.7564681605797, -122.427306727641) | |||
| 25685 | 25685 | 228535 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009303.88793 | 2107359.3535700003 | 37.766932343692005 | -122.411073521351 | (37.766932343692, -122.411073521351) | |||
| 25783 | 25783 | 70682 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 414 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 8 | 6010606.08274 | 2106339.87511 | 37.764206026409795 | -122.406497569303 | (37.7642060264098, -122.406497569303) | ||
| 25893 | 25893 | 226384 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 15 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007204.63358 | 2097592.3752900003 | 37.7399965053243 | -122.417642194748 | (37.7399965053243, -122.417642194748) | |||
| 25919 | 25919 | 40096 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 359 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2001 12:00:00 AM | 8 | Permit Number 44400 | 6014088.36289 | 2105304.3939 | 37.7615570193592 | -122.394380761457 | (37.7615570193592, -122.394380761457) | ||
| 25940 | 25940 | 226434 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006662.06006 | 2103117.82252 | 37.7551375848404 | -122.419910185127 | (37.7551375848404, -122.419910185127) | |||
| 25976 | 25976 | 190714 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 375 Texas St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 5ft | 6013800.48111 | 2105372.99908 | 37.761729387017496 | -122.39538124017099 | (37.7617293870175, -122.395381240171) | |||
| 26038 | 26038 | 229743 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005873.02878 | 2106520.6426 | 37.7644364480055 | -122.422880717778 | (37.7644364480055, -122.422880717778) | |||
| 26212 | 26212 | 226420 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 632 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007871.67107 | 2104237.7229400002 | 37.7582806479376 | -122.41580628094101 | (37.7582806479376, -122.415806280941) | |||
| 26294 | 26294 | 226376 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 268 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004329.65759 | 2096832.9872 | 37.7377492002742 | -122.42752859039899 | (37.7377492002742, -122.427528590399) | |||
| 26408 | 26408 | 226356 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2793 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008207.55 | 2106773.70397 | 37.765262744207604 | -122.414824138541 | (37.7652627442076, -122.414824138541) | |||
| 26647 | 26647 | 96093 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 116 Drake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2011 12:00:00 AM | 3x3 | Permit Number 56922 | 6001481.0 | 2086737.0 | 37.7098663684689 | -122.436655293893 | (37.7098663684689, -122.436655293893) | ||
| 26766 | 26766 | 226445 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3176 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008495.22679 | 2101571.86166 | 37.7509958309158 | -122.41346120966001 | (37.7509958309158, -122.41346120966) | |||
| 27369 | 27369 | 69766 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 8 | 6014547.15395 | 2096165.5632900002 | 37.7364892123042 | -122.392154828809 | (37.7364892123042, -122.392154828809) | ||
| 27540 | 27540 | 68129 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 635 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 9 | Permit Number 31880 | 6013874.62108 | 2104078.7495 | 37.7581797826985 | -122.39503416301001 | (37.7581797826985, -122.39503416301) | |
| 27605 | 27605 | 39569 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 806 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 7 | Permit Number 40988 | 6011543.776869999 | 2104583.27285 | 37.7594352029858 | -122.40313076567101 | (37.7594352029858, -122.403130765671) | |
| 27865 | 27865 | 229765 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011453.422780001 | 2102371.80516 | 37.753357955114396 | -122.40328768569401 | (37.7533579551144, -122.403287685694) | |||
| 27981 | 27981 | 229753 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011465.791619999 | 2102125.84808 | 37.7526833017063 | -122.40322761098899 | (37.7526833017063, -122.403227610989) | |||
| 28067 | 28067 | 190735 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 128 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010531.76595 | 2107657.21316 | 37.7678189790021 | -122.406847461368 | (37.7678189790021, -122.406847461368) | |||
| 28348 | 28348 | 226784 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 549 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003023.04842 | 2105091.7124400004 | 37.7603517290589 | -122.432635928409 | (37.7603517290589, -122.432635928409) | |||
| 28403 | 28403 | 226820 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1891 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004617.45608 | 2097657.55415 | 37.740029548214004 | -122.426592230667 | (37.740029548214, -122.426592230667) | |||
| 28599 | 28599 | 226426 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3323 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006880.3188 | 2102604.06002 | 37.753739204713895 | -122.419118940914 | (37.7537392047139, -122.419118940914) | |||
| 28716 | 28716 | 226385 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 352 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006123.1231 | 2098057.1404 | 37.7412117286404 | -122.421414615119 | (37.7412117286404, -122.421414615119) | |||
| 28765 | 28765 | 35362 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 979 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 6 | Permit Number 38824 | 6011922.436290001 | 2103880.66513 | 37.75752713659001 | -122.401771780343 | (37.75752713659, -122.401771780343) |
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");