Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109809 | 109809 | 67286 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 Valmar Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | Permit Number 30762 | 6005235.61143387 | 2092487.85869901 | 37.7258696432117 | -122.42408735009501 | (37.7258696432117, -122.424087350095) | ||
| 13897 | 13897 | 83463 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | 6 | 3x3 | 6010416.80991 | 2111846.95811 | 37.77931661531171 | -122.407540511299 | (37.7793166153117, -122.407540511299) | |
| 16867 | 16867 | 84834 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 5 | Permit No. 49303 | 6010439.60599 | 2111868.75172 | 37.7793777314294 | -122.40746318667 | (37.7793777314294, -122.40746318667) | ||
| 37057 | 37057 | 84835 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 5 | Permit No. 49303 | 6010454.595980001 | 2111882.01804 | 37.7794149966465 | -122.40741226527399 | (37.7794149966465, -122.407412265274) | ||
| 110437 | 110437 | 84836 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 1 | 3x3 | Permit No. 49303 | 6010462.0 | 2111912.0 | 37.7794977344849 | -122.407388765785 | (37.7794977344849, -122.407388765785) | |
| 180105 | 180105 | 238990 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1017 Guerrero St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6005766.99533 | 2102918.3127900003 | 37.7545393108464 | -122.422991404546 | (37.7545393108464, -122.422991404546) | |||
| 35995 | 35995 | 238899 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1017 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007637.27503 | 2103714.3832900003 | 37.7568304974367 | -122.416579855286 | (37.7568304974367, -122.416579855286) | |||
| 152725 | 152725 | 239912 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1018 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009411.3463 | 2103219.66951 | 37.755571738872106 | -122.410409504201 | (37.7555717388721, -122.410409504201) | |||
| 487 | 487 | 85532 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007270.64018 | 2109417.23244 | 37.7724685621036 | -122.418252136526 | (37.7724685621036, -122.418252136526) | |||
| 2490 | 2490 | 119764 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2496 | 2496 | 119765 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2509 | 2509 | 119763 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 83170 | 83170 | 107899 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101X Shields St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770994 | 5993727.26625 | 2089799.61042 | 37.717831878877796 | -122.46367556428301 | (37.7178318788778, -122.463675564283) | ||
| 86702 | 86702 | 107898 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101X Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770994 | 5993727.26625 | 2089799.61042 | 37.717831878877796 | -122.46367556428301 | (37.7178318788778, -122.463675564283) | ||
| 112862 | 112862 | 107900 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101X Shields St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770994 | 5993727.26625 | 2089799.61042 | 37.717831878877796 | -122.46367556428301 | (37.7178318788778, -122.463675564283) | ||
| 29525 | 29525 | 241263 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 102 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001760.09453 | 2096639.47445 | 37.73707218612729 | -122.436398949059 | (37.7370721861273, -122.436398949059) | |||
| 40325 | 40325 | 241260 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 102 Hickory St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006407.61883 | 2110610.88879 | 37.7756974394211 | -122.421322198076 | (37.7756974394211, -122.421322198076) | |||
| 153537 | 153537 | 213846 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 102 Omar Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998179.98905 | 2097537.07234 | 37.7393326968565 | -122.448841568688 | (37.7393326968565, -122.448841568688) | |||
| 128086 | 128086 | 48956 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1027 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | Permit Number 46143 | 6008645.82394943 | 2102562.73741605 | 37.7537250076262 | -122.41301048141399 | (37.7537250076262, -122.413010481414) | |||
| 27645 | 27645 | 136148 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1033 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007639.1934400005 | 2116096.29818 | 37.7908284024667 | -122.41745070389999 | (37.7908284024667, -122.4174507039) | |||
| 29502 | 29502 | 136149 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1033 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007646.2538 | 2116049.5218 | 37.7907003632889 | -122.417422958897 | (37.7907003632889, -122.417422958897) | |||
| 44562 | 44562 | 136150 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1033 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007649.0101 | 2116025.45035 | 37.790634424090904 | -122.41741171557699 | (37.7906344240909, -122.417411715577) | |||
| 26674 | 26674 | 30678 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1035 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 9 | Permit Number 34601 | 6007763.45978 | 2109624.69043 | 37.77306592059371 | -122.41656211886499 | (37.7730659205937, -122.416562118865) | |
| 48293 | 48293 | 239913 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1040 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009416.919919999 | 2103096.09581 | 37.75523274570929 | -122.410381503799 | (37.7552327457093, -122.410381503799) | |||
| 80322 | 80322 | 65255 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1040 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28054 | 6009412.00767636 | 2103111.21545962 | 37.755273985498 | -122.410399559399 | (37.755273985498, -122.410399559399) | ||
| 19868 | 19868 | 25582 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1050 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2005 12:00:00 AM | 6 | 3X3 | 6008562.72198 | 2097229.54928 | 37.7390765924125 | -122.412920823236 | (37.7390765924125, -122.412920823236) | ||
| 21856 | 21856 | 25583 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1050 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2005 12:00:00 AM | 6 | 3X3 | 6008597.97678 | 2097252.72638 | 37.739142210551 | -122.41280056592 | (37.739142210551, -122.41280056592) | ||
| 32709 | 32709 | 239108 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 106 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006240.935959999 | 2097507.20155 | 37.7397083616396 | -122.42096822311501 | (37.7397083616396, -122.420968223115) | |||
| 68792 | 68792 | 37771 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1063 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 11 | Permit Number 40109 | 6009536.46227 | 2091239.3466299998 | 37.7226833814051 | -122.40913148662202 | (37.7226833814051, -122.409131486622) | |
| 24722 | 24722 | 238913 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1068 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007587.824440001 | 2103414.46405 | 37.7560042066578 | -122.41672962747299 | (37.7560042066578, -122.416729627473) | |||
| 48573 | 48573 | 238939 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1079 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009205.49335 | 2102912.56915 | 37.7547169683289 | -122.411099719473 | (37.7547169683289, -122.411099719473) | |||
| 29188 | 29188 | 239883 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 108 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007724.09338 | 2096539.57325 | 37.737134959714496 | -122.415771584217 | (37.7371349597145, -122.415771584217) | |||
| 35083 | 35083 | 239884 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 108 Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007743.88943 | 2096538.61214 | 37.7371334335617 | -122.415703072057 | (37.7371334335617, -122.415703072057) | |||
| 149052 | 149052 | 239882 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 108 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007710.45226 | 2096541.24224 | 37.7371387755295 | -122.415818866042 | (37.7371387755295, -122.415818866042) | |||
| 82294 | 82294 | 46321 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1081 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2003 12:00:00 AM | Permit Number 44575 | 6008661.50268126 | 2102262.13718449 | 37.7529005072206 | -122.412935008702 | (37.7529005072206, -122.412935008702) | ||
| 59296 | 59296 | 238938 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1085 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009209.45462 | 2102846.96796 | 37.754537064349705 | -122.411081386809 | (37.7545370643497, -122.411081386809) | |||
| 65665 | 65665 | 238936 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1085 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009210.76069 | 2102819.30468 | 37.754461180441204 | -122.41107491618999 | (37.7544611804412, -122.41107491619) | |||
| 177799 | 177799 | 238937 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1085 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009210.34629 | 2102829.56023 | 37.7544893166383 | -122.411077073652 | (37.7544893166383, -122.411077073652) | |||
| 74712 | 74712 | 238914 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1088 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007589.75882 | 2103369.25281 | 37.7558801757332 | -122.416719734948 | (37.7558801757332, -122.416719734948) | |||
| 7441 | 7441 | 66970 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 109 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2016 12:00:00 AM | 3 | Permit Number 30310 | 5996758.1037 | 2112315.4543 | 37.77982897457179 | -122.454825264921 | (37.7798289745718, -122.454825264921) | |
| 176562 | 176562 | 248386 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 109 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998220.3188 | 2108130.1217 | 37.768420895584704 | -122.44946518922701 | (37.7684208955847, -122.449465189227) | |||
| 108967 | 108967 | 49883 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1095 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | 10 | 3x3 | Permit Number 46651 | 6009223.20438539 | 2102783.5825096 | 37.7543637932015 | -122.41102935948 | (37.7543637932015, -122.41102935948) |
| 86141 | 86141 | 108331 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1099 CAPITOL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995030.0 | 2091211.0 | 37.7217821988442 | -122.45927477266198 | (37.7217821988442, -122.459274772662) | ||||
| 86309 | 86309 | 108334 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1099 CAPITOL AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995030.0 | 2091211.0 | 37.7217821988442 | -122.45927477266198 | (37.7217821988442, -122.459274772662) | ||||
| 91809 | 91809 | 108333 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1099 CAPITOL AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995030.0 | 2091211.0 | 37.7217821988442 | -122.45927477266198 | (37.7217821988442, -122.459274772662) | ||||
| 91824 | 91824 | 108332 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1099 CAPITOL AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995030.0 | 2091211.0 | 37.7217821988442 | -122.45927477266198 | (37.7217821988442, -122.459274772662) | ||||
| 99470 | 99470 | 108338 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1099 CAPITOL AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995030.0 | 2091211.0 | 37.7217821988442 | -122.45927477266198 | (37.7217821988442, -122.459274772662) | ||||
| 116249 | 116249 | 108339 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1099 CAPITOL AVE | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995030.0 | 2091211.0 | 37.7217821988442 | -122.45927477266198 | (37.7217821988442, -122.459274772662) | ||||
| 118901 | 118901 | 108335 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1099 CAPITOL AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995030.0 | 2091211.0 | 37.7217821988442 | -122.45927477266198 | (37.7217821988442, -122.459274772662) | ||||
| 129110 | 129110 | 108336 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1099 CAPITOL AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995030.0 | 2091211.0 | 37.7217821988442 | -122.45927477266198 | (37.7217821988442, -122.459274772662) | ||||
| 138629 | 138629 | 108337 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1099 CAPITOL AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995030.0 | 2091211.0 | 37.7217821988442 | -122.45927477266198 | (37.7217821988442, -122.459274772662) | ||||
| 59635 | 59635 | 239119 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Gladys St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6005837.43876 | 2097632.2808 | 37.7400290481954 | -122.422372231215 | (37.7400290481954, -122.422372231215) | |||
| 73913 | 73913 | 239120 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Gladys St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6005846.7722 | 2097647.3968 | 37.740071079829896 | -122.422341033706 | (37.7400710798299, -122.422341033706) | |||
| 188910 | 188910 | 239118 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6005833.23887 | 2097623.0492 | 37.7400034633796 | -122.422386096966 | (37.7400034633796, -122.422386096966) | |||
| 27372 | 27372 | 196638 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Shaw Aly | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013210.02974 | 2115178.55923 | 37.7886203752705 | -122.398111327376 | (37.7886203752705, -122.398111327376) | |||
| 38199 | 38199 | 196641 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Shaw Aly | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013156.89718 | 2115236.73251 | 37.7887771459954 | -122.398299242536 | (37.7887771459954, -122.398299242536) | |||
| 76715 | 76715 | 196644 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Shaw Aly | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013115.316769999 | 2115283.6537200003 | 37.7889036644133 | -122.398446399488 | (37.7889036644133, -122.398446399488) | |||
| 160314 | 160314 | 196642 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Shaw Aly | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013143.62696 | 2115250.7318 | 37.7888148455695 | -122.398346138561 | (37.7888148455695, -122.398346138561) | |||
| 160662 | 160662 | 196643 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Shaw Aly | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013125.78847 | 2115269.94374 | 37.788866603361704 | -122.398409206221 | (37.7888666033617, -122.398409206221) | |||
| 186966 | 186966 | 196640 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Shaw Aly | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013174.26856 | 2115217.53007 | 37.7887253882096 | -122.39823779183901 | (37.7887253882096, -122.398237791839) | |||
| 188833 | 188833 | 196639 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Shaw Aly | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013190.96727 | 2115199.73755 | 37.7886774642349 | -122.39817876753901 | (37.7886774642349, -122.398178767539) | |||
| 69743 | 69743 | 240110 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Temple St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6000041.9592 | 2105926.45513 | 37.7624742145414 | -122.443006043297 | (37.7624742145414, -122.443006043297) | |||
| 135245 | 135245 | 240109 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 11 Temple St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6000029.34623 | 2105914.7834 | 37.7624414477226 | -122.443048828538 | (37.7624414477226, -122.443048828538) | |||
| 79929 | 79929 | 38131 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 110 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | Permit Number 40293 | 6010183.36335526 | 2094089.0979682 | 37.7305444209455 | -122.40709605392999 | (37.7305444209455, -122.40709605393) | ||
| 116091 | 116091 | 38129 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 110 Brussels St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | Permit Number 40293 | 6010183.36335526 | 2094089.0979682 | 37.7305444209455 | -122.40709605392999 | (37.7305444209455, -122.40709605393) | ||
| 122301 | 122301 | 38130 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 110 Brussels St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | Permit Number 40293 | 6010183.36335526 | 2094089.0979682 | 37.7305444209455 | -122.40709605392999 | (37.7305444209455, -122.40709605393) | ||
| 107305 | 107305 | 60871 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 110 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1988 12:00:00 AM | Permit Number 20653 | 6010410.64858764 | 2099930.61678525 | 37.7465966947669 | -122.406721807492 | (37.7465966947669, -122.406721807492) | ||
| 18231 | 18231 | 25584 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1100 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6008703.17196 | 2097328.50441 | 37.739356184437796 | -122.412442202248 | (37.7393561844378, -122.412442202248) | |||
| 163032 | 163032 | 123779 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1101 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992145.80881 | 2110645.58443 | 37.7749783164413 | -122.47065941775499 | (37.7749783164413, -122.470659417755) | |||
| 25835 | 25835 | 238959 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1111 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009480.56073 | 2102670.61993 | 37.7540680517192 | -122.41013137718299 | (37.7540680517192, -122.410131377183) | |||
| 29191 | 29191 | 238957 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1111 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009480.33516 | 2102696.1439799997 | 37.7541381224012 | -122.410133959135 | (37.7541381224012, -122.410133959135) | |||
| 45798 | 45798 | 238956 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1111 Florida St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6009479.314040001 | 2102707.0663099997 | 37.7541680554383 | -122.410138261499 | (37.7541680554383, -122.410138261499) | |||
| 72646 | 72646 | 238958 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1111 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009480.305869999 | 2102682.51772 | 37.754100706101106 | -122.41013309847999 | (37.7541007061011, -122.41013309848) | |||
| 22026 | 22026 | 25611 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1115X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1997 12:00:00 AM | 6 | 3X3 | 6008678.676080001 | 2097369.4322599997 | 37.739467188659205 | -122.412529790816 | (37.7394671886592, -122.412529790816) | ||
| 84326 | 84326 | 40172 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1116 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1999 12:00:00 AM | Permit Number 41363 | 6009436.98979788 | 2102661.78090656 | 37.754041339457295 | -122.41028143257601 | (37.7540413394573, -122.410281432576) | |||
| 86569 | 86569 | 40170 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1116 Florida St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1999 12:00:00 AM | Permit Number 41363 | 6009436.98979788 | 2102661.78090656 | 37.754041339457295 | -122.41028143257601 | (37.7540413394573, -122.410281432576) | |||
| 128541 | 128541 | 65257 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1116 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1999 12:00:00 AM | Permit Number 41363 | 6009436.98979788 | 2102661.78090656 | 37.754041339457295 | -122.41028143257601 | (37.7540413394573, -122.410281432576) | ||
| 130413 | 130413 | 239917 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1116 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009440.64689 | 2102647.11995 | 37.754001288752896 | -122.41026775035601 | (37.7540012887529, -122.410267750356) | |||
| 156321 | 156321 | 239916 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1116 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009438.01285 | 2102666.8267900003 | 37.7540552516703 | -122.41027825084299 | (37.7540552516703, -122.410278250843) | |||
| 148349 | 148349 | 238915 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1116 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007602.53859 | 2103130.97773 | 37.7552266455984 | -122.416658659296 | (37.7552266455984, -122.416658659296) | |||
| 59857 | 59857 | 239914 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1119 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009437.2029 | 2102726.30659 | 37.7542185244729 | -122.41028525117201 | (37.7542185244729, -122.410285251172) | |||
| 170513 | 170513 | 239915 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1119 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009438.62985 | 2102697.04973 | 37.7541382716789 | -122.41027825085199 | (37.7541382716789, -122.410278250852) | |||
| 86124 | 86124 | 66925 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 112 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1993 12:00:00 AM | Permit Number 30247 | 6007571.80930328 | 2098120.68585367 | 37.7414677837431 | -122.41641006085 | (37.7414677837431, -122.41641006085) | ||
| 186389 | 186389 | 239095 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 112 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007581.45918 | 2098108.31687 | 37.741434363915296 | -122.416375818915 | (37.7414343639153, -122.416375818915) | |||
| 164732 | 164732 | 239778 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 112 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004875.16501 | 2097481.82877 | 37.7395616120816 | -122.425688674597 | (37.7395616120816, -122.425688674597) | |||
| 156717 | 156717 | 238916 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1120 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007603.98274 | 2103104.1444200003 | 37.755153048679205 | -122.41665176419201 | (37.7551530486792, -122.416651764192) | |||
| 149035 | 149035 | 238860 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1124 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008631.9269 | 2101982.1607 | 37.752130094544896 | -122.413017493157 | (37.7521300945449, -122.413017493157) | |||
| 21027 | 21027 | 25609 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1125 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2005 12:00:00 AM | 3 | 3X3 | 6008736.292859999 | 2097412.56603 | 37.7395888579293 | -122.41233362442301 | (37.7395888579293, -122.412333624423) | ||
| 21758 | 21758 | 25610 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1125 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1997 12:00:00 AM | 6 | 3X3 | 6008728.38824 | 2097406.81962 | 37.7395726359678 | -122.412360549221 | (37.7395726359678, -122.412360549221) | ||
| 21699 | 21699 | 23058 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1125 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1995 12:00:00 AM | 3 | 3X3 | 6006398.20766 | 2103046.47398 | 37.754926809838096 | -122.420817600178 | (37.7549268098381, -122.420817600178) | ||
| 122725 | 122725 | 52988 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1126@ 23rd ST Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2006 12:00:00 AM | Permit Number 48970 | 6009440.10442867 | 2102605.7688847 | 37.7538877175805 | -122.41026670694099 | (37.7538877175805, -122.410266706941) | |||
| 47096 | 47096 | 239918 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1128 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009444.69761 | 2102597.65239 | 37.753865688972205 | -122.410250249564 | (37.7538656889722, -122.410250249564) | |||
| 160206 | 160206 | 238960 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1129 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009486.11969 | 2102589.48848 | 37.7538455945022 | -122.410106425474 | (37.7538455945022, -122.410106425474) | |||
| 91210 | 91210 | 90564 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1130 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5990184.07268 | 2110633.82375 | 37.774832389225296 | -122.477444552097 | (37.7748323892253, -122.477444552097) | ||
| 72940 | 72940 | 238898 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1133 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007672.83399 | 2103078.86843 | 37.7550875186789 | -122.416411865541 | (37.7550875186789, -122.416411865541) | |||
| 3651 | 3651 | 240097 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 114 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1992 12:00:00 AM | 7 | Width 3ft | Permit Number 31402 | 6002724.24367 | 2107408.57095 | 37.766696310316796 | -122.433834955823 | (37.7666963103168, -122.433834955823) | |
| 76251 | 76251 | 213799 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 114 Majestic Ave | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997066.26777 | 2089358.12222 | 37.7168114901382 | -122.452102341364 | (37.7168114901382, -122.452102341364) | |||
| 132573 | 132573 | 213798 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 114 Majestic Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997074.19184 | 2089369.0687 | 37.716842000536296 | -122.45207574122601 | (37.7168420005363, -122.452075741226) | |||
| 161665 | 161665 | 213800 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 114 Majestic Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997059.55329 | 2089349.83232 | 37.7167883433744 | -122.452124952113 | (37.7167883433744, -122.452124952113) | |||
| 75900 | 75900 | 238897 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1141 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007676.75598 | 2102978.18832 | 37.7548112946143 | -122.41639117122601 | (37.7548112946143, -122.416391171226) |
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");