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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 45830 | 45830 | 226462 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007188.60102 | 2106179.3508900004 | 37.763573483764894 | -122.41830630538601 | (37.7635734837649, -122.418306305386) | |||
| 45869 | 45869 | 229853 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 204 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6005411.70889 | 2102466.72114 | 37.7532792905247 | -122.42418796512501 | (37.7532792905247, -122.424187965125) | |||
| 46089 | 46089 | 229832 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1216 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010283.83962 | 2102006.15901 | 37.7522885811545 | -122.407306593143 | (37.7522885811545, -122.407306593143) | |||
| 46113 | 46113 | 226433 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006663.83853 | 2103099.55931 | 37.7550875384663 | -122.41990273874201 | (37.7550875384663, -122.419902738742) | |||
| 46199 | 46199 | 226315 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1045 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007642.72664 | 2103585.2825 | 37.756476322828 | -122.416551856705 | (37.756476322828, -122.416551856705) | |||
| 46346 | 46346 | 229882 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3770 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6008416.680380001 | 2097349.4564400003 | 37.739397632402294 | -122.41343424801 | (37.7393976324023, -122.41343424801) | |||
| 46451 | 46451 | 190747 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 200 Kansas St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6011390.12769 | 2107238.8028700002 | 37.766718110788105 | -122.40384902720899 | (37.7667181107881, -122.403849027209) | |||
| 46593 | 46593 | 229810 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1801 Bryant St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009529.11729 | 2106277.27866 | 37.7639738421376 | -122.41021807989999 | (37.7639738421376, -122.4102180799) | |||
| 47175 | 47175 | 229839 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 70 Lapidge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005996.276219999 | 2105099.28876 | 37.7605406982241 | -122.422353441684 | (37.7605406982241, -122.422353441684) | |||
| 47184 | 47184 | 229792 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1347 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006987.3466 | 2107613.99379 | 37.7675013456445 | -122.419104149736 | (37.7675013456445, -122.419104149736) | |||
| 47533 | 47533 | 190685 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 801 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014780.75112 | 2106205.10487 | 37.7640686405785 | -122.392049045151 | (37.7640686405785, -122.392049045151) | |||
| 47572 | 47572 | 229860 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3224 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008991.737509999 | 2099895.44974 | 37.746420642402605 | -122.411625786002 | (37.7464206424026, -122.411625786002) | |||
| 47649 | 47649 | 226766 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 84 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005428.90079 | 2099643.2891700002 | 37.7455277666988 | -122.42392775438101 | (37.7455277666988, -122.423927754381) | |||
| 47742 | 47742 | 229875 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3771 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004599.42844 | 2102480.0904900003 | 37.7532701021595 | -122.42699795081002 | (37.7532701021595, -122.42699795081) | |||
| 47760 | 47760 | 226378 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 511 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008209.356369999 | 2096429.78748 | 37.7368607798011 | -122.414086039755 | (37.7368607798011, -122.414086039755) | |||
| 47888 | 47888 | 229858 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 115 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005418.6936800005 | 2103014.66569 | 37.754784213323205 | -122.42420277693199 | (37.7547842133232, -122.424202776932) | |||
| 48009 | 48009 | 190733 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 128 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010530.15081 | 2107694.7357900003 | 37.767921917195004 | -122.406855692832 | (37.767921917195, -122.406855692832) | |||
| 48315 | 48315 | 190746 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6014545.668430001 | 2096162.71895 | 37.7364813198484 | -122.392159766062 | (37.7364813198484, -122.392159766062) | |||
| 48327 | 48327 | 226794 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 267 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001783.4277 | 2104311.13216 | 37.7581380667326 | -122.4368673106 | (37.7581380667326, -122.4368673106) | |||
| 48658 | 48658 | 226335 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 19 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006677.49566 | 2103645.89142 | 37.756588409851496 | -122.419894274305 | (37.7565884098515, -122.419894274305) | |||
| 48681 | 48681 | 229888 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 83 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008255.19246 | 2099602.19695 | 37.745574091677206 | -122.414151939365 | (37.7455740916772, -122.414151939365) | |||
| 48765 | 48765 | 226824 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 463 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6003840.68463 | 2095954.9720599998 | 37.735310701123296 | -122.429156618694 | (37.7353107011233, -122.429156618694) | |||
| 48894 | 48894 | 226782 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 579 Noe St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6003036.36439 | 2104869.3742 | 37.7597419968272 | -122.43257399299999 | (37.7597419968272, -122.432573993) | |||
| 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) | |||
| 50352 | 50352 | 226767 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4257 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001499.39319 | 2102307.7971900003 | 37.752621244884 | -122.437706147824 | (37.752621244884, -122.437706147824) | |||
| 50374 | 50374 | 226380 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 60 Nebraska St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6009262.96454 | 2097691.6296900003 | 37.740384646425795 | -122.410532314727 | (37.7403846464258, -122.410532314727) | |||
| 50747 | 50747 | 229889 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 77 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008249.8814900005 | 2099665.88685 | 37.7457486716635 | -122.414174809135 | (37.7457486716635, -122.414174809135) | |||
| 50888 | 50888 | 226456 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3330 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008043.14081 | 2104467.44618 | 37.7589210533947 | -122.41522952324 | (37.7589210533947, -122.41522952324) | |||
| 50961 | 50961 | 229852 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3631 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005555.32091 | 2102533.44251 | 37.7534705997005 | -122.423696068331 | (37.7534705997005, -122.423696068331) | |||
| 51165 | 51165 | 190723 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2277 Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010387.48096 | 2107844.66484 | 37.768325603974795 | -122.40735974486601 | (37.7683256039748, -122.407359744866) | |||
| 51559 | 51559 | 190682 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 546 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010644.5889099995 | 2105668.4578400003 | 37.7623646204591 | -122.40631707628799 | (37.7623646204591, -122.406317076288) | |||
| 51857 | 51857 | 229793 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2 Trainor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008301.706069999 | 2108167.22951 | 37.7690943309545 | -122.414597094793 | (37.7690943309545, -122.414597094793) | |||
| 52333 | 52333 | 226439 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 355 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006776.4110900005 | 2101737.7039799998 | 37.751354537191 | -122.41941682063101 | (37.751354537191, -122.419416820631) | |||
| 52736 | 52736 | 46565 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 642 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | 11 | Permit Number 44700 | 6012366.61584 | 2104950.40498 | 37.7604891841446 | -122.400310752549 | (37.7604891841446, -122.400310752549) |
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");