trees
400 rows where qSpecies_id = 43 sorted by Fire Prevention Districts 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12226 | 68412 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 33 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32249 | 5993232.78328668 | 2093269.41121212 | 37.7273306024275 | -122.465636703092 | (37.7273306024275, -122.465636703092) | 9 | 8 | 4 | 59 | 40 | ||
| 14145 | 52527 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 123 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5 | 2x3 | Permit Number 779986 | 6001343.89555 | 2092234.36388 | 37.7249531074958 | -122.437522568322 | (37.7249531074958, -122.437522568322) | 9 | 7 | 6 | 28861 | 25 |
| 20022 | 35741 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 231 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1998 12:00:00 AM | Permit Number 39015 | 6007788.68777846 | 2092857.60054619 | 37.7270286926321 | -122.415287680245 | (37.7270286926321, -122.415287680245) | 9 | 3 | 7 | 309 | 28 | ||
| 22083 | 36334 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 44 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.457225579924 | (37.7262004833581, -122.457225579924) | 9 | 7 | 4 | 28861 | 40 | ||
| 22221 | 36454 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1315 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39355 | 5995842.07912733 | 2092771.30842103 | 37.7261130893774 | -122.45658042282 | (37.7261130893774, -122.45658042282) | 9 | 7 | 4 | 28861 | 40 | ||
| 22627 | 31126 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 19 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34843 | 5998070.7770048 | 2093598.16198917 | 37.7285111411981 | -122.448935514449 | (37.7285111411981, -122.448935514449) | 9 | 7 | 4 | 28861 | 40 | ||
| 23544 | 42023 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 110 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42346 | 5993552.23919225 | 2093678.6131862 | 37.7284725917152 | -122.464562053467 | (37.7284725917152, -122.464562053467) | 9 | 8 | 4 | 59 | 40 | ||
| 25563 | 36489 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
| 27476 | 31110 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | Permit Number 34838 | 5998740.33351858 | 2094135.45298345 | 37.7300246851321 | -122.446659473393 | (37.7300246851321, -122.446659473393) | 9 | 7 | 4 | 28861 | 40 | |||
| 28494 | 42555 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 519 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | 9 | 8 | 4 | 59 | 40 | ||
| 29470 | 45414 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 845 Head St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2001 12:00:00 AM | Permit Number 44215 | 5993893.70509068 | 2091558.26488077 | 37.7226703098261 | -122.463227804134 | (37.7226703098261, -122.463227804134) | 9 | 8 | 4 | 59 | 40 | ||
| 31634 | 31124 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 15 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34842 | 5998070.62548996 | 2093588.33279569 | 37.7284841438842 | -122.448935330498 | (37.7284841438842, -122.448935330498) | 9 | 7 | 4 | 28861 | 40 | ||
| 35658 | 36470 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 101 San Ramon Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39368 | 5995817.82622595 | 2092643.889646 | 37.7257618354228 | -122.456655052435 | (37.7257618354228, -122.456655052435) | 9 | 7 | 4 | 28861 | 40 | ||
| 36889 | 207426 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 404 Baden St | 1 | Side Yard : Yard | Tree | Private 2 | 3 | 6000774.5178 | 2095253.08109 | 37.7332094216698 | -122.439707159174 | (37.7332094216698, -122.439707159174) | 9 | 7 | 5 | 63 | 40 | ||||
| 36936 | 31125 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 15 Foerster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34842 | 5998070.62548996 | 2093588.33279569 | 37.7284841438842 | -122.448935330498 | (37.7284841438842, -122.448935330498) | 9 | 7 | 4 | 28861 | 40 | ||
| 43841 | 39675 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 520 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.7186098185096 | -122.462555624891 | (37.7186098185096, -122.462555624891) | 9 | 8 | 6 | 28861 | 24 | ||
| 47043 | 36453 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1315 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39355 | 5995842.07912733 | 2092771.30842103 | 37.7261130893774 | -122.45658042282 | (37.7261130893774, -122.45658042282) | 9 | 7 | 4 | 28861 | 40 | ||
| 47534 | 34111 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1398 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39363 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | 9 | 7 | 4 | 28861 | 40 | ||
| 54982 | 31111 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Edna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | Permit Number 34838 | 5998740.33351858 | 2094135.45298345 | 37.7300246851321 | -122.446659473393 | (37.7300246851321, -122.446659473393) | 9 | 7 | 4 | 28861 | 40 | |||
| 63515 | 207425 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 359 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5991937.91081 | 2090925.40696 | 37.7208197721094 | -122.469942439193 | (37.7208197721094, -122.469942439193) | 9 | 8 | 6 | 64 | 24 | |||
| 63942 | 31145 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 419 Hearst Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/2006 12:00:00 AM | 3x3 | Permit Number 34852 | 5998635.87955939 | 2094356.6234018 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | 9 | 7 | 4 | 28861 | 40 | |
| 64456 | 42029 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 65 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42351 | 5994340.62872168 | 2093722.8989966 | 37.728639607369 | -122.461839780515 | (37.728639607369, -122.461839780515) | 9 | 8 | 4 | 59 | 40 | ||
| 74322 | 39707 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 738 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41092 | 5997200.32170515 | 2095026.51323817 | 37.7323832338006 | -122.452047720375 | (37.7323832338006, -122.452047720375) | 9 | 7 | 4 | 59 | 40 | ||
| 75770 | 36336 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 44 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/2002 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.457225579924 | (37.7262004833581, -122.457225579924) | 9 | 7 | 4 | 28861 | 40 | ||
| 82374 | 43745 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 253 Summit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43378 | 5996396.86656602 | 2089502.57565196 | 37.7171697577055 | -122.454426548253 | (37.7171697577055, -122.454426548253) | 9 | 8 | 6 | 28861 | 24 | ||
| 86559 | 38511 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 64 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1998 12:00:00 AM | Permit Number 40500 | 6008516.43042503 | 2087785.37039582 | 37.7131422875132 | -122.412413505045 | (37.7131422875132, -122.412413505045) | 9 | 7 | 8 | 309 | 39 | |||
| 94076 | 31013 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1016 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34783 | 6002340.84086344 | 2087450.93520516 | 37.7118755052494 | -122.433734519918 | (37.7118755052494, -122.433734519918) | 9 | 7 | 6 | 28861 | 5 | ||
| 94534 | 42120 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 630 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/06/2002 12:00:00 AM | Permit Number 42417 | 5997254.13334531 | 2095296.10071131 | 37.7331265386983 | -122.451881123727 | (37.7331265386983, -122.451881123727) | 9 | 7 | 4 | 59 | 40 | ||
| 96443 | 37870 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 135 Colon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40155 | 5996120.55604725 | 2093902.0241844 | 37.7292337486651 | -122.455699446357 | (37.7292337486651, -122.455699446357) | 9 | 7 | 4 | 28861 | 40 | ||
| 97659 | 36491 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
| 100219 | 39676 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 520 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.7186098185096 | -122.462555624891 | (37.7186098185096, -122.462555624891) | 9 | 8 | 6 | 28861 | 24 | ||
| 106874 | 34110 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1398 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39363 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | 9 | 7 | 4 | 28861 | 40 | ||
| 107910 | 51637 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 189 Margaret Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47927 | 5996660.05636895 | 2089154.42395132 | 37.7162289049692 | -122.453491707846 | (37.7162289049692, -122.453491707846) | 9 | 8 | 6 | 28861 | 24 | |||
| 111332 | 32293 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 160 Margaret Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1999 12:00:00 AM | Permit Number 41561 | 5996702.09015079 | 2089306.207139 | 37.7166480756618 | -122.453357371649 | (37.7166480756618, -122.453357371649) | 9 | 8 | 6 | 28861 | 24 | ||
| 116815 | 35745 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1005 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1998 12:00:00 AM | Permit Number 39018 | 6007884.66062501 | 2093417.72691387 | 37.728572072766 | -122.414995531053 | (37.728572072766, -122.414995531053) | 9 | 3 | 7 | 309 | 5 | ||
| 116835 | 43746 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 253 Summit St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43378 | 5996396.86656602 | 2089502.57565196 | 37.7171697577055 | -122.454426548253 | (37.7171697577055, -122.454426548253) | 9 | 8 | 6 | 28861 | 24 | ||
| 119125 | 36493 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
| 120572 | 45413 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 845 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2001 12:00:00 AM | Permit Number 44215 | 5993893.70509068 | 2091558.26488077 | 37.7226703098261 | -122.463227804134 | (37.7226703098261, -122.463227804134) | 9 | 8 | 4 | 59 | 40 | ||
| 136572 | 37871 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 135 Colon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40155 | 5996120.55604725 | 2093902.0241844 | 37.7292337486651 | -122.455699446357 | (37.7292337486651, -122.455699446357) | 9 | 7 | 4 | 28861 | 40 | ||
| 137049 | 37869 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 135 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/2002 12:00:00 AM | Permit Number 40155 | 5996120.55604725 | 2093902.0241844 | 37.7292337486651 | -122.455699446357 | (37.7292337486651, -122.455699446357) | 9 | 7 | 4 | 28861 | 40 | ||
| 140321 | 36492 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
| 143304 | 42554 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 519 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | 9 | 8 | 4 | 59 | 40 | ||
| 144944 | 36488 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
| 146965 | 31139 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 419 Hearst Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34852 | 5998635.87955939 | 2094356.6234018 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | 9 | 7 | 4 | 28861 | 40 | ||
| 147242 | 43743 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 240 Summit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43377 | 5996455.89048278 | 2089497.50907915 | 37.7171592309734 | -122.454222165987 | (37.7171592309734, -122.454222165987) | 9 | 8 | 6 | 28861 | 24 | ||
| 151050 | 42013 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 39 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42341 | 5993258.45652191 | 2093300.0310097 | 37.7274161576674 | -122.465550175008 | (37.7274161576674, -122.465550175008) | 9 | 8 | 4 | 59 | 40 | ||
| 155289 | 31184 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34882 | 5992197.59450604 | 2089880.36663556 | 37.7179653541743 | -122.468968787075 | (37.7179653541743, -122.468968787075) | 9 | 8 | 6 | 64 | 24 | ||
| 157890 | 40555 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 215 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1999 12:00:00 AM | Permit Number 41596 | 5992664.70806244 | 2095313.38893204 | 37.7329100758329 | -122.467749114045 | (37.7329100758329, -122.467749114045) | 9 | 8 | 4 | 59 | 40 | ||
| 160336 | 68399 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32230 | 5993170.65048654 | 2093114.37273837 | 37.7269013208382 | -122.465840234227 | (37.7269013208382, -122.465840234227) | 9 | 8 | 4 | 59 | 40 | ||
| 169396 | 33344 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 760 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37481 | 5993727.41255463 | 2094297.74009538 | 37.730182659203 | -122.464001399226 | (37.730182659203, -122.464001399226) | 9 | 8 | 4 | 59 | 40 | ||
| 169593 | 43744 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 240 Summit St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43377 | 5996455.89048278 | 2089497.50907915 | 37.7171592309734 | -122.454222165987 | (37.7171592309734, -122.454222165987) | 9 | 8 | 6 | 28861 | 24 | ||
| 172042 | 36471 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 101 San Ramon Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39368 | 5995817.82622595 | 2092643.889646 | 37.7257618354228 | -122.456655052435 | (37.7257618354228, -122.456655052435) | 9 | 7 | 4 | 28861 | 40 | ||
| 173394 | 64645 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 855 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1997 12:00:00 AM | Permit Number 25560 | 5994845.99503562 | 2093786.0882856 | 37.7288421898975 | -122.460097287553 | (37.7288421898975, -122.460097287553) | 9 | 7 | 4 | 28861 | 40 | ||
| 173715 | 36487 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
| 176487 | 34803 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 722 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | Permit Number 38439 | 5997690.29775308 | 2087581.0038805 | 37.7119676582592 | -122.449817388593 | (37.7119676582592, -122.449817388593) | 9 | 7 | 6 | 28861 | 25 | ||
| 189493 | 36335 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 44 Eastwood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.457225579924 | (37.7262004833581, -122.457225579924) | 9 | 7 | 4 | 28861 | 40 | ||
| 190993 | 42556 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 519 Darien Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | 9 | 8 | 4 | 59 | 40 | ||
| 5456 | 38303 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2000 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
| 10339 | 73455 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 24 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009841.50181 | 2111066.87201 | 37.777142462881 | -122.409475680552 | (37.777142462881, -122.409475680552) | 8 | 2 | 9 | 28853 | 34 | |||
| 28860 | 36076 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2091 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1998 12:00:00 AM | Permit Number 39189 | 6008123.15826597 | 2106262.62233667 | 37.7638546903501 | -122.415079851694 | (37.7638546903501, -122.415079851694) | 8 | 4 | 7 | 28859 | 19 | ||
| 34131 | 38301 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2000 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
| 46799 | 38320 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1810 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40378 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.413465790173 | (37.7684292621485, -122.413465790173) | 8 | 4 | 7 | 28853 | 19 | |||
| 58172 | 38315 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2000 Folsom St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
| 64957 | 9986 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2007 12:00:00 AM | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | 8 | 2 | 5 | 28853 | 19 | ||
| 67646 | 39064 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 238 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2003 12:00:00 AM | Permit Number 40776 | 6007140.57976269 | 2105924.49860202 | 37.7628710155664 | -122.418454324135 | (37.7628710155664, -122.418454324135) | 8 | 4 | 7 | 28859 | 19 | ||
| 71856 | 36717 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1850 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1999 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | 8 | 4 | 7 | 28853 | 19 | ||
| 91288 | 106921 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 112-118 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6007680.5 | 2107244.2 | 37.7665249882726 | -122.416680417976 | (37.7665249882726, -122.416680417976) | 8 | 4 | 7 | 28853 | 19 | |||
| 95507 | 36720 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1850 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | 8 | 4 | 7 | 28853 | 19 | ||
| 100539 | 39065 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 238 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2003 12:00:00 AM | Permit Number 40776 | 6007140.57976269 | 2105924.49860202 | 37.7628710155664 | -122.418454324135 | (37.7628710155664, -122.418454324135) | 8 | 4 | 7 | 28859 | 19 | ||
| 112873 | 38302 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2000 Folsom St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
| 131078 | 31826 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 204 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35286 | 6009467.18551703 | 2109171.58635448 | 37.7719174714901 | -122.410636689386 | (37.7719174714901, -122.410636689386) | 8 | 2 | 9 | 28853 | 34 | ||
| 139708 | 31829 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 222 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | 8 | 2 | 9 | 28853 | 34 | ||
| 139804 | 191035 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 30 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009859.31671 | 2111047.24968 | 37.7770895827422 | -122.409412667772 | (37.7770895827422, -122.409412667772) | 8 | 2 | 9 | 28853 | 34 | |||
| 151832 | 36719 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1850 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | 8 | 4 | 7 | 28853 | 19 | ||
| 152141 | 40299 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2155 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41445 | 6006883.99939755 | 2105792.08668164 | 37.7624929958367 | -122.419332354319 | (37.7624929958367, -122.419332354319) | 8 | 4 | 7 | 28859 | 19 | ||
| 156451 | 31830 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 222 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | 8 | 2 | 9 | 28853 | 34 | ||
| 161440 | 9987 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | 8 | 2 | 5 | 28853 | 19 | |||
| 170901 | 36718 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1850 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | 8 | 4 | 7 | 28853 | 19 | ||
| 172166 | 36078 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2134 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1998 12:00:00 AM | Permit Number 39191 | 6008086.14600314 | 2105996.63644369 | 37.7631222746353 | -122.415189036821 | (37.7631222746353, -122.415189036821) | 8 | 4 | 7 | 28859 | 19 | ||
| 172252 | 31827 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 204 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35286 | 6009467.18551703 | 2109171.58635448 | 37.7719174714901 | -122.410636689386 | (37.7719174714901, -122.410636689386) | 8 | 2 | 9 | 28853 | 34 | ||
| 193933 | 40300 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2155 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1999 12:00:00 AM | Permit Number 41445 | 6006883.99939755 | 2105792.08668164 | 37.7624929958367 | -122.419332354319 | (37.7624929958367, -122.419332354319) | 8 | 4 | 7 | 28859 | 19 | |||
| 177763 | 255250 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 209x Willow St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
| 46836 | 37543 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 704 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39985 | 6008763.04341244 | 2114941.12322015 | 37.7877197423167 | -122.413480489066 | (37.7877197423167, -122.413480489066) | 5 | 1 | 10 | 28858 | 21 | ||
| 69645 | 43105 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2004 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 | ||
| 102213 | 99920 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1740 Jones St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
| 114140 | 43109 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2004 12:00:00 AM | Permit Number 42936 | 6009339.17842867 | 2114353.98733566 | 37.7861399408742 | -122.411445668311 | (37.7861399408742, -122.411445668311) | 5 | 10 | 9 | 28852 | 36 | ||
| 128913 | 43106 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 | ||
| 148461 | 43110 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42936 | 6009339.17842867 | 2114353.98733566 | 37.7861399408742 | -122.411445668311 | (37.7861399408742, -122.411445668311) | 5 | 10 | 9 | 28852 | 36 | ||
| 150403 | 43108 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 | ||
| 159345 | 37542 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 704 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39985 | 6008763.04341244 | 2114941.12322015 | 37.7877197423167 | -122.413480489066 | (37.7877197423167, -122.413480489066) | 5 | 1 | 10 | 28858 | 21 | ||
| 176908 | 43107 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 | ||
| 30149 | 34482 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 840 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38209 | 6008945.03028541 | 2119415.9766962 | 37.8000168102383 | -122.413167394928 | (37.8000168102383, -122.413167394928) | 3 | 1 | 10 | 308 | 32 | ||
| 3049 | 43998 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 150 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2000 12:00:00 AM | Permit Number 43555 | 6008950.71046834 | 2099077.83692872 | 37.7441733566649 | -122.411709892219 | (37.7441733566649, -122.411709892219) | 2 | 7 | 7 | 28859 | 2 | |||
| 3336 | 35927 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 22 Appleton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | Permit Number 39097 | 6005564.10753047 | 2097077.73566378 | 37.738490969573 | -122.423277889221 | (37.738490969573, -122.423277889221) | 2 | 7 | 7 | 28859 | 2 | ||
| 3588 | 37560 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4645 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 39999 | 6000466.36495931 | 2104620.54811441 | 37.758912703603 | -122.44144447135 | (37.758912703603, -122.44144447135) | 2 | 4 | 5 | 28862 | 38 | ||
| 3986 | 116680 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 100 Esmeralda Ave | 19 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 10411 | 47385 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1231 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45301 | 6001377.58877778 | 2100188.59270033 | 37.7467954887327 | -122.437975585037 | (37.7467954887327, -122.437975585037) | 2 | 4 | 5 | 63 | 22 | |||
| 13812 | 34364 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1862 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38120 | 6004563.40220029 | 2097868.81083057 | 37.7406065549579 | -122.426794167737 | (37.7406065549579, -122.426794167737) | 2 | 7 | 5 | 63 | 7 | ||
| 14374 | 34363 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1846 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38119 | 6004556.0268692 | 2098000.12862747 | 37.7409667067108 | -122.426829018524 | (37.7409667067108, -122.426829018524) | 2 | 7 | 5 | 63 | 7 | ||
| 14912 | 34353 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 11 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38109 | 6004890.69932117 | 2098315.24737801 | 37.7418508681298 | -122.425694266568 | (37.7418508681298, -122.425694266568) | 2 | 7 | 5 | 63 | 7 |
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) );