Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
30560 | 30560 | 32977 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 448 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 4 | Permit Number 46744 | 6014321.91414 | 2105021.23892 | 37.76079251737271 | -122.393553179256 | (37.7607925173727, -122.393553179256) | |
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) | |||
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) | |||
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) | |||
37810 | 37810 | 39586 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1011 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 4 | Permit Number 40997 | 6011941.43836 | 2103546.16349 | 37.756609729177896 | -122.401682552328 | (37.7566097291779, -122.401682552328) | |
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) | ||||
40345 | 40345 | 94180 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 605 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53586 | 6010991.81939 | 2105452.40233 | 37.7617907981332 | -122.40510091500201 | (37.7617907981332, -122.405100915002) | |
41876 | 41876 | 229756 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011464.1555699995 | 2102190.87321 | 37.7528617550894 | -122.40323784257299 | (37.7528617550894, -122.403237842573) | |||
42016 | 42016 | 190686 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 801 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6014799.41703 | 2106205.9134299997 | 37.7640718970256 | -122.391984541257 | (37.7640718970256, -122.391984541257) | |||
42426 | 42426 | 190691 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1005 Minnesota St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6015298.330490001 | 2103800.67785 | 37.757495323968 | -122.39009089187901 | (37.757495323968, -122.390090891879) | |||
43371 | 43371 | 100400 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 88 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x3 | 6008223.0 | 2099495.0 | 37.7452779444232 | -122.41425567326598 | (37.7452779444232, -122.414255673266) | |||
44390 | 44390 | 229826 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1312 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6010048.8848 | 2101524.58992 | 37.750953146384 | -122.408085148809 | (37.750953146384, -122.408085148809) | |||
45723 | 45723 | 190690 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1003 Minnesota St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6015296.6982 | 2103817.69544 | 37.757541960103396 | -122.39009772585501 | (37.7575419601034, -122.390097725855) | |||
47604 | 47604 | 69898 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1019 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 4 | 6011946.5334 | 2103437.3528 | 37.756311243277004 | -122.401657284058 | (37.756311243277, -122.401657284058) | ||
49531 | 49531 | 226394 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1451 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008031.02829 | 2099712.8613299998 | 37.7458653577975 | -122.41493489813699 | (37.7458653577975, -122.414934898137) | |||
49682 | 49682 | 190742 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1617 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6015073.9615 | 2096817.26033 | 37.738307875303796 | -122.390378936647 | (37.7383078753038, -122.390378936647) | |||
54680 | 54680 | 190737 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 168 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6010533.3608099995 | 2107625.71159 | 37.767732572127294 | -122.406839724475 | (37.7677325721273, -122.406839724475) | |||
56727 | 56727 | 228536 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009279.45147 | 2107357.51638 | 37.7669259288053 | -122.411157913712 | (37.7669259288053, -122.411157913712) | |||
58441 | 58441 | 229861 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1509 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010132.55959 | 2100497.5838599997 | 37.7481378987515 | -122.407723384842 | (37.7481378987515, -122.407723384842) | |||
61430 | 61430 | 229754 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011464.93054 | 2102145.24186 | 37.7527365046859 | -122.403231952908 | (37.7527365046859, -122.403231952908) | |||
61585 | 61585 | 229787 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1799 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005558.49234 | 2107230.4627 | 37.7663676926515 | -122.42401909489901 | (37.7663676926515, -122.424019094899) | |||
63640 | 63640 | 38604 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1556 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50557 | 6015379.8321 | 2094216.5354 | 37.7311837737961 | -122.38913983494801 | (37.7311837737961, -122.389139834948) | |
69907 | 69907 | 226357 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 645 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005980.007540001 | 2099557.6277 | 37.7453236574624 | -122.42201602593799 | (37.7453236574624, -122.422016025938) | |||
70491 | 70491 | 226372 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4222 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002353.94285 | 2100643.26716 | 37.748099392475 | -122.43463195751801 | (37.748099392475, -122.434631957518) | |||
72129 | 72129 | 229771 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011447.677180001 | 2102483.4305 | 37.7536641328931 | -122.403315407293 | (37.7536641328931, -122.403315407293) | |||
74899 | 74899 | 190694 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 99 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013445.19565 | 2106684.95045 | 37.7653119497171 | -122.396702014197 | (37.7653119497171, -122.396702014197) | |||
75203 | 75203 | 226822 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 39 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004297.5525 | 2098038.31795 | 37.7410569481125 | -122.42772544836599 | (37.7410569481125, -122.427725448366) | |||
83699 | 83699 | 102167 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 677 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769761 | 6002448.6 | 2104297.1 | 37.7581373205651 | -122.4345658575 | (37.7581373205651, -122.4345658575) |
106016 | 106016 | 226435 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006660.81941 | 2103136.07502 | 37.75518763210621 | -122.419915770819 | (37.7551876321062, -122.419915770819) | |||
113367 | 113367 | 34979 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 204 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | 4 | 4.5x5.5 | Permit Number 38560 | 6005404.47969691 | 2102506.81993306 | 37.75338898431921 | -122.424215816798 | (37.7533889843192, -122.424215816798) | |
119848 | 119848 | 229838 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 28 Lapidge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005984.4522400005 | 2105323.33984 | 37.7611552229594 | -122.422410255427 | (37.7611552229594, -122.422410255427) | |||
130013 | 130013 | 116873 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1250 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6013484.98836 | 2106649.50082 | 37.7652168275233 | -122.396561894417 | (37.7652168275233, -122.396561894417) | |||
134711 | 134711 | 229867 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 474 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002892.54695 | 2098627.83365 | 37.7425960442853 | -122.432625542146 | (37.7425960442853, -122.432625542146) | |||
136900 | 136900 | 229779 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011439.173280001 | 2102646.69218 | 37.75411193863 | -122.403356300366 | (37.75411193863, -122.403356300366) | |||
140184 | 140184 | 229768 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011450.10406 | 2102428.33109 | 37.7535129775571 | -122.40330313873301 | (37.7535129775571, -122.403303138733) | |||
147848 | 147848 | 229762 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011454.29465 | 2102314.61303 | 37.7532009667707 | -122.403280647606 | (37.7532009667707, -122.403280647606) | |||
149086 | 149086 | 229895 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1429 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008018.20821 | 2099852.6789700002 | 37.7462485454514 | -122.41498912275101 | (37.7462485454514, -122.414989122751) | |||
149742 | 149742 | 229772 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011446.86383 | 2102500.86077 | 37.7537119471592 | -122.403319446151 | (37.7537119471592, -122.403319446151) | |||
150318 | 150318 | 38603 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1556 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50557 | 6015358.9468 | 2094230.8253 | 37.7312218531881 | -122.38921303719499 | (37.7312218531881, -122.389213037195) | |
154235 | 154235 | 229844 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3676 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005793.115569999 | 2104343.5803900003 | 37.7584542377953 | -122.423002369088 | (37.7584542377953, -122.423002369088) | |||
154343 | 154343 | 226352 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3133 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007317.42838 | 2105554.4356 | 37.761864862688604 | -122.417816432095 | (37.7618648626886, -122.417816432095) | |||
155759 | 155759 | 226368 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4252 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6002219.8956 | 2101222.17774 | 37.7496813332396 | -122.43513688726001 | (37.7496813332396, -122.43513688726) | |||
156248 | 156248 | 229848 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3494 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6005112.08271 | 2103723.9282400003 | 37.75671436528889 | -122.42531359166901 | (37.7567143652889, -122.425313591669) | |||
157614 | 157614 | 190697 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 99 Missouri St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013439.7362 | 2106789.19698 | 37.7655978837597 | -122.396728206045 | (37.7655978837597, -122.396728206045) | |||
158140 | 158140 | 226358 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 603 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006078.34429 | 2099888.6136 | 37.7462380152724 | -122.42169949783899 | (37.7462380152724, -122.421699497839) | |||
160436 | 160436 | 88048 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1555 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51058 | 6015584.72865 | 2096785.6405200001 | 37.73824937351 | -122.388610732819 | (37.73824937351, -122.388610732819) | |
162409 | 162409 | 226436 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006661.6983199995 | 2103152.67554 | 37.755233262826295 | -122.419913909217 | (37.7552332628263, -122.419913909217) | |||
163771 | 163771 | 190688 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1001 Minnesota St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6015295.35609 | 2103854.9870599997 | 37.7576442804869 | -122.390104972579 | (37.7576442804869, -122.390104972579) | |||
166694 | 166694 | 50730 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 725 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | 4 | Permit Number 47280 | 6012445.19576 | 2104545.72863 | 37.7593824136929 | -122.400010559737 | (37.7593824136929, -122.400010559737) | ||
169236 | 169236 | 190695 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 99 Missouri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013444.76571 | 2106699.32295 | 37.765351389493105 | -122.39670450891701 | (37.7653513894931, -122.396704508917) | |||
170855 | 170855 | 35338 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 738 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 4 | Permit Number 38803 | 6013013.2913 | 2103555.4038400003 | 37.7566948554054 | -122.397976322051 | (37.7566948554054, -122.397976322051) | |
171048 | 171048 | 229849 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 86 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005369.70063 | 2103246.31322 | 37.7554174970228 | -122.42438868391199 | (37.7554174970228, -122.424388683912) | |||
172297 | 172297 | 190698 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 99 Missouri St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013440.0708800005 | 2106805.7081400002 | 37.765643238376796 | -122.396728206061 | (37.7656432383768, -122.396728206061) | |||
172607 | 172607 | 190687 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1001 Minnesota St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6015294.95519 | 2103873.52866 | 37.7576951695231 | -122.390107654354 | (37.7576951695231, -122.390107654354) | |||
174390 | 174390 | 229887 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 87 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008255.9932699995 | 2099554.30466 | 37.745442635078 | -122.414145782603 | (37.745442635078, -122.414145782603) | |||
174788 | 174788 | 190745 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1617 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6015075.48119 | 2096817.4615200001 | 37.7383085120296 | -122.39037369631501 | (37.7383085120296, -122.390373696315) | |||
176880 | 176880 | 229750 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 365 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005497.63156 | 2101589.27142 | 37.750874867598206 | -122.423828439536 | (37.7508748675982, -122.423828439536) | |||
179500 | 179500 | 78429 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 744 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 4 | 3x3 | 6011805.9335 | 2104893.37298 | 37.7603013058687 | -122.402245896623 | (37.7603013058687, -122.402245896623) | |
180024 | 180024 | 229767 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011451.55336 | 2102410.70185 | 37.7534646524788 | -122.40329688663799 | (37.7534646524788, -122.403296886638) | |||
180443 | 180443 | 229755 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011464.24481 | 2102169.9708 | 37.7528043666378 | -122.40323606370701 | (37.7528043666378, -122.403236063707) | |||
181303 | 181303 | 229760 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6011458.91565 | 2102265.65077 | 37.753066785227105 | -122.40326122314501 | (37.7530667852271, -122.403261223145) | |||
182980 | 182980 | 62086 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 508 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1985 12:00:00 AM | 4 | Permit Number 22172 | 6013224.51154 | 2104585.93548 | 37.759536231938206 | -122.39731810554501 | (37.7595362319382, -122.397318105545) | |
187160 | 187160 | 228539 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009212.74652 | 2107353.73928 | 37.766911816665704 | -122.41138836950199 | (37.7669118166657, -122.411388369502) |
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");