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 | |||||||||
| 81308 | 81308 | 110460 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | 3x20 | Permit Number 775118 | 5987173.7 | 2114281.7 | 37.78467328365571 | -122.48812603128799 | (37.7846732836557, -122.488126031288) | |
| 100924 | 100924 | 110461 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | 3x20 | Permit Number 775118 | 5987173.7 | 2114281.7 | 37.78467328365571 | -122.48812603128799 | (37.7846732836557, -122.488126031288) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 4711 | 4711 | 41645 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 146 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2001 12:00:00 AM | 3 | 3x3 | Permit Number 42118 | 5997898.0776 | 2112825.6252 | 37.7812950956289 | -122.450918408743 | (37.7812950956289, -122.450918408743) |
| 136583 | 136583 | 229881 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 130 Belgrave Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997916.14381 | 2104919.64182 | 37.7595883251505 | -122.45028584571999 | (37.7595883251505, -122.45028584572) | |||
| 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) | |||
| 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) | |||
| 78078 | 78078 | 94188 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 456 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2014 12:00:00 AM | 10 | 3x4 | Permit Number 772961 | 5998552.0 | 2106546.0 | 37.7640902659836 | -122.448203856901 | (37.7640902659836, -122.448203856901) | |
| 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) | |||
| 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) | ||
| 161626 | 161626 | 226818 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 272 Corbett Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 5999639.14958 | 2105380.58985 | 37.7609524294432 | -122.44435997895599 | (37.7609524294432, -122.444359978956) | |||
| 63374 | 63374 | 226817 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4430 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999749.40261 | 2105767.64242 | 37.762021469725795 | -122.444006474335 | (37.7620214697258, -122.444006474335) | |||
| 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) | |||
| 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) | |||
| 155 | 155 | 251225 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Yukon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x2.5 | 6000238.0 | 2104757.0 | 37.7592743544717 | -122.442244057145 | (37.7592743544717, -122.442244057145) | ||||
| 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) | |||
| 82436 | 82436 | 55554 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 159 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50800 | 6000262.70357659 | 2104857.37596764 | 37.759551370106294 | -122.44216582584 | (37.7595513701063, -122.44216582584) | ||
| 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) | |||
| 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) | |
| 121758 | 121758 | 45811 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 71 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2001 12:00:00 AM | Permit Number 44439 | 6000723.05882095 | 2104884.41992047 | 37.759651851376795 | -122.440575632448 | (37.7596518513768, -122.440575632448) | |||
| 135152 | 135152 | 226806 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 190 Storrie St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 3ft | 6000773.9022 | 2105295.6973200003 | 37.7607840134024 | -122.440429287805 | (37.7607840134024, -122.440429287805) | |||
| 128651 | 128651 | 59724 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 706 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 19156 | 6001209.48230507 | 2102271.53927268 | 37.752505200797295 | -122.438706110204 | (37.7525052007973, -122.438706110204) | ||
| 123722 | 123722 | 226789 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4432 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001262.11488 | 2104680.78699 | 37.759123406241606 | -122.438696718674 | (37.7591234062416, -122.438696718674) | |||
| 165297 | 165297 | 226367 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 706 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6001215.62025 | 2102209.80088 | 37.752336031192705 | -122.43868046073601 | (37.7523360311927, -122.438680460736) | |||
| 163533 | 163533 | 226374 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4120 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001383.53668 | 2102929.36368 | 37.754321328688505 | -122.438151321247 | (37.7543213286885, -122.438151321247) | |||
| 169061 | 169061 | 226816 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4132 17th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6001458.2857800005 | 2105860.2549900003 | 37.7623730956507 | -122.438102756943 | (37.7623730956507, -122.438102756943) | |||
| 54064 | 54064 | 226815 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4132 17th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6001471.84267 | 2105861.76416 | 37.7623780104526 | -122.438055976903 | (37.7623780104526, -122.438055976903) | |||
| 103652 | 103652 | 64206 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4120 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2007 12:00:00 AM | Permit No. 49278 | 6001454.61421942 | 2102939.02028788 | 37.7543518855401 | -122.43790620920299 | (37.7543518855401, -122.437906209203) | |||
| 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) | |||
| 60031 | 60031 | 226364 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4365 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001531.187530001 | 2100555.7337599997 | 37.747812304611294 | -122.437470743076 | (37.7478123046113, -122.437470743076) | |||
| 126613 | 126613 | 105306 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4365 26th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2014 12:00:00 AM | 3x3 | Permit Number 771671 | 6001537.2 | 2100535.2 | 37.747756265607705 | -122.43744848210501 | (37.7477562656077, -122.437448482105) | |||
| 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) | |||
| 98478 | 98478 | 36911 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 416 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39557 | 6001782.24940233 | 2103410.78892741 | 37.755665874559604 | -122.436806934863 | (37.7556658745596, -122.436806934863) | ||
| 92794 | 92794 | 102177 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 267 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 5 | 6x9 | Permit Number 769769 | 6001804.7 | 2104316.3 | 37.758153465363996 | -122.436794111878 | (37.758153465364, -122.436794111878) |
| 2633 | 2633 | 108358 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250X Pixley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/17/2014 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002123.0245900005 | 2118966.98612 | 37.798398653541796 | -122.43674193970399 | (37.7983986535418, -122.436741939704) | |
| 170425 | 170425 | 226770 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 506 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001804.17577 | 2102825.14189 | 37.7540590746692 | -122.43668918726401 | (37.7540590746692, -122.436689187264) | |||
| 1083 | 1083 | 108357 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250X Pixley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/17/2014 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002140.21513 | 2118970.4470599997 | 37.7984091333207 | -122.436682703142 | (37.7984091333207, -122.436682703142) | |
| 91920 | 91920 | 36913 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 506 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39559 | 6001808.51272351 | 2102888.32664908 | 37.7542328113234 | -122.436678711571 | (37.7542328113234, -122.436678711571) | ||
| 81057 | 81057 | 36914 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 508 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 39560 | 6001809.10067712 | 2102876.63029352 | 37.7542007293515 | -122.436675841105 | (37.7542007293515, -122.436675841105) | ||
| 72376 | 72376 | 226769 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 508 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001809.15664 | 2102809.6039 | 37.7540166941382 | -122.4366708501 | (37.7540166941382, -122.4366708501) | |||
| 147318 | 147318 | 226768 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 508 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001810.12784 | 2102797.39865 | 37.7539832366425 | -122.436666617866 | (37.7539832366425, -122.436666617866) | |||
| 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) | ||
| 7958 | 7958 | 108356 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250X Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/17/2014 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002158.91155 | 2118972.60439 | 37.798416119273206 | -122.436618162405 | (37.7984161192732, -122.436618162405) | |
| 33217 | 33217 | 247662 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 108 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6001959.68947 | 2108344.83823 | 37.769223654362605 | -122.436546435187 | (37.7692236543626, -122.436546435187) | |||
| 93534 | 93534 | 50683 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 114 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | Permit Number 47255 | 6001960.98018226 | 2108347.90798031 | 37.7692321564841 | -122.436542190439 | (37.7692321564841, -122.436542190439) | |||
| 94481 | 94481 | 107509 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 240 PIXLEY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002182.3 | 2118985.3 | 37.7984523071777 | -122.436538140501 | (37.7984523071777, -122.436538140501) | ||||||
| 24375 | 24375 | 129099 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 240 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002192.1868900005 | 2118975.47765 | 37.79842589939221 | -122.43650322546499 | (37.7984258993922, -122.436503225465) | |||
| 80531 | 80531 | 83340 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4201 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52615 | 6002013.46643782 | 2105257.92812677 | 37.7607508108309 | -122.43613949146099 | (37.7607508108309, -122.436139491461) | |
| 144261 | 144261 | 74908 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4201 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52615 | 6002013.46643782 | 2105257.92812677 | 37.7607508108309 | -122.43613949146099 | (37.7607508108309, -122.436139491461) | |
| 105256 | 105256 | 114960 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1214 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2015 12:00:00 AM | Permit Number 770791 | 6001920.2 | 2100491.9 | 37.7476591410723 | -122.436120992025 | (37.7476591410723, -122.436120992025) | |||
| 80391 | 80391 | 37414 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 929 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39892 | 6001945.76118783 | 2101390.6122358004 | 37.7501282439333 | -122.436096904408 | (37.7501282439333, -122.436096904408) | ||
| 93170 | 93170 | 37415 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 935 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39893 | 6001946.57451683 | 2101373.82273034 | 37.750082190149996 | -122.436092890574 | (37.75008219015, -122.436092890574) | ||
| 54167 | 54167 | 226370 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 929 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001946.0113 | 2101316.44103 | 37.7499246016413 | -122.43609073251899 | (37.7499246016413, -122.436090732519) | |||
| 84233 | 84233 | 50586 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 941 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2003 12:00:00 AM | Permit Number 47201 | 6001947.38784558 | 2101357.03323011 | 37.7500361363805 | -122.436088876747 | (37.7500361363805, -122.436088876747) | |||
| 72874 | 72874 | 226805 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 73 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002033.709009999 | 2105453.8141799998 | 37.7612898163989 | -122.43608349926501 | (37.7612898163989, -122.436083499265) | |||
| 155399 | 155399 | 226369 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 935 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001947.50433 | 2101286.4879 | 37.7498424422864 | -122.436083426409 | (37.7498424422864, -122.436083426409) | |||
| 151613 | 151613 | 226366 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1220 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001939.37968 | 2100462.1573799998 | 37.7475785645179 | -122.436052541893 | (37.7475785645179, -122.436052541893) | |||
| 160383 | 160383 | 226365 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1214 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001939.894830001 | 2100487.05511 | 37.7476469570616 | -122.436052541887 | (37.7476469570616, -122.436052541887) | |||
| 112976 | 112976 | 108708 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1220 Diamond St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774630 | 6001943.854230001 | 2100537.23082 | 37.7477849526289 | -122.436042440417 | (37.7477849526289, -122.436042440417) | |
| 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) | |||
| 79276 | 79276 | 50560 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4175 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2003 12:00:00 AM | Permit Number 47183 | 6002030.50619515 | 2102333.72789299 | 37.7527226291178 | -122.435871324431 | (37.7527226291178, -122.435871324431) | |||
| 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) | |||
| 108696 | 108696 | 226792 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 379 Collingwood St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6002133.75148 | 2103664.46985 | 37.7563823922541 | -122.435609479191 | (37.7563823922541, -122.435609479191) | |||
| 155759 | 155759 | 226368 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4252 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6002219.8956 | 2101222.17774 | 37.7496813332396 | -122.43513688726001 | (37.7496813332396, -122.43513688726) | |||
| 98500 | 98500 | 67792 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4252 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52966 | 6002229.57555078 | 2101227.41307609 | 37.7496962578989 | -122.435103788069 | (37.7496962578989, -122.435103788069) | |
| 119070 | 119070 | 58905 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 655 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | Permit Number 769760 | 6002418.15212939 | 2104399.4018003996 | 37.7584164881822 | -122.43467847442601 | (37.7584164881822, -122.434678474426) | ||
| 132957 | 132957 | 226796 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 659 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002418.29753 | 2104403.0961700003 | 37.7584266402862 | -122.43467823573799 | (37.7584266402862, -122.434678235738) | |||
| 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) | |||
| 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) | |||
| 70491 | 70491 | 226372 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4222 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002353.94285 | 2100643.26716 | 37.748099392475 | -122.43463195751801 | (37.748099392475, -122.434631957518) | |||
| 83699 | 83699 | 102167 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 677 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769761 | 6002448.6 | 2104297.1 | 37.7581373205651 | -122.4345658575 | (37.7581373205651, -122.4345658575) |
| 120817 | 120817 | 41339 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 791 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2000 12:00:00 AM | 8 | Permit Number 41992 | 6002462.02491535 | 2103606.38445454 | 37.756241543596104 | -122.434470043403 | (37.7562415435961, -122.434470043403) | ||
| 58331 | 58331 | 226802 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4187 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002513.17222 | 2104117.5372099997 | 37.7576479497004 | -122.434329701679 | (37.7576479497004, -122.434329701679) | |||
| 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) | |||
| 165158 | 165158 | 226371 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 626 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002431.857369999 | 2098894.2222599997 | 37.743301348371794 | -122.43423751036 | (37.7433013483718, -122.43423751036) | |||
| 86849 | 86849 | 37319 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 584 Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39833 | 6002558.90773127 | 2103291.37845472 | 37.7553821115396 | -122.43411247211901 | (37.7553821115396, -122.434112472119) | ||
| 92858 | 92858 | 37318 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 584 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39833 | 6002558.90773127 | 2103291.37845472 | 37.7553821115396 | -122.43411247211901 | (37.7553821115396, -122.434112472119) | ||
| 92205 | 92205 | 105745 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 418 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 2 | 4x4 | Permit Number 771651 | 6002705.0 | 2109971.0 | 37.7737310181147 | -122.43408471033301 | (37.7737310181147, -122.434084710333) | |
| 114710 | 114710 | 105743 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 410 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 4x4 | Permit Number 771648 | 6002709.0 | 2109944.0 | 37.773657109816206 | -122.434068943261 | (37.7736571098162, -122.434068943261) | ||
| 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) | |||
| 147455 | 147455 | 226787 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 166 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002663.06838 | 2104932.4361099997 | 37.7598939732341 | -122.43386954555001 | (37.7598939732341, -122.43386954555) | |||
| 91211 | 91211 | 84806 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 545 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53985 | 6002776.0 | 2103844.0 | 37.7569117968289 | -122.433401190257 | (37.7569117968289, -122.433401190257) | |
| 113636 | 113636 | 226801 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 545 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002785.55177 | 2103842.18407 | 37.7569073526207 | -122.433368026935 | (37.7569073526207, -122.433368026935) | |||
| 65147 | 65147 | 100089 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2034 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003188.20593 | 2118955.0281 | 37.7984262977915 | -122.43305523462601 | (37.7984262977915, -122.433055234626) | |||
| 162761 | 162761 | 100088 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2034 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6003201.40964 | 2118956.6592900003 | 37.7984315255609 | -122.43300966237301 | (37.7984315255609, -122.433009662373) | |||
| 129193 | 129193 | 50614 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 474 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | Permit Number 47214 | 6002793.31412073 | 2098675.69251057 | 37.742721825510294 | -122.43297207844401 | (37.7427218255103, -122.432972078444) | |||
| 157180 | 157180 | 226773 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4030 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002932.26121 | 2102431.29378 | 37.753041705810396 | -122.43275986580099 | (37.7530417058104, -122.432759865801) | |||
| 9605 | 9605 | 17889 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2231 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2000 12:00:00 AM | 8 | 3x3 | 6003230.4792 | 2115158.6176 | 37.7880047264698 | -122.432637629177 | (37.7880047264698, -122.432637629177) | ||
| 28348 | 28348 | 226784 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 549 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003023.04842 | 2105091.7124400004 | 37.7603517290589 | -122.432635928409 | (37.7603517290589, -122.432635928409) | |||
| 134711 | 134711 | 229867 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 474 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002892.54695 | 2098627.83365 | 37.7425960442853 | -122.432625542146 | (37.7425960442853, -122.432625542146) | |||
| 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) |
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");