Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 120498 | 120498 | 93977 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 75 Loraine Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | Tree 2 on Anza. | 5996139.989030001 | 2112289.25125 | 37.7797215523196 | -122.45696168713002 | (37.7797215523196, -122.45696168713) | ||
| 112467 | 112467 | 54234 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1270 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2010 12:00:00 AM | Permit Number 9974 | 5995196.04681137 | 2106906.46154553 | 37.7648875762272 | -122.45983715274201 | (37.7648875762272, -122.459837152742) | ||
| 55798 | 55798 | 54057 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 874 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1972 12:00:00 AM | 8 | Permit Number 9779 | 5985134.071 | 2109910.10647 | 37.772550944555704 | -122.49485993091601 | (37.7725509445557, -122.494859930916) | ||
| 186476 | 186476 | 54020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 862 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1972 12:00:00 AM | 13 | Permit Number 9739 | 5985131.43408 | 2109993.46709 | 37.7727796747305 | -122.49487519957701 | (37.7727796747305, -122.494875199577) | ||
| 5189 | 5189 | 50319 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 207 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Permit Number 780459 | 5994858.57459 | 2113511.06459 | 37.7830026560888 | -122.461483229537 | (37.7830026560888, -122.461483229537) | ||
| 1681 | 1681 | 246983 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 779954 | 6004884.234759999 | 2101078.02552 | 37.7494364577399 | -122.42591323621201 | (37.7494364577399, -122.425913236212) | ||
| 1684 | 1684 | 236727 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1616 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | Permit Number 779934 | 6002562.04117 | 2100731.79845 | 37.7483542900352 | -122.43391868899201 | (37.7483542900352, -122.433918688992) | ||
| 407 | 407 | 248462 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | Permit Number 779787 | 5997458.097999999 | 2107812.3026 | 37.767504613553 | -122.45207869525 | (37.767504613553, -122.45207869525) | ||
| 1001 | 1001 | 238568 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1300 Noe St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779731 | 6003218.5106 | 2100626.90187 | 37.7481035005842 | -122.431641146931 | (37.7481035005842, -122.431641146931) | |
| 2396 | 2396 | 135722 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2498X Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | Permit Number 779691 | 6001734.0 | 2116823.0 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | ||
| 2420 | 2420 | 135721 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2498X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | Permit Number 779691 | 6001734.0 | 2116823.0 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | ||
| 678 | 678 | 237516 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1004 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779660 | 6003758.05774 | 2102389.1689299997 | 37.752972841143 | -122.429901097271 | (37.752972841143, -122.429901097271) | |
| 1884 | 1884 | 236583 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 607 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1994 12:00:00 AM | 5 | Width 4ft | Permit Number 779645 | 6009295.1552099995 | 2105340.17803 | 37.7613876608276 | -122.41096109620001 | (37.7613876608276, -122.4109610962) | |
| 1896 | 1896 | 236582 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 607 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | Permit Number 779645 | 6009292.7773400005 | 2105398.5203400003 | 37.7615477221736 | -122.410973441191 | (37.7615477221736, -122.410973441191) | ||
| 10051 | 10051 | 122896 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 263 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2017 12:00:00 AM | 3 | Permit Number 779289 | 6004832.0 | 2098951.0 | 37.7435931826557 | -122.42594247475901 | (37.7435931826557, -122.425942474759) | ||
| 10053 | 10053 | 62845 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 263 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2017 12:00:00 AM | 3 | Permit Number 779289 | 6004872.17430855 | 2098981.93904651 | 37.7436804045703 | -122.425805763528 | (37.7436804045703, -122.425805763528) | ||
| 10056 | 10056 | 122897 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 263 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2017 12:00:00 AM | 3 | Permit Number 779289 | 6004872.17430855 | 2098981.93904651 | 37.7436804045703 | -122.425805763528 | (37.7436804045703, -122.425805763528) | ||
| 9798 | 9798 | 32469 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 124 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779287 | 6000593.0 | 2105649.0 | 37.7617437934708 | -122.441080293978 | (37.7617437934708, -122.441080293978) | |
| 11218 | 11218 | 68392 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 240 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779249 | 6001623.41455 | 2093933.0441299998 | 37.7296331848184 | -122.43667784142099 | (37.7296331848184, -122.436677841421) |
| 7637 | 7637 | 36881 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2515 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002658.18112 | 2116991.83839 | 37.7930058086339 | -122.434748819925 | (37.7930058086339, -122.434748819925) | |
| 115900 | 115900 | 121400 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3998X 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779042 | 6003912.0 | 2101337.0 | 37.750092548464295 | -122.429293713772 | (37.7500925484643, -122.429293713772) | |
| 119077 | 119077 | 121401 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3998X 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779042 | 6003912.0 | 2101337.0 | 37.750092548464295 | -122.429293713772 | (37.7500925484643, -122.429293713772) | |
| 13011 | 13011 | 121633 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 715 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778948 | 6002248.64047 | 2088586.4317299998 | 37.7149880967002 | -122.43413431136001 | (37.7149880967002, -122.43413431136) | |
| 233 | 233 | 121240 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2016 12:00:00 AM | 3 | 3x5 | Permit Number 778926 | 5996501.4108 | 2113948.5087 | 37.7842981813685 | -122.45583135787399 | (37.7842981813685, -122.455831357874) | |
| 8304 | 8304 | 121239 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2016 12:00:00 AM | 3 | 3x5 | Permit Number 778926 | 5996501.0724 | 2113967.4603 | 37.7843501979957 | -122.455833899065 | (37.7843501979957, -122.455833899065) | |
| 7584 | 7584 | 38094 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2624 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 6 | Permit Number 778879 | 5999853.7645 | 2114048.6642 | 37.7847650081627 | -122.444240628643 | (37.7847650081627, -122.444240628643) | |
| 17119 | 17119 | 32210 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 85 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2016 12:00:00 AM | 3 | 3x6 | Permit Number 778854 | 6009682.7318 | 2099892.2355400003 | 37.746450553849705 | -122.40923616951599 | (37.7464505538497, -122.409236169516) | |
| 18542 | 18542 | 31283 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2574 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 778680 | 5991125.83447 | 2097900.24985 | 37.7399239615173 | -122.47325794369199 | (37.7399239615173, -122.473257943692) | |
| 80808 | 80808 | 64255 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 224 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1988 12:00:00 AM | 8 | Permit Number 778662 | 6004470.35805114 | 2098718.34053249 | 37.742933908305105 | -122.427176375442 | (37.7429339083051, -122.427176375442) | |
| 78539 | 78539 | 37251 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3956 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2016 12:00:00 AM | 3 | Permit Number 778657 | 6003965.79227695 | 2104246.29716673 | 37.7580838387743 | -122.42931513024999 | (37.7580838387743, -122.42931513025) | |
| 6107 | 6107 | 110275 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2612 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2016 12:00:00 AM | 3 | Permit Number 778382 | 6001183.56283 | 2117454.33561 | 37.794191876798 | -122.43988424377 | (37.794191876798, -122.43988424377) | ||
| 8328 | 8328 | 49474 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2612 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2003 12:00:00 AM | 3 | Permit Number 778382 | 6001188.38101 | 2117426.72551 | 37.7941163409457 | -122.43986559183399 | (37.7941163409457, -122.439865591834) | ||
| 100395 | 100395 | 39082 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3700 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/2016 12:00:00 AM | 3 | Permit Number 778242 | 6005630.70572311 | 2104338.6748817 | 37.758431602547496 | -122.42356370666201 | (37.7584316025475, -122.423563706662) | |
| 7207 | 7207 | 116159 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2660 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x5 | Permit Number 777886 | 6000321.54837 | 2117859.43879 | 37.795255076905704 | -122.442896004055 | (37.7952550769057, -122.442896004055) | |
| 100318 | 100318 | 32773 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 555 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2016 12:00:00 AM | Permit Number 777166 | 6000581.70628279 | 2110842.47785635 | 37.7760031430575 | -122.44149204508301 | (37.7760031430575, -122.441492045083) | ||
| 128279 | 128279 | 32772 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 555 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2016 12:00:00 AM | Permit Number 777166 | 6000581.70628279 | 2110842.47785635 | 37.7760031430575 | -122.44149204508301 | (37.7760031430575, -122.441492045083) | ||
| 70857 | 70857 | 114492 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 322 Ritch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2016 12:00:00 AM | 1 | 3x3 | Permit Number 777002 | 6014200.75816 | 2111763.05938 | 37.7792973266569 | -122.394444280578 | (37.7792973266569, -122.394444280578) | |
| 14659 | 14659 | 117454 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 236 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776408 | 6011523.8482099995 | 2111775.6168299997 | 37.7791826325214 | -122.403705761636 | (37.7791826325214, -122.403705761636) | |
| 31401 | 31401 | 68521 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 708 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/2015 12:00:00 AM | 7 | Permit Number 775425 | 5995373.47149 | 2110684.12761 | 37.775270261614104 | -122.45949710563801 | (37.7752702616141, -122.459497105638) | |
| 3513 | 3513 | 247938 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 29 Joy St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | |||
| 113861 | 113861 | 69479 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1875 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/2015 12:00:00 AM | 3 | Permit Number 775176 | 5993735.88293516 | 2102744.9511731 | 37.753377067666 | -122.464585247952 | (37.753377067666, -122.464585247952) | |
| 144064 | 144064 | 108205 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1192 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2014 12:00:00 AM | 3 | Permit Number 774208 | 6000914.97169 | 2109351.778 | 37.7719290371123 | -122.440232269589 | (37.7719290371123, -122.440232269589) | ||
| 20911 | 20911 | 50946 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1134 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2014 12:00:00 AM | 3 | Permit Number 773916 | 6007565.24376916 | 2118876.40998362 | 37.7984577381814 | -122.417903725033 | (37.7984577381814, -122.417903725033) | ||
| 12580 | 12580 | 108559 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 247 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773718 | 6001785.96966 | 2094072.85918 | 37.7300263216596 | -122.43612587350701 | (37.7300263216596, -122.436125873507) |
| 166287 | 166287 | 55604 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 658 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1973 12:00:00 AM | 1 | Permit Number 773340 | 5982601.78539 | 2111293.4380900003 | 37.7762006139918 | -122.50372168450501 | (37.7762006139918, -122.503721684505) | ||
| 128628 | 128628 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 1150 Lombard St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.42057600387301 | (37.8027004912885, -122.420576003873) | ||
| 7045 | 7045 | 117250 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 2474 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773044 | 6001780.62325 | 2117368.05955 | 37.7939889537763 | -122.437812170719 | (37.7939889537763, -122.437812170719) | |
| 145993 | 145993 | 106859 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 946 RHODE ISLAND ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 14 | 3x3 | Permit Number 773008 | 6011839.2 | 2104029.4 | 37.7579308843014 | -122.402070102772 | (37.7579308843014, -122.402070102772) | ||
| 116537 | 116537 | 108944 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 105 Richland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2015 12:00:00 AM | 3 | 4x4 | Permit Number 772521 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | |
| 120119 | 120119 | 46366 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 105 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2015 12:00:00 AM | 3 | 4x4 | Permit Number 772521 | 6005231.58018962 | 2096222.89831587 | 37.7361250059804 | -122.42436682508301 | (37.7361250059804, -122.424366825083) | |
| 117223 | 117223 | 61601 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 41 Temescal Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1984 12:00:00 AM | Permit Number 771041 | 5997430.33539748 | 2111463.9976056 | 37.7775296345883 | -122.452438269997 | (37.7775296345883, -122.452438269997) | ||
| 90303 | 90303 | 103621 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3982 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2013 12:00:00 AM | 12 | 3x3 | Permit Number 771038 | 5995737.809859999 | 2114868.57006 | 37.7867805691894 | -122.458539756662 | (37.7867805691894, -122.458539756662) | |
| 6090 | 6090 | 105252 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1875 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770851 | 6004061.8803 | 2118683.0933 | 37.7977291534815 | -122.43001264475201 | (37.7977291534815, -122.430012644752) | ||||
| 99972 | 99972 | 33470 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 106 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 770772 | 6006658.5962402 | 2099060.66654687 | 37.743997362867105 | -122.419634320147 | (37.7439973628671, -122.419634320147) | |||
| 166083 | 166083 | 105287 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2567 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 770757 | 6000732.18991 | 2118218.3862900003 | 37.796264055100295 | -122.441500892961 | (37.7962640551003, -122.441500892961) | ||
| 6855 | 6855 | 30870 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1922 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2013 12:00:00 AM | 22 | 3x3 | Permit Number 770521 | 6001989.3306 | 2115172.0478 | 37.787971137606895 | -122.436932736614 | (37.7879711376069, -122.436932736614) | |
| 77950 | 77950 | 65077 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2472 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2016 12:00:00 AM | 1 | Permit Number 770324 | 6008829.8770174 | 2104068.83442406 | 37.7578707396144 | -122.41248043525499 | (37.7578707396144, -122.412480435255) | ||
| 12530 | 12530 | 51006 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1262 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 3 | 3x3 | Permit Number 770221 | 5987105.8451 | 2106709.4716 | 37.7638781152555 | -122.48780425862302 | (37.7638781152555, -122.487804258623) | |
| 61737 | 61737 | 106161 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 827 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770049 | 6006757.57528 | 2121490.3236599998 | 37.8055893943007 | -122.42088419136499 | (37.8055893943007, -122.420884191365) | |
| 31730 | 31730 | 33993 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2034 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2013 12:00:00 AM | 3 | Permit Number 769995 | 6001441.2983 | 2115588.3906099997 | 37.789083143910496 | -122.438858673106 | (37.7890831439105, -122.438858673106) | ||
| 87893 | 87893 | 41359 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100X Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769972 | 6013404.2023591 | 2111579.81317621 | 37.7787498613905 | -122.397187064886 | (37.7787498613905, -122.397187064886) | |
| 104017 | 104017 | 102628 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/2013 12:00:00 AM | 3x3 | Permit Number 769972 | 6013417.4 | 2111578.2 | 37.778746166691 | -122.397141295625 | (37.778746166691, -122.397141295625) | |
| 128122 | 128122 | 41358 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100X Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769972 | 6013404.2023591 | 2111579.81317621 | 37.7787498613905 | -122.397187064886 | (37.7787498613905, -122.397187064886) | |
| 138733 | 138733 | 41360 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 564 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2013 12:00:00 AM | Permit Number 769972 | 6013404.2023591 | 2111579.81317621 | 37.7787498613905 | -122.397187064886 | (37.7787498613905, -122.397187064886) | |||
| 150573 | 150573 | 38787 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 564 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/2013 12:00:00 AM | 3 | Permit Number 769972 | 6013384.96932 | 2111589.18475 | 37.7787745228569 | -122.397254257292 | (37.7787745228569, -122.397254257292) | |
| 105795 | 105795 | 102986 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1459 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2013 12:00:00 AM | 3x3 | Permit Number 769945 | 5996811.8 | 2106244.7 | 37.763163336042794 | -122.45420090344 | (37.7631633360428, -122.45420090344) | ||
| 156864 | 156864 | 102047 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2853 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 1x1 | Permit Number 769645 | 5999920.96714 | 2117404.7453400004 | 37.7939837628837 | -122.444249383927 | (37.7939837628837, -122.444249383927) | ||
| 157570 | 157570 | 102045 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2853 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 1x1 | Permit Number 769645 | 5999896.35932 | 2117404.6933 | 37.7939822160532 | -122.444334525426 | (37.7939822160532, -122.444334525426) | ||
| 134912 | 134912 | 95603 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 345 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769429 | 5993376.0228699995 | 2113174.3502 | 37.7819926868669 | -122.466587723775 | (37.7819926868669, -122.466587723775) | |
| 171197 | 171197 | 95606 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 345 08th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769429 | 5993379.4788 | 2113094.52593 | 37.7817737105334 | -122.466569964084 | (37.7817737105334, -122.466569964084) | |
| 138866 | 138866 | 101623 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 80 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/2012 12:00:00 AM | 4x4 | Permit Number 769409 | 6000945.5 | 2101263.6 | 37.749722620490395 | -122.43954675389901 | (37.7497226204904, -122.439546753899) | |
| 59895 | 59895 | 66162 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 198x Venus St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2012 12:00:00 AM | 1 | 2x2 | Permit Number 769335 | 6012793.61205 | 2093996.0268 | 37.7304345958639 | -122.39806545206801 | (37.7304345958639, -122.398065452068) |
| 123419 | 123419 | 97459 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 198x Venus St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2012 12:00:00 AM | 7 | 3x3 | Permit Number 769335 | 6012779.459869999 | 2093933.7450599999 | 37.7302627947816 | -122.398110010771 | (37.7302627947816, -122.398110010771) | |
| 149499 | 149499 | 98173 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2061 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769212 | 5999384.05181 | 2115955.03644 | 37.7899725985939 | -122.446002837966 | (37.7899725985939, -122.446002837966) | |
| 61088 | 61088 | 100349 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 551 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769104 | 6002969.9885599995 | 2090393.63163 | 37.7199911835241 | -122.431769984714 | (37.7199911835241, -122.431769984714) | |
| 24266 | 24266 | 98663 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 388 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769043 | 6013484.27433 | 2110492.1123900004 | 37.7757677394235 | -122.39683378557699 | (37.7757677394235, -122.396833785577) | |
| 56257 | 56257 | 98662 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 388 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769043 | 6013504.77165 | 2110513.20608 | 37.775826798791 | -122.396764358806 | (37.775826798791, -122.396764358806) | |
| 184105 | 184105 | 98664 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 388 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769043 | 6013470.34035 | 2110479.34444 | 37.7757319059416 | -122.39688109169902 | (37.7757319059416, -122.396881091699) | |
| 75059 | 75059 | 99870 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2244 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768957 | 6002355.52291 | 2116016.0981900003 | 37.7903094900332 | -122.435726190525 | (37.7903094900332, -122.435726190525) | |
| 151306 | 151306 | 81701 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 851 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 4 | Permit Number 768903 | 6015512.02282 | 2105063.44662 | 37.760974466422795 | -122.389440035426 | (37.7609744664228, -122.389440035426) | |
| 162884 | 162884 | 81682 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 851 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | Permit Number 768903 | 6015510.18333 | 2105095.74005 | 37.7610630352539 | -122.389448652757 | (37.7610630352539, -122.389448652757) | |
| 41559 | 41559 | 98163 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2810 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2012 12:00:00 AM | 3 | 5x6 | Permit Number 768567 | 6001207.65142 | 2115957.84021 | 37.7900842611176 | -122.439693556909 | (37.7900842611176, -122.439693556909) | |
| 80392 | 80392 | 98149 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 850 Rockdale Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | |||
| 94269 | 94269 | 98150 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 850 Rockdale Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | |||
| 5965 | 5965 | 32283 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2242 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768378 | 6002362.300419999 | 2115970.86289 | 37.7901856704892 | -122.435699503149 | (37.7901856704892, -122.435699503149) | |
| 68453 | 68453 | 97807 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1440 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768317 | 6006742.70153 | 2118062.30449 | 37.796176083401896 | -122.420692156425 | (37.7961760834019, -122.420692156425) | |
| 169701 | 169701 | 97808 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1440 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768317 | 6006718.45955 | 2118058.39417 | 37.7961639803297 | -122.42077576099399 | (37.7961639803297, -122.420775760994) | |
| 29072 | 29072 | 97763 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 115 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2011 12:00:00 AM | 1 | Permit Number 768298 | 5996511.5635 | 2113681.1555 | 37.783564683267 | -122.455776900676 | (37.783564683267, -122.455776900676) | ||
| 79475 | 79475 | 42430 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100@ Detroit Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2011 12:00:00 AM | 3x3 | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 115710 | 115710 | 42429 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100@ Detroit Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2011 12:00:00 AM | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 142249 | 142249 | 42109 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100@ Detroit Judson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2011 12:00:00 AM | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 58902 | 58902 | 97276 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 550 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | 1 | Permit Number 768247 | 5987533.098119999 | 2112208.35101 | 37.7790014167653 | -122.486730350058 | (37.7790014167653, -122.486730350058) | ||
| 172889 | 172889 | 50135 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 237 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2011 12:00:00 AM | 2 | Permit Number 768238 | 6009283.11619 | 2094931.1858299999 | 37.732806193548896 | -122.410267786353 | (37.7328061935489, -122.410267786353) | ||
| 75396 | 75396 | 32949 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 166 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 4 | Permit Number 768206 | 6013131.82297 | 2106278.26567 | 37.7641778371582 | -122.397757375804 | (37.7641778371582, -122.397757375804) | |
| 68302 | 68302 | 64159 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 730 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/2011 12:00:00 AM | 2 | Permit Number 768106 | 5991971.46545 | 2110409.84636 | 37.7743209603675 | -122.471245324134 | (37.7743209603675, -122.471245324134) | |
| 109101 | 109101 | 98253 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 153 Clipper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 768037 | 6004170.0 | 2100997.0 | 37.7491735904315 | -122.428377304767 | (37.7491735904315, -122.428377304767) | ||
| 123568 | 123568 | 96765 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 184 Edgewood Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/12/2011 12:00:00 AM | Permit Number 767998 | 5996632.0 | 2105999.0 | 37.76247839448661 | -122.45480501488301 | (37.7624783944866, -122.454805014883) | |||
| 68750 | 68750 | 96491 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2018 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | 2 | Permit Number 767862 | 5986347.5106 | 2101481.4472 | 37.7494791308709 | -122.490042511756 | (37.7494791308709, -122.490042511756) | ||
| 96477 | 96477 | 53295 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4109 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767838 | 6002436.35323734 | 2102355.70064678 | 37.7528060072833 | -122.434469405268 | (37.7528060072833, -122.434469405268) | |
| 81180 | 81180 | 96346 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 673 Brussels St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2012 12:00:00 AM | 3x3 | Permit Number 767711 | 6010983.0 | 2091637.0 | 37.7238561870461 | -122.404159067143 | (37.7238561870461, -122.404159067143) |
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");