trees
953 rows where qSpecies_id = 60 sorted by qAddress descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 139654 | 111669 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99x CARL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998115 | 2107097 | 37.7655781805803 | -122.449755015442 | (37.7655781805803, -122.449755015442) | 15 | 5 | 11 | 29492 | 9 | ||||
| 145614 | 111670 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99x CARL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998115 | 2107097 | 37.7655781805803 | -122.449755015442 | (37.7655781805803, -122.449755015442) | 15 | 5 | 11 | 29492 | 9 | ||||
| 113252 | 24476 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99X Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002281.2265789 | 2096676.7830479 | 37.7372042247503 | -122.43459982975 | (37.7372042247503, -122.43459982975) | 2 | 7 | 5 | 63 | 7 | |||
| 130511 | 12318 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 999 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1997 12:00:00 AM | 6 | 4X4 | 6004783.3056 | 2112237.6551 | 37.7800724294036 | -122.427056996678 | (37.7800724294036, -122.427056996678) | 7 | 9 | 11 | 29490 | 41 | ||
| 178518 | 222595 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6002381.71285 | 2096266.74074 | 37.736084047029 | -122.434223097845 | (37.736084047029, -122.434223097845) | 2 | 7 | 5 | 63 | 7 | |||
| 77209 | 204658 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5994773.2638 | 2095284.74721 | 37.7329529584151 | -122.46045727068 | (37.7329529584151, -122.46045727068) | 9 | 8 | 4 | 59 | 40 | |||
| 127603 | 45765 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99 Blake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997815.0796 | 2113173.4382 | 37.7822453472 | -122.451230630986 | (37.7822453472, -122.451230630986) | 15 | 6 | 1 | 54 | 31 | |
| 164108 | 45767 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99 Blake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997811.6954 | 2113198.143 | 37.7823129863308 | -122.451244120994 | (37.7823129863308, -122.451244120994) | 15 | 6 | 1 | 54 | 31 |
| 422 | 113225 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 6008828.65356 | 2115644.68399 | 37.7896552332384 | -122.413303262628 | (37.7896552332384, -122.413303262628) | 5 | 1 | 10 | 28858 | 21 | ||
| 56102 | 52371 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48503 | 6008855.4568 | 2115649.67517 | 37.7896704425982 | -122.413210878899 | (37.7896704425982, -122.413210878899) | 5 | 1 | 10 | 28858 | 21 |
| 76641 | 27057 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 945 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/25/1999 12:00:00 AM | 7 | 2X3 | 6007415.89764 | 2093543.05958 | 37.7288898564603 | -122.416624950003 | (37.7288898564603, -122.416624950003) | 9 | 3 | 7 | 309 | 28 | ||
| 54578 | 99239 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 940 Laguna Honda Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768814 | 5996167.3 | 2098870.1 | 37.7428775588654 | -122.45589685275 | (37.7428775588654, -122.45589685275) | 1 | 8 | 4 | 59 | 40 | ||||
| 89469 | 221327 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 936 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6010186.18174 | 2103764.32859 | 37.7571106569582 | -122.407768272711 | (37.7571106569582, -122.407768272711) | 2 | 4 | 7 | 28859 | 19 | |||
| 81110 | 9507 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 935 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005077.1287 | 2112297.1038 | 37.7802522713917 | -122.426044762205 | (37.7802522713917, -122.426044762205) | 7 | 9 | 11 | 28852 | 41 | |||
| 67527 | 30677 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 920 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 8 | Permit Number 34600 | 6008142.25986 | 2110035.66546 | 37.7742156570679 | -122.415280896104 | (37.7742156570679, -122.415280896104) | 8 | 2 | 9 | 28853 | 34 | |
| 95200 | 221329 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 92 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010301.69617 | 2100286.438 | 37.7475676053645 | -122.407123632349 | (37.7475676053645, -122.407123632349) | 2 | 7 | 7 | 28859 | 2 | |||
| 32080 | 175788 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 913 Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008132.91971 | 2093497.94914 | 37.7288062932694 | -122.414142956056 | (37.7288062932694, -122.414142956056) | 9 | 3 | 7 | 309 | 28 | |||
| 37364 | 175787 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 913 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008123.23514 | 2093495.17198 | 37.7287981238093 | -122.414176239965 | (37.7287981238093, -122.414176239965) | 9 | 3 | 7 | 309 | 28 | |||
| 66237 | 175786 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 913 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008114.21781 | 2093492.54626 | 37.7287904076408 | -122.414207227876 | (37.7287904076408, -122.414207227876) | 9 | 3 | 7 | 309 | 28 | |||
| 79938 | 26491 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 912X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/1998 12:00:00 AM | 6 | 4X4 | 6004848.1679 | 2112085.98552 | 37.7796596496687 | -122.426821804086 | (37.7796596496687, -122.426821804086) | 7 | 9 | 11 | 28852 | 41 | ||
| 42376 | 27049 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 910 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3x3 | 6007348.52678 | 2093482.21971 | 37.7287190140661 | -122.416853547777 | (37.7287190140661, -122.416853547777) | 9 | 3 | 7 | 309 | 5 | ||
| 127226 | 221334 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90x Peralta Ave | 1 | Median : Yard | Tree | DPW 1 | 12 | Width 10ft | 6010340.53234 | 2100283.18119 | 37.747560836176 | -122.406989109071 | (37.747560836176, -122.406989109071) | 2 | 7 | 7 | 28859 | 2 | |||
| 129227 | 95797 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 907 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767539 | 6008624.3 | 2103231.6 | 37.7555603448561 | -122.413132208673 | (37.7555603448561, -122.413132208673) | 2 | 4 | 7 | 28859 | 19 | |
| 153247 | 222506 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 907 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008600.17028 | 2103215.25622 | 37.7555141138929 | -122.413214501368 | (37.7555141138929, -122.413214501368) | 2 | 4 | 7 | 28859 | 19 | |||
| 58561 | 39663 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.7199324789318 | -122.462649323963 | (37.7199324789318, -122.462649323963) | 9 | 8 | 6 | 28861 | 24 | ||
| 72542 | 39664 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.7199324789318 | -122.462649323963 | (37.7199324789318, -122.462649323963) | 9 | 8 | 6 | 28861 | 24 | ||
| 32876 | 188339 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6011007.54195 | 2094765.98142 | 37.7324490889606 | -122.404294355303 | (37.7324490889606, -122.404294355303) | 10 | 3 | 8 | 58 | 1 | |||
| 37723 | 96932 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011002.04218 | 2094782.56307 | 37.7324943113535 | -122.404314536086 | (37.7324943113535, -122.404314536086) | 10 | 3 | 8 | 58 | 1 | |||
| 55248 | 96934 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010990.76512 | 2094811.66283 | 37.7325735829947 | -122.404355571269 | (37.7325735829947, -122.404355571269) | 10 | 3 | 8 | 58 | 1 | |||
| 86195 | 96931 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010934.9 | 2094931.8 | 37.7329003323541 | -122.404557165415 | (37.7329003323541, -122.404557165415) | 10 | 3 | 8 | 58 | 1 | |||
| 100796 | 96937 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010960.45235 | 2094890.17175 | 37.7327874579767 | -122.404465894707 | (37.7327874579767, -122.404465894707) | 10 | 3 | 8 | 58 | 1 | |||
| 102157 | 96935 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010973.7505 | 2094855.21788 | 37.7326922251695 | -122.404417459925 | (37.7326922251695, -122.404417459925) | 10 | 3 | 8 | 58 | 1 | |||
| 144481 | 96936 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010967.89306 | 2094873.35668 | 37.7327417031574 | -122.404438986978 | (37.7327417031574, -122.404438986978) | 10 | 3 | 8 | 58 | 1 | |||
| 179070 | 96933 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010997.56747 | 2094792.14851 | 37.7325203809043 | -122.404330680741 | (37.7325203809043, -122.404330680741) | 10 | 3 | 8 | 58 | 1 | |||
| 172083 | 16346 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 900X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996119.1686597 | 2094698.5315602 | 37.7314206866198 | -122.455761795923 | (37.7314206866198, -122.455761795923) | 9 | 7 | 4 | 59 | 40 | ||
| 103861 | 139823 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 900 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004831 | 2112025 | 37.7794912277556 | -122.426876850808 | (37.7794912277556, -122.426876850808) | 7 | 9 | 11 | 28852 | 41 | |||
| 60961 | 188300 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008269.7706 | 2109537.20803 | 37.7728541761188 | -122.41480452791 | (37.7728541761188, -122.41480452791) | 8 | 2 | 9 | 28853 | 34 | |||
| 68435 | 188303 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6008234.3659 | 2109502.33979 | 37.7727564467773 | -122.414924528938 | (37.7727564467773, -122.414924528938) | 8 | 2 | 9 | 28853 | 34 | |||
| 94892 | 188302 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6008239.71976 | 2109507.11568 | 37.7727698610843 | -122.414906347362 | (37.7727698610843, -122.414906347362) | 8 | 2 | 9 | 28853 | 34 | |||
| 110873 | 188301 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6008261.50029 | 2109526.90873 | 37.7728254319749 | -122.41483240691 | (37.7728254319749, -122.41483240691) | 8 | 2 | 9 | 28853 | 34 | |||
| 120697 | 35219 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 896 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | 7 | Permit Number 38722 | 6011641.6488 | 2112229.3585 | 37.7804350816614 | -122.403330167353 | (37.7804350816614, -122.403330167353) | 6 | 2 | 9 | 28853 | 34 | ||
| 160804 | 35218 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 896 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | 5 | Permit Number 40401 | 6011658.1335 | 2112244.4696 | 37.7804774939022 | -122.403274202035 | (37.7804774939022, -122.403274202035) | 6 | 2 | 9 | 28853 | 34 | ||
| 110324 | 26698 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 89 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6016127.0690519 | 2096424.3370058 | 37.7372873485592 | -122.386710382374 | (37.7372873485592, -122.386710382374) | 10 | 3 | 8 | 58 | 1 | |||
| 85476 | 175760 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 885 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011559.50494 | 2090784.62511 | 37.7215479360666 | -122.402106275984 | (37.7215479360666, -122.402106275984) | 10 | 3 | 7 | 309 | 28 | |||
| 163528 | 51289 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 875 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2004 12:00:00 AM | Permit Number 47661 | 5995029.72941729 | 2089837.87433116 | 37.7180119072102 | -122.45917632674 | (37.7180119072102, -122.45917632674) | 9 | 8 | 6 | 28861 | 24 | |||
| 37894 | 45238 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 871 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2001 12:00:00 AM | Permit Number 44088 | 6008421.36689101 | 2115188.65226849 | 37.7883802062735 | -122.414680152021 | (37.7883802062735, -122.414680152021) | 5 | 1 | 10 | 28858 | 21 | |||
| 144714 | 4336 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 870 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001641.12667 | 2095893.97724 | 37.7350184628259 | -122.436756924204 | (37.7350184628259, -122.436756924204) | 2 | 7 | 5 | 63 | 7 | |||
| 141699 | 12297 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 861 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2004 12:00:00 AM | 3 | 4X4 | 6004837.02716 | 2111802.36626 | 37.7788802710673 | -122.426840140564 | (37.7788802710673, -122.426840140564) | 7 | 9 | 11 | 28852 | 41 | ||
| 5060 | 141961 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 861 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004842.0409 | 2111803.9569 | 37.7788849220533 | -122.426822909349 | (37.7788849220533, -122.426822909349) | 7 | 9 | 11 | 28852 | 41 | |||
| 17436 | 153178 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 855 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6010194.64784 | 2104257.6801 | 37.7584657635091 | -122.407773780163 | (37.7584657635091, -122.407773780163) | 10 | 4 | 7 | 28859 | 19 | |||
| 41211 | 188316 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 850 Carolina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6012420.02519 | 2103984.29593 | 37.7578394396596 | -122.400058184238 | (37.7578394396596, -122.400058184238) | 10 | 3 | 8 | 28856 | 29 | |||
| 70458 | 188315 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 850 Carolina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6012418.40198 | 2104012.51765 | 37.7579168397997 | -122.400065779927 | (37.7579168397997, -122.400065779927) | 10 | 3 | 8 | 28856 | 29 | |||
| 128662 | 221351 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 85 Sycamore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006363.61838 | 2105832.54053 | 37.7625747506491 | -122.421135037456 | (37.7625747506491, -122.421135037456) | 8 | 4 | 7 | 28859 | 19 | |||
| 191095 | 47724 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 85 Sycamore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2015 12:00:00 AM | 3 | Permit Number 774851 | 6006351.18478147 | 2105818.87737664 | 37.7625365339004 | -122.421177070604 | (37.7625365339004, -122.421177070604) | 8 | 4 | 7 | 28859 | 19 | ||
| 62828 | 39705 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 85 El Verano Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | 9 | 8 | 4 | 59 | 40 | ||
| 89668 | 39704 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 85 El Verano Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | 9 | 8 | 4 | 59 | 40 | ||
| 181007 | 32519 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 845 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37021 | 6007591.14794748 | 2095436.54835454 | 37.734098820334 | -122.41615314248 | (37.734098820334, -122.41615314248) | 2 | 7 | 7 | 28859 | 2 | ||
| 156072 | 12293 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 841X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2002 12:00:00 AM | 3 | 4X4 | 6004846.05575 | 2111737.27176 | 37.7787020480516 | -122.426804270071 | (37.7787020480516, -122.426804270071) | 7 | 9 | 11 | 28852 | 41 | ||
| 137523 | 141963 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 841 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004850.8791 | 2111736.5633 | 37.7787003755045 | -122.426787533754 | (37.7787003755045, -122.426787533754) | 7 | 9 | 11 | 28852 | 41 | |||
| 76818 | 175756 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 837 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000844.62416 | 2089035.80235 | 37.7161421822999 | -122.439019362161 | (37.7161421822999, -122.439019362161) | 9 | 7 | 6 | 28861 | 5 | |||
| 20518 | 188347 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 83 Scotia Ave | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6011997.83069 | 2095044.25145 | 37.7332684477844 | -122.400890216316 | (37.7332684477844, -122.400890216316) | 10 | 3 | 8 | 58 | 1 | |||
| 17042 | 116875 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012413.40755 | 2104121.29509 | 37.7582152402716 | -122.400090692059 | (37.7582152402716, -122.400090692059) | 10 | 3 | 8 | 28856 | 29 | |||
| 28386 | 49816 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46737 | 6012410.64537 | 2104168.1082 | 37.7583436247676 | -122.400103532548 | (37.7583436247676, -122.400103532548) | 10 | 3 | 8 | 28856 | 29 |
| 72533 | 116876 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6012412.72368 | 2104109.13047 | 37.7581818007698 | -122.400092202897 | (37.7581818007698, -122.400092202897) | 10 | 3 | 8 | 28856 | 29 | |||
| 89713 | 49814 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46606 | 6012411.85736 | 2104145.59448 | 37.7582818746203 | -122.400097759826 | (37.7582818746203, -122.400097759826) | 10 | 3 | 8 | 28856 | 29 | |
| 90148 | 49815 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | 11 | 3x3 | Permit Number 46737 | 6012411.85302 | 2104156.13739 | 37.7583108228906 | -122.400098515246 | (37.7583108228906, -122.400098515246) | 10 | 3 | 8 | 28856 | 29 | |
| 137786 | 116874 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6012413.67241 | 2104134.33813 | 37.7582510683591 | -122.400090692038 | (37.7582510683591, -122.400090692038) | 10 | 3 | 8 | 28856 | 29 | |||
| 96666 | 22595 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1992 12:00:00 AM | 6 | 4x4 | 6006111.72158 | 2112834.13473 | 37.7817852453704 | -122.422503794276 | (37.7817852453704, -122.422503794276) | 7 | 9 | 11 | 28852 | 41 | ||
| 102359 | 204612 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5992412.91605 | 2102688.13741 | 37.7531447159591 | -122.469156169131 | (37.7531447159591, -122.469156169131) | 1 | 8 | 4 | 56 | 12 | |||
| 12100 | 96019 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 37840 | 96018 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 70980 | 96020 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 149802 | 96017 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767661 | 6008768.28006 | 2115323.27409 | 37.7887693299764 | -122.413489408823 | (37.7887693299764, -122.413489408823) | 5 | 1 | 10 | 28858 | 21 |
| 166077 | 96016 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767661 | 6008769.14714 | 2115306.341 | 37.788722884507 | -122.41348521079 | (37.788722884507, -122.41348521079) | 5 | 1 | 10 | 28858 | 21 |
| 47264 | 256155 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 80X Peralta Ave | 4 | Median : Cutout | Tree | Private 2 | 3x3 | 6010428 | 2100359 | 37.747773912222 | -122.406691992098 | (37.747773912222, -122.406691992098) | 2 | 7 | 7 | 28859 | 2 | ||||
| 191879 | 12283 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 803X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2000 12:00:00 AM | 3 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | 7 | 9 | 11 | 28852 | 41 | ||
| 8829 | 141965 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 803 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004856.9254 | 2111690.3911 | 37.7785739398403 | -122.426763328248 | (37.7785739398403, -122.426763328248) | 7 | 9 | 11 | 28852 | 41 | |||
| 100041 | 19417 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 05/04/1999 12:00:00 AM | 3 | 20 | 5988998.1028282 | 2096024.0271709 | 37.7346489082814 | -122.480477366023 | (37.7346489082814, -122.480477366023) | 1 | 8 | 3 | 64 | 35 | ||
| 27809 | 188319 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6012713.14067 | 2103722.27252 | 37.7571363191045 | -122.39902607101 | (37.7571363191045, -122.39902607101) | 10 | 3 | 8 | 28856 | 29 | |||
| 62112 | 188324 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 8 | : | Tree | Private 2 | 3 | Width 4ft | 6012719.06472 | 2103600.79409 | 37.756803096012 | -122.39899705709 | (37.756803096012, -122.39899705709) | 10 | 3 | 8 | 28856 | 29 | |||
| 80882 | 188322 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 5 | : | Tree | Private 2 | 3 | Width 3ft | 6012715.86863 | 2103660.87857 | 37.7569678967592 | -122.399012327554 | (37.7569678967592, -122.399012327554) | 10 | 3 | 8 | 28856 | 29 | |||
| 101323 | 188323 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6012718.59247 | 2103642.79546 | 37.7569183962771 | -122.399001638237 | (37.7569183962771, -122.399001638237) | 10 | 3 | 8 | 28856 | 29 | |||
| 123431 | 188320 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6012714.93717 | 2103702.00953 | 37.7570807814757 | -122.399018435778 | (37.7570807814757, -122.399018435778) | 10 | 3 | 8 | 28856 | 29 | |||
| 125660 | 188325 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 9 | : | Tree | Private 2 | 3 | Width 4ft | 6012720.87909 | 2103581.41048 | 37.7567499739592 | -122.398989421832 | (37.7567499739592, -122.398989421832) | 10 | 3 | 8 | 28856 | 29 | |||
| 148011 | 188321 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6012714.29279 | 2103681.13676 | 37.757023433506 | -122.399019199302 | (37.757023433506, -122.399019199302) | 10 | 3 | 8 | 28856 | 29 | |||
| 30698 | 125889 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006091.49195 | 2112832.09387 | 37.781778500422 | -122.422573634365 | (37.781778500422, -122.422573634365) | 7 | 9 | 11 | 28852 | 41 | |||
| 34526 | 22825 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 80 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/1993 12:00:00 AM | 25 | 3X3 | 5999298.50958 | 2099073.67343 | 37.7436157369876 | -122.445084674243 | (37.7436157369876, -122.445084674243) | 2 | 7 | 5 | 63 | 7 | ||
| 175825 | 125890 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 8 Sharp Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007493.35542 | 2119123.01732 | 37.7991308141058 | -122.418169974478 | (37.7991308141058, -122.418169974478) | 5 | 1 | 10 | 28858 | 32 | |||
| 58433 | 27082 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 799X Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
| 113809 | 27079 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 799X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/1999 12:00:00 AM | 8 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
| 149995 | 56952 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 795 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | 7 | Permit Number 14204 | 5993489.41899 | 2110144.08424 | 37.7736789357713 | -122.465975170673 | (37.7736789357713, -122.465975170673) | 11 | 6 | 2 | 54 | 11 | ||
| 42079 | 252895 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 790x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:29:00 PM | 3 | 3x3 | 5997282 | 2090432 | 37.7197724640349 | -122.45143407539 | (37.7197724640349, -122.45143407539) | 9 | 8 | 6 | 28861 | 24 | ||
| 18692 | 175790 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 79 Colby St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6008193.10922 | 2093597.69816 | 37.7290835632519 | -122.413941929669 | (37.7290835632519, -122.413941929669) | 9 | 3 | 7 | 309 | 28 | |||
| 49184 | 125884 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008808.31826 | 2115292.90351 | 37.7886881877568 | -122.413348733254 | (37.7886881877568, -122.413348733254) | 5 | 1 | 10 | 28858 | 21 | |||
| 83415 | 107235 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008834.66692 | 2115296.44284 | 37.7886993852058 | -122.413257820814 | (37.7886993852058, -122.413257820814) | 5 | 1 | 10 | 28858 | 21 | |||
| 84156 | 125883 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008823.04151 | 2115295.32129 | 37.7886956530184 | -122.413297963833 | (37.7886956530184, -122.413297963833) | 5 | 1 | 10 | 28858 | 21 | |||
| 149525 | 123229 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 785 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993489.53527 | 2110160.53271 | 37.7737241055823 | -122.465975963885 | (37.7737241055823, -122.465975963885) | 11 | 6 | 2 | 54 | 11 | |||
| 185327 | 123230 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 785 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993487.30033 | 2110174.28885 | 37.7737617473343 | -122.465984694601 | (37.7737617473343, -122.465984694601) | 11 | 6 | 2 | 54 | 11 | |||
| 55938 | 175783 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 771 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006465.53434 | 2093625.53998 | 37.7290628338846 | -122.419916279827 | (37.7290628338846, -122.419916279827) | 9 | 7 | 7 | 309 | 5 | |||
| 26763 | 54426 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 770 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 15 | 3x3 | Permit Number 12242 | 6012397.0815 | 2104349.75534 | 37.7588416315494 | -122.400163199892 | (37.7588416315494, -122.400163199892) | 10 | 3 | 8 | 28856 | 29 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );