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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 30189 | 30189 | 229788 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1799 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005571.35245 | 2107231.70655 | 37.7663718340174 | -122.423974702579 | (37.7663718340174, -122.423974702579) | |||
| 30375 | 30375 | 229824 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1306 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010048.45335 | 2101561.1915599997 | 37.751053622231495 | -122.408089221836 | (37.7510536222315, -122.408089221836) | |||
| 30489 | 30489 | 229761 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6011456.4035 | 2102287.48645 | 37.753126600912296 | -122.40327144663401 | (37.7531266009123, -122.403271446634) | |||
| 30551 | 30551 | 226313 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2479 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008246.47754 | 2104016.96539 | 37.7576955616045 | -122.414494411095 | (37.7576955616045, -122.414494411095) | |||
| 31243 | 31243 | 229777 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011441.00674 | 2102606.02985 | 37.7540003912143 | -122.403347099413 | (37.7540003912143, -122.403347099413) | |||
| 31398 | 31398 | 229872 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3731 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004865.55222 | 2102495.62663 | 37.7533278053416 | -122.42607874566299 | (37.7533278053416, -122.426078745663) | |||
| 31417 | 31417 | 219235 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 5 Sequoia Way | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5998215.18129 | 2097817.79881 | 37.7401055166597 | -122.44874010447599 | (37.7401055166597, -122.448740104476) | |||
| 31720 | 31720 | 226814 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 63 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003182.02121 | 2107933.9662599997 | 37.7681648843321 | -122.432289109354 | (37.7681648843321, -122.432289109354) | |||
| 31787 | 31787 | 121581 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 3x3 | 6013754.46885 | 2106222.8302700003 | 37.764060277784 | -122.395599922908 | (37.764060277784, -122.395599922908) | ||
| 32128 | 32128 | 138952 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 715 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004470.5657 | 2110964.0931 | 37.7765578523866 | -122.428048123596 | (37.7765578523866, -122.428048123596) | |||
| 33023 | 33023 | 229856 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 119 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005420.32438 | 2102982.74414 | 37.7546966562501 | -122.42419486740299 | (37.7546966562501, -122.424194867403) | |||
| 33217 | 33217 | 247662 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 108 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6001959.68947 | 2108344.83823 | 37.769223654362605 | -122.436546435187 | (37.7692236543626, -122.436546435187) | |||
| 33332 | 33332 | 226355 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2175 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008795.60516 | 2105650.73446 | 37.7622123526471 | -122.412710792894 | (37.7622123526471, -122.412710792894) | |||
| 33460 | 33460 | 229759 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6011459.21947 | 2102251.51401 | 37.753027985753 | -122.403259178089 | (37.753027985753, -122.403259178089) | |||
| 33672 | 33672 | 229850 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 86 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005369.9834199995 | 2103227.0230799997 | 37.7553645467641 | -122.424386333963 | (37.7553645467641, -122.424386333963) | |||
| 33834 | 33834 | 228551 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1398 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009530.29917 | 2101073.08548 | 37.7496843657442 | -122.409846607735 | (37.7496843657442, -122.409846607735) | |||
| 34263 | 34263 | 226464 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2670 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008878.67119 | 2102975.76915 | 37.7548721679187 | -122.412234430081 | (37.7548721679187, -122.412234430081) | |||
| 34320 | 34320 | 190702 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 648 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012372.026430001 | 2104905.9974700003 | 37.760367552645704 | -122.40028892061899 | (37.7603675526457, -122.400288920619) | |||
| 34566 | 34566 | 190734 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 128 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010530.37912 | 2107677.75559 | 37.7678753062214 | -122.406853706245 | (37.7678753062214, -122.406853706245) | |||
| 35104 | 35104 | 248002 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 428 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009958.97644 | 2098527.35445 | 37.742718361070004 | -122.408184696582 | (37.74271836107, -122.408184696582) | |||
| 35178 | 35178 | 226804 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3520 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004856.92636 | 2103707.06921 | 37.75665365567029 | -122.42619481576 | (37.7566536556703, -122.42619481576) | |||
| 35292 | 35292 | 105896 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 635 Texas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013869.96834 | 2104118.28699 | 37.758288085340794 | -122.39505302359301 | (37.7582880853408, -122.395053023593) | |||
| 35377 | 35377 | 226460 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3236 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007913.34927 | 2105633.2143 | 37.7621146889646 | -122.41576094971799 | (37.7621146889646, -122.415760949718) | |||
| 35475 | 35475 | 229770 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011448.51225 | 2102466.33912 | 37.753617250356996 | -122.403311317166 | (37.753617250357, -122.403311317166) | |||
| 35984 | 35984 | 229773 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011446.65854 | 2102520.5438599996 | 37.7537659811344 | -122.403321540662 | (37.7537659811344, -122.403321540662) | |||
| 36119 | 36119 | 226431 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006664.9239300005 | 2103021.2685 | 37.7548726310745 | -122.419893429847 | (37.7548726310745, -122.419893429847) | |||
| 36567 | 36567 | 228540 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2620 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010291.15626 | 2104007.47358 | 37.757784154732 | -122.407422370055 | (37.757784154732, -122.407422370055) | |||
| 36855 | 36855 | 226463 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2680 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008883.3825199995 | 2102935.43228 | 37.754761676334205 | -122.412215286208 | (37.7547616763342, -122.412215286208) | |||
| 37583 | 37583 | 226819 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 70 Potomac St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003113.42277 | 2108740.53818 | 37.7703756436569 | -122.432584004272 | (37.7703756436569, -122.432584004272) | |||
| 37674 | 37674 | 229769 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011449.91996 | 2102448.3530599996 | 37.7535679432079 | -122.403305183785 | (37.7535679432079, -122.403305183785) | |||
| 37979 | 37979 | 229803 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006754.853759999 | 2105853.73018 | 37.7626549800545 | -122.419783396906 | (37.7626549800545, -122.419783396906) | |||
| 38097 | 38097 | 190683 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1301 Minnesota St | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015372.42654 | 2102509.7647599997 | 37.7539548603504 | -122.389744472134 | (37.7539548603504, -122.389744472134) |
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");