Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 28823 | 28823 | 37988 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 613 Texas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 9 | Permit Number 40209 | 6013865.90817 | 2104201.25783 | 37.7585156794839 | -122.39507287703199 | (37.7585156794839, -122.395072877032) | |
| 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) | |||
| 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) | |||
| 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) | |
| 31195 | 31195 | 35348 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1142 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 10 | Permit Number 38811 | 6012185.95108 | 2103089.25023 | 37.7553687870439 | -122.40080483467301 | (37.7553687870439, -122.400804834673) | |
| 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) | |||
| 33670 | 33670 | 67525 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1237 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 5 | Permit Number 31063 | 6013863.96904 | 2105222.10332 | 37.7613185911004 | -122.395151089252 | (37.7613185911004, -122.395151089252) | |
| 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) | |||
| 35605 | 35605 | 49762 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 123@ GIRARD Ordway St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 1 | Permit Number 46556 | 6011554.1535 | 2090217.48516 | 37.7199903867389 | -122.402084923384 | (37.7199903867389, -122.402084923384) | |
| 35695 | 35695 | 35366 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1034 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 10 | Permit Number 38826 | 6011879.44293 | 2103561.1446700003 | 37.756647404478 | -122.40189800918999 | (37.756647404478, -122.40189800919) | |
| 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) | |||
| 36302 | 36302 | 38643 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 850 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 8 | Permit Number 41006 | 6012722.66852 | 2103506.4045 | 37.7565441236392 | -122.39897796896099 | (37.7565441236392, -122.398977968961) | |
| 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) | |||
| 37401 | 37401 | 35575 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | 7X6 | Permit Number 38943 | 6005733.52150857 | 2103415.89933022 | 37.7559036789868 | -122.42314253259501 | (37.7559036789868, -122.423142532595) | |
| 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) | |||
| 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) | |
| 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) | |||
| 38020 | 38020 | 32982 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 559 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 14 | Permit Number 37295 | 6013853.095 | 2104468.98134 | 37.7592500775456 | -122.39513594376899 | (37.7592500775456, -122.395135943769) | |
| 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) | ||||
| 38164 | 38164 | 229739 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 28 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005381.68276 | 2105771.85713 | 37.7623527242205 | -122.424526883603 | (37.7623527242205, -122.424526883603) | |||
| 38255 | 38255 | 229744 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006129.97006 | 2100227.1008099997 | 37.747170335258204 | -122.421545017711 | (37.7471703352582, -122.421545017711) | |||
| 38346 | 38346 | 36010 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39158 | 6005991.6913929 | 2099142.23667474 | 37.744183746831496 | -122.421946122617 | (37.7441837468315, -122.421946122617) | ||
| 38369 | 38369 | 226432 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006660.51047 | 2103068.53452 | 37.7550021640414 | -122.41991204671999 | (37.7550021640414, -122.41991204672) | |||
| 38730 | 38730 | 226338 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 41 Bartlett St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006684.19647 | 2103512.2186 | 37.7562217526516 | -122.41986161543001 | (37.7562217526516, -122.41986161543) | |||
| 38848 | 38848 | 229842 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3731 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005435.33161 | 2104281.1313099996 | 37.758262571580794 | -122.424235305437 | (37.7582625715808, -122.424235305437) | |||
| 39045 | 39045 | 190719 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 642 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6014091.4532699995 | 2104130.33792 | 37.75833348851889 | -122.39428786959 | (37.7583334885189, -122.39428786959) | |||
| 39582 | 39582 | 229804 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 10 Crescent Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 5ft | 6005354.49537 | 2095898.81655 | 37.7352420900484 | -122.423918818711 | (37.7352420900484, -122.423918818711) | |||
| 40061 | 40061 | 226772 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 580 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002600.09968 | 2103291.6140799997 | 37.7553850962495 | -122.433970034883 | (37.7553850962495, -122.433970034883) | |||
| 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) | |
| 40415 | 40415 | 226761 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 69 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005532.060269999 | 2099607.16908 | 37.745434412567896 | -122.423568476998 | (37.7454344125679, -122.423568476998) | |||
| 40456 | 40456 | 229883 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3784 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008413.69404 | 2097282.5968400002 | 37.7392138829104 | -122.413439846296 | (37.7392138829104, -122.413439846296) | |||
| 40607 | 40607 | 229785 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1366 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010846.0607900005 | 2101951.02013 | 37.7521686322761 | -122.40535845022801 | (37.7521686322761, -122.405358450228) | |||
| 40700 | 40700 | 226317 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1332 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007672.14775 | 2101889.27632 | 37.7518211306439 | -122.416329985835 | (37.7518211306439, -122.416329985835) | |||
| 40736 | 40736 | 226790 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 35 Yukon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000260.41701 | 2104714.6723 | 37.7591594105937 | -122.44216349005899 | (37.7591594105937, -122.442163490059) | |||
| 40742 | 40742 | 226305 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 84 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006137.34667 | 2097561.4602200002 | 37.7398515040311 | -122.42133024340599 | (37.7398515040311, -122.421330243406) | |||
| 40748 | 40748 | 229794 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 270 14th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6006938.57132 | 2107935.81183 | 37.768382235178706 | -122.419295689168 | (37.7683822351787, -122.419295689168) | |||
| 40786 | 40786 | 229741 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 714 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6004954.861330001 | 2104148.63623 | 37.757871629989296 | -122.42588755157101 | (37.7578716299893, -122.425887551571) | |||
| 40930 | 40930 | 226331 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 155 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6006477.527480001 | 2105222.5882 | 37.7609063850338 | -122.420697763712 | (37.7609063850338, -122.420697763712) | |||
| 41014 | 41014 | 226360 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005779.63458 | 2103420.31022 | 37.7559183924354 | -122.422983371787 | (37.7559183924354, -122.422983371787) | |||
| 41064 | 41064 | 226779 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3974 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003146.2455400005 | 2105369.3554599998 | 37.76112105592 | -122.432229675877 | (37.76112105592, -122.432229675877) | |||
| 41798 | 41798 | 229805 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3526 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6006031.82091 | 2105526.37435 | 37.7617153800751 | -122.42226085285499 | (37.7617153800751, -122.422260852855) | |||
| 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) | |||
| 42129 | 42129 | 108456 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 980 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6015231.85708 | 2103981.85157 | 37.7579891012316 | -122.390333443542 | (37.7579891012316, -122.390333443542) | ||||
| 42197 | 42197 | 226381 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 60 Nebraska St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6009264.00065 | 2097705.48363 | 37.740422744414396 | -122.410529710297 | (37.7404227444144, -122.410529710297) | |||
| 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) | |||
| 42743 | 42743 | 108444 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 2 | 3x2.5 | 6014877.0 | 2117007.0 | 37.793733556134896 | -122.39247175850299 | (37.7937335561349, -122.392471758503) | |
| 42935 | 42935 | 226446 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3102 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008932.04499 | 2101596.23583 | 37.75108727397021 | -122.411952365814 | (37.7510872739702, -122.411952365814) | |||
| 43204 | 43204 | 228534 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009327.35781 | 2107359.80868 | 37.7669349094434 | -122.41099237460699 | (37.7669349094434, -122.410992374607) | |||
| 43221 | 43221 | 226788 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 133 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002056.46904 | 2105062.33058 | 37.760216190457605 | -122.43597676863999 | (37.7602161904576, -122.43597676864) | |||
| 43281 | 43281 | 229835 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2899 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010132.5344 | 2101618.9550900003 | 37.7512169355291 | -122.407802532369 | (37.7512169355291, -122.407802532369) | |||
| 43282 | 43282 | 226795 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 677 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002427.793880001 | 2104301.04841 | 37.758146980811404 | -122.434638096272 | (37.7581469808114, -122.434638096272) | |||
| 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) | |||
| 43399 | 43399 | 226803 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4187 20th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002522.14485 | 2104118.46632 | 37.7576510101026 | -122.434298737121 | (37.7576510101026, -122.434298737121) | |||
| 43435 | 43435 | 226821 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1883 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004617.16315 | 2097706.60415 | 37.740164211802 | -122.42659673536998 | (37.740164211802, -122.42659673537) | |||
| 43450 | 43450 | 226442 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3246 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008090.25065 | 2101545.29399 | 37.750900134931605 | -122.41485978137199 | (37.7509001349316, -122.414859781372) | |||
| 43697 | 43697 | 226398 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1480 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008004.95256 | 2099511.34192 | 37.745310565138794 | -122.415010803607 | (37.7453105651388, -122.415010803607) | |||
| 43915 | 43915 | 226404 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 47 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007592.36819 | 2099969.05914 | 37.746544160700005 | -122.416469871814 | (37.7465441607, -122.416469871814) | |||
| 44135 | 44135 | 226800 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 611 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003049.61247 | 2104666.39775 | 37.7591854234811 | -122.43251367635901 | (37.7591854234811, -122.432513676359) | |||
| 44200 | 44200 | 229830 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1097 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010012.5891 | 2102852.11627 | 37.7545962064773 | -122.408304286625 | (37.7545962064773, -122.408304286625) | |||
| 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) | |||
| 44950 | 44950 | 101142 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 450 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6x5 | 6013202.87541 | 2105008.80467 | 37.7606961334358 | -122.397422590588 | (37.7606961334358, -122.397422590588) | |||
| 45346 | 45346 | 121804 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1201x Vermont St | 22 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011405.0 | 2102539.0 | 37.753814330877205 | -122.403466904543 | (37.7538143308772, -122.403466904543) | ||||
| 45365 | 45365 | 201527 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 740 Earl St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 5ft | 6020341.20189 | 2093704.82943 | 37.730052512603294 | -122.371951898056 | (37.7300525126033, -122.371951898056) | |||
| 45434 | 45434 | 176587 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 125 Ordway St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011540.71743 | 2090213.76704 | 37.719979427594104 | -122.402131106273 | (37.7199794275941, -122.402131106273) | |||
| 45444 | 45444 | 228545 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1449 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6009584.1188 | 2100794.69775 | 37.7489229907161 | -122.409640850052 | (37.7489229907161, -122.409640850052) | |||
| 45485 | 45485 | 229864 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 76 Peralta Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6010511.83754 | 2100376.53881 | 37.7478267603098 | -122.406403320374 | (37.7478267603098, -122.406403320374) | |||
| 45657 | 45657 | 229886 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1420 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007989.59839 | 2099723.5875 | 37.7458924813579 | -122.41507891646002 | (37.7458924813579, -122.41507891646) | |||
| 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) |
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");