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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
81555 | 81555 | 108736 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1351 Minna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | 6006994.99302 | 2107616.27188 | 37.76750803134 | -122.419077863332 | (37.76750803134, -122.419077863332) | ||
83608 | 83608 | 89008 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 707 Carolina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52629 | 6012436.0 | 2104662.0 | 37.7597011565358 | -122.40005052882499 | (37.7597011565358, -122.400050528825) | |||
84328 | 84328 | 94953 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 763 Brannan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53984 | 6011909.0 | 2109793.0 | 37.773760330517796 | -122.402233924084 | (37.7737603305178, -122.402233924084) | ||
84731 | 84731 | 93487 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 643 San Jose Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53236 | 6005997.4 | 2099554.6 | 37.745316324998 | -122.421955670553 | (37.745316324998, -122.421955670553) | |||
85704 | 85704 | 88536 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1306 York St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367021999 | (37.7511299031436, -122.40816367022) | |||
86552 | 86552 | 94514 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 476 27th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53699 | 6003420.0 | 2100114.0 | 37.746706610489 | -122.430907804941 | (37.746706610489, -122.430907804941) | ||||
88147 | 88147 | 94579 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 615 Noe St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53757 | 6003043.0 | 2104661.0 | 37.759170227575495 | -122.432536159886 | (37.7591702275755, -122.432536159886) | ||
88570 | 88570 | 88284 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 270 Whitney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51280 | 6004294.4 | 2096874.5 | 37.7378611907196 | -122.427653449759 | (37.7378611907196, -122.427653449759) | |||
94481 | 94481 | 107509 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 240 PIXLEY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002182.3 | 2118985.3 | 37.7984523071777 | -122.436538140501 | (37.7984523071777, -122.436538140501) | ||||||
96180 | 96180 | 94952 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 763 Brannan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53984 | 6011909.0 | 2109793.0 | 37.773760330517796 | -122.402233924084 | (37.7737603305178, -122.402233924084) | ||
97037 | 97037 | 97024 | Property Tree 7 | Jacaranda mimosifolia :: Jacaranda 52 | 1455 Alabama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768189 | 6009349.0 | 2100759.5 | 37.748813167460106 | -122.410451409671 | (37.7488131674601, -122.410451409671) | ||||
98022 | 98022 | 117954 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 75 Bridgeview Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2016 12:00:00 AM | 3 | 2.5x3 | 6013772.990180001 | 2095538.9609400001 | 37.734725676752895 | -122.39478759166599 | (37.7347256767529, -122.394787591666) | |||
101789 | 101789 | 88303 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1306 York St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367021999 | (37.7511299031436, -122.40816367022) | |||
106024 | 106024 | 88537 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1306 York St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367021999 | (37.7511299031436, -122.40816367022) | |||
107998 | 107998 | 97023 | Property Tree 7 | Jacaranda mimosifolia :: Jacaranda 52 | 1443 Alabama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768190 | 6009347.4 | 2100788.9 | 37.748893803646105 | -122.410459018192 | (37.7488938036461, -122.410459018192) | ||||
112976 | 112976 | 108708 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1220 Diamond St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774630 | 6001943.854230001 | 2100537.23082 | 37.7477849526289 | -122.436042440417 | (37.7477849526289, -122.436042440417) | |
117159 | 117159 | 94883 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1786 Quesada Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53950 | 6014292.7 | 2095395.8 | 37.7343614687147 | -122.39298074998501 | (37.7343614687147, -122.392980749985) | ||
126613 | 126613 | 105306 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4365 26th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2014 12:00:00 AM | 3x3 | Permit Number 771671 | 6001537.2 | 2100535.2 | 37.747756265607705 | -122.43744848210501 | (37.7477562656077, -122.437448482105) | |||
138557 | 138557 | 88302 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1306 York St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367021999 | (37.7511299031436, -122.40816367022) | |||
140883 | 140883 | 94191 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 529 Texas St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53584 | 6013839.0 | 2104639.0 | 37.7597161279512 | -122.39519660091699 | (37.7597161279512, -122.395196600917) | |||
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) |
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 | |||||||
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) | ||||
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 | ||||||||
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) | ||
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) | ||
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) | |||
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) |
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) | ||
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) | |||
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) | ||
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) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |||
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) | |
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) | |
28783 | 28783 | 226457 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3330 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008057.367869999 | 2104469.97829 | 37.758928805544 | -122.415180498503 | (37.758928805544, -122.415180498503) | |||
28840 | 28840 | 37987 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 613 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40209 | 6013866.01576 | 2104192.39502 | 37.7584913501141 | -122.39507188416 | (37.7584913501141, -122.39507188416) | |
28977 | 28977 | 228541 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1380 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010322.60009 | 2101256.7138900002 | 37.750232939618705 | -122.407119730208 | (37.7502329396187, -122.407119730208) | |||
29032 | 29032 | 229738 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1498 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6009552.901980001 | 2100679.56843 | 37.748605121741 | -122.409740673009 | (37.748605121741, -122.409740673009) | |||
29106 | 29106 | 229884 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 137 Bradford St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 5ft | 6009563.00843 | 2097787.4840700002 | 37.7406646584401 | -122.409501640412 | (37.7406646584401, -122.409501640412) | |||
29331 | 29331 | 219232 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 393 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994163.921 | 2092422.7016599998 | 37.72505940734629 | -122.46235640053101 | (37.7250594073463, -122.462356400531) | |||
29888 | 29888 | 226402 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 88 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008216.93199 | 2099535.32688 | 37.745388332215704 | -122.414279508218 | (37.7453883322157, -122.414279508218) | |||
30186 | 30186 | 226343 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 205 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006735.41431 | 2102506.35586 | 37.7534627702098 | -122.41961312285 | (37.7534627702098, -122.41961312285) |
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");