trees
400 rows where qSpecies_id = 43 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 34181 | 68180 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 75 Rossi Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1993 12:00:00 AM | Permit Number 31952 | 5996329.36645327 | 2111693.70801186 | 37.7780972208044 | -122.456263479509 | (37.7780972208044, -122.456263479509) | 11 | 6 | 2 | 54 | 16 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 106945 | 140845 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 527 EUCLID AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5996698.8799 | 2113809.925 | 37.7839289983891 | -122.455138170133 | (37.7839289983891, -122.455138170133) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | ||
| 104093 | 36188 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 35 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 7 | Permit Number 39256 | 5996804.8059 | 2114366.2904 | 37.7854627064304 | -122.454811918638 | (37.7854627064304, -122.454811918638) | 11 | 6 | 1 | 54 | 31 | |
| 140389 | 36187 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 35 Parker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 8 | Permit Number 39256 | 5996805.8212 | 2114349.7078 | 37.7854172332631 | -122.45480720749 | (37.7854172332631, -122.45480720749) | 11 | 6 | 1 | 54 | 31 | |
| 180365 | 141254 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 45 PARKER AVE | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5996808.5286 | 2114260.026 | 37.7851711462005 | -122.454791358921 | (37.7851711462005, -122.454791358921) | 11 | 6 | 1 | 54 | 31 | |||
| 79658 | 141253 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 45 PARKER AVE | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5996809.5439 | 2114265.4407 | 37.7851860717648 | -122.454788237668 | (37.7851860717648, -122.454788237668) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 180644 | 248448 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 136 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998284.3672 | 2107976.1331 | 37.768001745714 | -122.449232557107 | (37.768001745714, -122.449232557107) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | |||
| 166774 | 141601 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1882 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998863.8341 | 2110436.3604 | 37.77479003056 | -122.447405354515 | (37.77479003056, -122.447405354515) | 15 | 5 | 11 | 29492 | 16 | |||
| 7624 | 246397 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1320 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999315.6516 | 2108414.4782 | 37.769264264093 | -122.445696997639 | (37.769264264093, -122.445696997639) | 15 | 5 | 11 | 29492 | 9 | |||
| 106912 | 246396 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1320 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999332.61 | 2108417.5065 | 37.769273547251 | -122.445638557414 | (37.769273547251, -122.445638557414) | 15 | 5 | 11 | 29492 | 9 | |||
| 124314 | 246395 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1320 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999349.2656 | 2108419.0206 | 37.7692786554823 | -122.445581055639 | (37.7692786554823, -122.445581055639) | 15 | 5 | 11 | 29492 | 9 | |||
| 91821 | 246394 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1320 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999365.9212 | 2108422.0489 | 37.7692879212962 | -122.445523662753 | (37.7692879212962, -122.445523662753) | 15 | 5 | 11 | 29492 | 9 | |||
| 32393 | 246393 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1318 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999383.4853 | 2108424.4716 | 37.7692955761214 | -122.445463083857 | (37.7692955761214, -122.445463083857) | 15 | 5 | 11 | 29492 | 9 | |||
| 65565 | 246392 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1310 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999402.5635 | 2108427.4999 | 37.7693049801732 | -122.445397311319 | (37.7693049801732, -122.445397311319) | 15 | 5 | 11 | 29492 | 9 | |||
| 58011 | 246391 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1302 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999418.9163 | 2108430.2253 | 37.7693133969257 | -122.445340943975 | (37.7693133969257, -122.445340943975) | 15 | 5 | 11 | 29492 | 9 | |||
| 150043 | 246390 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1267 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 0ft | 5999435.2691 | 2108467.7761 | 37.7694174354079 | -122.445287080875 | (37.7694174354079, -122.445287080875) | 15 | 5 | 11 | 29492 | 9 | |||
| 68367 | 14603 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1265 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 3X3 | 5999439.61797 | 2108531.98026 | 37.7695939720606 | -122.44527665521 | (37.7695939720606, -122.44527665521) | 15 | 5 | 11 | 29492 | 9 | |||
| 41386 | 121194 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 255x Red Rock Way | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 775289 | 5999917 | 2099808 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | 2 | 7 | 5 | 63 | 22 | |||
| 108248 | 96988 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2201 North Point St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.443579300178 | (37.8026268776405, -122.443579300178) | 13 | 9 | 1 | 57 | 17 | ||||
| 122439 | 96990 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2201 North Point St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.443579300178 | (37.8026268776405, -122.443579300178) | 13 | 9 | 1 | 57 | 17 | ||||
| 135345 | 96989 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2201 North Point St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.443579300178 | (37.8026268776405, -122.443579300178) | 13 | 9 | 1 | 57 | 17 | ||||
| 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 | ||
| 33819 | 38088 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000614.67901 | 2114079.17001 | 37.7848921510189 | -122.441610312074 | (37.7848921510189, -122.441610312074) | 15 | 6 | 11 | 29490 | 13 | ||
| 149752 | 38073 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000616.76201 | 2114062.24301 | 37.7848457925173 | -122.441601890436 | (37.7848457925173, -122.441601890436) | 15 | 6 | 11 | 29490 | 13 | ||
| 49379 | 38081 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000619.36701 | 2114044.53501 | 37.7847973193303 | -122.441591606798 | (37.7847973193303, -122.441591606798) | 15 | 6 | 11 | 29490 | 13 | ||
| 181292 | 38074 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000621.45001 | 2114020.83701 | 37.7847323694056 | -122.441582699114 | (37.7847323694056, -122.441582699114) | 15 | 6 | 11 | 29490 | 13 | ||
| 161249 | 38075 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000624.05401 | 2114007.81601 | 37.7846967654532 | -122.441572755427 | (37.7846967654532, -122.441572755427) | 15 | 6 | 11 | 29490 | 13 | ||
| 127672 | 38084 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000626.16659083 | 2114103.31583795 | 37.7849591037257 | -122.441572302214 | (37.7849591037257, -122.441572302214) | 15 | 6 | 11 | 29490 | 13 | ||
| 136957 | 38083 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000626.16659083 | 2114103.31583795 | 37.7849591037257 | -122.441572302214 | (37.7849591037257, -122.441572302214) | 15 | 6 | 11 | 29490 | 13 | ||
| 70486 | 38076 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000627.17901 | 2113992.97301 | 37.7846561884399 | -122.441560878475 | (37.7846561884399, -122.441560878475) | 15 | 6 | 11 | 29490 | 13 | ||
| 177223 | 38077 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000633.42901 | 2113935.94101 | 37.7844999493368 | -122.441535161579 | (37.7844999493368, -122.441535161579) | 15 | 6 | 11 | 29490 | 13 | ||
| 109355 | 38078 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000636.81501 | 2113914.58701 | 37.7844415096587 | -122.441521914323 | (37.7844415096587, -122.441521914323) | 15 | 6 | 11 | 29490 | 13 | ||
| 73346 | 38079 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000639.41901 | 2113899.22301 | 37.7843994724246 | -122.441511802515 | (37.7843994724246, -122.441511802515) | 15 | 6 | 11 | 29490 | 13 | ||
| 190764 | 38080 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000641.24201 | 2113883.59801 | 37.7843566740562 | -122.441504373964 | (37.7843566740562, -122.441504373964) | 15 | 6 | 11 | 29490 | 13 | ||
| 88322 | 38072 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000643.06501 | 2113866.93101 | 37.7843110146233 | -122.441496870623 | (37.7843110146233, -122.441496870623) | 15 | 6 | 11 | 29490 | 13 | ||
| 31600 | 38082 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000645.66901 | 2113851.82701 | 37.7842696912791 | -122.44148677751 | (37.7842696912791, -122.44148677751) | 15 | 6 | 11 | 29490 | 13 | ||
| 151337 | 36907 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 884 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40695 | 6000695.68812692 | 2102606.86536781 | 37.7533966824522 | -122.440506941015 | (37.7533966824522, -122.440506941015) | 2 | 4 | 5 | 28862 | 22 | ||
| 172638 | 126461 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1990 Beach St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6000743.63592 | 2120987.57838 | 37.8038681737437 | -122.441660117946 | (37.8038681737437, -122.441660117946) | 13 | 9 | 1 | 57 | 17 | |||
| 161625 | 126462 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1990 Beach St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000762.32542 | 2120990.48851 | 37.8038772290062 | -122.441595650935 | (37.8038772290062, -122.441595650935) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | ||||
| 32857 | 47691 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2858 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45490 | 6001036.99468682 | 2116264.16139907 | 37.7909156246348 | -122.440305990836 | (37.7909156246348, -122.440305990836) | 13 | 6 | 1 | 29490 | 27 | ||
| 180904 | 34527 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2856 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | 13 | 6 | 1 | 29490 | 27 | |||
| 189659 | 34528 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2856 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | 13 | 6 | 1 | 29490 | 27 | ||
| 39432 | 37587 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
| 62613 | 37588 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
| 65609 | 37589 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
| 79487 | 37590 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
| 59370 | 68249 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3531 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32050 | 6001184.87724579 | 2120700.92595518 | 37.8031062325164 | -122.440112611548 | (37.8031062325164, -122.440112611548) | 13 | 9 | 1 | 57 | 17 | ||
| 47019 | 39910 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | |||
| 77186 | 39908 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | |||
| 86961 | 39907 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | |||
| 89820 | 39905 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | |||
| 150087 | 39909 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2001 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | ||
| 49210 | 114656 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Post St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6001274.7016 | 2113900.9823 | 37.78444047533 | -122.439314075739 | (37.78444047533, -122.439314075739) | 15 | 6 | 11 | 29490 | 13 | |||
| 37916 | 233997 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1027 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001336.17311 | 2100800.0445 | 37.7484720346532 | -122.438162590655 | (37.7484720346532, -122.438162590655) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 |
| 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 | |||
| 64436 | 114654 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001378.1104 | 2113915.8269 | 37.7844871189173 | -122.438957381866 | (37.7844871189173, -122.438957381866) | 15 | 6 | 11 | 29490 | 13 | |||
| 49579 | 114652 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001448.056 | 2113923.3749 | 37.7845118231904 | -122.438715935573 | (37.7845118231904, -122.438715935573) | 15 | 6 | 11 | 29490 | 13 | |||
| 80984 | 36908 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 394 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39556 | 6001774.84404362 | 2103557.93464621 | 37.7560694803843 | -122.436843078117 | (37.7560694803843, -122.436843078117) | 2 | 4 | 5 | 28862 | 3 | ||
| 136510 | 34429 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 204 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38173 | 6002089.34387418 | 2096139.54747106 | 37.7357182050796 | -122.435224839434 | (37.7357182050796, -122.435224839434) | 2 | 7 | 5 | 63 | 7 | ||
| 131612 | 37420 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 679 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39898 | 6002152.44125634 | 2099703.71933952 | 37.7455081743626 | -122.435261547297 | (37.7455081743626, -122.435261547297) | 2 | 7 | 5 | 63 | 22 | ||
| 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 | ||
| 72751 | 37286 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 699 Castro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2002 12:00:00 AM | Permit Number 39818 | 6002432.10165251 | 2104152.77929012 | 37.757740114019 | -122.434612596377 | (37.757740114019, -122.434612596377) | 2 | 4 | 5 | 28862 | 3 | ||
| 29221 | 34402 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 160 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38149 | 6002458.41825324 | 2097080.12272084 | 37.7383217597979 | -122.434016021054 | (37.7383217597979, -122.434016021054) | 2 | 7 | 5 | 63 | 7 | ||
| 50923 | 34400 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 156 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38147 | 6002471.83146577 | 2097061.86671715 | 37.738272394243 | -122.433968340214 | (37.738272394243, -122.433968340214) | 2 | 7 | 5 | 63 | 7 | ||
| 63600 | 34404 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 171 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38152 | 6002491.04646095 | 2096956.56807226 | 37.7379843589135 | -122.433894379886 | (37.7379843589135, -122.433894379886) | 2 | 7 | 5 | 63 | 7 | ||
| 173663 | 37275 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3894 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39816 | 6002513.25180394 | 2102998.13185029 | 37.754574335137 | -122.434249400487 | (37.754574335137, -122.434249400487) | 2 | 4 | 5 | 28862 | 22 | |||
| 142598 | 35422 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 527 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38873 | 6002518.46166442 | 2099137.02773671 | 37.7439729506581 | -122.433955407599 | (37.7439729506581, -122.433955407599) | 2 | 7 | 5 | 63 | 22 | ||
| 125415 | 34401 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 157 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38148 | 6002541.2507672 | 2096900.64630627 | 37.7378336595187 | -122.433716803341 | (37.7378336595187, -122.433716803341) | 2 | 7 | 5 | 63 | 7 | ||
| 142202 | 34398 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2016 12:00:00 AM | 3 | Permit Number 38145 | 6002598.06465628 | 2096836.91119738 | 37.7376618812243 | -122.433515816831 | (37.7376618812243, -122.433515816831) | 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) );