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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188966 | 188966 | 226346 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008464.57897 | 2101524.14473 | 37.7508630900604 | -122.41356381871599 | (37.7508630900604, -122.413563818716) | |||
| 188915 | 188915 | 138953 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 717 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004472.5713 | 2110950.3879 | 37.7765203347407 | -122.42804020876001 | (37.7765203347407, -122.42804020876) | |||
| 188899 | 188899 | 226386 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 354 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006131.45892 | 2098074.37938 | 37.7412595329921 | -122.421387016722 | (37.7412595329921, -122.421387016722) | |||
| 188726 | 188726 | 229802 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 232 Lexington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006479.512730001 | 2104709.9912400004 | 37.759499025184496 | -122.420654508118 | (37.7594990251845, -122.420654508118) | |||
| 188639 | 188639 | 226373 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4222 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002349.444019999 | 2100642.72182 | 37.7480976397016 | -122.434647475301 | (37.7480976397016, -122.434647475301) | |||
| 188531 | 188531 | 67581 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 321 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 10 | Permit Number 31145 | 6013230.15205 | 2105558.3695799997 | 37.7622066365616 | -122.39736679306999 | (37.7622066365616, -122.39736679307) | |
| 188478 | 188478 | 226383 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007419.20582 | 2097997.75063 | 37.7411216480553 | -122.416929004483 | (37.7411216480553, -122.416929004483) | |||
| 188188 | 188188 | 229822 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 956 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6009932.67033 | 2103635.88774 | 37.7567437920002 | -122.40863595569701 | (37.7567437920002, -122.408635955697) | |||
| 188041 | 188041 | 226307 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 303 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007092.99842 | 2096727.1490900002 | 37.7376145033994 | -122.417966864376 | (37.7376145033994, -122.417966864376) | |||
| 187546 | 187546 | 32262 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 3 | Permit Number 35561 | 6005748.8799 | 2099664.71545 | 37.7456046578383 | -122.422822837406 | (37.7456046578383, -122.422822837406) | |
| 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) | |||
| 187007 | 187007 | 226411 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 950 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009265.11627 | 2098029.82714 | 37.741313383516996 | -122.410548750743 | (37.741313383517, -122.410548750743) | |||
| 186891 | 186891 | 226458 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3318 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008112.40239 | 2104471.67491 | 37.7589365568012 | -122.41499028288 | (37.7589365568012, -122.41499028288) | |||
| 186618 | 186618 | 115552 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 925x Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 15x7 | 6015276.56251 | 2104229.2059299997 | 37.7586707630633 | -122.390196112573 | (37.7586707630633, -122.390196112573) | ||
| 186575 | 186575 | 226337 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 41 Bartlett St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006682.98669 | 2103529.00936 | 37.756267788048795 | -122.41986699069099 | (37.7562677880488, -122.419866990691) | |||
| 186355 | 186355 | 39588 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1070 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 9 | Permit Number 40999 | 6011886.49797 | 2103421.1192799998 | 37.7562633193119 | -122.40186376750601 | (37.7562633193119, -122.401863767506) | |
| 186299 | 186299 | 226314 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1357 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6007744.38877 | 2101777.28879 | 37.751517700281404 | -122.416072235664 | (37.7515177002814, -122.416072235664) | |||
| 186242 | 186242 | 200047 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1582 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015033.0267 | 2094124.7502 | 37.730912518823295 | -122.39033240224899 | (37.7309125188233, -122.390332402249) | |||
| 186181 | 186181 | 142077 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 36 ATALAYA TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998850.2457 | 2110939.7307 | 37.776171379653896 | -122.447488599832 | (37.7761713796539, -122.447488599832) | |||
| 185952 | 185952 | 39551 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 814 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 6 | Permit Number 40977 | 6012407.86986 | 2104192.7387200003 | 37.7584111000042 | -122.40011486132 | (37.7584111000042, -122.40011486132) | |
| 185811 | 185811 | 229836 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 112 San Carlos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006642.16012 | 2105416.67615 | 37.7614485827148 | -122.420142145449 | (37.7614485827148, -122.420142145449) | |||
| 185529 | 185529 | 226416 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1118 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008031.51023 | 2101373.79083 | 37.7504259251155 | -122.415050773974 | (37.7504259251155, -122.415050773974) | |||
| 185514 | 185514 | 226765 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004241.0492 | 2095563.86697 | 37.7342594709862 | -122.427744552687 | (37.7342594709862, -122.427744552687) | |||
| 185078 | 185078 | 226762 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 62 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005544.98011 | 2099653.8434200003 | 37.745563298918704 | -122.42352711990101 | (37.7455632989187, -122.423527119901) | |||
| 184718 | 184718 | 229816 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 990 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008580.21051 | 2102912.8481900003 | 37.7546826492875 | -122.41326214475299 | (37.7546826492875, -122.413262144753) | |||
| 184211 | 184211 | 190717 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1150 19th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6014133.64605 | 2105280.55607 | 37.7614940829991 | -122.39422247538401 | (37.7614940829991, -122.394222475384) | |||
| 184158 | 184158 | 30882 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 601 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2005 12:00:00 AM | 6 | Permit Number 48128 | 6014140.03931 | 2104332.5507 | 37.7588914216105 | -122.39413399288601 | (37.7588914216105, -122.394133992886) | ||
| 183574 | 183574 | 226406 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1417 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008014.498269999 | 2099882.17848 | 37.7463293360461 | -122.415004038921 | (37.7463293360461, -122.415004038921) | |||
| 183258 | 183258 | 226328 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 351 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007822.68734 | 2105830.6205599997 | 37.762651623808104 | -122.416088496301 | (37.7626516238081, -122.416088496301) | |||
| 183146 | 183146 | 129102 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Buchanan St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6004465.70248 | 2110959.4385 | 37.7765447968535 | -122.428064615105 | (37.7765447968535, -122.428064615105) | |||
| 183138 | 183138 | 226388 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 88 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006749.9144 | 2099207.7220900003 | 37.7444062878286 | -122.41932899196001 | (37.7444062878286, -122.41932899196) | |||
| 182992 | 182992 | 190692 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1007 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6015546.55953 | 2104430.7549099997 | 37.7592391453969 | -122.38927640559099 | (37.7592391453969, -122.389276405591) | |||
| 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) | |
| 182886 | 182886 | 190722 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2200 Alameda St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010363.6035400005 | 2107883.96222 | 37.7684321691431 | -122.407445105823 | (37.7684321691431, -122.407445105823) | |||
| 182727 | 182727 | 226811 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004456.5508 | 2107418.4917900003 | 37.7668217000839 | -122.427843906179 | (37.7668217000839, -122.427843906179) | |||
| 182453 | 182453 | 226778 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3934 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003366.66584 | 2105380.9002799997 | 37.761165250397 | -122.43146816144301 | (37.761165250397, -122.431468161443) | |||
| 182421 | 182421 | 229809 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1801 Bryant St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009528.66718 | 2106237.67868 | 37.7638650844166 | -122.410216840643 | (37.7638650844166, -122.410216840643) | |||
| 182379 | 182379 | 80400 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 847 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51000 | 6000427.8652 | 2111924.6617 | 37.778965778909296 | -122.442101918526 | (37.7789657789093, -122.442101918526) | |
| 182053 | 182053 | 190732 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010527.29182 | 2107717.8289 | 37.767985165622605 | -122.40686720957899 | (37.7679851656226, -122.406867209579) | |||
| 181787 | 181787 | 190728 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010522.48931 | 2107817.1778 | 37.768257686259105 | -122.406890823964 | (37.7682576862591, -122.406890823964) | |||
| 181725 | 181725 | 70134 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 342-344 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 7 | 6010584.92199 | 2106684.72003 | 37.7651517084965 | -122.40659506122499 | (37.7651517084965, -122.406595061225) | ||
| 181441 | 181441 | 229892 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008238.53675 | 2099832.54368 | 37.7462056369848 | -122.414225826762 | (37.7462056369848, -122.414225826762) | |||
| 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) | |||
| 181284 | 181284 | 228530 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1736 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 6ft | 6009448.1788099995 | 2106596.433 | 37.7648456296528 | -122.410520561485 | (37.7648456296528, -122.410520561485) | |||
| 181234 | 181234 | 226785 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3894 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003780.43348 | 2104817.05272 | 37.75964050202929 | -122.429996893968 | (37.7596405020293, -122.429996893968) | |||
| 181213 | 181213 | 101797 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 600X Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6x6 | 6012355.97365 | 2105123.66121 | 37.7609643139807 | -122.400359728744 | (37.7609643139807, -122.400359728744) | |||
| 180989 | 180989 | 229786 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1254 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010820.80874 | 2102463.77247 | 37.7535751252085 | -122.405481884883 | (37.7535751252085, -122.405481884883) | |||
| 180970 | 180970 | 226399 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1480 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008004.14123 | 2099529.6733 | 37.745360853432395 | -122.41501490632 | (37.7453608534324, -122.41501490632) | |||
| 180912 | 180912 | 123149 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 530 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992851.14917 | 2111838.68412 | 37.77829500806129 | -122.468306331193 | (37.7782950080613, -122.468306331193) | |||
| 180855 | 180855 | 229814 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2851 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010203.85183 | 2101034.69033 | 37.749616665695896 | -122.40751471964799 | (37.7496166656959, -122.407514719648) | |||
| 180784 | 180784 | 226793 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 379 Collingwood St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6002133.14773 | 2103676.3157099998 | 37.756414883846105 | -122.435612414605 | (37.7564148838461, -122.435612414605) | |||
| 180694 | 180694 | 229796 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6005429.44821 | 2105495.57142 | 37.7615968062711 | -122.42434202886999 | (37.7615968062711, -122.42434202887) | |||
| 180535 | 180535 | 226382 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 58 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009331.97291 | 2097098.9463900002 | 37.738761135424795 | -122.410251874634 | (37.7387611354248, -122.410251874634) | |||
| 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) | |||
| 180200 | 180200 | 226393 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1451 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008028.94032 | 2099726.7877 | 37.745903479176896 | -122.41494310356701 | (37.7459034791769, -122.414943103567) | |||
| 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) | |||
| 179526 | 179526 | 190700 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 199 Texas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013754.83495 | 2106240.90179 | 37.764109918566206 | -122.395599922892 | (37.7641099185662, -122.395599922892) | |||
| 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) | |
| 179360 | 179360 | 226405 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1405 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008013.30182 | 2099943.8587 | 37.746498628924996 | -122.415012541103 | (37.746498628925, -122.415012541103) | |||
| 179268 | 179268 | 229775 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011442.57459 | 2102566.84517 | 37.7538928862632 | -122.40333892097799 | (37.7538928862632, -122.403338920978) | |||
| 179213 | 179213 | 228527 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 405 Florida St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009241.97976 | 2106321.44557 | 37.7640790151609 | -122.4112143273 | (37.7640790151609, -122.4112143273) | |||
| 178840 | 178840 | 226774 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4069 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003404.88062 | 2101242.91418 | 37.749805488230706 | -122.431040646222 | (37.7498054882307, -122.431040646222) | |||
| 178525 | 178525 | 190699 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 99 Missouri St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6013438.177180001 | 2106819.03274 | 37.7656797193792 | -122.3967356902 | (37.7656797193792, -122.3967356902) | |||
| 178416 | 178416 | 129103 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1306x Montgomery St | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011435.37643 | 2120050.37627 | 37.8018982087863 | -122.40459448426901 | (37.8018982087863, -122.404594484269) | |||
| 178091 | 178091 | 226347 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008486.7284 | 2101525.46437 | 37.7508679571961 | -122.413487316996 | (37.7508679571961, -122.413487316996) | |||
| 178077 | 178077 | 228538 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009238.1018900005 | 2107354.62318 | 37.7669156657401 | -122.411300731452 | (37.7669156657401, -122.411300731452) | |||
| 178014 | 178014 | 116872 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1250 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013499.867880001 | 2106650.2771400004 | 37.7652197871992 | -122.396510483775 | (37.7652197871992, -122.396510483775) | |||
| 177654 | 177654 | 226351 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3273 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006624.340340001 | 2103173.55504 | 37.7552884883831 | -122.420044586082 | (37.7552884883831, -122.420044586082) | |||
| 177492 | 177492 | 39550 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 815 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40976 | 6012466.9688800005 | 2104165.36194 | 37.7583392243866 | -122.399908546943 | (37.7583392243866, -122.399908546943) | |
| 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) | |||
| 176827 | 176827 | 190739 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 168 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010536.509219999 | 2107598.9835599996 | 37.7676593592282 | -122.406826950508 | (37.7676593592282, -122.406826950508) | |||
| 176464 | 176464 | 37964 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 422 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 6 | Permit Number 40195 | 6013476.642440001 | 2105094.41315 | 37.760946434546 | -122.396481747729 | (37.760946434546, -122.396481747729) | |
| 176414 | 176414 | 248003 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 428 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009956.29023 | 2098510.13636 | 37.7426709335279 | -122.40819277067699 | (37.7426709335279, -122.408192770677) | |||
| 176056 | 176056 | 228529 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1718 Bryant St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6009444.29412 | 2106686.02886 | 37.7650914215521 | -122.41054032498 | (37.7650914215521, -122.41054032498) | |||
| 175875 | 175875 | 226809 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 85 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003890.70666 | 2106665.10208 | 37.7647210474575 | -122.42974732669201 | (37.7647210474575, -122.429747326692) | |||
| 175571 | 175571 | 229878 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 402 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003817.08439 | 2100142.49851 | 37.746807351775 | -122.429536759424 | (37.746807351775, -122.429536759424) | |||
| 175495 | 175495 | 229865 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 539 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004844.26448 | 2110392.80621 | 37.7750103735616 | -122.426714698547 | (37.7750103735616, -122.426714698547) | |||
| 175116 | 175116 | 226306 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 92 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006186.62899 | 2097537.37358 | 37.7397881459032 | -122.421158135656 | (37.7397881459032, -122.421158135656) | |||
| 174926 | 174926 | 40804 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 585 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 41753 | 6013297.80731 | 2104343.61694 | 37.7588749586426 | -122.397047620054 | (37.7588749586426, -122.397047620054) | |||
| 174815 | 174815 | 78494 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2131 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 5 | 6012056.35315 | 2102319.0062700002 | 37.753246636133206 | -122.401198904113 | (37.7532466361332, -122.401198904113) | ||
| 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) | |||
| 174782 | 174782 | 229840 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3732 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005421.91572 | 2104323.47522 | 37.7583780804987 | -122.42428471508002 | (37.7583780804987, -122.42428471508) | |||
| 174734 | 174734 | 78725 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1300 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53574 | 6011951.3466300005 | 2102291.29231 | 37.753164680908206 | -122.401560092537 | (37.7531646809082, -122.401560092537) | |
| 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) | |||
| 174365 | 174365 | 226443 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3190 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008436.7771 | 2101566.08648 | 37.7509766915292 | -122.413662926703 | (37.7509766915292, -122.413662926703) | |||
| 174234 | 174234 | 228525 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 405 Florida St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009242.66431 | 2106282.23281 | 37.763971384304206 | -122.411209189472 | (37.7639713843042, -122.411209189472) | |||
| 173875 | 173875 | 228528 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1718 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6009443.5955 | 2106700.35684 | 37.7651307237316 | -122.410543753197 | (37.7651307237316, -122.410543753197) | |||
| 173677 | 173677 | 229831 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1216 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010281.08298 | 2102019.10674 | 37.7523239784704 | -122.407317038764 | (37.7523239784704, -122.407317038764) | |||
| 173236 | 173236 | 226336 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 25 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006679.39058 | 2103618.84473 | 37.7565142526416 | -122.41988580180201 | (37.7565142526416, -122.419885801802) | |||
| 173177 | 173177 | 229854 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 318 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005450.52958 | 2101809.91595 | 37.7514780473814 | -122.424007011614 | (37.7514780473814, -122.424007011614) | |||
| 172687 | 172687 | 226453 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3070 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008553.18177 | 2102742.64498 | 37.754213792241 | -122.41334358196 | (37.754213792241, -122.41334358196) | |||
| 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) | |||
| 172350 | 172350 | 229891 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008240.95046 | 2099813.7494799998 | 37.7461541678773 | -122.41421615095301 | (37.7461541678773, -122.414216150953) | |||
| 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) | |||
| 172269 | 172269 | 57319 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2719 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 2 | Permit Number 16144 | 5999557.8231 | 2113954.6853 | 37.784490078245604 | -122.44525772561501 | (37.7844900782456, -122.445257725615) | ||
| 172206 | 172206 | 226451 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3070 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008441.9337 | 2102736.37343 | 37.7541903253234 | -122.41372786314501 | (37.7541903253234, -122.413727863145) | |||
| 171915 | 171915 | 226448 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 990 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008365.48905 | 2102731.18987 | 37.75417179929121 | -122.413991861854 | (37.7541717992912, -122.413991861854) | |||
| 171875 | 171875 | 226791 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 43 Yukon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000246.5901 | 2104825.81574 | 37.759463795150104 | -122.442219288501 | (37.7594637951501, -122.442219288501) | |||
| 171644 | 171644 | 226410 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 340 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007045.3382 | 2096649.7231400001 | 37.7373992263821 | -122.41812616129499 | (37.7373992263821, -122.418126161295) | |||
| 171101 | 171101 | 229764 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011452.97986 | 2102350.02958 | 37.753298139414 | -122.403287685686 | (37.753298139414, -122.403287685686) |
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");