Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1994 | 1994 | 42166 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 354 05th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011846.02554 | 2111882.36991 | 37.77949374398221 | -122.402598720465 | (37.7794937439822, -122.402598720465) | ||
| 2014 | 2014 | 42165 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 354 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011856.41574 | 2111871.95313 | 37.7794657219919 | -122.40256204342501 | (37.7794657219919, -122.402562043425) | ||
| 10100 | 10100 | 42164 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 360 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42459 | 6011853.6 | 2111898.2 | 37.779537632618705 | -122.40257363052 | (37.7795376326187, -122.40257363052) | |||
| 10158 | 10158 | 44811 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2700x Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | Permit Number 43905 | 5986360.0 | 2105036.0 | 37.7592396918496 | -122.490260766294 | (37.7592396918496, -122.490260766294) | ||
| 11666 | 11666 | 108844 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 420 Woolsey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010500.63404 | 2091864.14228 | 37.724452908148606 | -122.405842528314 | (37.7244529081486, -122.405842528314) | |
| 12766 | 12766 | 31651 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3530 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/02/2016 12:00:00 AM | 3 | Permit Number 778640 | 5981977.0239 | 2096750.5895 | 37.736233320022 | -122.50480501648701 | (37.736233320022, -122.504805016487) | |
| 17983 | 17983 | 35807 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.762580870322104 | -122.42044317973499 | (37.7625808703221, -122.420443179735) | ||
| 18393 | 18393 | 65663 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 35 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | Permit Number 28583 | 5998824.47448758 | 2095859.96140736 | 37.7347645844735 | -122.44649260756701 | (37.7347645844735, -122.446492607567) | ||
| 18895 | 18895 | 37776 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 449 Felton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | Permit Number 40114 | 6009618.93348363 | 2093468.47161568 | 37.72880870980371 | -122.409003606238 | (37.7288087098037, -122.409003606238) | ||
| 20395 | 20395 | 43502 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 401 Gates St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43180 | 6008272.42807324 | 2096955.00828501 | 37.73830646369329 | -122.413905114955 | (37.7383064636933, -122.413905114955) | ||
| 23397 | 23397 | 54440 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 512 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1972 12:00:00 AM | 25 | Permit Number 10217 | 6014062.04664 | 2104690.51395 | 37.7598699757444 | -122.39442879427601 | (37.7598699757444, -122.394428794276) | ||
| 23971 | 23971 | 78224 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 5 | 6009704.84764 | 2090538.9392099997 | 37.7207696402774 | -122.40850003035101 | (37.7207696402774, -122.408500030351) | ||
| 24165 | 24165 | 54475 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 80 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1972 12:00:00 AM | 10 | Permit Number 10267 | 6012323.1841 | 2095334.0847599998 | 37.73408241247979 | -122.399785717559 | (37.7340824124798, -122.399785717559) | ||
| 24354 | 24354 | 54553 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 12 | Permit Number 10348 | 6012791.48057 | 2095648.57895 | 37.7349720434069 | -122.39818871674801 | (37.7349720434069, -122.398188716748) | ||
| 24699 | 24699 | 54559 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 10 | Permit Number 10354 | 6012768.0788 | 2095448.27942 | 37.734420759018604 | -122.398255576836 | (37.7344207590186, -122.398255576836) | ||
| 24798 | 24798 | 45088 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1900 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 2 | Permit Number 43969 | 5988077.6041 | 2102404.3375 | 37.752114018434206 | -122.484127544226 | (37.7521140184342, -122.484127544226) | |
| 25188 | 25188 | 99927 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 665 Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6008996.47999 | 2092997.0616099997 | 37.727479429923896 | -122.411122192648 | (37.7274794299239, -122.411122192648) | ||||
| 25312 | 25312 | 69188 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2249 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1994 12:00:00 AM | 6 | Permit Number 33230 | 6010676.3293699995 | 2106439.96142 | 37.7644847703853 | -122.40626165736401 | (37.7644847703853, -122.406261657364) | ||
| 25790 | 25790 | 222210 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 286 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 6002911.44026 | 2096221.9598 | 37.735991140781294 | -122.43238841969601 | (37.7359911407813, -122.432388419696) | ||||
| 27024 | 27024 | 38346 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1862 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 3 | Permit Number 40413 | 5982280.7574 | 2102429.3074 | 37.7518433707941 | -122.50417542529499 | (37.7518433707941, -122.504175425295) | |
| 27617 | 27617 | 56389 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1338 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 14 | Permit Number 12542 | 6016160.8061 | 2092941.1028 | 37.727724951534704 | -122.38635095351299 | (37.7277249515347, -122.386350953513) | ||
| 27713 | 27713 | 61447 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1745 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1994 12:00:00 AM | 7 | Permit Number 33475 | 6004648.5784 | 2118760.76141 | 37.7979756196421 | -122.42798804503599 | (37.7979756196421, -122.427988045036) | ||
| 28106 | 28106 | 32369 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 858 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 6 | Permit Number 36919 | 6008860.83914 | 2119402.12264 | 37.799974043636205 | -122.413457749072 | (37.7999740436362, -122.413457749072) | ||
| 28126 | 28126 | 125863 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 150 Francisco St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010483.33133 | 2121337.12789 | 37.8053780572129 | -122.407979816633 | (37.8053780572129, -122.407979816633) | ||||
| 28306 | 28306 | 220804 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 286 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6002911.89345 | 2096223.73908 | 37.735996051974396 | -122.432386979878 | (37.7359960519744, -122.432386979878) | ||||
| 28761 | 28761 | 54544 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 154 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 11 | Permit Number 10339 | 6009702.32393 | 2095129.7793599998 | 37.7333749787789 | -122.40883247914302 | (37.7333749787789, -122.408832479143) | ||
| 28858 | 28858 | 54973 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 570 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1972 12:00:00 AM | 8 | Permit Number 10851 | 5993170.16242 | 2111603.62161 | 37.7776680101154 | -122.467185660412 | (37.7776680101154, -122.467185660412) | ||
| 29157 | 29157 | 175654 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5989491.89044 | 2089216.44658 | 37.7159856948481 | -122.478272601196 | (37.7159856948481, -122.478272601196) | ||||
| 29194 | 29194 | 188256 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6013789.26124 | 2089763.6189299999 | 37.7188686596462 | -122.39432710432301 | (37.7188686596462, -122.394327104323) | ||||
| 29473 | 29473 | 47215 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 106 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 6 | Permit Number 45166 | 6006633.4762699995 | 2094299.61445 | 37.7309231552671 | -122.419383490876 | (37.7309231552671, -122.419383490876) | |
| 29933 | 29933 | 188870 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300x De Haro St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012283.09076 | 2102020.40062 | 37.7524393767806 | -122.40039382202299 | (37.7524393767806, -122.400393822023) | ||||
| 30025 | 30025 | 73382 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 502 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/1993 12:00:00 AM | 6 | 6001158.1468 | 2110520.1446 | 37.7751509205215 | -122.439474878934 | (37.7751509205215, -122.439474878934) | ||
| 30264 | 30264 | 56315 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 234 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 12 | Permit Number 12449 | 5993086.94537 | 2113893.4273099997 | 37.78395039042879 | -122.467640101935 | (37.7839503904288, -122.467640101935) | ||
| 30631 | 30631 | 205755 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Terrace Dr | 36 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5993878.86602 | 2096471.7721400002 | 37.7361607421118 | -122.463635532375 | (37.7361607421118, -122.463635532375) | ||||
| 30881 | 30881 | 79593 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2407 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/2002 12:00:00 AM | 3 | 5988231.6107 | 2107115.9609 | 37.7650598247176 | -122.48394043153401 | (37.7650598247176, -122.483940431534) | ||
| 31126 | 31126 | 222212 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1012 Chenery St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6000957.79216 | 2096197.5485099999 | 37.7358131397705 | -122.439141199604 | (37.7358131397705, -122.439141199604) | ||||
| 31708 | 31708 | 64202 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 712 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1987 12:00:00 AM | 7 | Permit Number 24989 | 6007253.84118 | 2121612.31265 | 37.805952304912296 | -122.41917544799401 | (37.8059523049123, -122.419175447994) | ||
| 32737 | 32737 | 69323 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2130 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1994 12:00:00 AM | 8 | Permit Number 33406 | 6007673.53376 | 2119706.35756 | 37.8007426600105 | -122.417587861288 | (37.8007426600105, -122.417587861288) | ||
| 32882 | 32882 | 45667 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3201 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2001 12:00:00 AM | 5 | Permit Number 44363 | 5999332.42339 | 2119845.91977 | 37.8006529814106 | -122.44646150300801 | (37.8006529814106, -122.446461503008) | ||
| 33017 | 33017 | 218260 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400x Portola Dr | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5992795.95946 | 2097207.23373 | 37.738117677685 | -122.46743301504 | (37.738117677685, -122.46743301504) | ||||
| 33255 | 33255 | 66536 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 555 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 7 | Permit Number 32084 | 6008859.29808 | 2093449.63302 | 37.7287144005277 | -122.41162839584999 | (37.7287144005277, -122.41162839585) | |
| 33421 | 33421 | 54453 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1305 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1976 12:00:00 AM | 9 | Permit Number 16511 | 6013657.09709 | 2105679.3601599997 | 37.76256261160079 | -122.39589862014 | (37.7625626116008, -122.39589862014) | ||
| 33632 | 33632 | 60190 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1235 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1982 12:00:00 AM | 10 | Permit Number 19735 | 6008544.7327 | 2110936.08659 | 37.776710612043 | -122.413952375309 | (37.776710612043, -122.413952375309) | ||
| 34071 | 34071 | 222168 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4462 24th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6000211.71034 | 2101702.64407 | 37.7508863393349 | -122.442115731555 | (37.7508863393349, -122.442115731555) | ||||
| 34280 | 34280 | 188251 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6013763.34518 | 2089782.1261 | 37.718918036018295 | -122.394417981716 | (37.7189180360183, -122.394417981716) | ||||
| 34509 | 34509 | 32604 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1327 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 6 | Permit Number 37070 | 5985214.1986 | 2106157.4162 | 37.7622518049359 | -122.49430610263501 | (37.7622518049359, -122.494306102635) | |
| 34544 | 34544 | 54558 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 50 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 8 | Permit Number 10353 | 6012731.08144 | 2095469.9154299998 | 37.7344781060868 | -122.398385007285 | (37.7344781060868, -122.398385007285) | ||
| 35753 | 35753 | 42874 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2366 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 5 | Permit Number 42798 | 5986118.9683 | 2099141.5396 | 37.7430410269224 | -122.49066066829901 | (37.7430410269224, -122.490660668299) | |
| 35816 | 35816 | 204568 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 61 Burnside Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6001187.03477 | 2095752.3933599999 | 37.734603888841896 | -122.438316738047 | (37.7346038888419, -122.438316738047) | ||||
| 35948 | 35948 | 65961 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2567 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 8 | Permit Number 28983 | 5987671.3147 | 2097818.6015 | 37.7394991439696 | -122.485196095129 | (37.7394991439696, -122.485196095129) | ||
| 36235 | 36235 | 43548 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1857 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | 4 | Permit Number 43212 | 6000253.363 | 2111274.4996 | 37.777170653454796 | -122.442658894423 | (37.7771706534548, -122.442658894423) | |
| 36306 | 36306 | 56388 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1322 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 12 | Permit Number 12540 | 6016246.7386 | 2092876.1026 | 37.7275512300997 | -122.386049351457 | (37.7275512300997, -122.386049351457) | ||
| 36565 | 36565 | 62056 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1700 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/1985 12:00:00 AM | 8 | Permit Number 22136 | 6002013.39133 | 2121163.89045 | 37.8044245429292 | -122.437278691955 | (37.8044245429292, -122.437278691955) | ||
| 36632 | 36632 | 188878 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 800 Vermont St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6011299.1950199995 | 2104323.40019 | 37.7587079887048 | -122.403958366804 | (37.7587079887048, -122.403958366804) | ||||
| 36921 | 36921 | 175655 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5989994.06268 | 2089291.6225400001 | 37.7162212479866 | -122.476542364932 | (37.7162212479866, -122.476542364932) | ||||
| 37058 | 37058 | 204587 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 231 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 5998761.6398599995 | 2095307.9959099998 | 37.733245428730996 | -122.446670146634 | (37.733245428731, -122.446670146634) | ||||
| 37572 | 37572 | 56393 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1367 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 10 | Permit Number 12549 | 6015984.5344 | 2092993.9843 | 37.7278603948519 | -122.386964019791 | (37.7278603948519, -122.386964019791) | ||
| 38251 | 38251 | 121802 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1235 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 6008587.55783 | 2110975.0957299997 | 37.776820126979 | -122.41380699001199 | (37.776820126979, -122.413806990012) | ||||
| 38289 | 38289 | 44471 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 133 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 7 | Permit Number 43785 | 6006112.385480001 | 2093200.59482 | 37.7278761253611 | -122.42110698399799 | (37.7278761253611, -122.421106983998) | |
| 38351 | 38351 | 54970 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 542 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1972 12:00:00 AM | 9 | Permit Number 10848 | 5993164.55901 | 2111769.98644 | 37.778124479556205 | -122.467217143666 | (37.7781244795562, -122.467217143666) | ||
| 38440 | 38440 | 59111 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 662 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 9 | Permit Number 18415 | 5993195.14439 | 2110965.57109 | 37.7759175373362 | -122.467052839991 | (37.7759175373362, -122.467052839991) | ||
| 39602 | 39602 | 222182 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 521 27th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6003111.77565 | 2100072.30365 | 37.7465746530929 | -122.431970636045 | (37.7465746530929, -122.431970636045) | ||||
| 39640 | 39640 | 54998 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 534 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 10 | Permit Number 10876 | 5990962.96365 | 2111750.1463 | 37.7779426698765 | -122.474831732013 | (37.7779426698765, -122.474831732013) | ||
| 40433 | 40433 | 53729 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 125 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1972 12:00:00 AM | 12 | Permit Number 9408 | 6012570.8653 | 2095236.57105 | 37.7338284646029 | -122.39892255904199 | (37.7338284646029, -122.398922559042) | ||
| 41008 | 41008 | 72911 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1970 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | 5 | 6001491.2891 | 2115220.1537 | 37.7880749043224 | -122.438659315373 | (37.7880749043224, -122.438659315373) | ||
| 41049 | 41049 | 43165 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 243 Madison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 6 | Permit Number 42974 | 6005684.86708 | 2092551.5835900002 | 37.7260699728301 | -122.42253882881201 | (37.7260699728301, -122.422538828812) | |
| 41651 | 41651 | 47841 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4424 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 3 | Permit Number 45602 | 5981838.80851 | 2110330.1740900003 | 37.773510883288395 | -122.506289537608 | (37.7735108832884, -122.506289537608) | |
| 41791 | 41791 | 188253 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6013773.56946 | 2089775.5723 | 37.718900608948395 | -122.394382181502 | (37.7189006089484, -122.394382181502) | ||||
| 41822 | 41822 | 53952 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 162 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | 11 | Permit Number 9667 | 6009674.27519 | 2095120.19458 | 37.7333470898892 | -122.408928775863 | (37.7333470898892, -122.408928775863) | ||
| 41943 | 41943 | 218261 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400x Portola Dr | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5992797.06764 | 2097201.3875599997 | 37.738101689549296 | -122.467428758544 | (37.7381016895493, -122.467428758544) | ||||
| 42132 | 42132 | 55307 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2770 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2012 12:00:00 AM | 2 | Permit Number 769514 | 6005272.5834 | 2119510.27332 | 37.8000688708465 | -122.42588218711 | (37.8000688708465, -122.42588218711) | ||
| 42310 | 42310 | 42884 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2514 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 4 | Permit Number 42805 | 5985844.8171 | 2098079.769 | 37.7401096713575 | -122.49153045761899 | (37.7401096713575, -122.491530457619) | |
| 43038 | 43038 | 188885 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 861 Vermont St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6011299.70234 | 2104367.2853200003 | 37.7588285158534 | -122.40395970050501 | (37.7588285158534, -122.403959700505) | ||||
| 43059 | 43059 | 55089 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 518 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 7 | Permit Number 10986 | 5990960.72715 | 2111836.53902 | 37.778179750938 | -122.47484577629801 | (37.778179750938, -122.474845776298) | ||
| 43429 | 43429 | 31131 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 120 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34846 | 5997461.35333 | 2093947.48586 | 37.7294354301769 | -122.45106749418001 | (37.7294354301769, -122.45106749418) | |
| 43796 | 43796 | 54707 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1782 Quint St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1972 12:00:00 AM | 13 | Permit Number 10542 | 6012472.9912 | 2095604.6829900001 | 37.734833769058 | -122.39928677368299 | (37.734833769058, -122.399286773683) | ||
| 43840 | 43840 | 205789 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6000042.28864 | 2094391.12615 | 37.730800989568294 | -122.442176813508 | (37.7308009895683, -122.442176813508) | ||||
| 44034 | 44034 | 38344 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1858 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 2 | Permit Number 40411 | 5982279.7422 | 2102452.6585 | 37.7519074266581 | -122.504180665511 | (37.7519074266581, -122.504180665511) | |
| 44157 | 44157 | 55090 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 522 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 9 | Permit Number 10987 | 5990959.394619999 | 2111814.6197900004 | 37.778119489538604 | -122.47484878563 | (37.7781194895386, -122.47484878563) | ||
| 44174 | 44174 | 42994 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500 Yale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.723036105202205 | -122.415997529963 | (37.7230361052022, -122.415997529963) | ||
| 44701 | 44701 | 175656 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5990014.1272599995 | 2089314.5953099998 | 37.716285489253 | -122.476474690052 | (37.716285489253, -122.476474690052) | ||||
| 44731 | 44731 | 57620 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1315 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1976 12:00:00 AM | 7 | Permit Number 16513 | 6013619.85223 | 2105678.11132 | 37.7625571104404 | -122.396027350002 | (37.7625571104404, -122.396027350002) | ||
| 45005 | 45005 | 53510 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1326 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12541 | 6016208.73 | 2092903.6451 | 37.7276247527235 | -122.386182668022 | (37.7276247527235, -122.386182668022) | ||
| 45150 | 45150 | 188881 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 875 Vermont St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6011300.937609999 | 2104283.5706 | 37.7585987228662 | -122.40394953724899 | (37.7585987228662, -122.403949537249) | ||||
| 45611 | 45611 | 43621 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2095 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.49332687468599 | (37.7480118028434, -122.493326874686) | ||
| 45755 | 45755 | 34141 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2466 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1997 12:00:00 AM | 7 | Permit Number 37989 | 5986144.1807 | 2098458.7736 | 37.7411678068726 | -122.490523271138 | (37.7411678068726, -122.490523271138) | ||
| 46065 | 46065 | 205754 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Terrace Dr | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5993872.8693 | 2096472.5281599998 | 37.7361624724174 | -122.46365632018 | (37.7361624724174, -122.46365632018) | ||||
| 46550 | 46550 | 43782 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 125 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 4 | Permit Number 43412 | 5989265.293980001 | 2114516.2308400003 | 37.7854390383616 | -122.480907074228 | (37.7854390383616, -122.480907074228) | |
| 46613 | 46613 | 70168 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5129 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 6 | 5982718.93125 | 2111668.1719299997 | 37.7772364107813 | -122.50334420523399 | (37.7772364107813, -122.503344205234) | ||
| 46937 | 46937 | 31866 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 54 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 10 | Permit Number 35308 | 5994462.19495 | 2090280.44973 | 37.7191944696164 | -122.46117009494301 | (37.7191944696164, -122.461170094943) | ||
| 47034 | 47034 | 222183 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 524 27th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6003110.998819999 | 2100092.09369 | 37.74662894788 | -122.43197473514799 | (37.74662894788, -122.431974735148) | ||||
| 47601 | 47601 | 69335 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2812 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/1994 12:00:00 AM | 13 | Permit Number 33420 | 5999154.94286 | 2118460.96082 | 37.796840116743105 | -122.446975936805 | (37.7968401167431, -122.446975936805) | ||
| 47881 | 47881 | 78378 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 35 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 5 | 6001605.25452 | 2090913.7229900002 | 37.7213417817901 | -122.436524599656 | (37.7213417817901, -122.436524599656) | ||
| 48074 | 48074 | 69362 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3521 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33456 | 6002627.22111 | 2120704.3070900002 | 37.8031975232214 | -122.435121592481 | (37.8031975232214, -122.435121592481) | |
| 48184 | 48184 | 56386 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1310 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 13 | Permit Number 12538 | 6016291.3574 | 2092843.6025 | 37.727464460543 | -122.38589283803199 | (37.727464460543, -122.385892838032) | ||
| 48313 | 48313 | 188250 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6013748.16101 | 2089779.7890700002 | 37.7189107748964 | -122.39447030426099 | (37.7189107748964, -122.394470304261) | ||||
| 49689 | 49689 | 56181 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 788 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 8 | Permit Number 12289 | 5991026.9623 | 2110070.57762 | 37.77333474205479 | -122.47448773746599 | (37.7733347420548, -122.474487737466) | ||
| 50065 | 50065 | 47679 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 327 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 6 | Permit Number 45466 | 6013233.56276 | 2105528.8113599997 | 37.762125666091 | -122.397352923703 | (37.762125666091, -122.397352923703) | |
| 50258 | 50258 | 205681 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 134 Lomita Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5991402.87169 | 2104383.6674599997 | 37.7577417813829 | -122.472772688422 | (37.7577417813829, -122.472772688422) | ||||
| 50323 | 50323 | 55325 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1231 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 11 | Permit Number 11255 | 6011451.82111 | 2089071.0764400002 | 37.7168368689981 | -122.402358088854 | (37.7168368689981, -122.402358088854) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");