trees
221 rows where qSpecies_id = 153 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1177 | 50666 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 132 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | Permit Number 47245 | 5997808.46990271 | 2107170.46182714 | 37.7657623457378 | -122.450820527035 | (37.7657623457378, -122.450820527035) | 15 | 5 | 11 | 29492 | 9 | |||
7833 | 37175 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 681 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1998 12:00:00 AM | Permit Number 39748 | 6005894.17436162 | 2099270.44010947 | 37.7445302641925 | -122.422292422651 | (37.7445302641925, -122.422292422651) | 2 | 7 | 5 | 28859 | 2 | ||
8138 | 38246 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.415157113805 | (37.7684933273993, -122.415157113805) | 8 | 4 | 7 | 28853 | 19 | ||
15276 | 40430 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 242 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1999 12:00:00 AM | Permit Number 41525 | 6007877.26148184 | 2097485.40267829 | 37.7397406088372 | -122.415308947554 | (37.7397406088372, -122.415308947554) | 2 | 7 | 7 | 28859 | 2 | ||
21432 | 68712 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3850 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32625 | 6003279.54613576 | 2105963.01747728 | 37.7627586660544 | -122.431811035931 | (37.7627586660544, -122.431811035931) | 15 | 4 | 5 | 28862 | 3 | ||
22023 | 35972 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 323 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39130 | 6006883.86528874 | 2096321.14092587 | 37.7364879223661 | -122.418661155064 | (37.7364879223661, -122.418661155064) | 2 | 7 | 7 | 28859 | 2 | ||
25126 | 251400 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 101 Rhine St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 3ft | 5994375.43496 | 2086552.55756 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | 9 | 8 | 6 | 28861 | 25 | ||||
27482 | 35063 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1600 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38619 | 5993105.16308773 | 2104567.76843585 | 37.7583456711152 | -122.46689889533 | (37.7583456711152, -122.46689889533) | 1 | 8 | 4 | 56 | 12 | ||
30622 | 52212 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3667 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2005 12:00:00 AM | Permit Number 48396 | 6005350.78664261 | 2101935.57102078 | 37.7518174353483 | -122.424360871513 | (37.7518174353483, -122.424360871513) | 2 | 4 | 5 | 28859 | 19 | |||
35999 | 115859 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
36425 | 115854 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
37176 | 49776 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 110 Talbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | Permit Number 46562 | 6010272.64518115 | 2086887.71649918 | 37.7107759109747 | -122.406280195673 | (37.7107759109747, -122.406280195673) | 9 | 7 | 8 | 309 | 39 | ||
37785 | 37556 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 4528 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1998 12:00:00 AM | Permit Number 39995 | 6000974.70295267 | 2104668.04462068 | 37.7590720640705 | -122.439689810342 | (37.7590720640705, -122.439689810342) | 2 | 4 | 5 | 28862 | 3 | ||
40063 | 35160 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 335 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38691 | 6002701.11607915 | 2109682.95719093 | 37.7729399034438 | -122.434077550687 | (37.7729399034438, -122.434077550687) | 15 | 5 | 11 | 29492 | 9 | ||
42905 | 34015 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1570 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46940 | 5986558.24673304 | 2104566.10079282 | 37.7579610536344 | -122.48954058892 | (37.7579610536344, -122.48954058892) | 1 | 8 | 3 | 56 | 35 | ||
43668 | 38245 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.415157113805 | (37.7684933273993, -122.415157113805) | 8 | 4 | 7 | 28853 | 19 | ||
48281 | 52318 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 4354DOUGLASS 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2005 12:00:00 AM | Permit Number 48474 | 6000907.18250943 | 2103314.58552811 | 37.7553519514145 | -122.439826288335 | (37.7553519514145, -122.439826288335) | 2 | 4 | 5 | 28862 | 38 | ||
48796 | 32635 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
52973 | 47695 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1857 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45494 | 6004612.55463086 | 2097920.97092871 | 37.7407525536623 | -122.42662793082 | (37.7407525536623, -122.42662793082) | 2 | 7 | 5 | 63 | 7 | ||
61617 | 34575 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 295X Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38282 | 5999028.12405406 | 2115657.54379136 | 37.789135431233 | -122.447212892779 | (37.789135431233, -122.447212892779) | 13 | 6 | 1 | 54 | 31 | ||
64637 | 32631 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
65058 | 42464 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 673 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42606 | 5996989.53231216 | 2095248.10603498 | 37.7329795980092 | -122.452792452541 | (37.7329795980092, -122.452792452541) | 9 | 7 | 4 | 59 | 40 | ||
67222 | 32634 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
68232 | 33286 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1055@Clay Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2002 12:00:00 AM | 3x3 | Permit Number 44830 | 6009456.49724061 | 2116992.25574546 | 37.7933905675371 | -122.411226210566 | (37.7933905675371, -122.411226210566) | 3 | 1 | 10 | 28857 | 21 | |
68626 | 115858 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
70461 | 32632 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
73325 | 115865 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
74214 | 38807 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 202 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1998 12:00:00 AM | Permit Number 40646 | 6014649.4963121 | 2111590.96099347 | 37.7788497186051 | -122.392879852588 | (37.7788497186051, -122.392879852588) | 6 | 2 | 9 | 28856 | 34 | ||
74686 | 35150 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 220 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38682 | 6003657.87156781 | 2109198.47011365 | 37.7716638731645 | -122.430733439651 | (37.7716638731645, -122.430733439651) | 15 | 9 | 11 | 29492 | 10 | ||
76027 | 251368 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 270 06th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010822 | 2111616 | 37.7787051302825 | -122.406122506892 | (37.7787051302825, -122.406122506892) | 14 | 2 | 9 | 28853 | 34 | |||
77398 | 35064 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1600 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38619 | 5993105.16308773 | 2104567.76843585 | 37.7583456711152 | -122.46689889533 | (37.7583456711152, -122.46689889533) | 1 | 8 | 4 | 56 | 12 | ||
83759 | 115862 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
84625 | 35990 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 222 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | 3x3 | Permit Number 39141 | 6006789.6042559 | 2098298.49411338 | 37.7419119870032 | -122.419127271552 | (37.7419119870032, -122.419127271552) | 2 | 7 | 7 | 28859 | 2 | |
85048 | 52141 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 100 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/2005 12:00:00 AM | Permit Number 48322 | 6004079.74050315 | 2108375.213269 | 37.7694273021614 | -122.42921545709 | (37.7694273021614, -122.42921545709) | 7 | 9 | 5 | 28862 | 3 | ||
89567 | 40256 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3625 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/2006 12:00:00 AM | Permit Number 41416 | 6005635.54182208 | 2102533.13348143 | 37.7534742792296 | -122.42341862495 | (37.7534742792296, -122.42341862495) | 2 | 4 | 5 | 28859 | 19 | ||
98312 | 48741 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 964 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | Permit Number 46597 | 6009929.68094635 | 2103590.07459933 | 37.7566178319635 | -122.40864306235 | (37.7566178319635, -122.40864306235) | 2 | 4 | 7 | 28859 | 19 | ||
98498 | 37428 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1223 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39903 | 6003243.0646952 | 2101122.55260682 | 37.7494658330862 | -122.431591620497 | (37.7494658330862, -122.431591620497) | 2 | 4 | 5 | 28862 | 22 | ||
99443 | 115866 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
103019 | 35151 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 220 Laussat St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1998 12:00:00 AM | Permit Number 38682 | 6003657.87156781 | 2109198.47011365 | 37.7716638731645 | -122.430733439651 | (37.7716638731645, -122.430733439651) | 15 | 9 | 11 | 29492 | 10 | |||
113359 | 35156 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1076 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38687 | 6001413.36342647 | 2109408.19644929 | 37.7721123108282 | -122.43851234272 | (37.7721123108282, -122.43851234272) | 15 | 5 | 11 | 29492 | 9 | ||
114452 | 32633 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
116330 | 32630 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
121494 | 32636 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
122776 | 40255 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3625 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41416 | 6005635.54182208 | 2102533.13348143 | 37.7534742792296 | -122.42341862495 | (37.7534742792296, -122.42341862495) | 2 | 4 | 5 | 28859 | 19 | ||
123654 | 37019 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1057 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39631 | 6008654.53435588 | 2102395.73728972 | 37.753266951872 | -122.412968551923 | (37.753266951872, -122.412968551923) | 2 | 4 | 7 | 28859 | 19 | ||
123719 | 34580 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 295X Presidio Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2012 12:00:00 AM | Permit Number 769651 | 5999028.12405406 | 2115657.54379136 | 37.789135431233 | -122.447212892779 | (37.789135431233, -122.447212892779) | 13 | 6 | 1 | 54 | 31 | |||
129412 | 52258 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3667 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48424 | 6005350.78664261 | 2101935.57102078 | 37.7518174353483 | -122.424360871513 | (37.7518174353483, -122.424360871513) | 2 | 4 | 5 | 28859 | 19 | ||
132403 | 115855 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
132856 | 37018 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1057 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39631 | 6008654.53435588 | 2102395.73728972 | 37.753266951872 | -122.412968551923 | (37.753266951872, -122.412968551923) | 2 | 4 | 7 | 28859 | 19 | ||
140855 | 52257 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3667 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48424 | 6005350.78664261 | 2101935.57102078 | 37.7518174353483 | -122.424360871513 | (37.7518174353483, -122.424360871513) | 2 | 4 | 5 | 28859 | 19 | ||
146222 | 115860 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
147434 | 115861 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
148343 | 41704 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 70 Natick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42154 | 6003051.73866425 | 2095477.41967872 | 37.7339547580058 | -122.431850206764 | (37.7339547580058, -122.431850206764) | 2 | 7 | 5 | 63 | 7 | ||
151909 | 48945 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 819 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46132 | 6009934.90888897 | 2104445.04060173 | 37.7589656692148 | -122.408685294891 | (37.7589656692148, -122.408685294891) | 2 | 4 | 7 | 28859 | 19 | ||
156537 | 40720 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 36 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 770949 | 6009333.47018643 | 2097251.8201173 | 37.7391809774349 | -122.41025748835 | (37.7391809774349, -122.41025748835) | 10 | 7 | 7 | 28859 | 2 | ||
156809 | 34576 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 295X Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38282 | 5999028.12405406 | 2115657.54379136 | 37.789135431233 | -122.447212892779 | (37.789135431233, -122.447212892779) | 13 | 6 | 1 | 54 | 31 | ||
158200 | 38808 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 202 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1998 12:00:00 AM | Permit Number 40646 | 6014649.4963121 | 2111590.96099347 | 37.7788497186051 | -122.392879852588 | (37.7788497186051, -122.392879852588) | 6 | 2 | 9 | 28856 | 34 | ||
162996 | 115863 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
166216 | 52213 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3667 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2005 12:00:00 AM | Permit Number 48396 | 6005350.78664261 | 2101935.57102078 | 37.7518174353483 | -122.424360871513 | (37.7518174353483, -122.424360871513) | 2 | 4 | 5 | 28859 | 19 | |||
170623 | 36005 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 315 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39154 | 6008606.55118779 | 2100215.49511804 | 37.7472778014217 | -122.412980345984 | (37.7472778014217, -122.412980345984) | 2 | 7 | 7 | 28859 | 2 | ||
172840 | 45193 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 134 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2001 12:00:00 AM | Permit Number 44037 | 5997793.88507772 | 2107168.4294301 | 37.7657559303797 | -122.45087082602 | (37.7657559303797, -122.45087082602) | 15 | 5 | 11 | 29492 | 9 | ||
173545 | 115867 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
173777 | 34577 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 295X Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38282 | 5999028.12405406 | 2115657.54379136 | 37.789135431233 | -122.447212892779 | (37.789135431233, -122.447212892779) | 13 | 6 | 1 | 54 | 31 | ||
176766 | 115856 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
176813 | 37586 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 2775 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40017 | 6001162.31345404 | 2105517.18376133 | 37.7614142693336 | -122.439101823773 | (37.7614142693336, -122.439101823773) | 15 | 4 | 5 | 28862 | 3 | ||
179557 | 115853 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 401x KANSAS ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011620 | 2106285 | 37.7641120222234 | -122.402986839965 | (37.7641120222234, -122.402986839965) | 8 | 3 | 8 | 28856 | 29 | |||||
179749 | 115864 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
179881 | 42255 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 449 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42499 | 6011032.58907867 | 2112142.29283942 | 37.7801619842664 | -122.405431068184 | (37.7801619842664, -122.405431068184) | 14 | 2 | 9 | 28853 | 34 | ||
182600 | 38809 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 202 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1998 12:00:00 AM | Permit Number 40646 | 6014649.4963121 | 2111590.96099347 | 37.7788497186051 | -122.392879852588 | (37.7788497186051, -122.392879852588) | 6 | 2 | 9 | 28856 | 34 | ||
182616 | 52299 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 46221st ST. Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2005 12:00:00 AM | Permit Number 48460 | 6001157.72665298 | 2103563.59755974 | 37.7560499364738 | -122.438977677821 | (37.7560499364738, -122.438977677821) | 2 | 4 | 5 | 28862 | 38 | ||
182640 | 41705 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42154 | 6003051.73866425 | 2095477.41967872 | 37.7339547580058 | -122.431850206764 | (37.7339547580058, -122.431850206764) | 2 | 7 | 5 | 63 | 7 | ||
182973 | 32637 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 778 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37083 | 6011766.14443501 | 2109713.24584796 | 37.7735333687871 | -122.402722477064 | (37.7735333687871, -122.402722477064) | 14 | 2 | 9 | 28853 | 34 | ||
183195 | 50085 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 169 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46817 | 5992373.11163098 | 2098031.46456186 | 37.7403563861764 | -122.468954963559 | (37.7403563861764, -122.468954963559) | 1 | 8 | 4 | 59 | 40 | ||
183417 | 46864 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 96 Athens St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44930 | 6004995.61677719 | 2092705.22653245 | 37.726452934298 | -122.424932453632 | (37.726452934298, -122.424932453632) | 9 | 7 | 6 | 28861 | 5 | ||
185514 | 34617 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3299 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38300 | 5999016.0246967 | 2115927.38259794 | 37.7898756461349 | -122.44727418368 | (37.7898756461349, -122.44727418368) | 13 | 6 | 1 | 29490 | 31 | ||
187222 | 115857 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
189272 | 173806 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 950 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007805.70004 | 2120292.05671 | 37.8023582786402 | -122.417172035787 | (37.8023582786402, -122.417172035787) | 5 | 1 | 1 | 308 | 32 | ||||
55650 | 222871 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 51 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6005724.8358 | 2097421.61611 | 37.7394442577386 | -122.422746599186 | (37.7394442577386, -122.422746599186) | 2 | 7 | 7 | 28859 | 2 | |||
65403 | 116770 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 307 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x6 | 6013506.88243 | 2105617.60092 | 37.7623846762351 | -122.396413832751 | (37.7623846762351, -122.396413832751) | 10 | 3 | 8 | 28856 | 29 | |||
88680 | 59247 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 900 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | 10 | Permit Number 24729 | 6008002.90133 | 2120325.62134 | 37.8024615306389 | -122.416491999617 | (37.8024615306389, -122.416491999617) | 5 | 1 | 1 | 308 | 32 | |
92393 | 222882 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1857 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004605.27602 | 2097916.14759 | 37.7407388983737 | -122.426652754132 | (37.7407388983737, -122.426652754132) | 2 | 7 | 5 | 63 | 7 | |||
124409 | 125959 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 900 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007983.53221 | 2120324.66338 | 37.802457811042 | -122.416558958654 | (37.802457811042, -122.416558958654) | 5 | 1 | 1 | 308 | 32 | |||
126312 | 125956 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1047 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009450.24252 | 2117026.36812 | 37.7934838810207 | -122.411250263289 | (37.7934838810207, -122.411250263289) | 3 | 1 | 10 | 28857 | 21 | |||
129831 | 106940 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 1607 WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5997889 | 2108175 | 37.7685251613651 | -122.450614421545 | (37.7685251613651, -122.450614421545) | 15 | 5 | 11 | 29492 | 9 | ||||
175081 | 188464 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011863.90983 | 2109727.01208 | 37.7735766257899 | -122.402385258275 | (37.7735766257899, -122.402385258275) | 14 | 2 | 9 | 28853 | 34 | |||
183706 | 59249 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 948 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1980 12:00:00 AM | 10 | Permit Number 18581 | 6007857.82328 | 2120305.56138 | 37.80239829122 | -122.416992620734 | (37.80239829122, -122.416992620734) | 5 | 1 | 1 | 308 | 32 | ||
193714 | 247476 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 856 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002462.8226 | 2109547.3008 | 37.7725538978004 | -122.434892132162 | (37.7725538978004, -122.434892132162) | 15 | 5 | 11 | 29492 | 9 | |||
28981 | 32639 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 787 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 11 | Permit Number 37084 | 6011743.68261 | 2109609.56566 | 37.7732474325671 | -122.402792883183 | (37.7732474325671, -122.402792883183) | 14 | 2 | 9 | 28853 | 34 | |
31697 | 125961 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 900 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007947.13488 | 2120318.93587 | 37.802440037726 | -122.4166845058 | (37.802440037726, -122.4166845058) | 5 | 1 | 1 | 308 | 32 | |||
55123 | 175827 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1669 Geneva Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 8ft | 6003539.76747 | 2087618.63679 | 37.7124039361582 | -122.42960264824 | (37.7124039361582, -122.42960264824) | 9 | 7 | 6 | 28861 | 5 | |||
95478 | 37963 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 655 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 11 | Permit Number 40194 | 6014150.19564 | 2104114.25281 | 37.7582925873621 | -122.39408358501 | (37.7582925873621, -122.39408358501) | 10 | 3 | 8 | 28856 | 29 | |
97583 | 205980 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 121 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995564.77238 | 2087377.85645 | 37.7112880204943 | -122.457149074963 | (37.7112880204943, -122.457149074963) | 9 | 8 | 6 | 28861 | 24 | |||
104503 | 222865 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3625 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005579.30004 | 2102535.69949 | 37.7534781504092 | -122.423613303727 | (37.7534781504092, -122.423613303727) | 2 | 4 | 5 | 28859 | 19 | |||
127193 | 205979 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 44 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993573.64628 | 2099229.5165 | 37.7437152253671 | -122.464891008423 | (37.7437152253671, -122.464891008423) | 1 | 8 | 4 | 29491 | 40 | |||
140768 | 125958 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 941 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007838.51696 | 2120251.34871 | 37.8022483508428 | -122.417055586769 | (37.8022483508428, -122.417055586769) | 5 | 1 | 10 | 308 | 32 | |||
171444 | 59252 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 961 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1980 12:00:00 AM | 11 | Permit Number 18584 | 6007751.14837 | 2120241.22842 | 37.8022156478981 | -122.417357207676 | (37.8022156478981, -122.417357207676) | 5 | 1 | 10 | 308 | 32 | ||
180116 | 125952 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 2294 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001994.86126 | 2118787.45338 | 37.7978984191288 | -122.437172562074 | (37.7978984191288, -122.437172562074) | 13 | 9 | 1 | 57 | 17 | |||
187258 | 222864 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1057 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008644.3268 | 2102383.5696 | 37.7532329691398 | -122.413002991602 | (37.7532329691398, -122.413002991602) | 2 | 4 | 7 | 28859 | 19 | |||
5393 | 28504 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 270 06th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010824.2979387 | 2111653.7211901 | 37.7788088323978 | -122.406117215604 | (37.7788088323978, -122.406117215604) | 14 | 2 | 9 | 28853 | 34 | |||
6934 | 125964 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 954 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007746.87512 | 2120288.68768 | 37.8023457186479 | -122.4173753605 | (37.8023457186479, -122.4173753605) | 5 | 1 | 1 | 308 | 32 |
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) );