trees
302 rows where qSpecies_id = 167 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192734 | 136035 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1798 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002262.26199 | 2120563.69941 | 37.8027907211793 | -122.436374473117 | (37.8027907211793, -122.436374473117) | 13 | 9 | 1 | 57 | 17 | |||
| 192532 | 185747 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1802 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987565.4993 | 2100345.9151 | 37.7464323129859 | -122.48574739527 | (37.7464323129859, -122.48574739527) | 1 | 8 | 3 | 29491 | 35 | |||
| 192207 | 84853 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1338 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 6 | Permit No. 49311 | 5994481.6608 | 2112148.58575 | 37.779239954215 | -122.462688317698 | (37.779239954215, -122.462688317698) | 11 | 6 | 2 | 54 | 11 | ||
| 191968 | 60785 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 126 Ewing Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1983 12:00:00 AM | Permit Number 20455 | 5998690.69552191 | 2112465.2130408 | 37.7803508407843 | -122.448150392076 | (37.7803508407843, -122.448150392076) | 15 | 6 | 2 | 54 | 16 | ||
| 191094 | 63659 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 411 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24307 | 6003836.58732035 | 2100093.87745401 | 37.7466749538841 | -122.429465853369 | (37.7466749538841, -122.429465853369) | 2 | 7 | 5 | 63 | 22 | ||
| 190777 | 85265 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3000 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.7335405447433 | -122.478606721292 | (37.7335405447433, -122.478606721292) | 1 | 8 | 4 | 64 | 35 | |||
| 189718 | 118270 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 775 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5984752.97057 | 2110594.13751 | 37.7744067825501 | -122.49622865438 | (37.7744067825501, -122.49622865438) | 11 | 6 | 2 | 55 | 26 | |||
| 189098 | 238561 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 84 Richland Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6005027.1753 | 2096150.27417 | 37.7359140517929 | -122.42506837081 | (37.7359140517929, -122.42506837081) | 2 | 7 | 5 | 28859 | 2 | |||
| 186986 | 59836 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1271 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 19290 | 5995144.61588097 | 2106889.02596139 | 37.7648367447545 | -122.46001377482 | (37.7648367447545, -122.46001377482) | 15 | 5 | 11 | 56 | 12 | ||
| 186444 | 246650 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3350 Harrison St | 11 | Side Yard : Yard | Tree | Private 2 | 5 | 6009031.04128 | 2099150.93712 | 37.744378579707 | -122.411437288125 | (37.744378579707, -122.411437288125) | 2 | 7 | 7 | 28859 | 2 | ||||
| 185325 | 238554 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1480 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6003916.2981 | 2099645.9415 | 37.7454495382776 | -122.429158287842 | (37.7454495382776, -122.429158287842) | 2 | 7 | 5 | 63 | 22 | |||
| 185215 | 182092 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2691 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987764.3751 | 2098252.1671 | 37.7406950216778 | -122.484906136221 | (37.7406950216778, -122.484906136221) | 1 | 8 | 3 | 29491 | 35 | |||
| 183518 | 181884 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2364 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986431.5008 | 2099166.4136 | 37.7431275754829 | -122.48958185913 | (37.7431275754829, -122.48958185913) | 1 | 8 | 3 | 29491 | 35 | |||
| 183391 | 196530 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1150 19th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6014129.09689 | 2105289.45573 | 37.7615182666641 | -122.394238832278 | (37.7615182666641, -122.394238832278) | 10 | 3 | 8 | 28856 | 29 | |||
| 183117 | 181827 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2311 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986682.1022 | 2099505.6814 | 37.7440737416666 | -122.488740290538 | (37.7440737416666, -122.488740290538) | 1 | 8 | 3 | 29491 | 35 | |||
| 182259 | 84042 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 508 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50447 | 6003026.52400311 | 2103317.18885819 | 37.7554795089619 | -122.432497158122 | (37.7554795089619, -122.432497158122) | 2 | 4 | 5 | 28862 | 22 | ||
| 182253 | 117637 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 Locust St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5997541.40632 | 2116024.00549 | 37.7900565763988 | -122.452383178041 | (37.7900565763988, -122.452383178041) | 11 | 6 | 1 | 54 | 31 | |||
| 181767 | 238546 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1550 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010196.53495 | 2100318.93034 | 37.7476509365422 | -122.407489565592 | (37.7476509365422, -122.407489565592) | 2 | 7 | 7 | 28859 | 2 | |||
| 181649 | 67772 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 146 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31403 | 6004564.19848572 | 2108804.14815363 | 37.7706324670974 | -122.427570300779 | (37.7706324670974, -122.427570300779) | 7 | 9 | 11 | 28852 | 10 | ||
| 181631 | 238545 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1673 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009720.83243 | 2099966.93881 | 37.7466578071094 | -122.409109691579 | (37.7466578071094, -122.409109691579) | 2 | 7 | 7 | 28859 | 2 | |||
| 181274 | 60074 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1275 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1982 12:00:00 AM | 4 | Permit Number 19575 | 5988921.6846 | 2106672.1231 | 37.7638813163914 | -122.481521155686 | (37.7638813163914, -122.481521155686) | 1 | 8 | 3 | 56 | 35 | |
| 181019 | 64271 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1627 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1988 12:00:00 AM | Permit Number 25074 | 6009690.91214732 | 2100255.03327712 | 37.7474471748973 | -122.409233479729 | (37.7474471748973, -122.409233479729) | 2 | 7 | 7 | 28859 | 2 | ||
| 180995 | 68955 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 790 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 4 | Permit Number 32944 | 5988860.14903 | 2109950.32052 | 37.7728787684605 | -122.481974145233 | (37.7728787684605, -122.481974145233) | 11 | 6 | 2 | 55 | 26 | |
| 180109 | 64262 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 159 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25064 | 6010000.52253468 | 2100073.98033326 | 37.7469673841837 | -122.408150095635 | (37.7469673841837, -122.408150095635) | 2 | 7 | 7 | 28859 | 2 | ||
| 179037 | 63775 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 29 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24456 | 6004942.98585197 | 2101617.48681583 | 37.7509210136603 | -122.425748465468 | (37.7509210136603, -122.425748465468) | 2 | 4 | 5 | 28862 | 22 | ||
| 175231 | 179168 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 200x Mansell St | 21 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6011032.14311 | 2090534.05643 | 37.7208304767293 | -122.40391160924 | (37.7208304767293, -122.40391160924) | 10 | 3 | 7 | 309 | 28 | |||
| 175102 | 246143 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 9 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999964.3115 | 2108327.8691 | 37.7690634706146 | -122.443447101152 | (37.7690634706146, -122.443447101152) | 15 | 5 | 11 | 29492 | 9 | |||
| 174135 | 196526 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1327 Rhode Island St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6012008.29844 | 2102189.51462 | 37.752888399289 | -122.401355988709 | (37.752888399289, -122.401355988709) | 10 | 3 | 8 | 28856 | 29 | |||
| 172690 | 40824 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 695 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1999 12:00:00 AM | Permit Number 41762 | 6013368.81391754 | 2110378.20910645 | 37.7754485595516 | -122.39722520599 | (37.7754485595516, -122.39722520599) | 6 | 2 | 9 | 28856 | 34 | |||
| 172046 | 1641 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 859 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5995651.21865 | 2110512.9681 | 37.774816268938 | -122.458523928345 | (37.774816268938, -122.458523928345) | 11 | 6 | 2 | 54 | 11 | |||
| 171935 | 60803 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 120 Ewing Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1983 12:00:00 AM | Permit Number 20479 | 5998693.79228565 | 2112443.24923504 | 37.7802907109033 | -122.448138097032 | (37.7802907109033, -122.448138097032) | 15 | 6 | 2 | 54 | 16 | ||
| 171034 | 50755 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 949 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2004 12:00:00 AM | Permit Number 47296 | 6007821.20096678 | 2120247.77734731 | 37.8022375706793 | -122.417115255464 | (37.8022375706793, -122.417115255464) | 5 | 1 | 10 | 308 | 32 | |||
| 170313 | 137918 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1914 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003425.977 | 2115322.684 | 37.7884662960967 | -122.431972962095 | (37.7884662960967, -122.431972962095) | 13 | 9 | 1 | 29490 | 27 | |||
| 169133 | 140279 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2099 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997824 | 2110223 | 37.774144722636 | -122.450986949191 | (37.774144722636, -122.450986949191) | 15 | 5 | 11 | 29492 | 16 | |||
| 168954 | 124302 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 183 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5996217.53414 | 2113089.73746 | 37.7819239279859 | -122.456751335801 | (37.7819239279859, -122.456751335801) | 11 | 6 | 1 | 54 | 31 | |||
| 168286 | 238567 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 638 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002382.79124 | 2100064.95153 | 37.7465131116006 | -122.434490857486 | (37.7465131116006, -122.434490857486) | 2 | 7 | 5 | 63 | 22 | |||
| 166319 | 238541 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 31 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6005390.57049 | 2103524.39032 | 37.7561822103525 | -122.424336286693 | (37.7561822103525, -122.424336286693) | 2 | 4 | 5 | 28859 | 19 | |||
| 164715 | 123860 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 346 Lake St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994375.95206 | 2114914.31886 | 37.7868278217721 | -122.463254749485 | (37.7868278217721, -122.463254749485) | 11 | 6 | 1 | 54 | 11 | |||
| 164404 | 136031 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1635 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004020.9595 | 2120061.85215 | 37.8015125516123 | -122.430252658446 | (37.8015125516123, -122.430252658446) | 13 | 9 | 1 | 57 | 17 | |||
| 163456 | 196527 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 333 Texas St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6013792.65149 | 2105531.32389 | 37.7621636768226 | -122.395419411895 | (37.7621636768226, -122.395419411895) | 10 | 3 | 8 | 28856 | 29 | |||
| 163362 | 35583 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3600 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1998 12:00:00 AM | 7 | Permit Number 38951 | 6002198.46328 | 2120613.57109 | 37.8029240303879 | -122.436598820686 | (37.8029240303879, -122.436598820686) | 13 | 9 | 1 | 57 | 17 | ||
| 163202 | 67421 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 511 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1992 12:00:00 AM | 5 | Permit Number 30922 | 5991237.50588 | 2111900.67959 | 37.7783718985889 | -122.473892988078 | (37.7783718985889, -122.473892988078) | 11 | 6 | 2 | 54 | 26 | |
| 162518 | 51916 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1750 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2005 12:00:00 AM | 2 | Permit Number 48117 | 5982875.703 | 2103201.7552 | 37.7539992671341 | -122.502175211562 | (37.7539992671341, -122.502175211562) | 1 | 8 | 3 | 56 | 35 | ||
| 161372 | 83531 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1355x COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50899 | 5998199 | 2105694 | 37.7617307020229 | -122.449363384978 | (37.7617307020229, -122.449363384978) | 15 | 5 | 11 | 29492 | 9 | ||
| 160965 | 85262 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3000 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.7335405447433 | -122.478606721292 | (37.7335405447433, -122.478606721292) | 1 | 8 | 4 | 64 | 35 | |||
| 159664 | 238542 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 38 Ramona Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005184.86734 | 2107563.56231 | 37.7672612032636 | -122.425335101659 | (37.7672612032636, -122.425335101659) | 8 | 4 | 5 | 28853 | 19 | |||
| 158692 | 117634 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | 3x3 | 5997551.04889 | 2115977.76508 | 37.7899301649938 | -122.452346477623 | (37.7899301649938, -122.452346477623) | 11 | 6 | 1 | 54 | 31 | ||
| 158248 | 50351 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 658 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/2003 12:00:00 AM | 3 | Permit Number 47029 | 5981670.87041 | 2111242.23948 | 37.7760052591288 | -122.506938117672 | (37.7760052591288, -122.506938117672) | 11 | 6 | 2 | 55 | 26 | |
| 158240 | 60370 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1439 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19948 | 6015729.73368672 | 2094586.16842125 | 37.7322181026296 | -122.387955935836 | (37.7322181026296, -122.387955935836) | 10 | 3 | 8 | 58 | 1 | ||
| 156886 | 118251 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 883 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5985085.51962 | 2109878.09808 | 37.7724602164796 | -122.495025511982 | (37.7724602164796, -122.495025511982) | 11 | 6 | 2 | 55 | 26 | |||
| 156391 | 64800 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 358 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | 6 | Permit Number 25799 | 6004181.11096303 | 2100164.87946029 | 37.7468894092393 | -122.428279585184 | (37.7468894092393, -122.428279585184) | 2 | 7 | 5 | 63 | 22 | |
| 156175 | 123146 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 560 10th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5992867.54706 | 2111680.63893 | 37.7778620058506 | -122.468238105016 | (37.7778620058506, -122.468238105016) | 11 | 6 | 2 | 54 | 11 | |||
| 154831 | 12714 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1501 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5990789.16326 | 2114722.34 | 37.7860934167472 | -122.475650050524 | (37.7860934167472, -122.475650050524) | 11 | 6 | 2 | 54 | 26 | |||
| 154377 | 34113 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1398 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37977 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | 9 | 7 | 4 | 28861 | 40 | ||
| 154216 | 139122 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1501 LAGUNA ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6004515.7696 | 2114102.0367 | 37.7851764260276 | -122.428115426505 | (37.7851764260276, -122.428115426505) | 13 | 9 | 11 | 29490 | 13 | |||
| 153765 | 139117 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1501 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004494.7186 | 2114242.7456 | 37.785561586454 | -122.428198287945 | (37.785561586454, -122.428198287945) | 13 | 9 | 11 | 29490 | 13 | |||
| 153565 | 65660 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 106 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1990 12:00:00 AM | Permit Number 28580 | 5999382.81726917 | 2095526.44780449 | 37.7338807102318 | -122.444538269179 | (37.7338807102318, -122.444538269179) | 9 | 7 | 4 | 59 | 40 | ||
| 152640 | 218233 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 365 Wawona St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 5991919.11048 | 2097078.05412 | 37.737712321755 | -122.470455286603 | (37.737712321755, -122.470455286603) | 1 | 8 | 4 | 59 | 40 | |||
| 150775 | 34800 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 67 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | 6 | Permit Number 38436 | 5999719.34945 | 2088765.88289 | 37.7153369536092 | -122.442889465097 | (37.7153369536092, -122.442889465097) | 9 | 7 | 6 | 28861 | 25 | |
| 149859 | 35161 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 515 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | 6 | Permit Number 38692 | 6002615.109 | 2110357.4935 | 37.7747871313025 | -122.434423295825 | (37.7747871313025, -122.434423295825) | 15 | 5 | 11 | 29492 | 10 | |
| 147981 | 138763 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1508 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | Permit Number 782176 | 6000172.4842 | 2114147.0286 | 37.7850532695664 | -122.443145033749 | (37.7850532695664, -122.443145033749) | 15 | 6 | 1 | 29490 | 27 | ||
| 147558 | 40222 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 4387 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 41401 | 6001391.00854692 | 2101128.86800083 | 37.7493780241405 | -122.437996521237 | (37.7493780241405, -122.437996521237) | 2 | 4 | 5 | 28862 | 22 | ||
| 147138 | 238569 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1623 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003376.35703 | 2098716.75556 | 37.7428676287329 | -122.430959013851 | (37.7428676287329, -122.430959013851) | 2 | 7 | 5 | 63 | 22 | |||
| 144382 | 117910 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 843 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5983532.20946 | 2110068.65579 | 37.7728923776477 | -122.500412569486 | (37.7728923776477, -122.500412569486) | 11 | 6 | 2 | 55 | 26 | |||
| 144321 | 23667 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 315 Virginia Ave | 2 | Median : Cutout | Tree | DPW 1 | 6 | 12 | 6006939.5968988 | 2098278.7889768 | 37.7418663267774 | -122.418607247372 | (37.7418663267774, -122.418607247372) | 2 | 7 | 7 | 28859 | 2 | |||
| 144154 | 142051 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 32 ATALAYA TER | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998845.9761 | 2110971.5149 | 37.7762584069 | -122.447505657858 | (37.7762584069, -122.447505657858) | 15 | 6 | 2 | 29492 | 16 | |||
| 143285 | 60381 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1350 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19961 | 6016233.53392592 | 2094275.31577425 | 37.7313924611256 | -122.386192505476 | (37.7313924611256, -122.386192505476) | 10 | 3 | 8 | 58 | 1 | ||
| 142626 | 424 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1901X Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5989549.9462 | 2114680.69168 | 37.7859071433722 | -122.479934312872 | (37.7859071433722, -122.479934312872) | 11 | 6 | 2 | 55 | 26 | |||
| 142615 | 122123 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990814.40287 | 2114634.30613 | 37.7858531634971 | -122.475556298764 | (37.7858531634971, -122.475556298764) | 11 | 6 | 2 | 54 | 26 | |||
| 142417 | 35588 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3600 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1998 12:00:00 AM | 5 | Permit Number 38951 | 6002194.35784 | 2120633.11747 | 37.8029774662898 | -122.436614427534 | (37.8029774662898, -122.436614427534) | 13 | 9 | 1 | 57 | 17 | ||
| 142059 | 111708 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 463 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5985915.33595 | 2112785.30995 | 37.780491135633 | -122.492369259237 | (37.780491135633, -122.492369259237) | 11 | 6 | 2 | 55 | 26 | |||
| 141391 | 423 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1901X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5989520.14191 | 2114679.43534 | 37.785901962187 | -122.480037334344 | (37.785901962187, -122.480037334344) | 11 | 6 | 2 | 55 | 26 | |||
| 140942 | 63743 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 330 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24415 | 6002754.42754095 | 2109677.07121909 | 37.7729267674736 | -122.433892719333 | (37.7729267674736, -122.433892719333) | 15 | 5 | 11 | 29492 | 9 | ||
| 140595 | 196528 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 400 Texas St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6013752.07769 | 2105195.94744 | 37.7612405497197 | -122.395536244627 | (37.7612405497197, -122.395536244627) | 10 | 3 | 8 | 28856 | 29 | |||
| 140530 | 120349 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2122 Lake St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5988820.20378 | 2114710.27627 | 37.7859459503003 | -122.482461158758 | (37.7859459503003, -122.482461158758) | 11 | 6 | 1 | 55 | 33 | |||
| 140030 | 60907 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1491 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20697 | 5994575.4199228 | 2105392.22311625 | 37.7606941592004 | -122.461873918454 | (37.7606941592004, -122.461873918454) | 1 | 5 | 11 | 56 | 12 | ||
| 139799 | 35587 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3600 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1998 12:00:00 AM | 5 | Permit Number 38951 | 6002200.57544 | 2120594.56512 | 37.8028719650354 | -122.436590150328 | (37.8028719650354, -122.436590150328) | 13 | 9 | 1 | 57 | 17 | ||
| 138936 | 22856 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 140 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5999949.39722 | 2099144.09084 | 37.7438462152458 | -122.442839126451 | (37.7438462152458, -122.442839126451) | 2 | 7 | 5 | 63 | 7 | |||
| 138858 | 218234 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 363 Wawona St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 5991942.37249 | 2097100.26262 | 37.7377746456792 | -122.470376476289 | (37.7377746456792, -122.470376476289) | 1 | 8 | 4 | 59 | 40 | |||
| 135657 | 218411 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 205 Castenada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5994290.42542 | 2100613.60822 | 37.7475568944299 | -122.462512951805 | (37.7475568944299, -122.462512951805) | 1 | 8 | 4 | 29491 | 40 | |||
| 135646 | 249615 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2350 Golden Gate Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998136.14994 | 2111389.29333 | 37.7773649281729 | -122.449991247621 | (37.7773649281729, -122.449991247621) | 15 | 6 | 2 | 54 | 16 | |||
| 135358 | 182279 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1496 Kirkham St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984984.0246 | 2105052.8568 | 37.7592055205034 | -122.495020725609 | (37.7592055205034, -122.495020725609) | 1 | 8 | 3 | 56 | 35 | |||
| 134630 | 181654 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1270 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5986485.9791 | 2106605.5895 | 37.7635567077637 | -122.489940517963 | (37.7635567077637, -122.489940517963) | 1 | 8 | 3 | 56 | 35 | |||
| 134167 | 213715 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 125 Judson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999200.66697 | 2093467.5999 | 37.728217201345 | -122.445020057043 | (37.728217201345, -122.445020057043) | 9 | 7 | 4 | 28861 | 40 | |||
| 133777 | 249614 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2350 Golden Gate Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998151.85452 | 2111390.96303 | 37.7773704113412 | -122.449937040973 | (37.7773704113412, -122.449937040973) | 15 | 6 | 2 | 54 | 16 | |||
| 133667 | 63671 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 371 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24322 | 6004109.81981541 | 2100108.88292896 | 37.7467316215822 | -122.428522112668 | (37.7467316215822, -122.428522112668) | 2 | 7 | 5 | 63 | 22 | ||
| 133366 | 50190 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 350 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2003 12:00:00 AM | Permit Number 46896 | 5992966.98430504 | 2103249.49310039 | 37.7547180534592 | -122.467280921215 | (37.7547180534592, -122.467280921215) | 1 | 8 | 4 | 56 | 12 | |||
| 133226 | 46266 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1461 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1987 12:00:00 AM | Permit Number 44550 | 6003962.08662823 | 2099767.6187722 | 37.7457862278615 | -122.429008632092 | (37.7457862278615, -122.429008632092) | 2 | 7 | 5 | 63 | 22 | ||
| 131218 | 187550 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 15 Chicago Way | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6003854.31887 | 2086791.04585 | 37.7101493555763 | -122.428456511776 | (37.7101493555763, -122.428456511776) | 9 | 7 | 6 | 309 | 5 | |||
| 130614 | 246643 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3350 Harrison St | 4 | Side Yard : Yard | Tree | Private 2 | 7 | 6009035.26115 | 2099177.78886 | 37.7444525453606 | -122.411424593276 | (37.7444525453606, -122.411424593276) | 2 | 7 | 7 | 28859 | 2 | ||||
| 130298 | 182113 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2462 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5988005.6699 | 2098548.963 | 37.7415239963656 | -122.484093600478 | (37.7415239963656, -122.484093600478) | 1 | 8 | 3 | 29491 | 35 | |||
| 129448 | 123859 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 346 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994390.43638 | 2114914.64585 | 37.7868295540161 | -122.463204661228 | (37.7868295540161, -122.463204661228) | 11 | 6 | 1 | 54 | 11 | |||
| 128132 | 196520 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1100 Pennsylvania Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014495.9358 | 2101776.59314 | 37.7518930845169 | -122.392724321763 | (37.7518930845169, -122.392724321763) | 10 | 3 | 8 | 28856 | 1 | ||||
| 127653 | 39615 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 41 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41016 | 5998377.05402267 | 2106536.9754029 | 37.7640554838896 | -122.44880829126 | (37.7640554838896, -122.44880829126) | 15 | 5 | 11 | 29492 | 9 | ||
| 127515 | 65516 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 159 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/1990 12:00:00 AM | 5 | Permit Number 28402 | 5990823.47806 | 2114342.11962 | 37.7850514269176 | -122.475503559583 | (37.7850514269176, -122.475503559583) | 11 | 6 | 2 | 54 | 26 | ||
| 127426 | 45342 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 466 Ralston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44172 | 5992247.31717609 | 2090977.05466926 | 37.7209794647769 | -122.46887668176 | (37.7209794647769, -122.46887668176) | 9 | 8 | 6 | 64 | 24 | ||
| 127350 | 98667 | Undocumented 4 | Prunus blireiana :: Flowering Plum 167 | 396 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013391.9 | 2110381 | 37.7754575079339 | -122.397145540942 | (37.7754575079339, -122.397145540942) | 6 | 2 | 9 | 28856 | 34 | ||||
| 126896 | 213713 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 125 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5999159.40748 | 2093468.82637 | 37.7282182139859 | -122.445162780338 | (37.7282182139859, -122.445162780338) | 9 | 7 | 4 | 28861 | 40 | |||
| 126638 | 185745 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2195 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987583.2114 | 2100377.5043 | 37.7465200805681 | -122.485688467617 | (37.7465200805681, -122.485688467617) | 1 | 8 | 3 | 29491 | 35 | |||
| 125996 | 61892 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1663 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/15/1985 12:00:00 AM | 5 | Permit Number 21935 | 5988700.7716 | 2104003.1782 | 37.7565402689029 | -122.482089681142 | (37.7565402689029, -122.482089681142) | 1 | 8 | 3 | 56 | 35 |
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) );