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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1131 | 1131 | 251458 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | 3x3 | |||||||
| 5203 | 5203 | 46584 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2790 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2002 12:00:00 AM | Permit Number 44712 | ||||||||
| 9458 | 9458 | 34058 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37960 | |||||||||
| 26647 | 26647 | 96093 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 116 Drake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2011 12:00:00 AM | 3x3 | Permit Number 56922 | 6001481.0 | 2086737.0 | 37.7098663684689 | -122.436655293893 | (37.7098663684689, -122.436655293893) | ||
| 127005 | 127005 | 96092 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 116 Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2011 12:00:00 AM | 3x3 | Permit Number 56922 | 6001481.0 | 2086737.0 | 37.7098663684689 | -122.436655293893 | (37.7098663684689, -122.436655293893) | ||
| 141083 | 141083 | 96091 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 116 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2011 12:00:00 AM | 3x3 | Permit Number 56922 | 6001481.0 | 2086737.0 | 37.7098663684689 | -122.436655293893 | (37.7098663684689, -122.436655293893) | ||
| 119702 | 119702 | 111096 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 67 SAINT CHARLES AVE | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 15 | 5992079.0 | 2088073.0 | 37.712995910736204 | -122.46924723728901 | (37.7129959107362, -122.469247237289) | |||
| 71727 | 71727 | 176584 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 263 Naglee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5997986.0041 | 2088216.93337 | 37.7137306897928 | -122.44884112532301 | (37.7137306897928, -122.448841125323) | |||
| 53861 | 53861 | 176586 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 205 Seneca Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 5999824.12192 | 2090353.8387799999 | 37.7197030929005 | -122.44264127649099 | (37.7197030929005, -122.442641276491) | |||
| 52880 | 52880 | 176585 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 205 Seneca Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5999821.59853 | 2090369.86807 | 37.719746961831 | -122.442651149242 | (37.719746961831, -122.442651149242) | |||
| 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) | |||
| 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) | |
| 155165 | 155165 | 219233 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 387 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994164.56547 | 2092392.43636 | 37.724976343277795 | -122.462351978558 | (37.7249763432778, -122.462351978558) | |||
| 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) | |||
| 104987 | 104987 | 46610 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 90 Stoneybrook Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2002 12:00:00 AM | Permit Number 44733 | 6005754.19470514 | 2093788.76212956 | 37.7294709047894 | -122.42238703292601 | (37.7294709047894, -122.422387032926) | |||
| 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) | |||
| 152017 | 152017 | 176588 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 151 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004383.65032 | 2094057.6355400002 | 37.73013176266 | -122.42714428398399 | (37.73013176266, -122.427144283984) | |||
| 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) | |||
| 63640 | 63640 | 38604 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1556 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50557 | 6015379.8321 | 2094216.5354 | 37.7311837737961 | -122.38913983494801 | (37.7311837737961, -122.389139834948) | |
| 159141 | 159141 | 38602 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1556 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50557 | 6015367.191000001 | 2094226.9780000001 | 37.731211746308105 | -122.389184266735 | (37.7312117463081, -122.389184266735) | |
| 150318 | 150318 | 38603 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1556 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50557 | 6015358.9468 | 2094230.8253 | 37.7312218531881 | -122.38921303719499 | (37.7312218531881, -122.389213037195) | |
| 67198 | 67198 | 38605 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1556 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50557 | 6015347.9546 | 2094242.9168 | 37.731254444632796 | -122.38925188353501 | (37.7312544446328, -122.389251883535) | |
| 152926 | 152926 | 190743 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 39 Latona St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 6ft | 6014419.07803 | 2094437.81167 | 37.731738047151296 | -122.392476830144 | (37.7317380471513, -122.392476830144) | |||
| 120515 | 120515 | 40005 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 911 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41258 | 6019178.20708985 | 2094459.30382263 | 37.7320602007089 | -122.376024856319 | (37.7320602007089, -122.376024856319) | ||
| 138131 | 138131 | 201517 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 911 Innes Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6019123.25931 | 2094488.31096 | 37.7321368236424 | -122.37621683574699 | (37.7321368236424, -122.376216835747) | |||
| 160223 | 160223 | 40004 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 911 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 2 | Permit Number 41258 | 6019111.21169 | 2094496.3329 | 37.7321581870346 | -122.376259043617 | (37.7321581870346, -122.376259043617) | |
| 137381 | 137381 | 43189 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 175 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 2 | Permit Number 42991 | 6009687.65103 | 2094852.37094 | 37.7326124525905 | -122.40886364246401 | (37.7326124525905, -122.408863642464) | |
| 74424 | 74424 | 226764 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 18 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004212.35359 | 2095476.2158400002 | 37.7340171774496 | -122.42783751920099 | (37.7340171774496, -122.427837519201) | |||
| 13611 | 13611 | 27142 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1775 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011388.172669999 | 2095338.5375299999 | 37.7340424699754 | -122.40301867507401 | (37.7340424699754, -122.403018675074) | |||
| 14097 | 14097 | 27140 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1775 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011410.17472 | 2095355.19259 | 37.7340894298873 | -122.40294377776002 | (37.7340894298873, -122.40294377776) | |||
| 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) | |||
| 163722 | 163722 | 190741 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1786 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014282.6032300005 | 2095390.34812 | 37.7343459381091 | -122.39301527674601 | (37.7343459381091, -122.393015276746) | |||
| 117159 | 117159 | 94883 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1786 Quesada Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53950 | 6014292.7 | 2095395.8 | 37.7343614687147 | -122.39298074998501 | (37.7343614687147, -122.392980749985) | ||
| 80413 | 80413 | 67919 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 18 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31630 | 6004275.26721169 | 2095614.00906402 | 37.734399085454996 | -122.427629821288 | (37.734399085455, -122.427629821288) | ||
| 84571 | 84571 | 66285 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31629 | 6004295.09294916 | 2095637.08175846 | 37.7344635592859 | -122.427562920462 | (37.7344635592859, -122.427562920462) | ||
| 90067 | 90067 | 40729 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 23 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1999 12:00:00 AM | Permit Number 41708 | 6007052.60593678 | 2095671.4040371003 | 37.734713386778495 | -122.41803169875901 | (37.7347133867785, -122.418031698759) | ||
| 98022 | 98022 | 117954 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 75 Bridgeview Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2016 12:00:00 AM | 3 | 2.5x3 | 6013772.990180001 | 2095538.9609400001 | 37.734725676752895 | -122.39478759166599 | (37.7347256767529, -122.394787591666) | |||
| 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) | |||
| 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) | |||
| 13316 | 13316 | 94652 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 463 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779226 | 6003847.0 | 2095961.0 | 37.735327609986 | -122.429135213798 | (37.735327609986, -122.429135213798) |
| 13609 | 13609 | 12227 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1551 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2000 12:00:00 AM | 6 | 3X3 | 6015788.0003 | 2095930.721 | 37.735913201034606 | -122.387848277235 | (37.7359132010346, -122.387848277235) | ||
| 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) | |||
| 27369 | 27369 | 69766 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 8 | 6014547.15395 | 2096165.5632900002 | 37.7364892123042 | -122.392154828809 | (37.7364892123042, -122.392154828809) | ||
| 82288 | 82288 | 35969 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 176 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39127 | 6006023.56999156 | 2096341.44627535 | 37.7364952030819 | -122.42163700697701 | (37.7364952030819, -122.421637006977) | ||
| 56810 | 56810 | 226363 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 178 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6006046.41496 | 2096344.0144900002 | 37.736503542996296 | -122.421558204449 | (37.7365035429963, -122.421558204449) | |||
| 155639 | 155639 | 226379 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 424 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008895.67252 | 2096317.34788 | 37.736590569490104 | -122.41170519075199 | (37.7365905694901, -122.411705190752) | |||
| 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) | |||
| 98391 | 98391 | 51473 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 511 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47785 | 6008227.06002157 | 2096462.73555684 | 37.7369522423723 | -122.414027160396 | (37.7369522423723, -122.414027160396) | ||
| 168226 | 168226 | 226409 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 340 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007041.57099 | 2096614.1671900002 | 37.7373013855609 | -122.41813666630101 | (37.7373013855609, -122.418136666301) | |||
| 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) | |||
| 103552 | 103552 | 117397 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 330X Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776356 | 6007069.63693 | 2096670.72705 | 37.7374582661153 | -122.418043637637 | (37.7374582661153, -122.418043637637) | ||
| 121515 | 121515 | 117396 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 330X Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776356 | 6007069.63693 | 2096670.72705 | 37.7374582661153 | -122.418043637637 | (37.7374582661153, -122.418043637637) | ||
| 131666 | 131666 | 190744 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2086 Quesada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6012709.58294 | 2096557.7365 | 37.737463838180496 | -122.398535643704 | (37.7374638381805, -122.398535643704) | ||||
| 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) | |||
| 135455 | 135455 | 226308 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 161 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007401.10475 | 2096768.5296099999 | 37.7377454608683 | -122.416904522239 | (37.7377454608683, -122.416904522239) | |||
| 26294 | 26294 | 226376 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 268 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004329.65759 | 2096832.9872 | 37.7377492002742 | -122.42752859039899 | (37.7377492002742, -122.427528590399) | |||
| 74219 | 74219 | 226309 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 161 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007378.4424 | 2096771.82308 | 37.737753229234 | -122.41698311040301 | (37.737753229234, -122.416983110403) | |||
| 99009 | 99009 | 35943 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 303 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2016 12:00:00 AM | 3 | Permit Number 39390 | 6007111.66828124 | 2096780.53419663 | 37.7377621378422 | -122.417906096842 | (37.7377621378422, -122.417906096842) | |
| 88570 | 88570 | 88284 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 270 Whitney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51280 | 6004294.4 | 2096874.5 | 37.7378611907196 | -122.427653449759 | (37.7378611907196, -122.427653449759) | |||
| 15907 | 15907 | 88471 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1525 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51425 | 6015740.82967 | 2096670.14534 | 37.7379408970519 | -122.388062950362 | (37.7379408970519, -122.388062950362) | |
| 137686 | 137686 | 226375 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 235 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004677.73219 | 2096935.7156099998 | 37.7380509507014 | -122.426332439909 | (37.7380509507014, -122.426332439909) | |||
| 160436 | 160436 | 88048 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1555 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51058 | 6015584.72865 | 2096785.6405200001 | 37.73824937351 | -122.388610732819 | (37.73824937351, -122.388610732819) | |
| 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) | |||
| 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) | |||
| 153521 | 153521 | 219234 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 273 Dalewood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995327.0897 | 2097229.7554099998 | 37.7383253194549 | -122.458683321089 | (37.7383253194549, -122.458683321089) | |||
| 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) | |||
| 89906 | 89906 | 40721 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 58 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1999 12:00:00 AM | Permit Number 41700 | 6009320.76573459 | 2097115.38530681 | 37.7388056449049 | -122.41029178429599 | (37.7388056449049, -122.410291784296) | ||
| 107952 | 107952 | 34378 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 192 Laidley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38129 | 6004119.49989193 | 2097245.26729923 | 37.7388693385577 | -122.428284582088 | (37.7388693385577, -122.428284582088) | ||
| 154055 | 154055 | 226823 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 192 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004115.91768 | 2097275.83468 | 37.738953066925895 | -122.42829914569201 | (37.7389530669259, -122.428299145692) | |||
| 157038 | 157038 | 226408 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 324 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006517.915030001 | 2097301.91264 | 37.739160293207995 | -122.419995981327 | (37.739160293208, -122.419995981327) | |||
| 108734 | 108734 | 36541 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3784 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39414 | 6008400.50795497 | 2097269.02278879 | 37.7391758711573 | -122.413484478256 | (37.7391758711573, -122.413484478256) | ||
| 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) | |||
| 581 | 581 | 240741 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007184.54991 | 2097351.72127 | 37.739334592605 | -122.41769458294901 | (37.739334592605, -122.417694582949) | |
| 85502 | 85502 | 36539 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3770 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39412 | 6008405.93467714 | 2097334.19751076 | 37.739355131371795 | -122.413470323165 | (37.7393551313718, -122.413470323165) | ||
| 578 | 578 | 239543 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Bennington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007186.362369999 | 2097372.9446900003 | 37.7393929694044 | -122.41768982014798 | (37.7393929694044, -122.417689820148) | |
| 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) | |||
| 603 | 603 | 239542 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Bennington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007187.05082 | 2097389.73315 | 37.739439105535105 | -122.41768862942101 | (37.7394391055351, -122.417688629421) | |
| 23793 | 23793 | 226377 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 267 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007909.30084 | 2097390.1768 | 37.739480940202 | -122.415191429754 | (37.739480940202, -122.415191429754) | |||
| 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) | |||
| 125040 | 125040 | 52402 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 92@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/2005 12:00:00 AM | Permit Number 48522 | 6006139.57045617 | 2097557.41563242 | 37.73984052387561 | -122.421322267329 | (37.7398405238756, -122.421322267329) | ||
| 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) | |||
| 94762 | 94762 | 43128 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 84 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | Permit Number 42946 | 6006098.21265371 | 2097579.74571646 | 37.73989950547 | -122.42146685090599 | (37.73989950547, -122.421466850906) | ||
| 139198 | 139198 | 34366 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1891 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38122 | 6004628.22720814 | 2097641.9206333 | 37.7399872310586 | -122.426553875593 | (37.7399872310586, -122.426553875593) | ||
| 25893 | 25893 | 226384 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 15 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007204.63358 | 2097592.3752900003 | 37.7399965053243 | -122.417642194748 | (37.7399965053243, -122.417642194748) | |||
| 28403 | 28403 | 226820 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1891 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004617.45608 | 2097657.55415 | 37.740029548214004 | -122.426592230667 | (37.740029548214, -122.426592230667) | |||
| 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) | |||
| 76353 | 76353 | 94663 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1883 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53800 | 6004614.0 | 2097695.0 | 37.7401321706185 | -122.42660684616101 | (37.7401321706185, -122.426606846161) | |
| 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) | |||
| 130158 | 130158 | 226407 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 59 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006002.53632 | 2097682.69863 | 37.740176796029296 | -122.421804971219 | (37.7401767960293, -122.421804971219) | |||
| 114886 | 114886 | 36511 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 15 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50549 | 6007227.68347498 | 2097723.04326722 | 37.7403565876102 | -122.417571756215 | (37.7403565876102, -122.417571756215) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 74959 | 74959 | 226390 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 304 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006633.7821 | 2097989.5025 | 37.741054788845204 | -122.41964413689101 | (37.7410547888452, -122.419644136891) | |||
| 75203 | 75203 | 226822 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 39 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004297.5525 | 2098038.31795 | 37.7410569481125 | -122.42772544836599 | (37.7410569481125, -122.427725448366) | |||
| 9759 | 9759 | 24293 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 302 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/03/2011 12:00:00 AM | 3 | 2x2 | 6006647.73618 | 2098006.46065 | 37.741102138158 | -122.41959709154101 | (37.741102138158, -122.419597091541) | ||
| 102883 | 102883 | 40466 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41551 | 6007432.501515401 | 2097996.59571862 | 37.741119224804294 | -122.41688295083799 | (37.7411192248043, -122.416882950838) | ||
| 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) | |||
| 92025 | 92025 | 28275 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 304 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/2016 12:00:00 AM | 6 | 2X3 | 6006647.725204401 | 2098034.3646343 | 37.7411787556411 | -122.419599108791 | (37.7411787556411, -122.419599108791) | ||
| 127365 | 127365 | 44068 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 304 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/02/2003 12:00:00 AM | Permit Number 43592 | 6006646.88740951 | 2098034.91768842 | 37.741180227012 | -122.41960204482099 | (37.741180227012, -122.419602044821) |
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");